eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_RESPONSE_PVT dependencies on PON_BID_ITEM_PRICES

Line 73: p_line_number IN pon_bid_item_prices.line_number%TYPE,

69: END get_header_close_bidding_date;
70:
71: FUNCTION get_line_close_bidding_date
72: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
73: p_line_number IN pon_bid_item_prices.line_number%TYPE,
74: p_is_paused IN pon_auction_headers_all.is_paused%TYPE,
75: p_pause_date IN pon_auction_headers_all.last_pause_date%TYPE)
76: RETURN DATE
77: IS

Line 107: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

103: -- we have two variations of this procedure:
104: -- 1) calculate group amount for the given line
105: -- 2) calculate group amount for all lines in the given bid
106: -- -------------------------------------------------------------------------
107: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
108: p_is_supplier IN VARCHAR)
109: IS
110: BEGIN
111: calculate_group_amounts(p_bid_number, p_is_supplier, 'Y', -1);

Line 114: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

110: BEGIN
111: calculate_group_amounts(p_bid_number, p_is_supplier, 'Y', -1);
112: END calculate_group_amounts;
113:
114: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
115: p_is_supplier IN VARCHAR,
116: p_do_all_lines IN VARCHAR,
117: p_batch_id IN pon_bid_item_prices.batch_id%TYPE)
118: IS

Line 117: p_batch_id IN pon_bid_item_prices.batch_id%TYPE)

113:
114: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
115: p_is_supplier IN VARCHAR,
116: p_do_all_lines IN VARCHAR,
117: p_batch_id IN pon_bid_item_prices.batch_id%TYPE)
118: IS
119:
120: l_api_name CONSTANT VARCHAR2(30) := 'calculate_group_amounts';
121: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

Line 160: UPDATE pon_bid_item_prices p1

156: print_log(l_api_name, p_bid_number || ' - v_doctype=' || v_doctype);
157: print_log(l_api_name, p_bid_number || ' - v_contract_type=' || v_contract_type);
158: END IF;
159:
160: UPDATE pon_bid_item_prices p1
161: SET p1.group_amount =
162: (SELECT SUM(decode(p_is_supplier,
163: 'Y', p2.bid_currency_price,
164: p2.price) *

Line 170: FROM pon_bid_item_prices p2,

166: 'FIXED PRICE', 1,
167: decode(v_contract_type,
168: 'STANDARD', p2.quantity,
169: nvl(p2.quantity, a1.quantity))))
170: FROM pon_bid_item_prices p2,
171: pon_auction_item_prices_all a1
172: WHERE p2.bid_number = p_bid_number
173: AND a1.auction_header_id = p2.auction_header_id
174: AND p2.line_number = a1.line_number

Line 190: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

186: END IF;
187:
188: END calculate_group_amounts;
189:
190: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
191: p_line_number IN pon_bid_item_prices.line_number%TYPE,
192: p_is_supplier IN VARCHAR,
193: p_group_amount OUT NOCOPY NUMBER)
194: IS

Line 191: p_line_number IN pon_bid_item_prices.line_number%TYPE,

187:
188: END calculate_group_amounts;
189:
190: PROCEDURE calculate_group_amounts(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
191: p_line_number IN pon_bid_item_prices.line_number%TYPE,
192: p_is_supplier IN VARCHAR,
193: p_group_amount OUT NOCOPY NUMBER)
194: IS
195:

Line 247: FROM pon_bid_item_prices groups,

243: decode(v_contract_type,
244: 'STANDARD', group_line.quantity,
245: nvl(group_line.quantity, auc_line.quantity))))
246: INTO p_group_amount
247: FROM pon_bid_item_prices groups,
248: pon_bid_item_prices group_line,
249: pon_auction_item_prices_all auc_line
250: WHERE groups.bid_number = p_bid_number
251: AND group_line.bid_number = groups.bid_number

Line 248: pon_bid_item_prices group_line,

244: 'STANDARD', group_line.quantity,
245: nvl(group_line.quantity, auc_line.quantity))))
246: INTO p_group_amount
247: FROM pon_bid_item_prices groups,
248: pon_bid_item_prices group_line,
249: pon_auction_item_prices_all auc_line
250: WHERE groups.bid_number = p_bid_number
251: AND group_line.bid_number = groups.bid_number
252: AND groups.line_number = p_line_number

