DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 9571: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;

9567: l_po_style_id pon_auction_headers_all.po_style_id%type;
9568: l_template_id pon_auction_headers_all.template_id%type;
9569: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
9570: l_org_id pon_auction_headers_all.org_id%type;
9571: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
9572: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
9573: l_price_break_enabled_flag VARCHAR2(1);
9574: l_price_break_allowed VARCHAR2(1);
9575: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;

Line 9668: from po_system_parameters_all

9664: BEGIN
9665: select decode(price_break_lookup_code, 'NON CUMULATIVE',
9666: 'NON-CUMULATIVE', price_break_lookup_code)
9667: into l_po_pb_type
9668: from po_system_parameters_all
9669: where org_id = l_org_id;
9670: EXCEPTION
9671: WHEN OTHERS THEN
9672: l_po_pb_type := 'NON-CUMULATIVE';