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_GB_ABSENCE_EVIDENCE_SWI dependencies on HR_API

Line 31: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

27: fetch get_category_code into l_absence_category ;
28: close get_category_code ;
29:
30: IF l_absence_category = 'S' THEN
31: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
32: IF l_legislation_code = 'GB' THEN
33: hr_utility.set_location(l_proc,10);
34:
35: populate_sickness_dates := true;

Line 48: (p_validate in number default hr_api.g_false_num

44: -- ----------------------------------------------------------------------------
45: -- |--------------------< create_gb_absence_evidence >------------------------|
46: -- ----------------------------------------------------------------------------
47: PROCEDURE create_gb_absence_evidence
48: (p_validate in number default hr_api.g_false_num
49: ,p_effective_date in date default null
50: ,p_person_id in number default null
51: ,p_business_group_id in number default null
52: ,p_absence_attendance_type_id in number default null

Line 124: hr_api.constant_to_boolean

120: --
121: -- Convert constant values to their corresponding boolean value
122: --
123: l_validate :=
124: hr_api.constant_to_boolean
125: (p_constant_value => p_validate);
126:
127:
128: l_populate_sickness_dates := is_gb_leg_and_category_s(p_absence_attendance_type_id , p_business_group_id);

Line 269: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then

265: if l_error_text is null then
266: l_error_text := fnd_message.get;
267: end if;
268:
269: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
270: hr_utility.set_location(' Leaving:' || l_proc,45);
271: raise;
272: end if;
273: --

Line 284: (p_validate in number default hr_api.g_false_num

280: -- ----------------------------------------------------------------------------
281: -- |---------------------< update_gb_absence_evidence >-----------------------|
282: -- ----------------------------------------------------------------------------
283: PROCEDURE update_gb_absence_evidence
284: (p_validate in number default hr_api.g_false_num
285: ,p_effective_date in date default hr_api.g_date
286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number

Line 285: ,p_effective_date in date default hr_api.g_date

281: -- |---------------------< update_gb_absence_evidence >-----------------------|
282: -- ----------------------------------------------------------------------------
283: PROCEDURE update_gb_absence_evidence
284: (p_validate in number default hr_api.g_false_num
285: ,p_effective_date in date default hr_api.g_date
286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date

Line 286: ,p_person_id in number default hr_api.g_number

282: -- ----------------------------------------------------------------------------
283: PROCEDURE update_gb_absence_evidence
284: (p_validate in number default hr_api.g_false_num
285: ,p_effective_date in date default hr_api.g_date
286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2

Line 287: ,p_business_group_id in number default hr_api.g_number

283: PROCEDURE update_gb_absence_evidence
284: (p_validate in number default hr_api.g_false_num
285: ,p_effective_date in date default hr_api.g_date
286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number

Line 288: ,p_absence_attendance_type_id in number default hr_api.g_number

284: (p_validate in number default hr_api.g_false_num
285: ,p_effective_date in date default hr_api.g_date
286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number

Line 289: ,p_evidence_date in date default hr_api.g_date

285: ,p_effective_date in date default hr_api.g_date
286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2

Line 290: ,p_evidence_source in varchar2 default hr_api.g_varchar2

286: ,p_person_id in number default hr_api.g_number
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2

Line 291: ,p_absence_attendance_id in number default hr_api.g_number

287: ,p_business_group_id in number default hr_api.g_number
288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date

Line 292: ,p_maternity_id in number default hr_api.g_number

288: ,p_absence_attendance_type_id in number default hr_api.g_number
289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2

Line 293: ,p_medical_type in varchar2 default hr_api.g_varchar2

289: ,p_evidence_date in date default hr_api.g_date
290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2

Line 294: ,p_self_certificate in varchar2 default hr_api.g_varchar2

290: ,p_evidence_source in varchar2 default hr_api.g_varchar2
291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2

Line 295: ,p_predicted_fitness_date in date default hr_api.g_date

291: ,p_absence_attendance_id in number default hr_api.g_number
292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2

Line 296: ,p_evidence_status in varchar2 default hr_api.g_varchar2

292: ,p_maternity_id in number default hr_api.g_number
293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date

Line 297: ,p_evidence_details in varchar2 default hr_api.g_varchar2

293: ,p_medical_type in varchar2 default hr_api.g_varchar2
294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2

294: ,p_self_certificate in varchar2 default hr_api.g_varchar2
295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2

295: ,p_predicted_fitness_date in date default hr_api.g_date
296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 300: ,p_evidence_received_date in date default hr_api.g_date

296: ,p_evidence_status in varchar2 default hr_api.g_varchar2
297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 301: ,p_attribute_category in varchar2 default hr_api.g_varchar2

297: ,p_evidence_details in varchar2 default hr_api.g_varchar2
298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 302: ,p_attribute1 in varchar2 default hr_api.g_varchar2

298: ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 303: ,p_attribute2 in varchar2 default hr_api.g_varchar2

299: ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 304: ,p_attribute3 in varchar2 default hr_api.g_varchar2

300: ,p_evidence_received_date in date default hr_api.g_date
301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 305: ,p_attribute4 in varchar2 default hr_api.g_varchar2

301: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 306: ,p_attribute5 in varchar2 default hr_api.g_varchar2

302: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 307: ,p_attribute6 in varchar2 default hr_api.g_varchar2

303: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 308: ,p_attribute7 in varchar2 default hr_api.g_varchar2

304: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 309: ,p_attribute8 in varchar2 default hr_api.g_varchar2

305: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 310: ,p_attribute9 in varchar2 default hr_api.g_varchar2

306: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 311: ,p_attribute10 in varchar2 default hr_api.g_varchar2

307: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 312: ,p_attribute11 in varchar2 default hr_api.g_varchar2

308: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 313: ,p_attribute12 in varchar2 default hr_api.g_varchar2

309: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 314: ,p_attribute13 in varchar2 default hr_api.g_varchar2

310: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 315: ,p_attribute14 in varchar2 default hr_api.g_varchar2

311: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 316: ,p_attribute15 in varchar2 default hr_api.g_varchar2

312: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 317: ,p_attribute16 in varchar2 default hr_api.g_varchar2

313: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute19 in varchar2 default hr_api.g_varchar2
321: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 318: ,p_attribute17 in varchar2 default hr_api.g_varchar2

314: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute19 in varchar2 default hr_api.g_varchar2
321: ,p_attribute20 in varchar2 default hr_api.g_varchar2
322: ,p_medical_id in out nocopy number

Line 319: ,p_attribute18 in varchar2 default hr_api.g_varchar2

315: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute19 in varchar2 default hr_api.g_varchar2
321: ,p_attribute20 in varchar2 default hr_api.g_varchar2
322: ,p_medical_id in out nocopy number
323: ,p_object_version_number out nocopy number

Line 320: ,p_attribute19 in varchar2 default hr_api.g_varchar2

316: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute19 in varchar2 default hr_api.g_varchar2
321: ,p_attribute20 in varchar2 default hr_api.g_varchar2
322: ,p_medical_id in out nocopy number
323: ,p_object_version_number out nocopy number
324: ,p_return_status out nocopy varchar2

Line 321: ,p_attribute20 in varchar2 default hr_api.g_varchar2

317: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute19 in varchar2 default hr_api.g_varchar2
321: ,p_attribute20 in varchar2 default hr_api.g_varchar2
322: ,p_medical_id in out nocopy number
323: ,p_object_version_number out nocopy number
324: ,p_return_status out nocopy varchar2
325: ) is

Line 371: hr_api.constant_to_boolean

367: --
368: -- Convert constant values to their corresponding boolean value
369: --
370: l_validate :=
371: hr_api.constant_to_boolean
372: (p_constant_value => p_validate);
373:
374: hr_utility.set_location(' Stage:' || l_proc,12);
375: open c_ssp_medicals;

Line 380: if p_evidence_source <> hr_api.g_varchar2 then

376: fetch c_ssp_medicals into ssp_rec;
377:
378: if c_ssp_medicals%found then
379: hr_utility.set_location(' Stage:' || l_proc,13);
380: if p_evidence_source <> hr_api.g_varchar2 then
381: ssp_rec.evidence_source := p_evidence_source;
382: end if;
383: if p_evidence_date <> hr_api.g_date then
384: ssp_rec.evidence_date := p_evidence_date;

Line 383: if p_evidence_date <> hr_api.g_date then

379: hr_utility.set_location(' Stage:' || l_proc,13);
380: if p_evidence_source <> hr_api.g_varchar2 then
381: ssp_rec.evidence_source := p_evidence_source;
382: end if;
383: if p_evidence_date <> hr_api.g_date then
384: ssp_rec.evidence_date := p_evidence_date;
385: end if;
386: if p_evidence_received_date <> hr_api.g_date then
387: ssp_rec.evidence_received_date := p_evidence_received_date;

Line 386: if p_evidence_received_date <> hr_api.g_date then

382: end if;
383: if p_evidence_date <> hr_api.g_date then
384: ssp_rec.evidence_date := p_evidence_date;
385: end if;
386: if p_evidence_received_date <> hr_api.g_date then
387: ssp_rec.evidence_received_date := p_evidence_received_date;
388: end if;
389: if p_predicted_fitness_date <> hr_api.g_date then
390: ssp_rec.predicted_fitness_date := p_predicted_fitness_date;

Line 389: if p_predicted_fitness_date <> hr_api.g_date then

385: end if;
386: if p_evidence_received_date <> hr_api.g_date then
387: ssp_rec.evidence_received_date := p_evidence_received_date;
388: end if;
389: if p_predicted_fitness_date <> hr_api.g_date then
390: ssp_rec.predicted_fitness_date := p_predicted_fitness_date;
391: end if;
392: if p_evidence_details <> hr_api.g_varchar2 then
393: ssp_rec.evidence_details := p_evidence_details;

Line 392: if p_evidence_details <> hr_api.g_varchar2 then

388: end if;
389: if p_predicted_fitness_date <> hr_api.g_date then
390: ssp_rec.predicted_fitness_date := p_predicted_fitness_date;
391: end if;
392: if p_evidence_details <> hr_api.g_varchar2 then
393: ssp_rec.evidence_details := p_evidence_details;
394: end if;
395: if p_evidence_status <> hr_api.g_varchar2 then
396: ssp_rec.evidence_status := p_evidence_status;

Line 395: if p_evidence_status <> hr_api.g_varchar2 then

391: end if;
392: if p_evidence_details <> hr_api.g_varchar2 then
393: ssp_rec.evidence_details := p_evidence_details;
394: end if;
395: if p_evidence_status <> hr_api.g_varchar2 then
396: ssp_rec.evidence_status := p_evidence_status;
397: end if;
398: if p_self_certificate <> hr_api.g_varchar2 then
399: ssp_rec.self_certificate := p_self_certificate;

Line 398: if p_self_certificate <> hr_api.g_varchar2 then

394: end if;
395: if p_evidence_status <> hr_api.g_varchar2 then
396: ssp_rec.evidence_status := p_evidence_status;
397: end if;
398: if p_self_certificate <> hr_api.g_varchar2 then
399: ssp_rec.self_certificate := p_self_certificate;
400: end if;
401: if p_attribute_category <> hr_api.g_varchar2 then
402: ssp_rec.attribute_category := p_attribute_category;

Line 401: if p_attribute_category <> hr_api.g_varchar2 then

397: end if;
398: if p_self_certificate <> hr_api.g_varchar2 then
399: ssp_rec.self_certificate := p_self_certificate;
400: end if;
401: if p_attribute_category <> hr_api.g_varchar2 then
402: ssp_rec.attribute_category := p_attribute_category;
403: end if;
404: if p_attribute1 <> hr_api.g_varchar2 then
405: ssp_rec.attribute1 := p_attribute1;

Line 404: if p_attribute1 <> hr_api.g_varchar2 then

400: end if;
401: if p_attribute_category <> hr_api.g_varchar2 then
402: ssp_rec.attribute_category := p_attribute_category;
403: end if;
404: if p_attribute1 <> hr_api.g_varchar2 then
405: ssp_rec.attribute1 := p_attribute1;
406: end if;
407: if p_attribute2 <> hr_api.g_varchar2 then
408: ssp_rec.attribute2 := p_attribute2;

Line 407: if p_attribute2 <> hr_api.g_varchar2 then

403: end if;
404: if p_attribute1 <> hr_api.g_varchar2 then
405: ssp_rec.attribute1 := p_attribute1;
406: end if;
407: if p_attribute2 <> hr_api.g_varchar2 then
408: ssp_rec.attribute2 := p_attribute2;
409: end if;
410: if p_attribute3 <> hr_api.g_varchar2 then
411: ssp_rec.attribute3 := p_attribute3;

Line 410: if p_attribute3 <> hr_api.g_varchar2 then

406: end if;
407: if p_attribute2 <> hr_api.g_varchar2 then
408: ssp_rec.attribute2 := p_attribute2;
409: end if;
410: if p_attribute3 <> hr_api.g_varchar2 then
411: ssp_rec.attribute3 := p_attribute3;
412: end if;
413: if p_attribute4 <> hr_api.g_varchar2 then
414: ssp_rec.attribute4 := p_attribute4;

Line 413: if p_attribute4 <> hr_api.g_varchar2 then

409: end if;
410: if p_attribute3 <> hr_api.g_varchar2 then
411: ssp_rec.attribute3 := p_attribute3;
412: end if;
413: if p_attribute4 <> hr_api.g_varchar2 then
414: ssp_rec.attribute4 := p_attribute4;
415: end if;
416: if p_attribute5 <> hr_api.g_varchar2 then
417: ssp_rec.attribute5 := p_attribute5;

Line 416: if p_attribute5 <> hr_api.g_varchar2 then

412: end if;
413: if p_attribute4 <> hr_api.g_varchar2 then
414: ssp_rec.attribute4 := p_attribute4;
415: end if;
416: if p_attribute5 <> hr_api.g_varchar2 then
417: ssp_rec.attribute5 := p_attribute5;
418: end if;
419: if p_attribute6 <> hr_api.g_varchar2 then
420: ssp_rec.attribute6 := p_attribute6;

Line 419: if p_attribute6 <> hr_api.g_varchar2 then

415: end if;
416: if p_attribute5 <> hr_api.g_varchar2 then
417: ssp_rec.attribute5 := p_attribute5;
418: end if;
419: if p_attribute6 <> hr_api.g_varchar2 then
420: ssp_rec.attribute6 := p_attribute6;
421: end if;
422: if p_attribute7 <> hr_api.g_varchar2 then
423: ssp_rec.attribute7 := p_attribute7;

Line 422: if p_attribute7 <> hr_api.g_varchar2 then

418: end if;
419: if p_attribute6 <> hr_api.g_varchar2 then
420: ssp_rec.attribute6 := p_attribute6;
421: end if;
422: if p_attribute7 <> hr_api.g_varchar2 then
423: ssp_rec.attribute7 := p_attribute7;
424: end if;
425: if p_attribute8 <> hr_api.g_varchar2 then
426: ssp_rec.attribute8 := p_attribute8;

Line 425: if p_attribute8 <> hr_api.g_varchar2 then

421: end if;
422: if p_attribute7 <> hr_api.g_varchar2 then
423: ssp_rec.attribute7 := p_attribute7;
424: end if;
425: if p_attribute8 <> hr_api.g_varchar2 then
426: ssp_rec.attribute8 := p_attribute8;
427: end if;
428: if p_attribute9 <> hr_api.g_varchar2 then
429: ssp_rec.attribute9 := p_attribute9;

Line 428: if p_attribute9 <> hr_api.g_varchar2 then

424: end if;
425: if p_attribute8 <> hr_api.g_varchar2 then
426: ssp_rec.attribute8 := p_attribute8;
427: end if;
428: if p_attribute9 <> hr_api.g_varchar2 then
429: ssp_rec.attribute9 := p_attribute9;
430: end if;
431: if p_attribute10 <> hr_api.g_varchar2 then
432: ssp_rec.attribute10 := p_attribute10;

Line 431: if p_attribute10 <> hr_api.g_varchar2 then

427: end if;
428: if p_attribute9 <> hr_api.g_varchar2 then
429: ssp_rec.attribute9 := p_attribute9;
430: end if;
431: if p_attribute10 <> hr_api.g_varchar2 then
432: ssp_rec.attribute10 := p_attribute10;
433: end if;
434: if p_attribute11 <> hr_api.g_varchar2 then
435: ssp_rec.attribute11 := p_attribute11;

Line 434: if p_attribute11 <> hr_api.g_varchar2 then

430: end if;
431: if p_attribute10 <> hr_api.g_varchar2 then
432: ssp_rec.attribute10 := p_attribute10;
433: end if;
434: if p_attribute11 <> hr_api.g_varchar2 then
435: ssp_rec.attribute11 := p_attribute11;
436: end if;
437: if p_attribute12 <> hr_api.g_varchar2 then
438: ssp_rec.attribute12 := p_attribute12;

Line 437: if p_attribute12 <> hr_api.g_varchar2 then

433: end if;
434: if p_attribute11 <> hr_api.g_varchar2 then
435: ssp_rec.attribute11 := p_attribute11;
436: end if;
437: if p_attribute12 <> hr_api.g_varchar2 then
438: ssp_rec.attribute12 := p_attribute12;
439: end if;
440: if p_attribute13 <> hr_api.g_varchar2 then
441: ssp_rec.attribute13 := p_attribute13;

Line 440: if p_attribute13 <> hr_api.g_varchar2 then

436: end if;
437: if p_attribute12 <> hr_api.g_varchar2 then
438: ssp_rec.attribute12 := p_attribute12;
439: end if;
440: if p_attribute13 <> hr_api.g_varchar2 then
441: ssp_rec.attribute13 := p_attribute13;
442: end if;
443: if p_attribute14 <> hr_api.g_varchar2 then
444: ssp_rec.attribute14 := p_attribute14;

Line 443: if p_attribute14 <> hr_api.g_varchar2 then

439: end if;
440: if p_attribute13 <> hr_api.g_varchar2 then
441: ssp_rec.attribute13 := p_attribute13;
442: end if;
443: if p_attribute14 <> hr_api.g_varchar2 then
444: ssp_rec.attribute14 := p_attribute14;
445: end if;
446: if p_attribute15 <> hr_api.g_varchar2 then
447: ssp_rec.attribute15 := p_attribute15;

Line 446: if p_attribute15 <> hr_api.g_varchar2 then

442: end if;
443: if p_attribute14 <> hr_api.g_varchar2 then
444: ssp_rec.attribute14 := p_attribute14;
445: end if;
446: if p_attribute15 <> hr_api.g_varchar2 then
447: ssp_rec.attribute15 := p_attribute15;
448: end if;
449: if p_attribute16 <> hr_api.g_varchar2 then
450: ssp_rec.attribute16 := p_attribute16;

Line 449: if p_attribute16 <> hr_api.g_varchar2 then

445: end if;
446: if p_attribute15 <> hr_api.g_varchar2 then
447: ssp_rec.attribute15 := p_attribute15;
448: end if;
449: if p_attribute16 <> hr_api.g_varchar2 then
450: ssp_rec.attribute16 := p_attribute16;
451: end if;
452: if p_attribute17 <> hr_api.g_varchar2 then
453: ssp_rec.attribute17 := p_attribute17;

Line 452: if p_attribute17 <> hr_api.g_varchar2 then

448: end if;
449: if p_attribute16 <> hr_api.g_varchar2 then
450: ssp_rec.attribute16 := p_attribute16;
451: end if;
452: if p_attribute17 <> hr_api.g_varchar2 then
453: ssp_rec.attribute17 := p_attribute17;
454: end if;
455: if p_attribute18 <> hr_api.g_varchar2 then
456: ssp_rec.attribute18 := p_attribute18;

Line 455: if p_attribute18 <> hr_api.g_varchar2 then

451: end if;
452: if p_attribute17 <> hr_api.g_varchar2 then
453: ssp_rec.attribute17 := p_attribute17;
454: end if;
455: if p_attribute18 <> hr_api.g_varchar2 then
456: ssp_rec.attribute18 := p_attribute18;
457: end if;
458: if p_attribute19 <> hr_api.g_varchar2 then
459: ssp_rec.attribute19 := p_attribute19;

Line 458: if p_attribute19 <> hr_api.g_varchar2 then

454: end if;
455: if p_attribute18 <> hr_api.g_varchar2 then
456: ssp_rec.attribute18 := p_attribute18;
457: end if;
458: if p_attribute19 <> hr_api.g_varchar2 then
459: ssp_rec.attribute19 := p_attribute19;
460: end if;
461: if p_attribute20 <> hr_api.g_varchar2 then
462: ssp_rec.attribute20 := p_attribute20;

Line 461: if p_attribute20 <> hr_api.g_varchar2 then

457: end if;
458: if p_attribute19 <> hr_api.g_varchar2 then
459: ssp_rec.attribute19 := p_attribute19;
460: end if;
461: if p_attribute20 <> hr_api.g_varchar2 then
462: ssp_rec.attribute20 := p_attribute20;
463: end if;
464: end if;
465: close c_ssp_medicals;

Line 549: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then

545: if l_error_text is null then
546: l_error_text := fnd_message.get;
547: end if;
548:
549: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
550: hr_utility.set_location(' Leaving:' || l_proc,45);
551: raise;
552: end if;
553:

Line 561: (p_validate in number default hr_api.g_false_num

557: -- ----------------------------------------------------------------------------
558: -- |----------------------< delete_gb_absence_evidence >----------------------|
559: -- ----------------------------------------------------------------------------
560: PROCEDURE delete_gb_absence_evidence
561: (p_validate in number default hr_api.g_false_num
562: ,p_absence_attendance_id in number
563: ,p_medical_id in number
564: ,p_object_version_number in number
565: ,p_return_status out nocopy varchar2

Line 594: hr_api.constant_to_boolean

590: --
591: -- Convert constant values to their corresponding boolean value
592: --
593: l_validate :=
594: hr_api.constant_to_boolean
595: (p_constant_value => p_validate);
596: --
597: if not(l_validate) then
598: delete from ssp_medicals where medical_id = p_medical_id;

Line 652: ,p_validate in number default hr_api.g_false_num

648:
649: Procedure process_api
650: ( p_document in CLOB
651: ,p_return_status out nocopy VARCHAR2
652: ,p_validate in number default hr_api.g_false_num
653: ,p_effective_date in date default null
654: )
655: IS
656: l_postState VARCHAR2(2);