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 FND_GLOBAL

Line 123: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

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:
127: BEGIN

Line 145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

141: END IF;
142:
143: -- log file
144: fnd_file.put_line(FND_FILE.LOG,' ');
145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
146: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
147: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
148:
149: /*

Line 161: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

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,
165: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 162: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

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,
165: last_update_login = FND_GLOBAL.LOGIN_ID,
166: last_update_date = SYSDATE,

Line 163: program_application_id = FND_GLOBAL.PROG_APPL_ID,

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,
165: last_update_login = FND_GLOBAL.LOGIN_ID,
166: last_update_date = SYSDATE,
167: last_updated_by = FND_GLOBAL.USER_ID

Line 165: last_update_login = FND_GLOBAL.LOGIN_ID,

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,
165: last_update_login = FND_GLOBAL.LOGIN_ID,
166: last_update_date = SYSDATE,
167: last_updated_by = FND_GLOBAL.USER_ID
168: WHERE org_id = p_org_id
169: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

Line 167: last_updated_by = FND_GLOBAL.USER_ID

163: program_application_id = FND_GLOBAL.PROG_APPL_ID,
164: program_update_date = SYSDATE,
165: last_update_login = FND_GLOBAL.LOGIN_ID,
166: last_update_date = SYSDATE,
167: last_updated_by = FND_GLOBAL.USER_ID
168: WHERE org_id = p_org_id
169: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
170: intent,
171: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

Line 240: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
243: END LOOP;
244:

Line 291: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
294: END LOOP;
295: COMMIT;

Line 306: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
309: END LOOP;
310: COMMIT;

Line 350: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
353: END LOOP;
354: COMMIT;

Line 365: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
368: END LOOP;
369: COMMIT;

Line 404: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
407: END LOOP;
408: COMMIT;

Line 419: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
422: END LOOP;
423: COMMIT;

Line 461: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
464: END LOOP;
465: COMMIT;

Line 476: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
479: END LOOP;
480: COMMIT;

Line 530: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
533: END LOOP;
534: COMMIT;

Line 545: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
548: END LOOP;
549: COMMIT;

Line 631: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
634: END LOOP;
635: COMMIT;

Line 700: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
703: END LOOP;
704: COMMIT;

Line 743: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
746: END LOOP;
747: COMMIT;

Line 758: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
761: END LOOP;
762: COMMIT;

Line 798: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
801: END LOOP;
802: COMMIT;

Line 813: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
816: END LOOP;
817: COMMIT;

Line 853: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
856: END LOOP;
857: COMMIT;

Line 868: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
871: END LOOP;
872: COMMIT;

Line 997: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

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:
1001: BEGIN

Line 1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1015: END IF;
1016:
1017: -- log file
1018: fnd_file.put_line(FND_FILE.LOG,' ');
1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1020: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1021: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1022:
1023: /*

Line 1035: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

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,
1039: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1036: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

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,
1039: last_update_login = FND_GLOBAL.LOGIN_ID,
1040: last_update_date = SYSDATE,

Line 1037: program_application_id = FND_GLOBAL.PROG_APPL_ID,

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,
1039: last_update_login = FND_GLOBAL.LOGIN_ID,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID

Line 1039: last_update_login = FND_GLOBAL.LOGIN_ID,

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,
1039: last_update_login = FND_GLOBAL.LOGIN_ID,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID
1042: WHERE org_id = p_org_id
1043: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

Line 1041: last_updated_by = FND_GLOBAL.USER_ID

1037: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1038: program_update_date = SYSDATE,
1039: last_update_login = FND_GLOBAL.LOGIN_ID,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID
1042: WHERE org_id = p_org_id
1043: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1044: intent,
1045: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

Line 1095: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1098: END LOOP;
1099: COMMIT;

Line 1110: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1113: END LOOP;
1114: COMMIT;

Line 1152: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1155: END LOOP;
1156: COMMIT;

Line 1167: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1170: END LOOP;
1171: COMMIT;

Line 1220: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1223: END LOOP;
1224: COMMIT;

Line 1235: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1238: END LOOP;
1239: COMMIT;

Line 1292: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1295: END LOOP;
1296: COMMIT;

Line 1359: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1362: END LOOP;
1363: COMMIT;

Line 1401: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1404: END LOOP;
1405: COMMIT;

Line 1416: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1419: END LOOP;
1420: COMMIT;

Line 1456: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1459: END LOOP;
1460: COMMIT;

Line 1471: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1474: END LOOP;
1475: COMMIT;

Line 1512: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1515: END LOOP;
1516: COMMIT;

Line 1527: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

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';
1530: END LOOP;
1531: COMMIT;

Line 1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1651: END IF;
1652:
1653: -- log file
1654: fnd_file.put_line(FND_FILE.LOG,' ');
1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);

Line 1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1917: END IF;
1918:
1919: -- log file
1920: fnd_file.put_line(FND_FILE.LOG,' ');
1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1922: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1923: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1924:
1925: /*