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_IMP_MGR dependencies on DBMS_APPLICATION_INFO

Line 51: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');

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;
55: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_INFOS';

Line 58: DBMS_APPLICATION_INFO.SET_MODULE('','');

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
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;

Line 65: DBMS_APPLICATION_INFO.SET_MODULE('','');

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);
65: DBMS_APPLICATION_INFO.SET_MODULE('','');
66: RAISE;
67: END purge;
68: -------------------------------------------
69: PROCEDURE purge_to_date(p_days IN NUMBER)

Line 75: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');

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
79: WHERE TRUNC(started) < (SELECT TRUNC(SYSDATE) - p_days FROM DUAL);

Line 83: DBMS_APPLICATION_INFO.SET_MODULE('','');

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;
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

Line 86: DBMS_APPLICATION_INFO.SET_MODULE('','');

82: END IF;
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

Line 92: DBMS_APPLICATION_INFO.SET_MODULE('','');

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);
92: DBMS_APPLICATION_INFO.SET_MODULE('','');
93: RAISE;
94: END purge_to_date;
95: -------------------------------------------
96: PROCEDURE purge_to_runid(p_run_id IN NUMBER)

Line 102: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');

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
106: WHERE run_id <= p_run_id;

Line 110: DBMS_APPLICATION_INFO.SET_MODULE('','');

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;
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

Line 113: DBMS_APPLICATION_INFO.SET_MODULE('','');

109: END IF;
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

Line 119: DBMS_APPLICATION_INFO.SET_MODULE('','');

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);
119: DBMS_APPLICATION_INFO.SET_MODULE('','');
120: RAISE;
121: END purge_to_runid;
122: -------------------------------------------
123: PROCEDURE purge_cp(errbuf IN OUT NOCOPY VARCHAR2,

Line 135: DBMS_APPLICATION_INFO.SET_MODULE('','');

131: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
132: WHEN OTHERS THEN
133: retcode := G_CONCURRENT_ERROR;
134: errbuf := cz_utils.get_text('CZ_PURGE_FATAL_ERR', 'SQLERRM',Sqlerrm);
135: DBMS_APPLICATION_INFO.SET_MODULE('','');
136: END purge_cp;
137: -------------------------------------------
138: PROCEDURE purge_to_date_cp(errbuf IN OUT NOCOPY VARCHAR2,
139: retcode IN OUT NOCOPY pls_integer,

Line 151: DBMS_APPLICATION_INFO.SET_MODULE('','');

147: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
148: WHEN OTHERS THEN
149: retcode := G_CONCURRENT_ERROR;
150: errbuf := cz_utils.get_text('CZ_PURGE_FATAL_ERR', 'SQLERRM',Sqlerrm);
151: DBMS_APPLICATION_INFO.SET_MODULE('','');
152: END purge_to_date_cp;
153: -------------------------------------------
154: PROCEDURE purge_to_runid_cp(errbuf IN OUT NOCOPY VARCHAR2,
155: retcode IN OUT NOCOPY pls_integer,

Line 167: DBMS_APPLICATION_INFO.SET_MODULE('','');

163: errbuf := cz_utils.get_text('CZ_IMP_ACTIVE_SESSION_EXISTS');
164: WHEN OTHERS THEN
165: retcode := G_CONCURRENT_ERROR;
166: errbuf := cz_utils.get_text('CZ_PURGE_FATAL_ERR', 'SQLERRM',Sqlerrm);
167: DBMS_APPLICATION_INFO.SET_MODULE('','');
168: END purge_to_runid_cp;
169:
170: END CZ_IMP_MGR;