APPS.PER_ABS_ATTENDANCE_REASONS_PKG dependencies on PER_ABS_ATTENDANCE_REASONS

Line 1: PACKAGE BODY PER_ABS_ATTENDANCE_REASONS_PKG as

1: PACKAGE BODY PER_ABS_ATTENDANCE_REASONS_PKG as
2: /* $Header: peaar01t.pkb 115.0 99/07/17 18:23:02 porting ship $ */
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 35: FROM PER_ABS_ATTENDANCE_REASONS

31: ) IS
32: --
33: CURSOR C IS
34: SELECT rowid
35: FROM PER_ABS_ATTENDANCE_REASONS
36: WHERE abs_attendance_reason_id = X_Abs_Attendance_Reason_Id;
37: --
38: CURSOR C2 IS
39: SELECT per_abs_attendance_reasons_s.nextval

Line 39: SELECT per_abs_attendance_reasons_s.nextval

35: FROM PER_ABS_ATTENDANCE_REASONS
36: WHERE abs_attendance_reason_id = X_Abs_Attendance_Reason_Id;
37: --
38: CURSOR C2 IS
39: SELECT per_abs_attendance_reasons_s.nextval
40: FROM sys.dual;
41: --
42: BEGIN
43: --

Line 53: INSERT INTO PER_ABS_ATTENDANCE_REASONS(

49: OPEN C2;
50: FETCH C2 INTO X_Abs_Attendance_Reason_Id;
51: CLOSE C2;
52: end if;
53: INSERT INTO PER_ABS_ATTENDANCE_REASONS(
54: abs_attendance_reason_id,
55: business_group_id,
56: absence_attendance_type_id,
57: name,

Line 92: FROM PER_ABS_ATTENDANCE_REASONS

88: X_Name VARCHAR2
89: ) IS
90: CURSOR C IS
91: SELECT *
92: FROM PER_ABS_ATTENDANCE_REASONS
93: WHERE rowid = X_Rowid
94: FOR UPDATE of Abs_Attendance_Reason_Id NOWAIT;
95: Recinfo C%ROWTYPE;
96: BEGIN

Line 143: UPDATE PER_ABS_ATTENDANCE_REASONS

139: check_unique_reason(X_Rowid
140: ,X_Name
141: ,X_Absence_Attendance_Type_Id);
142: --
143: UPDATE PER_ABS_ATTENDANCE_REASONS
144: SET
145: abs_attendance_reason_id = X_Abs_Attendance_Reason_Id,
146: business_group_id = X_Business_Group_Id,
147: absence_attendance_type_id = X_Absence_Attendance_Type_Id,

Line 166: DELETE FROM PER_ABS_ATTENDANCE_REASONS

162: BEGIN
163: --
164: abr_del_validation(X_abs_attendance_reason_id);
165: --
166: DELETE FROM PER_ABS_ATTENDANCE_REASONS
167: WHERE rowid = X_Rowid;
168: --
169: if (SQL%NOTFOUND) then
170: RAISE NO_DATA_FOUND;

Line 183: hr_utility.set_location('per_abs_attendance_reasons_pkg.Get_Name',1);

179: where lookup_code = X_CODE
180: and lookup_type = 'ABSENCE_REASON';
181: --
182: begin
183: hr_utility.set_location('per_abs_attendance_reasons_pkg.Get_Name',1);
184: OPEN C;
185: FETCH C INTO X_MEANING;
186: CLOSE C;
187: end Get_Name;

Line 198: hr_utility.set_location('per_abs_attendance_reasons_pkg.abr_del_validation',1);

194: where ABS_ATTENDANCE_REASON_ID =p_abs_attendance_reason_id;
195: abs_rec c%rowtype;
196: --
197: begin
198: hr_utility.set_location('per_abs_attendance_reasons_pkg.abr_del_validation',1);
199: OPEN C;
200: FETCH C INTO abs_rec;
201: if (C%FOUND) then
202: CLOSE C;

Line 216: from per_abs_attendance_reasons

212: ,p_absence_attendance_type_id NUMBER) is
213: --
214: cursor c is
215: select ''
216: from per_abs_attendance_reasons
217: where absence_attendance_type_id = p_absence_attendance_type_id
218: and name = p_name
219: and (p_rowid is null
220: or (p_rowid is not null

Line 225: hr_utility.set_location('per_abs_attendance_reasons_pkg.check_unique_reason',1);

221: and rowid = chartorowid(p_rowid)));
222: abr_rec c%rowtype;
223: --
224: begin
225: hr_utility.set_location('per_abs_attendance_reasons_pkg.check_unique_reason',1);
226: OPEN C;
227: FETCH C INTO abr_rec;
228: if (C%FOUND) then
229: CLOSE C;

Line 237: END PER_ABS_ATTENDANCE_REASONS_PKG;

233: CLOSE C;
234: end check_unique_reason;
235: --
236: --
237: END PER_ABS_ATTENDANCE_REASONS_PKG;