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 39: (x_entity_name => 'PON_BID_ITEM_PRICES',

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

Line 57: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

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

Line 58: p_batch_end IN pon_bid_item_prices.line_number%TYPE

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

Line 125: l_max_line_number pon_bid_item_prices.line_number%TYPE;

121: (
122: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
123: p_bid_number IN pon_bid_headers.bid_number%TYPE
124: ) IS
125: l_max_line_number pon_bid_item_prices.line_number%TYPE;
126: l_batch_start pon_bid_item_prices.line_number%TYPE;
127: l_batch_end pon_bid_item_prices.line_number%TYPE;
128:
129: --Unsolicited Lines Project

Line 126: l_batch_start pon_bid_item_prices.line_number%TYPE;

122: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
123: p_bid_number IN pon_bid_headers.bid_number%TYPE
124: ) IS
125: l_max_line_number pon_bid_item_prices.line_number%TYPE;
126: l_batch_start pon_bid_item_prices.line_number%TYPE;
127: l_batch_end pon_bid_item_prices.line_number%TYPE;
128:
129: --Unsolicited Lines Project
130: l_result VARCHAR2(1);

Line 127: l_batch_end pon_bid_item_prices.line_number%TYPE;

123: p_bid_number IN pon_bid_headers.bid_number%TYPE
124: ) IS
125: l_max_line_number pon_bid_item_prices.line_number%TYPE;
126: l_batch_start pon_bid_item_prices.line_number%TYPE;
127: l_batch_end pon_bid_item_prices.line_number%TYPE;
128:
129: --Unsolicited Lines Project
130: l_result VARCHAR2(1);
131: l_error_code VARCHAR2(100);

Line 204: DELETE FROM pon_bid_item_prices

200: l_batch_start,
201: l_batch_end);
202:
203: -- Delete lines
204: DELETE FROM pon_bid_item_prices
205: WHERE bid_number = p_bid_number
206: AND line_number BETWEEN l_batch_start AND l_batch_end;
207:
208: -- If there is more than one batch, then commit the batch