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.

[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on WF_ROLES

Line 3021: l_role_name wf_roles.name%type;

3017: l_top_msg_txt varchar2(2000);
3018: l_mbr_msg_hdr varchar2(2000);
3019: l_mbr_msg_txt varchar2(2000);
3020:
3021: l_role_name wf_roles.name%type;
3022: l_role_displayname wf_roles.display_name%type;
3023: l_admin_role_name wf_roles.name%type;
3024: l_admin_role_displayname wf_roles.display_name%type;
3025: --

Line 3022: l_role_displayname wf_roles.display_name%type;

3018: l_mbr_msg_hdr varchar2(2000);
3019: l_mbr_msg_txt varchar2(2000);
3020:
3021: l_role_name wf_roles.name%type;
3022: l_role_displayname wf_roles.display_name%type;
3023: l_admin_role_name wf_roles.name%type;
3024: l_admin_role_displayname wf_roles.display_name%type;
3025: --
3026: begin

Line 3023: l_admin_role_name wf_roles.name%type;

3019: l_mbr_msg_txt varchar2(2000);
3020:
3021: l_role_name wf_roles.name%type;
3022: l_role_displayname wf_roles.display_name%type;
3023: l_admin_role_name wf_roles.name%type;
3024: l_admin_role_displayname wf_roles.display_name%type;
3025: --
3026: begin
3027: --

Line 3024: l_admin_role_displayname wf_roles.display_name%type;

3020:
3021: l_role_name wf_roles.name%type;
3022: l_role_displayname wf_roles.display_name%type;
3023: l_admin_role_name wf_roles.name%type;
3024: l_admin_role_displayname wf_roles.display_name%type;
3025: --
3026: begin
3027: --
3028: IF g_dbg THEN op('Entering:'|| l_proc, g_REGULAR_LOG, 10); END IF;

Line 3259: l_role_name wf_roles.name%type;

3255: resultout out nocopy varchar2)
3256: is
3257: --
3258: l_plan_id number;
3259: l_role_name wf_roles.name%type;
3260: l_role_displayname wf_roles.display_name%type;
3261: --
3262: begin
3263: --

Line 3260: l_role_displayname wf_roles.display_name%type;

3256: is
3257: --
3258: l_plan_id number;
3259: l_role_name wf_roles.name%type;
3260: l_role_displayname wf_roles.display_name%type;
3261: --
3262: begin
3263: --
3264: IF (funcmode = 'RUN') then

Line 3335: l_role_name wf_roles.name%type;

3331: --
3332: l_plan_id number;
3333: l_plan_hierarchy varchar2(30);
3334: l_top_id number;
3335: l_role_name wf_roles.name%type;
3336: l_role_displayname wf_roles.display_name%type;
3337: --
3338: begin
3339: --

Line 3336: l_role_displayname wf_roles.display_name%type;

3332: l_plan_id number;
3333: l_plan_hierarchy varchar2(30);
3334: l_top_id number;
3335: l_role_name wf_roles.name%type;
3336: l_role_displayname wf_roles.display_name%type;
3337: --
3338: begin
3339: --
3340: IF (funcmode = 'RUN') then

Line 3450: l_role_name wf_roles.name%type;

3446: --
3447: l_plan_id number;
3448: l_plan_hierarchy varchar2(30);
3449: l_top_id number;
3450: l_role_name wf_roles.name%type;
3451: l_role_displayname wf_roles.display_name%type;
3452: --
3453: begin
3454: --

Line 3451: l_role_displayname wf_roles.display_name%type;

3447: l_plan_id number;
3448: l_plan_hierarchy varchar2(30);
3449: l_top_id number;
3450: l_role_name wf_roles.name%type;
3451: l_role_displayname wf_roles.display_name%type;
3452: --
3453: begin
3454: --
3455: IF (funcmode = 'RUN') then

Line 4587: l_role_name wf_roles.name%type;

4583: ,funcmode in varchar2
4584: ,resultout out nocopy varchar2
4585: ) is
4586: prole wf_users.name%type; -- Fix 3210283.
4587: l_role_name wf_roles.name%type;
4588: expand_role varchar2(1);
4589: l_msg varchar2(30);
4590: -- Start changes for bug#5903006
4591: l_obj_setting_flag VARCHAR2(30);

Line 4647: l_role_name wf_roles.name%type;

4643: ,funcmode in varchar2
4644: ,resultout out nocopy varchar2
4645: ) is
4646: prole wf_users.name%type;
4647: l_role_name wf_roles.name%type;
4648: l_role_displayname wf_roles.display_name%type;
4649: expand_role varchar2(1);
4650: l_msg varchar2(30);
4651: l_plan_id number;

Line 4648: l_role_displayname wf_roles.display_name%type;

4644: ,resultout out nocopy varchar2
4645: ) is
4646: prole wf_users.name%type;
4647: l_role_name wf_roles.name%type;
4648: l_role_displayname wf_roles.display_name%type;
4649: expand_role varchar2(1);
4650: l_msg varchar2(30);
4651: l_plan_id number;
4652: cursor csr_get_admin

Line 4725: l_to_role_name wf_roles.name%type;

4721: ,p_request_id in number
4722: )
4723: IS
4724:
4725: l_to_role_name wf_roles.name%type;
4726: l_to_role_displayname wf_roles.display_name%type;
4727: l_from_role_name wf_roles.name%type;
4728: l_from_role_displayname wf_roles.display_name%type;
4729: expand_role varchar2(1);

Line 4726: l_to_role_displayname wf_roles.display_name%type;

4722: )
4723: IS
4724:
4725: l_to_role_name wf_roles.name%type;
4726: l_to_role_displayname wf_roles.display_name%type;
4727: l_from_role_name wf_roles.name%type;
4728: l_from_role_displayname wf_roles.display_name%type;
4729: expand_role varchar2(1);
4730: l_msg varchar2(30);

Line 4727: l_from_role_name wf_roles.name%type;

4723: IS
4724:
4725: l_to_role_name wf_roles.name%type;
4726: l_to_role_displayname wf_roles.display_name%type;
4727: l_from_role_name wf_roles.name%type;
4728: l_from_role_displayname wf_roles.display_name%type;
4729: expand_role varchar2(1);
4730: l_msg varchar2(30);
4731: l_notification_id number;

Line 4728: l_from_role_displayname wf_roles.display_name%type;

4724:
4725: l_to_role_name wf_roles.name%type;
4726: l_to_role_displayname wf_roles.display_name%type;
4727: l_from_role_name wf_roles.name%type;
4728: l_from_role_displayname wf_roles.display_name%type;
4729: expand_role varchar2(1);
4730: l_msg varchar2(30);
4731: l_notification_id number;
4732: FROM_ROLE_NOT_EXISTS exception;

Line 6530: from wf_roles wf

6526:
6527: cursor get_role(person_id per_all_people_f.person_id%TYPE)
6528: is
6529: select wf.name role_name
6530: from wf_roles wf
6531: where wf.orig_system = 'PER'
6532: and wf.orig_system_id = person_id;
6533:
6534: cursor csr_plan_det(p_plan_id per_perf_mgmt_plans.plan_id%type)