DBA Data[Home] [Help]

APPS.CZ_RULE_IMPORT dependencies on CZ_XFR_RUN_RESULTS

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

1542: AND rec_status IS NOT NULL
1543: AND disposition IS NOT NULL
1544: GROUP BY disposition, rec_status) LOOP
1545:
1546: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)
1547: VALUES (p_run_id, 'CZ_IMP_RULES', c_stat.disposition, c_stat.rec_status, c_stat.records);
1548: END LOOP;
1549:
1550: COMMIT;

Line 1569: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;

1565:
1566: v_debug NUMBER := 11000;
1567: BEGIN
1568:
1569: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;
1570: rpt_rules(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
1571: END;
1572: ---------------------------------------------------------------------------------------
1573: PROCEDURE import_rules(p_api_version IN NUMBER,

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

2377: AND rec_status IS NOT NULL
2378: AND disposition IS NOT NULL
2379: GROUP BY disposition, rec_status) LOOP
2380:
2381: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)
2382: VALUES (p_run_id, 'CZ_IMP_LOCALIZED_TEXTS', c_stat.disposition, c_stat.rec_status, c_stat.records);
2383: END LOOP;
2384:
2385: COMMIT;

Line 2404: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;

2400:
2401: v_debug NUMBER := 10000;
2402: BEGIN
2403:
2404: DELETE FROM cz_xfr_run_results WHERE run_id = p_run_id;
2405: rpt_localized_texts(p_api_version, p_run_id, x_return_status, x_msg_count, x_msg_data);
2406: END;
2407: ---------------------------------------------------------------------------------------
2408: PROCEDURE import_localized_texts(p_api_version IN NUMBER,