APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 488: v_seq_num fnd_attached_documents.seq_num%TYPE;

484: v_header_attach_count NUMBER;
485: v_item_attach_count NUMBER;
486: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
487: v_org_id pon_auction_headers_all.org_id%TYPE;
488: v_seq_num fnd_attached_documents.seq_num%TYPE;
489: v_price pon_auction_item_prices_all.current_price%TYPE;
490: v_category_name pon_auction_item_prices_all.category_name%TYPE;
491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
492: v_quantity pon_auction_item_prices_all.quantity%TYPE;

Line 664: FROM fnd_attached_documents ad, fnd_documents doc

660:
661: -- Does this requisition line have any attachments?
662: SELECT count(*)
663: INTO v_header_attach_count
664: FROM fnd_attached_documents ad, fnd_documents doc
665: WHERE ad.entity_name = 'REQ_HEADERS'
666: AND ad.pk1_value = to_char(p_requisition_header_id)
667: AND ad.document_id = doc.document_id
668: AND doc.category_id = v_att_category_id;

Line 672: FROM fnd_attached_documents ad, fnd_documents doc

668: AND doc.category_id = v_att_category_id;
669:
670: SELECT count(*)
671: INTO v_item_attach_count
672: FROM fnd_attached_documents ad, fnd_documents doc
673: WHERE ad.entity_name = 'REQ_LINES'
674: AND ad.pk1_value = to_char(p_requisition_line_id)
675: AND ad.document_id = doc.document_id
676: AND doc.category_id = v_att_category_id;

Line 1057: fnd_attached_documents2_pkg.COPY_ATTACHMENTS (

1053: -- Copy attachments from requisition (header, item and line)
1054: IF (v_has_attachments = 'Y') THEN
1055: -- Copy requisition header attachments
1056: v_debug_status := 'INSERT_HEADER_ATTACHMENT';
1057: fnd_attached_documents2_pkg.COPY_ATTACHMENTS (
1058: 'REQ_HEADERS', --from_entity_name
1059: to_char(p_requisition_header_id), -- from_pk1_value
1060: NULL, -- from_pk2_value
1061: NULL, -- from_pk3_value

Line 1081: fnd_attached_documents2_pkg.COPY_ATTACHMENTS (

1077: 33); -- to_category_id (Vendor)
1078:
1079: -- Copy requisition line attachments
1080: v_debug_status := 'INSERT_LINE_ATTACHMENT';
1081: fnd_attached_documents2_pkg.COPY_ATTACHMENTS (
1082: 'REQ_LINES', --from_entity_name
1083: to_char(p_requisition_line_id), -- from_pk1_value
1084: NULL, -- from_pk2_value
1085: NULL, -- from_pk3_value