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_WPM_NTF_UTIL dependencies on PER_ALL_PEOPLE_F

Line 13: cursor get_role(person_id per_all_people_f.person_id%TYPE)

9: reason varchar2)
10: RETURN number
11: IS
12: -- to be clarified for orig_system
13: cursor get_role(person_id per_all_people_f.person_id%TYPE)
14: is
15: select wf.name role_name
16: from wf_roles wf
17: where wf.orig_system = 'PER'

Line 20: cursor get_global_name(p_person_id per_all_people_f.person_id%TYPE)

16: from wf_roles wf
17: where wf.orig_system = 'PER'
18: and wf.orig_system_id = person_id;
19:
20: cursor get_global_name(p_person_id per_all_people_f.person_id%TYPE)
21: is
22: select global_name from per_all_people_f
23: where person_id = p_person_id
24: and trunc(sysdate) between effective_start_date and effective_end_date;

Line 22: select global_name from per_all_people_f

18: and wf.orig_system_id = person_id;
19:
20: cursor get_global_name(p_person_id per_all_people_f.person_id%TYPE)
21: is
22: select global_name from per_all_people_f
23: where person_id = p_person_id
24: and trunc(sysdate) between effective_start_date and effective_end_date;
25:
26: cursor get_scorecard_info(p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

Line 67: from_name per_all_people_f.global_name%TYPE;

63:
64: ln_notification_id number;
65: from_role wf_local_roles.name%TYPE default null;
66: to_role wf_local_roles.name%TYPE default null;
67: from_name per_all_people_f.global_name%TYPE;
68: to_name per_all_people_f.global_name%TYPE;
69: FROM_ROLE_NOT_EXISTS exception;
70: TO_ROLE_NOT_EXISTS exception;
71: l_sc_info per_personal_scorecards%ROWTYPE;

Line 68: to_name per_all_people_f.global_name%TYPE;

64: ln_notification_id number;
65: from_role wf_local_roles.name%TYPE default null;
66: to_role wf_local_roles.name%TYPE default null;
67: from_name per_all_people_f.global_name%TYPE;
68: to_name per_all_people_f.global_name%TYPE;
69: FROM_ROLE_NOT_EXISTS exception;
70: TO_ROLE_NOT_EXISTS exception;
71: l_sc_info per_personal_scorecards%ROWTYPE;
72: NO_SCORE_CARD_WITH_THIS_ID exception;

Line 75: mgr_person_id per_all_people_f.person_id%TYPE default null;

71: l_sc_info per_personal_scorecards%ROWTYPE;
72: NO_SCORE_CARD_WITH_THIS_ID exception;
73: lv_subject varchar2(200) default null;
74: tlnt_mgmt_rel_apps_fn varchar2(200) default null;
75: mgr_person_id per_all_people_f.person_id%TYPE default null;
76: sc_person_id per_personal_scorecards.person_id%TYPE default null;
77: from_person_id per_all_people_f.person_id%TYPE default null;
78: to_person_id per_all_people_f.person_id%TYPE default null;
79: mesg_name varchar2(100) default null;

Line 77: from_person_id per_all_people_f.person_id%TYPE default null;

73: lv_subject varchar2(200) default null;
74: tlnt_mgmt_rel_apps_fn varchar2(200) default null;
75: mgr_person_id per_all_people_f.person_id%TYPE default null;
76: sc_person_id per_personal_scorecards.person_id%TYPE default null;
77: from_person_id per_all_people_f.person_id%TYPE default null;
78: to_person_id per_all_people_f.person_id%TYPE default null;
79: mesg_name varchar2(100) default null;
80: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
81:

Line 78: to_person_id per_all_people_f.person_id%TYPE default null;

74: tlnt_mgmt_rel_apps_fn varchar2(200) default null;
75: mgr_person_id per_all_people_f.person_id%TYPE default null;
76: sc_person_id per_personal_scorecards.person_id%TYPE default null;
77: from_person_id per_all_people_f.person_id%TYPE default null;
78: to_person_id per_all_people_f.person_id%TYPE default null;
79: mesg_name varchar2(100) default null;
80: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
81:
82: BEGIN