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 6: score_card_id per_personal_scorecards.scorecard_id%TYPE,

2: /* $Header: hrwpmntf.pkb 120.22.12020000.4 2012/11/09 06:21:50 sussuman ship $*/
3:
4: FUNCTION send_notification (
5: action_type VARCHAR2,
6: score_card_id per_personal_scorecards.scorecard_id%TYPE,
7: to_or_from_mgr_ntf VARCHAR2,
8: reason VARCHAR2
9: )
10: RETURN NUMBER

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

22: 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 *
29: FROM per_personal_scorecards
30: WHERE scorecard_id = p_scorecard_id;

Line 29: FROM per_personal_scorecards

25:
26: CURSOR get_scorecard_info (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
27: IS
28: SELECT *
29: FROM per_personal_scorecards
30: WHERE scorecard_id = p_scorecard_id;
31:
32: CURSOR get_sc_manager_person_id (p_sc_id NUMBER)
33: IS

Line 35: FROM per_all_assignments_f paf, per_personal_scorecards sc

31:
32: CURSOR get_sc_manager_person_id (p_sc_id NUMBER)
33: IS
34: SELECT paf.supervisor_id
35: FROM per_all_assignments_f paf, per_personal_scorecards sc
36: WHERE sc.scorecard_id = p_sc_id
37: AND sc.assignment_id = paf.assignment_id
38: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
39: AND paf.assignment_type IN ('E', 'C');

Line 41: CURSOR get_sc_person_id (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

37: AND sc.assignment_id = paf.assignment_id
38: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
39: AND paf.assignment_type IN ('E', 'C');
40:
41: CURSOR get_sc_person_id (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
42: IS
43: SELECT person_id
44: FROM per_personal_scorecards
45: WHERE scorecard_id = p_scorecard_id;

Line 44: FROM per_personal_scorecards

40:
41: CURSOR get_sc_person_id (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
42: IS
43: SELECT person_id
44: FROM per_personal_scorecards
45: WHERE scorecard_id = p_scorecard_id;
46:
47: CURSOR get_sc_plan_info (p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
48: IS

Line 50: FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN

46:
47: CURSOR get_sc_plan_info (p_sc_id per_perf_mgmt_plans.plan_id%TYPE)
48: IS
49: SELECT PLAN.hierarchy_type_code, PLAN.supervisor_id, PLAN.supervisor_assignment_id
50: FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN
51: WHERE sc.scorecard_id = p_sc_id AND sc.plan_id = PLAN.plan_id;
52:
53: CURSOR get_pos_manager_id (p_sc_id per_personal_scorecards.scorecard_id%TYPE)
54: IS

Line 53: CURSOR get_pos_manager_id (p_sc_id per_personal_scorecards.scorecard_id%TYPE)

49: SELECT PLAN.hierarchy_type_code, PLAN.supervisor_id, PLAN.supervisor_assignment_id
50: FROM per_personal_scorecards sc, per_perf_mgmt_plans PLAN
51: WHERE sc.scorecard_id = p_sc_id AND sc.plan_id = PLAN.plan_id;
52:
53: CURSOR get_pos_manager_id (p_sc_id per_personal_scorecards.scorecard_id%TYPE)
54: IS
55: SELECT sup.person_id
56: FROM per_personal_scorecards sc,
57: per_all_assignments_f wrk,

Line 56: FROM per_personal_scorecards sc,

52:
53: CURSOR get_pos_manager_id (p_sc_id per_personal_scorecards.scorecard_id%TYPE)
54: IS
55: SELECT sup.person_id
56: FROM per_personal_scorecards sc,
57: per_all_assignments_f wrk,
58: per_pos_structure_elements ppse,
59: per_all_assignments_f sup,
60: per_perf_mgmt_plans plans

Line 90: l_sc_info per_personal_scorecards%ROWTYPE;

86: from_name per_all_people_f.GLOBAL_NAME%TYPE;
87: to_name per_all_people_f.GLOBAL_NAME%TYPE;
88: from_role_not_exists EXCEPTION;
89: to_role_not_exists EXCEPTION;
90: l_sc_info per_personal_scorecards%ROWTYPE;
91: no_score_card_with_this_id EXCEPTION;
92: lv_subject VARCHAR2 (200) DEFAULT NULL;
93: tlnt_mgmt_rel_apps_fn VARCHAR2 (200) DEFAULT NULL;
94: mgr_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;

Line 95: sc_person_id per_personal_scorecards.person_id%TYPE DEFAULT NULL;

91: no_score_card_with_this_id EXCEPTION;
92: lv_subject VARCHAR2 (200) DEFAULT NULL;
93: tlnt_mgmt_rel_apps_fn VARCHAR2 (200) DEFAULT NULL;
94: mgr_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
95: sc_person_id per_personal_scorecards.person_id%TYPE DEFAULT NULL;
96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;
99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;

Line 132: UPDATE per_personal_scorecards

128: -- normally this procedure is invoked only when there is supervisor and employee
129: -- in case of top employee this is not called.
130: --- Added for bug#10246515 DO NOT SEND NOTIFICATION FOR THE TOP SUPERVISOR
131: IF (l_sc_info.person_id = NVL(l_top_supervisor_id,-1) OR l_sc_info.assignment_id = NVL(l_top_sup_asg_id,-1) ) AND to_or_from_mgr_ntf = 'EMP_TO_MGR' THEN
132: UPDATE per_personal_scorecards
133: SET status_code = 'PUBLISHED'
134: WHERE scorecard_id = score_card_id;
135: COMMIT;
136: RETURN success;

Line 341: UPDATE per_personal_scorecards

337: -- Bug 7580480 Fix start
338: BEGIN
339: IF (to_or_from_mgr_ntf = 'EMP_TO_MGR')
340: THEN
341: UPDATE per_personal_scorecards
342: SET status_code = 'APPROVAL'
343: WHERE scorecard_id = score_card_id;
344:
345: COMMIT;