DBA Data[Home] [Help]

APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_LARGE_NEG_PF_VALUES

Line 2776: FROM PON_LARGE_NEG_PF_VALUES

2772:
2773: -- Delete values that do not exist
2774: FORALL x IN 1..l_PRICE_ELEMENT_TYPE_ID.COUNT
2775: DELETE
2776: FROM PON_LARGE_NEG_PF_VALUES
2777: WHERE
2778: auction_header_id = g_auction_header_id
2779: and PRICE_ELEMENT_TYPE_ID <> l_PRICE_ELEMENT_TYPE_ID(x)
2780: and PRICING_BASIS <> l_PRICING_BASIS(x);

Line 2789: PON_LARGE_NEG_PF_VALUES

2785:
2786: -- Insert new values
2787: FORALL x IN 1..l_PRICE_ELEMENT_TYPE_ID.COUNT
2788: insert into
2789: PON_LARGE_NEG_PF_VALUES
2790: (auction_header_id,
2791: price_element_type_id,
2792: pricing_basis,
2793: supplier_seq_number,

Line 2818: PON_LARGE_NEG_PF_VALUES pf_values

2814: PBP.auction_header_id = g_auction_header_id and
2815: not exists (
2816: select 1
2817: from
2818: PON_LARGE_NEG_PF_VALUES pf_values
2819: where pf_values.auction_header_id = PBP.auction_header_id
2820: and pf_values.supplier_seq_number = PBP.sequence
2821: and pf_values.price_element_type_id = l_PRICE_ELEMENT_TYPE_ID(x)
2822: and pf_values.pricing_basis = l_PRICING_BASIS(x));

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

3122: WHERE auction_header_id = g_auction_header_id;
3123:
3124: else
3125:
3126: -- If this is not an amendment or new round then we need to synch the PON_LARGE_NEG_PF_VALUES
3127: -- If a template is applied
3128: IF (g_price_element_enabled_flag = 'Y' and
3129: l_large_neg_enabled_flag = 'Y' and
3130: l_template_id <> 0) THEN