APPS.HR_MX_PERSON_ABSENCE_API dependencies on PER_ABSENCE_ATTENDANCES

Line 32: type with per_absence_attendances.comments%TYPE

28: 29-JUN-2004 sdahiya 115.0 Created.
29: 09-JUL-2004 sdahiya 115.1 Added business group check in
30: update_mx_person_absence.
31: 17-NOV-2011 emunisek 115.2 For Bug#13375560 replaced long data
32: type with per_absence_attendances.comments%TYPE
33:
34: *****************************************************************************/
35:
36: g_proc_name varchar2 (50);

Line 49: ,p_comments in per_absence_attendances.comments%TYPE default null

45: ,p_person_id in number
46: ,p_business_group_id in number
47: ,p_absence_attendance_type_id in number
48: ,p_abs_attendance_reason_id in number default null
49: ,p_comments in per_absence_attendances.comments%TYPE default null
50: ,p_date_notification in date default null
51: ,p_date_projected_start in date default null
52: ,p_time_projected_start in varchar2 default null
53: ,p_date_projected_end in date default null

Line 200: ,p_comments in per_absence_attendances.comments%TYPE default hr_api.g_varchar2

196: (p_validate in boolean default false
197: ,p_effective_date in date
198: ,p_absence_attendance_id in number
199: ,p_abs_attendance_reason_id in number default hr_api.g_number
200: ,p_comments in per_absence_attendances.comments%TYPE default hr_api.g_varchar2
201: ,p_date_notification in date default hr_api.g_date
202: ,p_date_projected_start in date default hr_api.g_date
203: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
204: ,p_date_projected_end in date default hr_api.g_date

Line 260: FROM per_absence_attendances_v

256: ) AS
257:
258: CURSOR get_person_id IS
259: SELECT person_id
260: FROM per_absence_attendances_v
261: WHERE absence_attendance_id = p_absence_attendance_id;
262:
263: l_proc_name varchar2(100);
264: l_person_id per_absence_attendances_v.person_id%type;

Line 264: l_person_id per_absence_attendances_v.person_id%type;

260: FROM per_absence_attendances_v
261: WHERE absence_attendance_id = p_absence_attendance_id;
262:
263: l_proc_name varchar2(100);
264: l_person_id per_absence_attendances_v.person_id%type;
265:
266: BEGIN
267: l_proc_name := g_proc_name||'UPDATE_MX_PERSON_ABSENCE';
268: hr_utility.trace('Entering '||l_proc_name);