APPS.PON_MULTIPLE_RESPONSE_PKG dependencies on PON_BID_ITEM_PRICES

Line 279: l_max_line_number pon_bid_item_prices.line_number%TYPE;

275: ------------------------------------------------------------------
276: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
277: x_rebid_flag OUT NOCOPY VARCHAR2
278: ) IS
279: l_max_line_number pon_bid_item_prices.line_number%TYPE;
280: l_batch_start pon_bid_item_prices.line_number%TYPE;
281: l_batch_end pon_bid_item_prices.line_number%TYPE;
282: BEGIN
283:

Line 280: l_batch_start pon_bid_item_prices.line_number%TYPE;

276: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
277: x_rebid_flag OUT NOCOPY VARCHAR2
278: ) IS
279: l_max_line_number pon_bid_item_prices.line_number%TYPE;
280: l_batch_start pon_bid_item_prices.line_number%TYPE;
281: l_batch_end pon_bid_item_prices.line_number%TYPE;
282: BEGIN
283:
284: SELECT bh.old_bid_number

Line 281: l_batch_end pon_bid_item_prices.line_number%TYPE;

277: x_rebid_flag OUT NOCOPY VARCHAR2
278: ) IS
279: l_max_line_number pon_bid_item_prices.line_number%TYPE;
280: l_batch_start pon_bid_item_prices.line_number%TYPE;
281: l_batch_end pon_bid_item_prices.line_number%TYPE;
282: BEGIN
283:
284: SELECT bh.old_bid_number
285: INTO x_prev_bid_number

Line 315: /*UPDATE pon_bid_item_prices bl

311: WHILE (l_batch_start <= l_max_line_number) LOOP
312:
313: -- Copy over price columns and set copy_price_for_proxy_flag
314: -- If the proxy has been exhausted, copy_price_for_proxy flag changed to N
315: /*UPDATE pon_bid_item_prices bl
316: SET (bl.price, bl.proxy_bid_limit_price, bl.bid_currency_price,
317: bl.bid_currency_limit_price, bl.bid_currency_trans_price,
318: bl.unit_price, bl.bid_currency_unit_price, bl.copy_price_for_proxy_flag,
319: bl.old_price, bl.old_bid_currency_unit_price, bl.old_bid_currency_price,

Line 327: FROM pon_bid_item_prices old_bl

323: old_bl.unit_price, old_bl.bid_currency_unit_price,
324: decode(sign(old_bl.proxy_bid_limit_price - old_bl.price),
325: 0, 'N', 'Y'),
326: old_bl.price, old_bl.bid_currency_unit_price, old_bl.bid_currency_price, old_bl.bid_currency_limit_price
327: FROM pon_bid_item_prices old_bl
328: WHERE old_bl.bid_number = x_prev_bid_number
329: AND old_bl.line_number = bl.line_number)
330: WHERE bl.bid_number = p_draft_bid_num
331: AND bl.copy_price_for_proxy_flag = 'Y'

Line 335: UPDATE pon_bid_item_prices bl

331: AND bl.copy_price_for_proxy_flag = 'Y'
332: AND bl.line_number BETWEEN l_batch_start AND l_batch_end; */
333:
334: -- Copy over the rank for all lines
335: UPDATE pon_bid_item_prices bl
336: SET rank =
337: (SELECT old_bl.rank
338: FROM pon_bid_item_prices old_bl
339: WHERE old_bl.bid_number = x_prev_bid_number

Line 338: FROM pon_bid_item_prices old_bl

334: -- Copy over the rank for all lines
335: UPDATE pon_bid_item_prices bl
336: SET rank =
337: (SELECT old_bl.rank
338: FROM pon_bid_item_prices old_bl
339: WHERE old_bl.bid_number = x_prev_bid_number
340: AND old_bl.line_number = bl.line_number)
341: WHERE bl.bid_number = p_draft_bid_num
342: AND bl.line_number BETWEEN l_batch_start AND l_batch_end