APPS.GR_REG_PRINT_DOC dependencies on FND_ATTACHED_DOCUMENTS

Line 445: FROM fnd_attached_documents a,

441: /* Used to get the attached document information for a Delivery Detail Line*/
442: CURSOR c_get_attch_doc_details IS
443: SELECT
444: a.entity_name
445: FROM fnd_attached_documents a,
446: fnd_documents d
447: WHERE
448: d.category_id IN
449: (SELECT category_id

Line 521: FROM fnd_attached_documents

517:
518: /* Get Sequence number for Next New attachment */
519: CURSOR c_get_seq IS
520: SELECT NVL(max(seq_num),0) + 10
521: FROM fnd_attached_documents
522: WHERE entity_name= 'WSH_DELIVERY_DETAILS'
523: AND pk1_value = LocalDeliverydetail.delivery_detail_id;
524:
525: /*Used to get the next attached_document_id for a new attachment*/

Line 527: SELECT fnd_attached_documents_s.nextval

523: AND pk1_value = LocalDeliverydetail.delivery_detail_id;
524:
525: /*Used to get the next attached_document_id for a new attachment*/
526: CURSOR c_get_id IS
527: SELECT fnd_attached_documents_s.nextval
528: FROM dual;
529:
530:
531: BEGIN

Line 643: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(

639: l_seq := 10;
640: END IF;
641: CLOSE c_get_seq;
642:
643: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(
644: X_Rowid => l_rowid,
645: X_attached_document_id => l_attached_document_id,
646: X_document_id => LocalLatestDocument.document_id,
647: X_creation_date => SYSDATE,