APPS.CZ_RULE_IMPORT dependencies on CZ_RULES

Line 379: ' FROM cz_rules ' ||

375: t_reason_id table_of_number;
376:
377: resolveRuleId VARCHAR2(4000) :=
378: 'SELECT rule_id ' ||
379: ' FROM cz_rules ' ||
380: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
381: ' AND devl_project_id = :1 ' ||
382: ' AND orig_sys_ref = :2';
383:

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

410:
411: IF((last_id_allocated IS NULL) OR
412: (next_id_to_use = (NVL(last_id_allocated, 0) + id_increment)))THEN
413:
414: SELECT cz_rules_s.NEXTVAL INTO last_id_allocated FROM dual;
415: next_id_to_use := last_id_allocated;
416: END IF;
417:
418: id_to_return := next_id_to_use;

Line 736: INSERT INTO cz_rules

732: --FORALL i IN 1..t_rule_id.COUNT does not work in 8i because rule_text and noted are CLOB columns.
733:
734: FOR i IN 1..t_rule_id.COUNT LOOP
735:
736: INSERT INTO cz_rules
737: (rule_id, reason_id, rule_folder_id, devl_project_id, invalid_flag, desc_text,
738: name, rule_type, expr_rule_type, component_id, model_ref_expl_id, reason_type,
739: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
740: effective_usage_mask, seq_nbr, effective_from, effective_until, effectivity_set_id,

Line 872: UPDATE cz_rules SET

868: --FORALL i IN 1..t_rule_id.COUNT does not work in 8i because rule_text and noted are CLOB columns.
869:
870: FOR i IN 1..t_rule_id.COUNT LOOP
871:
872: UPDATE cz_rules SET
873: reason_id = t_reason_id(i),
874: rule_folder_id = t_rule_folder_id(i),
875: devl_project_id = t_devl_project_id(i),
876: invalid_flag = t_invalid_flag(i),

Line 1013: INSERT INTO cz_rules

1009: BEGIN
1010:
1011: SAVEPOINT insert_rule_record;
1012:
1013: INSERT INTO cz_rules
1014: (rule_id, reason_id, rule_folder_id, devl_project_id, invalid_flag, desc_text,
1015: name, rule_type, expr_rule_type, component_id, model_ref_expl_id, reason_type,
1016: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
1017: effective_usage_mask, seq_nbr, effective_from, effective_until, effectivity_set_id,

Line 1079: UPDATE cz_rules SET

1075: BEGIN
1076:
1077: SAVEPOINT update_rule_record;
1078:
1079: UPDATE cz_rules SET
1080: reason_id = t_reason_id(i),
1081: rule_folder_id = t_rule_folder_id(i),
1082: devl_project_id = t_devl_project_id(i),
1083: invalid_flag = t_invalid_flag(i),