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_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 700: FROM okc_xprt_rule_hdrs_all r

696: r.rule_name,
697: r.rule_description,
698: DECODE(p_mode,'P','0','D','1') deleted_flag,
699: r.rule_type
700: FROM okc_xprt_rule_hdrs_all r
701: WHERE r.rule_id = p_rule_id ;
702:
703: CURSOR csr_template_dtls IS
704: SELECT template_name,

Line 730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

726: FROM FND_LANGUAGES L
727: WHERE L.INSTALLED_FLAG IN ('I', 'B');
728:
729: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;

Line 731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

727: WHERE L.INSTALLED_FLAG IN ('I', 'B');
728:
729: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;

Line 732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

728:
729: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

Line 733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

729: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
737:

Line 734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;

730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
737:
738: l_rule_text cz_imp_rules.rule_text%TYPE;

Line 735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;

731: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
737:
738: l_rule_text cz_imp_rules.rule_text%TYPE;
739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

Line 1230: FROM okc_xprt_rule_hdrs_all

1226: -- Rules to be Published
1227: CURSOR csr_rules IS
1228: SELECT rule_id,
1229: published_flag
1230: FROM okc_xprt_rule_hdrs_all
1231: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1232:
1233: -- Templates Attached to each Rule
1234: CURSOR csr_templates(p_rule_id IN NUMBER) IS

Line 1248: okc_xprt_rule_hdrs_all r

1244: UNION ALL
1245: -- Org Wide Rules
1246: SELECT t.template_id
1247: FROM OKC_TERMS_TEMPLATES_ALL t,
1248: okc_xprt_rule_hdrs_all r
1249: WHERE t.org_id = r.org_id
1250: AND t.intent = r.intent
1251: AND t.contract_expert_enabled = 'Y'
1252: AND t.status_code IN ('APPROVED','ON_HOLD')

Line 1288: okc_xprt_rule_hdrs_all r

1284: UNION ALL
1285: -- Org Wide Rules
1286: SELECT to_char(t.template_id)
1287: FROM OKC_TERMS_TEMPLATES_ALL t,
1288: okc_xprt_rule_hdrs_all r
1289: --,okc_xprt_template_rules tr -- Added for Bug 5005681
1290: WHERE t.org_id = r.org_id
1291: --AND tr.template_id = t.template_id -- Added for Bug 5005681
1292: --AND tr.rule_id = r.rule_id -- Added for Bug 5005681

Line 1309: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;

1305:
1306: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1307: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1308: l_template_id okc_xprt_template_rules.template_id%TYPE;
1309: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;
1310:
1311:
1312: BEGIN
1313: -- start debug log

Line 1470: FROM okc_xprt_rule_hdrs_all

1466:
1467: -- Rules to be Disabled
1468: CURSOR csr_rules IS
1469: SELECT rule_id
1470: FROM okc_xprt_rule_hdrs_all
1471: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1472:
1473: /*
1474: In case of rules to be disabled we look at the template assciation of the rule is CZ

Line 1631: okc_xprt_rule_hdrs_all h

1627: CURSOR csr_template_rules IS
1628: -- Local Active Rules for template
1629: SELECT r.rule_id
1630: FROM okc_xprt_template_rules r,
1631: okc_xprt_rule_hdrs_all h
1632: WHERE r.rule_id = h.rule_id
1633: AND h.status_code = 'ACTIVE'
1634: AND NVL(r.deleted_flag,'N') = 'N'
1635: AND r.template_id = p_template_id

Line 1640: okc_xprt_rule_hdrs_all r

1636: UNION ALL
1637: -- Global Active Rules for the template
1638: SELECT r.rule_id
1639: FROM OKC_TERMS_TEMPLATES_ALL t,
1640: okc_xprt_rule_hdrs_all r
1641: WHERE t.org_id = r.org_id
1642: AND t.intent = r.intent
1643: AND NVL(r.org_wide_flag,'N') = 'Y'
1644: AND r.status_code = 'ACTIVE'

Line 1652: okc_xprt_rule_hdrs_all h

1648: -- Local Active Rules on Parent Template to be deleted
1649: -- Delete rules on parent template and not on the revision template
1650: SELECT r.rule_id
1651: FROM okc_xprt_template_rules r,
1652: okc_xprt_rule_hdrs_all h
1653: WHERE r.rule_id = h.rule_id
1654: AND h.status_code = 'ACTIVE'
1655: AND NVL(r.deleted_flag,'N') = 'N'
1656: AND r.template_id = p_parent_tmpl_id

Line 1661: okc_xprt_rule_hdrs_all h

1657: MINUS
1658: -- current local rules on revision template
1659: SELECT r.rule_id
1660: FROM okc_xprt_template_rules r,
1661: okc_xprt_rule_hdrs_all h
1662: WHERE r.rule_id = h.rule_id
1663: AND h.status_code = 'ACTIVE'
1664: AND NVL(r.deleted_flag,'N') = 'N'
1665: AND r.template_id = p_template_id ;

Line 1930: FROM okc_xprt_rule_hdrs_all r

1926:
1927: -- Added Org_id to the cusor for R12
1928: CURSOR csr_intents IS
1929: SELECT distinct intent, org_id
1930: FROM okc_xprt_rule_hdrs_all r
1931: WHERE r.request_id = fnd_global.conc_request_id;
1932:
1933: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
1934: SELECT devl_project_id, orig_sys_ref

Line 1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

1950: FROM FND_LANGUAGES L
1951: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1952:
1953: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;

Line 1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

1951: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1952:
1953: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;

Line 1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

1952:
1953: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%TYPE;

Line 2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

2389: FROM FND_LANGUAGES L
2390: WHERE L.INSTALLED_FLAG IN ('I', 'B');
2391:
2392: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;

Line 2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

2390: WHERE L.INSTALLED_FLAG IN ('I', 'B');
2391:
2392: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;

Line 2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;

2391:
2392: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%TYPE;