DBA Data[Home] [Help]

APPS.QP_DEFAULT_PRICE_LIST dependencies on FND_PROFILE

Line 232: if nvl(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'), 'N') = 'Y'

228: BEGIN
229: -- bug 2302661, if multi-currency is installed and public api do not pass the currency_header_id
230: -- then find the currency header id for currency code and rounding factor. If currency_header_id
231: -- is not found then create it.
232: if nvl(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'), 'N') = 'Y'
233: --added for moac now defaulted currency_code can be null
234: --when the default org_id is not set as the OM setofbooks will be null
235: --and qp_currency_lists_b.base_currency_code is a notnull column
236: --and the insert below will fail

Line 457: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);

453: RETURN VARCHAR2
454: IS
455: l_pte_code VARCHAR2(30);
456: BEGIN
457: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
458:
459: IF l_pte_code IS NULL THEN
460: l_pte_code := 'ORDFUL';
461: END IF;

Line 477: FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');

473:
474: oe_debug_pub.add('entering get_rounding_factor');
475:
476: l_unit_precision_type :=
477: FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');
478:
479: SELECT -1*PRECISION,
480: -1*EXTENDED_PRECISION
481: INTO l_precision,

Line 587: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE',l_source_system_code);

583: IS
584: l_source_system_code VARCHAR2(30);
585: BEGIN
586:
587: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE',l_source_system_code);
588: RETURN l_source_system_code;
589:
590: END Get_Source_System_Code;
591: