APPS.GMA_STANDARD dependencies on EDR_FILES_B

Line 169: FROM edr_files_b

165: LocalCatRecord c_get_category%ROWTYPE;
166:
167: CURSOR c_get_exists IS
168: SELECT version_number, status
169: FROM edr_files_b
170: WHERE original_file_name = p_file_name
171: AND category_id = LocalCatRecord.category_id;
172: LocalExistsRecord c_get_exists%ROWTYPE;
173:

Line 175: SELECT edr_files_b_s.nextval

171: AND category_id = LocalCatRecord.category_id;
172: LocalExistsRecord c_get_exists%ROWTYPE;
173:
174: CURSOR c_get_seq_num IS
175: SELECT edr_files_b_s.nextval
176: FROM dual;
177: LocalSeqRecord c_get_seq_num%ROWTYPE;
178:
179: CURSOR c_get_event IS

Line 181: FROM edr_files_b a, fnd_document_categories b

177: LocalSeqRecord c_get_seq_num%ROWTYPE;
178:
179: CURSOR c_get_event IS
180: SELECT a.file_name, b.name
181: FROM edr_files_b a, fnd_document_categories b
182: WHERE a.category_id = b.category_id
183: AND a.file_id = l_file_id;
184: LocalEventRecord c_get_event%ROWTYPE;
185:

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

390: l_file_name := l_file_name ||'_v_'||p_version_label||l_extension;
391:
392: /* Get the next sequence number for file_id */
393: /* Fixed SKARIMIS */
394: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
395:
396: /* Call private package to insert data into the tables */
397: --cj the whole idea is that instead of inserting one row in edr_files_b/tl tables
398: -- we would have to insert a row in:

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

393: /* Fixed SKARIMIS */
394: SELECT edr_files_b_s.nextval INTO l_file_id FROM dual;
395:
396: /* Call private package to insert data into the tables */
397: --cj the whole idea is that instead of inserting one row in edr_files_b/tl tables
398: -- we would have to insert a row in:
399: -- edr_files_b/tl
400: -- fnd_documents
401: --fnd_lobs

Line 399: -- edr_files_b/tl

395:
396: /* Call private package to insert data into the tables */
397: --cj the whole idea is that instead of inserting one row in edr_files_b/tl tables
398: -- we would have to insert a row in:
399: -- edr_files_b/tl
400: -- fnd_documents
401: --fnd_lobs
402: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B
403:

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

398: -- we would have to insert a row in:
399: -- edr_files_b/tl
400: -- fnd_documents
401: --fnd_lobs
402: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B
403:
404: --CJ look at the new definition of this package
405: --it would not have the BLOB col FILE_DATA
406: --change this call accordingly

Line 465: X_entity_name=>'EDR_FILES_B',

461: X_last_update_date=>p_last_update_date,
462: X_last_updated_by=>p_last_updated_by,
463: X_last_update_login=>p_last_update_login,
464: X_seq_num=>1,
465: X_entity_name=>'EDR_FILES_B',
466: X_column1=>NULL,
467: X_pk1_value=>NULL,
468: X_pk2_value=>NULL,
469: X_pk3_value=>NULL,

Line 514: --CJ now update the row in the edr_files_b table with the fnd_document_id that you get

510: l_file_data,
511: p_content_type,
512: p_file_format);
513:
514: --CJ now update the row in the edr_files_b table with the fnd_document_id that you get
515: -- from inserting a row in FND_DOCUMENTS table
516:
517: UPDATE EDR_FILES_B
518: SET fnd_document_id = x_document_id

Line 517: UPDATE EDR_FILES_B

513:
514: --CJ now update the row in the edr_files_b table with the fnd_document_id that you get
515: -- from inserting a row in FND_DOCUMENTS table
516:
517: UPDATE EDR_FILES_B
518: SET fnd_document_id = x_document_id
519: WHERE file_id = l_file_id;
520:
521: /* If sending for approval, raise ERES event */

Line 563: UPDATE edr_files_b

559: -- to the approver and its waiting approval
560: -- in any other case raise an error
561:
562: if l_status = 'PENDING' then
563: UPDATE edr_files_b
564: SET status = 'P'
565: WHERE file_id = l_file_id
566: AND file_name = LocalEventRecord.file_name;
567: elsif l_status = 'COMPLETE' then

Line 568: UPDATE edr_files_b

564: SET status = 'P'
565: WHERE file_id = l_file_id
566: AND file_name = LocalEventRecord.file_name;
567: elsif l_status = 'COMPLETE' then
568: UPDATE edr_files_b
569: SET status = 'S'
570: WHERE file_id = l_file_id
571: AND file_name = LocalEventRecord.file_name;
572: else

Line 745: FROM fnd_attached_documents f, edr_files_b e

741:
742: /* ------------------ CURSORS ---------------------- */
743: CURSOR c_get_event_key IS
744: SELECT file_id
745: FROM fnd_attached_documents f, edr_files_b e
746: WHERE entity_name = p_entity_name
747: AND pk1_value = p_pk1_value
748: AND NVL(pk2_value,' ') = NVL(p_pk2_value,' ')
749: AND NVL(pk3_value,' ') = NVL(p_pk3_value,' ')