APPS.CSM_LOBS_PKG dependencies on CSF_M_LOBS_INQ

Line 47: csf_m_lobs_inq

43: DATA_TYPE_ID,
44: DOCUMENT_ID,
45: TITLE
46: FROM
47: csf_m_lobs_inq
48: WHERE tranid$$ = b_tranid
49: AND clid$$cs = b_user_name;
50:
51: /***

Line 148: where table_name = 'CSF_M_LOBS_INQ'

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'
150: and OWNER = c_schema;
151: */
152:

Line 157: and syn.synonym_name = 'CSF_M_LOBS_INQ'

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'
158: and col.owner = syn.table_owner
159: and col.table_name = syn.table_name
160: and col.column_name = 'FILE_DATA';
161:

Line 293: FROM csf_m_lobs_inq

289: file_data AS FILE_DATA,
290: SYSDATE as UPLOAD_DATE,
291: l_language as LANGUAGE,
292: 'binary' AS FILE_FORMAT
293: FROM csf_m_lobs_inq
294: WHERE file_id = l_file_id
295: AND tranid$$ = p_record.tranid$$
296: AND clid$$cs = p_record.clid$$cs;*/
297: IF l_data_type ='BLOB' THEN

Line 312: ||' FROM csf_m_lobs_inq'

308: || 'file_data AS FILE_DATA, '
309: ||' SYSDATE AS UPLOAD_DATE,'
310: ||'''' || l_language || ''' AS LANGUAGE,'
311: ||'''binary''' || ' AS FILE_FORMAT '
312: ||' FROM csf_m_lobs_inq'
313: || ' WHERE file_id = ' || l_file_id
314: || ' AND tranid$$ = ' || p_record.tranid$$
315: || ' AND clid$$cs = ''' || p_record.clid$$cs || '''';
316:

Line 332: ||' FROM csf_m_lobs_inq'

328: || 'TO_LOB(file_data) AS FILE_DATA, '
329: ||' SYSDATE AS UPLOAD_DATE,'
330: ||'''' || l_language || ''' AS LANGUAGE,'
331: ||'''binary''' || ' AS FILE_FORMAT '
332: ||' FROM csf_m_lobs_inq'
333: || ' WHERE file_id = ' || l_file_id
334: || ' AND tranid$$ = ' || p_record.tranid$$
335: || ' AND clid$$cs = ''' || p_record.clid$$cs || '''';
336: