APPS.CZ_ADMIN dependencies on CZ_END_USERS

Line 5: SELECT LOGIN_NAME FROM CZ_END_USERS;

1: PACKAGE BODY CZ_ADMIN as
2: /* $Header: czcadmnb.pls 115.18 2003/10/31 19:49:48 qmao ship $ */
3: PROCEDURE VALIDATE_END_USERS IS
4: CURSOR C_GET_USER IS
5: SELECT LOGIN_NAME FROM CZ_END_USERS;
6: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;
7:
8: BEGIN
9: OPEN C_GET_USER;

Line 6: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;

2: /* $Header: czcadmnb.pls 115.18 2003/10/31 19:49:48 qmao ship $ */
3: PROCEDURE VALIDATE_END_USERS IS
4: CURSOR C_GET_USER IS
5: SELECT LOGIN_NAME FROM CZ_END_USERS;
6: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;
7:
8: BEGIN
9: OPEN C_GET_USER;
10:

Line 35: SELECT UPPER(LOGIN_NAME) FROM CZ_END_USERS;

31: PROCEDURE ENABLE_END_USERS IS
32: CURSOR C_CHECK_USER(sUser_name VARCHAR2) IS
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

Line 46: sLogin_name CZ_END_USERS.LOGIN_NAME%TYPE;

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';
48: sDefault_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
49: sTempory_tspc CZ_DB_SETTINGS.VALUE%TYPE := NULL;
50: sCommand VARCHAR2(255);

Line 134: UPDATE CZ_END_USERS SET DBMS_ID=nUserID WHERE UPPER(LOGIN_NAME)=sLogin_name;

130: FETCH C_CHECK_USER INTO nUserID;
131: CLOSE C_CHECK_USER;
132:
133: BEGIN
134: UPDATE CZ_END_USERS SET DBMS_ID=nUserID WHERE UPPER(LOGIN_NAME)=sLogin_name;
135: EXCEPTION
136: WHEN OTHERS THEN
137: -- xERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_ADMIN.ENABLE_END_USER',11276);
138: cz_utils.log_report('CZ_ADMIN', 'ENABLE_END_USER', null,