DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on PER_ABSENCE_ATTENDANCES_PKG

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