APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 901: v_seq_num fnd_attached_documents.seq_num%TYPE;

897: v_header_attach_count NUMBER;
898: v_item_attach_count NUMBER;
899: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
900: v_org_id pon_auction_headers_all.org_id%TYPE;
901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;
905: v_quantity pon_auction_item_prices_all.quantity%TYPE;

Line 1154: FROM fnd_attached_documents ad,

1150: END;
1151: -- Does this requisition line have any attachments?
1152: SELECT COUNT(*)
1153: INTO v_header_attach_count
1154: FROM fnd_attached_documents ad,
1155: fnd_documents doc
1156: WHERE ad.entity_name = 'REQ_HEADERS'
1157: AND ad.pk1_value = TO_CHAR(p_requisition_header_id)
1158: AND ad.document_id = doc.document_id

Line 1162: FROM fnd_attached_documents ad,

1158: AND ad.document_id = doc.document_id
1159: AND doc.category_id = v_att_category_id;
1160: SELECT COUNT(*)
1161: INTO v_item_attach_count
1162: FROM fnd_attached_documents ad,
1163: fnd_documents doc
1164: WHERE ad.entity_name = 'REQ_LINES'
1165: AND ad.pk1_value = TO_CHAR(p_requisition_line_id)
1166: AND ad.document_id = doc.document_id

Line 1740: fnd_attached_documents2_pkg.COPY_ATTACHMENTS

1736: (
1737: l_log_module, v_debug_status
1738: )
1739: ;
1740: fnd_attached_documents2_pkg.COPY_ATTACHMENTS
1741: (
1742: 'REQ_HEADERS', --from_entity_name
1743: TO_CHAR(p_requisition_header_id), -- from_pk1_value
1744: NULL, -- from_pk2_value

Line 1771: fnd_attached_documents2_pkg.COPY_ATTACHMENTS

1767: (
1768: l_log_module, v_debug_status
1769: )
1770: ;
1771: fnd_attached_documents2_pkg.COPY_ATTACHMENTS
1772: (
1773: 'REQ_LINES', --from_entity_name
1774: TO_CHAR(p_requisition_line_id), -- from_pk1_value
1775: NULL, -- from_pk2_value