DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;

10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
10406: l_org_id pon_auction_headers_all.org_id%type;
10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
10408: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
10409: l_price_break_enabled_flag VARCHAR2(1);
10410: l_price_break_allowed VARCHAR2(1);
10411: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;

Line 10504: from po_system_parameters_all

10500: BEGIN
10501: select decode(price_break_lookup_code, 'NON CUMULATIVE',
10502: 'NON-CUMULATIVE', price_break_lookup_code)
10503: into l_po_pb_type
10504: from po_system_parameters_all
10505: where org_id = l_org_id;
10506: EXCEPTION
10507: WHEN OTHERS THEN
10508: l_po_pb_type := 'NON-CUMULATIVE';