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 2337: l_user_id := FND_GLOBAL.User_id;

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

Line 2527: l_user_id := FND_GLOBAL.User_id;

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

Line 3421: ,FND_GLOBAL.USER_ID

3417: ,pa_budget_lines_s.nextval
3418: ,p_fin_plan_version_id
3419: ,START_DATE
3420: ,SYSDATE
3421: ,FND_GLOBAL.USER_ID
3422: ,SYSDATE
3423: ,FND_GLOBAL.USER_ID
3424: ,FND_GLOBAL.LOGIN_ID
3425: ,END_DATE

Line 3423: ,FND_GLOBAL.USER_ID

3419: ,START_DATE
3420: ,SYSDATE
3421: ,FND_GLOBAL.USER_ID
3422: ,SYSDATE
3423: ,FND_GLOBAL.USER_ID
3424: ,FND_GLOBAL.LOGIN_ID
3425: ,END_DATE
3426: ,PERIOD_NAME
3427: ,null--QUANTITY

Line 3424: ,FND_GLOBAL.LOGIN_ID

3420: ,SYSDATE
3421: ,FND_GLOBAL.USER_ID
3422: ,SYSDATE
3423: ,FND_GLOBAL.USER_ID
3424: ,FND_GLOBAL.LOGIN_ID
3425: ,END_DATE
3426: ,PERIOD_NAME
3427: ,null--QUANTITY
3428: ,null--PROJFUNC_RAW_COST

Line 3570: ,FND_GLOBAL.USER_ID

3566: RESOURCE_ASSIGNMENT_ID
3567: ,p_fin_plan_version_id
3568: ,START_DATE
3569: ,SYSDATE
3570: ,FND_GLOBAL.USER_ID
3571: ,END_DATE
3572: ,PERIOD_NAME
3573: ,CHANGE_REASON_CODE
3574: ,DESCRIPTION