APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 1195: NOTE: Use the FND function fnd_attached_documents2_pkg.copy_attachments()

1191:
1192: ARGS: IN : p_doc_rec doc_row_type -Some attribute values of the document
1193: IN : is_mod Y/N Is this a modification
1194:
1195: NOTE: Use the FND function fnd_attached_documents2_pkg.copy_attachments()
1196:
1197: ==============================================================================*/
1198: PROCEDURE copy_attachment (p_doc_rec IN doc_row_type, p_is_mod IN VARCHAR2 default 'N')
1199: IS

Line 1440: fnd_attached_documents2_pkg.copy_attachments

1436: IF po_autocreate_params.g_interface_source_code NOT IN
1437: ('SOURCING', 'CONSUMPTION_ADVICE')
1438: THEN -- CONSIGNED FPI
1439: l_progress := '050';
1440: fnd_attached_documents2_pkg.copy_attachments
1441: ('REQ_LINES',
1442: intf_rec.requisition_line_id,
1443: '',
1444: '',

Line 1469: fnd_attached_documents2_pkg.copy_attachments

1465: FROM po_requisition_lines_all --
1466: WHERE requisition_line_id = intf_rec.requisition_line_id;
1467:
1468: l_progress := '070';
1469: fnd_attached_documents2_pkg.copy_attachments
1470: ('REQ_HEADERS',
1471: x_requisition_header_id,
1472: '',
1473: '',

Line 1582: FROM fnd_attached_documents fad, fnd_documents_tl fdt

1578: -- the PO_LINES entity by it's unique iP identifier prefix
1579: --SQL Why: Need the attached_document_id to move the attachment
1580: SELECT fad.attached_document_id
1581: INTO l_one_time_att_doc_id
1582: FROM fnd_attached_documents fad, fnd_documents_tl fdt
1583: WHERE fad.entity_name = 'PO_LINES'
1584: AND fad.pk1_value = TO_CHAR (line_rec.po_line_id)
1585: AND fad.document_id = fdt.document_id
1586: AND fdt.LANGUAGE = USERENV ('LANG')

Line 1605: UPDATE fnd_attached_documents

1601: pk1_shipment := to_char(x_line_location_id);
1602: END IF;
1603:
1604: -- Move the attachment from the PO line to the PO shipment
1605: UPDATE fnd_attached_documents
1606: SET entity_name = 'PO_SHIPMENTS',
1607: pk1_value = pk1_shipment, --TO_CHAR (x_line_location_id),
1608: pk2_value = 'ONE_TIME_LOCATION'
1609: WHERE attached_document_id = l_one_time_att_doc_id;

Line 1642: fnd_attached_documents2_pkg.copy_attachments

1638: l_progress := '150';
1639:
1640: IF (l_one_time_att_doc_id IS NOT NULL)
1641: THEN
1642: fnd_attached_documents2_pkg.copy_attachments
1643: (x_from_entity_name => 'PO_SHIPMENTS',
1644: x_from_pk1_value => x_line_location_id,
1645: x_from_pk2_value => 'ONE_TIME_LOCATION',
1646: x_to_entity_name => 'PO_SHIPMENTS',