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 OKC_XPRT_RULE_HDRS_ALL

Line 122: FROM okc_xprt_rule_hdrs_all

118:
119: -- Added for 4103931
120: CURSOR csr_pub_rule_list IS
121: SELECT rule_id
122: FROM okc_xprt_rule_hdrs_all
123: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
124:
125: l_rule_exists_flag VARCHAR2(1) := NULL;
126:

Line 160: UPDATE okc_xprt_rule_hdrs_all

156: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
157: fnd_file.put_line(FND_FILE.LOG,' ');
158:
159: -- Update request_id for all Rules in Pending Publication for current org id
160: UPDATE okc_xprt_rule_hdrs_all
161: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
162: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
163: program_application_id = FND_GLOBAL.PROG_APPL_ID,
164: program_update_date = SYSDATE,

Line 238: UPDATE okc_xprt_rule_hdrs_all

234: -- Added for Bug 4103931
235: FOR csr_pub_rule_rec IN csr_pub_rule_list
236: LOOP
237: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
238: UPDATE okc_xprt_rule_hdrs_all
239: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
240: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
241: AND rule_id = csr_pub_rule_rec.rule_id;
242: l_rule_exists_flag := 'F';

Line 289: UPDATE okc_xprt_rule_hdrs_all

285: -- Added for Bug 4757731
286: FOR csr_pub_rule_rec IN csr_pub_rule_list
287: LOOP
288: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
289: UPDATE okc_xprt_rule_hdrs_all
290: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
291: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
292: AND rule_id = csr_pub_rule_rec.rule_id;
293: l_rule_exists_flag := 'F';

Line 304: UPDATE okc_xprt_rule_hdrs_all

300: -- Added for Bug 4757731
301: FOR csr_pub_rule_rec IN csr_pub_rule_list
302: LOOP
303: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
304: UPDATE okc_xprt_rule_hdrs_all
305: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
306: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
307: AND rule_id = csr_pub_rule_rec.rule_id;
308: l_rule_exists_flag := 'F';

Line 348: UPDATE okc_xprt_rule_hdrs_all

344: -- Added for Bug 4757731
345: FOR csr_pub_rule_rec IN csr_pub_rule_list
346: LOOP
347: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
348: UPDATE okc_xprt_rule_hdrs_all
349: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
350: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
351: AND rule_id = csr_pub_rule_rec.rule_id;
352: l_rule_exists_flag := 'F';

Line 363: UPDATE okc_xprt_rule_hdrs_all

359: -- Added for Bug 4757731
360: FOR csr_pub_rule_rec IN csr_pub_rule_list
361: LOOP
362: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
363: UPDATE okc_xprt_rule_hdrs_all
364: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
365: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
366: AND rule_id = csr_pub_rule_rec.rule_id;
367: l_rule_exists_flag := 'F';

Line 402: UPDATE okc_xprt_rule_hdrs_all

398: -- Added for Bug 4757731
399: FOR csr_pub_rule_rec IN csr_pub_rule_list
400: LOOP
401: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
402: UPDATE okc_xprt_rule_hdrs_all
403: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
404: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
405: AND rule_id = csr_pub_rule_rec.rule_id;
406: l_rule_exists_flag := 'F';

Line 417: UPDATE okc_xprt_rule_hdrs_all

413: -- Added for Bug 4757731
414: FOR csr_pub_rule_rec IN csr_pub_rule_list
415: LOOP
416: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
417: UPDATE okc_xprt_rule_hdrs_all
418: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
419: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
420: AND rule_id = csr_pub_rule_rec.rule_id;
421: l_rule_exists_flag := 'F';

Line 459: UPDATE okc_xprt_rule_hdrs_all

455: -- Added for Bug 4757731
456: FOR csr_pub_rule_rec IN csr_pub_rule_list
457: LOOP
458: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
459: UPDATE okc_xprt_rule_hdrs_all
460: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
461: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
462: AND rule_id = csr_pub_rule_rec.rule_id;
463: l_rule_exists_flag := 'F';

Line 474: UPDATE okc_xprt_rule_hdrs_all

470: -- Added for Bug 4757731
471: FOR csr_pub_rule_rec IN csr_pub_rule_list
472: LOOP
473: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
474: UPDATE okc_xprt_rule_hdrs_all
475: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
476: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
477: AND rule_id = csr_pub_rule_rec.rule_id;
478: l_rule_exists_flag := 'F';

Line 528: UPDATE okc_xprt_rule_hdrs_all

524: -- Added for Bug 4757731
525: FOR csr_pub_rule_rec IN csr_pub_rule_list
526: LOOP
527: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
528: UPDATE okc_xprt_rule_hdrs_all
529: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
530: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
531: AND rule_id = csr_pub_rule_rec.rule_id;
532: l_rule_exists_flag := 'F';

Line 543: UPDATE okc_xprt_rule_hdrs_all

539: -- Added for Bug 4757731
540: FOR csr_pub_rule_rec IN csr_pub_rule_list
541: LOOP
542: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
543: UPDATE okc_xprt_rule_hdrs_all
544: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
545: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
546: AND rule_id = csr_pub_rule_rec.rule_id;
547: l_rule_exists_flag := 'F';

