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 629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

625:
626: begin
627:
628: /*Changes for the bug 10185794 */
629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
630: select apps.fnd_global.resp_id into l_resp_id from dual;
631: select apps.fnd_global.user_id into l_user from dual;
632:
633: if l_resp_id = -1

Line 630: select apps.fnd_global.resp_id into l_resp_id from dual;

626: begin
627:
628: /*Changes for the bug 10185794 */
629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
630: select apps.fnd_global.resp_id into l_resp_id from dual;
631: select apps.fnd_global.user_id into l_user from dual;
632:
633: if l_resp_id = -1
634: then

Line 631: select apps.fnd_global.user_id into l_user from dual;

627:
628: /*Changes for the bug 10185794 */
629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
630: select apps.fnd_global.resp_id into l_resp_id from dual;
631: select apps.fnd_global.user_id into l_user from dual;
632:
633: if l_resp_id = -1
634: then
635: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 642: l_user_id := fnd_global.user_id;

638:
639: l_same_approval_level := 'N';
640: ---hr_utility.trace_on('Y','WF-1');
641:
642: l_user_id := fnd_global.user_id;
643: l_login_id := fnd_global.login_id;
644: if funcmode = 'RUN' then
645: l_approver_order_num :=
646: wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 643: l_login_id := fnd_global.login_id;