Line 263: PROCEDURE calculate_group_amounts_auto(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

259: END IF;
260:
261: END calculate_group_amounts;
262:
263: PROCEDURE calculate_group_amounts_auto(p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
264: p_is_supplier IN VARCHAR)
265: IS
266: PRAGMA AUTONOMOUS_TRANSACTION;
267:

Line 295: (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

291: -- specified bid by the specified percentage.
292: -- -------------------------------------------------------------------------
293:
294: PROCEDURE change_bid_by_percentage
295: (p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
296: p_power_percentage IN NUMBER,
297: p_powerbidlosinglines IN VARCHAR2,
298: p_previous_bid_number IN pon_bid_headers.old_bid_number%TYPE)
299: IS

Line 343: UPDATE pon_bid_item_prices pbip

339: END IF;
340:
341: WHILE (v_batch_start <= v_max_line_number) LOOP
342:
343: UPDATE pon_bid_item_prices pbip
344: SET pbip.bid_currency_price = round(pbip.bid_currency_price * (1 - p_power_percentage / 100), v_precision),
345: pbip.bid_currency_unit_price = round(pbip.bid_currency_price * (1 - p_power_percentage / 100), v_precision),
346: pbip.bid_currency_trans_price = round(pbip.bid_currency_price * (1 - p_power_percentage / 100), v_precision),
347: pbip.price = (round(pbip.bid_currency_price * (1 - p_power_percentage / 100), v_precision)) / v_rate,

Line 375: FROM pon_bid_item_prices pbip

371: SET pbs.bid_currency_unit_price =
372: DECODE(pbs.price_type,
373: 'PRICE', round(pbs.bid_currency_price * (1 - p_power_percentage/100), v_precision),
374: round((SELECT pbip.bid_currency_unit_price
375: FROM pon_bid_item_prices pbip
376: WHERE pbip.bid_number = pbs.bid_number
377: AND pbip.line_number = pbs.line_number) *
378: (1 - pbs.price_discount/100), v_precision))
379: WHERE pbs.bid_number = p_bid_number

Line 381: FROM pon_bid_item_prices pbip

377: AND pbip.line_number = pbs.line_number) *
378: (1 - pbs.price_discount/100), v_precision))
379: WHERE pbs.bid_number = p_bid_number
380: AND pbs.line_number IN (SELECT pbip.line_number
381: FROM pon_bid_item_prices pbip
382: WHERE pbip.bid_number = pbs.bid_number
383: AND ((get_line_close_bidding_date(pbip.auction_header_id, pbip.line_number, v_is_paused, v_paused_date) > sysdate) OR (v_surrog_bid_flag = 'Y'))
384: AND pbip.copy_price_for_proxy_flag = 'N')
385: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'

Line 405: FROM pon_bid_item_prices pbip

401: pbs.unit_price = pbs.bid_currency_unit_price / v_rate,
402: pbs.price = pbs.bid_currency_unit_price / v_rate
403: WHERE pbs.bid_number = p_bid_number
404: AND pbs.line_number IN (SELECT pbip.line_number
405: FROM pon_bid_item_prices pbip
406: WHERE pbip.bid_number = pbs.bid_number
407: AND ((get_line_close_bidding_date(pbip.auction_header_id, pbip.line_number, v_is_paused, v_paused_date) > sysdate) OR (v_surrog_bid_flag = 'Y'))
408: AND pbip.copy_price_for_proxy_flag = 'N')
409: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'

Line 459: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

455: -- -------------------------------------------------------------------------
456:
457: PROCEDURE recalculate_auc_curr_prices
458: (
459: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
460: p_curr_changed IN VARCHAR2,
461: p_batch_id IN pon_bid_item_prices.batch_id%TYPE
462: )
463: IS

Line 461: p_batch_id IN pon_bid_item_prices.batch_id%TYPE

