DBA Data[Home] [Help]

APPS.CSM_LOBS_PKG dependencies on FND_LOBS_S

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

211: END IF;
212:
213:
214: --setting file id
215: --For lobs we require file id to insert data into fnd_lobs.So we get the file_id from the client
216: --For LOBS we give fileid to the server so that we can avoid the lobs getting downloaded in the client
217: --twice when its uploaded
218: IF l_data_type_id = 6 THEN
219: l_file_id := p_record.file_id;

Line 234: SELECT fnd_lobs_s.nextval

230: 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';
231: CSM_UTIL_PKG.LOG( p_error_msg ,'CSM_LOBS_PKG.UPLOAD_SR_TASK_LOB', FND_LOG.LEVEL_ERROR );
232: l_file_id := NULL;
233: --get the file id from the sequence diretly.As the client sent file id is not proper.
234: SELECT fnd_lobs_s.nextval
235: INTO l_file_id
236: FROM dual;
237: l_dodirty := TRUE;
238: END IF;

Line 589: r_FND_LOBS.seqno$$,

585: CSM_UTIL_PKG.DELETE_RECORD
586: (
587: p_user_name,
588: p_tranid,
589: r_FND_LOBS.seqno$$,
590: r_FND_LOBS.FILE_ID, -- put PK column here
591: g_object_name,
592: g_pub_name,
593: l_error_msg,

Line 624: , r_FND_LOBS.seqno$$

620: CSM_UTIL_PKG.DEFER_RECORD
621: (
622: p_user_name
623: , p_tranid
624: , r_FND_LOBS.seqno$$
625: , r_FND_LOBS.FILE_ID -- put PK column here
626: , g_object_name
627: , g_pub_name
628: , l_error_msg