APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_BID_ITEM_PRICES

Line 19: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

15: PROCEDURE delete_line_attachments
16: (
17: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
18: p_bid_number IN pon_bid_headers.bid_number%TYPE,
19: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
20: p_batch_end IN pon_bid_item_prices.line_number%TYPE
21: ) IS
22:
23: -- Determine which lines have attachments

Line 20: p_batch_end IN pon_bid_item_prices.line_number%TYPE

16: (
17: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
18: p_bid_number IN pon_bid_headers.bid_number%TYPE,
19: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
20: p_batch_end IN pon_bid_item_prices.line_number%TYPE
21: ) IS
22:
23: -- Determine which lines have attachments
24: CURSOR bid_lines_with_attachments IS

Line 27: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'

23: -- Determine which lines have attachments
24: CURSOR bid_lines_with_attachments IS
25: SELECT DISTINCT ad.pk3_value
26: FROM fnd_attached_documents ad
27: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
28: AND ad.pk1_value = p_auc_header_id
29: AND ad.pk2_value = p_bid_number
30: AND ad.pk3_value IS NOT null
31: AND to_number(ad.pk3_value) BETWEEN p_batch_start AND p_batch_end;

Line 37: (x_entity_name => 'PON_BID_ITEM_PRICES',

33:
34: -- Delete all line level attachments
35: FOR line IN bid_lines_with_attachments LOOP
36: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
37: (x_entity_name => 'PON_BID_ITEM_PRICES',
38: x_pk1_value => p_auc_header_id,
39: x_pk2_value => p_bid_number,
40: x_pk3_value => line.pk3_value,
41: x_delete_document_flag => 'Y');

Line 55: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

51: -- ======================================================================
52: PROCEDURE delete_bid_payment_attachments
53: (
54: p_bid_number IN pon_bid_headers.bid_number%TYPE,
55: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
56: p_batch_end IN pon_bid_item_prices.line_number%TYPE
57: ) IS
58:
59: l_module_name VARCHAR2 (30);

Line 56: p_batch_end IN pon_bid_item_prices.line_number%TYPE

52: PROCEDURE delete_bid_payment_attachments
53: (
54: p_bid_number IN pon_bid_headers.bid_number%TYPE,
55: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
56: p_batch_end IN pon_bid_item_prices.line_number%TYPE
57: ) IS
58:
59: l_module_name VARCHAR2 (30);
60:

Line 123: l_max_line_number pon_bid_item_prices.line_number%TYPE;

119: (
120: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
121: p_bid_number IN pon_bid_headers.bid_number%TYPE
122: ) IS
123: l_max_line_number pon_bid_item_prices.line_number%TYPE;
124: l_batch_start pon_bid_item_prices.line_number%TYPE;
125: l_batch_end pon_bid_item_prices.line_number%TYPE;
126: BEGIN
127:

Line 124: l_batch_start pon_bid_item_prices.line_number%TYPE;

120: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
121: p_bid_number IN pon_bid_headers.bid_number%TYPE
122: ) IS
123: l_max_line_number pon_bid_item_prices.line_number%TYPE;
124: l_batch_start pon_bid_item_prices.line_number%TYPE;
125: l_batch_end pon_bid_item_prices.line_number%TYPE;
126: BEGIN
127:
128: -- START BATCHING

Line 125: l_batch_end pon_bid_item_prices.line_number%TYPE;

121: p_bid_number IN pon_bid_headers.bid_number%TYPE
122: ) IS
123: l_max_line_number pon_bid_item_prices.line_number%TYPE;
124: l_batch_start pon_bid_item_prices.line_number%TYPE;
125: l_batch_end pon_bid_item_prices.line_number%TYPE;
126: BEGIN
127:
128: -- START BATCHING
129:

Line 190: DELETE FROM pon_bid_item_prices

186: l_batch_start,
187: l_batch_end);
188:
189: -- Delete lines
190: DELETE FROM pon_bid_item_prices
191: WHERE bid_number = p_bid_number
192: AND line_number BETWEEN l_batch_start AND l_batch_end;
193:
194: -- If there is more than one batch, then commit the batch