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_CP_INTRFAC_TO_TRANSACTION dependencies on PON_LARGE_NEG_PF_VALUES

Line 2515: FROM PON_LARGE_NEG_PF_VALUES

2511:
2512: -- Delete values that do not exist
2513: FORALL x IN 1..l_PRICE_ELEMENT_TYPE_ID.COUNT
2514: DELETE
2515: FROM PON_LARGE_NEG_PF_VALUES
2516: WHERE
2517: auction_header_id = g_auction_header_id
2518: and PRICE_ELEMENT_TYPE_ID <> l_PRICE_ELEMENT_TYPE_ID(x)
2519: and PRICING_BASIS <> l_PRICING_BASIS(x);

Line 2528: PON_LARGE_NEG_PF_VALUES

2524:
2525: -- Insert new values
2526: FORALL x IN 1..l_PRICE_ELEMENT_TYPE_ID.COUNT
2527: insert into
2528: PON_LARGE_NEG_PF_VALUES
2529: (auction_header_id,
2530: price_element_type_id,
2531: pricing_basis,
2532: supplier_seq_number,

Line 2557: PON_LARGE_NEG_PF_VALUES pf_values

2553: PBP.auction_header_id = g_auction_header_id and
2554: not exists (
2555: select 1
2556: from
2557: PON_LARGE_NEG_PF_VALUES pf_values
2558: where pf_values.auction_header_id = PBP.auction_header_id
2559: and pf_values.supplier_seq_number = PBP.sequence
2560: and pf_values.price_element_type_id = l_PRICE_ELEMENT_TYPE_ID(x)
2561: and pf_values.pricing_basis = l_PRICING_BASIS(x));

Line 2865: -- If this is not an amendment or new round then we need to synch the PON_LARGE_NEG_PF_VALUES

2861: WHERE auction_header_id = g_auction_header_id;
2862:
2863: else
2864:
2865: -- If this is not an amendment or new round then we need to synch the PON_LARGE_NEG_PF_VALUES
2866: -- If a template is applied
2867: IF (g_price_element_enabled_flag = 'Y' and
2868: l_large_neg_enabled_flag = 'Y' and
2869: l_template_id <> 0) THEN