DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUCTION_PKG

Line 2585: where rt_category_id = decode(pon_auction_pkg.get_mapped_ip_category(p1.category_id), -2, null, pon_auction_pkg.get_mapped_ip_category(p1.category_id)) and

2581: IF (NVL(l_progress_payment_type,'NONE') = 'NONE') THEN
2582: update pon_item_prices_interface p1
2583: set ip_category_name = (select category_name
2584: from icx_cat_categories_v
2585: where rt_category_id = decode(pon_auction_pkg.get_mapped_ip_category(p1.category_id), -2, null, pon_auction_pkg.get_mapped_ip_category(p1.category_id)) and
2586: language = p_language)
2587: where batch_id = p_batch_id and
2588: (action is null or action = '+') and
2589: p1.category_id <> -1 and

Line 3779: PON_AUCTION_PKG.get_default_pb_settings (l_auction_header_id,

3775: END IF;
3776: END IF; -- end of if p_source <> 'SBID'
3777: --
3778: -- Price Breaks ER
3779: PON_AUCTION_PKG.get_default_pb_settings (l_auction_header_id,
3780: l_price_break_type,
3781: l_price_break_neg_flag);
3782:
3783: SELECT price_tiers_indicator INTO l_price_tiers_indicator FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

Line 3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');

3783: SELECT price_tiers_indicator INTO l_price_tiers_indicator FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3784:
3785: IF(l_price_tiers_indicator = 'PRICE_BREAKS' ) THEN
3786:
3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');
3788: l_noncumulative := pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE');
3789: l_none:=pon_auction_pkg.getmessage('PON_AUC_NONE');
3790: l_required:=pon_auction_pkg.getmessage('PON_AUCTS_REQUIRED');
3791: l_optional:=pon_auction_pkg.getmessage('PON_AUCTS_OPTIONAL');

Line 3788: l_noncumulative := pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE');

3784:
3785: IF(l_price_tiers_indicator = 'PRICE_BREAKS' ) THEN
3786:
3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');
3788: l_noncumulative := pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE');
3789: l_none:=pon_auction_pkg.getmessage('PON_AUC_NONE');
3790: l_required:=pon_auction_pkg.getmessage('PON_AUCTS_REQUIRED');
3791: l_optional:=pon_auction_pkg.getmessage('PON_AUCTS_OPTIONAL');
3792:

Line 3789: l_none:=pon_auction_pkg.getmessage('PON_AUC_NONE');

3785: IF(l_price_tiers_indicator = 'PRICE_BREAKS' ) THEN
3786:
3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');
3788: l_noncumulative := pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE');
3789: l_none:=pon_auction_pkg.getmessage('PON_AUC_NONE');
3790: l_required:=pon_auction_pkg.getmessage('PON_AUCTS_REQUIRED');
3791: l_optional:=pon_auction_pkg.getmessage('PON_AUCTS_OPTIONAL');
3792:
3793:

Line 3790: l_required:=pon_auction_pkg.getmessage('PON_AUCTS_REQUIRED');

3786:
3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');
3788: l_noncumulative := pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE');
3789: l_none:=pon_auction_pkg.getmessage('PON_AUC_NONE');
3790: l_required:=pon_auction_pkg.getmessage('PON_AUCTS_REQUIRED');
3791: l_optional:=pon_auction_pkg.getmessage('PON_AUCTS_OPTIONAL');
3792:
3793:
3794: -- Should not set values for Fixed Price Line types

Line 3791: l_optional:=pon_auction_pkg.getmessage('PON_AUCTS_OPTIONAL');

3787: l_cumulative := pon_auction_pkg.getmessage('PON_AUC_CUMULATIVE');
3788: l_noncumulative := pon_auction_pkg.getmessage('PON_AUC_NON_CUMULATIVE');
3789: l_none:=pon_auction_pkg.getmessage('PON_AUC_NONE');
3790: l_required:=pon_auction_pkg.getmessage('PON_AUCTS_REQUIRED');
3791: l_optional:=pon_auction_pkg.getmessage('PON_AUCTS_OPTIONAL');
3792:
3793:
3794: -- Should not set values for Fixed Price Line types
3795: /* insert into PON_INTERFACE_ERRORS

Line 3919: pon_auction_pkg.getMessage('PON_AGREEMENT_RELEASE_QUANTITY'),

3915: interface_line_id
3916:
3917: )
3918: select
3919: pon_auction_pkg.getMessage('PON_AGREEMENT_RELEASE_QUANTITY'),
3920: interface_type , --INTERFACE_TYPE
3921: 'PON_AUC_BAD_PBTYPE_GLOBAL' , -- ERROR_MESSAGE_NAME
3922: batch_id , -- BATCH_ID
3923: 'PON_ITEM_PRICES_INTERFACE' , -- ENTITY_TYPE