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.12020000.2 2013/03/19 16:32:31 aabmishr 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 157: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')

153: WHERE oap.organization_id = l_organization_id
154: AND oap.acct_period_id = l_acct_period_id;
155:
156: CURSOR c_costing IS
157: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')
158: FROM sys.dual;
159:
160: l_org_name hr_all_organization_units.name%TYPE;
161: l_project_number pa_projects_all.segment1%TYPE;

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

209: l_eib_installed := cse_util_pkg.is_eib_installed ;
210: i := 0 ;
211:
212: IF l_eib_installed = 'Y' AND l_eib_costing_used = 'Y' THEN
213: fnd_profile.get('ORG_ID',l_ou_org_id);
214: l_txn_source_type_id := NULL ;
215:
216: OPEN mtl_trx_cur(p_transaction_id) ;
217: FETCH mtl_trx_cur INTO l_mtl_trx_quantity, l_txn_source_type_id, l_type_class, l_txn_action_id;