DBA Data[Home] [Help]

APPS.CZ_RULE_IMPORT dependencies on CZ_XFR_RUN_RESULTS

Line 1199: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)

1195: AND rec_status IS NOT NULL
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;

Line 1222: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;

1218:
1219: v_debug NUMBER := 11000;
1220: BEGIN
1221:
1222: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;
1223: rpt_rules(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
1224: END;
1225: ---------------------------------------------------------------------------------------
1226: PROCEDURE import_rules(p_api_version IN NUMBER,

Line 1961: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)

1957: AND rec_status IS NOT NULL
1958: AND disposition IS NOT NULL
1959: GROUP BY disposition, rec_status) LOOP
1960:
1961: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)
1962: VALUES (p_run_id, 'CZ_IMP_LOCALIZED_TEXTS', c_stat.disposition, c_stat.rec_status, c_stat.records);
1963: END LOOP;
1964:
1965: COMMIT;

Line 1984: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;

1980:
1981: v_debug NUMBER := 10000;
1982: BEGIN
1983:
1984: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;
1985: rpt_localized_texts(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
1986: END;
1987: ---------------------------------------------------------------------------------------
1988: PROCEDURE import_localized_texts(p_api_version IN NUMBER,