APPS.PA_ALLOC_RUN dependencies on FND_PROFILE

Line 3: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY PA_ALLOC_RUN AS
2: /* $Header: PAXALRNB.pls 120.7 2008/03/18 14:59:01 sgottimu ship $ */
3: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: G_creation_date DATE ;
5: G_last_update_date DATE ;
6: G_created_by NUMBER ;
7: G_last_updated_by NUMBER ;

Line 51: G_created_by := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

47: -- ------------------------------------------------------------
48: PROCEDURE Init_who_cols
49: IS
50: BEGIN
51: G_created_by := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
52: G_last_update_login := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);
53: G_last_updated_by := G_created_by;
54: G_creation_date := G_sysdate;
55: G_last_update_date := G_sysdate ;

Line 52: G_last_update_login := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);

48: PROCEDURE Init_who_cols
49: IS
50: BEGIN
51: G_created_by := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
52: G_last_update_login := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);
53: G_last_updated_by := G_created_by;
54: G_creation_date := G_sysdate;
55: G_last_update_date := G_sysdate ;
56: END Init_who_cols ;

Line 10251: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

10247: l_module_name VARCHAR2(100);
10248: BEGIN
10249: x_msg_count := 0;
10250: x_return_status := FND_API.G_RET_STS_SUCCESS;
10251: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10252: l_module_name := 'release_capint_txns';
10253: pa_debug.set_curr_function( p_function => 'release_capint_txns',
10254: p_debug_mode => l_debug_mode );
10255: IF l_debug_mode = 'Y' THEN

Line 10363: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

10359: WHERE run_id=p_run_id;
10360: BEGIN
10361: x_msg_count := 0;
10362: x_return_status := FND_API.G_RET_STS_SUCCESS;
10363: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10364: l_module_name := 'delete_cint_source_dets';
10365: pa_debug.set_curr_function( p_function => l_module_name,
10366: p_debug_mode => l_debug_mode );
10367: IF l_debug_mode = 'Y' THEN