274:
275: CURSOR c_get_user(c_user_name VARCHAR2)
276: IS
277: SELECT USER_ID
278: FROM ASG_USER
279: WHERE USER_NAME =c_user_name;
280: --Variable Declarations
281: l_variable_name_lst CSM_VARCHAR_LIST;
282: l_var_type_lst CSM_VARCHAR_LIST;
432:
433: CURSOR c_get_user(c_user_name VARCHAR2)
434: IS
435: SELECT USER_ID
436: FROM ASG_USER
437: WHERE USER_NAME =c_user_name;
438:
439: l_DELETE_FLAG VARCHAR2(1) := NULL;
440: l_USER_ID NUMBER := NULL;