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_UTIL_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 405: FROM okc_xprt_rule_hdrs_all rhdr,

401:
402: CURSOR c1 IS
403: --Check the Variable Type for line level
404: SELECT NVL(v.line_level_flag,'N') line_level_flag
405: FROM okc_xprt_rule_hdrs_all rhdr,
406: okc_xprt_rule_conditions rcon,
407: okc_bus_variables_b v
408: WHERE rhdr.rule_id = rcon.rule_id
409: AND rcon.object_type = 'VARIABLE'

Line 416: FROM okc_xprt_rule_hdrs_all rhdr,

412: AND v.line_level_flag = 'Y'
413: AND rhdr.rule_id = p_rule_id
414: UNION
415: SELECT NVL(v.line_level_flag,'N') line_level_flag
416: FROM okc_xprt_rule_hdrs_all rhdr,
417: okc_xprt_rule_conditions rcon,
418: okc_bus_variables_b v
419: WHERE rhdr.rule_id = rcon.rule_id
420: AND rcon.object_value_type = 'VARIABLE'

Line 487: okc_xprt_rule_hdrs_all h

483: CURSOR csr_local_rules_templates IS
484: -- Local Rules on Template
485: SELECT 'X'
486: FROM okc_xprt_template_rules r,
487: okc_xprt_rule_hdrs_all h
488: WHERE r.rule_id = h.rule_id
489: AND h.status_code = 'ACTIVE'
490: AND template_id = p_template_id ;
491:

Line 496: okc_xprt_rule_hdrs_all h

492: CURSOR csr_org_rules_templates IS
493: -- Org Wide Rules
494: SELECT 'X'
495: FROM okc_terms_templates_all t,
496: okc_xprt_rule_hdrs_all h
497: WHERE t.org_id = h.org_id
498: AND t.intent = h.intent
499: AND h.status_code = 'ACTIVE'
500: AND NVL(h.org_wide_flag,'N') = 'Y'

Line 1023: okc_xprt_rule_hdrs_all Rules,

