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_PERSONAL_SCORECARDS

Line 7: score_card_id per_personal_scorecards.scorecard_id%TYPE,

3:
4:
5: FUNCTION send_notification
6: ( action_type varchar2,
7: score_card_id per_personal_scorecards.scorecard_id%TYPE,
8: to_or_from_mgr_ntf varchar2,
9: reason varchar2)
10: RETURN number
11: IS

Line 26: cursor get_scorecard_info(p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

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)
27: is
28: select * from per_personal_scorecards where scorecard_id = p_scorecard_id;
29:
30: CURSOR get_sc_manager_person_id(p_sc_id NUMBER) IS

Line 28: select * from per_personal_scorecards where scorecard_id = p_scorecard_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)
27: is
28: select * from per_personal_scorecards where scorecard_id = p_scorecard_id;
29:
30: CURSOR get_sc_manager_person_id(p_sc_id NUMBER) IS
31: SELECT paf.supervisor_id
32: FROM per_all_assignments_f paf

Line 33: ,per_personal_scorecards sc

29:
30: CURSOR get_sc_manager_person_id(p_sc_id NUMBER) IS
31: SELECT paf.supervisor_id
32: FROM per_all_assignments_f paf
33: ,per_personal_scorecards sc
34: WHERE sc.scorecard_id = p_sc_id
35: AND sc.assignment_id = paf.assignment_id
36: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
37: AND paf.assignment_type in ('E','C');

Line 39: cursor get_sc_person_id (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

35: AND sc.assignment_id = paf.assignment_id
36: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
37: AND paf.assignment_type in ('E','C');
38:
39: cursor get_sc_person_id (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
40: is
41: select person_id from per_personal_scorecards
42: where scorecard_id = p_scorecard_id;
43:

Line 41: select person_id from per_personal_scorecards

37: AND paf.assignment_type in ('E','C');
38:
39: cursor get_sc_person_id (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
40: is
41: select person_id from per_personal_scorecards
42: where scorecard_id = p_scorecard_id;
43:
44: cursor get_sc_plan_info(p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
45: is

Line 46: select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan

42: where scorecard_id = p_scorecard_id;
43:
44: cursor get_sc_plan_info(p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
45: is
46: select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan
47: where sc.scorecard_id = p_sc_id
48: and sc.plan_id = plan.plan_id;
49:
50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)

Line 50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)

46: select HIERARCHY_TYPE_CODE from per_personal_scorecards sc, per_perf_mgmt_plans plan
47: where sc.scorecard_id = p_sc_id
48: and sc.plan_id = plan.plan_id;
49:
50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)
51: is
52: select sup.person_id
53: from per_personal_scorecards sc, per_assignments_f wrk,
54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans

Line 53: from per_personal_scorecards sc, per_assignments_f wrk,

49:
50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)
51: is
52: select sup.person_id
53: from per_personal_scorecards sc, per_assignments_f wrk,
54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans
55: where sc.scorecard_id = p_sc_id
56: and plans.plan_id = sc.plan_id
57: and sc.assignment_id = wrk.assignment_id

Line 71: l_sc_info per_personal_scorecards%ROWTYPE;

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;
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;

Line 76: sc_person_id per_personal_scorecards.person_id%TYPE default null;

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;
80: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;