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 147: where table_name = 'CSF_M_LOBS_INQ'

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'
149: and OWNER = c_schema;
150:
151: BEGIN

Line 282: FROM csf_m_lobs_inq

278: file_data AS FILE_DATA,
279: SYSDATE as UPLOAD_DATE,
280: l_language as LANGUAGE,
281: 'binary' AS FILE_FORMAT
282: FROM csf_m_lobs_inq
283: WHERE file_id = l_file_id
284: AND tranid$$ = p_record.tranid$$
285: AND clid$$cs = p_record.clid$$cs;*/
286: IF l_data_type ='BLOB' THEN

Line 301: ||' FROM csf_m_lobs_inq'

297: || 'file_data AS FILE_DATA, '
298: ||' SYSDATE AS UPLOAD_DATE,'
299: ||'''' || l_language || ''' AS LANGUAGE,'
300: ||'''binary''' || ' AS FILE_FORMAT '
301: ||' FROM csf_m_lobs_inq'
302: || ' WHERE file_id = ' || l_file_id
303: || ' AND tranid$$ = ' || p_record.tranid$$
304: || ' AND clid$$cs = ''' || p_record.clid$$cs || '''';
305:

Line 321: ||' FROM csf_m_lobs_inq'

317: || 'TO_LOB(file_data) AS FILE_DATA, '
318: ||' SYSDATE AS UPLOAD_DATE,'
319: ||'''' || l_language || ''' AS LANGUAGE,'
320: ||'''binary''' || ' AS FILE_FORMAT '
321: ||' FROM csf_m_lobs_inq'
322: || ' WHERE file_id = ' || l_file_id
323: || ' AND tranid$$ = ' || p_record.tranid$$
324: || ' AND clid$$cs = ''' || p_record.clid$$cs || '''';
325: