DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 9513: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;

9509: l_pref_unused_1 VARCHAR2(300);
9510: l_pref_unused_2 VARCHAR2(300);
9511: l_pref_unused_3 VARCHAR2(300);
9512:
9513: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
9514:
9515: BEGIN
9516:
9517: select display_flag

Line 9519: from PON_AUC_DOCTYPE_RULES dr,

9515: BEGIN
9516:
9517: select display_flag
9518: into l_price_break_display_flag
9519: from PON_AUC_DOCTYPE_RULES dr,
9520: PON_AUC_BIZRULES b
9521: where b.bizrule_id = dr.bizrule_id
9522: and dr.doctype_id = p_doctype_id
9523: and b.name = 'PRICE_BREAK';

Line 9572: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%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;
9576:

Line 9597: from PON_AUC_DOCTYPE_RULES dr,

9593: where auction_header_id = p_auction_header_id;
9594:
9595: select display_flag
9596: into l_price_break_display_flag
9597: from PON_AUC_DOCTYPE_RULES dr,
9598: PON_AUC_BIZRULES b
9599: where b.bizrule_id = dr.bizrule_id
9600: and dr.doctype_id = l_doctype_id
9601: and b.name = 'PRICE_BREAK';