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 891: l_rname wf_roles.name%type;

887: itemkey in varchar2,
888: actid in number,
889: funcmode in varchar2,
890: result out nocopy varchar2) is
891: l_rname wf_roles.name%type;
892: l_request_id integer;
893: l_effort_report_id integer;
894: l_initiator_rname wf_roles.name%type;
895: l_orig_system_id wf_roles.orig_system_id%type;

Line 894: l_initiator_rname wf_roles.name%type;

890: result out nocopy varchar2) is
891: l_rname wf_roles.name%type;
892: l_request_id integer;
893: l_effort_report_id integer;
894: l_initiator_rname wf_roles.name%type;
895: l_orig_system_id wf_roles.orig_system_id%type;
896: l_orig_system wf_roles.orig_system%type;
897: l_txn_id varchar2(50);
898: approver_rec ame_util.approverRecord2;

Line 895: l_orig_system_id wf_roles.orig_system_id%type;

891: l_rname wf_roles.name%type;
892: l_request_id integer;
893: l_effort_report_id integer;
894: l_initiator_rname wf_roles.name%type;
895: l_orig_system_id wf_roles.orig_system_id%type;
896: l_orig_system wf_roles.orig_system%type;
897: l_txn_id varchar2(50);
898: approver_rec ame_util.approverRecord2;
899: l_recipnt_role varchar2(300);

Line 896: l_orig_system wf_roles.orig_system%type;

892: l_request_id integer;
893: l_effort_report_id integer;
894: l_initiator_rname wf_roles.name%type;
895: l_orig_system_id wf_roles.orig_system_id%type;
896: l_orig_system wf_roles.orig_system%type;
897: l_txn_id varchar2(50);
898: approver_rec ame_util.approverRecord2;
899: l_recipnt_role varchar2(300);
900:

Line 940: from wf_roles

936: and era.wf_role_name = fu.user_name -- Bug 6641216
937: and trunc(sysdate) between trunc(fu.start_date) and nvl(trunc(fu.end_date),trunc(sysdate)) -- Bug 6641216
938: union
939: select name
940: from wf_roles
941: where orig_system = 'PER'
942: and orig_system_id in
943: (select initiator_person_id
944: from psp_report_templates_h

Line 991: from wf_roles

987: select orig_system_id,
988: orig_system
989: into l_orig_system_id,
990: l_orig_system
991: from wf_roles
992: where name = l_rname;
993:
994: approver_rec.name := l_rname;
995: approver_rec.orig_system := l_orig_system;

Line 1125: l_rname wf_roles.name%type;

1121: actid in number,
1122: funcmode in varchar2,
1123: result out nocopy varchar2) is
1124:
1125: l_rname wf_roles.name%type;
1126: l_orig_system_id wf_roles.orig_system_id%type;
1127: l_orig_system wf_roles.orig_system%type;
1128: l_txn_id varchar2(50);
1129: approver_rec ame_util.approverRecord2;

Line 1126: l_orig_system_id wf_roles.orig_system_id%type;

1122: funcmode in varchar2,
1123: result out nocopy varchar2) is
1124:
1125: l_rname wf_roles.name%type;
1126: l_orig_system_id wf_roles.orig_system_id%type;
1127: l_orig_system wf_roles.orig_system%type;
1128: l_txn_id varchar2(50);
1129: approver_rec ame_util.approverRecord2;
1130: l_return_status CHAR(1);

Line 1127: l_orig_system wf_roles.orig_system%type;

1123: result out nocopy varchar2) is
1124:
1125: l_rname wf_roles.name%type;
1126: l_orig_system_id wf_roles.orig_system_id%type;
1127: l_orig_system wf_roles.orig_system%type;
1128: l_txn_id varchar2(50);
1129: approver_rec ame_util.approverRecord2;
1130: l_return_status CHAR(1);
1131:

Line 1250: l_rname wf_roles.name%type;

1246: actid in number,
1247: funcmode in varchar2,
1248: result out nocopy varchar2) is
1249:
1250: l_rname wf_roles.name%type;
1251: l_orig_system_id wf_roles.orig_system_id%type;
1252: l_orig_system wf_roles.orig_system%type;
1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;

