DBA Data[Home] [Help]

APPS.CSE_FA_TXN_PKG dependencies on FND_PROFILE

Line 5: l_debug varchar2(1) := NVL(fnd_profile.value('cse_debug_option'),'N');

1: PACKAGE BODY cse_fa_txn_pkg AS
2: /* $Header: CSEASTXB.pls 120.7.12020000.3 2012/12/28 16:53:38 dsingire ship $ */
3:
4:
5: l_debug varchar2(1) := NVL(fnd_profile.value('cse_debug_option'),'N');
6:
7: PROCEDURE debug( p_message IN varchar2) IS
8: BEGIN
9: IF l_debug = 'Y' THEN

Line 112: WHERE name = fnd_profile.value('CSI_DEFAULT_INSTANCE_STATUS')

108: BEGIN
109: SELECT instance_status_id
110: INTO l_def_Instance_status_id
111: FROM csi_instance_statuses
112: WHERE name = fnd_profile.value('CSI_DEFAULT_INSTANCE_STATUS')
113: AND ROWNUM =1 ;
114: EXCEPTION
115: WHEN OTHERS THEN
116: NULL;