APPS.PON_BID_DEFAULTING_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 2158: FND_ATTACHED_DOCUMENTS fnd,

2154: dest_pay.bid_line_number dest_bid_line_number,
2155: dest_pay.bid_payment_id dest_bid_payment_id
2156: FROM
2157: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2158: FND_ATTACHED_DOCUMENTS fnd,
2159: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2160: PON_BID_ITEM_PRICES bl
2161: WHERE bl.auction_header_id = p_auc_header_id
2162: AND bl.bid_number = p_bid_number

Line 2396: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

2392: END IF;
2393: END IF;
2394: --copy the attachments for those payments which came from bid
2395: FOR payment_rec in c_bid_pymnts_attach LOOP
2396: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
2397: X_from_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
2398: X_from_pk1_value => to_char(payment_rec.source_bid_number),
2399: X_from_pk2_value => to_char(payment_rec.source_bid_line_number),
2400: X_from_pk3_value => to_char(payment_rec.source_bid_payment_id),

Line 2444: FROM fnd_attached_documents ad, pon_bid_item_prices bl

2440: ) IS
2441:
2442: CURSOR bid_lines_with_attachments IS
2443: SELECT DISTINCT ad.pk3_value
2444: FROM fnd_attached_documents ad, pon_bid_item_prices bl
2445: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
2446: AND ad.pk1_value = p_source_header_id
2447: AND ad.pk2_value = p_source_bid_num
2448: AND ad.pk3_value IS NOT null

Line 2458: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments

2454: BEGIN
2455: IF p_change_categ_id = 'Y' then
2456: -- Copy the line's attachments only for unmodified lines, with new target category.
2457: FOR line IN bid_lines_with_attachments LOOP
2458: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2459: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2460: x_from_pk1_value => p_source_header_id,
2461: x_from_pk2_value => p_source_bid_num,
2462: x_from_pk3_value => line.pk3_value,

Line 2474: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments

2470: END LOOP;
2471: ELSE
2472: -- Copy the line's attachments only for unmodified lines
2473: FOR line IN bid_lines_with_attachments LOOP
2474: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2475: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2476: x_from_pk1_value => p_source_header_id,
2477: x_from_pk2_value => p_source_bid_num,
2478: x_from_pk3_value => line.pk3_value,

Line 2746: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments

2742:
2743: log_message(l_module, 'Two-Part related variables: l_to_category_id: ' || l_to_category_id || '; l_categ_id_supp_tech: '||l_categ_id_supp_tech||'; l_categ_id_supp: ' || l_categ_id_supp);
2744:
2745: -- Copy header attachments to new target category
2746: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2747: (x_from_entity_name => 'PON_BID_HEADERS',
2748: x_from_pk1_value => l_source_header_id,
2749: x_from_pk2_value => p_source_bid_num,
2750: x_to_entity_name => 'PON_BID_HEADERS',

Line 2759: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments

2755: x_to_category_id => l_to_category_id);
2756:
2757: ELSE
2758: -- Copy header level attachments without changing categories
2759: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2760: (x_from_entity_name => 'PON_BID_HEADERS',
2761: x_from_pk1_value => l_source_header_id,
2762: x_from_pk2_value => p_source_bid_num,
2763: x_to_entity_name => 'PON_BID_HEADERS',