DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 10349: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;

10345: l_pref_unused_1 VARCHAR2(300);
10346: l_pref_unused_2 VARCHAR2(300);
10347: l_pref_unused_3 VARCHAR2(300);
10348:
10349: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
10350:
10351: BEGIN
10352:
10353: select display_flag

Line 10355: from PON_AUC_DOCTYPE_RULES dr,

10351: BEGIN
10352:
10353: select display_flag
10354: into l_price_break_display_flag
10355: from PON_AUC_DOCTYPE_RULES dr,
10356: PON_AUC_BIZRULES b
10357: where b.bizrule_id = dr.bizrule_id
10358: and dr.doctype_id = p_doctype_id
10359: and b.name = 'PRICE_BREAK';

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

Line 10433: from PON_AUC_DOCTYPE_RULES dr,

10429: where auction_header_id = p_auction_header_id;
10430:
10431: select display_flag
10432: into l_price_break_display_flag
10433: from PON_AUC_DOCTYPE_RULES dr,
10434: PON_AUC_BIZRULES b
10435: where b.bizrule_id = dr.bizrule_id
10436: and dr.doctype_id = l_doctype_id
10437: and b.name = 'PRICE_BREAK';