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_GRADE_SPINES_PKG dependencies on PER_GRADE_SPINES

Line 1: package body PER_GRADE_SPINES_PKG as

1: package body PER_GRADE_SPINES_PKG as
2: /* $Header: pegrs01t.pkb 120.0 2005/05/31 09:32:19 appldev noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Grade_Spine_Id IN OUT NOCOPY NUMBER,

Line 13: CURSOR C IS SELECT rowid FROM per_grade_spines_f

9: X_Parent_Spine_Id NUMBER,
10: X_Grade_Id NUMBER,
11: X_Ceiling_Step_Id IN OUT NOCOPY NUMBER
12: ) IS
13: CURSOR C IS SELECT rowid FROM per_grade_spines_f
14: WHERE grade_spine_id = X_Grade_Spine_Id;
15:
16: CURSOR C2 IS SELECT per_grade_spines_s.nextval
17: FROM sys.dual;

Line 16: CURSOR C2 IS SELECT per_grade_spines_s.nextval

12: ) IS
13: CURSOR C IS SELECT rowid FROM per_grade_spines_f
14: WHERE grade_spine_id = X_Grade_Spine_Id;
15:
16: CURSOR C2 IS SELECT per_grade_spines_s.nextval
17: FROM sys.dual;
18:
19: CURSOR C3 is select per_spinal_point_steps_s.nextval
20: from sys.dual;

Line 32: INSERT INTO per_grade_spines(

28: OPEN C3;
29: FETCH C3 into X_ceiling_step_id;
30: CLOSE C3;
31: end if;
32: INSERT INTO per_grade_spines(
33: grade_spine_id,
34: effective_start_date,
35: effective_end_date,
36: business_group_id,

Line 77: FROM per_grade_spines_f

73: X_program_update_date DATE
74: ) IS
75: CURSOR C IS
76: SELECT *
77: FROM per_grade_spines_f
78: WHERE rowid = chartorowid(X_Rowid)
79: FOR UPDATE of Grade_Spine_Id NOWAIT;
80:
81: Recinfo C%ROWTYPE;

Line 148: UPDATE per_grade_spines_f

144: X_Grade_Id NUMBER,
145: X_Ceiling_Step_Id NUMBER
146: ) IS
147: BEGIN
148: UPDATE per_grade_spines_f
149: SET
150: grade_spine_id = X_Grade_Spine_Id,
151: effective_start_date = X_Effective_Start_Date,
152: effective_end_date = X_Effective_End_Date,

Line 176: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;

172:
173: -- Start of fix for Bug 2694503.
174:
175: DECLARE
176: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;
177: BEGIN
178: select grade_spine_id
179: into l_grade_spine_id
180: from per_grade_spines_f

Line 180: from per_grade_spines_f

176: l_grade_spine_id per_grade_spines_f.grade_spine_id%Type;
177: BEGIN
178: select grade_spine_id
179: into l_grade_spine_id
180: from per_grade_spines_f
181: where rowid = chartorowid(X_Rowid);
182:
183: Delete from per_spinal_point_steps_f
184: where grade_spine_id = l_grade_spine_id;

Line 194: DELETE FROM per_grade_spines_f

190: end ;
191:
192: -- End of fix for Bug 2694503.
193:
194: DELETE FROM per_grade_spines_f
195: WHERE rowid = chartorowid(X_Rowid);
196:
197: if (SQL%NOTFOUND) then
198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 215: per_grade_spines_f gs

211:
212: cursor c1 is
213: select 'x'
214: from per_spinal_point_steps_f sps,
215: per_grade_spines_f gs
216: where gs.grade_spine_id = sps.grade_spine_id
217: and gs.parent_spine_id = p_pspine_id
218: and gs.grade_id = p_grd_id
219: and exists

Line 227: per_grade_spines_f gs

223: --
224: cursor c2 is
225: select 'x'
226: from per_spinal_point_steps_f sps,
227: per_grade_spines_f gs
228: where gs.grade_spine_id = sps.grade_spine_id
229: and gs.parent_spine_id = p_pspine_id
230: and gs.grade_id = p_grd_id
231: and exists

Line 239: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);

235: and a.special_ceiling_step_id is not null);
236: --
237: begin
238: --
239: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);
240: --
241: open c1;
242: --
243: fetch c1 into l_exists1;

Line 252: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',2);

248: END IF;
249: --
250: close c1;
251: --
252: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',2);
253: --
254: open c2;
255: --
256: fetch c2 into l_exists2;

Line 275: from per_grade_spines_f

271: l_exists VARCHAR2(1);
272:
273: cursor c3 is
274: select 'x'
275: from per_grade_spines_f
276: where grade_id = p_grd_id
277: and p_sess between effective_start_date and effective_end_date;
278: --
279: begin

Line 281: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);

277: and p_sess between effective_start_date and effective_end_date;
278: --
279: begin
280: --
281: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);
282: --
283: open c3;
284: --
285: fetch c3 into l_exists;

Line 371: l_proc varchar2(72) := 'per_grade_spines_pkg.first_step_api';

367:
368: --
369: -- declare local variables
370: --
371: l_proc varchar2(72) := 'per_grade_spines_pkg.first_step_api';
372: l_pay_scale_name varchar2(30);
373: l_spinal_point_name varchar2(30);
374: l_grade_id number;
375: l_return varchar2(20);

Line 383: ,per_grade_spines_f pgs

379: select pps.name
380: ,psp.spinal_point
381: ,pgs.grade_id
382: from per_parent_spines pps
383: ,per_grade_spines_f pgs
384: ,per_spinal_points psp
385: where pgs.grade_spine_id = p_grade_spine_id
386: and p_effective_date between
387: pgs.effective_start_date and pgs.effective_end_date

Line 521: hr_utility.set_location('per_grade_spines_pkg.chk_low_ceiling',1);

517: and s.sequence > p_new_ceil);
518: --
519: begin
520: --
521: hr_utility.set_location('per_grade_spines_pkg.chk_low_ceiling',1);
522: --
523: open c5;
524: --
525: fetch c5 into l_exists;

Line 556: hr_utility.set_location('per_grade_spines_pkg.zap_placement',1);

552: -- the point in time where the grade spine is being ended.
553: --
554: begin
555: --
556: hr_utility.set_location('per_grade_spines_pkg.zap_placement',1);
557: --
558: delete from per_spinal_point_placements_f
559: where placement_id = p_placement_id
560: and step_id = p_step_id

Line 563: hr_utility.set_location('per_grade_spines_pkg.zap_placement',2);

559: where placement_id = p_placement_id
560: and step_id = p_step_id
561: and effective_start_date = p_eff_start_date;
562: --
563: hr_utility.set_location('per_grade_spines_pkg.zap_placement',2);
564: --
565: end zap_placement;
566:
567:

Line 578: hr_utility.set_location('per_grade_spines_pkg.update_placement',1);

574: -- EED to the date the grade spine is being ended/opened up until.
575: --
576: begin
577: --
578: hr_utility.set_location('per_grade_spines_pkg.update_placement',1);
579: --
580: update per_spinal_point_placements_f
581: set effective_end_date = p_newdate
582: where placement_id = p_placement_id

Line 586: hr_utility.set_location('per_grade_spines_pkg.update_placement',2);

582: where placement_id = p_placement_id
583: and step_id = p_step_id
584: and effective_start_date = p_eff_start_date;
585: --
586: hr_utility.set_location('per_grade_spines_pkg.update_placement',2);
587: --
588: end update_placement;
589:
590:

Line 600: hr_utility.set_location('per_grade_spines_pkg.zap_step',1);

596: -- point in time where the grade spine is being ended.
597: --
598: begin
599: --
600: hr_utility.set_location('per_grade_spines_pkg.zap_step',1);
601: --
602: delete from per_spinal_point_steps_f
603: where step_id = p_step_id
604: and grade_spine_id = p_grade_spine_id

Line 607: hr_utility.set_location('per_grade_spines_pkg.zap_step',2);

603: where step_id = p_step_id
604: and grade_spine_id = p_grade_spine_id
605: and effective_start_date = p_eff_start_date;
606: --
607: hr_utility.set_location('per_grade_spines_pkg.zap_step',2);
608: --
609: end zap_step;
610:
611:

Line 622: hr_utility.set_location('per_grade_spines_pkg.update_step',1);

618: -- to the date the grade spine is being ended/opened up until.
619: --
620: begin
621: --
622: hr_utility.set_location('per_grade_spines_pkg.update_step',1);
623: --
624: update per_spinal_point_steps_f
625: set effective_end_date = p_newdate
626: where step_id = p_step_id

Line 630: hr_utility.set_location('per_grade_spines_pkg.update_step',2);

626: where step_id = p_step_id
627: and grade_spine_id = p_grade_spine_id
628: and effective_start_date = p_eff_start_date;
629: --
630: hr_utility.set_location('per_grade_spines_pkg.update_step',2);
631: --
632: end update_step;
633:
634:

Line 649: from per_grade_spines_f

645: -- the steps can be opened to the end of time.
646: --
647: cursor get_end is
648: select effective_start_date -1
649: from per_grade_spines_f
650: where grade_id = p_grade_id
651: and effective_start_date > p_eff_end_date
652: and grade_spine_id <> p_gspine_id;
653: --

Line 656: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',1);

652: and grade_spine_id <> p_gspine_id;
653: --
654: begin
655: --
656: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',1);
657: --
658: open get_end;
659: --
660: fetch get_end into p_gspine_opento_date;

Line 668: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',2);

664: IF p_gspine_opento_date is null THEN
665: p_gspine_opento_date := l_end_of_time;
666: END IF;
667: --
668: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',2);
669: --
670: end get_gspine_end;
671:
672:

Line 721: hr_utility.set_location('per_grade_spines_pkg.close_gspine',1);

717: --
718: --
719: begin
720: --
721: hr_utility.set_location('per_grade_spines_pkg.close_gspine',1);
722: --
723: open check_ass;
724: --
725: fetch check_ass into l_exists;

Line 734: hr_utility.set_location('per_grade_spines_pkg.close_gspine',2);

730: END IF;
731: --
732: close check_ass;
733: --
734: hr_utility.set_location('per_grade_spines_pkg.close_gspine',2);
735: --
736: open get_steps;
737: --
738: LOOP

Line 749: hr_utility.set_location('per_grade_spines_pkg.close_gspine',3);

745: exit when get_steps%notfound;
746: IF p_sess < l_stp_eff_end THEN
747: --
748: --
749: hr_utility.set_location('per_grade_spines_pkg.close_gspine',3);
750: --
751: open get_plcmnts(l_step_id);
752: --
753: -- delete/update the placement records.

Line 819: from per_grade_spines_f

815: -- step change.
816: --
817: cursor check_notceilchng is
818: select 1
819: from per_grade_spines_f
820: where grade_spine_id = p_gspine_id
821: and effective_start_date > p_eff_end_date;
822: --
823: -- cursor to locate the spinal point steps that require re-opening.

Line 870: hr_utility.set_location('per_grade_spines_pkg.open_gspine',1);

866: --
867: --
868: begin
869: --
870: hr_utility.set_location('per_grade_spines_pkg.open_gspine',1);
871: --
872: open check_notceilchng;
873: --
874: fetch check_notceilchng into l_exists;

Line 878: hr_utility.set_location('per_grade_spines_pkg.open_gspine',2);

874: fetch check_notceilchng into l_exists;
875: IF check_notceilchng%notfound THEN
876: close check_notceilchng;
877: --
878: hr_utility.set_location('per_grade_spines_pkg.open_gspine',2);
879: --
880: per_grade_spines_pkg.get_gspine_end(p_gspine_id,
881: p_grade_id,
882: p_eff_end_date,

Line 880: per_grade_spines_pkg.get_gspine_end(p_gspine_id,

876: close check_notceilchng;
877: --
878: hr_utility.set_location('per_grade_spines_pkg.open_gspine',2);
879: --
880: per_grade_spines_pkg.get_gspine_end(p_gspine_id,
881: p_grade_id,
882: p_eff_end_date,
883: l_gspine_opento_date);
884: --

Line 887: hr_utility.set_location('per_grade_spines_pkg.open_gspine',3);

883: l_gspine_opento_date);
884: --
885: l_stp_opento_date := nvl(l_gspine_opento_date,l_eot);
886: --
887: hr_utility.set_location('per_grade_spines_pkg.open_gspine',3);
888: --
889: FOR steps IN get_steps LOOP
890: --
891: -- re-open step records for grade spine

Line 896: hr_utility.set_location('per_grade_spines_pkg.open_gspine',4);

892: --
893: l_step_id := steps.step_id;
894: l_stp_eff_start := steps.effective_start_date;
895: --
896: hr_utility.set_location('per_grade_spines_pkg.open_gspine',4);
897: --
898: FOR placements IN get_placements(l_step_id) LOOP
899: --
900: -- re-open placement records for each step re-opened

Line 907: hr_utility.set_location('per_grade_spines_pkg.open_gspine',5);

903: l_plc_eff_start := placements.effective_start_date;
904: --
905: -- check if assignment has been ended
906: --
907: hr_utility.set_location('per_grade_spines_pkg.open_gspine',5);
908: --
909: open get_assend(l_plcmnt_id);
910: fetch get_assend into l_ass_maxend;
911: close get_assend;

Line 915: hr_utility.set_location('per_grade_spines_pkg.open_gspine',6);

911: close get_assend;
912: --
913: -- check if assignments grade has been changed
914: --
915: hr_utility.set_location('per_grade_spines_pkg.open_gspine',6);
916: --
917: open get_plcdate(l_plcmnt_id,
918: p_grade_id,
919: l_plc_eff_start);

Line 954: end PER_GRADE_SPINES_PKG;

950: --
951: end open_gspine;
952:
953:
954: end PER_GRADE_SPINES_PKG;