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.HR_PERF_MGMT_PLAN_INTERNAL dependencies on WF_ROLES

Line 3956: l_role_name wf_roles.NAME%TYPE;

3952: l_top_msg_hdr VARCHAR2 (2000);
3953: l_top_msg_txt VARCHAR2 (2000);
3954: l_mbr_msg_hdr VARCHAR2 (2000);
3955: l_mbr_msg_txt VARCHAR2 (2000);
3956: l_role_name wf_roles.NAME%TYPE;
3957: l_role_displayname wf_roles.display_name%TYPE;
3958: l_admin_role_name wf_roles.NAME%TYPE;
3959: l_admin_role_displayname wf_roles.display_name%TYPE;
3960: l_wfthreshold NUMBER;

Line 3957: l_role_displayname wf_roles.display_name%TYPE;

3953: l_top_msg_txt VARCHAR2 (2000);
3954: l_mbr_msg_hdr VARCHAR2 (2000);
3955: l_mbr_msg_txt VARCHAR2 (2000);
3956: l_role_name wf_roles.NAME%TYPE;
3957: l_role_displayname wf_roles.display_name%TYPE;
3958: l_admin_role_name wf_roles.NAME%TYPE;
3959: l_admin_role_displayname wf_roles.display_name%TYPE;
3960: l_wfthreshold NUMBER;
3961: --

Line 3958: l_admin_role_name wf_roles.NAME%TYPE;

3954: l_mbr_msg_hdr VARCHAR2 (2000);
3955: l_mbr_msg_txt VARCHAR2 (2000);
3956: l_role_name wf_roles.NAME%TYPE;
3957: l_role_displayname wf_roles.display_name%TYPE;
3958: l_admin_role_name wf_roles.NAME%TYPE;
3959: l_admin_role_displayname wf_roles.display_name%TYPE;
3960: l_wfthreshold NUMBER;
3961: --
3962: BEGIN

Line 3959: l_admin_role_displayname wf_roles.display_name%TYPE;

3955: l_mbr_msg_txt VARCHAR2 (2000);
3956: l_role_name wf_roles.NAME%TYPE;
3957: l_role_displayname wf_roles.display_name%TYPE;
3958: l_admin_role_name wf_roles.NAME%TYPE;
3959: l_admin_role_displayname wf_roles.display_name%TYPE;
3960: l_wfthreshold NUMBER;
3961: --
3962: BEGIN
3963: --

Line 4231: l_role_name wf_roles.NAME%TYPE;

4227: )
4228: IS
4229: --
4230: l_plan_id NUMBER;
4231: l_role_name wf_roles.NAME%TYPE;
4232: l_role_displayname wf_roles.display_name%TYPE;
4233: --
4234: BEGIN
4235: --

Line 4232: l_role_displayname wf_roles.display_name%TYPE;

4228: IS
4229: --
4230: l_plan_id NUMBER;
4231: l_role_name wf_roles.NAME%TYPE;
4232: l_role_displayname wf_roles.display_name%TYPE;
4233: --
4234: BEGIN
4235: --
4236: IF (funcmode = 'RUN')

Line 4311: l_role_name wf_roles.NAME%TYPE;

4307: --
4308: l_plan_id NUMBER;
4309: l_plan_hierarchy VARCHAR2 (30);
4310: l_top_id NUMBER;
4311: l_role_name wf_roles.NAME%TYPE;
4312: l_role_displayname wf_roles.display_name%TYPE;
4313: --
4314: BEGIN
4315: --

Line 4312: l_role_displayname wf_roles.display_name%TYPE;

4308: l_plan_id NUMBER;
4309: l_plan_hierarchy VARCHAR2 (30);
4310: l_top_id NUMBER;
4311: l_role_name wf_roles.NAME%TYPE;
4312: l_role_displayname wf_roles.display_name%TYPE;
4313: --
4314: BEGIN
4315: --
4316: IF (funcmode = 'RUN')

Line 4420: l_role_name wf_roles.NAME%TYPE;

4416: --
4417: l_plan_id NUMBER;
4418: l_plan_hierarchy VARCHAR2 (30);
4419: l_top_id NUMBER;
4420: l_role_name wf_roles.NAME%TYPE;
4421: l_role_displayname wf_roles.display_name%TYPE;
4422: l_sc_exists VARCHAR2 (20);
4423:
4424: CURSOR csr_chk_sc_exists (p_assignment_id NUMBER, p_plan_id NUMBER)

Line 4421: l_role_displayname wf_roles.display_name%TYPE;

4417: l_plan_id NUMBER;
4418: l_plan_hierarchy VARCHAR2 (30);
4419: l_top_id NUMBER;
4420: l_role_name wf_roles.NAME%TYPE;
4421: l_role_displayname wf_roles.display_name%TYPE;
4422: l_sc_exists VARCHAR2 (20);
4423:
4424: CURSOR csr_chk_sc_exists (p_assignment_id NUMBER, p_plan_id NUMBER)
4425: IS

Line 6163: l_role_name wf_roles.NAME%TYPE;

