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_NEGOTIATION_PUBLISH_PVT dependencies on PON_PRICE_ELEMENTS

Line 2030: PON_PRICE_ELEMENTS

2026: sel_unit_target_price IS NOT NULL AND
2027: NOT EXISTS (
2028: SELECT 1
2029: FROM
2030: PON_PRICE_ELEMENTS
2031: WHERE
2032: AUCTION_HEADER_ID = p_auction_header_id AND
2033: LINE_NUMBER = sel_line_number AND
2034: PF_TYPE='SUPPLIER'

Line 2643: PON_PRICE_ELEMENTS

2639: sel_quantity IS NULL AND
2640: EXISTS (
2641: SELECT 1
2642: FROM
2643: PON_PRICE_ELEMENTS
2644: WHERE
2645: AUCTION_HEADER_ID = p_auction_header_id AND
2646: LINE_NUMBER = sel_line_number AND
2647: PRICING_BASIS = g_fixed_amount)

Line 4939: PON_PRICE_ELEMENTS PPE,

4935: PPET.SYSTEM_FLAG sel_system_flag,
4936: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4937: FROM
4938: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4939: PON_PRICE_ELEMENTS PPE,
4940: PON_PRICE_ELEMENT_TYPES_TL PPETL,
4941: PON_PRICE_ELEMENT_TYPES PPET
4942: WHERE
4943: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 5006: PON_PRICE_ELEMENTS PPE,

5002: sysdate, -- LAST_UPDATE_DATE
5003: p_login_id -- LAST_UPDATE_LOGIN
5004: FROM
5005: PON_AUCTION_ITEM_PRICES_ALL PAIP,
5006: PON_PRICE_ELEMENTS PPE,
5007: PON_PRICE_ELEMENT_TYPES_TL PPETL
5008: WHERE
5009: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
5010: PPE.AUCTION_HEADER_ID = p_auction_header_id AND

Line 7194: FROM PON_PRICE_ELEMENTS

7190: AND LINE_NUMBER = PAIP.LINE_NUMBER
7191: AND ROWNUM = 1),'N'),
7192: HAS_PRICE_ELEMENTS_FLAG = NVL (
7193: (SELECT 'Y'
7194: FROM PON_PRICE_ELEMENTS
7195: WHERE AUCTION_HEADER_ID = p_auction_header_id
7196: AND LINE_NUMBER = PAIP.LINE_NUMBER
7197: AND PF_TYPE = 'SUPPLIER'
7198: AND ROWNUM = 1), 'N'),

Line 7201: FROM PON_PRICE_ELEMENTS

7197: AND PF_TYPE = 'SUPPLIER'
7198: AND ROWNUM = 1), 'N'),
7199: HAS_BUYER_PFS_FLAG = NVL (
7200: (SELECT 'Y'
7201: FROM PON_PRICE_ELEMENTS
7202: WHERE AUCTION_HEADER_ID = p_auction_header_id
7203: AND LINE_NUMBER = PAIP.LINE_NUMBER
7204: AND ROWNUM = 1
7205: AND PF_TYPE = 'BUYER'),'N'),

Line 7976: FROM pon_price_elements

7972:
7973: -- If the line has any supplier price factors this flag will be Y else N
7974: has_price_elements_flag = NVL (
7975: (SELECT 'Y'
7976: FROM pon_price_elements
7977: WHERE auction_header_id = p_auction_header_id
7978: AND line_number = paip.line_number
7979: AND pf_type = 'SUPPLIER'
7980: AND rownum = 1), 'N'),

Line 7985: FROM pon_price_elements

7981:
7982: -- If the line has any buyer price factors this flag will be Y else N
7983: has_buyer_pfs_flag = NVL (
7984: (SELECT 'Y'
7985: FROM pon_price_elements
7986: WHERE auction_header_id = p_auction_header_id
7987: AND line_number = paip.line_number
7988: AND pf_type = 'BUYER'
7989: AND rownum = 1),'N'),

Line 8080: MERGE INTO pon_price_elements ppe

8076: module => g_module_prefix || l_module_name,
8077: message => 'Entering procedure = ' || l_module_name);
8078: END IF;
8079:
8080: MERGE INTO pon_price_elements ppe
8081: USING
8082: (
8083: SELECT
8084: auction_header_id,

Line 8166: pon_price_elements ppe

8162: from
8163: pon_auction_item_prices_all paip,
8164: pon_bidding_parties pbp,
8165: pon_pf_supplier_values ppsv,
8166: pon_price_elements ppe
8167: where
8168: paip.auction_header_id = p_auction_header_id and
8169: pbp.auction_header_id = paip.auction_header_id and
8170: pbp.auction_header_id = ppsv.auction_header_id and

Line 8605: FROM PON_PRICE_ELEMENTS

8601: BEGIN
8602:
8603: SELECT 'Y'
8604: INTO l_has_price_elements
8605: FROM PON_PRICE_ELEMENTS
8606: WHERE AUCTION_HEADER_ID = p_auction_header_id
8607: AND ROWNUM = 1;
8608:
8609: EXCEPTION WHEN NO_DATA_FOUND THEN --{

Line 8742: -- clean up the pon_price_elements table of any line type price elements:

8738: WHERE
8739: auction_header_id = p_auction_header_id;
8740: END IF;
8741:
8742: -- clean up the pon_price_elements table of any line type price elements:
8743: -- why we need a clean up?
8744: -- a. After a failure the user might have deleted all price elements from a line, in which case this row should not be present
8745: -- b. After a failure the user might have deleted the line (the price element row will not have a parent ...) and created another
8746: -- (we reuse the line numbers)

Line 8749: pon_price_elements

8745: -- b. After a failure the user might have deleted the line (the price element row will not have a parent ...) and created another
8746: -- (we reuse the line numbers)
8747:
8748: DELETE FROM
8749: pon_price_elements
8750: WHERE
8751: auction_header_id = p_auction_header_id and
8752: price_element_type_id = -10;
8753:

Line 8823: -- populate the pon_price_elements table and the pon_pf_supplier_formula table (MERGE)

8819: p_from_line_number => l_batch_start,
8820: p_to_line_number => l_batch_end);
8821: END IF;
8822:
8823: -- populate the pon_price_elements table and the pon_pf_supplier_formula table (MERGE)
8824:
8825: process_price_factors (
8826: p_auction_header_id => p_auction_header_id,
8827: p_user_id => p_user_id,