APPS.CN_IMP_RULE_PVT dependencies on CN_RULESETS

Line 13: -- cn_rulesets, cn_rules, cn_attributes, cn_rules_hierarchy

9: -- Start of comments
10: -- API name : Rules_Import
11: -- Type : Private.
12: -- Function : program to transfer data from staging table into
13: -- cn_rulesets, cn_rules, cn_attributes, cn_rules_hierarchy
14: -- Pre-reqs : None.
15: -- Parameters :
16: -- IN : p_imp_header_id IN NUMBER Required
17: -- OUT : errbuf OUT VARCHAR2 Required

Line 52: CURSOR c_is_ruleset_present_csr (l_name cn_rulesets.name%TYPE, l_start_date cn_rulesets.start_date%TYPE, l_end_date cn_rulesets.end_date%TYPE, l_module_type cn_rulesets.module_type%TYPE) IS

48: l_err_imp_line_id NUMBER;
49: l_org_id NUMBER;
50:
51: -- Cursor to check if the ruleset is present in the system
52: CURSOR c_is_ruleset_present_csr (l_name cn_rulesets.name%TYPE, l_start_date cn_rulesets.start_date%TYPE, l_end_date cn_rulesets.end_date%TYPE, l_module_type cn_rulesets.module_type%TYPE) IS
53: SELECT ruleset_id
54: FROM cn_rulesets
55: WHERE name = l_name
56: AND start_date = l_start_date

Line 54: FROM cn_rulesets

50:
51: -- Cursor to check if the ruleset is present in the system
52: CURSOR c_is_ruleset_present_csr (l_name cn_rulesets.name%TYPE, l_start_date cn_rulesets.start_date%TYPE, l_end_date cn_rulesets.end_date%TYPE, l_module_type cn_rulesets.module_type%TYPE) IS
53: SELECT ruleset_id
54: FROM cn_rulesets
55: WHERE name = l_name
56: AND start_date = l_start_date
57: AND end_date = l_end_date
58: AND module_type = l_module_type

Line 267: cn_rulesets_pkg.Sync_ruleset

263: GOTO end_of_ruleset_loop;
264:
265: END IF;
266: -- synchronize the package
267: cn_rulesets_pkg.Sync_ruleset
268: (x_ruleset_id_in => l_current_ruleset_id,
269: x_ruleset_status_in => l_return_status,
270: x_org_id => l_org_id);
271: