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

Line 78: FROM okc_xprt_rule_hdrs_all

74: SELECT org_id,
75: intent,
76: DECODE(condition_expr_code,'ALL','AND','OR'),
77: rule_type
78: FROM okc_xprt_rule_hdrs_all
79: WHERE rule_id = p_rule_id;
80:
81: --DECODE(SUBSTR(rcon.object_code,1,3),'OKC',rcon.object_code,'USER$' || rcon.object_code) variable_code
82: CURSOR csr_rule_conditions IS

Line 122: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

118: FROM okc_xprt_rule_outcomes
119: WHERE rule_id = p_rule_id;
120:
121: l_api_name CONSTANT VARCHAR2(30) := 'build_statement_rule';
122: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
123: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;
125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:

Line 123: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

119: WHERE rule_id = p_rule_id;
120:
121: l_api_name CONSTANT VARCHAR2(30) := 'build_statement_rule';
122: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
123: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;
125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;

Line 124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;

120:
121: l_api_name CONSTANT VARCHAR2(30) := 'build_statement_rule';
122: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
123: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;
125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;

Line 125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;

121: l_api_name CONSTANT VARCHAR2(30) := 'build_statement_rule';
122: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
123: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
124: l_condition_expr_code okc_xprt_rule_hdrs_all.condition_expr_code%TYPE;
125: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
126:
127: l_rule_condition_id okc_xprt_rule_conditions.rule_condition_id%TYPE;
128: l_object_type okc_xprt_rule_conditions.object_type%TYPE;
129: l_object_code okc_xprt_rule_conditions.object_code%TYPE;

Line 714: FROM okc_xprt_rule_hdrs_all r

710: r.rule_name,
711: r.rule_description,
712: DECODE(p_mode,'P','0','D','1') deleted_flag,
713: r.rule_type
714: FROM okc_xprt_rule_hdrs_all r
715: WHERE r.rule_id = p_rule_id ;
716:
717: CURSOR csr_template_dtls IS
718: SELECT template_name,

Line 744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

740: FROM FND_LANGUAGES L
741: WHERE L.INSTALLED_FLAG IN ('I', 'B');
742:
743: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;

Line 745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

741: WHERE L.INSTALLED_FLAG IN ('I', 'B');
742:
743: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;

Line 746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

742:
743: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

Line 747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

743: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
751:

Line 748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;

744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
751:
752: l_rule_text cz_imp_rules.rule_text%TYPE;

Line 749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;

745: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
751:
752: l_rule_text cz_imp_rules.rule_text%TYPE;
753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

Line 1244: FROM okc_xprt_rule_hdrs_all

1240: -- Rules to be Published
1241: CURSOR csr_rules IS
1242: SELECT rule_id,
1243: published_flag
1244: FROM okc_xprt_rule_hdrs_all
1245: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1246:
1247: -- Templates Attached to each Rule
1248: CURSOR csr_templates(p_rule_id IN NUMBER) IS

Line 1262: okc_xprt_rule_hdrs_all r

1258: UNION ALL
1259: -- Org Wide Rules
1260: SELECT t.template_id
1261: FROM OKC_TERMS_TEMPLATES_ALL t,
1262: okc_xprt_rule_hdrs_all r
1263: WHERE t.org_id = r.org_id
1264: AND t.intent = r.intent
1265: AND t.contract_expert_enabled = 'Y'
1266: AND t.status_code IN ('APPROVED','ON_HOLD')

Line 1302: okc_xprt_rule_hdrs_all r

1298: UNION ALL
1299: -- Org Wide Rules
1300: SELECT to_char(t.template_id)
1301: FROM OKC_TERMS_TEMPLATES_ALL t,
1302: okc_xprt_rule_hdrs_all r
1303: --,okc_xprt_template_rules tr -- Added for Bug 5005681
1304: WHERE t.org_id = r.org_id
1305: --AND tr.template_id = t.template_id -- Added for Bug 5005681
1306: --AND tr.rule_id = r.rule_id -- Added for Bug 5005681

Line 1323: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;

1319:
1320: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1321: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1322: l_template_id okc_xprt_template_rules.template_id%TYPE;
1323: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;
1324:
1325:
1326: BEGIN
1327: -- start debug log

Line 1484: FROM okc_xprt_rule_hdrs_all

1480:
1481: -- Rules to be Disabled
1482: CURSOR csr_rules IS
1483: SELECT rule_id
1484: FROM okc_xprt_rule_hdrs_all
1485: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1486:
1487: /*
1488: In case of rules to be disabled we look at the template assciation of the rule is CZ

Line 1645: okc_xprt_rule_hdrs_all h

1641: CURSOR csr_template_rules IS
1642: -- Local Active Rules for template
1643: SELECT r.rule_id
1644: FROM okc_xprt_template_rules r,
1645: okc_xprt_rule_hdrs_all h
1646: WHERE r.rule_id = h.rule_id
1647: AND h.status_code = 'ACTIVE'
1648: AND NVL(r.deleted_flag,'N') = 'N'
1649: AND r.template_id = p_template_id

Line 1654: okc_xprt_rule_hdrs_all r

1650: UNION ALL
1651: -- Global Active Rules for the template
1652: SELECT r.rule_id
1653: FROM OKC_TERMS_TEMPLATES_ALL t,
1654: okc_xprt_rule_hdrs_all r
1655: WHERE t.org_id = r.org_id
1656: AND t.intent = r.intent
1657: AND NVL(r.org_wide_flag,'N') = 'Y'
1658: AND r.status_code = 'ACTIVE'

Line 1666: okc_xprt_rule_hdrs_all h

1662: -- Local Active Rules on Parent Template to be deleted
1663: -- Delete rules on parent template and not on the revision template
1664: SELECT r.rule_id
1665: FROM okc_xprt_template_rules r,
1666: okc_xprt_rule_hdrs_all h
1667: WHERE r.rule_id = h.rule_id
1668: AND h.status_code = 'ACTIVE'
1669: AND NVL(r.deleted_flag,'N') = 'N'
1670: AND r.template_id = p_parent_tmpl_id

Line 1675: okc_xprt_rule_hdrs_all h

1671: MINUS
1672: -- current local rules on revision template
1673: SELECT r.rule_id
1674: FROM okc_xprt_template_rules r,
1675: okc_xprt_rule_hdrs_all h
1676: WHERE r.rule_id = h.rule_id
1677: AND h.status_code = 'ACTIVE'
1678: AND NVL(r.deleted_flag,'N') = 'N'
1679: AND r.template_id = p_template_id ;

Line 1944: FROM okc_xprt_rule_hdrs_all r

1940:
1941: -- Added Org_id to the cusor for R12
1942: CURSOR csr_intents IS
1943: SELECT distinct intent, org_id
1944: FROM okc_xprt_rule_hdrs_all r
1945: WHERE r.request_id = fnd_global.conc_request_id;
1946:
1947: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
1948: SELECT devl_project_id, orig_sys_ref

Line 1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

1964: FROM FND_LANGUAGES L
1965: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1966:
1967: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;

Line 1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

1965: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1966:
1967: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;

Line 1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

1966:
1967: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%TYPE;

Line 2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

2403: FROM FND_LANGUAGES L
2404: WHERE L.INSTALLED_FLAG IN ('I', 'B');
2405:
2406: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;

Line 2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

2404: WHERE L.INSTALLED_FLAG IN ('I', 'B');
2405:
2406: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;

Line 2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

2405:
2406: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%TYPE;