APPS.CSM_LOBS_PKG dependencies on FND_ORACLE_USERID

Line 84: l_schema_name FND_ORACLE_USERID.ORACLE_USERNAME%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 all_tab_columns.data_type%TYPE;
86: l_data_type_id NUMBER;
87: l_dsql VARCHAR2(4000);
88: l_cursorid NUMBER;

Line 141: SELECT ORACLE_USERNAME from FND_ORACLE_USERID

137: WHERE au.user_name = p_user_name;
138:
139: CURSOR l_get_schema
140: IS
141: SELECT ORACLE_USERNAME from FND_ORACLE_USERID
142: WHERE ORACLE_ID =883;
143:
144: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)
145: IS

Line 144: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)

140: IS
141: SELECT ORACLE_USERNAME from FND_ORACLE_USERID
142: WHERE ORACLE_ID =883;
143:
144: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)
145: IS
146: select data_type from all_tab_columns
147: where table_name = 'CSF_M_LOBS_INQ'
148: and column_name = 'FILE_DATA'