Line 629: UPDATE okc_xprt_rule_hdrs_all

625: -- Added for Bug 4757731
626: FOR csr_pub_rule_rec IN csr_pub_rule_list
627: LOOP
628: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
629: UPDATE okc_xprt_rule_hdrs_all
630: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
631: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
632: AND rule_id = csr_pub_rule_rec.rule_id;
633: l_rule_exists_flag := 'F';

Line 698: UPDATE okc_xprt_rule_hdrs_all

694: -- Added for Bug 4757731
695: FOR csr_pub_rule_rec IN csr_pub_rule_list
696: LOOP
697: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
698: UPDATE okc_xprt_rule_hdrs_all
699: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
700: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
701: AND rule_id = csr_pub_rule_rec.rule_id;
702: l_rule_exists_flag := 'F';

Line 741: UPDATE okc_xprt_rule_hdrs_all

737: -- Added for Bug 4757731
738: FOR csr_pub_rule_rec IN csr_pub_rule_list
739: LOOP
740: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
741: UPDATE okc_xprt_rule_hdrs_all
742: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
743: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
744: AND rule_id = csr_pub_rule_rec.rule_id;
745: l_rule_exists_flag := 'F';

Line 756: UPDATE okc_xprt_rule_hdrs_all

752: -- Added for Bug 4757731
753: FOR csr_pub_rule_rec IN csr_pub_rule_list
754: LOOP
755: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
756: UPDATE okc_xprt_rule_hdrs_all
757: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
758: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
759: AND rule_id = csr_pub_rule_rec.rule_id;
760: l_rule_exists_flag := 'F';

Line 796: UPDATE okc_xprt_rule_hdrs_all

792: -- Added for Bug 4757731
793: FOR csr_pub_rule_rec IN csr_pub_rule_list
794: LOOP
795: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
796: UPDATE okc_xprt_rule_hdrs_all
797: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
798: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
799: AND rule_id = csr_pub_rule_rec.rule_id;
800: l_rule_exists_flag := 'F';

Line 811: UPDATE okc_xprt_rule_hdrs_all

807: -- Added for Bug 4757731
808: FOR csr_pub_rule_rec IN csr_pub_rule_list
809: LOOP
810: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
811: UPDATE okc_xprt_rule_hdrs_all
812: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
813: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
814: AND rule_id = csr_pub_rule_rec.rule_id;
815: l_rule_exists_flag := 'F';

Line 851: UPDATE okc_xprt_rule_hdrs_all

847: -- Added for Bug 4757731
848: FOR csr_pub_rule_rec IN csr_pub_rule_list
849: LOOP
850: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
851: UPDATE okc_xprt_rule_hdrs_all
852: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
853: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
854: AND rule_id = csr_pub_rule_rec.rule_id;
855: l_rule_exists_flag := 'F';

Line 866: UPDATE okc_xprt_rule_hdrs_all

862: -- Added for Bug 4757731
863: FOR csr_pub_rule_rec IN csr_pub_rule_list
864: LOOP
865: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
866: UPDATE okc_xprt_rule_hdrs_all
867: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
868: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
869: AND rule_id = csr_pub_rule_rec.rule_id;
870: l_rule_exists_flag := 'F';

Line 996: FROM okc_xprt_rule_hdrs_all

992:
993: -- Added for 4757731
994: CURSOR csr_dis_rule_list IS
995: SELECT rule_id
996: FROM okc_xprt_rule_hdrs_all
997: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
998:
999: l_rule_exists_flag VARCHAR2(1) := NULL;
1000:

Line 1034: UPDATE okc_xprt_rule_hdrs_all

1030: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1031: fnd_file.put_line(FND_FILE.LOG,' ');
1032:
1033: -- Update request_id for all Rules in Pending Publication for current org id
1034: UPDATE okc_xprt_rule_hdrs_all
1035: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1036: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1037: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1038: program_update_date = SYSDATE,

Line 1093: UPDATE okc_xprt_rule_hdrs_all

1089: -- Added for Bug 4757731
1090: FOR csr_dis_rule_rec IN csr_dis_rule_list
1091: LOOP
1092: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1093: UPDATE okc_xprt_rule_hdrs_all
1094: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1095: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1096: AND rule_id = csr_dis_rule_rec.rule_id;
1097: l_rule_exists_flag := 'F';

Line 1108: UPDATE okc_xprt_rule_hdrs_all

1104: -- Added for Bug 4757731
1105: FOR csr_dis_rule_rec IN csr_dis_rule_list
1106: LOOP
1107: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1108: UPDATE okc_xprt_rule_hdrs_all
1109: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1110: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1111: AND rule_id = csr_dis_rule_rec.rule_id;
1112: l_rule_exists_flag := 'F';

Line 1150: UPDATE okc_xprt_rule_hdrs_all

1146: -- Added for Bug 4757731
1147: FOR csr_dis_rule_rec IN csr_dis_rule_list
1148: LOOP
1149: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1150: UPDATE okc_xprt_rule_hdrs_all
1151: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1152: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1153: AND rule_id = csr_dis_rule_rec.rule_id;
1154: l_rule_exists_flag := 'F';

