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_FIN_PLAN_PVT dependencies on FND_GLOBAL

Line 175: last_updated_by=FND_GLOBAL.user_id,

171: update pa_budget_versions
172: set locked_by_person_id = l_person_id,
173: record_version_number = p_record_version_number + 1,
174: last_update_date=SYSDATE,
175: last_updated_by=FND_GLOBAL.user_id,
176: last_update_login=FND_GLOBAL.login_id
177: where budget_version_id = p_budget_version_id;
178: -- UNLOCK the version
179: elsif p_action = 'U' then

Line 176: last_update_login=FND_GLOBAL.login_id

172: set locked_by_person_id = l_person_id,
173: record_version_number = p_record_version_number + 1,
174: last_update_date=SYSDATE,
175: last_updated_by=FND_GLOBAL.user_id,
176: last_update_login=FND_GLOBAL.login_id
177: where budget_version_id = p_budget_version_id;
178: -- UNLOCK the version
179: elsif p_action = 'U' then
180: update pa_budget_versions

Line 184: last_updated_by=FND_GLOBAL.user_id,

180: update pa_budget_versions
181: set locked_by_person_id = null,
182: record_version_number = p_record_version_number + 1,
183: last_update_date=SYSDATE,
184: last_updated_by=FND_GLOBAL.user_id,
185: last_update_login=FND_GLOBAL.login_id
186: where budget_version_id = p_budget_version_id;
187: -- if p_action neither 'L' nor 'U', then we assume it's a lock/unlock toggle
188: else

Line 185: last_update_login=FND_GLOBAL.login_id

181: set locked_by_person_id = null,
182: record_version_number = p_record_version_number + 1,
183: last_update_date=SYSDATE,
184: last_updated_by=FND_GLOBAL.user_id,
185: last_update_login=FND_GLOBAL.login_id
186: where budget_version_id = p_budget_version_id;
187: -- if p_action neither 'L' nor 'U', then we assume it's a lock/unlock toggle
188: else
189: select nvl(locked_by_person_id, -1)

Line 199: last_updated_by=FND_GLOBAL.user_id,

195: update pa_budget_versions
196: set locked_by_person_id = l_person_id,
197: record_version_number = p_record_version_number + 1,
198: last_update_date=SYSDATE,
199: last_updated_by=FND_GLOBAL.user_id,
200: last_update_login=FND_GLOBAL.login_id
201: where budget_version_id = p_budget_version_id;
202: -- it was locked before: LOCK --> UNLOCK
203: else

Line 200: last_update_login=FND_GLOBAL.login_id

196: set locked_by_person_id = l_person_id,
197: record_version_number = p_record_version_number + 1,
198: last_update_date=SYSDATE,
199: last_updated_by=FND_GLOBAL.user_id,
200: last_update_login=FND_GLOBAL.login_id
201: where budget_version_id = p_budget_version_id;
202: -- it was locked before: LOCK --> UNLOCK
203: else
204: update pa_budget_versions

Line 208: last_updated_by=FND_GLOBAL.user_id,

204: update pa_budget_versions
205: set locked_by_person_id = null,
206: record_version_number = p_record_version_number + 1,
207: last_update_date=SYSDATE,
208: last_updated_by=FND_GLOBAL.user_id,
209: last_update_login=FND_GLOBAL.login_id
210: where budget_version_id = p_budget_version_id;
211: end if;
212: end if; -- p_action value

Line 209: last_update_login=FND_GLOBAL.login_id

205: set locked_by_person_id = null,
206: record_version_number = p_record_version_number + 1,
207: last_update_date=SYSDATE,
208: last_updated_by=FND_GLOBAL.user_id,
209: last_update_login=FND_GLOBAL.login_id
210: where budget_version_id = p_budget_version_id;
211: end if;
212: end if; -- p_action value
213: return;

Line 360: l_created_by:=FND_GLOBAL.user_id;

356: FND_MSG_PUB.initialize;
357: IF p_pa_debug_mode = 'Y' THEN
358: pa_debug.init_err_stack('PA_FIN_PLAN_PUB.Baseline_FinPlan');
359: END IF;
360: l_created_by:=FND_GLOBAL.user_id;
361: l_msg_count := 0;
362:
363: ------------ CHECK FOR BUSINESS RULES VIOLATIONS --------------
364: -- 1. RECORD VERSION NUMBER -- If record_version_number of p_budget_version_id

Line 658: last_updated_by = FND_GLOBAL.user_id,

654: /* set the status_code back to "Working" from "Submitted" for the version we're baselining */
655: --dbms_output.put_line('updating pa_budget_versions');
656: update pa_budget_versions
657: set last_update_date = SYSDATE,
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_login = FND_GLOBAL.login_id,
660: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING, -- bug 3978894 'W',
661: record_version_number = record_version_number+1
662: where budget_version_id = p_budget_version_id;

Line 659: last_update_login = FND_GLOBAL.login_id,