457: PROCEDURE recalculate_auc_curr_prices
458: (
459: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
460: p_curr_changed IN VARCHAR2,
461: p_batch_id IN pon_bid_item_prices.batch_id%TYPE
462: )
463: IS
464:
465: v_rate NUMBER;

Line 468: v_display_price_factors_flag pon_bid_item_prices.display_price_factors_flag%TYPE;

464:
465: v_rate NUMBER;
466: v_precision NUMBER;
467: v_fnd_precision NUMBER;
468: v_display_price_factors_flag pon_bid_item_prices.display_price_factors_flag%TYPE;
469: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
470: v_contract_type pon_auction_headers_all.contract_type%TYPE;
471: v_is_spo_transformed VARCHAR(1);
472: v_auction_header_id NUMBER;

Line 598: UPDATE pon_bid_item_prices pbip

594: v_is_spo_transformed := 'N';
595: END IF;
596:
597: -- (1) apply BPF formula
598: UPDATE pon_bid_item_prices pbip
599: SET pbip.bid_currency_trans_price = nvl(
600: (SELECT (pbip.bid_currency_unit_price * ppsf.percentage) +
601: ppsf.unit_price*v_rate +
602: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,

Line 624: UPDATE pon_bid_item_prices pbip

620: pbip.line_number <= v_batch_end)
621: OR pbip.batch_id = p_batch_id);
622:
623: -- (2) apply SPF values
624: UPDATE pon_bid_item_prices pbip
625: SET pbip.bid_currency_trans_price =
626: (SELECT pbip.bid_currency_trans_price +
627: nvl(sum( Decode(Nvl(negative_cost_factor_flag,'N'),'Y',
628: -decode(spf.pricing_basis,

Line 677: UPDATE pon_bid_item_prices pbip

673: -- work fields is almost same. So, if you change one, also consider impact on others.
674:
675: IF p_curr_changed = 'Y' THEN
676:
677: UPDATE pon_bid_item_prices pbip
678: SET pbip.unit_price = pbip.bid_currency_unit_price / v_rate,
679: pbip.price = pbip.bid_currency_trans_price / v_rate,
680: pbip.bid_currency_price = DECODE(v_supplier_view_type,
681: 'TRANSFORMED', round(pbip.bid_currency_trans_price, v_precision),

Line 724: UPDATE pon_bid_item_prices pbip

720: pbip.line_number <= v_batch_end)
721: OR pbip.batch_id = p_batch_id);
722: ELSE
723:
724: UPDATE pon_bid_item_prices pbip
725: SET pbip.unit_price = pbip.bid_currency_unit_price / v_rate,
726: pbip.price = pbip.bid_currency_trans_price / v_rate,
727: pbip.bid_currency_price = DECODE(v_supplier_view_type,
728: 'TRANSFORMED', round(pbip.bid_currency_trans_price, v_precision),

Line 764: pon_bid_item_prices pbip

760: nvl(aip.quantity, 1)))
761: FROM pon_pf_supplier_formula ppsf,
762: pon_bid_headers pbh,
763: pon_auction_item_prices_all aip,
764: pon_bid_item_prices pbip
765: WHERE pbip.bid_number = pbs.bid_number
766: AND pbip.line_number = pbs.line_number
767: AND ppsf.auction_header_id = pbip.auction_header_id
768: AND ppsf.line_number = pbip.line_number

Line 793: pon_bid_item_prices pbip

789: nvl(aip.quantity, 1))))),
790: 0)
791: FROM pon_bid_price_elements spf,
792: pon_auction_item_prices_all aip,
793: pon_bid_item_prices pbip
794: WHERE pbip.bid_number = pbs.bid_number
795: AND pbip.line_number = pbs.line_number
796: AND spf.bid_number = p_bid_number
797: AND spf.line_number = pbip.line_number

Line 864: Cursor infoCursor Is select auction_header_id,auction_line_number,line_number,group_line_id from pon_bid_item_prices where

860:
861: PROCEDURE MARK_UNSOL_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)
862: IS
863: --Unsolicited Lines Project : Mark Unsolicited info lines.
864: Cursor infoCursor Is select auction_header_id,auction_line_number,line_number,group_line_id from pon_bid_item_prices where
865: bid_number = p_bid_number and nvl(clm_info_flag,'N') = 'Y' AND auction_line_number = -1;
866: l_award_flag Varchar2(1);
867: l_bid_line_count Number;
868: BEGIN

Line 872: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = infoLine.group_line_id;

868: BEGIN
869: For infoLine in infoCursor loop
870: if ( infoLine.group_line_id IS NOT null ) THEN
871: --slin info line check parent line
872: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = infoLine.group_line_id;
873: if ( l_award_flag = 'Y' ) Then
874: update pon_bid_item_prices
875: set has_bid_flag = l_award_flag
876: where bid_number = p_bid_number

Line 874: update pon_bid_item_prices

870: if ( infoLine.group_line_id IS NOT null ) THEN
871: --slin info line check parent line
872: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = infoLine.group_line_id;
873: if ( l_award_flag = 'Y' ) Then
874: update pon_bid_item_prices
875: set has_bid_flag = l_award_flag
876: where bid_number = p_bid_number
877: and line_number = infoLine.line_number;
878: end if;

Line 881: select count(*) into l_bid_line_count from pon_bid_item_prices where

877: and line_number = infoLine.line_number;
878: end if;
879: else
880: --info CLIN
881: select count(*) into l_bid_line_count from pon_bid_item_prices where
882: bid_number = p_bid_number and group_line_id = infoLine.line_number and nvl(has_bid_flag,'N') = 'Y';
883:
884: if ( l_bid_line_count > 0 ) THEN
885: update pon_bid_item_prices

Line 885: update pon_bid_item_prices

881: select count(*) into l_bid_line_count from pon_bid_item_prices where
882: bid_number = p_bid_number and group_line_id = infoLine.line_number and nvl(has_bid_flag,'N') = 'Y';
883:
884: if ( l_bid_line_count > 0 ) THEN
885: update pon_bid_item_prices
886: set has_bid_flag = 'Y'
887: where bid_number = p_bid_number
888: and line_number = infoLine.line_number;
889: end if;

Line 913: UPDATE pon_bid_item_prices

909: END IF;
910:
911: IF p_rebid_flag = 'N' THEN
912:
913: UPDATE pon_bid_item_prices
914: SET publish_date = p_publish_date,
915: proxy_bid_flag = 'N',
916: award_price = price,
917: first_bid_price = price, --(woojin) do we really need this?

Line 925: UPDATE pon_bid_item_prices

921: AND auction_line_number = -1; --Unsolicited Lines Project : Update unsol lines.
922:
923: ELSE
924:
925: UPDATE pon_bid_item_prices
926: SET publish_date = p_publish_date,
927: proxy_bid_flag = 'N',
928: award_price = price,
929: first_bid_price = nvl(first_bid_price, price), --(woojin) do we really need this?

Line 937: UPDATE pon_bid_item_prices

933: AND is_changed_line_flag = 'Y'
934: AND auction_line_number = -1; --Unsolicited Lines Project : Update unsol lines.
935:
936: --Added for bug 10169313
937: UPDATE pon_bid_item_prices
938: SET award_price = price
939: WHERE bid_number = p_bid_number
940: AND is_changed_line_flag <> 'Y'
941: AND auction_line_number = -1; --Unsolicited Lines Project : Update unsol lines.

Line 1387: Cursor infoCursor Is select auction_header_id,auction_line_number,line_number,group_line_id from pon_bid_item_prices where

1383: PROCEDURE MARK_INFO_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)
1384: IS
1385:
1386: --Unsolicited Lines Project : Mark only negotiation lines. Unsolicited info lines will be marked seperately.
1387: Cursor infoCursor Is select auction_header_id,auction_line_number,line_number,group_line_id from pon_bid_item_prices where
1388: bid_number = p_bid_number and nvl(clm_info_flag,'N') = 'Y' AND auction_line_number <> -1;
1389: l_award_flag Varchar2(1);
1390: l_bid_line_count Number;
1391: BEGIN

Line 1395: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = infoLine.group_line_id;

