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_ALL dependencies on CZ_DB_SETTINGS

Line 15: INTO nEnableTrace FROM CZ_DB_SETTINGS

11: v_section_name := 'IMPORT';
12:
13: SELECT decode(upper(VALUE),'TRUE','1','FALSE','0','T','1','F','0','1','1',
14: '0','0','YES','1','NO','0','Y','1', 'N', '0','0')
15: INTO nEnableTrace FROM CZ_DB_SETTINGS
16: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
17: RETURN (nEnableTrace = '1');
18: EXCEPTION
19: WHEN OTHERS THEN

Line 34: INTO nEnableLog FROM CZ_DB_SETTINGS

30: v_section_name := 'IMPORT';
31:
32: SELECT decode(upper(VALUE),'TRUE','1','FALSE','0','T','1','F','0','1','1',
33: '0','0','YES','1','NO','0','Y','1', 'N', '0','0')
34: INTO nEnableLog FROM CZ_DB_SETTINGS
35: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
36: RETURN (nEnableLog='1');
37: EXCEPTION
38: WHEN OTHERS THEN

Line 201: bAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE:='NO';

197: nMax_err PLS_INTEGER DEFAULT 10000;
198: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;
199: sSrcTableName CZ_XFR_TABLES.SRC_TABLE%TYPE;
200: xERROR BOOLEAN:=FALSE;
201: bAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE:='NO';
202: bRunExploder CZ_DB_SETTINGS.VALUE%TYPE:='NO';
203: outGrp_ID NUMBER;
204: outError_code NUMBER;
205: outErr_msg VARCHAR2(255);

Line 202: bRunExploder CZ_DB_SETTINGS.VALUE%TYPE:='NO';

198: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;
199: sSrcTableName CZ_XFR_TABLES.SRC_TABLE%TYPE;
200: xERROR BOOLEAN:=FALSE;
201: bAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE:='NO';
202: bRunExploder CZ_DB_SETTINGS.VALUE%TYPE:='NO';
203: outGrp_ID NUMBER;
204: outError_code NUMBER;
205: outErr_msg VARCHAR2(255);
206: d_str varchar2(255);

Line 276: ----2) Get the COMMIT_SIZE and MAX_ERR values from CZ_DB_SETTINGS

272: END IF;
273: outRun_ID:=genRun_ID;
274: COMMIT;
275:
276: ----2) Get the COMMIT_SIZE and MAX_ERR values from CZ_DB_SETTINGS
277:
278: v_settings_id := 'CommitSize';
279: v_section_name := 'IMPORT';
280:

Line 282: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS

278: v_settings_id := 'CommitSize';
279: v_section_name := 'IMPORT';
280:
281: BEGIN
282: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS
283: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');

Line 287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);

283: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
284: EXCEPTION
285: WHEN NO_DATA_FOUND THEN
286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');
287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
288: WHEN OTHERS THEN
289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);
290: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
291: END;

Line 289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);

285: WHEN NO_DATA_FOUND THEN
286: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_COMMITSIZE');
287: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
288: WHEN OTHERS THEN
289: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.COMMITSIZE',11276,genRun_ID);
290: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
291: END;
292:
293: v_settings_id := 'MaximumErrors';

Line 297: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS

293: v_settings_id := 'MaximumErrors';
294: v_section_name := 'IMPORT';
295:
296: BEGIN
297: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS
298: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');

Line 302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);

298: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');
302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
303: WHEN OTHERS THEN
304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);
305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
306: END;

Line 304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);

300: WHEN NO_DATA_FOUND THEN
301: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_MAX_ERR');
302: xERROR:=cz_utils.log_report(d_str,1,'GO_GENERIC.CZ_DB_SETTINGS',11276,genRun_ID);
303: WHEN OTHERS THEN
304: xERROR:=cz_utils.log_report(SQLERRM,1,'GO_GENERIC.CZ_DB_SETTINGS.MAXERRORS',11276,genRun_ID);
305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
306: END;
307:
308: ----3) Call all the import procedures in the order specified by ORDER_SEQ field of

Line 348: SELECT VALUE INTO bAutoCreateUsers FROM CZ_DB_SETTINGS

344: v_settings_id := 'AUTOCREATE_IMPORTED_USERS';
345: v_section_name := 'ORAAPPS_INTEGRATE';
346:
347: BEGIN
348: SELECT VALUE INTO bAutoCreateUsers FROM CZ_DB_SETTINGS
349: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
350: EXCEPTION
351: WHEN OTHERS THEN
352: bAutoCreateUsers:='NO';

Line 602: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

598: v_settings_id := 'OracleSequenceIncr';
599: v_section_name := 'SCHEMA';
600:
601: BEGIN
602: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
603: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
604: EXCEPTION
605: WHEN OTHERS THEN
606: nAllocateBlock:=1;