APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_PF_SUPPLIER_FORMULA

Line 7257: -- Populate the pon_pf_supplier_formula table

7253: 'SUPPLIER',
7254: 'Y'
7255: );
7256:
7257: -- Populate the pon_pf_supplier_formula table
7258:
7259: MERGE INTO pon_pf_supplier_formula ppsf
7260: USING
7261: (

Line 7259: MERGE INTO pon_pf_supplier_formula ppsf

7255: );
7256:
7257: -- Populate the pon_pf_supplier_formula table
7258:
7259: MERGE INTO pon_pf_supplier_formula ppsf
7260: USING
7261: (
7262: SELECT
7263: paip.auction_header_id,

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

7859: WHERE
7860: auction_header_id = p_auction_header_id and
7861: price_element_type_id = -10;
7862:
7863: -- clean up the pon_pf_supplier_formula table of any rows for this auction:
7864: -- why we need a clean up?
7865: -- a. After a failure the user might have deleted all price elements from a line
7866:
7867: DELETE FROM

Line 7868: pon_pf_supplier_formula

7864: -- why we need a clean up?
7865: -- a. After a failure the user might have deleted all price elements from a line
7866:
7867: DELETE FROM
7868: pon_pf_supplier_formula
7869: WHERE
7870: auction_header_id = p_auction_header_id;
7871:
7872: COMMIT;

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,