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 1533: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1529: l_s_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1530: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1531:
1532: l_last_update_date date := SYSDATE;
1533: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1534: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1535: l_plan_type_code char(1);
1536:
1537: BEGIN

Line 1534: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1530: l_d_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1531:
1532: l_last_update_date date := SYSDATE;
1533: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1534: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1535: l_plan_type_code char(1);
1536:
1537: BEGIN
1538:

Line 1808: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1804: l_original_exists NUMBER := NULL;
1805: l_processing_code VARCHAR2(1) := NULL;
1806:
1807: l_last_update_date date := SYSDATE;
1808: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1809: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1810: l_plan_type_code char(1) ; /*4771527 */
1811:
1812: BEGIN

Line 1809: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1805: l_processing_code VARCHAR2(1) := NULL;
1806:
1807: l_last_update_date date := SYSDATE;
1808: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1809: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1810: l_plan_type_code char(1) ; /*4771527 */
1811:
1812: BEGIN
1813:

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

2154:
2155: -- l_event_rec := p_event_rec;
2156: p_event_rec.creation_date := SYSDATE;
2157: p_event_rec.last_update_date := SYSDATE;
2158: p_event_rec.last_updated_by := Fnd_Global.USER_ID;
2159: p_event_rec.created_by := Fnd_Global.USER_ID;
2160: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;
2161:
2162: IF (p_event_rec.event_id IS NULL) THEN

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

2155: -- l_event_rec := p_event_rec;
2156: p_event_rec.creation_date := SYSDATE;
2157: p_event_rec.last_update_date := SYSDATE;
2158: p_event_rec.last_updated_by := Fnd_Global.USER_ID;
2159: p_event_rec.created_by := Fnd_Global.USER_ID;
2160: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;
2161:
2162: IF (p_event_rec.event_id IS NULL) THEN
2163: SELECT pa_pji_proj_events_log_s.NEXTVAL

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

2156: p_event_rec.creation_date := SYSDATE;
2157: p_event_rec.last_update_date := SYSDATE;
2158: p_event_rec.last_updated_by := Fnd_Global.USER_ID;
2159: p_event_rec.created_by := Fnd_Global.USER_ID;
2160: p_event_rec.last_update_login := Fnd_Global.LOGIN_ID;
2161:
2162: IF (p_event_rec.event_id IS NULL) THEN
2163: SELECT pa_pji_proj_events_log_s.NEXTVAL
2164: INTO p_event_rec.event_id

Line 2331: l_last_updated_by NUMBER := Fnd_Global.USER_ID;

2327:
2328: l_wbs_version_id NUMBER := NULL;
2329:
2330: l_last_update_date DATE := SYSDATE;
2331: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
2332: l_creation_date DATE := SYSDATE;
2333: l_created_by NUMBER := Fnd_Global.USER_ID;
2334: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
2335:

Line 2333: l_created_by NUMBER := Fnd_Global.USER_ID;

2329:
2330: l_last_update_date DATE := SYSDATE;
2331: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
2332: l_creation_date DATE := SYSDATE;
2333: l_created_by NUMBER := Fnd_Global.USER_ID;
2334: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
2335:
2336: excp_resource_busy EXCEPTION;
2337: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);

Line 2334: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;

2330: l_last_update_date DATE := SYSDATE;
2331: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
2332: l_creation_date DATE := SYSDATE;
2333: l_created_by NUMBER := Fnd_Global.USER_ID;
2334: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
2335:
2336: excp_resource_busy EXCEPTION;
2337: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);
2338:

Line 3198: , last_updated_by = Fnd_Global.USER_ID

3194: -- Todo: verifiy logic with VR.
3195: UPDATE pa_budget_versions
3196: SET original_flag = 'Y'
3197: , last_update_date = SYSDATE
3198: , last_updated_by = Fnd_Global.USER_ID
3199: , last_update_login = Fnd_Global.LOGIN_ID
3200: WHERE budget_version_id = p_original_version_id ;
3201:
3202: EXCEPTION

Line 3199: , last_update_login = Fnd_Global.LOGIN_ID

3195: UPDATE pa_budget_versions
3196: SET original_flag = 'Y'
3197: , last_update_date = SYSDATE
3198: , last_updated_by = Fnd_Global.USER_ID
3199: , last_update_login = Fnd_Global.LOGIN_ID
3200: WHERE budget_version_id = p_original_version_id ;
3201:
3202: EXCEPTION
3203: WHEN OTHERS THEN

Line 3220: l_last_updated_by NUMBER := Fnd_Global.USER_ID;

3216: , p_plan_version_id IN NUMBER
3217: , x_processing_code OUT NOCOPY VARCHAR2
3218: ) IS
3219: l_last_update_date DATE := SYSDATE;
3220: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
3221: l_creation_date DATE := SYSDATE;
3222: l_created_by NUMBER := Fnd_Global.USER_ID;
3223: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
3224: l_return_status VARCHAR2(1);

Line 3222: l_created_by NUMBER := Fnd_Global.USER_ID;

3218: ) IS
3219: l_last_update_date DATE := SYSDATE;
3220: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
3221: l_creation_date DATE := SYSDATE;
3222: l_created_by NUMBER := Fnd_Global.USER_ID;
3223: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
3224: l_return_status VARCHAR2(1);
3225: BEGIN
3226:

Line 3223: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;

