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.PER_WPM_SUMMARY_PKG dependencies on PER_WPM_PLAN_HIERARCHY

Line 90: INSERT INTO per_wpm_plan_hierarchy

86: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
87: hr_utility.trace('INSIDE insert_next_levels: '||p_level_num);
88: hr_utility.trace('Inserting directs for:'||i.supervisor_name);
89: hr_utility.trace('Inserting direct:'||i.employee_name);
90: INSERT INTO per_wpm_plan_hierarchy
91: (wpm_plan_hierarchy_id
92: ,plan_id
93: ,employee_person_id
94: ,employee_name

Line 98: VALUES (per_wpm_plan_hierarchy_s.nextval

94: ,employee_name
95: ,supervisor_person_id
96: ,supervisor_name
97: ,level_num)
98: VALUES (per_wpm_plan_hierarchy_s.nextval
99: ,i.plan_id
100: ,i.employee_id
101: ,i.employee_name
102: ,i.supervisor_id

Line 112: INSERT INTO per_wpm_plan_hierarchy

108: LOOP
109: hr_utility.trace('Looping for supervisors for :'||i.employee_name);
110: hr_utility.trace('Supervisor:'||l_sup_level(j).supervisor_name);
111: hr_utility.trace('Supervisor level:'||((l_max_level - l_counter)+1));
112: INSERT INTO per_wpm_plan_hierarchy
113: (wpm_plan_hierarchy_id
114: ,plan_id
115: ,employee_person_id
116: ,employee_name

Line 120: VALUES (per_wpm_plan_hierarchy_s.nextval

116: ,employee_name
117: ,supervisor_person_id
118: ,supervisor_name
119: ,level_num)
120: VALUES (per_wpm_plan_hierarchy_s.nextval
121: ,i.plan_id
122: ,i.employee_id
123: ,i.employee_name
124: ,l_sup_level(j).supervisor_id

Line 235: INSERT INTO per_wpm_plan_hierarchy

231: l_sc_hrchy(j).position_id = l_pl_rec.top_position_id ) THEN
232: -- No need to insert anything as this is the top most record in the hierarchy
233: NULL;
234: ELSE
235: INSERT INTO per_wpm_plan_hierarchy
236: (wpm_plan_hierarchy_id
237: ,plan_id
238: ,employee_person_id
239: ,employee_name

Line 243: VALUES (per_wpm_plan_hierarchy_s.nextval

239: ,employee_name
240: ,supervisor_person_id
241: ,supervisor_name
242: ,level_num)
243: VALUES (per_wpm_plan_hierarchy_s.nextval
244: ,p_plan_id
245: ,i.person_id
246: ,i.full_name
247: ,l_sc_hrchy(j).supervisor_id

Line 272: INSERT INTO per_wpm_plan_hierarchy

268: l_sc_hrchy(j).position_id = l_pl_rec.top_position_id ) THEN
269: -- No need to insert anything as this is the top most record in the hierarchy
270: NULL;
271: ELSE
272: INSERT INTO per_wpm_plan_hierarchy
273: (wpm_plan_hierarchy_id
274: ,plan_id
275: ,employee_person_id
276: ,employee_name

Line 280: VALUES (per_wpm_plan_hierarchy_s.nextval

276: ,employee_name
277: ,supervisor_person_id
278: ,supervisor_name
279: ,level_num)
280: VALUES (per_wpm_plan_hierarchy_s.nextval
281: ,p_plan_id
282: ,i.person_id
283: ,i.full_name
284: ,l_sc_hrchy(j).supervisor_id

Line 323: DELETE per_wpm_plan_hierarchy

319: l_proc VARCHAR2(80) := g_package||'populate_plan_hierarchy';
320: BEGIN
321: --
322: hr_utility.set_location('Entering:'||l_proc,10);
323: DELETE per_wpm_plan_hierarchy
324: WHERE plan_id = p_plan_id;
325: l_effective_date := NVL(p_effective_date,TRUNC(SYSDATE));
326: /* changed the logic using build_hierarchy_for_sc
327: * FOR i IN csr_plan_sup_directs(p_plan_id,l_effective_date)

Line 332: INSERT INTO per_wpm_plan_hierarchy

328: LOOP
329: l_sup_level(1).supervisor_id := i.supervisor_id;
330: l_sup_level(1).supervisor_name := i.supervisor_name;
331: l_sup_level(1).level_num :=1;
332: INSERT INTO per_wpm_plan_hierarchy
333: (wpm_plan_hierarchy_id
334: ,plan_id
335: ,employee_person_id
336: ,employee_name

Line 340: VALUES (per_wpm_plan_hierarchy_s.nextval

336: ,employee_name
337: ,supervisor_person_id
338: ,supervisor_name
339: ,level_num)
340: VALUES (per_wpm_plan_hierarchy_s.nextval
341: ,i.plan_id
342: ,i.employee_id
343: ,i.employee_name
344: ,i.supervisor_id

Line 434: ,per_wpm_plan_hierarchy wph

430: ,p_effective_date DATE
431: ,p_rating_level_id NUMBER) IS
432: SELECT COUNT(*)
433: FROM per_appraisals pa
434: ,per_wpm_plan_hierarchy wph
435: ,per_people_f ppf
436: WHERE wph.plan_id = p_plan_id
437: AND wph.supervisor_person_id = p_supervisor_id
438: AND wph.level_num = 1

Line 454: ,per_wpm_plan_hierarchy wph

450: ,p_effective_date DATE
451: ,p_rating_level_id NUMBER) IS
452: SELECT COUNT(*)
453: FROM per_appraisals pa
454: ,per_wpm_plan_hierarchy wph
455: ,per_people_f ppf
456: WHERE wph.plan_id = p_plan_id
457: AND wph.supervisor_person_id = p_supervisor_id
458: AND wph.employee_person_id = ppf.person_id

Line 472: ,per_wpm_plan_hierarchy wph

468: ,p_supervisor_id NUMBER
469: ,p_effective_date DATE) IS
470: SELECT COUNT(*)
471: FROM per_appraisals pa
472: ,per_wpm_plan_hierarchy wph
473: ,per_people_f ppf
474: WHERE wph.plan_id = p_plan_id
475: AND wph.level_num = 1
476: AND wph.supervisor_person_id = p_supervisor_id

Line 489: ,per_wpm_plan_hierarchy wph

485: ,p_supervisor_id NUMBER
486: ,p_effective_date DATE) IS
487: SELECT COUNT(*)
488: FROM per_appraisals pa
489: ,per_wpm_plan_hierarchy wph
490: ,per_people_f ppf
491: WHERE wph.plan_id = p_plan_id
492: AND wph.supervisor_person_id = p_supervisor_id
493: AND wph.employee_person_id = ppf.person_id

Line 765: FROM per_wpm_plan_hierarchy

761: --
762: CURSOR csr_plan_managers(p_plan_id IN NUMBER) IS
763: SELECT distinct supervisor_person_id
764: , supervisor_name
765: FROM per_wpm_plan_hierarchy
766: WHERE plan_id = p_plan_id;
767: BEGIN
768: hr_utility.set_location('Entering:'||l_proc,10);
769: OPEN csr_appr_period_dtls(p_appraisal_period_id);