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.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_GLOBAL

Line 1909: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1905: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1906: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1907:
1908: l_last_update_date date := SYSDATE;
1909: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1910: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1911: l_plan_type_code char(1);
1912:
1913: BEGIN

Line 1910: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1906: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1907:
1908: l_last_update_date date := SYSDATE;
1909: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1910: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1911: l_plan_type_code char(1);
1912:
1913: BEGIN
1914:

Line 2184: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2180: l_original_exists NUMBER := NULL;
2181: l_processing_code VARCHAR2(1) := NULL;
2182:
2183: l_last_update_date date := SYSDATE;
2184: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2185: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2186: l_plan_type_code char(1) ; /*4771527 */
2187:
2188: BEGIN

Line 2185: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

2181: l_processing_code VARCHAR2(1) := NULL;
2182:
2183: l_last_update_date date := SYSDATE;
2184: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2185: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2186: l_plan_type_code char(1) ; /*4771527 */
2187:
2188: BEGIN
2189:

Line 2534: p_event_rec.last_updated_by := Fnd_Global.USER_ID;

2530:
2531: -- l_event_rec := p_event_rec;
2532: p_event_rec.creation_date := SYSDATE;
2533: p_event_rec.last_update_date := SYSDATE;
2534: p_event_rec.last_updated_by := Fnd_Global.USER_ID;
2535: p_event_rec.created_by := Fnd_Global.USER_ID;
2536: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;
2537:
2538: IF (p_event_rec.event_id IS NULL) THEN

Line 2535: p_event_rec.created_by := Fnd_Global.USER_ID;

2531: -- l_event_rec := p_event_rec;
2532: p_event_rec.creation_date := SYSDATE;
2533: p_event_rec.last_update_date := SYSDATE;
2534: p_event_rec.last_updated_by := Fnd_Global.USER_ID;
2535: p_event_rec.created_by := Fnd_Global.USER_ID;
2536: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;
2537:
2538: IF (p_event_rec.event_id IS NULL) THEN
2539: SELECT pa_pji_proj_events_log_s.NEXTVAL

Line 2536: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;

2532: p_event_rec.creation_date := SYSDATE;
2533: p_event_rec.last_update_date := SYSDATE;
2534: p_event_rec.last_updated_by := Fnd_Global.USER_ID;
2535: p_event_rec.created_by := Fnd_Global.USER_ID;
2536: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;
2537:
2538: IF (p_event_rec.event_id IS NULL) THEN
2539: SELECT pa_pji_proj_events_log_s.NEXTVAL
2540: INTO p_event_rec.event_id

Line 2707: l_last_updated_by NUMBER := Fnd_Global.USER_ID;

2703:
2704: l_wbs_version_id NUMBER := NULL;
2705:
2706: l_last_update_date DATE := SYSDATE;
2707: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
2708: l_creation_date DATE := SYSDATE;
2709: l_created_by NUMBER := Fnd_Global.USER_ID;
2710: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
2711:

Line 2709: l_created_by NUMBER := Fnd_Global.USER_ID;

2705:
2706: l_last_update_date DATE := SYSDATE;
2707: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
2708: l_creation_date DATE := SYSDATE;
2709: l_created_by NUMBER := Fnd_Global.USER_ID;
2710: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
2711:
2712: excp_resource_busy EXCEPTION;
2713: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);

Line 2710: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;

2706: l_last_update_date DATE := SYSDATE;
2707: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
2708: l_creation_date DATE := SYSDATE;
2709: l_created_by NUMBER := Fnd_Global.USER_ID;
2710: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
2711:
2712: excp_resource_busy EXCEPTION;
2713: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);
2714:

Line 3574: , last_updated_by = Fnd_Global.USER_ID

3570: -- Todo: verifiy logic with VR.
3571: UPDATE pa_budget_versions
3572: SET original_flag = 'Y'
3573: , last_update_date = SYSDATE
3574: , last_updated_by = Fnd_Global.USER_ID
3575: , last_update_login = Fnd_Global.LOGIN_ID
3576: WHERE budget_version_id = p_original_version_id ;
3577:
3578: EXCEPTION

Line 3575: , last_update_login = Fnd_Global.LOGIN_ID

3571: UPDATE pa_budget_versions
3572: SET original_flag = 'Y'
3573: , last_update_date = SYSDATE
3574: , last_updated_by = Fnd_Global.USER_ID
3575: , last_update_login = Fnd_Global.LOGIN_ID
3576: WHERE budget_version_id = p_original_version_id ;
3577:
3578: EXCEPTION
3579: WHEN OTHERS THEN

Line 3596: l_last_updated_by NUMBER := Fnd_Global.USER_ID;

3592: , p_plan_version_id IN NUMBER
3593: , x_processing_code OUT NOCOPY VARCHAR2
3594: ) IS
3595: l_last_update_date DATE := SYSDATE;
3596: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
3597: l_creation_date DATE := SYSDATE;
3598: l_created_by NUMBER := Fnd_Global.USER_ID;
3599: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
3600: l_return_status VARCHAR2(1);

Line 3598: l_created_by NUMBER := Fnd_Global.USER_ID;

3594: ) IS
3595: l_last_update_date DATE := SYSDATE;
3596: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
3597: l_creation_date DATE := SYSDATE;
3598: l_created_by NUMBER := Fnd_Global.USER_ID;
3599: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
3600: l_return_status VARCHAR2(1);
3601: BEGIN
3602:

Line 3599: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;

