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_GRADES_PKG dependencies on PER_GRADES

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 43: select per_grades_s.nextval

39: p_attribute19 varchar2,
40: p_attribute20 varchar2,
41: p_language_code varchar2 default hr_api.userenv_lang) IS
42: cursor c1 is
43: select per_grades_s.nextval
44: from sys.dual;
45: cursor c2 is
46: select rowid
47: from per_grades

Line 47: from per_grades

43: select per_grades_s.nextval
44: from sys.dual;
45: cursor c2 is
46: select rowid
47: from per_grades
48: where grade_id = p_grade_id;
49: begin
50: open c1;
51: fetch c1 into p_grade_id;

Line 56: insert into per_grades (

52: close c1;
53:
54:
55: BEGIn
56: insert into per_grades (
57: grade_id,
58: business_group_id,
59: grade_definition_id,
60: date_from,

Line 150: delete from per_grades g

146: p_grd_id in number) is
147: begin
148: stbdelvl(p_grd_id);
149: begin
150: delete from per_grades g
151: where g.rowid = chartorowid(P_ROW_ID);
152: end;
153:
154: --

Line 204: from per_grades_vl g

200: p_language_code varchar2 default hr_api.userenv_lang) IS
201:
202: cursor OPM_CUR is
203: select *
204: from per_grades_vl g
205: where g.row_id = chartorowid(P_ROW_ID)
206: for update of grade_id nowait;
207:
208: OPM_REC OPM_CUR%rowtype;

Line 394: update per_grades g

390: p_attribute20 varchar2,
391: p_language_code varchar2 default hr_api.userenv_lang) is
392:
393: begin
394: update per_grades g
395: set
396: g.grade_id = p_grade_id,
397: g.business_group_id = p_business_group_id,
398: g.grade_definition_id = p_grade_definition_id,

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 745: FROM per_grades p

741: l_exists VARCHAR2(1);
742:
743: cursor c12 is
744: select 'x'
745: FROM per_grades p
746: WHERE (p.ROWID <> p_rwid OR p_rwid IS NULL)
747: AND (p.grade_id <> p_grd_id OR p_grd_id IS NULL)
748: AND p.business_group_id + 0 = p_bgroup_id
749: AND p.grade_definition_id = p_grdef_id;

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 780: FROM per_grades p

776: p_fail OUT NOCOPY BOOLEAN) IS
777:
778: cursor c14 is
779: SELECT 'Y'
780: FROM per_grades p
781: WHERE (p_rwid IS NULL OR p_rwid <> p.ROWID)
782: AND p_bgroup_id = p.business_group_id + 0
783: AND p_seg = p.name;
784: --

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 806: from per_grades

802: p_old_date IN OUT NOCOPY DATE) is
803:
804: cursor c15 is
805: select date_to
806: from per_grades
807: where grade_id = p_grd_id;
808: --
809: begin
810: --

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 830: from per_grades g

826: l_exists varchar2(1);
827:
828: cursor c16 is
829: select 'x'
830: from per_grades g
831: where g.sequence = p_seq
832: and g.business_group_id + 0 = p_bgroup
833: and (p_rwid is null or chartorowid(p_rwid) <> g.rowid);
834: --

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;