Line 1251: l_orig_system_id wf_roles.orig_system_id%type;

1247: funcmode in varchar2,
1248: result out nocopy varchar2) is
1249:
1250: l_rname wf_roles.name%type;
1251: l_orig_system_id wf_roles.orig_system_id%type;
1252: l_orig_system wf_roles.orig_system%type;
1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;

Line 1252: l_orig_system wf_roles.orig_system%type;

1248: result out nocopy varchar2) is
1249:
1250: l_rname wf_roles.name%type;
1251: l_orig_system_id wf_roles.orig_system_id%type;
1252: l_orig_system wf_roles.orig_system%type;
1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;
1256: l_txn_id varchar2(50);

Line 1253: l_rname2 wf_roles.name%type;

1249:
1250: l_rname wf_roles.name%type;
1251: l_orig_system_id wf_roles.orig_system_id%type;
1252: l_orig_system wf_roles.orig_system%type;
1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;
1256: l_txn_id varchar2(50);
1257: approver_rec ame_util.approverRecord2;

Line 1254: l_orig_system_id2 wf_roles.orig_system_id%type;

1250: l_rname wf_roles.name%type;
1251: l_orig_system_id wf_roles.orig_system_id%type;
1252: l_orig_system wf_roles.orig_system%type;
1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;
1256: l_txn_id varchar2(50);
1257: approver_rec ame_util.approverRecord2;
1258: forward_rec ame_util.approverRecord2;

Line 1255: l_orig_system2 wf_roles.orig_system%type;

1251: l_orig_system_id wf_roles.orig_system_id%type;
1252: l_orig_system wf_roles.orig_system%type;
1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;
1256: l_txn_id varchar2(50);
1257: approver_rec ame_util.approverRecord2;
1258: forward_rec ame_util.approverRecord2;
1259: l_return_status CHAR(1);

Line 1284: from wf_roles

1280: cursor get_forwarde_details is
1281: select orig_system,
1282: orig_system_id,
1283: display_name
1284: from wf_roles
1285: where name = l_rname2;
1286: l_role_display_name2 wf_roles.display_name%type;
1287: l_nid number;
1288:

Line 1286: l_role_display_name2 wf_roles.display_name%type;

1282: orig_system_id,
1283: display_name
1284: from wf_roles
1285: where name = l_rname2;
1286: l_role_display_name2 wf_roles.display_name%type;
1287: l_nid number;
1288:
1289: /* Added for hundred percent validation for overridden effort */
1290: l_result varchar2(240);

Line 1973: l_recipnt_role wf_roles.name%type;

1969: actid in number,
1970: funcmode in varchar2,
1971: result out nocopy varchar2) is
1972:
1973: l_recipnt_role wf_roles.name%type;
1974: l_request_id integer;
1975: l_member_rname wf_roles.name%type;
1976:
1977: cursor get_member_role is

Line 1975: l_member_rname wf_roles.name%type;

1971: result out nocopy varchar2) is
1972:
1973: l_recipnt_role wf_roles.name%type;
1974: l_request_id integer;
1975: l_member_rname wf_roles.name%type;
1976:
1977: cursor get_member_role is
1978: select distinct wf.name
1979: from wf_roles wf,

Line 1979: from wf_roles wf,

1975: l_member_rname wf_roles.name%type;
1976:
1977: cursor get_member_role is
1978: select distinct wf.name
1979: from wf_roles wf,
1980: psp_report_template_details_h temp
1981: where temp.request_id = l_request_id
1982: and wf.orig_system = 'PER'
1983: and to_char(wf.orig_system_id) = temp.criteria_value1

Line 2247: l_initiator_rname wf_roles.name%type;

2243: actid IN number,
2244: funcmode IN varchar2,
2245: result OUT nocopy varchar2) IS
2246:
2247: l_initiator_rname wf_roles.name%type;
2248:
2249: BEGIN
2250: l_initiator_rname :=
2251: wf_engine.GetItemAttrText(itemtype => itemtype,