eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 3466: l_url_servlet_string := nvl(p_servlet_url, fnd_profile.value('APPS_FRAMEWORK_AGENT') ||

3462: WHEN NO_DATA_FOUND THEN
3463: RAISE INVALID_PRICE_BOOK_HEADER;
3464: END;
3465:
3466: l_url_servlet_string := nvl(p_servlet_url, fnd_profile.value('APPS_FRAMEWORK_AGENT') ||
3467: '/OA_HTML/RequestPriceBook');
3468: l_url_param_string := 'pbInputHeaderId='||nvl(p_pb_input_header_id, -1)||
3469: qp_java_engine_util_pub.G_HARD_CHAR||'priceBookHeaderId='||nvl(p_price_book_header_id, -1);
3470: qp_java_engine_util_pub.send_java_request(l_url_servlet_string,

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

3617: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3618: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3619: END IF;
3620:
3621: SELECT FND_PROFILE.VALUE('ORG_ID')
3622: INTO l_operating_unit_id
3623: FROM dual;
3624:
3625: IF (l_debug = FND_API.G_TRUE) THEN

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

4065: -- get pricing perpective based on user
4066: fnd_global.apps_initialize(l_user_id,
4067: null,
4068: null);
4069: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4070: QP_PREQ_GRP.Set_QP_Debug;
4071: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
4072: IF l_debug = FND_API.G_TRUE THEN
4073: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);

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

4086: -- get responsibility based on pricing perspective
4087: fnd_global.apps_initialize(l_user_id,
4088: null,
4089: l_pricing_perspective_appl_id);
4090: l_resp_id := FND_PROFILE.VALUE('QP_XML_RESP');
4091: IF l_debug = FND_API.G_TRUE THEN
4092: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_id=' || l_resp_id);
4093: END IF;
4094:

Line 4362: fnd_profile.Value('QP_PRICEBOOK_PROCESSOR_BATCH_SIZE')

4358: IS
4359: l_value NATURAL;
4360: BEGIN
4361: l_value := To_Number(
4362: fnd_profile.Value('QP_PRICEBOOK_PROCESSOR_BATCH_SIZE')
4363: );
4364: RETURN Nvl(l_value, 5000);
4365: EXCEPTION
4366: WHEN Others THEN

Line 4388: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.CREATION_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "CreationDate",

4384: BEGIN
4385: l_qryCtx := DBMS_XMLQUERY.newContext('SELECT XMLElement(
4386: "PriceBookHeadersVORow",
4387: XMLForest( PBHDR.PRICE_BOOK_HEADER_ID "PriceBookHeaderId",
4388: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.CREATION_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "CreationDate",
4389: PBHDR.CREATED_BY "CreatedBy",
4390: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.LAST_UPDATE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "LastUpdateDate",
4391: PBHDR.LAST_UPDATED_BY "LastUpdatedBy",
4392: PBHDR.LAST_UPDATE_LOGIN "LastUpdateLogin",

Line 4390: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.LAST_UPDATE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "LastUpdateDate",

4386: "PriceBookHeadersVORow",
4387: XMLForest( PBHDR.PRICE_BOOK_HEADER_ID "PriceBookHeaderId",
4388: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.CREATION_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "CreationDate",
4389: PBHDR.CREATED_BY "CreatedBy",
4390: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.LAST_UPDATE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "LastUpdateDate",
4391: PBHDR.LAST_UPDATED_BY "LastUpdatedBy",
4392: PBHDR.LAST_UPDATE_LOGIN "LastUpdateLogin",
4393: PBHDR.CUSTOMER_ID "CustomerId",
4394: PBHDR.CURRENCY_CODE "CurrencyCode",

Line 4395: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.EFFECTIVE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "EffectiveDate",

4391: PBHDR.LAST_UPDATED_BY "LastUpdatedBy",
4392: PBHDR.LAST_UPDATE_LOGIN "LastUpdateLogin",
4393: PBHDR.CUSTOMER_ID "CustomerId",
4394: PBHDR.CURRENCY_CODE "CurrencyCode",
4395: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBHDR.EFFECTIVE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "EffectiveDate",
4396: PBHDR.ITEM_QUANTITY "ItemQuantity",
4397: PBHDR.REQUEST_ID "RequestId",
4398: PBHDR.ORG_ID "OrgId",
4399: PBHDR.OPERATING_UNIT "OperatingUnit",

Line 4428: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBInputHDR.EFFECTIVE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "EffectiveDate",

4424: PBInputHDR.CURRENCY_CODE "CurrencyCode",
4425: PBInputHDR.PRODUCT_CONTEXT "ProductContext",
4426: PBInputHDR.PRODUCT_ATTRIBUTE "ProductAttribute",
4427: PBInputHDR.PRODUCT_ATTR_VALUE "ProductAttrValue",
4428: replace(to_char(hz_timezone_pub.convert_datetime(FND_PROFILE.VALUE(''SERVER_TIMEZONE_ID''),0,PBInputHDR.EFFECTIVE_DATE), ''YYYY-MM-DD HH24:MI:SS''), '' '', ''T'') "EffectiveDate",
4429: PBInputHDR.ITEM_QUANTITY "ItemQuantity",
4430: PBInputHDR.GENERATION_TIME_CODE "GenerationTimeCode",
4431: PBInputHDR.GEN_SCHEDULE_DATE "GenScheduleDate",
4432: PBInputHDR.REQUEST_ID "RequestId",