APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_TEMPLATE_RULES

Line 1955: FROM okc_xprt_template_rules

1951:
1952: CURSOR cur_dup_template
1953: IS
1954: SELECT 'Y'
1955: FROM okc_xprt_template_rules
1956: WHERE template_id = p_template_rules_rec.template_id
1957: AND rule_id = g_rule_id
1958: AND deleted_flag = NVL (p_template_rules_rec.deleted_flag, 'N');
1959:

Line 1964: /*SELECT okc_xprt_template_rules_s.NEXTVAL

1960: l_val_flag VARCHAR2 (1);
1961: l_dup_flag VARCHAR2 (1);
1962: BEGIN
1963: -- Default
1964: /*SELECT okc_xprt_template_rules_s.NEXTVAL
1965: INTO p_template_rules_rec.template_rule_id
1966: FROM DUAL;*/
1967: p_template_rules_rec.rule_id := g_rule_id;
1968: p_template_rules_rec.deleted_flag := 'N';

Line 2023: INSERT INTO okc_xprt_template_rules

2019: RAISE fnd_api.g_exc_error;
2020: END IF;
2021:
2022: -- Insert
2023: INSERT INTO okc_xprt_template_rules
2024: (template_rule_id,
2025: template_id,
2026: rule_id,
2027: deleted_flag,

Line 2036: VALUES (okc_xprt_template_rules_s.NEXTVAL,

2032: last_updated_by,
2033: last_update_date,
2034: last_update_login
2035: )
2036: VALUES (okc_xprt_template_rules_s.NEXTVAL,
2037: p_template_rules_rec.template_id,
2038: p_template_rules_rec.rule_id,
2039: p_template_rules_rec.deleted_flag,
2040: p_template_rules_rec.published_flag,

Line 2446: DELETE FROM okc_xprt_template_rules

2442: -- Delete the Template Assignments if any.
2443: -- Same as changing the org wide flag from UI when the staus is 'DRAFT'.
2444: l_progress := '140';
2445:
2446: DELETE FROM okc_xprt_template_rules
2447: WHERE rule_id = p_rule_header_rec.rule_id;
2448: END IF;
2449:
2450: l_progress := '150';

Line 2856: FROM okc_xprt_template_rules

2852:
2853: BEGIN
2854: SELECT 'Y'
2855: INTO l_flag
2856: FROM okc_xprt_template_rules
2857: WHERE rule_id = p_rule_child_entities_rec.rule_id
2858: AND template_rule_id =
2859: p_rule_child_entities_rec.template_rule_id_tbl (i)
2860: AND ROWNUM = 1;

Line 2879: DELETE FROM okc_xprt_template_rules

2875: --As of now Commenting out the validation */
2876:
2877: -- Delete
2878: FORALL i IN INDICES OF p_rule_child_entities_rec.template_rule_id_tbl
2879: DELETE FROM okc_xprt_template_rules
2880: WHERE 1 = 1
2881: AND template_rule_id =
2882: p_rule_child_entities_rec.template_rule_id_tbl (i);
2883: END IF;