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_PF_SUPPLIER_FORMULA

Line 8148: -- Populate the pon_pf_supplier_formula table

8144: 'SUPPLIER',
8145: 'Y'
8146: );
8147:
8148: -- Populate the pon_pf_supplier_formula table
8149:
8150: MERGE INTO pon_pf_supplier_formula ppsf
8151: USING
8152: (

Line 8150: MERGE INTO pon_pf_supplier_formula ppsf

8146: );
8147:
8148: -- Populate the pon_pf_supplier_formula table
8149:
8150: MERGE INTO pon_pf_supplier_formula ppsf
8151: USING
8152: (
8153: SELECT
8154: paip.auction_header_id,

Line 8754: -- clean up the pon_pf_supplier_formula table of any rows for this auction:

8750: WHERE
8751: auction_header_id = p_auction_header_id and
8752: price_element_type_id = -10;
8753:
8754: -- clean up the pon_pf_supplier_formula table of any rows for this auction:
8755: -- why we need a clean up?
8756: -- a. After a failure the user might have deleted all price elements from a line
8757:
8758: DELETE FROM

Line 8759: pon_pf_supplier_formula

8755: -- why we need a clean up?
8756: -- a. After a failure the user might have deleted all price elements from a line
8757:
8758: DELETE FROM
8759: pon_pf_supplier_formula
8760: WHERE
8761: auction_header_id = p_auction_header_id;
8762:
8763: COMMIT;

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,