APPS.CZ_RULE_IMPORT dependencies on CZ_RULES

Line 454: ' FROM cz_rules ' ||

450:
451:
452: resolveRuleId VARCHAR2(4000) :=
453: 'SELECT rule_id, rule_text, devl_project_id,orig_sys_ref, rule_folder_id, rule_type,name ' ||
454: ' FROM cz_rules ' ||
455: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
456: ' AND devl_project_id = :1 ' ||
457: ' AND orig_sys_ref = :2';
458:

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 599: FROM cz_rules

595: ELSE
596: BEGIN
597: SELECT class_seq
598: INTO v_rule_class_chk
599: FROM cz_rules
600: WHERE devl_project_id = t_devl_project_id(i)
601: AND rule_class= t_rule_class(i)
602: AND class_seq = t_class_seq(i)
603: AND deleted_flag = CZRI_FLAG_NOT_DELETED;

Line 1022: INSERT INTO cz_rules

1018: --FORALL i IN 1..t_rule_id.COUNT does not work in 8i because rule_text and noted are CLOB columns.
1019:
1020: FOR i IN 1..t_rule_id.COUNT LOOP
1021:
1022: INSERT INTO cz_rules
1023: (rule_id, reason_id, rule_folder_id, devl_project_id, invalid_flag, desc_text,
1024: name, rule_type, expr_rule_type, component_id, model_ref_expl_id, reason_type,
1025: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
1026: effective_usage_mask, seq_nbr, effective_from, effective_until, effectivity_set_id,

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 1331: INSERT INTO cz_rules

1327:
1328: BEGIN
1329:
1330: SAVEPOINT insert_rule_record;
1331: INSERT INTO cz_rules
1332: (rule_id, reason_id, rule_folder_id, devl_project_id, invalid_flag, desc_text,
1333: name, rule_type, expr_rule_type, component_id, model_ref_expl_id, reason_type,
1334: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
1335: effective_usage_mask, seq_nbr, effective_from, effective_until, effectivity_set_id,

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),

Line 2824: WHERE intl_text_id = (SELECT reason_id from cz_rules where rule_id = t_rules_id(i));

2820:
2821: FORALL i IN 1..t_rowid.COUNT
2822: UPDATE cz_localized_texts
2823: SET localized_str = t_text_str(i)
2824: WHERE intl_text_id = (SELECT reason_id from cz_rules where rule_id = t_rules_id(i));
2825: RETURN TRUE;
2826:
2827: EXCEPTION
2828: WHEN OTHERS THEN

Line 2855: UPDATE CZ_RULES

2851: (last_update_login, text_str, intl_text_id, deleted_flag, model_id)
2852: VALUES
2853: (t_last_update_login(i), t_text_str(i), cz_intl_texts_s.NEXTVAL, 0, t_model_id(i)) ;
2854:
2855: UPDATE CZ_RULES
2856: SET reason_id = cz_intl_texts_s.currval
2857: WHERE devl_project_id = t_model_id(i)
2858: AND rule_id = t_rules_id(i);
2859:

Line 2877: WHERE intl_text_id = (SELECT reason_id from cz_rules where rule_id = t_rules_id(i));

2873: SAVEPOINT update_msg_record;
2874:
2875: UPDATE cz_localized_texts
2876: SET localized_str = t_text_str(i)
2877: WHERE intl_text_id = (SELECT reason_id from cz_rules where rule_id = t_rules_id(i));
2878:
2879: EXCEPTION
2880: WHEN OTHERS THEN
2881: ROLLBACK TO update_msg_record;