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.

[Home] [Help]

APPS.OKC_XPRT_IMPORT_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 288: okc_xprt_rule_hdrs_all h

284: -- Templates on Local Rules
285: SELECT DISTINCT to_char(r.template_id)
286: FROM okc_terms_templates_all t,
287: okc_xprt_template_rules r,
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;

Line 301: FROM okc_xprt_rule_hdrs_all

297: SELECT t.template_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');

Line 310: FROM okc_xprt_rule_hdrs_all

306:
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

Line 317: FROM okc_xprt_rule_hdrs_all

313:
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;

Line 322: l_org_rules_yn okc_xprt_rule_hdrs_all.org_wide_flag%TYPE := NULL;

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;
323: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
324:
325: BEGIN
326: -- start debug log

Line 323: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

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;
323: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
324:
325: BEGIN
326: -- start debug log
327: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 517: FROM okc_xprt_rule_hdrs_all

513:
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:

Line 522: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;

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;
523:
524: l_okc_rules_engine VARCHAR2(1);
525:
526: l_rule_id NUMBER;

Line 530: FROM okc_xprt_rule_hdrs_all

526: l_rule_id NUMBER;
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

Line 573: UPDATE okc_xprt_rule_hdrs_all

569: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
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,

Line 651: UPDATE okc_xprt_rule_hdrs_all

647: -- Added for Bug 4103931
648: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 702: UPDATE okc_xprt_rule_hdrs_all

698: -- Added for Bug 4757731
699: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 717: UPDATE okc_xprt_rule_hdrs_all

713: -- Added for Bug 4757731
714: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 761: UPDATE okc_xprt_rule_hdrs_all

757: -- Added for Bug 4757731
758: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 776: UPDATE okc_xprt_rule_hdrs_all

772: -- Added for Bug 4757731
773: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 815: UPDATE okc_xprt_rule_hdrs_all

811: -- Added for Bug 4757731
812: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 830: UPDATE okc_xprt_rule_hdrs_all

826: -- Added for Bug 4757731
827: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 872: UPDATE okc_xprt_rule_hdrs_all

868: -- Added for Bug 4757731
869: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 887: UPDATE okc_xprt_rule_hdrs_all

883: -- Added for Bug 4757731
884: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 941: UPDATE okc_xprt_rule_hdrs_all

937: -- Added for Bug 4757731
938: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 956: UPDATE okc_xprt_rule_hdrs_all

952: -- Added for Bug 4757731
953: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1042: UPDATE okc_xprt_rule_hdrs_all

1038: -- Added for Bug 4757731
1039: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1111: UPDATE okc_xprt_rule_hdrs_all

1107: -- Added for Bug 4757731
1108: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1154: UPDATE okc_xprt_rule_hdrs_all

1150: -- Added for Bug 4757731
1151: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1169: UPDATE okc_xprt_rule_hdrs_all

1165: -- Added for Bug 4757731
1166: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1209: UPDATE okc_xprt_rule_hdrs_all

1205: -- Added for Bug 4757731
1206: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1224: UPDATE okc_xprt_rule_hdrs_all

1220: -- Added for Bug 4757731
1221: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1264: UPDATE okc_xprt_rule_hdrs_all

1260: -- Added for Bug 4757731
1261: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1279: UPDATE okc_xprt_rule_hdrs_all

1275: -- Added for Bug 4757731
1276: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1329: UPDATE okc_xprt_rule_hdrs_all

1325: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
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,

Line 1410: UPDATE okc_xprt_rule_hdrs_all

1406: -- Added for Bug 4103931
1407: FOR csr_pub_rule_rec IN csr_pub_rule_list
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';

Line 1480: UPDATE okc_xprt_rule_hdrs_all

1476: EXIT WHEN csr_rules%NOTFOUND;
1477:
1478: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
1479:
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,

Line 1496: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;

1492: DELETE FROM okc_xprt_rule_cond_vals_active WHERE rule_condition_id IN (SELECT rule_condition_id FROM okc_xprt_rule_conditions WHERE rule_id = l_rule_id);
1493:
1494: DELETE FROM okc_xprt_rule_cond_active WHERE rule_id = l_rule_id;
1495:
1496: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;
1497:
1498: END LOOP;
1499: CLOSE csr_rules;
1500:

Line 1595: FROM okc_xprt_rule_hdrs_all

1591:
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:

Line 1604: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;

1600: l_okc_rules_engine VARCHAR2(1);
1601:
1602: l_rule_id NUMBER;
1603:
1604: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1605:
1606: CURSOR csr_rules IS
1607: SELECT rule_id
1608: FROM okc_xprt_rule_hdrs_all

Line 1608: FROM okc_xprt_rule_hdrs_all

1604: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
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:

Line 1652: UPDATE okc_xprt_rule_hdrs_all

1648: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
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,

Line 1711: UPDATE okc_xprt_rule_hdrs_all

1707: -- Added for Bug 4757731
1708: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1726: UPDATE okc_xprt_rule_hdrs_all

1722: -- Added for Bug 4757731
1723: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1768: UPDATE okc_xprt_rule_hdrs_all

1764: -- Added for Bug 4757731
1765: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1783: UPDATE okc_xprt_rule_hdrs_all

1779: -- Added for Bug 4757731
1780: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1836: UPDATE okc_xprt_rule_hdrs_all

1832: -- Added for Bug 4757731
1833: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1851: UPDATE okc_xprt_rule_hdrs_all

1847: -- Added for Bug 4757731
1848: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1908: UPDATE okc_xprt_rule_hdrs_all

1904: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
1905: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 1975: UPDATE okc_xprt_rule_hdrs_all

1971: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
1972: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2017: UPDATE okc_xprt_rule_hdrs_all

2013: -- Added for Bug 4757731
2014: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2032: UPDATE okc_xprt_rule_hdrs_all

2028: -- Added for Bug 4757731
2029: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2072: UPDATE okc_xprt_rule_hdrs_all

2068: -- Added for Bug 4757731
2069: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2087: UPDATE okc_xprt_rule_hdrs_all

2083: -- Added for Bug 4757731
2084: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2128: UPDATE okc_xprt_rule_hdrs_all

2124: -- Added for Bug 4757731
2125: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2143: UPDATE okc_xprt_rule_hdrs_all

2139: -- Added for Bug 4757731
2140: FOR csr_dis_rule_rec IN csr_dis_rule_list
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';

Line 2209: UPDATE okc_xprt_rule_hdrs_all

2205: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
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,

Line 2265: UPDATE okc_xprt_rule_hdrs_all

2261: EXIT WHEN csr_rules%NOTFOUND;
2262:
2263: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2264:
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,

Line 2280: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;

2276: DELETE FROM okc_xprt_rule_cond_vals_active WHERE rule_condition_id IN (SELECT rule_condition_id FROM okc_xprt_rule_conditions WHERE rule_id = l_rule_id);
2277:
2278: DELETE FROM okc_xprt_rule_cond_active WHERE rule_id = l_rule_id;
2279:
2280: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;
2281:
2282: END LOOP;
2283: CLOSE csr_rules;
2284:

Line 2358: FROM okc_xprt_rule_hdrs_all

2354: AND t.template_id = NVL(p_template_id, template_id);
2355:
2356: CURSOR csr_active_rules_cnt IS
2357: SELECT COUNT(*)
2358: FROM okc_xprt_rule_hdrs_all
2359: WHERE org_id = p_org_id
2360: AND intent = p_intent
2361: AND status_code = 'ACTIVE';
2362: