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

Line 57: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

53:
54: BEGIN
55:
56: BEGIN
57: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
58: WHERE SETTING_ID='OracleSequenceIncr' AND SECTION_NAME='SCHEMA';
59: EXCEPTION
60: WHEN OTHERS THEN
61: nAllocateBlock:=1;

Line 261: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

257:
258: BEGIN
259:
260: BEGIN
261: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
262: WHERE SETTING_ID='OracleSequenceIncr' AND SECTION_NAME='SCHEMA';
263: EXCEPTION
264: WHEN OTHERS THEN
265: nAllocateBlock:=1;

Line 461: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

457:
458: BEGIN
459:
460: BEGIN
461: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
462: WHERE SETTING_ID='OracleSequenceIncr' AND SECTION_NAME='SCHEMA';
463: EXCEPTION
464: WHEN OTHERS THEN
465: nAllocateBlock:=1;

Line 624: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

620:
621: BEGIN
622:
623: BEGIN
624: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
625: WHERE SETTING_ID='OracleSequenceIncr' AND SECTION_NAME='SCHEMA';
626: EXCEPTION
627: WHEN OTHERS THEN
628: nAllocateBlock:=1;

Line 961: sAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE := 'NO';

957: nDups PLS_INTEGER:=0; /*Duplicate records */
958: nAllocateBlock PLS_INTEGER:=1;
959: nAllocateCounter PLS_INTEGER;
960: nNextValue NUMBER;
961: sAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE := 'NO';
962:
963: thisRowId ROWID;
964:
965: BEGIN

Line 968: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

964:
965: BEGIN
966:
967: BEGIN
968: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
969: WHERE SETTING_ID='OracleSequenceIncr' AND SECTION_NAME='SCHEMA';
970: EXCEPTION
971: WHEN OTHERS THEN
972: nAllocateBlock:=1;

Line 976: SELECT VALUE INTO sAutoCreateUsers FROM CZ_DB_SETTINGS

972: nAllocateBlock:=1;
973: END;
974: nAllocateCounter:=nAllocateBlock-1;
975: BEGIN
976: SELECT VALUE INTO sAutoCreateUsers FROM CZ_DB_SETTINGS
977: WHERE SETTING_ID='AUTOCREATE_IMPORTED_USERS' AND SECTION_NAME='ORAAPPS_INTEGRATE';
978: EXCEPTION
979: WHEN OTHERS THEN
980: sAutoCreateUsers:='NO';

Line 1305: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

1301:
1302: BEGIN
1303:
1304: BEGIN
1305: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
1306: WHERE SETTING_ID='OracleSequenceIncr' AND SECTION_NAME='SCHEMA';
1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: nAllocateBlock:=1;