APPS.PER_JOB_EVALUATIONS_PKG2 dependencies on PER_JOB_EVALUATIONS

Line 1: PACKAGE BODY PER_JOB_EVALUATIONS_PKG2 as

1: PACKAGE BODY PER_JOB_EVALUATIONS_PKG2 as
2: /* $Header: pejbe02t.pkb 115.1 99/07/18 13:55:00 porting ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,

Line 37: CURSOR C IS SELECT rowid FROM PER_JOB_EVALUATIONS

33: X_Attribute18 VARCHAR2,
34: X_Attribute19 VARCHAR2,
35: X_Attribute20 VARCHAR2
36: ) IS
37: CURSOR C IS SELECT rowid FROM PER_JOB_EVALUATIONS
38:
39: WHERE job_evaluation_id = X_Job_Evaluation_Id;
40:
41:

Line 45: CURSOR C2 IS SELECT per_job_evaluations_s.nextval FROM sys.dual;

41:
42:
43:
44:
45: CURSOR C2 IS SELECT per_job_evaluations_s.nextval FROM sys.dual;
46: BEGIN
47:
48: if (X_Job_Evaluation_Id is NULL) then
49: OPEN C2;

Line 53: INSERT INTO PER_JOB_EVALUATIONS(

49: OPEN C2;
50: FETCH C2 INTO X_Job_Evaluation_Id;
51: CLOSE C2;
52: end if;
53: INSERT INTO PER_JOB_EVALUATIONS(
54: job_evaluation_id,
55: business_group_id,
56: comments,
57: date_evaluated,

Line 163: FROM PER_JOB_EVALUATIONS

159: X_Attribute20 VARCHAR2
160: ) IS
161: CURSOR C IS
162: SELECT *
163: FROM PER_JOB_EVALUATIONS
164: WHERE rowid = X_Rowid
165: FOR UPDATE of Job_Evaluation_Id NOWAIT;
166: Recinfo C%ROWTYPE;
167: BEGIN

Line 337: UPDATE PER_JOB_EVALUATIONS

333: X_Attribute19 VARCHAR2,
334: X_Attribute20 VARCHAR2
335: ) IS
336: BEGIN
337: UPDATE PER_JOB_EVALUATIONS
338: SET
339:
340: job_evaluation_id = X_Job_Evaluation_Id,
341: business_group_id = X_Business_Group_Id,

Line 383: DELETE FROM PER_JOB_EVALUATIONS

379: END Update_Row;
380:
381: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
382: BEGIN
383: DELETE FROM PER_JOB_EVALUATIONS
384: WHERE rowid = X_Rowid;
385:
386: if (SQL%NOTFOUND) then
387: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 394: END PER_JOB_EVALUATIONS_PKG2;

390: hr_utility.raise_error;
391: end if;
392: END Delete_Row;
393:
394: END PER_JOB_EVALUATIONS_PKG2;