APPS.PO_INTERFACE_S dependencies on FND_ATTACHED_DOCUMENTS

Line 2762: l_one_time_att_doc_id fnd_attached_documents.attached_document_id%TYPE;

2758: l_conversion_rate number :=1;
2759: -- Bug 2735840 END
2760:
2761: -- Bug 2875346.
2762: l_one_time_att_doc_id fnd_attached_documents.attached_document_id%TYPE;
2763:
2764: --
2765: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
2766: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;

Line 4807: fnd_attached_documents2_pkg.

4803: -- CONSIGNED FPI
4804:
4805: l_progress := '640';
4806: -- API to copy attachments from requisition line to release shipment
4807: fnd_attached_documents2_pkg.
4808: copy_attachments('REQ_LINES',
4809: interface.requisition_line_id,
4810: '',
4811: '',

Line 4837: fnd_attached_documents2_pkg.

4833: WHERE requisition_line_id = interface.requisition_line_id;
4834:
4835: l_progress:='660';
4836:
4837: fnd_attached_documents2_pkg.
4838: copy_attachments('REQ_HEADERS',
4839: x_requisition_header_id,
4840: '',
4841: '',

Line 4882: fnd_attached_documents2_pkg.

4878: */
4879:
4880: if g_interface_source_code not in ('SOURCING','CONSUMPTION_ADVICE') then -- CONSIGNED FPI
4881: l_progress := '670';
4882: fnd_attached_documents2_pkg.
4883: copy_attachments('REQ_LINES',
4884: interface.requisition_line_id,
4885: '',
4886: '',

Line 4912: fnd_attached_documents2_pkg.

4908: WHERE requisition_line_id = interface.requisition_line_id;
4909:
4910: l_progress:='690';
4911:
4912: fnd_attached_documents2_pkg.
4913: copy_attachments('REQ_HEADERS',
4914: x_requisition_header_id,
4915: '',
4916: '',

Line 5009: FROM fnd_attached_documents fad,

5005: --SQL Why: Need the attached_document_id to move the attachment
5006:
5007: SELECT fad.attached_document_id
5008: INTO l_one_time_att_doc_id
5009: FROM fnd_attached_documents fad,
5010: fnd_documents_tl fdt
5011: WHERE fad.entity_name = 'PO_LINES'
5012: AND fad.pk1_value = to_char(x_po_line_id)
5013: AND fad.document_id = fdt.document_id

Line 5020: UPDATE fnd_attached_documents

5016:
5017: l_progress := '750';
5018:
5019: -- Move the attachment from the PO line to the PO shipment
5020: UPDATE fnd_attached_documents
5021: SET entity_name = 'PO_SHIPMENTS',
5022: pk1_value = to_char(x_line_location_id),
5023: pk2_value = 'ONE_TIME_LOCATION'
5024: WHERE attached_document_id = l_one_time_att_doc_id;

Line 5051: fnd_attached_documents2_pkg.copy_attachments(

5047: -- only then need to copy the one time attachments.
5048: -- copy one-time location from first actual shipment to
5049: -- each payitem.
5050: IF (l_one_time_att_doc_id IS NOT NULL) THEN
5051: fnd_attached_documents2_pkg.copy_attachments(
5052: X_from_entity_name => 'PO_SHIPMENTS'
5053: , X_from_pk1_value => x_line_location_id
5054: , X_from_pk2_value => 'ONE_TIME_LOCATION'
5055: , X_to_entity_name => 'PO_SHIPMENTS'

Line 11702: FROM fnd_attached_documents

11698: -- Query if this req line has a one-time location attachment, which
11699: -- indicates that the req line is for a one-time location.
11700: SELECT 'Y'
11701: INTO l_flag
11702: FROM fnd_attached_documents
11703: WHERE entity_name = 'REQ_LINES'
11704: AND pk1_value = to_char(p_req_line_id)
11705: AND pk2_value = 'ONE_TIME_LOCATION'
11706: AND rownum = 1;