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.42.12020000.7 2013/06/06 09:47:14 djambhek 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 79: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

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

Line 80: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

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

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

1429: -- 4. Entire WBS using structure version id.
1430: -- 5. Program Rollup
1431:
1432:
1433: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
1434:
1435: IF g1_debug_mode = 'Y' THEN
1436: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT');
1437: END IF;

Line 4095: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

4091: l_msg_data VARCHAR2(250) ;
4092: l_data VARCHAR2(250) ;
4093: l_msg_index_out NUMBER ;
4094: l_error_msg_code VARCHAR2(250) ;
4095: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4096: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4097:
4098: BEGIN
4099: -- Bug 4242787 : Commented update_rollup_progress_pvt, IT is merged into rollup_progress_pvt

Line 4096: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

4092: l_data VARCHAR2(250) ;
4093: l_msg_index_out NUMBER ;
4094: l_error_msg_code VARCHAR2(250) ;
4095: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4096: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4097:
4098: BEGIN
4099: -- Bug 4242787 : Commented update_rollup_progress_pvt, IT is merged into rollup_progress_pvt
4100: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4219: l_base_struct_ver_id NUMBER; -- Bug 4573257
4220: l_last_as_of_date DATE; -- Bug 4573257
4221: BEGIN
4222:
4223: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4224:
4225: IF g1_debug_mode = 'Y' THEN
4226: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_FUTURE_PROGRESS_PVT');
4227: END IF;

Line 4388: l_user_id NUMBER := FND_GLOBAL.USER_ID;

4384: )
4385: IS
4386: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
4387: l_api_version CONSTANT NUMBER := p_api_version;
4388: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4389: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4390: l_return_status VARCHAR2(1);
4391: l_msg_count NUMBER;
4392: l_msg_data VARCHAR2(250);

Line 4389: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

4385: IS
4386: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
4387: l_api_version CONSTANT NUMBER := p_api_version;
4388: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4389: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4390: l_return_status VARCHAR2(1);
4391: l_msg_count NUMBER;
4392: l_msg_data VARCHAR2(250);
4393:

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

4589: --Open Question:
4590: --1. The parent Project progress record should go to the parent project cycle date.
4591: --As of now it is going with just passed as of date.
4592: --2.
4593: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4594:
4595: IF g1_debug_mode = 'Y' THEN
4596: pa_debug.init_err_stack ('PA_PROGRESS_PVT.PROGRAM_ROLLUP_PVT');
4597: END IF;

Line 5577: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

5573: l_msg_data VARCHAR2(250) ;
5574: l_data VARCHAR2(250) ;
5575: l_msg_index_out NUMBER ;
5576: l_error_msg_code VARCHAR2(250) ;
5577: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5578: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5579: l_lowest_task VARCHAR2(1) ;
5580: l_published_structure VARCHAR2(1) ;
5581: l_task_version_id NUMBER ;

Line 5578: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

5574: l_data VARCHAR2(250) ;
5575: l_msg_index_out NUMBER ;
5576: l_error_msg_code VARCHAR2(250) ;
5577: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5578: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5579: l_lowest_task VARCHAR2(1) ;
5580: l_published_structure VARCHAR2(1) ;
5581: l_task_version_id NUMBER ;
5582: l_rollup_table1 PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE ;

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

6912: l_subproj_task_version_id NUMBER;--4582956
6913:
6914: BEGIN
6915:
6916: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
6917:
6918: IF g1_debug_mode = 'Y' THEN
6919: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT');
6920: END IF;

Line 9085: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