655: --dbms_output.put_line('updating pa_budget_versions');
656: update pa_budget_versions
657: set last_update_date = SYSDATE,
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_login = FND_GLOBAL.login_id,
660: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING, -- bug 3978894 'W',
661: record_version_number = record_version_number+1
662: where budget_version_id = p_budget_version_id;
663:

Line 678: last_updated_by = FND_GLOBAL.user_id,

674: END IF;
675:
676: UPDATE pa_budget_versions
677: SET last_update_date = SYSDATE,
678: last_updated_by = FND_GLOBAL.user_id,
679: last_update_login = FND_GLOBAL.login_id,
680: record_version_number = record_version_number+1,
681: rev_partially_impl_flag='N'
682: WHERE project_id = p_project_id

Line 679: last_update_login = FND_GLOBAL.login_id,

675:
676: UPDATE pa_budget_versions
677: SET last_update_date = SYSDATE,
678: last_updated_by = FND_GLOBAL.user_id,
679: last_update_login = FND_GLOBAL.login_id,
680: record_version_number = record_version_number+1,
681: rev_partially_impl_flag='N'
682: WHERE project_id = p_project_id
683: AND ci_id IS NOT NULL

Line 787: last_updated_by = FND_GLOBAL.user_id,

783: -- IF baselined_version_id EXISTS --> set CURRENT_FLAG to 'N' to remove current baselined
784: -- status
785: update pa_budget_versions
786: set last_update_date = SYSDATE,
787: last_updated_by = FND_GLOBAL.user_id,
788: last_update_login = FND_GLOBAL.login_id,
789: current_flag = 'N',
790: record_version_number = record_version_number+1
791: where budget_version_id=p_orig_budget_version_id;

Line 788: last_update_login = FND_GLOBAL.login_id,

784: -- status
785: update pa_budget_versions
786: set last_update_date = SYSDATE,
787: last_updated_by = FND_GLOBAL.user_id,
788: last_update_login = FND_GLOBAL.login_id,
789: current_flag = 'N',
790: record_version_number = record_version_number+1
791: where budget_version_id=p_orig_budget_version_id;
792: --dbms_output.put_line('THERE IS ORIG BUDGET VERSION ID: set it to be NOT CURRENT BASELINED');

Line 861: last_update_login = FND_GLOBAL.login_id,

857: FORALL i in l_temp_ci_id_tbl.FIRST..l_temp_ci_id_tbl.LAST
858: UPDATE pa_fp_merged_ctrl_items
859: SET inclusion_method_code = l_tmp_incl_method_code_tbl(i),
860: creation_date = l_cw_creation_date_tbl(i),
861: last_update_login = FND_GLOBAL.login_id,
862: last_updated_by = FND_GLOBAL.user_id,
863: last_update_date = SYSDATE
864: WHERE plan_version_id = l_target_version_id
865: AND project_id = p_project_id

Line 862: last_updated_by = FND_GLOBAL.user_id,

858: UPDATE pa_fp_merged_ctrl_items
859: SET inclusion_method_code = l_tmp_incl_method_code_tbl(i),
860: creation_date = l_cw_creation_date_tbl(i),
861: last_update_login = FND_GLOBAL.login_id,
862: last_updated_by = FND_GLOBAL.user_id,
863: last_update_date = SYSDATE
864: WHERE plan_version_id = l_target_version_id
865: AND project_id = p_project_id
866: AND ci_id = l_temp_ci_id_tbl(i)

Line 876: last_update_login = FND_GLOBAL.login_id,

872: FORALL i in l_temp_ci_id_tbl.FIRST..l_temp_ci_id_tbl.LAST
873: UPDATE pa_fp_merged_ctrl_items
874: SET inclusion_method_code = 'COPIED',
875: creation_date = l_bl_creation_date_tbl(i),
876: last_update_login = FND_GLOBAL.login_id,
877: last_updated_by = FND_GLOBAL.user_id,
878: last_update_date = SYSDATE
879: WHERE plan_version_id = p_budget_version_id
880: AND project_id = p_project_id

Line 877: last_updated_by = FND_GLOBAL.user_id,

873: UPDATE pa_fp_merged_ctrl_items
874: SET inclusion_method_code = 'COPIED',
875: creation_date = l_bl_creation_date_tbl(i),
876: last_update_login = FND_GLOBAL.login_id,
877: last_updated_by = FND_GLOBAL.user_id,
878: last_update_date = SYSDATE
879: WHERE plan_version_id = p_budget_version_id
880: AND project_id = p_project_id
881: AND ci_id = l_temp_ci_id_tbl(i)

Line 1379: l_created_by:=FND_GLOBAL.user_id;

1375: END IF;
1376: x_msg_count := 0;
1377:
1378: /* Added for bug 6176649 */
1379: l_created_by:=FND_GLOBAL.user_id;
1380:
1381:
1382: ------------ CHECK FOR BUSINESS RULES VIOLATIONS --------------
1383: -- 1. RECORD VERSION NUMBER -- If record_version_number of p_budget_version_id

