DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on FND_PROFILE

Line 254: fnd_profile.value('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');

250:
251: IF l_customer_id IS NOT NULL --external customer
252: THEN
253: p_pb_input_header_rec.pricing_perspective_code :=
254: fnd_profile.value('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
255: ELSE --internal customer
256: p_pb_input_header_rec.pricing_perspective_code :=
257: fnd_profile.value('QP_INT_DEFAULT_PRICING_PERSPECTIVE');
258: END IF;

Line 257: fnd_profile.value('QP_INT_DEFAULT_PRICING_PERSPECTIVE');

253: p_pb_input_header_rec.pricing_perspective_code :=
254: fnd_profile.value('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
255: ELSE --internal customer
256: p_pb_input_header_rec.pricing_perspective_code :=
257: fnd_profile.value('QP_INT_DEFAULT_PRICING_PERSPECTIVE');
258: END IF;
259: END IF;
260:
261: IF p_pb_input_header_rec.customer_context IS NULL THEN

Line 382: IF NOT(UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN

378: p_pb_input_header_rec.pl_agr_bsa_id IS NOT NULL
379: THEN
380:
381: --If multi-currency is not installed, default to currency of pricelist
382: IF NOT(UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN
383: ('Y','YES'))
384: AND nvl(fnd_profile.value('QP_MULTI_CURRENCY_USAGE'), 'N') <> 'Y'
385: THEN
386: BEGIN

Line 384: AND nvl(fnd_profile.value('QP_MULTI_CURRENCY_USAGE'), 'N') <> 'Y'

380:
381: --If multi-currency is not installed, default to currency of pricelist
382: IF NOT(UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN
383: ('Y','YES'))
384: AND nvl(fnd_profile.value('QP_MULTI_CURRENCY_USAGE'), 'N') <> 'Y'
385: THEN
386: BEGIN
387: SELECT currency_code
388: INTO p_pb_input_header_rec.currency_code

Line 432: fnd_profile.value('QP_PRICING_PERSPECTIVE_REQUEST_TYPE');

428: END IF;
429:
430: IF p_pb_input_header_rec.request_type_code IS NULL THEN
431: p_pb_input_header_rec.request_type_code :=
432: fnd_profile.value('QP_PRICING_PERSPECTIVE_REQUEST_TYPE');
433: END IF;
434:
435: IF p_pb_input_header_rec.publish_existing_pb_flag IS NULL THEN
436: p_pb_input_header_rec.publish_existing_pb_flag := 'N';

Line 612: fnd_profile.value('QP_PRICING_PERSPECTIVE_REQUEST_TYPE');

608: fnd_global.resp_id,
609: l_application_id);
610:
611: l_request_type_code :=
612: fnd_profile.value('QP_PRICING_PERSPECTIVE_REQUEST_TYPE');
613:
614: IF l_request_type_code IS NULL THEN
615: x_return_status := 'E';
616: FND_MESSAGE.SET_NAME('QP', 'QP_REQUEST_TYPE_NOT_FOUND');

Line 2373: l_request_type_code := fnd_profile.value_specific(

2369: EXCEPTION
2370: l_application_id := NULL;
2371: END;
2372:
2373: l_request_type_code := fnd_profile.value_specific(
2374: name => 'QP_PRICING_PERSPECTIVE_REQUEST_TYPE',
2375: application_id => l_application_id);
2376: */
2377:

Line 3433: l_url_servlet_string := nvl(p_servlet_url, fnd_profile.value('APPS_FRAMEWORK_AGENT') ||

3429: WHEN NO_DATA_FOUND THEN
3430: RAISE INVALID_PRICE_BOOK_HEADER;
3431: END;
3432:
3433: l_url_servlet_string := nvl(p_servlet_url, fnd_profile.value('APPS_FRAMEWORK_AGENT') ||
3434: '/OA_HTML/RequestPriceBook');
3435: l_url_param_string := 'pbInputHeaderId='||nvl(p_pb_input_header_id, -1)||
3436: qp_java_engine_util_pub.G_HARD_CHAR||'priceBookHeaderId='||nvl(p_price_book_header_id, -1);
3437: qp_java_engine_util_pub.send_java_request(l_url_servlet_string,

Line 3588: SELECT FND_PROFILE.VALUE('ORG_ID')

3584: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3585: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3586: END IF;
3587:
3588: SELECT FND_PROFILE.VALUE('ORG_ID')
3589: INTO l_operating_unit_id
3590: FROM dual;
3591:
3592: IF (l_debug = FND_API.G_TRUE) THEN

Line 4036: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');

4032: -- get pricing perpective based on user
4033: fnd_global.apps_initialize(l_user_id,
4034: null,
4035: null);
4036: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4037: QP_PREQ_GRP.Set_QP_Debug;
4038: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
4039: IF l_debug = FND_API.G_TRUE THEN
4040: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);

Line 4057: l_resp_id := FND_PROFILE.VALUE('QP_XML_RESP');

4053: -- get responsibility based on pricing perspective
4054: fnd_global.apps_initialize(l_user_id,
4055: null,
4056: l_pricing_perspective_appl_id);
4057: l_resp_id := FND_PROFILE.VALUE('QP_XML_RESP');
4058: IF l_debug = FND_API.G_TRUE THEN
4059: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_id=' || l_resp_id);
4060: END IF;
4061:

Line 4330: fnd_profile.Value('QP_PRICEBOOK_PROCESSOR_BATCH_SIZE')

4326: IS
4327: l_value NATURAL;
4328: BEGIN
4329: l_value := To_Number(
4330: fnd_profile.Value('QP_PRICEBOOK_PROCESSOR_BATCH_SIZE')
4331: );
4332: RETURN Nvl(l_value, 5000);
4333: EXCEPTION
4334: WHEN Others THEN