1019: WHERE Template_Id = p_Template_Id
1020: AND NOT EXISTS
1021: (SELECT 1
1022: FROM Okc_Xprt_Rule_Conditions Cond,
1023: okc_xprt_rule_hdrs_all Rules,
1024: Okc_Xprt_Template_Rules Assoc,
1025: Okc_xprt_questions_b quest
1026: WHERE Rules.Rule_Id = Cond.Rule_Id
1027: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1039: okc_xprt_rule_hdrs_all Rules,

1035: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1036: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1037: SELECT 1
1038: FROM Okc_Xprt_Rule_Outcomes Outs,
1039: okc_xprt_rule_hdrs_all Rules,
1040: Okc_Xprt_Template_Rules Assoc,
1041: Okc_xprt_questions_b quest
1042: WHERE Rules.Rule_Id = Assoc.Rule_Id
1043: AND Rules.rule_id = Outs.rule_id

Line 1052: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,

1048: AND quest.question_id = Okc_Xprt_Question_Orders.Question_Id
1049: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1050: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1051: SELECT 1
1052: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,
1053: Okc_xprt_questions_b quest
1054: WHERE Rules.Rule_Id = Cond.Rule_Id
1055: AND Rules.Org_Wide_Flag = 'Y'
1056: AND Rules.Org_Id = l_Org_Id

Line 1067: FROM Okc_Xprt_Rule_Outcomes Outs, okc_xprt_rule_hdrs_all Rules,

1063: AND quest.question_id = Okc_Xprt_Question_Orders.Question_Id
1064: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1065: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1066: SELECT 1
1067: FROM Okc_Xprt_Rule_Outcomes Outs, okc_xprt_rule_hdrs_all Rules,
1068: Okc_xprt_questions_b quest
1069: WHERE Rules.Rule_Id = Outs.Rule_Id
1070: AND Rules.Org_Wide_Flag = 'Y'
1071: AND Rules.Org_Id = l_Org_Id

Line 1125: okc_xprt_rule_hdrs_all Rules,

1121: CURSOR Active_Draft_Rule_Questions IS
1122: SELECT * FROM (
1123: SELECT distinct To_Number(Cond.Object_Code) Question_Id, Rules.Status_Code
1124: FROM Okc_Xprt_Rule_Conditions Cond,
1125: okc_xprt_rule_hdrs_all Rules,
1126: Okc_Xprt_Template_Rules Assoc
1127: WHERE Rules.Rule_Id = Cond.Rule_Id
1128: AND Rules.Rule_Id = Assoc.Rule_Id
1129: AND Assoc.Template_Id = p_Template_Id

Line 1135: okc_xprt_rule_hdrs_all Rules,

1131: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1132: UNION
1133: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id, Rules.Status_Code
1134: FROM Okc_Xprt_Rule_Conditions Cond,
1135: okc_xprt_rule_hdrs_all Rules,
1136: Okc_Xprt_Template_Rules Assoc
1137: WHERE Rules.Rule_Id = Cond.Rule_Id
1138: AND Rules.Rule_Id = Assoc.Rule_Id
1139: AND Assoc.Template_Id = p_Template_Id

Line 1145: okc_xprt_rule_hdrs_all Rules,

1141: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1142: UNION
1143: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id, Rules.Status_Code
1144: FROM Okc_Xprt_Rule_Outcomes Outs,
1145: okc_xprt_rule_hdrs_all Rules,
1146: Okc_Xprt_Template_Rules Assoc
1147: WHERE Rules.Rule_Id = Assoc.Rule_Id
1148: AND Assoc.Template_Id = p_Template_Id
1149: AND Outs.Object_Type = 'QUESTION'

Line 1155: okc_xprt_rule_hdrs_all Rules

1151: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1152: UNION
1153: SELECT distinct To_Number(Cond.Object_Code) Question_Id, Rules.Status_Code
1154: FROM Okc_Xprt_Rule_Conditions Cond,
1155: okc_xprt_rule_hdrs_all Rules
1156: WHERE Rules.Rule_Id = Cond.Rule_Id
1157: AND Rules.Org_Wide_Flag = 'Y'
1158: AND Rules.Org_Id = l_Org_Id
1159: AND Rules.Intent = l_Intent

Line 1165: okc_xprt_rule_hdrs_all Rules

1161: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1162: UNION
1163: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id, Rules.Status_Code
1164: FROM Okc_Xprt_Rule_Conditions Cond,
1165: okc_xprt_rule_hdrs_all Rules
1166: WHERE Rules.Rule_Id = Cond.Rule_Id
1167: AND Rules.Org_Wide_Flag = 'Y'
1168: AND Rules.Org_Id = l_Org_Id
1169: AND Rules.Intent = l_Intent

Line 1175: okc_xprt_rule_hdrs_all Rules

1171: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1172: UNION
1173: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id, Rules.Status_Code
1174: FROM Okc_Xprt_Rule_Outcomes Outs,
1175: okc_xprt_rule_hdrs_all Rules
1176: WHERE Rules.Rule_Id = Outs.Rule_Id
1177: AND Rules.Org_Wide_Flag = 'Y'
1178: AND Rules.Org_Id = l_Org_Id
1179: AND Rules.Intent = l_Intent

Line 1254: okc_xprt_rule_hdrs_all Rules,

1250: DECLARE
1251: CURSOR Pending_Rule_Questions IS
1252: SELECT distinct To_Number(Cond.Object_Code) Question_Id
1253: FROM Okc_Xprt_Rule_Conditions Cond,
1254: okc_xprt_rule_hdrs_all Rules,
1255: Okc_Xprt_Template_Rules Assoc
1256: WHERE Rules.Rule_Id = Cond.Rule_Id
1257: AND Rules.Rule_Id = Assoc.Rule_Id
1258: AND Assoc.Template_Id = p_Template_Id

Line 1265: okc_xprt_rule_hdrs_all Rules,

1261: AND Rules.Request_Id = l_conc_request_id
1262: UNION
1263: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id
1264: FROM Okc_Xprt_Rule_Conditions Cond,
1265: okc_xprt_rule_hdrs_all Rules,
1266: Okc_Xprt_Template_Rules Assoc
1267: WHERE Rules.Rule_Id = Cond.Rule_Id
1268: AND Rules.Rule_Id = Assoc.Rule_Id
1269: AND Assoc.Template_Id = p_Template_Id

Line 1276: okc_xprt_rule_hdrs_all Rules,

1272: AND Rules.Request_Id = l_conc_request_id
1273: UNION
1274: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id
1275: FROM Okc_Xprt_Rule_Outcomes Outs,
1276: okc_xprt_rule_hdrs_all Rules,
1277: Okc_Xprt_Template_Rules Assoc
1278: WHERE Rules.Rule_Id = Assoc.Rule_Id
1279: AND Assoc.Template_Id = p_Template_Id
1280: AND Outs.Object_Type = 'QUESTION'

Line 1287: okc_xprt_rule_hdrs_all Rules

1283: AND Rules.Request_Id = l_conc_request_id
1284: UNION
1285: SELECT distinct To_Number(Cond.Object_Code) Question_Id
1286: FROM Okc_Xprt_Rule_Conditions Cond,
1287: okc_xprt_rule_hdrs_all Rules
1288: WHERE Rules.Rule_Id = Cond.Rule_Id
1289: AND Rules.Org_Wide_Flag = 'Y'
1290: AND Rules.Org_Id = l_Org_Id
1291: AND Rules.Intent = l_Intent

Line 1298: okc_xprt_rule_hdrs_all Rules

1294: AND Rules.Request_Id = l_conc_request_id
1295: UNION
1296: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id
1297: FROM Okc_Xprt_Rule_Conditions Cond,
1298: okc_xprt_rule_hdrs_all Rules
1299: WHERE Rules.Rule_Id = Cond.Rule_Id
1300: AND Rules.Org_Wide_Flag = 'Y'
1301: AND Rules.Org_Id = l_Org_Id
1302: AND Rules.Intent = l_Intent

Line 1309: okc_xprt_rule_hdrs_all Rules

1305: AND Rules.Request_Id = l_conc_request_id
1306: UNION
1307: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id
1308: FROM Okc_Xprt_Rule_Outcomes Outs,
1309: okc_xprt_rule_hdrs_all Rules
1310: WHERE Rules.Rule_Id = Outs.Rule_Id
1311: AND Rules.Org_Wide_Flag = 'Y'
1312: AND Rules.Org_Id = l_Org_Id
1313: AND Rules.Intent = l_Intent

Line 1403: okc_xprt_rule_hdrs_all Rules,

1399: WHERE Template_Id = p_Template_Id
1400: AND Question_Id IN
1401: (SELECT Ord.Question_Id
1402: FROM Okc_Xprt_Rule_Conditions Cond,
1403: okc_xprt_rule_hdrs_all Rules,
1404: Okc_Xprt_Template_Rules Assoc,
1405: Okc_Xprt_Question_Orders Ord
1406: WHERE Rules.Rule_Id = Cond.Rule_Id
1407: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1426: okc_xprt_rule_hdrs_all Rules,

1422: WHERE Template_Id = p_Template_Id
1423: AND Question_Id IN
1424: (SELECT Ord.Question_Id
1425: FROM Okc_Xprt_Rule_Conditions Cond,
1426: okc_xprt_rule_hdrs_all Rules,
1427: Okc_Xprt_Question_Orders Ord
1428: WHERE Rules.Rule_Id = Cond.Rule_Id
1429: AND Rules.Org_Wide_Flag = 'Y'
1430: AND Rules.Org_Id = l_Org_Id

Line 1449: okc_xprt_rule_hdrs_all Rules,

1445: WHERE Template_Id = p_Template_Id
1446: AND Question_Id IN
1447: (SELECT Ord.Question_Id
1448: FROM Okc_Xprt_Rule_Outcomes Outs,
1449: okc_xprt_rule_hdrs_all Rules,
1450: Okc_Xprt_Template_Rules Assoc,
1451: Okc_Xprt_Question_Orders Ord
1452: WHERE Rules.Rule_Id = Assoc.Rule_Id
1453: AND Assoc.Template_Id = p_Template_Id

Line 1469: okc_xprt_rule_hdrs_all Rules,

1465: WHERE Template_Id = p_Template_Id
1466: AND Question_Id IN
1467: (SELECT Ord.Question_Id
1468: FROM Okc_Xprt_Rule_Outcomes Outs,
1469: okc_xprt_rule_hdrs_all Rules,
1470: Okc_Xprt_Question_Orders Ord
1471: WHERE Rules.Rule_Id = Outs.Rule_Id
1472: AND Rules.Org_Wide_Flag = 'Y'
1473: AND Rules.Org_Id = l_Org_Id

Line 1498: okc_xprt_rule_hdrs_all Rules,

1494: WHERE Template_Id = p_Template_Id
1495: AND Question_Id IN
1496: (SELECT Ord.Question_Id
1497: FROM Okc_Xprt_Rule_Conditions Cond,
1498: okc_xprt_rule_hdrs_all Rules,
1499: Okc_Xprt_Template_Rules Assoc,
1500: Okc_Xprt_Question_Orders Ord
1501: WHERE Rules.Rule_Id = Cond.Rule_Id
1502: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1514: okc_xprt_rule_hdrs_all Rules,

1510: AND Rules.Status_Code = 'ACTIVE'
1511: UNION
1512: SELECT Ord.Question_Id
1513: FROM Okc_Xprt_Rule_Conditions Cond,
1514: okc_xprt_rule_hdrs_all Rules,
1515: Okc_Xprt_Question_Orders Ord
1516: WHERE Rules.Rule_Id = Cond.Rule_Id
1517: AND Rules.Org_Wide_Flag = 'Y'
1518: AND Rules.Org_Id = l_Org_Id

Line 1539: okc_xprt_rule_hdrs_all Rules,

1535: WHERE Template_Id = p_Template_Id
1536: AND Question_Id IN
1537: (SELECT Ord.Question_Id
1538: FROM Okc_Xprt_Rule_Conditions Cond,
1539: okc_xprt_rule_hdrs_all Rules,
1540: Okc_Xprt_Template_Rules Assoc,
1541: Okc_Xprt_Question_Orders Ord
1542: WHERE Rules.Rule_Id = Cond.Rule_Id
1543: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1556: okc_xprt_rule_hdrs_all Rules,

1552: AND Rules.Request_Id = l_conc_request_id
1553: UNION
1554: SELECT Ord.Question_Id
1555: FROM Okc_Xprt_Rule_Conditions Cond,
1556: okc_xprt_rule_hdrs_all Rules,
1557: Okc_Xprt_Question_Orders Ord
1558: WHERE Rules.Rule_Id = Cond.Rule_Id
1559: AND Rules.Org_Wide_Flag = 'Y'
1560: AND Rules.Org_Id = l_Org_Id

Line 1581: okc_xprt_rule_hdrs_all Rules,

1577: WHERE Template_Id = p_Template_Id
1578: AND Question_Id IN
1579: (SELECT Ord.Question_Id
1580: FROM Okc_Xprt_Rule_Outcomes Outs,
1581: okc_xprt_rule_hdrs_all Rules,
1582: Okc_Xprt_Template_Rules Assoc,
1583: Okc_Xprt_Question_Orders Ord
1584: WHERE Rules.Rule_Id = Assoc.Rule_Id
1585: AND Assoc.Template_Id = p_Template_Id

Line 1593: okc_xprt_rule_hdrs_all Rules,

1589: AND rules.rule_id = outs.rule_id
1590: UNION
1591: SELECT Ord.Question_Id
1592: FROM Okc_Xprt_Rule_Outcomes Outs,
1593: okc_xprt_rule_hdrs_all Rules,
1594: Okc_Xprt_Question_Orders Ord
1595: WHERE Rules.Rule_Id = Outs.Rule_Id
1596: AND Rules.Org_Wide_Flag = 'Y'
1597: AND Rules.Org_Id = l_Org_Id

Line 1614: okc_xprt_rule_hdrs_all Rules,

1610: WHERE Template_Id = p_Template_Id
1611: AND Question_Id IN
1612: (SELECT Ord.Question_Id
1613: FROM Okc_Xprt_Rule_Outcomes Outs,
1614: okc_xprt_rule_hdrs_all Rules,
1615: Okc_Xprt_Template_Rules Assoc,
1616: Okc_Xprt_Question_Orders Ord
1617: WHERE Rules.Rule_Id = Assoc.Rule_Id
1618: AND Assoc.Template_Id = p_Template_Id

Line 1627: okc_xprt_rule_hdrs_all Rules,

1623: AND rules.rule_id = outs.rule_id
1624: UNION
1625: SELECT Ord.Question_Id
1626: FROM Okc_Xprt_Rule_Outcomes Outs,
1627: okc_xprt_rule_hdrs_all Rules,
1628: Okc_Xprt_Question_Orders Ord
1629: WHERE Rules.Rule_Id = Outs.Rule_Id
1630: AND Rules.Org_Wide_Flag = 'Y'
1631: AND Rules.Org_Id = l_Org_Id

Line 1817: FROM okc_xprt_rule_hdrs_all

1813: */
1814:
1815: CURSOR csr_rules IS
1816: SELECT rule_id
1817: FROM okc_xprt_rule_hdrs_all
1818: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1819:
1820: CURSOR csr_get_publication_id (p_template_model_id NUMBER, p_publication_mode VARCHAR2) IS
1821: SELECT publication_id ,

Line 1835: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

1831: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
1832: l_run_id NUMBER;
1833: l_publication_id cz_model_publications.publication_id%TYPE;
1834: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1835: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1836: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1837:
1838: --Bug 5032199 Using REF cursor
1839: TYPE cur_type IS REF CURSOR;

Line 1836: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;

1832: l_run_id NUMBER;
1833: l_publication_id cz_model_publications.publication_id%TYPE;
1834: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1835: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1836: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1837:
1838: --Bug 5032199 Using REF cursor
1839: TYPE cur_type IS REF CURSOR;
1840: csr_templates cur_type;

Line 2100: UPDATE okc_xprt_rule_hdrs_all

2096: EXIT WHEN csr_rules%NOTFOUND;
2097:
2098: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2099:
2100: UPDATE okc_xprt_rule_hdrs_all
2101: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
2102: published_flag = 'Y',
2103: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
2104: last_updated_by = FND_GLOBAL.USER_ID,

Line 2237: FROM okc_xprt_rule_hdrs_all r,

2233:
2234: CURSOR csr_tmpl_non_active_rules IS
2235: -- global rules not active
2236: SELECT 'X'
2237: FROM okc_xprt_rule_hdrs_all r,
2238: okc_terms_templates_all t
2239: WHERE t.org_id = r.org_id
2240: AND t.intent = r.intent
2241: AND t.template_id = p_template_id

Line 2248: okc_xprt_rule_hdrs_all r

2244: UNION ALL
2245: -- Local rules not active
2246: SELECT 'X'
2247: FROM okc_xprt_template_rules tr,
2248: okc_xprt_rule_hdrs_all r
2249: WHERE tr.template_id = p_template_id
2250: AND tr.rule_id = r.rule_id
2251: AND r.status_code NOT IN ('ACTIVE','INACTIVE');
2252:

Line 2256: FROM okc_xprt_rule_hdrs_all r,

2252:
2253: CURSOR csr_tmpl_active_rules IS
2254: -- global Active rules
2255: SELECT 'X'
2256: FROM okc_xprt_rule_hdrs_all r,
2257: okc_terms_templates_all t
2258: WHERE t.org_id = r.org_id
2259: AND t.intent = r.intent
2260: AND t.template_id = p_template_id

Line 2267: okc_xprt_rule_hdrs_all r

2263: UNION ALL
2264: -- Local Active rules
2265: SELECT 'X'
2266: FROM okc_xprt_template_rules tr,
2267: okc_xprt_rule_hdrs_all r
2268: WHERE tr.template_id = p_template_id
2269: AND tr.rule_id = r.rule_id
2270: AND r.status_code = 'ACTIVE' ;
2271:

Line 4744: FROM okc_xprt_rule_hdrs_all rule

4740: CURSOR all_rules IS
4741:
4742: -- org wide rules applicable to given template
4743: SELECT 'x'
4744: FROM okc_xprt_rule_hdrs_all rule
4745: WHERE rule.rule_id = p_rule_id
4746: AND rule.org_wide_flag = 'Y'
4747: AND (rule.intent, rule.org_id) in (select intent, org_id from okc_terms_templates_all where template_id = p_template_id)
4748:

Line 4753: FROM okc_xprt_rule_hdrs_all xrh,

4749: UNION ALL
4750:
4751: --template specific rules
4752: SELECT 'x'
4753: FROM okc_xprt_rule_hdrs_all xrh,
4754: okc_xprt_template_rules xtr
4755: WHERE xrh.rule_id = xtr.rule_id
4756: AND xrh.rule_id = p_rule_id
4757: AND template_id=p_template_id;

Line 4796: from okc_xprt_rule_hdrs_all

4792:
4793: IS
4794: CURSOR c1 is
4795: select 'x'
4796: from okc_xprt_rule_hdrs_all
4797: where org_wide_flag='Y';
4798: --Bug#4779070 commented below condition
4799: /*and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
4800: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,

Line 5898: UPDATE okc_xprt_rule_hdrs_all

5894:
5895: x_return_status := G_RET_STS_SUCCESS;
5896:
5897: -- Update Rule status
5898: UPDATE okc_xprt_rule_hdrs_all
5899: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
5900: published_flag = 'Y',
5901: last_updated_by = FND_GLOBAL.USER_ID,
5902: last_update_date = SYSDATE,

Line 5979: FROM okc_xprt_rule_hdrs_all

5975:
5976: -- Rules under Publication
5977: CURSOR csr_publish_rules IS
5978: SELECT rule_id
5979: FROM okc_xprt_rule_hdrs_all
5980: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
5981:
5982: -- Rules attached to template
5983: CURSOR csr_approval_rules IS

Line 5987: okc_xprt_rule_hdrs_all h

5983: CURSOR csr_approval_rules IS
5984: -- Local Rules on Template
5985: SELECT r.rule_id
5986: FROM okc_xprt_template_rules r,
5987: okc_xprt_rule_hdrs_all h
5988: WHERE r.rule_id = h.rule_id
5989: AND h.status_code = 'ACTIVE'
5990: AND r.template_id = p_template_id
5991: UNION ALL

Line 5994: okc_xprt_rule_hdrs_all h

5990: AND r.template_id = p_template_id
5991: UNION ALL
5992: SELECT h.rule_id
5993: FROM okc_terms_templates_all t,
5994: okc_xprt_rule_hdrs_all h
5995: WHERE t.org_id = h.org_id
5996: AND t.intent = h.intent
5997: AND h.status_code = 'ACTIVE'
5998: AND NVL(h.org_wide_flag,'N') = 'Y'

Line 7815: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

7811: l_api_version CONSTANT NUMBER := 1;
7812: l_api_name CONSTANT VARCHAR2(30) := 'populate_terms_deviations_tbl';
7813:
7814: j BINARY_INTEGER :=0;
7815: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
7816: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
7817: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
7818: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
7819:

Line 7816: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;

7812: l_api_name CONSTANT VARCHAR2(30) := 'populate_terms_deviations_tbl';
7813:
7814: j BINARY_INTEGER :=0;
7815: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
7816: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
7817: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
7818: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
7819:
7820: l_article_id NUMBER;

Line 7840: FROM okc_xprt_rule_hdrs_all

7836: --
7837: CURSOR l_get_rul_details_csr (p_rule_id NUMBER) IS
7838: SELECT rule_name,
7839: rule_description
7840: FROM okc_xprt_rule_hdrs_all
7841: WHERE rule_id = p_rule_id;
7842:
7843: --
7844: -- Currsor to Select Item name and Description

Line 9983: okc_xprt_rule_hdrs_all rhdr

9979:
9980: CURSOR csr_rules(p_org_id NUMBER, p_intent VARCHAR2) IS
9981: SELECT tr.rule_id
9982: FROM okc_xprt_template_rules tr,
9983: okc_xprt_rule_hdrs_all rhdr
9984: WHERE tr.rule_id = rhdr.rule_id
9985: AND tr.template_id = p_template_id
9986: AND rhdr.rule_type = p_rule_type
9987: AND rhdr.status_code IN ('ACTIVE','PENDING_PUB')

Line 9991: okc_xprt_rule_hdrs_all r

9987: AND rhdr.status_code IN ('ACTIVE','PENDING_PUB')
9988: UNION ALL
9989: SELECT r.rule_id
9990: FROM OKC_TERMS_TEMPLATES_ALL t,
9991: okc_xprt_rule_hdrs_all r
9992: WHERE t.org_id = p_org_id
9993: AND t.intent = p_intent
9994: AND r.rule_type = p_rule_type
9995: AND r.status_code IN ('ACTIVE','PENDING_PUB')