APPS.OKC_XPRT_IMPORT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

SELECT 'X'
FROM cz_rules
WHERE rule_type = 200 -- Statement rule
--AND devl_project_id = p_devl_project_id
AND rule_id = persistent_rule_id
AND SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) = p_rule_id
AND deleted_flag = 0;

Line: 105

SELECT SUBSTR(req_data,
                      1,
                      INSTR(req_data,':',1) -1
                    )  child_req_id,
       SUBSTR(req_data,
                      INSTR(req_data,':',1) + 1
                    ) run_id
FROM dual;

Line: 115

SELECT COUNT(*)
  FROM cz_imp_rules
 WHERE run_id = G_RUN_ID;

Line: 121

SELECT rule_id
  FROM okc_xprt_rule_hdrs_all
 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

Line: 150

	        Step 1: Update current request Id for all rules to be published
	    */

         fnd_file.put_line(FND_FILE.LOG,'  ');

Line: 160

           UPDATE okc_xprt_rule_hdrs_all
              SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
		        program_id = FND_GLOBAL.CONC_PROGRAM_ID,
			   program_application_id = FND_GLOBAL.PROG_APPL_ID,
			   program_update_date = SYSDATE,
			   last_update_login = FND_GLOBAL.LOGIN_ID,
			   last_update_date = SYSDATE,
			   last_updated_by = FND_GLOBAL.USER_ID
            WHERE org_id = p_org_id
		    AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
		                                  intent,
								    fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
						    )
              AND status_code = 'PENDINGPUB';

Line: 238

				UPDATE okc_xprt_rule_hdrs_all
				   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
				 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
				   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 289

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 304

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 348

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 363

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 402

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 417

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 459

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 474

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 528

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 543

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 566

		      Step 6: Insert Extension Rules
		   */

            fnd_file.put_line(FND_FILE.LOG,'  ');

Line: 571

            fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');

Line: 586

            fnd_file.put_line(FND_FILE.LOG,'Step 6: After Calling API to insert extension rule records');

Line: 629

		     		 	UPDATE okc_xprt_rule_hdrs_all
		     		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		     		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		     		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 698

	       		 	UPDATE okc_xprt_rule_hdrs_all
	       		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
	       		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
	       		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 741

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 756

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 796

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 811

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 851

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 866

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_pub_rule_rec.rule_id;

Line: 979

SELECT SUBSTR(req_data,
                      1,
                      INSTR(req_data,':',1) -1
                    )  child_req_id,
       SUBSTR(req_data,
                      INSTR(req_data,':',1) + 1
                    ) run_id
FROM dual;

Line: 989

SELECT COUNT(*)
  FROM cz_imp_rules
 WHERE run_id = G_RUN_ID;

Line: 995

SELECT rule_id
  FROM okc_xprt_rule_hdrs_all
 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

Line: 1024

	        Step 1: Update current request Id for all rules to be published
	    */

         fnd_file.put_line(FND_FILE.LOG,'  ');

Line: 1034

           UPDATE okc_xprt_rule_hdrs_all
              SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
		        program_id = FND_GLOBAL.CONC_PROGRAM_ID,
			   program_application_id = FND_GLOBAL.PROG_APPL_ID,
			   program_update_date = SYSDATE,
			   last_update_login = FND_GLOBAL.LOGIN_ID,
			   last_update_date = SYSDATE,
			   last_updated_by = FND_GLOBAL.USER_ID
            WHERE org_id = p_org_id
		    AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
		                                  intent,
								    fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
						    )
              AND status_code = 'PENDINGDISABLE';

Line: 1093

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1108

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1150

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1165

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1218

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1233

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1290

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1357

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1399

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1414

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1454

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1469

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1510

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1525

		 	UPDATE okc_xprt_rule_hdrs_all
		 	   SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
		 	 WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
		 	   AND rule_id = csr_dis_rule_rec.rule_id;

Line: 1624

SELECT 'x'
  FROM okc_terms_templates_all t
 WHERE  t.org_id = p_org_id
   AND  t.intent = p_intent
   AND  t.template_id = NVL(p_template_id, template_id);

Line: 1631

SELECT COUNT(*)
  FROM okc_xprt_rule_hdrs_all
 WHERE org_id = p_org_id
   AND intent = p_intent
   AND status_code = 'ACTIVE';

Line: 1887

SELECT SUBSTR(req_data,
                      1,
                      INSTR(req_data,':',1) -1
                    )  child_req_id,
       SUBSTR(req_data,
                      INSTR(req_data,':',1) + 1
                    ) run_id
FROM dual;

Line: 1897

SELECT COUNT(*)
  FROM cz_imp_rules
 WHERE run_id = G_RUN_ID;

Line: 2078

		      Step 2.2: Insert Extension Rules in Template Approval Flow
		   */

            fnd_file.put_line(FND_FILE.LOG,'  ');

Line: 2083

            fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');

Line: 2099

            fnd_file.put_line(FND_FILE.LOG,'Step 2.2: After Calling API to insert extension rule records');