APPS.PER_VALID_GRADES_PKG2 dependencies on PER_VALID_GRADES

Line 1: PACKAGE BODY PER_VALID_GRADES_PKG2 as

1: PACKAGE BODY PER_VALID_GRADES_PKG2 as
2: /* $Header: pevgr02t.pkb 120.1 2005/10/03 12:04:46 hsajja noship $ */
3:
4: Procedure check_duplicate_valid_grade (X_Rowid VARCHAR2,
5: X_Business_Group_Id NUMBER,

Line 18: FROM PER_VALID_GRADES VG

14: l_dummy varchar2(1);
15:
16: cursor csr_exists is
17: SELECT '1'
18: FROM PER_VALID_GRADES VG
19: WHERE (ROWID <> X_Rowid
20: OR X_Rowid IS NULL)
21: AND VG.business_group_id + 0 = X_Business_Group_Id
22: AND VG.POSITION_ID = X_Position_Id

Line 152: CURSOR C IS SELECT rowid FROM PER_VALID_GRADES

148: x_end_of_time DATE,
149: x_pst1_date_end DATE,
150: x_pst1_date_effective DATE
151: ) IS
152: CURSOR C IS SELECT rowid FROM PER_VALID_GRADES
153:
154: WHERE valid_grade_id = X_Valid_Grade_Id;
155:
156:

Line 160: CURSOR C2 IS SELECT per_valid_grades_s.nextval FROM sys.dual;

156:
157:
158:
159:
160: CURSOR C2 IS SELECT per_valid_grades_s.nextval FROM sys.dual;
161: BEGIN
162:
163: -- date to must be greater than date from.
164:

Line 192: INSERT INTO PER_VALID_GRADES(

188: OPEN C2;
189: FETCH C2 INTO X_Valid_Grade_Id;
190: CLOSE C2;
191: end if;
192: INSERT INTO PER_VALID_GRADES(
193: valid_grade_id,
194: business_group_id,
195: grade_id,
196: date_from,

Line 299: FROM PER_VALID_GRADES

295: X_Attribute20 VARCHAR2
296: ) IS
297: CURSOR C IS
298: SELECT *
299: FROM PER_VALID_GRADES
300: WHERE rowid = X_Rowid
301: FOR UPDATE of Valid_Grade_Id NOWAIT;
302: Recinfo C%ROWTYPE;
303: BEGIN

Line 494: UPDATE PER_VALID_GRADES

490: check_valid_grade_date_from(x_Date_From ,
491: x_pst1_date_effective ,
492: x_grade_id);
493:
494: UPDATE PER_VALID_GRADES
495: SET
496:
497: valid_grade_id = X_Valid_Grade_Id,
498: business_group_id = X_Business_Group_Id,

Line 539: DELETE FROM PER_VALID_GRADES

535: END Update_Row;
536:
537: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
538: BEGIN
539: DELETE FROM PER_VALID_GRADES
540: WHERE rowid = X_Rowid;
541:
542: if (SQL%NOTFOUND) then
543: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 550: END PER_VALID_GRADES_PKG2;

546: hr_utility.raise_error;
547: end if;
548: END Delete_Row;
549:
550: END PER_VALID_GRADES_PKG2;