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.

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.48.12010000.6 2008/11/21 07:47:11 anjha 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 725: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_rec.currency_conv_type);

721:
722: if (l_curr_rec.alt_currency is not NULL and l_curr_rec.currency_conv_rate = -1) then
723: if (l_curr_rec.alt_currency <> l_curr_rec.pri_currency) then
724: if (l_curr_rec.currency_conv_type is NULL) then
725: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_curr_rec.currency_conv_type);
726: end if;
727: l_stmt_num := 16;
728: l_curr_rec.currency_conv_rate := gl_currency_api.get_rate(i_ae_txn_rec.set_of_books_id,
729: l_curr_rec.alt_currency,

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

2015:
2016: /* Get profile status for internal sales orders */
2017: BEGIN
2018: /* Change the Query for the performance. Bug 4586534 */
2019: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
2020: INTO l_tprice_option
2021: FROM mtl_intercompany_parameters MIP
2022: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
2023: AND (select count(1)

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

2018: /* Change the Query for the performance. Bug 4586534 */
2019: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
2020: INTO l_tprice_option
2021: FROM mtl_intercompany_parameters MIP
2022: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
2023: AND (select count(1)
2024: from hr_organization_information HOI
2025: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id,
2026: 21, i_ae_txn_rec.organization_id,

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

4017: l_stmt_num := 370;
4018:
4019: BEGIN
4020: /* Change the Query for the performance. Bug 4586534 */
4021: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
4022: INTO l_tprice_option
4023: FROM mtl_intercompany_parameters MIP
4024: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
4025: AND ( select count(1)

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

4020: /* Change the Query for the performance. Bug 4586534 */
4021: SELECT nvl(fnd_profile.value('CST_TRANSFER_PRICING_OPTION'), 0)
4022: INTO l_tprice_option
4023: FROM mtl_intercompany_parameters MIP
4024: WHERE fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') = 1
4025: AND ( select count(1)
4026: FROM hr_organization_information HOI
4027: where HOI.organization_id = decode(i_ae_txn_rec.txn_action_id, 21,
4028: i_ae_txn_rec.organization_id,

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

8108:
8109: if (l_ae_curr_rec.alt_currency is not NULL and l_ae_curr_rec.currency_conv_rate = -1) then
8110: if (l_ae_curr_rec.alt_currency <> l_ae_curr_rec.pri_currency) then
8111: if (l_ae_curr_rec.currency_conv_type is NULL) then
8112: FND_PROFILE.get('CURRENCY_CONVERSION_TYPE', l_ae_curr_rec.currency_conv_type);
8113: end if;
8114: l_ae_curr_rec.currency_conv_rate := gl_currency_api.get_rate(i_ae_txn_rec.set_of_books_id,
8115: l_ae_curr_rec.alt_currency,
8116: i_ae_txn_rec.accounting_date,