Line 33: SELECT USER_ID FROM ALL_USERS WHERE USERNAME=sUser_name;
29: END VALIDATE_END_USERS;
30: ------------------------------------------------------------------------------------------
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