eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_PVT dependencies on FND_GLOBAL

Line 6: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

2: /* $Header: PAPCPVTB.pls 120.30.12010000.4 2008/12/11 11:22:37 jsundara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROGRESS_PVT';
5:
6: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
7:
8: -- Start of comments
9: -- API name : ROLLUP_PROGRESS_PVT
10: -- Type : Public

Line 78: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

74: l_msg_data VARCHAR2(250) ;
75: l_data VARCHAR2(250) ;
76: l_msg_index_out NUMBER ;
77: l_error_msg_code VARCHAR2(250) ;
78: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
79: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
80: l_lowest_task VARCHAR2(1) ;
81: l_published_structure VARCHAR2(1) ;
82: l_task_version_id NUMBER ;

Line 79: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

75: l_data VARCHAR2(250) ;
76: l_msg_index_out NUMBER ;
77: l_error_msg_code VARCHAR2(250) ;
78: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
79: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
80: l_lowest_task VARCHAR2(1) ;
81: l_published_structure VARCHAR2(1) ;
82: l_task_version_id NUMBER ;
83: l_rollup_table1 PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE;

Line 1426: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

1422: -- 4. Entire WBS using structure version id.
1423: -- 5. Program Rollup
1424:
1425:
1426: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
1427:
1428: IF g1_debug_mode = 'Y' THEN
1429: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT');
1430: END IF;

Line 4052: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

4048: l_msg_data VARCHAR2(250) ;
4049: l_data VARCHAR2(250) ;
4050: l_msg_index_out NUMBER ;
4051: l_error_msg_code VARCHAR2(250) ;
4052: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4053: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4054:
4055: BEGIN
4056: -- Bug 4242787 : Commented update_rollup_progress_pvt, IT is merged into rollup_progress_pvt

Line 4053: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

4049: l_data VARCHAR2(250) ;
4050: l_msg_index_out NUMBER ;
4051: l_error_msg_code VARCHAR2(250) ;
4052: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4053: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4054:
4055: BEGIN
4056: -- Bug 4242787 : Commented update_rollup_progress_pvt, IT is merged into rollup_progress_pvt
4057: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4180: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

4176: l_base_struct_ver_id NUMBER; -- Bug 4573257
4177: l_last_as_of_date DATE; -- Bug 4573257
4178: BEGIN
4179:
4180: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4181:
4182: IF g1_debug_mode = 'Y' THEN
4183: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_FUTURE_PROGRESS_PVT');
4184: END IF;

Line 4345: l_user_id NUMBER := FND_GLOBAL.USER_ID;

4341: )
4342: IS
4343: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
4344: l_api_version CONSTANT NUMBER := p_api_version;
4345: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4346: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4347: l_return_status VARCHAR2(1);
4348: l_msg_count NUMBER;
4349: l_msg_data VARCHAR2(250);

Line 4346: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

4342: IS
4343: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
4344: l_api_version CONSTANT NUMBER := p_api_version;
4345: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4346: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4347: l_return_status VARCHAR2(1);
4348: l_msg_count NUMBER;
4349: l_msg_data VARCHAR2(250);
4350:

Line 4540: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

4536: --Open Question:
4537: --1. The parent Project progress record should go to the parent project cycle date.
4538: --As of now it is going with just passed as of date.
4539: --2.
4540: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4541:
4542: IF g1_debug_mode = 'Y' THEN
4543: pa_debug.init_err_stack ('PA_PROGRESS_PVT.PROGRAM_ROLLUP_PVT');
4544: END IF;

Line 5511: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

5507: l_msg_data VARCHAR2(250) ;
5508: l_data VARCHAR2(250) ;
5509: l_msg_index_out NUMBER ;
5510: l_error_msg_code VARCHAR2(250) ;
5511: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5512: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5513: l_lowest_task VARCHAR2(1) ;
5514: l_published_structure VARCHAR2(1) ;
5515: l_task_version_id NUMBER ;

Line 5512: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

5508: l_data VARCHAR2(250) ;
5509: l_msg_index_out NUMBER ;
5510: l_error_msg_code VARCHAR2(250) ;
5511: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5512: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5513: l_lowest_task VARCHAR2(1) ;
5514: l_published_structure VARCHAR2(1) ;
5515: l_task_version_id NUMBER ;
5516: l_rollup_table1 PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE ;

Line 6850: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

6846: l_subproj_task_version_id NUMBER;--4582956
6847:
6848: BEGIN
6849:
6850: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
6851:
6852: IF g1_debug_mode = 'Y' THEN
6853: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT');
6854: END IF;

Line 9019: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

9015: l_msg_data VARCHAR2(250) ;
9016: l_data VARCHAR2(250) ;
9017: l_msg_index_out NUMBER ;
9018: l_error_msg_code VARCHAR2(250) ;
9019: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9020: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9021:
9022: -- Bug 3958686 : Commented
9023: /*

Line 9020: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

9016: l_data VARCHAR2(250) ;
9017: l_msg_index_out NUMBER ;
9018: l_error_msg_code VARCHAR2(250) ;
9019: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9020: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9021:
9022: -- Bug 3958686 : Commented
9023: /*
9024: CURSOR cur_chk_asgn

Line 9133: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

9129: -- Bug 4661350 end
9130:
9131: BEGIN
9132:
9133: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
9134:
9135: IF g1_debug_mode = 'Y' THEN
9136: pa_debug.init_err_stack ('PA_PROGRESS_PVT.convert_task_prog_to_assgn');
9137: END IF;

Line 9773: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

9769: BEGIN
9770: x_msg_count := 0;
9771: x_return_status := FND_API.G_RET_STS_SUCCESS;
9772:
9773: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
9774:
9775: -- Set curr function
9776: pa_debug.set_curr_function(
9777: p_function =>'pa_fp_copy_from_pkg.copy_actuals_for_workplan'

Line 10179: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10175: IS
10176:
10177: l_api_name CONSTANT VARCHAR2(30) := 'ROLLUP_PROG_FROM_SUBPROJS';
10178: l_api_version CONSTANT NUMBER := p_api_version;
10179: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10180: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10181: l_return_status VARCHAR2(1);
10182: l_msg_count NUMBER;
10183: l_msg_data VARCHAR2(250);

Line 10180: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10176:
10177: l_api_name CONSTANT VARCHAR2(30) := 'ROLLUP_PROG_FROM_SUBPROJS';
10178: l_api_version CONSTANT NUMBER := p_api_version;
10179: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10180: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10181: l_return_status VARCHAR2(1);
10182: l_msg_count NUMBER;
10183: l_msg_data VARCHAR2(250);
10184: g1_debug_mode VARCHAR2(1);

Line 10219: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

10215: order by a.prg_level desc; --select the lowest level of projects first.
10216:
10217: BEGIN
10218:
10219: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10220:
10221: IF g1_debug_mode = 'Y' THEN
10222: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_PROG_FROM_SUBPROJS');
10223: END IF;