eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_RULE_IMPORT dependencies on CZ_IMP_RULES

Line 37: FROM cz_imp_rules

33: name, seeded_flag, deleted_flag, mutable_flag, disabled_flag, invalid_flag,
34: presentation_flag, effective_usage_mask, seq_nbr, disposition,
35: component_id, model_ref_expl_id, fsk_component_id, fsk_model_ref_expl_id,
36: instantiation_scope
37: FROM cz_imp_rules
38: WHERE run_id = p_run_id
39: AND rec_status IS NULL
40: AND disposition IS NULL;
41:

Line 104: UPDATE cz_imp_rules SET

100: PROCEDURE update_table_data(p_upper_limit IN PLS_INTEGER) IS
101: BEGIN
102:
103: FORALL i IN 1..p_upper_limit
104: UPDATE cz_imp_rules SET
105: message = t_message(i),
106: seeded_flag = t_seeded_flag(i),
107: deleted_flag = t_deleted_flag(i),
108: rec_status = CZRI_RECSTATUS_CND,

Line 358: FROM cz_imp_rules

354:
355: CURSOR c_rec IS
356: SELECT ROWID, rule_id, devl_project_id, message, orig_sys_ref, rec_status, disposition,
357: fsk_localized_text_1, fsk_component_id, fsk_model_ref_expl_id, rule_type, reason_id
358: FROM cz_imp_rules
359: WHERE run_id = p_run_id
360: AND rec_status = CZRI_RECSTATUS_CND
361: AND disposition = CZRI_DISPOSITION_PASSED
362: ORDER BY devl_project_id, orig_sys_ref;

Line 384: last_orig_sys_ref cz_imp_rules.orig_sys_ref%TYPE;

380: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
381: ' AND devl_project_id = :1 ' ||
382: ' AND orig_sys_ref = :2';
383:
384: last_orig_sys_ref cz_imp_rules.orig_sys_ref%TYPE;
385: last_project_id cz_imp_rules.devl_project_id%TYPE;
386:
387: last_id_allocated NUMBER := NULL;
388: next_id_to_use NUMBER := 0;

Line 385: last_project_id cz_imp_rules.devl_project_id%TYPE;

381: ' AND devl_project_id = :1 ' ||
382: ' AND orig_sys_ref = :2';
383:
384: last_orig_sys_ref cz_imp_rules.orig_sys_ref%TYPE;
385: last_project_id cz_imp_rules.devl_project_id%TYPE;
386:
387: last_id_allocated NUMBER := NULL;
388: next_id_to_use NUMBER := 0;
389: id_increment NUMBER := CZRI_RULES_INC;

Line 398: UPDATE cz_imp_rules SET

394: PROCEDURE update_table_data(p_upper_limit IN PLS_INTEGER) IS
395: BEGIN
396:
397: FORALL i IN 1..p_upper_limit
398: UPDATE cz_imp_rules SET
399: rule_id = t_rule_id(i),
400: reason_id = t_reason_id(i),
401: message = t_message(i),
402: rec_status = CZRI_RECSTATUS_KRS,

Line 577: FROM cz_imp_rules

573: unsatisfied_msg_id, unsatisfied_msg_source, signature_id, template_primitive_flag,
574: presentation_flag, template_token, rule_text, notes, class_name, instantiation_scope,
575: mutable_flag, seeded_flag, ui_def_id, ui_page_id, ui_page_element_id, rule_folder_type,
576: disposition, message
577: FROM cz_imp_rules
578: WHERE run_id = p_run_id
579: AND rec_status = CZRI_RECSTATUS_KRS
580: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY);
581:

Line 632: UPDATE cz_imp_rules SET

628: --We updating rec_status to XFR, not OK, because the rules still have to be parsed.
629: --When parsed successfully, the status will be changed to OK.
630:
631: FORALL i IN 1..p_upper_limit
632: UPDATE cz_imp_rules SET
633: message = t_message(i),
634: rec_status = CZRI_RECSTATUS_XFR,
635: disposition = t_disposition(i)
636: WHERE ROWID = t_rowid(i);

Line 1193: FROM cz_imp_rules

1189:
1190: v_debug NUMBER := 9000;
1191: BEGIN
1192: FOR c_stat IN (SELECT disposition, rec_status, COUNT(*) as records
1193: FROM cz_imp_rules
1194: WHERE run_id = p_run_id
1195: AND rec_status IS NOT NULL
1196: AND disposition IS NOT NULL
1197: GROUP BY disposition, rec_status) LOOP

Line 1200: VALUES (p_run_id, 'CZ_IMP_RULES', c_stat.disposition, c_stat.rec_status, c_stat.records);

1196: AND disposition IS NOT NULL
1197: GROUP BY disposition, rec_status) LOOP
1198:
1199: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)
1200: VALUES (p_run_id, 'CZ_IMP_RULES', c_stat.disposition, c_stat.rec_status, c_stat.records);
1201: END LOOP;
1202:
1203: COMMIT;
1204: EXCEPTION

Line 2123: UPDATE cz_imp_rules SET run_id = p_run_id

2119: IF(p_run_id IS NULL)THEN
2120:
2121: SELECT cz_xfr_run_infos_s.NEXTVAL INTO p_run_id FROM DUAL;
2122:
2123: UPDATE cz_imp_rules SET run_id = p_run_id
2124: WHERE disposition IS NULL
2125: AND rec_status IS NULL
2126: AND run_id IS NULL;
2127:

Line 2139: (SELECT NULL FROM cz_imp_rules WHERE run_id = p_run_id);

2135:
2136: BEGIN
2137:
2138: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2139: (SELECT NULL FROM cz_imp_rules WHERE run_id = p_run_id);
2140:
2141: EXCEPTION
2142: WHEN NO_DATA_FOUND THEN
2143: v_error_flag := 0;

Line 2200: (SELECT NULL FROM cz_imp_rules

2196:
2197: BEGIN
2198:
2199: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2200: (SELECT NULL FROM cz_imp_rules
2201: WHERE run_id = p_run_id
2202: AND rec_status = CZRI_RECSTATUS_XFR
2203: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY));
2204:

Line 2282: FROM cz_imp_rules

2278: SELECT distinct devl_project_id
2279: BULK
2280: COLLECT
2281: INTO l_model_id_tbl
2282: FROM cz_imp_rules
2283: WHERE rec_status IS NULL
2284: AND disposition IS NULL
2285: AND run_id IS NULL;
2286: ELSE

Line 2291: FROM cz_imp_rules

2287: SELECT distinct devl_project_id
2288: BULK
2289: COLLECT
2290: INTO l_model_id_tbl
2291: FROM cz_imp_rules
2292: WHERE rec_status IS NULL
2293: AND disposition IS NULL
2294: AND run_id = p_run_id;
2295: END IF;