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 1252: PON_PRICE_ELEMENTS

1248: sel_unit_target_price IS NOT NULL AND
1249: NOT EXISTS (
1250: SELECT 1
1251: FROM
1252: PON_PRICE_ELEMENTS
1253: WHERE
1254: AUCTION_HEADER_ID = p_auction_header_id AND
1255: LINE_NUMBER = sel_line_number AND
1256: PF_TYPE='SUPPLIER'

Line 1812: PON_PRICE_ELEMENTS

1808: sel_quantity IS NULL AND
1809: EXISTS (
1810: SELECT 1
1811: FROM
1812: PON_PRICE_ELEMENTS
1813: WHERE
1814: AUCTION_HEADER_ID = p_auction_header_id AND
1815: LINE_NUMBER = sel_line_number AND
1816: PRICING_BASIS = g_fixed_amount)

Line 4095: PON_PRICE_ELEMENTS PPE,

4091: PPET.ENABLED_FLAG sel_enabled_flag,
4092: PPET.SYSTEM_FLAG sel_system_flag
4093: FROM
4094: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4095: PON_PRICE_ELEMENTS PPE,
4096: PON_PRICE_ELEMENT_TYPES_TL PPETL,
4097: PON_PRICE_ELEMENT_TYPES PPET
4098: WHERE
4099: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4162: PON_PRICE_ELEMENTS PPE,

4158: sysdate, -- LAST_UPDATE_DATE
4159: p_login_id -- LAST_UPDATE_LOGIN
4160: FROM
4161: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4162: PON_PRICE_ELEMENTS PPE,
4163: PON_PRICE_ELEMENT_TYPES_TL PPETL
4164: WHERE
4165: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4166: PPE.AUCTION_HEADER_ID = p_auction_header_id AND

Line 6336: FROM PON_PRICE_ELEMENTS

6332: AND LINE_NUMBER = PAIP.LINE_NUMBER
6333: AND ROWNUM = 1),'N'),
6334: HAS_PRICE_ELEMENTS_FLAG = NVL (
6335: (SELECT 'Y'
6336: FROM PON_PRICE_ELEMENTS
6337: WHERE AUCTION_HEADER_ID = p_auction_header_id
6338: AND LINE_NUMBER = PAIP.LINE_NUMBER
6339: AND PF_TYPE = 'SUPPLIER'
6340: AND ROWNUM = 1), 'N'),

Line 6343: FROM PON_PRICE_ELEMENTS

6339: AND PF_TYPE = 'SUPPLIER'
6340: AND ROWNUM = 1), 'N'),
6341: HAS_BUYER_PFS_FLAG = NVL (
6342: (SELECT 'Y'
6343: FROM PON_PRICE_ELEMENTS
6344: WHERE AUCTION_HEADER_ID = p_auction_header_id
6345: AND LINE_NUMBER = PAIP.LINE_NUMBER
6346: AND ROWNUM = 1
6347: AND PF_TYPE = 'BUYER'),'N'),

Line 7085: FROM pon_price_elements

7081:
7082: -- If the line has any supplier price factors this flag will be Y else N
7083: has_price_elements_flag = NVL (
7084: (SELECT 'Y'
7085: FROM pon_price_elements
7086: WHERE auction_header_id = p_auction_header_id
7087: AND line_number = paip.line_number
7088: AND pf_type = 'SUPPLIER'
7089: AND rownum = 1), 'N'),

Line 7094: FROM pon_price_elements

7090:
7091: -- If the line has any buyer price factors this flag will be Y else N
7092: has_buyer_pfs_flag = NVL (
7093: (SELECT 'Y'
7094: FROM pon_price_elements
7095: WHERE auction_header_id = p_auction_header_id
7096: AND line_number = paip.line_number
7097: AND pf_type = 'BUYER'
7098: AND rownum = 1),'N'),

Line 7189: MERGE INTO pon_price_elements ppe

7185: module => g_module_prefix || l_module_name,
7186: message => 'Entering procedure = ' || l_module_name);
7187: END IF;
7188:
7189: MERGE INTO pon_price_elements ppe
7190: USING
7191: (
7192: SELECT
7193: auction_header_id,

Line 7275: pon_price_elements ppe

7271: from
7272: pon_auction_item_prices_all paip,
7273: pon_bidding_parties pbp,
7274: pon_pf_supplier_values ppsv,
7275: pon_price_elements ppe
7276: where
7277: paip.auction_header_id = p_auction_header_id and
7278: pbp.auction_header_id = paip.auction_header_id and
7279: pbp.auction_header_id = ppsv.auction_header_id and

Line 7714: FROM PON_PRICE_ELEMENTS

7710: BEGIN
7711:
7712: SELECT 'Y'
7713: INTO l_has_price_elements
7714: FROM PON_PRICE_ELEMENTS
7715: WHERE AUCTION_HEADER_ID = p_auction_header_id
7716: AND ROWNUM = 1;
7717:
7718: EXCEPTION WHEN NO_DATA_FOUND THEN --{

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

7847: WHERE
7848: auction_header_id = p_auction_header_id;
7849: END IF;
7850:
7851: -- clean up the pon_price_elements table of any line type price elements:
7852: -- why we need a clean up?
7853: -- a. After a failure the user might have deleted all price elements from a line, in which case this row should not be present
7854: -- b. After a failure the user might have deleted the line (the price element row will not have a parent ...) and created another
7855: -- (we reuse the line numbers)

Line 7858: pon_price_elements

7854: -- b. After a failure the user might have deleted the line (the price element row will not have a parent ...) and created another
7855: -- (we reuse the line numbers)
7856:
7857: DELETE FROM
7858: pon_price_elements
7859: WHERE
7860: auction_header_id = p_auction_header_id and
7861: price_element_type_id = -10;
7862:

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

7928: p_from_line_number => l_batch_start,
7929: p_to_line_number => l_batch_end);
7930: END IF;
7931:
7932: -- populate the pon_price_elements table and the pon_pf_supplier_formula table (MERGE)
7933:
7934: process_price_factors (
7935: p_auction_header_id => p_auction_header_id,
7936: p_user_id => p_user_id,