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: benefit_qty_t VARCHAR2(240); --Bug 8474533
51:
52: BEGIN

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: benefit_qty_t VARCHAR2(240); --Bug 8474533
51:
52: BEGIN
53:

Line 148: FROM QP_LIST_HEADERS_B

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