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(spf.pricing_basis,
628: 'PER_UNIT', spf.bid_currency_value,

Line 670: UPDATE pon_bid_item_prices pbip

666: -- work fields is almost same. So, if you change one, also consider impact on others.
667:
668: IF p_curr_changed = 'Y' THEN
669:
670: UPDATE pon_bid_item_prices pbip
671: SET pbip.unit_price = pbip.bid_currency_unit_price / v_rate,
672: pbip.price = pbip.bid_currency_trans_price / v_rate,
673: pbip.bid_currency_price = DECODE(v_supplier_view_type,
674: 'TRANSFORMED', round(pbip.bid_currency_trans_price, v_precision),

Line 717: UPDATE pon_bid_item_prices pbip

713: pbip.line_number <= v_batch_end)
714: OR pbip.batch_id = p_batch_id);
715: ELSE
716:
717: UPDATE pon_bid_item_prices pbip
718: SET pbip.unit_price = pbip.bid_currency_unit_price / v_rate,
719: pbip.price = pbip.bid_currency_trans_price / v_rate,
720: pbip.bid_currency_price = DECODE(v_supplier_view_type,
721: 'TRANSFORMED', round(pbip.bid_currency_trans_price, v_precision),

Line 757: pon_bid_item_prices pbip

753: nvl(aip.quantity, 1)))
754: FROM pon_pf_supplier_formula ppsf,
755: pon_bid_headers pbh,
756: pon_auction_item_prices_all aip,
757: pon_bid_item_prices pbip
758: WHERE pbip.bid_number = pbs.bid_number
759: AND pbip.line_number = pbs.line_number
760: AND ppsf.auction_header_id = pbip.auction_header_id
761: AND ppsf.line_number = pbip.line_number

Line 786: pon_bid_item_prices pbip

782: nvl(aip.quantity, 1))))),
783: 0)
784: FROM pon_bid_price_elements spf,
785: pon_auction_item_prices_all aip,
786: pon_bid_item_prices pbip
787: WHERE pbip.bid_number = pbs.bid_number
788: AND pbip.line_number = pbs.line_number
789: AND spf.bid_number = p_bid_number
790: AND spf.line_number = pbip.line_number

Line 1291: FROM pon_bid_item_prices pbip

1287: AND pbav.attribute_name = paa.attribute_name
1288: AND paa.display_only_flag = 'Y')
1289: OR pbav.value IS NULL
1290: OR EXISTS (SELECT null
1291: FROM pon_bid_item_prices pbip
1292: WHERE pbip.bid_number = pbav.bid_number
1293: AND pbip.line_number = pbav.line_number
1294: AND pbip.has_bid_flag = 'N'))
1295: AND pbav.line_number >= p_batch_start

Line 1304: FROM pon_bid_item_prices pbip

1300: -- 2) price elements for lines with hasBid=N
1301: DELETE FROM pon_bid_price_elements pbpe
1302: WHERE pbpe.bid_number = p_bid_number
1303: AND EXISTS (SELECT null
1304: FROM pon_bid_item_prices pbip
1305: WHERE pbip.bid_number = pbpe.bid_number
1306: AND pbip.line_number = pbpe.line_number
1307: AND pbip.has_bid_flag = 'N')
1308: AND pbpe.line_number >= p_batch_start

Line 1317: FROM pon_bid_item_prices pbip

1313: -- 2) price differentials for lines with hasBid=N (line-level, shipment-level)
1314: DELETE FROM pon_bid_price_differentials pbpd
1315: WHERE pbpd.bid_number = p_bid_number
1316: AND EXISTS (SELECT null
1317: FROM pon_bid_item_prices pbip
1318: WHERE pbip.bid_number = pbpd.bid_number
1319: AND pbip.line_number = pbpd.line_number
1320: AND pbip.has_bid_flag = 'N')
1321: AND pbpd.line_number >= p_batch_start

Line 1330: FROM pon_bid_item_prices pbip

1326: -- 1) shipments for lines with hasBid=N
1327: DELETE FROM pon_bid_shipments pbs
1328: WHERE pbs.bid_number = p_bid_number
1329: AND EXISTS (SELECT null
1330: FROM pon_bid_item_prices pbip
1331: WHERE pbip.bid_number = pbs.bid_number
1332: AND pbip.line_number = pbs.line_number
1333: AND pbip.has_bid_flag = 'N')
1334: AND pbs.line_number >= p_batch_start

Line 1342: FROM pon_bid_item_prices pbip

1338: -- 1) Payments for lines with hasBid=N
1339: DELETE FROM pon_bid_payments_shipments pbps
1340: WHERE pbps.bid_number = p_bid_number
1341: AND EXISTS (SELECT null
1342: FROM pon_bid_item_prices pbip
1343: WHERE pbip.bid_number = pbps.bid_number
1344: AND pbip.line_number = pbps.bid_line_number
1345: AND pbip.has_bid_flag = 'N')
1346: AND pbps.bid_line_number >= p_batch_start

Line 1350: DELETE FROM pon_bid_item_prices

1346: AND pbps.bid_line_number >= p_batch_start
1347: AND pbps.bid_line_number <= p_batch_end;
1348:
1349: -- remove empty lines finally
1350: DELETE FROM pon_bid_item_prices
1351: WHERE bid_number = p_bid_number
1352: AND has_bid_flag = 'N'
1353: AND line_number >= p_batch_start
1354: AND line_number <= p_batch_end;

Line 1516: UPDATE pon_bid_item_prices

1512: END IF;
1513:
1514: IF p_rebid_flag = 'N' THEN
1515:
1516: UPDATE pon_bid_item_prices
1517: SET publish_date = p_publish_date,
1518: proxy_bid_flag = 'N',
1519: award_price = price,
1520: first_bid_price = price, --(woojin) do we really need this?

Line 1535: UPDATE pon_bid_item_prices

1531: -- Please note that the is_changed_line_flag is used in the procedure
1532: -- PONAUCHB.check_is_bid_valid to determine the newly added/modified
1533: -- lines. In case this logic is changed do ensure that the check_is_bid_valid
1534: -- procedure is also modified
1535: UPDATE pon_bid_item_prices
1536: SET publish_date = p_publish_date,
1537: proxy_bid_flag = 'N',
1538: award_price = price,
1539: first_bid_price = nvl(first_bid_price, price), --(woojin) do we really need this?