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_IMPORT_PKG dependencies on PON_BID_PRICE_ELEMENTS

Line 207: FROM pon_bid_price_elements_int bpfi

203: -- No price elements
204: AND(bl.display_price_factors_flag = 'N'
205: OR NOT EXISTS
206: (SELECT bpfi.price_element_type_id
207: FROM pon_bid_price_elements_int bpfi
208: WHERE bpfi.batch_id = bli.batch_id
209: AND bpfi.interface_line_id = bli.interface_line_id
210: AND bpfi.bid_currency_value IS NOT null))
211: -- No price differentials

Line 351: DELETE FROM pon_bid_price_elements_int bpfi

347: AND (bli.line_number = g_error_int
348: OR bli.line_number = g_skip_int));
349:
350: -- Delete from price elements interface table
351: DELETE FROM pon_bid_price_elements_int bpfi
352: WHERE bpfi.batch_id = p_batch_id
353: AND bpfi.interface_line_id in (
354: select bli.interface_line_id
355: from pon_bid_item_prices_interface bli

Line 395: UPDATE pon_bid_price_elements_int bpfi

391:
392: -- Update price elements' internal line numbers's
393: -- NOTE: we also update line_number for those price elements with
394: -- valid line_numbers
395: UPDATE pon_bid_price_elements_int bpfi
396: SET bpfi.line_number =
397: (SELECT bli.line_number
398: FROM pon_bid_item_prices_interface bli
399: WHERE bli.batch_id = bpfi.batch_id

Line 757: UPDATE pon_bid_price_elements_int bpfi

753: -- 2. PRICE ELEMENTS/COST FACTORS
754:
755: -- Update price_element_type_id since the user specifies price
756: -- elements by name and not price_element_type_id
757: UPDATE pon_bid_price_elements_int bpfi
758: SET bpfi.price_element_type_id =
759: nvl((SELECT pft.price_element_type_id
760: FROM pon_price_element_types_tl pft
761: WHERE pft.name = bpfi.price_element_name

Line 814: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf

810: AND bli.line_number = bip.line_number
811: AND bip.display_price_factors_flag = 'Y'
812: AND EXISTS
813: (SELECT bpfi.price_element_name
814: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf
815: WHERE apf.auction_header_id = p_auc_header_id
816: AND apf.line_number = bli.line_number
817: AND apf.pf_type = 'SUPPLIER'
818: AND bpfi.batch_id (+) = bli.batch_id

Line 827: UPDATE pon_bid_price_elements_int bpfi

823:
824: END IF;
825:
826: -- BUYER price factors are not allowed to be uploaded
827: UPDATE pon_bid_price_elements_int bpfi
828: SET bpfi.price_element_type_id = g_error_int
829: WHERE bpfi.batch_id = p_batch_id
830: AND bpfi.price_element_type_id <> g_error_int
831: AND 'BUYER' =

Line 875: FROM pon_bid_price_elements_int bpfi

871: bpfi.auction_header_id,
872: bpfi.bid_number,
873: bpfi.line_number,
874: g_exp_date
875: FROM pon_bid_price_elements_int bpfi
876: WHERE bpfi.batch_id = p_batch_id
877: AND bpfi.price_element_type_id = g_error_int);
878:
879: -- Delete from price elements interface table

Line 880: DELETE FROM pon_bid_price_elements_int bpfi

876: WHERE bpfi.batch_id = p_batch_id
877: AND bpfi.price_element_type_id = g_error_int);
878:
879: -- Delete from price elements interface table
880: DELETE FROM pon_bid_price_elements_int bpfi
881: WHERE bpfi.batch_id = p_batch_id
882: AND bpfi.price_element_type_id = g_error_int;
883:
884:

Line 1311: MERGE INTO pon_bid_price_elements bpf

1307: -- Update price elements transaction table from interface table
1308: -- only set bid currency value. The auction currency value
1309: -- will be recalculated later in
1310: -- recalculate_auc_curr_prices
1311: MERGE INTO pon_bid_price_elements bpf
1312: USING
1313: (SELECT
1314: batch_id,
1315: bid_number,

Line 1320: FROM pon_bid_price_elements_int

1316: line_number,
1317: price_element_type_id,
1318: bid_currency_value,
1319: interface_line_id
1320: FROM pon_bid_price_elements_int
1321: WHERE batch_id = p_batch_id
1322: AND auction_header_id = p_auction_header_id
1323: AND bid_number = p_bid_number) bpfi
1324: ON (bpf.bid_number = bpfi.bid_number

Line 1339: FROM pon_bid_price_elements bpf

1335: -- Sync bid_currency_unit_price from price factors to lines table
1336: UPDATE pon_bid_item_prices bl
1337: SET bl.bid_currency_unit_price =
1338: (SELECT bpf.bid_currency_value
1339: FROM pon_bid_price_elements bpf
1340: WHERE bpf.bid_number = bl.bid_number
1341: AND bpf.line_number = bl.line_number
1342: AND bpf.price_element_type_id = -10)
1343: WHERE bl.bid_number = p_bid_number

Line 1505: DELETE FROM pon_bid_price_elements_int bpfi

1501:
1502: DELETE FROM pon_bid_attr_values_interface bai
1503: WHERE bai.batch_id = p_batch_id;
1504:
1505: DELETE FROM pon_bid_price_elements_int bpfi
1506: WHERE bpfi.batch_id = p_batch_id;
1507:
1508: DELETE FROM pon_bid_price_differ_int bpdi
1509: WHERE bpdi.batch_id = p_batch_id;

Line 2282: pon_bid_price_elements_int bpei

2278: bpei.worksheet_name,
2279: bpei.worksheet_sequence_number
2280: FROM pon_bid_item_prices_interface bli,
2281: pon_bid_item_prices bip,
2282: pon_bid_price_elements_int bpei
2283: WHERE bli.batch_id = p_batch_id
2284: AND bli.bid_number = bip.bid_number
2285: AND bli.line_number = bip.line_number
2286: AND bip.display_price_factors_flag = 'Y'

Line 2291: FROM pon_bid_price_elements_int bpfi,

2287: AND bpei.batch_id = bli.batch_id
2288: AND bpei.line_number = bli.line_number
2289: AND EXISTS
2290: (SELECT bpfi.price_element_type_id
2291: FROM pon_bid_price_elements_int bpfi,
2292: pon_price_elements apf
2293: WHERE apf.auction_header_id = p_auction_header_id
2294: AND apf.line_number = bli.line_number
2295: AND apf.pf_type = 'SUPPLIER'

Line 2362: FROM pon_bid_price_elements_int bpfi

2358: -- No price elements
2359: AND(bl.display_price_factors_flag = 'N'
2360: OR NOT EXISTS
2361: (SELECT bpfi.price_element_type_id
2362: FROM pon_bid_price_elements_int bpfi
2363: WHERE bpfi.batch_id = bli.batch_id
2364: AND bpfi.line_number = bli.line_number
2365: AND bpfi.bid_currency_value IS NOT null))
2366: -- No line / Price Break level price differentials

Line 2446: DELETE FROM pon_bid_price_elements_int bpfi

2442: where bli.batch_id = p_batch_id
2443: AND bli.interface_line_id = g_skip_int);
2444:
2445: -- Delete from price elements interface table
2446: DELETE FROM pon_bid_price_elements_int bpfi
2447: WHERE bpfi.batch_id = p_batch_id
2448: AND bpfi.line_number in (
2449: select bli.line_number
2450: from pon_bid_item_prices_interface bli