DBA Data[Home] [Help]

APPS.CSE_COST_COLLECTOR dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSE_DEBUG_OPTION'),'N');

1: PACKAGE BODY cse_cost_collector AS
2: /* $Header: CSECSTHB.pls 120.9.12010000.1 2008/07/30 05:17:16 appldev ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSE_DEBUG_OPTION'),'N');
5:
6: PROCEDURE debug(p_message IN varchar2) IS
7: BEGIN
8: IF (l_debug = 'Y') THEN

Line 144: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')

140: WHERE oap.organization_id = l_organization_id
141: AND oap.acct_period_id = l_acct_period_id;
142:
143: CURSOR c_costing IS
144: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')
145: FROM sys.dual;
146:
147: l_org_name hr_all_organization_units.name%TYPE;
148: l_project_number pa_projects_all.segment1%TYPE;

Line 200: fnd_profile.get('ORG_ID',l_ou_org_id);

196: l_eib_installed := cse_util_pkg.is_eib_installed ;
197: i := 0 ;
198:
199: IF l_eib_installed = 'Y' AND l_eib_costing_used = 'Y' THEN
200: fnd_profile.get('ORG_ID',l_ou_org_id);
201: l_txn_source_type_id := NULL ;
202:
203: OPEN mtl_trx_cur(p_transaction_id) ;
204: FETCH mtl_trx_cur INTO l_mtl_trx_quantity, l_txn_source_type_id, l_type_class, l_txn_action_id;