eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_IMPORT_PVT dependencies on CZ_IMP_RULES

Line 114: CURSOR csr_cz_imp_rules_cnt IS

110: INSTR(req_data,':',1) + 1
111: ) run_id
112: FROM dual;
113:
114: CURSOR csr_cz_imp_rules_cnt IS
115: SELECT COUNT(*)
116: FROM cz_imp_rules
117: WHERE run_id = G_RUN_ID;
118:

Line 116: FROM cz_imp_rules

112: FROM dual;
113:
114: CURSOR csr_cz_imp_rules_cnt IS
115: SELECT COUNT(*)
116: FROM cz_imp_rules
117: WHERE run_id = G_RUN_ID;
118:
119: -- Added for 4103931
120: CURSOR csr_pub_rule_list IS

Line 430: Step 5: Populate cz_imp_rules

426: END IF;
427:
428:
429: /*
430: Step 5: Populate cz_imp_rules
431: */
432:
433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');

431: */
432:
433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
436: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
437: fnd_file.put_line(FND_FILE.LOG,' ');
438:
439: OKC_XPRT_IMPORT_RULES_PVT.import_rules_publish

Line 448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

444: x_msg_count => x_msg_count
445: );
446:
447: fnd_file.put_line(FND_FILE.LOG,' ');
448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
451: fnd_file.put_line(FND_FILE.LOG,' ');
452:

Line 487: Check if there are any records in cz_imp_rules

483: END IF;
484:
485: /*
486: Step 5.1: Count Rules to be imported
487: Check if there are any records in cz_imp_rules
488: If there are no records in cz_imp_rules then there were no expert enabled templates
489: attached to the rule. Just change the status of the rule to ACTIVE
490: */
491:

Line 488: If there are no records in cz_imp_rules then there were no expert enabled templates

484:
485: /*
486: Step 5.1: Count Rules to be imported
487: Check if there are any records in cz_imp_rules
488: If there are no records in cz_imp_rules then there were no expert enabled templates
489: attached to the rule. Just change the status of the rule to ACTIVE
490: */
491:
492: fnd_file.put_line(FND_FILE.LOG,' ');

Line 498: OPEN csr_cz_imp_rules_cnt;

494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');
497:
498: OPEN csr_cz_imp_rules_cnt;
499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
500: CLOSE csr_cz_imp_rules_cnt;
501:
502: fnd_file.put_line(FND_FILE.LOG,' ');

Line 499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');
497:
498: OPEN csr_cz_imp_rules_cnt;
499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
500: CLOSE csr_cz_imp_rules_cnt;
501:
502: fnd_file.put_line(FND_FILE.LOG,' ');
503: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

Line 500: CLOSE csr_cz_imp_rules_cnt;

496: fnd_file.put_line(FND_FILE.LOG,' ');
497:
498: OPEN csr_cz_imp_rules_cnt;
499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
500: CLOSE csr_cz_imp_rules_cnt;
501:
502: fnd_file.put_line(FND_FILE.LOG,' ');
503: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
504: fnd_file.put_line(FND_FILE.LOG,' ');

Line 988: CURSOR csr_cz_imp_rules_cnt IS

984: INSTR(req_data,':',1) + 1
985: ) run_id
986: FROM dual;
987:
988: CURSOR csr_cz_imp_rules_cnt IS
989: SELECT COUNT(*)
990: FROM cz_imp_rules
991: WHERE run_id = G_RUN_ID;
992:

Line 990: FROM cz_imp_rules

986: FROM dual;
987:
988: CURSOR csr_cz_imp_rules_cnt IS
989: SELECT COUNT(*)
990: FROM cz_imp_rules
991: WHERE run_id = G_RUN_ID;
992:
993: -- Added for 4757731
994: CURSOR csr_dis_rule_list IS

Line 1121: Step 3: Populate cz_imp_rules

1117: END IF;
1118:
1119:
1120: /*
1121: Step 3: Populate cz_imp_rules
1122: */
1123:
1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');

1122: */
1123:
1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1127: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1128: fnd_file.put_line(FND_FILE.LOG,' ');
1129:
1130: OKC_XPRT_IMPORT_RULES_PVT.import_rules_disable

Line 1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

