APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 6804: -- FND_ATTACHED_DOCUMENTS / FND_DOCUMENTS

6800: --Name: archive_attachments
6801: --Pre-reqs:
6802: -- None.
6803: --Modifies:
6804: -- FND_ATTACHED_DOCUMENTS / FND_DOCUMENTS
6805: --Locks:
6806: -- None.
6807: --Function:
6808: -- Archives the Attachments with pk1_value = po_header_id-draft_id

Line 6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

6836: d_mod CONSTANT VARCHAR2(100) := 'archive_attachments';
6837: l_progress VARCHAR2(4) := '000';
6838:
6839: l_from_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

Line 6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

6838:
6839: l_from_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

Line 6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6847:
6848: -- Cursor definitions:

Line 6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;

6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6847:
6848: -- Cursor definitions:
6849:
6850: CURSOR po_line_cursor(p_po_header_id po_lines.po_header_id%TYPE) IS

Line 6887: fnd_attached_documents2_pkg.copy_attachments('PO_HEADERS',

6883: 'Copy Header Attachment from pk1_value: '|| l_from_po_header_id
6884: || ' to pk1_value: '||l_to_po_header_id);
6885: END IF;
6886:
6887: fnd_attached_documents2_pkg.copy_attachments('PO_HEADERS',
6888: l_from_po_header_id,
6889: '',
6890: '',
6891: '',

Line 6930: fnd_attached_documents2_pkg.copy_attachments('PO_LINES',

6926: 'Copy Line Attachments from pk1_value: '|| l_from_po_line_id
6927: || ' to pk1_value: '||l_to_po_line_id);
6928: END IF;
6929:
6930: fnd_attached_documents2_pkg.copy_attachments('PO_LINES',
6931: l_from_po_line_id,
6932: '',
6933: '',
6934: '',

Line 6967: fnd_attached_documents2_pkg.copy_attachments('PO_SHIPMENTS',

6963: 'Copy Shipment Attachments from pk1_value: '|| l_from_line_location_id
6964: || ' to pk1_value: '||l_to_line_location_id);
6965: END IF;
6966:
6967: fnd_attached_documents2_pkg.copy_attachments('PO_SHIPMENTS',
6968: l_from_line_location_id,
6969: '',
6970: '',
6971: '',

Line 7003: fnd_attached_documents2_pkg.copy_attachments('PO_DISTRIBUTIONS',

6999: 'Copy Distribution Attachments from pk1_value: '|| l_from_po_distribution_id
7000: || ' to pk1_value: '||l_to_po_distribution_id);
7001: END IF;
7002:
7003: fnd_attached_documents2_pkg.copy_attachments('PO_DISTRIBUTIONS',
7004: l_from_po_distribution_id,
7005: '',
7006: '',
7007: '',