25: --
26: -- {End of comments}
27: -- ----------------------------------------------------------------------------
28: PROCEDURE create_gb_absence_evidence
29: (p_validate in number default hr_api.g_false_num
30: ,p_effective_date in date default null
31: ,p_person_id in number default null
32: ,p_business_group_id in number default null
33: ,p_absence_attendance_type_id in number default null
91: --
92: -- {End of comments}
93: -- ----------------------------------------------------------------------------
94: PROCEDURE update_gb_absence_evidence
95: (p_validate in number default hr_api.g_false_num
96: ,p_effective_date in date default hr_api.g_date
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
92: -- {End of comments}
93: -- ----------------------------------------------------------------------------
94: PROCEDURE update_gb_absence_evidence
95: (p_validate in number default hr_api.g_false_num
96: ,p_effective_date in date default hr_api.g_date
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
93: -- ----------------------------------------------------------------------------
94: PROCEDURE update_gb_absence_evidence
95: (p_validate in number default hr_api.g_false_num
96: ,p_effective_date in date default hr_api.g_date
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
94: PROCEDURE update_gb_absence_evidence
95: (p_validate in number default hr_api.g_false_num
96: ,p_effective_date in date default hr_api.g_date
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
95: (p_validate in number default hr_api.g_false_num
96: ,p_effective_date in date default hr_api.g_date
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
96: ,p_effective_date in date default hr_api.g_date
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
97: ,p_person_id in number default hr_api.g_number
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
98: ,p_business_group_id in number default hr_api.g_number
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
99: ,p_absence_attendance_type_id in number default hr_api.g_number
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
100: ,p_evidence_date in date default hr_api.g_date
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
101: ,p_evidence_source in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
102: ,p_absence_attendance_id in number default hr_api.g_number
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
103: ,p_maternity_id in number default hr_api.g_number
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
104: ,p_medical_type in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
105: ,p_self_certificate in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
106: ,p_predicted_fitness_date in date default hr_api.g_date
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
107: ,p_evidence_status in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
108: ,p_evidence_details in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
109: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
110: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
111: ,p_evidence_received_date in date default hr_api.g_date
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
112: ,p_attribute_category in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
113: ,p_attribute1 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
114: ,p_attribute2 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
115: ,p_attribute3 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
116: ,p_attribute4 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
117: ,p_attribute5 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
118: ,p_attribute6 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
119: ,p_attribute7 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
120: ,p_attribute8 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
121: ,p_attribute9 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
122: ,p_attribute10 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
123: ,p_attribute11 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
131: ,p_attribute19 in varchar2 default hr_api.g_varchar2
124: ,p_attribute12 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
131: ,p_attribute19 in varchar2 default hr_api.g_varchar2
132: ,p_attribute20 in varchar2 default hr_api.g_varchar2
125: ,p_attribute13 in varchar2 default hr_api.g_varchar2
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
131: ,p_attribute19 in varchar2 default hr_api.g_varchar2
132: ,p_attribute20 in varchar2 default hr_api.g_varchar2
133: ,p_medical_id in out nocopy number
126: ,p_attribute14 in varchar2 default hr_api.g_varchar2
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
131: ,p_attribute19 in varchar2 default hr_api.g_varchar2
132: ,p_attribute20 in varchar2 default hr_api.g_varchar2
133: ,p_medical_id in out nocopy number
134: ,p_object_version_number out nocopy number
127: ,p_attribute15 in varchar2 default hr_api.g_varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
131: ,p_attribute19 in varchar2 default hr_api.g_varchar2
132: ,p_attribute20 in varchar2 default hr_api.g_varchar2
133: ,p_medical_id in out nocopy number
134: ,p_object_version_number out nocopy number
135: ,p_return_status out nocopy varchar2
128: ,p_attribute16 in varchar2 default hr_api.g_varchar2
129: ,p_attribute17 in varchar2 default hr_api.g_varchar2
130: ,p_attribute18 in varchar2 default hr_api.g_varchar2
131: ,p_attribute19 in varchar2 default hr_api.g_varchar2
132: ,p_attribute20 in varchar2 default hr_api.g_varchar2
133: ,p_medical_id in out nocopy number
134: ,p_object_version_number out nocopy number
135: ,p_return_status out nocopy varchar2
136: ) ;
157: --
158: -- {End of comments}
159: -- ----------------------------------------------------------------------------
160: PROCEDURE delete_gb_absence_evidence
161: (p_validate in number default hr_api.g_false_num
162: ,p_absence_attendance_id in number
163: ,p_medical_id in number
164: ,p_object_version_number in number
165: ,p_return_status out nocopy varchar2
171: -- {Start of comments}
172: --
173: -- Description:
174: -- This procedure is responsible for commiting data from transaction
175: -- table (hr_api_transaction_step_id) to the base table
176: --
177: -- Parameters:
178: -- p_document is the document having the data that needs to be committed
179: -- p_return_status is the return status after committing the date. In case of
189:
190: Procedure process_api
191: ( p_document in CLOB
192: ,p_return_status out nocopy VARCHAR2
193: ,p_validate in number default hr_api.g_false_num
194: ,p_effective_date in date default null
195: );
196:
197: end PER_GB_ABSENCE_EVIDENCE_SWI;