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);
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);
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
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,