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 179: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,

175: fnd_file.put_line(FND_FILE.LOG,'Template Name : '||l_template_name);
176:
177: -- Update the xprt_request_id for the current template
178: UPDATE okc_terms_templates_all
179: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
180: last_update_login = FND_GLOBAL.LOGIN_ID,
181: last_update_date = SYSDATE,
182: last_updated_by = FND_GLOBAL.USER_ID
183: WHERE template_id = p_template_id;

Line 180: last_update_login = FND_GLOBAL.LOGIN_ID,

176:
177: -- Update the xprt_request_id for the current template
178: UPDATE okc_terms_templates_all
179: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
180: last_update_login = FND_GLOBAL.LOGIN_ID,
181: last_update_date = SYSDATE,
182: last_updated_by = FND_GLOBAL.USER_ID
183: WHERE template_id = p_template_id;
184:

Line 182: last_updated_by = FND_GLOBAL.USER_ID

178: UPDATE okc_terms_templates_all
179: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
180: last_update_login = FND_GLOBAL.LOGIN_ID,
181: last_update_date = SYSDATE,
182: last_updated_by = FND_GLOBAL.USER_ID
183: WHERE template_id = p_template_id;
184:
185: -- debug log
186: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 292: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID;

288: okc_xprt_rule_hdrs_all h
289: WHERE r.template_id = t.template_id
290: AND r.rule_id = h.rule_id
291: AND t.status_code IN ('APPROVED','ON_HOLD')
292: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID;
293:
294:
295: CURSOR csr_org_rules_templates(p_org_id IN NUMBER) IS
296: -- Org Wide Rule Templates

Line 302: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

298: FROM okc_terms_templates_all t
299: WHERE t.org_id = p_org_id
300: AND t.intent IN (SELECT DISTINCT intent
301: FROM okc_xprt_rule_hdrs_all
302: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
303: )
304: AND t.contract_expert_enabled = 'Y'
305: AND t.status_code IN ('APPROVED','ON_HOLD');
306:

Line 311: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

307: -- Cursor to check if any rule is Org Wide
308: CURSOR csr_org_rule_exists IS
309: SELECT 'X'
310: FROM okc_xprt_rule_hdrs_all
311: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
312: AND NVL(org_wide_flag,'N') = 'Y';
313:
314: -- Get the Rule Org Id
315: CURSOR csr_rule_org_id IS

Line 318: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

314: -- Get the Rule Org Id
315: CURSOR csr_rule_org_id IS
316: SELECT org_id
317: FROM okc_xprt_rule_hdrs_all
318: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
319:
320: l_api_name CONSTANT VARCHAR2(30) := 'sync_templates';
321: l_template_id okc_terms_templates_all.template_id%TYPE;
322: l_org_rules_yn okc_xprt_rule_hdrs_all.org_wide_flag%TYPE := NULL;

Line 518: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

514: -- Added for 4103931
515: CURSOR csr_pub_rule_list IS
516: SELECT rule_id
517: FROM okc_xprt_rule_hdrs_all
518: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
519:
520: l_rule_exists_flag VARCHAR2(1) := NULL;
521:
522: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;

Line 531: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

527:
528: CURSOR csr_rules IS
529: SELECT rule_id
530: FROM okc_xprt_rule_hdrs_all
531: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
532:
533:
534: BEGIN
535:

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

