[Home] [Help]
112: hr_utility.TRACE ('INSIDE insert_next_levels: ' || p_level_num);
113: hr_utility.TRACE ('Inserting directs for:' || i.supervisor_name);
114: hr_utility.TRACE ('Inserting direct:' || i.employee_name);
115:
116: INSERT INTO per_wpm_plan_hierarchy
117: (wpm_plan_hierarchy_id,
118: plan_id,
119: employee_person_id,
120: employee_name,
121: supervisor_person_id,
122: supervisor_name,
123: level_num
124: )
125: VALUES (per_wpm_plan_hierarchy_s.NEXTVAL,
126: i.plan_id,
127: i.employee_id,
128: i.employee_name,
129: i.supervisor_id,
139: hr_utility.TRACE ('Looping for supervisors for :' || i.employee_name);
140: hr_utility.TRACE ('Supervisor:' || l_sup_level (j).supervisor_name);
141: hr_utility.TRACE ('Supervisor level:' || ((l_max_level - l_counter) + 1));
142:
143: INSERT INTO per_wpm_plan_hierarchy
144: (wpm_plan_hierarchy_id,
145: plan_id,
146: employee_person_id,
147: employee_name,
148: supervisor_person_id,
149: supervisor_name,
150: level_num
151: )
152: VALUES (per_wpm_plan_hierarchy_s.NEXTVAL,
153: i.plan_id,
154: i.employee_id,
155: i.employee_name,
156: l_sup_level (j).supervisor_id,
350: THEN
351: -- No need to insert anything as this is the top most record in the hierarchy
352: NULL;
353: ELSE
354: INSERT INTO per_wpm_plan_hierarchy
355: (wpm_plan_hierarchy_id,
356: plan_id,
357: employee_person_id,
358: employee_name,
359: supervisor_person_id,
360: supervisor_name,
361: level_num
362: )
363: VALUES (per_wpm_plan_hierarchy_s.NEXTVAL,
364: p_plan_id,
365: i.person_id,
366: i.full_name,
367: l_sc_hrchy (j).supervisor_id,
396: THEN
397: -- No need to insert anything as this is the top most record in the hierarchy
398: NULL;
399: ELSE
400: INSERT INTO per_wpm_plan_hierarchy
401: (wpm_plan_hierarchy_id,
402: plan_id,
403: employee_person_id,
404: employee_name,
405: supervisor_person_id,
406: supervisor_name,
407: level_num
408: )
409: VALUES (per_wpm_plan_hierarchy_s.NEXTVAL,
410: p_plan_id,
411: i.person_id,
412: i.full_name,
413: l_sc_hrchy (j).supervisor_id,
452: BEGIN
453: --
454: hr_utility.set_location ('Entering:' || l_proc, 10);
455:
456: DELETE per_wpm_plan_hierarchy
457: WHERE plan_id = p_plan_id;
458:
459: l_effective_date := NVL (p_effective_date, TRUNC (SYSDATE));
460: /* changed the logic using build_hierarchy_for_sc
462: LOOP
463: l_sup_level(1).supervisor_id := i.supervisor_id;
464: l_sup_level(1).supervisor_name := i.supervisor_name;
465: l_sup_level(1).level_num :=1;
466: INSERT INTO per_wpm_plan_hierarchy
467: (wpm_plan_hierarchy_id
468: ,plan_id
469: ,employee_person_id
470: ,employee_name
470: ,employee_name
471: ,supervisor_person_id
472: ,supervisor_name
473: ,level_num)
474: VALUES (per_wpm_plan_hierarchy_s.nextval
475: ,i.plan_id
476: ,i.employee_id
477: ,i.employee_name
478: ,i.supervisor_id
578: IS
579: SELECT COUNT (*)
580: FROM (SELECT pa.appraisal_id
581: FROM per_appraisals pa,
582: per_wpm_plan_hierarchy wph,
583: per_people_f ppf,
584: per_all_assignments_f paf,
585: per_periods_of_service pps
586: WHERE wph.plan_id = p_plan_id
607: AND pa.overall_performance_level_id = p_rating_level_id
608: UNION
609: SELECT pa.appraisal_id
610: FROM per_appraisals pa,
611: per_wpm_plan_hierarchy wph,
612: per_people_f ppf,
613: per_all_assignments_f paf,
614: per_periods_of_placement pps
615: WHERE wph.plan_id = p_plan_id
647: IS
648: SELECT COUNT (*)
649: FROM (SELECT pa.appraisal_id
650: FROM per_appraisals pa,
651: per_wpm_plan_hierarchy wph,
652: per_people_f ppf,
653: per_all_assignments_f paf,
654: per_periods_of_service pps
655: WHERE wph.plan_id = p_plan_id
675: AND pa.overall_performance_level_id = p_rating_level_id
676: UNION
677: SELECT pa.appraisal_id
678: FROM per_appraisals pa,
679: per_wpm_plan_hierarchy wph,
680: per_people_f ppf,
681: per_all_assignments_f paf,
682: per_periods_of_placement pps
683: WHERE wph.plan_id = p_plan_id
714: IS
715: SELECT COUNT (*)
716: FROM (SELECT pa.appraisal_id
717: FROM per_appraisals pa,
718: per_wpm_plan_hierarchy wph,
719: per_people_f ppf,
720: per_all_assignments_f paf,
721: per_periods_of_service pps
722: WHERE wph.plan_id = p_plan_id
743: AND pa.overall_performance_level_id IS NULL
744: UNION
745: SELECT pa.appraisal_id
746: FROM per_appraisals pa,
747: per_wpm_plan_hierarchy wph,
748: per_people_f ppf,
749: per_all_assignments_f paf,
750: per_periods_of_placement pps
751: WHERE wph.plan_id = p_plan_id
781: IS
782: SELECT COUNT (*)
783: FROM (SELECT pa.appraisal_id
784: FROM per_appraisals pa,
785: per_wpm_plan_hierarchy wph,
786: per_people_f ppf,
787: per_all_assignments_f paf,
788: per_periods_of_service pps
789: WHERE wph.plan_id = p_plan_id
809: AND pa.overall_performance_level_id IS NULL
810: UNION
811: SELECT pa.appraisal_id
812: FROM per_appraisals pa,
813: per_wpm_plan_hierarchy wph,
814: per_people_f ppf,
815: per_all_assignments_f paf,
816: per_periods_of_placement pps
817: WHERE wph.plan_id = p_plan_id
1147: SELECT DISTINCT supervisor_person_id,
1148: supervisor_name,
1149: pap.appraisal_period_id,
1150: pap.appraisal_template_id
1151: FROM per_wpm_plan_hierarchy wph, per_appraisal_periods pap
1152: WHERE wph.plan_id = p_plan_id
1153: AND pap.appraisal_period_id = p_appraisal_period_id
1154: AND pap.plan_id = wph.plan_id;
1155: BEGIN