639: l_same_approval_level := 'N';
640: ---hr_utility.trace_on('Y','WF-1');
641:
642: l_user_id := fnd_global.user_id;
643: l_login_id := fnd_global.login_id;
644: if funcmode = 'RUN' then
645: l_approver_order_num :=
646: wf_engine.GetItemAttrNumber(itemtype => itemtype,
647: itemkey => itemkey,

Line 669: er.last_update_login = fnd_global.login_id,

665: elsif l_approval_type in ('PMG', 'TMG', 'GPI') then
666: update psp_eff_reports er
667: set er.status_code = 'A',
668: er.last_update_date = sysdate,
669: er.last_update_login = fnd_global.login_id,
670: er.last_updated_by = fnd_global.user_id
671: where er.status_code = 'N'
672: and er.effort_report_id in
673: (select erd.effort_report_id

Line 670: er.last_updated_by = fnd_global.user_id

666: update psp_eff_reports er
667: set er.status_code = 'A',
668: er.last_update_date = sysdate,
669: er.last_update_login = fnd_global.login_id,
670: er.last_updated_by = fnd_global.user_id
671: where er.status_code = 'N'
672: and er.effort_report_id in
673: (select erd.effort_report_id
674: from psp_eff_report_details erd,

Line 808: er.last_update_login = fnd_global.login_id,

804: if l_temp_not_found = 'Y' then
805: update psp_eff_reports er
806: set er.status_code = 'A',
807: er.last_update_date = sysdate,
808: er.last_update_login = fnd_global.login_id,
809: er.last_updated_by = fnd_global.user_id
810: where er.status_code = 'N'
811: and er.effort_report_id in
812: (select erd.effort_report_id

Line 809: er.last_updated_by = fnd_global.user_id

805: update psp_eff_reports er
806: set er.status_code = 'A',
807: er.last_update_date = sysdate,
808: er.last_update_login = fnd_global.login_id,
809: er.last_updated_by = fnd_global.user_id
810: where er.status_code = 'N'
811: and er.effort_report_id in
812: (select erd.effort_report_id
813: from psp_eff_report_details erd,

Line 1038: era.last_update_login = fnd_global.login_id,

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

Line 1039: era.last_updated_by = fnd_global.user_id

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

Line 1055: era.last_update_login = fnd_global.login_id,

1051: update psp_eff_report_approvals era
1052: set era.approval_status = 'R',
1053: era.response_date = sysdate,
1054: era.last_update_date = sysdate,
1055: era.last_update_login = fnd_global.login_id,
1056: era.last_updated_by = fnd_global.user_id
1057: where era.wf_item_key = itemkey
1058: and era.wf_role_name = l_rname
1059: and not exists

Line 1056: era.last_updated_by = fnd_global.user_id

1052: set era.approval_status = 'R',
1053: era.response_date = sysdate,
1054: era.last_update_date = sysdate,
1055: era.last_update_login = fnd_global.login_id,
1056: era.last_updated_by = fnd_global.user_id
1057: where era.wf_item_key = itemkey
1058: and era.wf_role_name = l_rname
1059: and not exists
1060: ( select erd.effort_report_detail_id

Line 1079: last_update_login = fnd_global.login_id,

1075: end if;
1076: update psp_eff_reports
1077: set status_code = 'R',
1078: last_update_date = sysdate,
1079: last_update_login = fnd_global.login_id,
1080: last_updated_by = fnd_global.user_id
1081: where effort_report_id = l_effort_report_id;
1082: hr_utility.trace('er_workflow -->19 ');
1083: end loop;

Line 1080: last_updated_by = fnd_global.user_id

1076: update psp_eff_reports
1077: set status_code = 'R',
1078: last_update_date = sysdate,
1079: last_update_login = fnd_global.login_id,
1080: last_updated_by = fnd_global.user_id
1081: where effort_report_id = l_effort_report_id;
1082: hr_utility.trace('er_workflow -->19 ');
1083: end loop;
1084:

Line 1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

1171:
1172: begin
1173:
1174: /*Changes for the bug 10185794 */
1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
1176: select apps.fnd_global.resp_id into l_resp_id from dual;
1177: select apps.fnd_global.user_id into l_user from dual;
1178:
1179: if l_resp_id = -1

Line 1176: select apps.fnd_global.resp_id into l_resp_id from dual;

1172: begin
1173:
1174: /*Changes for the bug 10185794 */
1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
1176: select apps.fnd_global.resp_id into l_resp_id from dual;
1177: select apps.fnd_global.user_id into l_user from dual;
1178:
1179: if l_resp_id = -1
1180: then

Line 1177: select apps.fnd_global.user_id into l_user from dual;

1173:
1174: /*Changes for the bug 10185794 */
1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
1176: select apps.fnd_global.resp_id into l_resp_id from dual;
1177: select apps.fnd_global.user_id into l_user from dual;
1178:
1179: if l_resp_id = -1
1180: then
1181: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 1203: era.last_update_login = fnd_global.login_id,

1199: update psp_eff_report_approvals era
1200: set era.approval_status = 'S',
1201: era.response_date = SYSDATE,
1202: era.last_update_date = sysdate,
1203: era.last_update_login = fnd_global.login_id,
1204: era.last_updated_by = fnd_global.user_id
1205: where era.wf_item_key = itemkey
1206: and era.wf_role_name = l_rname
1207: and era.wf_orig_system_id = l_orig_system_id

Line 1204: era.last_updated_by = fnd_global.user_id

1200: set era.approval_status = 'S',
1201: era.response_date = SYSDATE,
1202: era.last_update_date = sysdate,
1203: era.last_update_login = fnd_global.login_id,
1204: era.last_updated_by = fnd_global.user_id
1205: where era.wf_item_key = itemkey
1206: and era.wf_role_name = l_rname
1207: and era.wf_orig_system_id = l_orig_system_id
1208: and era.wf_orig_system = l_orig_system

Line 1223: era.last_update_login = fnd_global.login_id,

1219: update psp_eff_report_approvals era
1220: set era.approval_status = 'A',
1221: era.response_date = SYSDATE,
1222: era.last_update_date = sysdate,
1223: era.last_update_login = fnd_global.login_id,
1224: era.last_updated_by = fnd_global.user_id
1225: where era.wf_item_key = itemkey
1226: and era.wf_role_name = l_rname
1227: and era.wf_orig_system_id = l_orig_system_id

Line 1224: era.last_updated_by = fnd_global.user_id

1220: set era.approval_status = 'A',
1221: era.response_date = SYSDATE,
1222: era.last_update_date = sysdate,
1223: era.last_update_login = fnd_global.login_id,
1224: era.last_updated_by = fnd_global.user_id
1225: where era.wf_item_key = itemkey
1226: and era.wf_role_name = l_rname
1227: and era.wf_orig_system_id = l_orig_system_id
1228: and era.wf_orig_system = l_orig_system

Line 1799: l_user_name := fnd_global.user_name;

1795: FROM psp_selected_persons_t
1796: WHERE request_id = p_request_id;
1797: begin
1798:
1799: l_user_name := fnd_global.user_name;
1800: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
1801: l_retry_request_id := fnd_global.conc_request_id;
1802:
1803: OPEN get_sob_cur;

Line 1801: l_retry_request_id := fnd_global.conc_request_id;

1797: begin
1798:
1799: l_user_name := fnd_global.user_name;
1800: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
1801: l_retry_request_id := fnd_global.conc_request_id;
1802:
1803: OPEN get_sob_cur;
1804: FETCH get_sob_cur INTO l_gl_sob;
1805: CLOSE get_sob_cur;

Line 2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

2151:
2152: begin
2153:
2154: /*Changes for the bug 10185794 */
2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2156: select apps.fnd_global.resp_id into l_resp_id from dual;
2157: select apps.fnd_global.user_id into l_user from dual;
2158:
2159: if l_resp_id = -1

Line 2156: select apps.fnd_global.resp_id into l_resp_id from dual;

2152: begin
2153:
2154: /*Changes for the bug 10185794 */
2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2156: select apps.fnd_global.resp_id into l_resp_id from dual;
2157: select apps.fnd_global.user_id into l_user from dual;
2158:
2159: if l_resp_id = -1
2160: then

Line 2157: select apps.fnd_global.user_id into l_user from dual;

2153:
2154: /*Changes for the bug 10185794 */
2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2156: select apps.fnd_global.resp_id into l_resp_id from dual;
2157: select apps.fnd_global.user_id into l_user from dual;
2158:
2159: if l_resp_id = -1
2160: then
2161: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

2223:
2224: begin
2225:
2226: /*Changes for the bug 10185794 */
2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2228: select apps.fnd_global.resp_id into l_resp_id from dual;
2229: select apps.fnd_global.user_id into l_user from dual;
2230:
2231: if l_resp_id = -1

Line 2228: select apps.fnd_global.resp_id into l_resp_id from dual;

2224: begin
2225:
2226: /*Changes for the bug 10185794 */
2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2228: select apps.fnd_global.resp_id into l_resp_id from dual;
2229: select apps.fnd_global.user_id into l_user from dual;
2230:
2231: if l_resp_id = -1
2232: then

Line 2229: select apps.fnd_global.user_id into l_user from dual;

2225:
2226: /*Changes for the bug 10185794 */
2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2228: select apps.fnd_global.resp_id into l_resp_id from dual;
2229: select apps.fnd_global.user_id into l_user from dual;
2230:
2231: if l_resp_id = -1
2232: then
2233: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

2405:
2406: begin
2407:
2408: /*Changes for the bug 10185794 */
2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2410: select apps.fnd_global.resp_id into l_resp_id from dual;
2411: select apps.fnd_global.user_id into l_user from dual;
2412:
2413: if l_resp_id = -1

Line 2410: select apps.fnd_global.resp_id into l_resp_id from dual;

2406: begin
2407:
2408: /*Changes for the bug 10185794 */
2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2410: select apps.fnd_global.resp_id into l_resp_id from dual;
2411: select apps.fnd_global.user_id into l_user from dual;
2412:
2413: if l_resp_id = -1
2414: then

Line 2411: select apps.fnd_global.user_id into l_user from dual;

2407:
2408: /*Changes for the bug 10185794 */
2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2410: select apps.fnd_global.resp_id into l_resp_id from dual;
2411: select apps.fnd_global.user_id into l_user from dual;
2412:
2413: if l_resp_id = -1
2414: then
2415: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');