APPS.EDR_FILES_PUB dependencies on EDR_FILES_B

Line 115: FROM edr_files_b

111: LocalCatRecord c_get_category%ROWTYPE;
112:
113: CURSOR c_get_exists IS
114: SELECT version_number, status
115: FROM edr_files_b
116: WHERE original_file_name = p_file_name
117: AND category_id = LocalCatRecord.category_id;
118: LocalExistsRecord c_get_exists%ROWTYPE;
119:

Line 121: SELECT edr_files_b_s.nextval

117: AND category_id = LocalCatRecord.category_id;
118: LocalExistsRecord c_get_exists%ROWTYPE;
119:
120: CURSOR c_get_seq_num IS
121: SELECT edr_files_b_s.nextval
122: FROM dual;
123: LocalSeqRecord c_get_seq_num%ROWTYPE;
124:
125: CURSOR c_get_event IS

Line 127: FROM edr_files_b a, fnd_document_categories b

123: LocalSeqRecord c_get_seq_num%ROWTYPE;
124:
125: CURSOR c_get_event IS
126: SELECT a.file_name, b.name
127: FROM edr_files_b a, fnd_document_categories b
128: WHERE a.category_id = b.category_id
129: AND a.file_id = l_file_id;
130: LocalEventRecord c_get_event%ROWTYPE;
131:

Line 332: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;

328: --Set up the display name for the attachment
329: l_file_name := l_file_name ||'_v_'||p_version_label||l_extension;
330:
331: --Get the next sequence number for file_id
332: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
333:
334: --Call private package to insert data into the tables
335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables
336: -- we would have to insert a row in:

Line 335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables

331: --Get the next sequence number for file_id
332: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
333:
334: --Call private package to insert data into the tables
335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables
336: -- we would have to insert a row in:
337: -- edr_files_b/tl
338: -- fnd_documents
339: --fnd_lobs

Line 337: -- edr_files_b/tl

333:
334: --Call private package to insert data into the tables
335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables
336: -- we would have to insert a row in:
337: -- edr_files_b/tl
338: -- fnd_documents
339: --fnd_lobs
340: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B
341:

Line 340: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B

336: -- we would have to insert a row in:
337: -- edr_files_b/tl
338: -- fnd_documents
339: --fnd_lobs
340: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B
341:
342: EDR_FILES_PKG.Insert_Row (
343: X_ROWID =>l_row_id,
344: X_FILE_ID =>l_file_id,

Line 397: X_entity_name=>'EDR_FILES_B',

393: X_last_update_date=>p_last_update_date,
394: X_last_updated_by=>p_last_updated_by,
395: X_last_update_login=>p_last_update_login,
396: X_seq_num=>1,
397: X_entity_name=>'EDR_FILES_B',
398: X_column1=>NULL,
399: X_pk1_value=>NULL,
400: X_pk2_value=>NULL,
401: X_pk3_value=>NULL,

Line 452: --now update the row in the edr_files_b table with the fnd_document_id

448: --Bug 3265035: End
449: p_content_type,
450: p_file_format);
451:
452: --now update the row in the edr_files_b table with the fnd_document_id
453: --that you get from inserting a row in FND_DOCUMENTS table
454:
455: UPDATE EDR_FILES_B
456: SET fnd_document_id = x_document_id

Line 455: UPDATE EDR_FILES_B

451:
452: --now update the row in the edr_files_b table with the fnd_document_id
453: --that you get from inserting a row in FND_DOCUMENTS table
454:
455: UPDATE EDR_FILES_B
456: SET fnd_document_id = x_document_id
457: WHERE file_id = l_file_id;
458:
459: --If sending for approval, raise ERES event

Line 565: UPDATE edr_files_b

561:
562: --update the file status and put the erecord
563: --id in attribute 14
564:
565: UPDATE edr_files_b
566: SET status = 'P',
567: attribute14 = l_erecord_id
568: WHERE file_id = l_file_id
569: AND file_name = LocalEventRecord.file_name;

Line 574: UPDATE edr_files_b

570: elsif (l_event_status = 'NOACTION') then
571: l_send_ackn := TRUE;
572: l_trans_status := 'SUCCESS';
573:
574: UPDATE edr_files_b
575: SET status = 'S',
576: attribute14 = l_erecord_id
577: WHERE file_id = l_file_id
578: AND file_name = LocalEventRecord.file_name;