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 WF_ROLES

Line 237: l_initiator_rname wf_roles.name%type;

233: type t_varchar2 is table of varchar2(320) index by binary_integer;
234: wf_rname_array t_varchar2;
235: wf_ikey_array t_integer;
236: k integer;
237: l_initiator_rname wf_roles.name%type;
238: l_request_id integer;
239: l_start_date varchar2(50);
240: l_end_date varchar2(50);
241: l_template_name varchar2(200);

Line 907: l_rname wf_roles.name%type;

903: itemkey in varchar2,
904: actid in number,
905: funcmode in varchar2,
906: result out nocopy varchar2) is
907: l_rname wf_roles.name%type;
908: l_request_id integer;
909: l_effort_report_id integer;
910: l_initiator_rname wf_roles.name%type;
911: l_orig_system_id wf_roles.orig_system_id%type;

Line 910: l_initiator_rname wf_roles.name%type;

906: result out nocopy varchar2) is
907: l_rname wf_roles.name%type;
908: l_request_id integer;
909: l_effort_report_id integer;
910: l_initiator_rname wf_roles.name%type;
911: l_orig_system_id wf_roles.orig_system_id%type;
912: l_orig_system wf_roles.orig_system%type;
913: l_txn_id varchar2(50);
914: approver_rec ame_util.approverRecord2;

Line 911: l_orig_system_id wf_roles.orig_system_id%type;

907: l_rname wf_roles.name%type;
908: l_request_id integer;
909: l_effort_report_id integer;
910: l_initiator_rname wf_roles.name%type;
911: l_orig_system_id wf_roles.orig_system_id%type;
912: l_orig_system wf_roles.orig_system%type;
913: l_txn_id varchar2(50);
914: approver_rec ame_util.approverRecord2;
915: l_recipnt_role varchar2(300);

Line 912: l_orig_system wf_roles.orig_system%type;

908: l_request_id integer;
909: l_effort_report_id integer;
910: l_initiator_rname wf_roles.name%type;
911: l_orig_system_id wf_roles.orig_system_id%type;
912: l_orig_system wf_roles.orig_system%type;
913: l_txn_id varchar2(50);
914: approver_rec ame_util.approverRecord2;
915: l_recipnt_role varchar2(300);
916:

Line 956: from wf_roles

952: and era.wf_role_name = fu.user_name -- Bug 6641216
953: and trunc(sysdate) between trunc(fu.start_date) and nvl(trunc(fu.end_date),trunc(sysdate)) -- Bug 6641216
954: union
955: select name
956: from wf_roles
957: where orig_system = 'PER'
958: and orig_system_id in
959: (select initiator_person_id
960: from psp_report_templates_h

Line 1007: from wf_roles

1003: select orig_system_id,
1004: orig_system
1005: into l_orig_system_id,
1006: l_orig_system
1007: from wf_roles
1008: where name = l_rname;
1009:
1010: approver_rec.name := l_rname;
1011: approver_rec.orig_system := l_orig_system;

Line 1141: l_rname wf_roles.name%type;

1137: actid in number,
1138: funcmode in varchar2,
1139: result out nocopy varchar2) is
1140:
1141: l_rname wf_roles.name%type;
1142: l_orig_system_id wf_roles.orig_system_id%type;
1143: l_orig_system wf_roles.orig_system%type;
1144: l_txn_id varchar2(50);
1145: approver_rec ame_util.approverRecord2;

Line 1142: l_orig_system_id wf_roles.orig_system_id%type;

1138: funcmode in varchar2,
1139: result out nocopy varchar2) is
1140:
1141: l_rname wf_roles.name%type;
1142: l_orig_system_id wf_roles.orig_system_id%type;
1143: l_orig_system wf_roles.orig_system%type;
1144: l_txn_id varchar2(50);
1145: approver_rec ame_util.approverRecord2;
1146: l_return_status CHAR(1);

Line 1143: l_orig_system wf_roles.orig_system%type;

1139: result out nocopy varchar2) is
1140:
1141: l_rname wf_roles.name%type;
1142: l_orig_system_id wf_roles.orig_system_id%type;
1143: l_orig_system wf_roles.orig_system%type;
1144: l_txn_id varchar2(50);
1145: approver_rec ame_util.approverRecord2;
1146: l_return_status CHAR(1);
1147:

