1312: );
1313:
1314: -- Generate Run Id for Rule Import
1315: CURSOR csr_cz_run_id IS
1316: SELECT cz_xfr_run_infos_s.NEXTVAL
1317: FROM dual;
1318:
1319:
1320: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1502: AND rule_type = 200; --Added for perf Bug#5032335
1503:
1504: -- Generate Run Id for Rule Import
1505: CURSOR csr_cz_run_id IS
1506: SELECT cz_xfr_run_infos_s.NEXTVAL
1507: FROM dual;
1508:
1509:
1510: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1685:
1686:
1687: -- Generate Run Id for Rule Import
1688: CURSOR csr_cz_run_id IS
1689: SELECT cz_xfr_run_infos_s.NEXTVAL
1690: FROM dual;
1691:
1692:
1693: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';