554: END IF;
555:
556: -- log file
557: fnd_file.put_line(FND_FILE.LOG,' ');
558: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
559: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
560: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
561:
562: /*

Line 574: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

570: fnd_file.put_line(FND_FILE.LOG,' ');
571:
572: -- Update request_id for all Rules in Pending Publication for current org id
573: UPDATE okc_xprt_rule_hdrs_all
574: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
575: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
576: program_application_id = FND_GLOBAL.PROG_APPL_ID,
577: program_update_date = SYSDATE,
578: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 575: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

571:
572: -- Update request_id for all Rules in Pending Publication for current org id
573: UPDATE okc_xprt_rule_hdrs_all
574: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
575: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
576: program_application_id = FND_GLOBAL.PROG_APPL_ID,
577: program_update_date = SYSDATE,
578: last_update_login = FND_GLOBAL.LOGIN_ID,
579: last_update_date = SYSDATE,

Line 576: program_application_id = FND_GLOBAL.PROG_APPL_ID,

572: -- Update request_id for all Rules in Pending Publication for current org id
573: UPDATE okc_xprt_rule_hdrs_all
574: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
575: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
576: program_application_id = FND_GLOBAL.PROG_APPL_ID,
577: program_update_date = SYSDATE,
578: last_update_login = FND_GLOBAL.LOGIN_ID,
579: last_update_date = SYSDATE,
580: last_updated_by = FND_GLOBAL.USER_ID

Line 578: last_update_login = FND_GLOBAL.LOGIN_ID,

574: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
575: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
576: program_application_id = FND_GLOBAL.PROG_APPL_ID,
577: program_update_date = SYSDATE,
578: last_update_login = FND_GLOBAL.LOGIN_ID,
579: last_update_date = SYSDATE,
580: last_updated_by = FND_GLOBAL.USER_ID
581: WHERE org_id = p_org_id
582: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

Line 580: last_updated_by = FND_GLOBAL.USER_ID

576: program_application_id = FND_GLOBAL.PROG_APPL_ID,
577: program_update_date = SYSDATE,
578: last_update_login = FND_GLOBAL.LOGIN_ID,
579: last_update_date = SYSDATE,
580: last_updated_by = FND_GLOBAL.USER_ID
581: WHERE org_id = p_org_id
582: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
583: intent,
584: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

Line 653: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

649: LOOP
650: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
651: UPDATE okc_xprt_rule_hdrs_all
652: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
653: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
654: AND rule_id = csr_pub_rule_rec.rule_id;
655: l_rule_exists_flag := 'F';
656: END LOOP;
657:

Line 704: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

700: LOOP
701: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
702: UPDATE okc_xprt_rule_hdrs_all
703: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
704: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
705: AND rule_id = csr_pub_rule_rec.rule_id;
706: l_rule_exists_flag := 'F';
707: END LOOP;
708: COMMIT;

Line 719: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

715: LOOP
716: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
717: UPDATE okc_xprt_rule_hdrs_all
718: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
719: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
720: AND rule_id = csr_pub_rule_rec.rule_id;
721: l_rule_exists_flag := 'F';
722: END LOOP;
723: COMMIT;

Line 763: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

759: LOOP
760: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
761: UPDATE okc_xprt_rule_hdrs_all
762: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
763: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
764: AND rule_id = csr_pub_rule_rec.rule_id;
765: l_rule_exists_flag := 'F';
766: END LOOP;
767: COMMIT;

Line 778: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

774: LOOP
775: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
776: UPDATE okc_xprt_rule_hdrs_all
777: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
778: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
779: AND rule_id = csr_pub_rule_rec.rule_id;
780: l_rule_exists_flag := 'F';
781: END LOOP;
782: COMMIT;

Line 817: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

813: LOOP
814: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
815: UPDATE okc_xprt_rule_hdrs_all
816: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
817: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
818: AND rule_id = csr_pub_rule_rec.rule_id;
819: l_rule_exists_flag := 'F';
820: END LOOP;
821: COMMIT;

Line 832: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

828: LOOP
829: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
830: UPDATE okc_xprt_rule_hdrs_all
831: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
832: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
833: AND rule_id = csr_pub_rule_rec.rule_id;
834: l_rule_exists_flag := 'F';
835: END LOOP;
836: COMMIT;

Line 874: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

870: LOOP
871: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
872: UPDATE okc_xprt_rule_hdrs_all
873: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
874: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
875: AND rule_id = csr_pub_rule_rec.rule_id;
876: l_rule_exists_flag := 'F';
877: END LOOP;
878: COMMIT;

Line 889: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

885: LOOP
886: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
887: UPDATE okc_xprt_rule_hdrs_all
888: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
889: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
890: AND rule_id = csr_pub_rule_rec.rule_id;
891: l_rule_exists_flag := 'F';
892: END LOOP;
893: COMMIT;

Line 943: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

939: LOOP
940: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
941: UPDATE okc_xprt_rule_hdrs_all
942: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
943: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
944: AND rule_id = csr_pub_rule_rec.rule_id;
945: l_rule_exists_flag := 'F';
946: END LOOP;
947: COMMIT;

Line 958: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

954: LOOP
955: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
956: UPDATE okc_xprt_rule_hdrs_all
957: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
958: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
959: AND rule_id = csr_pub_rule_rec.rule_id;
960: l_rule_exists_flag := 'F';
961: END LOOP;
962: COMMIT;

Line 1044: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1040: LOOP
1041: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1042: UPDATE okc_xprt_rule_hdrs_all
1043: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1044: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1045: AND rule_id = csr_pub_rule_rec.rule_id;
1046: l_rule_exists_flag := 'F';
1047: END LOOP;
1048: COMMIT;

Line 1113: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1109: LOOP
1110: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1111: UPDATE okc_xprt_rule_hdrs_all
1112: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1113: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1114: AND rule_id = csr_pub_rule_rec.rule_id;
1115: l_rule_exists_flag := 'F';
1116: END LOOP;
1117: COMMIT;

Line 1156: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1152: LOOP
1153: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1154: UPDATE okc_xprt_rule_hdrs_all
1155: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1156: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1157: AND rule_id = csr_pub_rule_rec.rule_id;
1158: l_rule_exists_flag := 'F';
1159: END LOOP;
1160: COMMIT;

Line 1171: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1167: LOOP
1168: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1169: UPDATE okc_xprt_rule_hdrs_all
1170: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1171: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1172: AND rule_id = csr_pub_rule_rec.rule_id;
1173: l_rule_exists_flag := 'F';
1174: END LOOP;
1175: COMMIT;

Line 1211: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1207: LOOP
1208: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1209: UPDATE okc_xprt_rule_hdrs_all
1210: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1211: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1212: AND rule_id = csr_pub_rule_rec.rule_id;
1213: l_rule_exists_flag := 'F';
1214: END LOOP;
1215: COMMIT;

Line 1226: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1222: LOOP
1223: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1224: UPDATE okc_xprt_rule_hdrs_all
1225: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1226: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1227: AND rule_id = csr_pub_rule_rec.rule_id;
1228: l_rule_exists_flag := 'F';
1229: END LOOP;
1230: COMMIT;

Line 1266: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1262: LOOP
1263: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1264: UPDATE okc_xprt_rule_hdrs_all
1265: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1266: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1267: AND rule_id = csr_pub_rule_rec.rule_id;
1268: l_rule_exists_flag := 'F';
1269: END LOOP;
1270: COMMIT;

Line 1281: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1277: LOOP
1278: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1279: UPDATE okc_xprt_rule_hdrs_all
1280: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1281: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1282: AND rule_id = csr_pub_rule_rec.rule_id;
1283: l_rule_exists_flag := 'F';
1284: END LOOP;
1285: COMMIT;

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

1310: END IF;
1311:
1312: -- log file
1313: fnd_file.put_line(FND_FILE.LOG,' ');
1314: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1315: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1316: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1317:
1318: /*

Line 1330: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

1326: fnd_file.put_line(FND_FILE.LOG,' ');
1327:
1328: -- Update request_id for all Rules in Pending Publication for current org id
1329: UPDATE okc_xprt_rule_hdrs_all
1330: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1331: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1332: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1333: program_update_date = SYSDATE,
1334: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1331: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

1327:
1328: -- Update request_id for all Rules in Pending Publication for current org id
1329: UPDATE okc_xprt_rule_hdrs_all
1330: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1331: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1332: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1333: program_update_date = SYSDATE,
1334: last_update_login = FND_GLOBAL.LOGIN_ID,
1335: last_update_date = SYSDATE,

Line 1332: program_application_id = FND_GLOBAL.PROG_APPL_ID,

1328: -- Update request_id for all Rules in Pending Publication for current org id
1329: UPDATE okc_xprt_rule_hdrs_all
1330: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1331: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1332: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1333: program_update_date = SYSDATE,
1334: last_update_login = FND_GLOBAL.LOGIN_ID,
1335: last_update_date = SYSDATE,
1336: last_updated_by = FND_GLOBAL.USER_ID

Line 1334: last_update_login = FND_GLOBAL.LOGIN_ID,

1330: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1331: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1332: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1333: program_update_date = SYSDATE,
1334: last_update_login = FND_GLOBAL.LOGIN_ID,
1335: last_update_date = SYSDATE,
1336: last_updated_by = FND_GLOBAL.USER_ID
1337: WHERE org_id = p_org_id
1338: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

Line 1336: last_updated_by = FND_GLOBAL.USER_ID

1332: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1333: program_update_date = SYSDATE,
1334: last_update_login = FND_GLOBAL.LOGIN_ID,
1335: last_update_date = SYSDATE,
1336: last_updated_by = FND_GLOBAL.USER_ID
1337: WHERE org_id = p_org_id
1338: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1339: intent,
1340: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

Line 1412: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1408: LOOP
1409: l_rule_exists_flag := check_rule_active(csr_pub_rule_rec.rule_id);
1410: UPDATE okc_xprt_rule_hdrs_all
1411: SET status_code = DECODE(l_rule_exists_flag,'T','REVISION','F','DRAFT')
1412: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1413: AND rule_id = csr_pub_rule_rec.rule_id;
1414: l_rule_exists_flag := 'F';
1415: END LOOP;
1416:

Line 1448: last_updated_by = FND_GLOBAL.USER_ID,

1444: -- Update all the Question order records that have question_rule_status as PENDINGPUB
1445: UPDATE Okc_Xprt_Question_Orders
1446: SET runtime_available_flag = 'Y',
1447: question_rule_status = 'ACTIVE',
1448: last_updated_by = FND_GLOBAL.USER_ID,
1449: last_update_date = SYSDATE,
1450: last_update_login = FND_GLOBAL.LOGIN_ID
1451: WHERE question_rule_status = 'PENDINGPUB'
1452: AND template_id IN ( SELECT template_id

Line 1450: last_update_login = FND_GLOBAL.LOGIN_ID

1446: SET runtime_available_flag = 'Y',
1447: question_rule_status = 'ACTIVE',
1448: last_updated_by = FND_GLOBAL.USER_ID,
1449: last_update_date = SYSDATE,
1450: last_update_login = FND_GLOBAL.LOGIN_ID
1451: WHERE question_rule_status = 'PENDINGPUB'
1452: AND template_id IN ( SELECT template_id
1453: FROM okc_terms_templates_all
1454: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 1454: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

1450: last_update_login = FND_GLOBAL.LOGIN_ID
1451: WHERE question_rule_status = 'PENDINGPUB'
1452: AND template_id IN ( SELECT template_id
1453: FROM okc_terms_templates_all
1454: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
1455: );
1456:
1457: -- Delete from okc_xprt_template_rules
1458: DELETE FROM okc_xprt_template_rules

Line 1462: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

1458: DELETE FROM okc_xprt_template_rules
1459: WHERE NVL(deleted_flag,'N') = 'Y'
1460: AND template_id IN ( SELECT template_id
1461: FROM okc_terms_templates_all
1462: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
1463: );
1464:
1465: -- Update published_flag in okc_xprt_template_rules
1466: UPDATE okc_xprt_template_rules

Line 1470: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

1466: UPDATE okc_xprt_template_rules
1467: SET published_flag = 'Y'
1468: WHERE template_id IN ( SELECT template_id
1469: FROM okc_terms_templates_all
1470: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
1471: );
1472: -- Update Rule status
1473: OPEN csr_rules;
1474: LOOP

Line 1484: last_updated_by = FND_GLOBAL.USER_ID,

1480: UPDATE okc_xprt_rule_hdrs_all
1481: SET status_code = 'ACTIVE',
1482: published_flag = 'Y',
1483: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
1484: last_updated_by = FND_GLOBAL.USER_ID,
1485: last_update_date = SYSDATE,
1486: last_update_login = FND_GLOBAL.LOGIN_ID,
1487: activation_date = SYSDATE
1488: WHERE rule_id = l_rule_id;

Line 1486: last_update_login = FND_GLOBAL.LOGIN_ID,

1482: published_flag = 'Y',
1483: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
1484: last_updated_by = FND_GLOBAL.USER_ID,
1485: last_update_date = SYSDATE,
1486: last_update_login = FND_GLOBAL.LOGIN_ID,
1487: activation_date = SYSDATE
1488: WHERE rule_id = l_rule_id;
1489:
1490: DELETE FROM okc_xprt_rule_outcomes_active WHERE rule_id = l_rule_id;

Line 1596: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

1592: -- Added for 4757731
1593: CURSOR csr_dis_rule_list IS
1594: SELECT rule_id
1595: FROM okc_xprt_rule_hdrs_all
1596: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
1597:
1598: l_rule_exists_flag VARCHAR2(1) := NULL;
1599:
1600: l_okc_rules_engine VARCHAR2(1);

Line 1609: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

1605:
1606: CURSOR csr_rules IS
1607: SELECT rule_id
1608: FROM okc_xprt_rule_hdrs_all
1609: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1610:
1611:
1612:
1613: BEGIN

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

1633: END IF;
1634:
1635: -- log file
1636: fnd_file.put_line(FND_FILE.LOG,' ');
1637: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1638: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1639: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1640:
1641: /*

Line 1653: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

1649: fnd_file.put_line(FND_FILE.LOG,' ');
1650:
1651: -- Update request_id for all Rules in Pending Publication for current org id
1652: UPDATE okc_xprt_rule_hdrs_all
1653: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1654: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1655: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1656: program_update_date = SYSDATE,
1657: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1654: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

1650:
1651: -- Update request_id for all Rules in Pending Publication for current org id
1652: UPDATE okc_xprt_rule_hdrs_all
1653: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1654: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1655: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1656: program_update_date = SYSDATE,
1657: last_update_login = FND_GLOBAL.LOGIN_ID,
1658: last_update_date = SYSDATE,

Line 1655: program_application_id = FND_GLOBAL.PROG_APPL_ID,

1651: -- Update request_id for all Rules in Pending Publication for current org id
1652: UPDATE okc_xprt_rule_hdrs_all
1653: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1654: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1655: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1656: program_update_date = SYSDATE,
1657: last_update_login = FND_GLOBAL.LOGIN_ID,
1658: last_update_date = SYSDATE,
1659: last_updated_by = FND_GLOBAL.USER_ID

Line 1657: last_update_login = FND_GLOBAL.LOGIN_ID,

1653: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
1654: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1655: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1656: program_update_date = SYSDATE,
1657: last_update_login = FND_GLOBAL.LOGIN_ID,
1658: last_update_date = SYSDATE,
1659: last_updated_by = FND_GLOBAL.USER_ID
1660: WHERE org_id = p_org_id
1661: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

Line 1659: last_updated_by = FND_GLOBAL.USER_ID

1655: program_application_id = FND_GLOBAL.PROG_APPL_ID,
1656: program_update_date = SYSDATE,
1657: last_update_login = FND_GLOBAL.LOGIN_ID,
1658: last_update_date = SYSDATE,
1659: last_updated_by = FND_GLOBAL.USER_ID
1660: WHERE org_id = p_org_id
1661: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1662: intent,
1663: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

Line 1713: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1709: LOOP
1710: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1711: UPDATE okc_xprt_rule_hdrs_all
1712: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1713: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1714: AND rule_id = csr_dis_rule_rec.rule_id;
1715: l_rule_exists_flag := 'F';
1716: END LOOP;
1717: COMMIT;

Line 1728: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1724: LOOP
1725: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1726: UPDATE okc_xprt_rule_hdrs_all
1727: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1728: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1729: AND rule_id = csr_dis_rule_rec.rule_id;
1730: l_rule_exists_flag := 'F';
1731: END LOOP;
1732: COMMIT;

Line 1770: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1766: LOOP
1767: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1768: UPDATE okc_xprt_rule_hdrs_all
1769: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1770: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1771: AND rule_id = csr_dis_rule_rec.rule_id;
1772: l_rule_exists_flag := 'F';
1773: END LOOP;
1774: COMMIT;

Line 1785: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1781: LOOP
1782: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1783: UPDATE okc_xprt_rule_hdrs_all
1784: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1785: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1786: AND rule_id = csr_dis_rule_rec.rule_id;
1787: l_rule_exists_flag := 'F';
1788: END LOOP;
1789: COMMIT;

Line 1838: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1834: LOOP
1835: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1836: UPDATE okc_xprt_rule_hdrs_all
1837: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1838: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1839: AND rule_id = csr_dis_rule_rec.rule_id;
1840: l_rule_exists_flag := 'F';
1841: END LOOP;
1842: COMMIT;

Line 1853: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1849: LOOP
1850: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1851: UPDATE okc_xprt_rule_hdrs_all
1852: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1853: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1854: AND rule_id = csr_dis_rule_rec.rule_id;
1855: l_rule_exists_flag := 'F';
1856: END LOOP;
1857: COMMIT;

Line 1910: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1906: LOOP
1907: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1908: UPDATE okc_xprt_rule_hdrs_all
1909: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1910: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1911: AND rule_id = csr_dis_rule_rec.rule_id;
1912: l_rule_exists_flag := 'F';
1913: END LOOP;
1914: COMMIT;

Line 1977: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

1973: LOOP
1974: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1975: UPDATE okc_xprt_rule_hdrs_all
1976: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
1977: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
1978: AND rule_id = csr_dis_rule_rec.rule_id;
1979: l_rule_exists_flag := 'F';
1980: END LOOP;
1981: COMMIT;

Line 2019: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2015: LOOP
2016: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
2017: UPDATE okc_xprt_rule_hdrs_all
2018: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
2019: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2020: AND rule_id = csr_dis_rule_rec.rule_id;
2021: l_rule_exists_flag := 'F';
2022: END LOOP;
2023: COMMIT;

Line 2034: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2030: LOOP
2031: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
2032: UPDATE okc_xprt_rule_hdrs_all
2033: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
2034: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2035: AND rule_id = csr_dis_rule_rec.rule_id;
2036: l_rule_exists_flag := 'F';
2037: END LOOP;
2038: COMMIT;

Line 2074: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2070: LOOP
2071: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
2072: UPDATE okc_xprt_rule_hdrs_all
2073: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
2074: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2075: AND rule_id = csr_dis_rule_rec.rule_id;
2076: l_rule_exists_flag := 'F';
2077: END LOOP;
2078: COMMIT;

Line 2089: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2085: LOOP
2086: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
2087: UPDATE okc_xprt_rule_hdrs_all
2088: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
2089: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2090: AND rule_id = csr_dis_rule_rec.rule_id;
2091: l_rule_exists_flag := 'F';
2092: END LOOP;
2093: COMMIT;

Line 2130: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2126: LOOP
2127: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
2128: UPDATE okc_xprt_rule_hdrs_all
2129: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
2130: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2131: AND rule_id = csr_dis_rule_rec.rule_id;
2132: l_rule_exists_flag := 'F';
2133: END LOOP;
2134: COMMIT;

Line 2145: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2141: LOOP
2142: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
2143: UPDATE okc_xprt_rule_hdrs_all
2144: SET status_code = DECODE(l_rule_exists_flag,'T','ACTIVE',status_code)
2145: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2146: AND rule_id = csr_dis_rule_rec.rule_id;
2147: l_rule_exists_flag := 'F';
2148: END LOOP;
2149: COMMIT;

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

2190: END IF;
2191:
2192: -- log file
2193: fnd_file.put_line(FND_FILE.LOG,' ');
2194: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
2195: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
2196: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
2197:
2198: /*

Line 2210: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

2206: fnd_file.put_line(FND_FILE.LOG,' ');
2207:
2208: -- Update request_id for all Rules in Pending Publication for current org id
2209: UPDATE okc_xprt_rule_hdrs_all
2210: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
2211: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
2212: program_application_id = FND_GLOBAL.PROG_APPL_ID,
2213: program_update_date = SYSDATE,
2214: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 2211: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

2207:
2208: -- Update request_id for all Rules in Pending Publication for current org id
2209: UPDATE okc_xprt_rule_hdrs_all
2210: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
2211: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
2212: program_application_id = FND_GLOBAL.PROG_APPL_ID,
2213: program_update_date = SYSDATE,
2214: last_update_login = FND_GLOBAL.LOGIN_ID,
2215: last_update_date = SYSDATE,

Line 2212: program_application_id = FND_GLOBAL.PROG_APPL_ID,

2208: -- Update request_id for all Rules in Pending Publication for current org id
2209: UPDATE okc_xprt_rule_hdrs_all
2210: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
2211: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
2212: program_application_id = FND_GLOBAL.PROG_APPL_ID,
2213: program_update_date = SYSDATE,
2214: last_update_login = FND_GLOBAL.LOGIN_ID,
2215: last_update_date = SYSDATE,
2216: last_updated_by = FND_GLOBAL.USER_ID

Line 2214: last_update_login = FND_GLOBAL.LOGIN_ID,

2210: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,
2211: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
2212: program_application_id = FND_GLOBAL.PROG_APPL_ID,
2213: program_update_date = SYSDATE,
2214: last_update_login = FND_GLOBAL.LOGIN_ID,
2215: last_update_date = SYSDATE,
2216: last_updated_by = FND_GLOBAL.USER_ID
2217: WHERE org_id = p_org_id
2218: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

Line 2216: last_updated_by = FND_GLOBAL.USER_ID

2212: program_application_id = FND_GLOBAL.PROG_APPL_ID,
2213: program_update_date = SYSDATE,
2214: last_update_login = FND_GLOBAL.LOGIN_ID,
2215: last_update_date = SYSDATE,
2216: last_updated_by = FND_GLOBAL.USER_ID
2217: WHERE org_id = p_org_id
2218: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
2219: intent,
2220: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

Line 2269: last_updated_by = FND_GLOBAL.USER_ID,

2265: UPDATE okc_xprt_rule_hdrs_all
2266: SET status_code = 'INACTIVE',
2267: published_flag = 'Y',
2268: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
2269: last_updated_by = FND_GLOBAL.USER_ID,
2270: last_update_date = SYSDATE,
2271: last_update_login = FND_GLOBAL.LOGIN_ID
2272: WHERE rule_id = l_rule_id;
2273:

Line 2271: last_update_login = FND_GLOBAL.LOGIN_ID

2267: published_flag = 'Y',
2268: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
2269: last_updated_by = FND_GLOBAL.USER_ID,
2270: last_update_date = SYSDATE,
2271: last_update_login = FND_GLOBAL.LOGIN_ID
2272: WHERE rule_id = l_rule_id;
2273:
2274: DELETE FROM okc_xprt_rule_outcomes_active WHERE rule_id = l_rule_id;
2275:

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

2377: END IF;
2378:
2379: -- log file
2380: fnd_file.put_line(FND_FILE.LOG,' ');
2381: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
2382: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
2383: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
2384: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
2385: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);

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

2653: END IF;
2654:
2655: -- log file
2656: fnd_file.put_line(FND_FILE.LOG,' ');
2657: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
2658: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
2659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
2660:
2661: /*