Line 1282: l_rname wf_roles.name%type;

1278: actid in number,
1279: funcmode in varchar2,
1280: result out nocopy varchar2) is
1281:
1282: l_rname wf_roles.name%type;
1283: l_orig_system_id wf_roles.orig_system_id%type;
1284: l_orig_system wf_roles.orig_system%type;
1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;

Line 1283: l_orig_system_id wf_roles.orig_system_id%type;

1279: funcmode in varchar2,
1280: result out nocopy varchar2) is
1281:
1282: l_rname wf_roles.name%type;
1283: l_orig_system_id wf_roles.orig_system_id%type;
1284: l_orig_system wf_roles.orig_system%type;
1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;

Line 1284: l_orig_system wf_roles.orig_system%type;

1280: result out nocopy varchar2) is
1281:
1282: l_rname wf_roles.name%type;
1283: l_orig_system_id wf_roles.orig_system_id%type;
1284: l_orig_system wf_roles.orig_system%type;
1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;
1288: l_txn_id varchar2(50);

Line 1285: l_rname2 wf_roles.name%type;

1281:
1282: l_rname wf_roles.name%type;
1283: l_orig_system_id wf_roles.orig_system_id%type;
1284: l_orig_system wf_roles.orig_system%type;
1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;
1288: l_txn_id varchar2(50);
1289: approver_rec ame_util.approverRecord2;

Line 1286: l_orig_system_id2 wf_roles.orig_system_id%type;

1282: l_rname wf_roles.name%type;
1283: l_orig_system_id wf_roles.orig_system_id%type;
1284: l_orig_system wf_roles.orig_system%type;
1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;
1288: l_txn_id varchar2(50);
1289: approver_rec ame_util.approverRecord2;
1290: forward_rec ame_util.approverRecord2;

Line 1287: l_orig_system2 wf_roles.orig_system%type;

1283: l_orig_system_id wf_roles.orig_system_id%type;
1284: l_orig_system wf_roles.orig_system%type;
1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;
1288: l_txn_id varchar2(50);
1289: approver_rec ame_util.approverRecord2;
1290: forward_rec ame_util.approverRecord2;
1291: l_return_status CHAR(1);

Line 1316: from wf_roles

1312: cursor get_forwarde_details is
1313: select orig_system,
1314: orig_system_id,
1315: display_name
1316: from wf_roles
1317: where name = l_rname2;
1318: l_role_display_name2 wf_roles.display_name%type;
1319: l_nid number;
1320:

Line 1318: l_role_display_name2 wf_roles.display_name%type;

1314: orig_system_id,
1315: display_name
1316: from wf_roles
1317: where name = l_rname2;
1318: l_role_display_name2 wf_roles.display_name%type;
1319: l_nid number;
1320:
1321: /* Added for hundred percent validation for overridden effort */
1322: l_result varchar2(240);

Line 2013: l_recipnt_role wf_roles.name%type;

2009: actid in number,
2010: funcmode in varchar2,
2011: result out nocopy varchar2) is
2012:
2013: l_recipnt_role wf_roles.name%type;
2014: l_request_id integer;
2015: l_member_rname wf_roles.name%type;
2016:
2017: cursor get_member_role is

Line 2015: l_member_rname wf_roles.name%type;

2011: result out nocopy varchar2) is
2012:
2013: l_recipnt_role wf_roles.name%type;
2014: l_request_id integer;
2015: l_member_rname wf_roles.name%type;
2016:
2017: cursor get_member_role is
2018: select distinct wf.name
2019: from wf_roles wf,

Line 2019: from wf_roles wf,

2015: l_member_rname wf_roles.name%type;
2016:
2017: cursor get_member_role is
2018: select distinct wf.name
2019: from wf_roles wf,
2020: psp_report_template_details_h temp
2021: where temp.request_id = l_request_id
2022: and wf.orig_system = 'PER'
2023: and to_char(wf.orig_system_id) = temp.criteria_value1

Line 2322: l_initiator_rname wf_roles.name%type;

2318: actid IN number,
2319: funcmode IN varchar2,
2320: result OUT nocopy varchar2) IS
2321:
2322: l_initiator_rname wf_roles.name%type;
2323:
2324: BEGIN
2325: l_initiator_rname :=
2326: wf_engine.GetItemAttrText(itemtype => itemtype,