DBA Data[Home] [Help]

APPS.CSM_LOBS_PKG dependencies on FND_LOBS_S

Line 226: --For lobs we require file id to insert data into fnd_lobs.So we get the file_id from the client

222: END IF;
223:
224:
225: --setting file id
226: --For lobs we require file id to insert data into fnd_lobs.So we get the file_id from the client
227: --For LOBS we give fileid to the server so that we can avoid the lobs getting downloaded in the client
228: --twice when its uploaded
229: IF l_data_type_id = 6 THEN
230: l_file_id := p_record.file_id;

Line 245: SELECT fnd_lobs_s.nextval

241: p_error_msg := 'Duplicate Record: File id ' || to_char(l_file_id)|| ' already exists in fnd_lobs table.So generating a new from fnd sequence';
242: CSM_UTIL_PKG.LOG( p_error_msg ,'CSM_LOBS_PKG.UPLOAD_SR_TASK_LOB', FND_LOG.LEVEL_ERROR );
243: l_file_id := NULL;
244: --get the file id from the sequence diretly.As the client sent file id is not proper.
245: SELECT fnd_lobs_s.nextval
246: INTO l_file_id
247: FROM dual;
248: l_dodirty := TRUE;
249: END IF;

Line 600: r_FND_LOBS.seqno$$,

596: CSM_UTIL_PKG.DELETE_RECORD
597: (
598: p_user_name,
599: p_tranid,
600: r_FND_LOBS.seqno$$,
601: r_FND_LOBS.FILE_ID, -- put PK column here
602: g_object_name,
603: g_pub_name,
604: l_error_msg,

Line 635: , r_FND_LOBS.seqno$$

631: CSM_UTIL_PKG.DEFER_RECORD
632: (
633: p_user_name
634: , p_tranid
635: , r_FND_LOBS.seqno$$
636: , r_FND_LOBS.FILE_ID -- put PK column here
637: , g_object_name
638: , g_pub_name
639: , l_error_msg