{"id":18548,"date":"2019-06-25T16:26:12","date_gmt":"2019-06-25T19:26:12","guid":{"rendered":"https:\/\/orabr.com\/?p=18548"},"modified":"2019-06-25T16:28:33","modified_gmt":"2019-06-25T19:28:33","slug":"oracle-r12-exportar-e-importar-atributos-do-quality-qa_results","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=18548","title":{"rendered":"ORACLE R12 EXPORTAR E IMPORTAR ATRIBUTOS DO QUALITY QA_RESULTS"},"content":{"rendered":"\n
BEGIN\n  \nCREATE TABLE XONT_QA_RESULTS AS SELECT * FROM QA_RESULTS;\n\nCURSOR get_details IS\nSELECT ROWID\n      ,column1\n      ,column2\n      ,column3\n      ,column4\n      ,column5\n      ,column6\n      ,column7\n      ,column8\n      ,column9\n      ,column10\n      ,column11\n      ,column12\n  FROM XONT_QA_RESULTS\n WHERE NVL(process_flag, 'N') = 'N'\n ORDER BY page_seq\n         ,main_seq\n         ,item_in_grp_Seq;\n\nl_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');\nl_plan_id QA_PLANS_V.plan_id%TYPE;\nln_request_id NUMBER;\nl_collection_id NUMBER;\nl_return BOOLEAN;\nl_phase VARCHAR2(100);\nl_status VARCHAR2(100);\nl_return_status VARCHAR2(100);\nl_dev_phase VARCHAR2(100);\nl_dev_status VARCHAR2(100);\nl_message VARCHAR2(100);\n\nBEGIN\nSELECT QA_COLLECTION_ID_S.NEXTVAL\nINTO l_collection_id\nFROM DUAL;\n\nSELECT plan_id\nINTO l_plan_id\nFROM QA_PLANS_V\nWHERE name = 'PLAN NAME1';\n\nBEGIN\nUPDATE XONT_QA_RESULTS\nSET process_flag = 'D' -- Unprocessed Status where Attachment has not been uploaded\nWHERE process_flag = 'P';\nEXCEPTION\nWHEN NO_DATA_FOUND THEN\nFND_FILE.PUT_LINE(FND_FILE.LOG, 'No existing \"Processed\" Data to be updated as D')\nEND;\n\nFOR get_dtls IN get_details\n\nLOOP\nINSERT INTO qa_results_interface\ntransaction_interface_id\n,organization_code\n,plan_name\n,process_status\n,insert_type\n,plan_id\n,collection_id\n,last_update_date\n,last_updated_by\n,qa_last_updated_by\n,transaction_date\n,character1\n,character2\n,character3\n,character4\n,character5\n,character6\n,character7\n,character8\n,character9\n,character10\n,character11\n,character12\n)\nVALUES (\nQA_RESULTS_UPDATE_HISTORY_S.nextval,\n'OR1'\n,'PLAN NAME1'\n,1 -- process_status\n,1 -- For Update\n,l_plan_id--\n,l_collection_id\n,SYSDATE\n,l_user_id\n,l_user_id\n,SYSDATE\n, get_dtls.column1\n, get_dtls.column2\n, get_dtls.column3\n, get_dtls.column4\n,get_dtls.column5\n,get_dtls.column6\n,get_dtls.column7\n,get_dtls.column8\n,get_dtls.column9\n,get_dtls.column10\n,get_dtls.column11\n,get_dtls.column12\n);\n\nUPDATE Xont_qa_results\nSET process_flag = 'P'\nWHERE column12 = get_dtls.COLUMN12\nAND process_Flag = 'N';\nEND LOOP;\n\nCOMMIT;\n\nln_request_id :=\nfnd_request.submit_request ('QA', -- application\n'QLTTRAMB', -- program short name\n'', -- description\n'', -- start time\nFALSE, -- sub request\n'200',\n'1',\nl_user_id,\n2, CHR (0));\nCOMMIT;\n\nIF ln_request_id = 0\nTHEN\nfnd_file.put_line(fnd_file.log,'failed in concurrent request submission');\n\nELSE\nfnd_file.put_line(fnd_file.log, 'Submitted request for Import.');\n\nEND IF;\nfnd_file.put_line(fnd_file.log, 'Completed process');\n\nEND;<\/pre>\n\u00a0<\/p>\n<\/HTML><\/HTML>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-18548","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18548"}],"version-history":[{"count":3,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18548\/revisions"}],"predecessor-version":[{"id":18551,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18548\/revisions\/18551"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}