APPS.CZ_RULE_IMPORT dependencies on CZ_RULES_S

Line 501: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;

497:
498: IF((last_id_allocated IS NULL) OR
499: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
500:
501: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;
502: next_id_to_use := last_id_allocated;
503: END IF;
504:
505: id_to_return := next_id_to_use;

Line 1172: UPDATE cz_rules SET

1168: FOR i IN 1..t_rule_id.COUNT LOOP
1169:
1170: -- Bug 9793987 , Need to retain the original Reason id /Intl text id, if no localized messages are imported in this run.
1171:
1172: UPDATE cz_rules SET
1173: reason_id = NVL(t_reason_id(i), reason_id) ,
1174: rule_folder_id = t_rule_folder_id(i),
1175: devl_project_id = t_devl_project_id(i),
1176: invalid_flag = t_invalid_flag(i),

Line 1399: UPDATE cz_rules SET

1395:
1396: SAVEPOINT update_rule_record;
1397:
1398: -- Bug 9793987 , Need to retain the original Reason id /Intl text id, if no localized messages are imported in this run.
1399: UPDATE cz_rules SET
1400: reason_id = NVL(t_reason_id(i), reason_id) ,
1401: rule_folder_id = t_rule_folder_id(i),
1402: devl_project_id = t_devl_project_id(i),
1403: invalid_flag = t_invalid_flag(i),