9081: l_msg_data VARCHAR2(250) ;
9082: l_data VARCHAR2(250) ;
9083: l_msg_index_out NUMBER ;
9084: l_error_msg_code VARCHAR2(250) ;
9085: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9086: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9087:
9088: -- Bug 3958686 : Commented
9089: /*

Line 9086: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

9082: l_data VARCHAR2(250) ;
9083: l_msg_index_out NUMBER ;
9084: l_error_msg_code VARCHAR2(250) ;
9085: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9086: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9087:
9088: -- Bug 3958686 : Commented
9089: /*
9090: CURSOR cur_chk_asgn

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

9195: -- Bug 4661350 end
9196:
9197: BEGIN
9198:
9199: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
9200:
9201: IF g1_debug_mode = 'Y' THEN
9202: pa_debug.init_err_stack ('PA_PROGRESS_PVT.convert_task_prog_to_assgn');
9203: END IF;

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

9837: BEGIN
9838: x_msg_count := 0;
9839: x_return_status := FND_API.G_RET_STS_SUCCESS;
9840:
9841: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
9842:
9843: -- Set curr function
9844: pa_debug.set_curr_function(
9845: p_function =>'pa_fp_copy_from_pkg.copy_actuals_for_workplan'

Line 10247: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10243: IS
10244:
10245: l_api_name CONSTANT VARCHAR2(30) := 'ROLLUP_PROG_FROM_SUBPROJS';
10246: l_api_version CONSTANT NUMBER := p_api_version;
10247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10248: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10249: l_return_status VARCHAR2(1);
10250: l_msg_count NUMBER;
10251: l_msg_data VARCHAR2(250);

Line 10248: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10244:
10245: l_api_name CONSTANT VARCHAR2(30) := 'ROLLUP_PROG_FROM_SUBPROJS';
10246: l_api_version CONSTANT NUMBER := p_api_version;
10247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10248: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10249: l_return_status VARCHAR2(1);
10250: l_msg_count NUMBER;
10251: l_msg_data VARCHAR2(250);
10252: g1_debug_mode VARCHAR2(1);

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

10331: order by a.prg_level desc; --select the lowest level of projects first.
10332:
10333: BEGIN
10334:
10335: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10336:
10337: IF g1_debug_mode = 'Y' THEN
10338: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_PROG_FROM_SUBPROJS');
10339: END IF;

Line 10590: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

10586: l_msg_data VARCHAR2(250) ;
10587: l_data VARCHAR2(250) ;
10588: l_msg_index_out NUMBER ;
10589: l_error_msg_code VARCHAR2(250) ;
10590: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
10591: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
10592: l_lowest_task VARCHAR2(1) ;
10593: l_published_structure VARCHAR2(1) ;
10594: l_task_version_id NUMBER ;

Line 10591: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

10587: l_data VARCHAR2(250) ;
10588: l_msg_index_out NUMBER ;
10589: l_error_msg_code VARCHAR2(250) ;
10590: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
10591: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
10592: l_lowest_task VARCHAR2(1) ;
10593: l_published_structure VARCHAR2(1) ;
10594: l_task_version_id NUMBER ;
10595: l_rollup_table1 PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE;

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

11723: -- 3. Financial Structure Rollup.
11724: -- 4. Entire WBS using structure version id.
11725: -- 5. Program Rollup
11726:
11727: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
11728:
11729: IF g1_debug_mode = 'Y' THEN
11730: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_PVT');
11731: END IF;

Line 14146: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

14142: l_msg_data VARCHAR2(250) ;
14143: l_data VARCHAR2(250) ;
14144: l_msg_index_out NUMBER ;
14145: l_error_msg_code VARCHAR2(250) ;
14146: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
14147: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
14148: l_lowest_task VARCHAR2(1) ;
14149: l_published_structure VARCHAR2(1) ;
14150: l_task_version_id NUMBER ;

Line 14147: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

14143: l_data VARCHAR2(250) ;
14144: l_msg_index_out NUMBER ;
14145: l_error_msg_code VARCHAR2(250) ;
14146: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
14147: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
14148: l_lowest_task VARCHAR2(1) ;
14149: l_published_structure VARCHAR2(1) ;
14150: l_task_version_id NUMBER ;
14151: l_rollup_table1 PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE;

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

15293: -- 3. Financial Structure Rollup.
15294: -- 4. Entire WBS using structure version id.
15295: -- 5. Program Rollup
15296:
15297: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
15298:
15299: IF g1_debug_mode = 'Y' THEN
15300: pa_debug.init_err_stack ('PA_PROGRESS_PVT.ROLLUP_PVT');
15301: END IF;