APPS.PER_GRADES_PKG dependencies on PER_GRADES_PKG

Line 1: package body PER_GRADES_PKG as

1: package body PER_GRADES_PKG as
2: /* $Header: pegrd01t.pkb 120.0 2005/05/31 09:29:18 appldev noship $ */
3:
4: -- Standard insert procedure
5:

Line 488: hr_utility.set_location('per_grades_pkg.stbdelvl',1);

484: AND rate_type = 'G';
485: --
486: begin
487: --
488: hr_utility.set_location('per_grades_pkg.stbdelvl',1);
489: --
490: open c1;
491: --
492: fetch c1 into l_exists;

Line 501: hr_utility.set_location('per_grades_pkg.stbdelvl',2);

497: END IF;
498: --
499: close c1;
500: --
501: hr_utility.set_location('per_grades_pkg.stbdelvl',2);
502: --
503: open c2;
504: --
505: fetch c2 into l_exists;

Line 514: hr_utility.set_location('per_grades_pkg.stbdelvl',3);

510: END IF;
511: --
512: close c2;
513: --
514: hr_utility.set_location('per_grades_pkg.stbdelvl',3);
515: --
516: open c3;
517: --
518: fetch c3 into l_exists;

Line 527: hr_utility.set_location('per_grades_pkg.stbdelvl',4);

523: END IF;
524: --
525: close c3;
526: --
527: hr_utility.set_location('per_grades_pkg.stbdelvl',4);
528: --
529: open c4;
530: --
531: fetch c4 into l_exists;

Line 540: hr_utility.set_location('per_grades_pkg.stbdelvl',5);

536: END IF;
537: --
538: close c4;
539: --
540: hr_utility.set_location('per_grades_pkg.stbdelvl',5);
541: --
542: open c5;
543: --
544: fetch c5 into l_exists;

Line 553: hr_utility.set_location('per_grades_pkg.stbdelvl',6);

549: END IF;
550: --
551: close c5;
552: --
553: hr_utility.set_location('per_grades_pkg.stbdelvl',6);
554: --
555: open c6;
556: --
557: fetch c6 into l_exists;

Line 566: hr_utility.set_location('per_grades_pkg.stbdelvl',7);

562: END IF;
563: --
564: close c6;
565: --
566: hr_utility.set_location('per_grades_pkg.stbdelvl',7);
567: --
568: open c7;
569: --
570: fetch c7 into l_exists;

Line 687: hr_utility.set_location('per_grades_pkg.gstruct',1);

683: AND rownum = 1;
684: --
685: begin
686: --
687: hr_utility.set_location('per_grades_pkg.gstruct',1);
688: --
689: open c10;
690: --
691: fetch c10 into l_g_str;

Line 720: hr_utility.set_location('per_grades_pkg.b_check_grade_date_from',1);

716: AND p_date_from > date_from;
717: --
718: begin
719: --
720: hr_utility.set_location('per_grades_pkg.b_check_grade_date_from',1);
721: --
722: open c11;
723: --
724: fetch c11 into l_exists;

Line 753: hr_utility.set_location('per_grades_pkg.chk_flex_def',1);

749: AND p.grade_definition_id = p_grdef_id;
750: --
751: begin
752: --
753: hr_utility.set_location('per_grades_pkg.chk_flex_def',1);
754: --
755: open c12;
756: --
757: fetch c12 into l_exists;

Line 787: hr_utility.set_location('per_grades_pkg.chk_grade',1);

783: AND p_seg = p.name;
784: --
785: begin
786: --
787: hr_utility.set_location('per_grades_pkg.chk_grade',1);
788: --
789: open c14;
790: --
791: fetch c14 into p_popid;

Line 811: hr_utility.set_location('per_grades_pkg.old_date_to',1);

807: where grade_id = p_grd_id;
808: --
809: begin
810: --
811: hr_utility.set_location('per_grades_pkg.old_date_to',1);
812: --
813: open c15;
814: --
815: fetch c15 into p_old_date;

Line 837: hr_utility.set_location('per_grades_pkg.chk_seq',1);

833: and (p_rwid is null or chartorowid(p_rwid) <> g.rowid);
834: --
835: begin
836: --
837: hr_utility.set_location('per_grades_pkg.chk_seq',1);
838: --
839: open c16;
840: --
841: fetch c16 into l_exists;

Line 868: hr_utility.set_location('per_grades_pkg.chk_date_from', 1);

864: and p.effective_start_date < nvl(p_date_from, hr_api.g_sot);
865: --
866: begin
867: --
868: hr_utility.set_location('per_grades_pkg.chk_date_from', 1);
869: --
870: open chk_grd_dt_from;
871: fetch chk_grd_dt_from into l_exists;
872: IF chk_grd_dt_from%found THEN

Line 905: hr_utility.set_location('per_grades_pkg.chk_end_date', 1);

901:
902: --
903: begin
904: --
905: hr_utility.set_location('per_grades_pkg.chk_end_date', 1);
906: --
907: open chk_grd_dt_to;
908: fetch chk_grd_dt_to into l_exists;
909: IF chk_grd_dt_to%found THEN

Line 932: end PER_GRADES_PKG;

928: -- bug fix 3360504 ends here
929:
930: end chk_end_date;
931:
932: end PER_GRADES_PKG;