APPS.CSM_LOBS_PKG dependencies on ASG_USER

Line 74: l_language asg_user.LANGUAGE%TYPE;

70: l_error_msg VARCHAR(1024);
71: l_signature_loc BLOB;
72: l_signature_raw LONG RAW(32000);
73: l_signature_size NUMBER;
74: l_language asg_user.LANGUAGE%TYPE;
75: l_dummy NUMBER;
76: l_category_name VARCHAR2(240);--need to add value
77: l_file_name p_record.FILE_NAME%TYPE;
78: l_file_content_type p_record.FILE_CONTENT_TYPE%TYPE;

Line 81: l_user_id ASG_USER.USER_ID%TYPE;

77: l_file_name p_record.FILE_NAME%TYPE;
78: l_file_content_type p_record.FILE_CONTENT_TYPE%TYPE;
79: l_entity_name p_record.ENTITY_NAME%TYPE;
80: l_function_name VARCHAR2(240);
81: l_user_id ASG_USER.USER_ID%TYPE;
82: l_dodirty BOOLEAN;
83: l_title VARCHAR2(80);
84: l_schema_name FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
85: l_data_type dba_tab_columns.data_type%TYPE;

Line 136: FROM asg_user au

132:
133: CURSOR l_get_language(p_user_name IN VARCHAR2)
134: IS
135: SELECT au.LANGUAGE,au.USER_ID
136: FROM asg_user au
137: WHERE au.user_name = p_user_name;
138:
139: CURSOR l_get_schema
140: IS