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

Line 165: last_update_login = fnd_global.login_id,

161: if check_pre_approved_cur%found then
162: update psp_eff_reports
163: set status_code = 'A',
164: last_update_date = sysdate,
165: last_update_login = fnd_global.login_id,
166: last_updated_by = fnd_global.user_id
167: where request_id = l_request_id;
168: end if;
169: close check_pre_approved_cur;

Line 166: last_updated_by = fnd_global.user_id

162: update psp_eff_reports
163: set status_code = 'A',
164: last_update_date = sysdate,
165: last_update_login = fnd_global.login_id,
166: last_updated_by = fnd_global.user_id
167: where request_id = l_request_id;
168: end if;
169: close check_pre_approved_cur;
170:

Line 626: l_user_id := fnd_global.user_id;

622: hr_utility.trace(' Entering GET_NEXT_APPROVER');
623: l_same_approval_level := 'N';
624: ---hr_utility.trace_on('Y','WF-1');
625:
626: l_user_id := fnd_global.user_id;
627: l_login_id := fnd_global.login_id;
628: if funcmode = 'RUN' then
629: l_approver_order_num :=
630: wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 627: l_login_id := fnd_global.login_id;

623: l_same_approval_level := 'N';
624: ---hr_utility.trace_on('Y','WF-1');
625:
626: l_user_id := fnd_global.user_id;
627: l_login_id := fnd_global.login_id;
628: if funcmode = 'RUN' then
629: l_approver_order_num :=
630: wf_engine.GetItemAttrNumber(itemtype => itemtype,
631: itemkey => itemkey,

Line 653: er.last_update_login = fnd_global.login_id,

649: elsif l_approval_type in ('PMG', 'TMG', 'GPI') then
650: update psp_eff_reports er
651: set er.status_code = 'A',
652: er.last_update_date = sysdate,
653: er.last_update_login = fnd_global.login_id,
654: er.last_updated_by = fnd_global.user_id
655: where er.status_code = 'N'
656: and er.effort_report_id in
657: (select erd.effort_report_id

Line 654: er.last_updated_by = fnd_global.user_id

650: update psp_eff_reports er
651: set er.status_code = 'A',
652: er.last_update_date = sysdate,
653: er.last_update_login = fnd_global.login_id,
654: er.last_updated_by = fnd_global.user_id
655: where er.status_code = 'N'
656: and er.effort_report_id in
657: (select erd.effort_report_id
658: from psp_eff_report_details erd,

Line 792: er.last_update_login = fnd_global.login_id,

788: if l_temp_not_found = 'Y' then
789: update psp_eff_reports er
790: set er.status_code = 'A',
791: er.last_update_date = sysdate,
792: er.last_update_login = fnd_global.login_id,
793: er.last_updated_by = fnd_global.user_id
794: where er.status_code = 'N'
795: and er.effort_report_id in
796: (select erd.effort_report_id

Line 793: er.last_updated_by = fnd_global.user_id

789: update psp_eff_reports er
790: set er.status_code = 'A',
791: er.last_update_date = sysdate,
792: er.last_update_login = fnd_global.login_id,
793: er.last_updated_by = fnd_global.user_id
794: where er.status_code = 'N'
795: and er.effort_report_id in
796: (select erd.effort_report_id
797: from psp_eff_report_details erd,

Line 1022: era.last_update_login = fnd_global.login_id,

1018: update psp_eff_report_approvals era
1019: set era.approval_status = 'S',
1020: era.response_date = sysdate,
1021: era.last_update_date = sysdate,
1022: era.last_update_login = fnd_global.login_id,
1023: era.last_updated_by = fnd_global.user_id
1024: where era.wf_item_key = itemkey
1025: and era.wf_role_name = l_rname
1026: and exists

Line 1023: era.last_updated_by = fnd_global.user_id

1019: set era.approval_status = 'S',
1020: era.response_date = sysdate,
1021: era.last_update_date = sysdate,
1022: era.last_update_login = fnd_global.login_id,
1023: era.last_updated_by = fnd_global.user_id
1024: where era.wf_item_key = itemkey
1025: and era.wf_role_name = l_rname
1026: and exists
1027: ( select erd.effort_report_detail_id

Line 1039: era.last_update_login = fnd_global.login_id,

1035: update psp_eff_report_approvals era
1036: set era.approval_status = 'R',
1037: era.response_date = sysdate,
1038: era.last_update_date = sysdate,
1039: era.last_update_login = fnd_global.login_id,
1040: era.last_updated_by = fnd_global.user_id
1041: where era.wf_item_key = itemkey
1042: and era.wf_role_name = l_rname
1043: and not exists

Line 1040: era.last_updated_by = fnd_global.user_id

1036: set era.approval_status = 'R',
1037: era.response_date = sysdate,
1038: era.last_update_date = sysdate,
1039: era.last_update_login = fnd_global.login_id,
1040: era.last_updated_by = fnd_global.user_id
1041: where era.wf_item_key = itemkey
1042: and era.wf_role_name = l_rname
1043: and not exists
1044: ( select erd.effort_report_detail_id

Line 1063: last_update_login = fnd_global.login_id,

1059: end if;
1060: update psp_eff_reports
1061: set status_code = 'R',
1062: last_update_date = sysdate,
1063: last_update_login = fnd_global.login_id,
1064: last_updated_by = fnd_global.user_id
1065: where effort_report_id = l_effort_report_id;
1066: hr_utility.trace('er_workflow -->19 ');
1067: end loop;

Line 1064: last_updated_by = fnd_global.user_id

1060: update psp_eff_reports
1061: set status_code = 'R',
1062: last_update_date = sysdate,
1063: last_update_login = fnd_global.login_id,
1064: last_updated_by = fnd_global.user_id
1065: where effort_report_id = l_effort_report_id;
1066: hr_utility.trace('er_workflow -->19 ');
1067: end loop;
1068:

Line 1171: era.last_update_login = fnd_global.login_id,

1167: update psp_eff_report_approvals era
1168: set era.approval_status = 'S',
1169: era.response_date = SYSDATE,
1170: era.last_update_date = sysdate,
1171: era.last_update_login = fnd_global.login_id,
1172: era.last_updated_by = fnd_global.user_id
1173: where era.wf_item_key = itemkey
1174: and era.wf_role_name = l_rname
1175: and era.wf_orig_system_id = l_orig_system_id

Line 1172: era.last_updated_by = fnd_global.user_id

1168: set era.approval_status = 'S',
1169: era.response_date = SYSDATE,
1170: era.last_update_date = sysdate,
1171: era.last_update_login = fnd_global.login_id,
1172: era.last_updated_by = fnd_global.user_id
1173: where era.wf_item_key = itemkey
1174: and era.wf_role_name = l_rname
1175: and era.wf_orig_system_id = l_orig_system_id
1176: and era.wf_orig_system = l_orig_system

Line 1191: era.last_update_login = fnd_global.login_id,

1187: update psp_eff_report_approvals era
1188: set era.approval_status = 'A',
1189: era.response_date = SYSDATE,
1190: era.last_update_date = sysdate,
1191: era.last_update_login = fnd_global.login_id,
1192: era.last_updated_by = fnd_global.user_id
1193: where era.wf_item_key = itemkey
1194: and era.wf_role_name = l_rname
1195: and era.wf_orig_system_id = l_orig_system_id

Line 1192: era.last_updated_by = fnd_global.user_id

1188: set era.approval_status = 'A',
1189: era.response_date = SYSDATE,
1190: era.last_update_date = sysdate,
1191: era.last_update_login = fnd_global.login_id,
1192: era.last_updated_by = fnd_global.user_id
1193: where era.wf_item_key = itemkey
1194: and era.wf_role_name = l_rname
1195: and era.wf_orig_system_id = l_orig_system_id
1196: and era.wf_orig_system = l_orig_system

Line 1759: l_user_name := fnd_global.user_name;

1755: FROM psp_selected_persons_t
1756: WHERE request_id = p_request_id;
1757: begin
1758:
1759: l_user_name := fnd_global.user_name;
1760: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
1761: l_retry_request_id := fnd_global.conc_request_id;
1762:
1763: OPEN get_sob_cur;

Line 1761: l_retry_request_id := fnd_global.conc_request_id;

1757: begin
1758:
1759: l_user_name := fnd_global.user_name;
1760: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
1761: l_retry_request_id := fnd_global.conc_request_id;
1762:
1763: OPEN get_sob_cur;
1764: FETCH get_sob_cur INTO l_gl_sob;
1765: CLOSE get_sob_cur;