APPS.PON_NEGOTIATION_COPY_GRP dependencies on FND_ATTACHED_DOCUMENTS2_PKG

Line 4257: -- FND_ATTACHED_DOCUMENTS2_PKG API. But, most of the time it is NULL

4253: -- Copy Attachments for Lines if user wants to retain the attachments of the
4254: -- source document and the corresponding line in the source document has
4255: -- attachment flag on. It tried to assume that the original document should have
4256: -- the ATTACHMENT_FLAG properly set to prevent redundant calls on
4257: -- FND_ATTACHED_DOCUMENTS2_PKG API. But, most of the time it is NULL
4258: -- even if there are attachments. Hence dropping the condition as of now
4259: --
4260:
4261: /*

Line 4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

4293: AND ATTACHED_DOCUMENT_ID NOT IN
4294: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
4295: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
4296:
4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4298: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4299: X_from_pk1_value => base_attach_rec.pk1_value,
4300: X_from_pk2_value => base_attach_rec.pk2_value,
4301: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

Line 4311: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

4307: );
4308: END LOOP;
4309:
4310: ELSE
4311: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4312: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4313: X_from_pk1_value => to_char(p_source_auction_header_id),
4314: X_from_pk2_value => to_char(l_line_number(x)),
4315: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

Line 5894: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

5890: in ('PON_AUC_PAYMENTS_SHIPMENTS',
5891: 'PON_AUC_PAYMENTS_SHIPMENTS_DEL')
5892: AND ORIG_ATTACH_DOC_ID =fad.ORIG_ATTACH_DOC_ID)) LOOP
5893:
5894: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5895: X_from_entity_name => base_attach_rec.ENTITY_NAME,
5896: X_from_pk1_value => base_attach_rec.pk1_value,
5897: X_from_pk2_value => base_attach_rec.pk2_value,
5898: X_from_pk3_value => base_attach_rec.pk3_value,

Line 5922: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

5918: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5919: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'
5920: ) LOOP
5921:
5922: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5923: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5924: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5925: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5926: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),

Line 5939: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

5935: END LOOP;
5936:
5937: ELSE
5938:
5939: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5940: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5941: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5942: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5943: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),

Line 11962: -- Using fnd_attached_documents2_pkg.copy_attachments

11958: IF (p_retain_attachments = 'Y' AND
11959: (l_is_federal = 0 OR p_copy_type <> g_amend_copy)) THEN
11960: --
11961: -- Copy Header and line level attachments here
11962: -- Using fnd_attached_documents2_pkg.copy_attachments
11963: -- for this purpose
11964: --
11965: -- Header Attachments copy
11966: --

Line 11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

11988: AND ATTACHED_DOCUMENT_ID NOT IN
11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
11990: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
11991:
11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
11993: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
11994: X_from_pk1_value => base_attach_rec.pk1_value,
11995: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
11996: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 12004: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

12000: );
12001: END LOOP;
12002:
12003: ELSE
12004: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
12005: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
12006: X_from_pk1_value => to_char(p_source_auction_header_id),
12007: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
12008: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 13513: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

13509: INTO l_pk1_value, l_pk2_value, l_pk3_value
13510: FROM fnd_attached_documents
13511: WHERE attached_document_id = payments_orig_doc_id;
13512:
13513: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
13514: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
13515: X_from_pk1_value => l_pk1_value,
13516: X_from_pk2_value => l_pk2_value,
13517: X_from_pk3_value => l_pk3_value,

Line 13529: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

13525: );
13526:
13527: ELSE
13528:
13529: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
13530: X_from_entity_name => p_from_entity_name,
13531: X_from_pk1_value => p_from_pk1_value,
13532: X_from_pk2_value => p_from_pk2_value,
13533: X_from_pk3_value => p_from_pk3_value,