eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on PER_ABSENCE_ATTENDANCES

Line 1: PACKAGE BODY PER_ABSENCE_ATTENDANCES_PKG3 as

1: PACKAGE BODY PER_ABSENCE_ATTENDANCES_PKG3 as
2: /* $Header: peaba03t.pkb 120.0 2005/05/31 04:40:30 appldev noship $ */
3: --
4: /*
5: NAME

Line 20: per_absence_attendances_pkg.insert_row. They

16: row from datetracked join tables in the
17: base view for PERWSEAD, so should not be left
18: NULL.
19: rfine 70.5 23-Nov-95 Added new SSP-related args to call to
20: per_absence_attendances_pkg.insert_row. They
21: are defined as DEFAULTs, which means they
22: shouldn't really be necessary, but they appear
23: to be.
24: ctredwin 110.2 16-Aug-99 Bug 953648. Handle null value from cursor

Line 69: g_package varchar2(33) := ' per_absence_attendances_pkg3.';

65: */
66: --
67: -- Package Variables
68: --
69: g_package varchar2(33) := ' per_absence_attendances_pkg3.';
70: --
71: procedure check_dates_entered(p_date_end In DATE,
72: p_absence_days In NUMBER,
73: p_absence_hours In NUMBER,

Line 249: per_absence_attendances_pkg.get_defaults(p_time_end,

245: --
246: else
247: --
248:
249: per_absence_attendances_pkg.get_defaults(p_time_end,
250: p_time_start,
251: p_date_end,
252: p_date_start,
253: l_hours_default,

Line 303: from per_absence_attendances t,

299: l_exists2 VARCHAR2(1);
300:
301: cursor c1 is
302: select 'x'
303: from per_absence_attendances t,
304: per_absence_attendance_types a,
305: per_absence_attendance_types b
306: where t.person_id = p_person_id
307: and p_abs_type_id = a.absence_attendance_type_id

Line 316: from per_absence_attendances t,

312: and t.date_end is null;
313: --
314: cursor c2 is
315: select 'x'
316: from per_absence_attendances t,
317: per_absence_attendance_types a,
318: per_absence_attendance_types b
319: where t.person_id = p_person_id
320: and p_abs_type_id = b.absence_attendance_type_id

Line 565: IF per_absence_attendances_pkg.chkab3(null,

561: l_message varchar2(30) := null;
562:
563: begin
564: --
565: IF per_absence_attendances_pkg.chkab3(null,
566: p_person_id,
567: p_abs_type_id,
568: p_date_start,
569: p_date_end,

Line 591: IF not (per_absence_attendances_pkg.is_emp_entitled (

587: l_message varchar2(30) := null;
588:
589: begin
590: --
591: IF not (per_absence_attendances_pkg.is_emp_entitled (
592: p_abs_type_id,
593: p_assignment_id,
594: p_date_start,
595: p_absence_days,

Line 631: l_balance := per_absence_attendances_pkg.get_annual_balance(

627: close c1;
628:
629: if l_flag = 'D' then
630: --
631: l_balance := per_absence_attendances_pkg.get_annual_balance(
632: p_session_date => p_date_start,
633: p_abs_type_id => p_abs_type_id,
634: p_ass_id => p_assignment_id
635: );

Line 659: IF per_absence_attendances_pkg.chkab1(null,

655: l_message varchar2(30) := null;
656:
657: begin
658: --
659: IF per_absence_attendances_pkg.chkab1(null,
660: p_person_id,
661: p_abs_type_id,
662: p_date_start) THEN
663: --

Line 923: FROM per_absence_attendances

919: -- has to be declared after l_person_id.
920: --
921: CURSOR C3 IS
922: SELECT max(occurrence)
923: FROM per_absence_attendances
924: WHERE person_id = l_person_id
925: AND absence_attendance_type_id = p_absence_att_type_id;
926: --
927: --

Line 979: per_absence_attendances_pkg.get_ele_det1

975: IF l_ele_exists_flag = 'Y' THEN
976: --
977: -- Derive p_element_link
978: --
979: per_absence_attendances_pkg.get_ele_det1
980: (p_bgroup_id => l_business_group_id,
981: p_eltype => l_element_type_id,
982: p_per_id => l_person_id,
983: p_dstart => p_date_start,

Line 1016: -- Insert the new absence from PayMIX into per_absence_attendances

1012: --
1013: l_max_occurrence := l_max_occurrence + 1;
1014: --
1015: --
1016: -- Insert the new absence from PayMIX into per_absence_attendances
1017: -- table. All values are set to null except for the mandatory ones
1018: -- and those set up by PayMIX.
1019: --
1020: per_absence_attendances_pkg.insert_row

Line 1020: per_absence_attendances_pkg.insert_row

1016: -- Insert the new absence from PayMIX into per_absence_attendances
1017: -- table. All values are set to null except for the mandatory ones
1018: -- and those set up by PayMIX.
1019: --
1020: per_absence_attendances_pkg.insert_row
1021: (X_Rowid => l_row_id,
1022: X_Absence_Attendance_Id => l_absence_att_id,
1023: X_Business_Group_Id => l_business_group_id,
1024: X_Absence_Attendance_Type_Id => p_absence_att_type_id,

Line 1128: per_absence_attendances_pkg2.insert_element

1124: IF l_ele_exists_flag = 'Y' THEN
1125: --
1126: -- Insert the element entry.
1127: --
1128: per_absence_attendances_pkg2.insert_element
1129: (p_effective_start_date => l_date_start,
1130: p_effective_end_date => l_date_end,
1131: p_element_entry_id => l_element_entry_id,
1132: p_assignment_id => p_assignment_id,

Line 1307: -- per_absence_attendances table.

1303: -- ###
1304:
1305: --
1306: -- Call the absence API to insert the new absence from BEE into
1307: -- per_absence_attendances table.
1308: -- All values are set to null except for the mandatory ones
1309: -- and those set up by BEE.
1310: --
1311: hr_person_absence_api.create_person_absence

Line 1468: per_absence_attendances_pkg3.insert_abs_for_bee(

1464: end if;
1465: --
1466: hr_utility.set_location(l_proc, 20);
1467: -- Calling the absence API after validation
1468: per_absence_attendances_pkg3.insert_abs_for_bee(
1469: p_session_date => p_line_record.effective_date,
1470: p_absence_att_type_id => p_absence_att_type_id,
1471: p_absence_attendance_id => p_absence_attendance_id,
1472: p_batch_id => p_batch_id,

Line 1509: END PER_ABSENCE_ATTENDANCES_PKG3;

1505: hr_utility.set_location(' Leaving:'||l_proc, 99);
1506: --
1507: end insert_abs_for_bee;
1508: --
1509: END PER_ABSENCE_ATTENDANCES_PKG3;