Line 1536: last_updated_by = FND_GLOBAL.user_id,

1532: --- BUDGET RULES VERIFIED AND OK, PROCEED WITH SUBMITTING CURRENT WORKING ---
1533: /* set the status_code to "S" for the version we're submitting */
1534: update pa_budget_versions
1535: set last_update_date = SYSDATE,
1536: last_updated_by = FND_GLOBAL.user_id,
1537: last_update_login = FND_GLOBAL.login_id,
1538: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED, -- bug 3978894 'S',
1539: record_version_number = record_version_number+1
1540: where budget_version_id = p_budget_version_id;

Line 1537: last_update_login = FND_GLOBAL.login_id,

1533: /* set the status_code to "S" for the version we're submitting */
1534: update pa_budget_versions
1535: set last_update_date = SYSDATE,
1536: last_updated_by = FND_GLOBAL.user_id,
1537: last_update_login = FND_GLOBAL.login_id,
1538: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED, -- bug 3978894 'S',
1539: record_version_number = record_version_number+1
1540: where budget_version_id = p_budget_version_id;
1541: --dbms_output.put_line('update pa_budget_versions statement executed');

Line 1968: last_updated_by=fnd_global.user_id,

1964:
1965: UPDATE pa_budget_versions
1966: SET rev_partially_impl_flag='N',
1967: record_version_number=nvl(record_version_number,0)+1,
1968: last_updated_by=fnd_global.user_id,
1969: last_update_login=fnd_global.login_id,
1970: last_update_date=sysdate
1971: WHERE budget_Version_id=l_ci_rec_tab(i).ci_plan_version_id;
1972:

Line 1969: last_update_login=fnd_global.login_id,

1965: UPDATE pa_budget_versions
1966: SET rev_partially_impl_flag='N',
1967: record_version_number=nvl(record_version_number,0)+1,
1968: last_updated_by=fnd_global.user_id,
1969: last_update_login=fnd_global.login_id,
1970: last_update_date=sysdate
1971: WHERE budget_Version_id=l_ci_rec_tab(i).ci_plan_version_id;
1972:
1973: END IF;

Line 2338: l_user_id := FND_GLOBAL.User_id;

2334: (p_budget_version_id => l_curr_work_version_id);
2335:
2336: --Try to lock the version before deleting the version. This is required so as not to delete
2337: --versions locked by other users. AMG UT2
2338: l_user_id := FND_GLOBAL.User_id;
2339: pa_fin_plan_pvt.lock_unlock_version
2340: (p_budget_version_id => l_curr_work_version_id,
2341: p_record_version_number => l_record_version_number,
2342: p_action => 'L',

Line 2528: l_user_id := FND_GLOBAL.User_id;

2524: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);
2525:
2526: --Get the record version number of the newly created version
2527: l_created_ver_rec_ver_num := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_created_version_id);
2528: l_user_id := FND_GLOBAL.User_id;
2529: pa_fin_plan_pvt.lock_unlock_version
2530: (p_budget_version_id => l_CW_version_id,
2531: p_record_version_number => l_CW_record_version_number,
2532: p_action => 'L',

Line 3429: ,FND_GLOBAL.USER_ID

3425: ,pa_budget_lines_s.nextval
3426: ,p_fin_plan_version_id
3427: ,START_DATE
3428: ,SYSDATE
3429: ,FND_GLOBAL.USER_ID
3430: ,SYSDATE
3431: ,FND_GLOBAL.USER_ID
3432: ,FND_GLOBAL.LOGIN_ID
3433: ,END_DATE

Line 3431: ,FND_GLOBAL.USER_ID

3427: ,START_DATE
3428: ,SYSDATE
3429: ,FND_GLOBAL.USER_ID
3430: ,SYSDATE
3431: ,FND_GLOBAL.USER_ID
3432: ,FND_GLOBAL.LOGIN_ID
3433: ,END_DATE
3434: ,PERIOD_NAME
3435: ,null--QUANTITY

Line 3432: ,FND_GLOBAL.LOGIN_ID

3428: ,SYSDATE
3429: ,FND_GLOBAL.USER_ID
3430: ,SYSDATE
3431: ,FND_GLOBAL.USER_ID
3432: ,FND_GLOBAL.LOGIN_ID
3433: ,END_DATE
3434: ,PERIOD_NAME
3435: ,null--QUANTITY
3436: ,null--PROJFUNC_RAW_COST

Line 3578: ,FND_GLOBAL.USER_ID

3574: RESOURCE_ASSIGNMENT_ID
3575: ,p_fin_plan_version_id
3576: ,START_DATE
3577: ,SYSDATE
3578: ,FND_GLOBAL.USER_ID
3579: ,END_DATE
3580: ,PERIOD_NAME
3581: ,CHANGE_REASON_CODE
3582: ,DESCRIPTION