1135: x_msg_count => x_msg_count
1136: );
1137:
1138: fnd_file.put_line(FND_FILE.LOG,' ');
1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1142: fnd_file.put_line(FND_FILE.LOG,' ');
1143:

Line 1177: Check if there are any records in cz_imp_rules

1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: /*
1176: Step 3.1: Count Rules to be imported
1177: Check if there are any records in cz_imp_rules
1178: If there are no records in cz_imp_rules then there were no expert enabled templates
1179: attached to the rule. Just change the status of the rule to INACTIVE
1180: */
1181:

Line 1178: If there are no records in cz_imp_rules then there were no expert enabled templates

1174: END IF;
1175: /*
1176: Step 3.1: Count Rules to be imported
1177: Check if there are any records in cz_imp_rules
1178: If there are no records in cz_imp_rules then there were no expert enabled templates
1179: attached to the rule. Just change the status of the rule to INACTIVE
1180: */
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1188: OPEN csr_cz_imp_rules_cnt;

1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:
1188: OPEN csr_cz_imp_rules_cnt;
1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1190: CLOSE csr_cz_imp_rules_cnt;
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:
1188: OPEN csr_cz_imp_rules_cnt;
1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1190: CLOSE csr_cz_imp_rules_cnt;
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

Line 1190: CLOSE csr_cz_imp_rules_cnt;

1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:
1188: OPEN csr_cz_imp_rules_cnt;
1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1190: CLOSE csr_cz_imp_rules_cnt;
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
1194: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1896: CURSOR csr_cz_imp_rules_cnt IS

1892: INSTR(req_data,':',1) + 1
1893: ) run_id
1894: FROM dual;
1895:
1896: CURSOR csr_cz_imp_rules_cnt IS
1897: SELECT COUNT(*)
1898: FROM cz_imp_rules
1899: WHERE run_id = G_RUN_ID;
1900:

Line 1898: FROM cz_imp_rules

1894: FROM dual;
1895:
1896: CURSOR csr_cz_imp_rules_cnt IS
1897: SELECT COUNT(*)
1898: FROM cz_imp_rules
1899: WHERE run_id = G_RUN_ID;
1900:
1901:
1902:

Line 2010: Step 2: Populate cz_imp_rules

2006: END IF;
2007:
2008:
2009: /*
2010: Step 2: Populate cz_imp_rules
2011: */
2012:
2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');

2011: */
2012:
2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2016: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2017: fnd_file.put_line(FND_FILE.LOG,' ');
2018:
2019: OKC_XPRT_IMPORT_RULES_PVT.import_rule_temp_approval

Line 2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

2025: x_msg_count => x_msg_count
2026: );
2027:
2028: fnd_file.put_line(FND_FILE.LOG,' ');
2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2033: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2045: Check if there are any records in cz_imp_rules

2041:
2042:
2043: /*
2044: Step 2.1: Count Rules to be imported
2045: Check if there are any records in cz_imp_rules
2046: If there are no records in cz_imp_rules then Template has no rules attached
2047: Skip the rule import process
2048: */
2049:

Line 2046: If there are no records in cz_imp_rules then Template has no rules attached

2042:
2043: /*
2044: Step 2.1: Count Rules to be imported
2045: Check if there are any records in cz_imp_rules
2046: If there are no records in cz_imp_rules then Template has no rules attached
2047: Skip the rule import process
2048: */
2049:
2050: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2056: OPEN csr_cz_imp_rules_cnt;

2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:
2056: OPEN csr_cz_imp_rules_cnt;
2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2058: CLOSE csr_cz_imp_rules_cnt;
2059:
2060: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:
2056: OPEN csr_cz_imp_rules_cnt;
2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2058: CLOSE csr_cz_imp_rules_cnt;
2059:
2060: fnd_file.put_line(FND_FILE.LOG,' ');
2061: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

Line 2058: CLOSE csr_cz_imp_rules_cnt;

2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:
2056: OPEN csr_cz_imp_rules_cnt;
2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2058: CLOSE csr_cz_imp_rules_cnt;
2059:
2060: fnd_file.put_line(FND_FILE.LOG,' ');
2061: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
2062: fnd_file.put_line(FND_FILE.LOG,' ');