APPS.CZ_IMP_MGR dependencies on CZ_ADMIN

Line 50: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

46: IS
47: l_schema_owner dba_tables.owner%TYPE := 'CZ';
48: l_error BOOLEAN;
49: BEGIN
50: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
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;

Line 60: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

56: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_RESULTS';
57: COMMIT;
58: DBMS_APPLICATION_INFO.SET_MODULE('','');
59: EXCEPTION
60: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
61: l_error := cz_utils.log_report(cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'CZ_IMP_MGR.PURGE',11276);
62: RAISE;
63: WHEN OTHERS THEN
64: l_error:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_MGR.PURGE',11276);

Line 74: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

70: IS
71: l_run_id_tbl tRunId;
72: l_error BOOLEAN;
73: BEGIN
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

Line 87: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

83: DBMS_APPLICATION_INFO.SET_MODULE('','');
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
86: DBMS_APPLICATION_INFO.SET_MODULE('','');
87: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
88: l_error := cz_utils.log_report(cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'CZ_IMP_MGR.PURGE',11276);
89: RAISE;
90: WHEN OTHERS THEN
91: l_error:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_MGR.PURGE_to_date',11276);

Line 101: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

97: IS
98: l_run_id_tbl tRunId;
99: l_error BOOLEAN;
100: BEGIN
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

Line 114: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

110: DBMS_APPLICATION_INFO.SET_MODULE('','');
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN
113: DBMS_APPLICATION_INFO.SET_MODULE('','');
114: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
115: l_error := cz_utils.log_report(cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'CZ_IMP_MGR.PURGE',11276);
116: RAISE;
117: WHEN OTHERS THEN
118: l_error:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_MGR.PURGE_TO_RUNID',11276);

Line 129: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

125: BEGIN
126: retcode := G_CONCURRENT_SUCCESS;
127: purge;
128: EXCEPTION
129: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
130: retcode := G_CONCURRENT_ERROR;
131: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
132: WHEN OTHERS THEN
133: retcode := G_CONCURRENT_ERROR;

Line 145: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

141: BEGIN
142: retcode := G_CONCURRENT_SUCCESS;
143: purge_to_date(p_days);
144: EXCEPTION
145: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
146: retcode := G_CONCURRENT_ERROR;
147: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
148: WHEN OTHERS THEN
149: retcode := G_CONCURRENT_ERROR;

Line 161: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN

157: BEGIN
158: retcode := G_CONCURRENT_SUCCESS;
159: purge_to_runid(p_run_id);
160: EXCEPTION
161: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
162: retcode := G_CONCURRENT_ERROR;
163: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
164: WHEN OTHERS THEN
165: retcode := G_CONCURRENT_ERROR;