1391: BEGIN
1392: For infoLine in infoCursor loop
1393: if ( pon_clm_util_pkg.is_line_clin(infoLine.auction_header_id,infoLine.auction_line_number) = FALSE ) THEN
1394: --slin info line check parent line
1395: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = infoLine.group_line_id;
1396: if ( l_award_flag = 'Y' ) Then
1397: update pon_bid_item_prices
1398: set has_bid_flag = l_award_flag
1399: where bid_number = p_bid_number

Line 1397: update pon_bid_item_prices

1393: if ( pon_clm_util_pkg.is_line_clin(infoLine.auction_header_id,infoLine.auction_line_number) = FALSE ) THEN
1394: --slin info line check parent line
1395: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = infoLine.group_line_id;
1396: if ( l_award_flag = 'Y' ) Then
1397: update pon_bid_item_prices
1398: set has_bid_flag = l_award_flag
1399: where bid_number = p_bid_number
1400: and line_number = infoLine.line_number;
1401: end if;

Line 1404: select count(*) into l_bid_line_count from pon_bid_item_prices where

1400: and line_number = infoLine.line_number;
1401: end if;
1402: else
1403: --info CLIN
1404: select count(*) into l_bid_line_count from pon_bid_item_prices where
1405: bid_number = p_bid_number and group_line_id = infoLine.line_number and nvl(has_bid_flag,'N') = 'Y';
1406:
1407: if ( l_bid_line_count > 0 ) THEN
1408: update pon_bid_item_prices

Line 1408: update pon_bid_item_prices

1404: select count(*) into l_bid_line_count from pon_bid_item_prices where
1405: bid_number = p_bid_number and group_line_id = infoLine.line_number and nvl(has_bid_flag,'N') = 'Y';
1406:
1407: if ( l_bid_line_count > 0 ) THEN
1408: update pon_bid_item_prices
1409: set has_bid_flag = 'Y'
1410: where bid_number = p_bid_number
1411: and line_number = infoLine.line_number;
1412: end if;

Line 1419: Cursor optCursor Is select auction_header_id,auction_line_number,line_number,clm_base_line_num from pon_bid_item_prices where

1415: END MARK_INFO_LINES;
1416:
1417: PROCEDURE MARK_OPTION_LINES(p_bid_number IN pon_bid_headers.bid_number%TYPE)
1418: IS
1419: Cursor optCursor Is select auction_header_id,auction_line_number,line_number,clm_base_line_num from pon_bid_item_prices where
1420: bid_number = p_bid_number and clm_base_line_num is not null and nvl(has_bid_flag,'N') = 'N';
1421: l_award_flag Varchar2(1);
1422: BEGIN
1423: For optLine in optCursor loop

Line 1425: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = optLine.clm_base_line_num;

1421: l_award_flag Varchar2(1);
1422: BEGIN
1423: For optLine in optCursor loop
1424: --slin info line check parent line
1425: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = optLine.clm_base_line_num;
1426: if ( l_award_flag = 'Y' ) Then
1427: update pon_bid_item_prices
1428: set has_bid_flag = l_award_flag
1429: where bid_number = p_bid_number

Line 1427: update pon_bid_item_prices

1423: For optLine in optCursor loop
1424: --slin info line check parent line
1425: select nvl(has_bid_flag,'N') into l_award_flag from pon_bid_item_prices where bid_number = p_bid_number and line_number = optLine.clm_base_line_num;
1426: if ( l_award_flag = 'Y' ) Then
1427: update pon_bid_item_prices
1428: set has_bid_flag = l_award_flag
1429: where bid_number = p_bid_number
1430: and line_number = optLine.line_number;
1431: end if;

Line 1472: FROM pon_bid_item_prices pbip

1468: AND pbav.attribute_name = paa.attribute_name
1469: AND paa.display_only_flag = 'Y')
1470: OR pbav.value IS NULL
1471: OR EXISTS (SELECT null
1472: FROM pon_bid_item_prices pbip
1473: WHERE pbip.bid_number = pbav.bid_number
1474: AND pbip.line_number = pbav.line_number
1475: AND pbip.has_bid_flag = 'N'))
1476: AND pbav.line_number >= p_batch_start

Line 1485: FROM pon_bid_item_prices pbip

