DBA Data[Home] [Help]

APPS.PER_ABS_ATTENDANCE_REASONS_PKG dependencies on PER_ABS_ATTENDANCE_REASONS_PKG

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 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 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;