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

Line 37: SELECT VALUE FROM CZ_DB_SETTINGS

33: SELECT USER_ID FROM ALL_USERS WHERE USERNAME=sUser_name;
34: CURSOR C_GET_USER IS
35: SELECT UPPER(LOGIN_NAME) FROM CZ_END_USERS;
36: CURSOR C_GET_ROLE IS
37: SELECT VALUE FROM CZ_DB_SETTINGS
38: WHERE SECTION_NAME='DB_USER_ROLES' AND SETTING_ID='0';
39: CURSOR C_GET_DEFAULT IS
40: SELECT VALUE FROM CZ_DB_SETTINGS
41: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxDefaultTablespace';

Line 40: SELECT VALUE FROM CZ_DB_SETTINGS

36: CURSOR C_GET_ROLE IS
37: SELECT VALUE FROM CZ_DB_SETTINGS
38: WHERE SECTION_NAME='DB_USER_ROLES' AND SETTING_ID='0';
39: CURSOR C_GET_DEFAULT IS
40: SELECT VALUE FROM CZ_DB_SETTINGS
41: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxDefaultTablespace';
42: CURSOR C_GET_TEMPORY IS
43: SELECT VALUE FROM CZ_DB_SETTINGS
44: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxTemporaryTablespace';

Line 43: SELECT VALUE FROM CZ_DB_SETTINGS

39: CURSOR C_GET_DEFAULT IS
40: SELECT VALUE FROM CZ_DB_SETTINGS
41: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxDefaultTablespace';
42: CURSOR C_GET_TEMPORY IS
43: SELECT VALUE FROM CZ_DB_SETTINGS
44: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxTemporaryTablespace';
45: DC_CURSOR INTEGER;
46: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;
47: sDefault_role CZ_DB_SETTINGS.VALUE%TYPE := 'SPX_USER';

Line 47: sDefault_role CZ_DB_SETTINGS.VALUE%TYPE := 'SPX_USER';

43: SELECT VALUE FROM CZ_DB_SETTINGS
44: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxTemporaryTablespace';
45: DC_CURSOR INTEGER;
46: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;
47: sDefault_role CZ_DB_SETTINGS.VALUE%TYPE := 'SPX_USER';
48: sDefault_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
49: sTempory_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
50: sCommand VARCHAR2(255);
51: nUserID NUMBER;

Line 48: sDefault_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;

44: WHERE SECTION_NAME='SCHEMA' AND SETTING_ID='SpxTemporaryTablespace';
45: DC_CURSOR INTEGER;
46: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;
47: sDefault_role CZ_DB_SETTINGS.VALUE%TYPE := 'SPX_USER';
48: sDefault_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
49: sTempory_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
50: sCommand VARCHAR2(255);
51: nUserID NUMBER;
52: RESULT INTEGER;

Line 49: sTempory_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;

45: DC_CURSOR INTEGER;
46: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;
47: sDefault_role CZ_DB_SETTINGS.VALUE%TYPE := 'SPX_USER';
48: sDefault_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
49: sTempory_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
50: sCommand VARCHAR2(255);
51: nUserID NUMBER;
52: RESULT INTEGER;
53:

Line 178: SELECT NVL(to_number(VALUE),0) INTO nSeconds FROM CZ_DB_SETTINGS

174: nSeconds NUMBER;
175: nCounter PLS_INTEGER;
176: BEGIN
177: BEGIN
178: SELECT NVL(to_number(VALUE),0) INTO nSeconds FROM CZ_DB_SETTINGS
179: WHERE SETTING_ID='MULTISESSION' AND SECTION_NAME='IMPORT';
180: EXCEPTION
181: WHEN OTHERS THEN
182: nSeconds:=0;

Line 213: SELECT NVL(to_number(VALUE),0) INTO nSeconds FROM CZ_DB_SETTINGS

209: nSeconds NUMBER;
210: nCounter PLS_INTEGER;
211: BEGIN
212: BEGIN
213: SELECT NVL(to_number(VALUE),0) INTO nSeconds FROM CZ_DB_SETTINGS
214: WHERE SETTING_ID='MULTISESSION' AND SECTION_NAME='CZPUBLISH';
215: EXCEPTION
216: WHEN OTHERS THEN
217: nSeconds:=0;