1481: -- 2) price elements for lines with hasBid=N
1482: DELETE FROM pon_bid_price_elements pbpe
1483: WHERE pbpe.bid_number = p_bid_number
1484: AND EXISTS (SELECT null
1485: FROM pon_bid_item_prices pbip
1486: WHERE pbip.bid_number = pbpe.bid_number
1487: AND pbip.line_number = pbpe.line_number
1488: AND pbip.has_bid_flag = 'N')
1489: AND pbpe.line_number >= p_batch_start

Line 1498: FROM pon_bid_item_prices pbip

1494: -- 2) price differentials for lines with hasBid=N (line-level, shipment-level)
1495: DELETE FROM pon_bid_price_differentials pbpd
1496: WHERE pbpd.bid_number = p_bid_number
1497: AND EXISTS (SELECT null
1498: FROM pon_bid_item_prices pbip
1499: WHERE pbip.bid_number = pbpd.bid_number
1500: AND pbip.line_number = pbpd.line_number
1501: AND pbip.has_bid_flag = 'N')
1502: AND pbpd.line_number >= p_batch_start

Line 1511: FROM pon_bid_item_prices pbip

1507: -- 1) shipments for lines with hasBid=N
1508: DELETE FROM pon_bid_shipments pbs
1509: WHERE pbs.bid_number = p_bid_number
1510: AND EXISTS (SELECT null
1511: FROM pon_bid_item_prices pbip
1512: WHERE pbip.bid_number = pbs.bid_number
1513: AND pbip.line_number = pbs.line_number
1514: AND pbip.has_bid_flag = 'N')
1515: AND pbs.line_number >= p_batch_start

Line 1523: FROM pon_bid_item_prices pbip

1519: -- 1) Payments for lines with hasBid=N
1520: DELETE FROM pon_bid_payments_shipments pbps
1521: WHERE pbps.bid_number = p_bid_number
1522: AND EXISTS (SELECT null
1523: FROM pon_bid_item_prices pbip
1524: WHERE pbip.bid_number = pbps.bid_number
1525: AND pbip.line_number = pbps.bid_line_number
1526: AND pbip.has_bid_flag = 'N')
1527: AND pbps.bid_line_number >= p_batch_start

Line 1531: DELETE FROM pon_bid_item_prices

1527: AND pbps.bid_line_number >= p_batch_start
1528: AND pbps.bid_line_number <= p_batch_end;
1529:
1530: -- remove empty lines finally
1531: DELETE FROM pon_bid_item_prices
1532: WHERE bid_number = p_bid_number
1533: AND has_bid_flag = 'N'
1534: AND line_number >= p_batch_start
1535: AND line_number <= p_batch_end;

Line 1697: UPDATE pon_bid_item_prices

1693: END IF;
1694:
1695: IF p_rebid_flag = 'N' THEN
1696:
1697: UPDATE pon_bid_item_prices
1698: SET publish_date = p_publish_date,
1699: proxy_bid_flag = 'N',
1700: award_price = price,
1701: first_bid_price = price, --(woojin) do we really need this?

Line 1717: UPDATE pon_bid_item_prices

1713: -- Please note that the is_changed_line_flag is used in the procedure
1714: -- PONAUCHB.check_is_bid_valid to determine the newly added/modified
1715: -- lines. In case this logic is changed do ensure that the check_is_bid_valid
1716: -- procedure is also modified
1717: UPDATE pon_bid_item_prices
1718: SET publish_date = p_publish_date,
1719: proxy_bid_flag = 'N',
1720: award_price = price,
1721: first_bid_price = nvl(first_bid_price, price), --(woojin) do we really need this?

Line 1731: UPDATE pon_bid_item_prices

1727: AND line_number <= p_batch_end
1728: AND auction_line_number <> -1; --Unsolicited Lines Project : Update unsol lines seperately.
1729:
1730: --Added for bug 10169313
1731: UPDATE pon_bid_item_prices
1732: SET award_price = price
1733: WHERE bid_number = p_bid_number
1734: AND is_changed_line_flag <> 'Y'
1735: AND line_number >= p_batch_start