6159: resultout OUT NOCOPY VARCHAR2
6160: )
6161: IS
6162: prole wf_users.NAME%TYPE; -- Fix 3210283.
6163: l_role_name wf_roles.NAME%TYPE;
6164: expand_role VARCHAR2 (1);
6165: l_msg VARCHAR2 (30);
6166: -- Start changes for bug#5903006
6167: l_obj_setting_flag VARCHAR2 (30);

Line 6230: l_role_name wf_roles.NAME%TYPE;

6226: resultout OUT NOCOPY VARCHAR2
6227: )
6228: IS
6229: prole wf_users.NAME%TYPE;
6230: l_role_name wf_roles.NAME%TYPE;
6231: l_role_displayname wf_roles.display_name%TYPE;
6232: expand_role VARCHAR2 (1);
6233: l_msg VARCHAR2 (30);
6234: l_plan_id NUMBER;

Line 6231: l_role_displayname wf_roles.display_name%TYPE;

6227: )
6228: IS
6229: prole wf_users.NAME%TYPE;
6230: l_role_name wf_roles.NAME%TYPE;
6231: l_role_displayname wf_roles.display_name%TYPE;
6232: expand_role VARCHAR2 (1);
6233: l_msg VARCHAR2 (30);
6234: l_plan_id NUMBER;
6235:

Line 6310: l_to_role_name wf_roles.NAME%TYPE;

6306: -- ----------------------------------------------------------------------------
6307: --
6308: PROCEDURE send_fyi_admin (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_status IN VARCHAR2, p_request_id IN NUMBER)
6309: IS
6310: l_to_role_name wf_roles.NAME%TYPE;
6311: l_to_role_displayname wf_roles.display_name%TYPE;
6312: l_from_role_name wf_roles.NAME%TYPE;
6313: l_from_role_displayname wf_roles.display_name%TYPE;
6314: expand_role VARCHAR2 (1);

Line 6311: l_to_role_displayname wf_roles.display_name%TYPE;

6307: --
6308: PROCEDURE send_fyi_admin (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_status IN VARCHAR2, p_request_id IN NUMBER)
6309: IS
6310: l_to_role_name wf_roles.NAME%TYPE;
6311: l_to_role_displayname wf_roles.display_name%TYPE;
6312: l_from_role_name wf_roles.NAME%TYPE;
6313: l_from_role_displayname wf_roles.display_name%TYPE;
6314: expand_role VARCHAR2 (1);
6315: l_msg VARCHAR2 (30);

Line 6312: l_from_role_name wf_roles.NAME%TYPE;

6308: PROCEDURE send_fyi_admin (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_status IN VARCHAR2, p_request_id IN NUMBER)
6309: IS
6310: l_to_role_name wf_roles.NAME%TYPE;
6311: l_to_role_displayname wf_roles.display_name%TYPE;
6312: l_from_role_name wf_roles.NAME%TYPE;
6313: l_from_role_displayname wf_roles.display_name%TYPE;
6314: expand_role VARCHAR2 (1);
6315: l_msg VARCHAR2 (30);
6316: l_notification_id NUMBER;

Line 6313: l_from_role_displayname wf_roles.display_name%TYPE;

6309: IS
6310: l_to_role_name wf_roles.NAME%TYPE;
6311: l_to_role_displayname wf_roles.display_name%TYPE;
6312: l_from_role_name wf_roles.NAME%TYPE;
6313: l_from_role_displayname wf_roles.display_name%TYPE;
6314: expand_role VARCHAR2 (1);
6315: l_msg VARCHAR2 (30);
6316: l_notification_id NUMBER;
6317: from_role_not_exists EXCEPTION;

Line 9371: FROM wf_roles wf

9367: IS
9368: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)
9369: IS
9370: SELECT wf.NAME role_name
9371: FROM wf_roles wf
9372: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;
9373:
9374: CURSOR csr_plan_det (p_plan_id per_perf_mgmt_plans.plan_id%TYPE)
9375: IS

Line 9547: l_role_name wf_roles.NAME%TYPE;

9543: rolename IN VARCHAR2
9544: )
9545: IS
9546: prole wf_users.NAME%TYPE; -- Fix 3210283.
9547: l_role_name wf_roles.NAME%TYPE;
9548: expand_role VARCHAR2 (1);
9549: l_msg VARCHAR2 (30);
9550: -- Start changes for bug#5903006
9551: l_obj_setting_flag VARCHAR2 (30);

Line 9610: l_role_name wf_roles.NAME%TYPE;

9606: resultout OUT NOCOPY VARCHAR2
9607: )
9608: IS
9609: l_plan_id NUMBER;
9610: l_role_name wf_roles.NAME%TYPE;
9611: l_role_displayname wf_roles.display_name%TYPE;
9612: --
9613: l_member_index NUMBER;
9614: l_result VARCHAR2 (100);

Line 9611: l_role_displayname wf_roles.display_name%TYPE;

9607: )
9608: IS
9609: l_plan_id NUMBER;
9610: l_role_name wf_roles.NAME%TYPE;
9611: l_role_displayname wf_roles.display_name%TYPE;
9612: --
9613: l_member_index NUMBER;
9614: l_result VARCHAR2 (100);
9615: l_count NUMBER := 0;