3219: l_last_update_date DATE := SYSDATE;
3220: l_last_updated_by NUMBER := Fnd_Global.USER_ID;
3221: l_creation_date DATE := SYSDATE;
3222: l_created_by NUMBER := Fnd_Global.USER_ID;
3223: l_last_update_login NUMBER := Fnd_Global.LOGIN_ID;
3224: l_return_status VARCHAR2(1);
3225: BEGIN
3226:
3227: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 4149: 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);

4145: x_return_status => l_return_status,
4146: x_msg_count => l_msg_count ,
4147: x_msg_data => l_msg_data);
4148: IF g_debug_mode='Y' THEN
4149: 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);
4150: end if;
4151: END IF;
4152:
4153:

Line 4507: p_request_id => Fnd_Global.CONC_REQUEST_ID,

4503:
4504: WBS_LOCK_PVT (
4505: p_event_id => l_event_id,
4506: p_online_flag => 'Y',
4507: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4508: x_lock_mode => l_lock_mode,
4509: x_return_status => l_return_status );
4510:
4511: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 4608: p_request_id => Fnd_Global.CONC_REQUEST_ID,

4604:
4605: WBS_LOCK_PVT (
4606: p_event_id => l_event_id,
4607: p_online_flag => 'Y',
4608: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4609: x_lock_mode => l_lock_mode,
4610: x_return_status => l_return_status );
4611:
4612: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 4727: p_request_id => Fnd_Global.CONC_REQUEST_ID,

4723:
4724: WBS_LOCK_PVT (
4725: p_event_id => l_event_id,
4726: p_online_flag => 'Y',
4727: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4728: x_lock_mode => l_lock_mode,
4729: x_return_status => l_return_status );
4730:
4731: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 4837: p_request_id => Fnd_Global.CONC_REQUEST_ID,

4833:
4834: WBS_LOCK_PVT (
4835: p_event_id => p_event_id,
4836: p_online_flag => 'N', --- 5138049 because in online NOWAIT is used
4837: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4838: x_lock_mode => l_lock_mode ,
4839: x_return_status => l_return_status );
4840: IF g_debug_mode='Y' THEN
4841: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);

Line 4849: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

4845: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
4846: , 'CONC_PUBLISH', 'PUE'
4847: , 'CONC_UPDATE', 'WUE', null),
4848: process_update_wbs_flag = 'Y', /* 5138049 */
4849: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
4850: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4851: AND PROJECT_ID = l_project_id;
4852: retcode := 2;
4853: errbuf := SQLERRM;

Line 4874: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

4870: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);
4871: end if;
4872: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4873:
4874: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4875: rollback to process_proj_sum_conc;
4876: UPDATE pa_proj_elem_ver_structure
4877: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
4878: , 'CONC_PUBLISH', 'PUE'

Line 4881: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

4877: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
4878: , 'CONC_PUBLISH', 'PUE'
4879: , 'CONC_UPDATE', 'WUE', null),
4880: process_update_wbs_flag = 'Y', /* 5138049 */
4881: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
4882: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4883: AND PROJECT_ID = l_project_id;
4884: /*
4885: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(

Line 4889: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

4885: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4886: p_project_id => l_project_id,
4887: p_structure_version_id => l_struct_version_id,
4888: p_calling_context => p_calling_context,
4889: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,
4890: x_return_status => l_return_status );
4891: */
4892: END IF;
4893:

Line 4897: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

4893:
4894: retcode := 2;
4895: errbuf := SQLERRM;
4896: ELSE
4897: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4898: UPDATE pa_proj_elem_ver_structure
4899: SET PROCESS_CODE = NULL,
4900: process_update_wbs_flag='N',
4901: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

Line 4901: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID

4897: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4898: UPDATE pa_proj_elem_ver_structure
4899: SET PROCESS_CODE = NULL,
4900: process_update_wbs_flag='N',
4901: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
4902: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4903: AND PROJECT_ID = l_project_id;
4904: END IF;
4905: retcode := 0;

Line 4921: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

4917:
4918: EXCEPTION
4919: WHEN OTHERS THEN
4920: rollback to process_proj_sum_conc;
4921: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4922: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4923: p_project_id => l_project_id,
4924: p_structure_version_id => l_struct_version_id,
4925: p_calling_context => p_calling_context,

Line 4926: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,

4922: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE_ERR(
4923: p_project_id => l_project_id,
4924: p_structure_version_id => l_struct_version_id,
4925: p_calling_context => p_calling_context,
4926: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,
4927: x_return_status => l_return_status );
4928: END IF;
4929: IF g_debug_mode='Y' THEN
4930: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES : COMING to the exception' ,null,5);

Line 5023: p_request_id => Fnd_Global.CONC_REQUEST_ID,

5019:
5020: WBS_LOCK_PVT (
5021: p_event_id => p_event_id,
5022: p_online_flag => 'Y',
5023: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5024: x_lock_mode => l_lock_mode,
5025: x_return_status => l_return_status );
5026:
5027: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 5407: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

5403: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5404: l_count NUMBER := 1;
5405:
5406: l_last_update_date date := SYSDATE;
5407: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5408: l_creation_date date := SYSDATE;
5409: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5409: l_created_by NUMBER := FND_GLOBAL.USER_ID;

5405:
5406: l_last_update_date date := SYSDATE;
5407: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5408: l_creation_date date := SYSDATE;
5409: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5412: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

5406: l_last_update_date date := SYSDATE;
5407: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
5408: l_creation_date date := SYSDATE;
5409: l_created_by NUMBER := FND_GLOBAL.USER_ID;
5410: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
5411: il_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5412: il_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(); /*4471527 */
5413: il_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5414: il_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();