DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on FND_PROFILE

Line 20: G_LIMITS_INSTALLED CONSTANT VARCHAR2(1) := FND_PROFILE.VALUE('QP_LIMITS_INSTALLED');

16: G_ROUNDING_PROFILE CONSTANT VARCHAR2(1) := 'Q';
17:
18: G_POST_ROUND CONSTANT VARCHAR2(30) := 'POST'; --[prarasto:Post Round] constant for post rounding
19:
20: G_LIMITS_INSTALLED CONSTANT VARCHAR2(1) := FND_PROFILE.VALUE('QP_LIMITS_INSTALLED');
21:
22: --prg processing pl/sql tbl
23: G_PRG_UNCH_CALC_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PRG_UNCH_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 161: l_bypass_pricing := FND_PROFILE.VALUE(G_BYPASS_PRICING);

157:
158: END IF;
159:
160:
161: l_bypass_pricing := FND_PROFILE.VALUE(G_BYPASS_PRICING);
162:
163: --pricing event can be null when applying manual adjustments
164: --IF(p_control_rec.PRICING_EVENT IS NULL
165: IF (p_control_rec.calculate_flag = NULL

Line 13061: G_QP_DEBUG := FND_PROFILE.VALUE(l_debug_switch); --3085171

13057:
13058: --===============START: Pre-pricing process needed by JAVA and PL/SQL engine====
13059: -- Set the debug variable G_DEBUG_ENGINE in QP_PREQ_GRP
13060: QP_PREQ_GRP.Set_QP_Debug;
13061: G_QP_DEBUG := FND_PROFILE.VALUE(l_debug_switch); --3085171
13062:
13063: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
13064: l_pricing_start_time := dbms_utility.get_time;
13065:

Line 13151: G_LICENSED_FOR_PRODUCT := nvl(fnd_profile.VALUE('QP_LICENSED_FOR_PRODUCT'), 'ZZZZZZ');

13147: END IF;
13148:
13149: IF G_REQUEST_TYPE_CODE IN ('PO', 'ICX') THEN
13150: IF G_LICENSED_FOR_PRODUCT IS NULL THEN
13151: G_LICENSED_FOR_PRODUCT := nvl(fnd_profile.VALUE('QP_LICENSED_FOR_PRODUCT'), 'ZZZZZZ');
13152: END IF;
13153:
13154: IF l_debug = FND_API.G_TRUE THEN
13155: QP_PREQ_GRP.engine_debug('G_LICENSED_FOR_PRODUCT = ' || G_LICENSED_FOR_PRODUCT);

Line 13171: G_LICENSED_FOR_PRODUCT := nvl(fnd_profile.VALUE('QP_LICENSED_FOR_PRODUCT'), 'ZZZZZZ');

13167:
13168: -- for QP-CMRO integration
13169: IF G_REQUEST_TYPE_CODE = 'AHL' THEN
13170: IF G_LICENSED_FOR_PRODUCT IS NULL THEN
13171: G_LICENSED_FOR_PRODUCT := nvl(fnd_profile.VALUE('QP_LICENSED_FOR_PRODUCT'), 'ZZZZZZ');
13172: END IF;
13173:
13174: IF l_debug = FND_API.G_TRUE THEN
13175: QP_PREQ_GRP.engine_debug('G_LICENSED_FOR_PRODUCT = ' || G_LICENSED_FOR_PRODUCT);

Line 13245: G_ROUNDING_OPTIONS := FND_PROFILE.VALUE('QP_SELLING_PRICE_ROUNDING_OPTIONS');

13241: -- U - NO_ROUND_ADJ
13242: -- Q - look at the QP profile
13243: --Change for 2635440 - pass 'Q' as default value for OC if request_type is 'ASO'
13244: ----------------------------------------------------
13245: G_ROUNDING_OPTIONS := FND_PROFILE.VALUE('QP_SELLING_PRICE_ROUNDING_OPTIONS');
13246: IF (l_debug = FND_API.G_TRUE) THEN
13247: QP_PREQ_GRP.engine_debug('Rounding profile value '|| G_ROUNDING_OPTIONS);
13248: END IF;
13249:

Line 13273: G_USE_MULTI_CURRENCY_PUB := nvl(fnd_profile.VALUE('QP_MULTI_CURRENCY_USAGE'), 'N');

13269: -- current behaviour,bug 2943033
13270: IF p_control_rec.use_multi_currency = 'Y' THEN
13271: G_USE_MULTI_CURRENCY_PUB := p_control_rec.use_multi_currency;
13272: ELSE
13273: G_USE_MULTI_CURRENCY_PUB := nvl(fnd_profile.VALUE('QP_MULTI_CURRENCY_USAGE'), 'N');
13274: l_control_rec.use_multi_currency := G_USE_MULTI_CURRENCY_PUB;
13275: END IF;
13276:
13277: IF nvl(p_control_rec.rounding_flag, G_YES) = G_ROUNDING_PROFILE

Line 13308: --G_QP_DEBUG := FND_PROFILE.VALUE(l_debug_switch); --3085171

13304: -- The below code is replaced with QP_PREQ_GRP.Set_QP_Debug
13305:
13306: --getting debug profilE
13307: ----------------------------------------------------
13308: --G_QP_DEBUG := FND_PROFILE.VALUE(l_debug_switch); --3085171
13309: ----------------------------------------------------
13310:
13311: /* ----------------------------------------------------
13312:

Line 13363: G_GSA_ENABLED_FLAG := nvl(FND_PROFILE.VALUE(G_GSA_Max_Discount_Enabled), G_NO);

13359: QP_PREQ_GRP.ENGINE_DEBUG('PRICE REQUEST PUB: GSA_profile '|| G_GSA_ENABLED_FLAG);
13360:
13361: END IF;
13362: G_GSA_CHECK_FLAG := nvl(p_control_rec.GSA_CHECK_FLAG, G_YES);
13363: G_GSA_ENABLED_FLAG := nvl(FND_PROFILE.VALUE(G_GSA_Max_Discount_Enabled), G_NO);
13364:
13365:
13366: IF l_debug = FND_API.G_TRUE THEN
13367: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: request_type_code '|| G_REQUEST_TYPE_CODE);

Line 13401: G_GSA_ENABLED_FLAG := nvl(FND_PROFILE.VALUE(G_GSA_Max_Discount_Enabled), G_NO);

13397: QP_PREQ_GRP.ENGINE_DEBUG('PRICE REQUEST PUB: GSA_profile '||G_GSA_ENABLED_FLAG);
13398:
13399: END IF;
13400: G_GSA_CHECK_FLAG := nvl(p_control_rec.GSA_CHECK_FLAG, G_YES);
13401: G_GSA_ENABLED_FLAG := nvl(FND_PROFILE.VALUE(G_GSA_Max_Discount_Enabled), G_NO);
13402:
13403:
13404: IF l_debug = FND_API.G_TRUE THEN
13405: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: request_type_code '||G_REQUEST_TYPE_CODE);

Line 13524: l_dynamic_sampling_level := TO_NUMBER(NVL(FND_PROFILE.VALUE(G_DYNAMIC_SAMPLING_LEVEL),1));

13520: WHERE name = 'optimizer_dynamic_sampling';
13521: IF l_debug = FND_API.G_TRUE THEN
13522: QP_PREQ_GRP.engine_debug('Default Dynamic sampling Level :'|| l_old_dynamic_sampling_level);
13523: END IF;
13524: l_dynamic_sampling_level := TO_NUMBER(NVL(FND_PROFILE.VALUE(G_DYNAMIC_SAMPLING_LEVEL),1));
13525: IF l_debug = FND_API.G_TRUE THEN
13526: QP_PREQ_GRP.engine_debug('QP Profile Dynamic sampling level :'|| l_dynamic_sampling_level);
13527: END If;
13528: EXCEPTION