APPS.CSTPAPBR dependencies on FND_PROFILE

Line 4: g_debug_flag VARCHAR2(1) := NVL(fnd_profile.value('MRP_DEBUG'), 'N'); /* Bug 4586534 */

1: PACKAGE BODY CSTPAPBR AS
2: /* $Header: CSTAPBRB.pls 120.63.12020000.6 2013/05/22 06:43:38 yunfchen ship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(fnd_profile.value('MRP_DEBUG'), 'N'); /* Bug 4586534 */
5:
6: /*============================================================================+
7: | This procedure is called by the Accounting Package for the Accounting Lib. |
8: | It first gets the details of the transaction from either |

Line 750: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_rec.currency_conv_type);

746:
747: if (l_curr_rec.alt_currency is not NULL and l_curr_rec.currency_conv_rate = -1) then
748: if (l_curr_rec.alt_currency <> l_curr_rec.pri_currency) then
749: if (l_curr_rec.currency_conv_type is NULL) then
750: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_rec.currency_conv_type);
751: end if;
752: l_stmt_num := 16;
753: l_curr_rec.currency_conv_rate := gl_currency_api.get_rate(i_ae_txn_rec.set_of_books_id,
754: l_curr_rec.alt_currency,

Line 2301: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)

2297:
2298: /* Get profile status for internal sales orders */
2299: BEGIN
2300: /* Change the Query for the performance. Bug 4586534 */
2301: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
2302: INTO l_tprice_option
2303: FROM mtl_intercompany_parameters MIP
2304: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
2305: AND (select count(1)

Line 2304: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1

2300: /* Change the Query for the performance. Bug 4586534 */
2301: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
2302: INTO l_tprice_option
2303: FROM mtl_intercompany_parameters MIP
2304: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
2305: AND (select count(1)
2306: from hr_organization_information HOI
2307: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id,
2308: 21, i_ae_txn_rec.organization_id,

Line 4303: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)

4299: l_stmt_num := 370;
4300:
4301: BEGIN
4302: /* Change the Query for the performance. Bug 4586534 */
4303: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
4304: INTO l_tprice_option
4305: FROM mtl_intercompany_parameters MIP
4306: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
4307: AND ( select count(1)

Line 4306: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1

4302: /* Change the Query for the performance. Bug 4586534 */
4303: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
4304: INTO l_tprice_option
4305: FROM mtl_intercompany_parameters MIP
4306: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
4307: AND ( select count(1)
4308: FROM hr_organization_information HOI
4309: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id, 21,
4310: i_ae_txn_rec.organization_id,

Line 8498: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_ae_curr_rec.currency_conv_type);

8494:
8495: if (l_ae_curr_rec.alt_currency is not NULL and l_ae_curr_rec.currency_conv_rate = -1) then
8496: if (l_ae_curr_rec.alt_currency <> l_ae_curr_rec.pri_currency) then
8497: if (l_ae_curr_rec.currency_conv_type is NULL) then
8498: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_ae_curr_rec.currency_conv_type);
8499: end if;
8500: l_ae_curr_rec.currency_conv_rate := gl_currency_api.get_rate(i_ae_txn_rec.set_of_books_id,
8501: l_ae_curr_rec.alt_currency,
8502: i_ae_txn_rec.accounting_date,