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.12.12020000.3 2013/03/06 09:51:42 admarath 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 10356: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

10352: l_module_name VARCHAR2(100);
10353: BEGIN
10354: x_msg_count := 0;
10355: x_return_status := FND_API.G_RET_STS_SUCCESS;
10356: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10357: l_module_name := 'release_capint_txns';
10358: pa_debug.set_curr_function( p_function => 'release_capint_txns',
10359: p_debug_mode => l_debug_mode );
10360: IF l_debug_mode = 'Y' THEN

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

10464: WHERE run_id=p_run_id;
10465: BEGIN
10466: x_msg_count := 0;
10467: x_return_status := FND_API.G_RET_STS_SUCCESS;
10468: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10469: l_module_name := 'delete_cint_source_dets';
10470: pa_debug.set_curr_function( p_function => l_module_name,
10471: p_debug_mode => l_debug_mode );
10472: IF l_debug_mode = 'Y' THEN