Line 1165: UPDATE okc_xprt_rule_hdrs_all

1161: -- Added for Bug 4757731
1162: FOR csr_dis_rule_rec IN csr_dis_rule_list
1163: LOOP
1164: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1165: UPDATE okc_xprt_rule_hdrs_all
1166: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1167: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1168: AND rule_id = csr_dis_rule_rec.rule_id;
1169: l_rule_exists_flag := 'F';

Line 1218: UPDATE okc_xprt_rule_hdrs_all

1214: -- Added for Bug 4757731
1215: FOR csr_dis_rule_rec IN csr_dis_rule_list
1216: LOOP
1217: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1218: UPDATE okc_xprt_rule_hdrs_all
1219: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1220: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1221: AND rule_id = csr_dis_rule_rec.rule_id;
1222: l_rule_exists_flag := 'F';

Line 1233: UPDATE okc_xprt_rule_hdrs_all

1229: -- Added for Bug 4757731
1230: FOR csr_dis_rule_rec IN csr_dis_rule_list
1231: LOOP
1232: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1233: UPDATE okc_xprt_rule_hdrs_all
1234: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1235: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1236: AND rule_id = csr_dis_rule_rec.rule_id;
1237: l_rule_exists_flag := 'F';

Line 1290: UPDATE okc_xprt_rule_hdrs_all

1286: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
1287: FOR csr_dis_rule_rec IN csr_dis_rule_list
1288: LOOP
1289: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1290: UPDATE okc_xprt_rule_hdrs_all
1291: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1292: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1293: AND rule_id = csr_dis_rule_rec.rule_id;
1294: l_rule_exists_flag := 'F';

Line 1357: UPDATE okc_xprt_rule_hdrs_all

1353: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
1354: FOR csr_dis_rule_rec IN csr_dis_rule_list
1355: LOOP
1356: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1357: UPDATE okc_xprt_rule_hdrs_all
1358: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1359: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1360: AND rule_id = csr_dis_rule_rec.rule_id;
1361: l_rule_exists_flag := 'F';

Line 1399: UPDATE okc_xprt_rule_hdrs_all

1395: -- Added for Bug 4757731
1396: FOR csr_dis_rule_rec IN csr_dis_rule_list
1397: LOOP
1398: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1399: UPDATE okc_xprt_rule_hdrs_all
1400: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1401: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1402: AND rule_id = csr_dis_rule_rec.rule_id;
1403: l_rule_exists_flag := 'F';

Line 1414: UPDATE okc_xprt_rule_hdrs_all

1410: -- Added for Bug 4757731
1411: FOR csr_dis_rule_rec IN csr_dis_rule_list
1412: LOOP
1413: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1414: UPDATE okc_xprt_rule_hdrs_all
1415: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1416: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1417: AND rule_id = csr_dis_rule_rec.rule_id;
1418: l_rule_exists_flag := 'F';

Line 1454: UPDATE okc_xprt_rule_hdrs_all

1450: -- Added for Bug 4757731
1451: FOR csr_dis_rule_rec IN csr_dis_rule_list
1452: LOOP
1453: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1454: UPDATE okc_xprt_rule_hdrs_all
1455: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1456: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1457: AND rule_id = csr_dis_rule_rec.rule_id;
1458: l_rule_exists_flag := 'F';

Line 1469: UPDATE okc_xprt_rule_hdrs_all

1465: -- Added for Bug 4757731
1466: FOR csr_dis_rule_rec IN csr_dis_rule_list
1467: LOOP
1468: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1469: UPDATE okc_xprt_rule_hdrs_all
1470: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1471: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1472: AND rule_id = csr_dis_rule_rec.rule_id;
1473: l_rule_exists_flag := 'F';

Line 1510: UPDATE okc_xprt_rule_hdrs_all

1506: -- Added for Bug 4757731
1507: FOR csr_dis_rule_rec IN csr_dis_rule_list
1508: LOOP
1509: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1510: UPDATE okc_xprt_rule_hdrs_all
1511: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1512: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1513: AND rule_id = csr_dis_rule_rec.rule_id;
1514: l_rule_exists_flag := 'F';

Line 1525: UPDATE okc_xprt_rule_hdrs_all

1521: -- Added for Bug 4757731
1522: FOR csr_dis_rule_rec IN csr_dis_rule_list
1523: LOOP
1524: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1525: UPDATE okc_xprt_rule_hdrs_all
1526: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1527: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1528: AND rule_id = csr_dis_rule_rec.rule_id;
1529: l_rule_exists_flag := 'F';

Line 1632: FROM okc_xprt_rule_hdrs_all

1628: AND t.template_id = NVL(p_template_id, template_id);
1629:
1630: CURSOR csr_active_rules_cnt IS
1631: SELECT COUNT(*)
1632: FROM okc_xprt_rule_hdrs_all
1633: WHERE org_id = p_org_id
1634: AND intent = p_intent
1635: AND status_code = 'ACTIVE';
1636: