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.

[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_ELEMENTS_INT

Line 205: FROM pon_bid_price_elements_int bpfi

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

Line 324: DELETE FROM pon_bid_price_elements_int bpfi

320: AND (bli.line_number = g_error_int
321: OR bli.line_number = g_skip_int));
322:
323: -- Delete from price elements interface table
324: DELETE FROM pon_bid_price_elements_int bpfi
325: WHERE bpfi.batch_id = p_batch_id
326: AND bpfi.interface_line_id in (
327: select bli.interface_line_id
328: from pon_bid_item_prices_interface bli

Line 368: UPDATE pon_bid_price_elements_int bpfi

364:
365: -- Update price elements' internal line numbers's
366: -- NOTE: we also update line_number for those price elements with
367: -- valid line_numbers
368: UPDATE pon_bid_price_elements_int bpfi
369: SET bpfi.line_number =
370: (SELECT bli.line_number
371: FROM pon_bid_item_prices_interface bli
372: WHERE bli.batch_id = bpfi.batch_id

Line 680: UPDATE pon_bid_price_elements_int bpfi

676: -- 2. PRICE ELEMENTS/COST FACTORS
677:
678: -- Update price_element_type_id since the user specifies price
679: -- elements by name and not price_element_type_id
680: UPDATE pon_bid_price_elements_int bpfi
681: SET bpfi.price_element_type_id =
682: nvl((SELECT pft.price_element_type_id
683: FROM pon_price_element_types_tl pft
684: WHERE pft.name = bpfi.price_element_name

Line 737: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf

733: AND bli.line_number = bip.line_number
734: AND bip.display_price_factors_flag = 'Y'
735: AND EXISTS
736: (SELECT bpfi.price_element_name
737: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf
738: WHERE apf.auction_header_id = p_auc_header_id
739: AND apf.line_number = bli.line_number
740: AND apf.pf_type = 'SUPPLIER'
741: AND bpfi.batch_id (+) = bli.batch_id

Line 750: UPDATE pon_bid_price_elements_int bpfi

746:
747: END IF;
748:
749: -- BUYER price factors are not allowed to be uploaded
750: UPDATE pon_bid_price_elements_int bpfi
751: SET bpfi.price_element_type_id = g_error_int
752: WHERE bpfi.batch_id = p_batch_id
753: AND bpfi.price_element_type_id <> g_error_int
754: AND 'BUYER' =

Line 798: FROM pon_bid_price_elements_int bpfi

794: bpfi.auction_header_id,
795: bpfi.bid_number,
796: bpfi.line_number,
797: g_exp_date
798: FROM pon_bid_price_elements_int bpfi
799: WHERE bpfi.batch_id = p_batch_id
800: AND bpfi.price_element_type_id = g_error_int);
801:
802: -- Delete from price elements interface table

Line 803: DELETE FROM pon_bid_price_elements_int bpfi

799: WHERE bpfi.batch_id = p_batch_id
800: AND bpfi.price_element_type_id = g_error_int);
801:
802: -- Delete from price elements interface table
803: DELETE FROM pon_bid_price_elements_int bpfi
804: WHERE bpfi.batch_id = p_batch_id
805: AND bpfi.price_element_type_id = g_error_int;
806:
807:

Line 1121: FROM pon_bid_price_elements_int

1117: line_number,
1118: price_element_type_id,
1119: bid_currency_value,
1120: interface_line_id
1121: FROM pon_bid_price_elements_int
1122: WHERE batch_id = p_batch_id
1123: AND auction_header_id = p_auction_header_id
1124: AND bid_number = p_bid_number) bpfi
1125: ON (bpf.bid_number = bpfi.bid_number

Line 1306: DELETE FROM pon_bid_price_elements_int bpfi

1302:
1303: DELETE FROM pon_bid_attr_values_interface bai
1304: WHERE bai.batch_id = p_batch_id;
1305:
1306: DELETE FROM pon_bid_price_elements_int bpfi
1307: WHERE bpfi.batch_id = p_batch_id;
1308:
1309: DELETE FROM pon_bid_price_differ_int bpdi
1310: WHERE bpdi.batch_id = p_batch_id;

Line 2069: pon_bid_price_elements_int bpei

2065: bpei.worksheet_name,
2066: bpei.worksheet_sequence_number
2067: FROM pon_bid_item_prices_interface bli,
2068: pon_bid_item_prices bip,
2069: pon_bid_price_elements_int bpei
2070: WHERE bli.batch_id = p_batch_id
2071: AND bli.bid_number = bip.bid_number
2072: AND bli.line_number = bip.line_number
2073: AND bip.display_price_factors_flag = 'Y'

Line 2078: FROM pon_bid_price_elements_int bpfi,

2074: AND bpei.batch_id = bli.batch_id
2075: AND bpei.line_number = bli.line_number
2076: AND EXISTS
2077: (SELECT bpfi.price_element_type_id
2078: FROM pon_bid_price_elements_int bpfi,
2079: pon_price_elements apf
2080: WHERE apf.auction_header_id = p_auction_header_id
2081: AND apf.line_number = bli.line_number
2082: AND apf.pf_type = 'SUPPLIER'

Line 2149: FROM pon_bid_price_elements_int bpfi

2145: -- No price elements
2146: AND(bl.display_price_factors_flag = 'N'
2147: OR NOT EXISTS
2148: (SELECT bpfi.price_element_type_id
2149: FROM pon_bid_price_elements_int bpfi
2150: WHERE bpfi.batch_id = bli.batch_id
2151: AND bpfi.line_number = bli.line_number
2152: AND bpfi.bid_currency_value IS NOT null))
2153: -- No line / Price Break level price differentials

Line 2233: DELETE FROM pon_bid_price_elements_int bpfi

2229: where bli.batch_id = p_batch_id
2230: AND bli.interface_line_id = g_skip_int);
2231:
2232: -- Delete from price elements interface table
2233: DELETE FROM pon_bid_price_elements_int bpfi
2234: WHERE bpfi.batch_id = p_batch_id
2235: AND bpfi.line_number in (
2236: select bli.line_number
2237: from pon_bid_item_prices_interface bli