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 dba_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: /* Bug 15932265
145: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)

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

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

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

149: and column_name = 'FILE_DATA'
150: and OWNER = c_schema;
151: */
152:
153: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)
154: IS
155: select data_type from user_synonyms syn, dba_tab_columns col
156: where syn.table_owner = c_schema
157: and syn.synonym_name = 'CSF_M_LOBS_INQ'