APPS.CZ_IMP_MGR dependencies on CZ_XFR_RUN_INFOS

Line 38: l_str := 'DELETE FROM cz_xfr_run_infos WHERE run_id = :1';

34: END IF;
35: END LOOP;
36: l_str := 'DELETE FROM cz_xfr_run_results WHERE run_id = :1';
37: EXECUTE IMMEDIATE l_str USING p_run_id_tbl(i);
38: l_str := 'DELETE FROM cz_xfr_run_infos WHERE run_id = :1';
39: EXECUTE IMMEDIATE l_str USING p_run_id_tbl(i);
40: END LOOP;
41: END IF;
42: COMMIT;

Line 55: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_INFOS';

51: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
52: FOR i IN (SELECT table_name FROM dba_tables WHERE table_name like 'CZ_IMP%' AND owner = UPPER(l_schema_owner)) LOOP
53: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'|| i.table_name;
54: END LOOP;
55: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_INFOS';
56: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_RESULTS';
57: COMMIT;
58: DBMS_APPLICATION_INFO.SET_MODULE('','');
59: EXCEPTION

Line 78: FROM cz_xfr_run_infos

74: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
75: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
76: l_run_id_tbl.DELETE;
77: SELECT run_id BULK COLLECT INTO l_run_id_tbl
78: FROM cz_xfr_run_infos
79: WHERE TRUNC(started) < (SELECT TRUNC(SYSDATE) - p_days FROM DUAL);
80: IF (l_run_id_tbl.COUNT > 0) THEN
81: delete_runs(l_run_id_tbl);
82: END IF;

Line 105: FROM cz_xfr_run_infos

101: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
102: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
103: l_run_id_tbl.DELETE;
104: SELECT run_id BULK COLLECT INTO l_run_id_tbl
105: FROM cz_xfr_run_infos
106: WHERE run_id <= p_run_id;
107: IF (l_run_id_tbl.COUNT > 0) THEN
108: delete_runs(l_run_id_tbl);
109: END IF;