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.
PACKAGE: APPS.PER_ABSENCE_RECORD

Source


1 PACKAGE per_absence_record AUTHID CURRENT_USER AS
2 /* $Header: peabsqry.pkh 120.0.12010000.4 2009/01/22 09:44:06 srgnanas noship $ */
3 /*#
4 * This is the source file to query absence details
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname PER_EMPLOYEE_ABSENCE
8 */
9 TYPE absence_rectype IS RECORD
10 	(
11 	absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE,
12 	business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13 	absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14 	abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15 	person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16 	authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17 	replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18 	period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19 	absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20 	absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21 	comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22 	date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23 	date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24 	date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25 	date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26 	date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27 	occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28 	ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29 	time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30 	time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31 	time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32 	time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33 	request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34 	program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35 	program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36 	program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37 	attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38 	attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39 	attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40 	attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41 	attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42 	attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43 	attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44 	attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45 	attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46 	attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47 	attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48 	attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49 	attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50 	attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51 	attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52 	attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53 	attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54 	attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55 	attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56 	attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57 	attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58 	last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59 	last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60 	last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61 	created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62 	creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63 	object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64 	c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65 	element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66 	absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67 	category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68 	hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69 	value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70 	increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71 	value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72 	c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73 	abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74 	abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75 	c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76 	c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77 	c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78 	c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79 	c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80 	linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81 	sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82 	sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83 	accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84 	reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85 	pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86 	maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87 	smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88 	abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89 	abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90 	abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91 	abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92 	abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93 	abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94 	abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95 	abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96 	abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97 	abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98 	abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99 	abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100 	abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101 	abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102 	abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103 	abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104 	abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105 	abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106 	abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107 	abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108 	abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109 	abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110 	abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111 	abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112 	abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113 	abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114 	abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115 	abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116 	abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117 	abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118 	abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119 	approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120 	confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121 	source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122 	advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
123 	absence_case_id PER_ABSENCE_ATTENDANCES_V.absence_case_id%TYPE
124 	);
125 
126 TYPE absence_tabletype IS TABLE OF absence_rectype NOT NULL;
127 
128 TYPE    absence_input_rectype IS RECORD
129     (
130         person_id                     PER_ABSENCE_ATTENDANCES_V.person_id%TYPE    DEFAULT NULL,
131         start_person_id               PER_ABSENCE_ATTENDANCES_V.person_id%TYPE    DEFAULT NULL,
132         end_person_id                 PER_ABSENCE_ATTENDANCES_V.person_id%TYPE    DEFAULT NULL,
133         absence_attendance_id         PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE DEFAULT NULL
134     );
135 
136 /*#
137 * This is procedure for querying absence details.
138 * @rep:displayname Get Absence Details
139 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ABSENCE
140 * @rep:scope public
141 * @rep:lifecycle active
142 */
143 PROCEDURE get_absence_details( p_query_options  IN  absence_input_rectype,
144                                p_absences       OUT NOCOPY absence_tabletype);
145 END per_absence_record;