APPS.PO_INTERFACE_S dependencies on FND_ATTACHED_DOCUMENTS

Line 3099: l_one_time_att_doc_id fnd_attached_documents.attached_document_id%TYPE;

3095: l_conversion_rate number :=1;
3096: -- Bug 2735840 END
3097:
3098: -- Bug 2875346.
3099: l_one_time_att_doc_id fnd_attached_documents.attached_document_id%TYPE;
3100:
3101: --
3102: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
3103: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;

Line 5267: fnd_attached_documents2_pkg.

5263: -- CONSIGNED FPI
5264:
5265: l_progress := '640';
5266: -- API to copy attachments from requisition line to release shipment
5267: fnd_attached_documents2_pkg.
5268: copy_attachments('REQ_LINES',
5269: interface.requisition_line_id,
5270: '',
5271: '',

Line 5297: fnd_attached_documents2_pkg.

5293: WHERE requisition_line_id = interface.requisition_line_id;
5294:
5295: l_progress:='660';
5296:
5297: fnd_attached_documents2_pkg.
5298: copy_attachments('REQ_HEADERS',
5299: x_requisition_header_id,
5300: '',
5301: '',

Line 5342: fnd_attached_documents2_pkg.

5338: */
5339:
5340: if g_interface_source_code not in ('SOURCING','CONSUMPTION_ADVICE') then -- CONSIGNED FPI
5341: l_progress := '670';
5342: fnd_attached_documents2_pkg.
5343: copy_attachments('REQ_LINES',
5344: interface.requisition_line_id,
5345: '',
5346: '',

Line 5372: fnd_attached_documents2_pkg.

5368: WHERE requisition_line_id = interface.requisition_line_id;
5369:
5370: l_progress:='690';
5371:
5372: fnd_attached_documents2_pkg.
5373: copy_attachments('REQ_HEADERS',
5374: x_requisition_header_id,
5375: '',
5376: '',

Line 5469: FROM fnd_attached_documents fad,

5465: --SQL Why: Need the attached_document_id to move the attachment
5466:
5467: SELECT fad.attached_document_id
5468: INTO l_one_time_att_doc_id
5469: FROM fnd_attached_documents fad,
5470: fnd_documents_tl fdt
5471: WHERE fad.entity_name = 'PO_LINES'
5472: AND fad.pk1_value = to_char(x_po_line_id)
5473: AND fad.document_id = fdt.document_id

Line 5480: UPDATE fnd_attached_documents

5476:
5477: l_progress := '750';
5478:
5479: -- Move the attachment from the PO line to the PO shipment
5480: UPDATE fnd_attached_documents
5481: SET entity_name = 'PO_SHIPMENTS',
5482: pk1_value = to_char(x_line_location_id),
5483: pk2_value = 'ONE_TIME_LOCATION'
5484: WHERE attached_document_id = l_one_time_att_doc_id;

Line 5511: fnd_attached_documents2_pkg.copy_attachments(

5507: -- only then need to copy the one time attachments.
5508: -- copy one-time location from first actual shipment to
5509: -- each payitem.
5510: IF (l_one_time_att_doc_id IS NOT NULL) THEN
5511: fnd_attached_documents2_pkg.copy_attachments(
5512: X_from_entity_name => 'PO_SHIPMENTS'
5513: , X_from_pk1_value => x_line_location_id
5514: , X_from_pk2_value => 'ONE_TIME_LOCATION'
5515: , X_to_entity_name => 'PO_SHIPMENTS'

Line 12343: FROM fnd_attached_documents

12339: -- Query if this req line has a one-time location attachment, which
12340: -- indicates that the req line is for a one-time location.
12341: SELECT 'Y'
12342: INTO l_flag
12343: FROM fnd_attached_documents
12344: WHERE entity_name = 'REQ_LINES'
12345: AND pk1_value = to_char(p_req_line_id)
12346: AND pk2_value = 'ONE_TIME_LOCATION'
12347: AND rownum = 1;