3595: l_last_update_date DATE := SYSDATE;
3596: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
3597: l_creation_date DATE := SYSDATE;
3598: l_created_by NUMBER := Fnd_Global.USER_ID;
3599: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
3600: l_return_status VARCHAR2(1);
3601: BEGIN
3602:
3603: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 4526: Pji_Utils.write2log( 'after call to APPLY_LP_PROG_ON_CWV :l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data||'CONC_REQUEST_Id:'||Fnd_Global.CONC_REQUEST_ID,null,3);

4522: x_return_status => l_return_status,
4523: x_msg_count => l_msg_count ,
4524: x_msg_data => l_msg_data);
4525: IF g_debug_mode='Y' THEN
4526: Pji_Utils.write2log( 'after call to APPLY_LP_PROG_ON_CWV :l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data||'CONC_REQUEST_Id:'||Fnd_Global.CONC_REQUEST_ID,null,3);
4527: end if;
4528: END IF;
4529:
4530:

Line 4885: p_request_id => Fnd_Global.CONC_REQUEST_ID,

4881:
4882: WBS_LOCK_PVT (
4883: p_event_id => l_event_id,
4884: p_online_flag => 'Y',
4885: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4886: x_lock_mode => l_lock_mode,
4887: x_return_status => l_return_status );
4888:
4889: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 4986: p_request_id => Fnd_Global.CONC_REQUEST_ID,

4982:
4983: WBS_LOCK_PVT (
4984: p_event_id => l_event_id,
4985: p_online_flag => 'Y',
4986: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4987: x_lock_mode => l_lock_mode,
4988: x_return_status => l_return_status );
4989:
4990: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 5105: p_request_id => Fnd_Global.CONC_REQUEST_ID,

5101:
5102: WBS_LOCK_PVT (
5103: p_event_id => l_event_id,
5104: p_online_flag => 'Y',
5105: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5106: x_lock_mode => l_lock_mode,
5107: x_return_status => l_return_status );
5108:
5109: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 5215: p_request_id => Fnd_Global.CONC_REQUEST_ID,

5211:
5212: WBS_LOCK_PVT (
5213: p_event_id => p_event_id,
5214: p_online_flag => 'N', --- 5138049 because in online NOWAIT is used
5215: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5216: x_lock_mode => l_lock_mode ,
5217: x_return_status => l_return_status );
5218: IF g_debug_mode='Y' THEN
5219: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);

Line 5227: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

5223: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
5224: , 'CONC_PUBLISH', 'PUE'
5225: , 'CONC_UPDATE', 'WUE', null),
5226: process_update_wbs_flag = 'Y', /* 5138049 */
5227: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
5228: WHERE ELEMENT_VERSION_ID = l_struct_version_id
5229: AND PROJECT_ID = l_project_id;
5230: retcode := 2;
5231: errbuf := SQLERRM;

Line 5252: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

5248: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);
5249: end if;
5250: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5251:
5252: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5253: rollback to process_proj_sum_conc;
5254: UPDATE pa_proj_elem_ver_structure
5255: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
5256: , 'CONC_PUBLISH', 'PUE'

Line 5259: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

5255: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
5256: , 'CONC_PUBLISH', 'PUE'
5257: , 'CONC_UPDATE', 'WUE', null),
5258: process_update_wbs_flag = 'Y', /* 5138049 */
5259: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
5260: WHERE ELEMENT_VERSION_ID = l_struct_version_id
5261: AND PROJECT_ID = l_project_id;
5262: /*
5263: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

Line 5267: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

5263: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
5264: p_project_id => l_project_id,
5265: p_structure_version_id => l_struct_version_id,
5266: p_calling_context => p_calling_context,
5267: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,
5268: x_return_status => l_return_status );
5269: */
5270: END IF;
5271:

Line 5275: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

5271:
5272: retcode := 2;
5273: errbuf := SQLERRM;
5274: ELSE
5275: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5276: UPDATE pa_proj_elem_ver_structure
5277: SET PROCESS_CODE = NULL,
5278: process_update_wbs_flag='N',
5279: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

Line 5279: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

5275: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5276: UPDATE pa_proj_elem_ver_structure
5277: SET PROCESS_CODE = NULL,
5278: process_update_wbs_flag='N',
5279: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
5280: WHERE ELEMENT_VERSION_ID = l_struct_version_id
5281: AND PROJECT_ID = l_project_id;
5282: END IF;
5283: retcode := 0;

Line 5299: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

5295:
5296: EXCEPTION
5297: WHEN OTHERS THEN
5298: rollback to process_proj_sum_conc;
5299: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5300: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
5301: p_project_id => l_project_id,
5302: p_structure_version_id => l_struct_version_id,
5303: p_calling_context => l_calling_context, --Bug fix 6456711

Line 5304: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

5300: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
5301: p_project_id => l_project_id,
5302: p_structure_version_id => l_struct_version_id,
5303: p_calling_context => l_calling_context, --Bug fix 6456711
5304: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,
5305: x_return_status => l_return_status );
5306: END IF;
5307: IF g_debug_mode='Y' THEN
5308: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES : COMING to the exception' ,null,5);

Line 5401: p_request_id => Fnd_Global.CONC_REQUEST_ID,

5397:
5398: WBS_LOCK_PVT (
5399: p_event_id => p_event_id,
5400: p_online_flag => 'Y',
5401: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5402: x_lock_mode => l_lock_mode,
5403: x_return_status => l_return_status );
5404:
5405: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 5785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

5781: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5782: l_count NUMBER := 1;
5783:
5784: l_last_update_date date := SYSDATE;
5785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5786: l_creation_date date := SYSDATE;
5787: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5787: l_created_by NUMBER := FND_GLOBAL.USER_ID;

5783:
5784: l_last_update_date date := SYSDATE;
5785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5786: l_creation_date date := SYSDATE;
5787: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5790: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

5784: l_last_update_date date := SYSDATE;
5785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5786: l_creation_date date := SYSDATE;
5787: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5788: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5789: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5790: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5791: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5792: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();