DBA Data[Home] [Help]

APPS.QP_VALIDATE_MODIFIERS dependencies on QP_LIST_HEADERS_B

Line 48: l_profile_pte_code qp_list_headers_b.pte_code%type:=fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');

44: l_phase_price_evt VARCHAR2(1):='N'; --Bug 2724502
45: l_phase_freeze_set VARCHAR2(1):='N'; --Bug 1748272
46: l_modifier_level_code VARCHAR2(30); --Bug 2835156
47: l_rltd_exist VARCHAR2(1); --Bug 2835156
48: l_profile_pte_code qp_list_headers_b.pte_code%type:=fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
49: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
50:
51: BEGIN
52:

Line 49: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');

45: l_phase_freeze_set VARCHAR2(1):='N'; --Bug 1748272
46: l_modifier_level_code VARCHAR2(30); --Bug 2835156
47: l_rltd_exist VARCHAR2(1); --Bug 2835156
48: l_profile_pte_code qp_list_headers_b.pte_code%type:=fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
49: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
50:
51: BEGIN
52:
53: oe_debug_pub.add('BEGIN Entity in QPXLMLLB');

Line 147: FROM QP_LIST_HEADERS_B

143:
144:
145: SELECT LIST_TYPE_CODE, ASK_FOR_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE,GSA_INDICATOR
146: INTO l_list_type_code, l_ask_for_flag, l_start_date_active, l_end_date_active, l_gsa_indicator
147: FROM QP_LIST_HEADERS_B
148: WHERE LIST_HEADER_ID = p_MODIFIERS_rec.list_header_id;
149:
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN