DBA Data[Home] [Help]

APPS.PON_UNSOL_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 43: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (

39: message => 'UDA deletion complete');
40: END IF;
41: END IF;
42:
43: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
44: x_entity_name => 'PON_BID_ITEM_PRICES',
45: x_pk1_value => p_auction_header_id,
46: x_pk2_value => p_bid_number,
47: x_pk3_value => p_line_number);

Line 197: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (

193: END IF;
194: END IF;
195:
196: FOR line IN all_lines LOOP
197: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments (
198: x_entity_name => 'PON_BID_ITEM_PRICES',
199: x_pk1_value => p_auction_header_id,
200: x_pk2_value => p_bid_number,
201: x_pk3_value => line.line_number);

Line 667: FROM fnd_attached_documents ad, pon_bid_item_prices bl

663: ) IS
664:
665: CURSOR unsol_lines_with_attachments IS
666: SELECT DISTINCT ad.pk3_value
667: FROM fnd_attached_documents ad, pon_bid_item_prices bl
668: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
669: AND ad.pk1_value = p_source_header_id
670: AND ad.pk2_value = p_source_bid_num
671: AND ad.pk3_value IS NOT null

Line 678: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments

674: AND bl.auction_line_number = -1;
675:
676: BEGIN
677: FOR line IN unsol_lines_with_attachments LOOP
678: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
679: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
680: x_from_pk1_value => p_source_header_id,
681: x_from_pk2_value => p_source_bid_num,
682: x_from_pk3_value => line.pk3_value,