APPS.HR_STD_HOL_ABS_API dependencies on HR_API

Line 97: when hr_api.cannot_find_prog_unit then

93: ,p_attribute20 => p_attribute20
94: ,p_effective_date => p_effective_date
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'CREATE_STD_HOL_ABS',
100: p_hook_type => 'BP'
101: );

Line 98: hr_api.cannot_find_prog_unit_error

94: ,p_effective_date => p_effective_date
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'CREATE_STD_HOL_ABS',
100: p_hook_type => 'BP'
101: );
102: end;

Line 175: when hr_api.cannot_find_prog_unit then

171: ,p_object_version_number => l_object_version_number
172: ,p_std_holiday_absences_id => l_std_holiday_absences_id
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'CREATE_STD_HOL_ABS',
178: p_hook_type => 'AP'
179: );

Line 176: hr_api.cannot_find_prog_unit_error

172: ,p_std_holiday_absences_id => l_std_holiday_absences_id
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'CREATE_STD_HOL_ABS',
178: p_hook_type => 'AP'
179: );
180: end;

Line 183: raise hr_api.validate_enabled;

179: );
180: end;
181: --
182: if p_validate then
183: raise hr_api.validate_enabled;
184: end if;
185: --
186: p_object_version_number := l_object_version_number;
187: p_std_holiday_absences_id := l_std_holiday_absences_id;

Line 191: when hr_api.validate_enabled then

187: p_std_holiday_absences_id := l_std_holiday_absences_id;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 11);
190: exception
191: when hr_api.validate_enabled then
192: --
193: -- As the Validate_Enabled exception has been raised
194: -- we must rollback to the savepoint
195: --

Line 225: p_date_not_taken in date default hr_api.g_date,

221: -- ----------------------------------------------------------------------------
222: --
223: procedure update_std_hol_abs
224: (p_std_holiday_absences_id in number,
225: p_date_not_taken in date default hr_api.g_date,
226: p_standard_holiday_id in number default hr_api.g_number,
227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,

Line 226: p_standard_holiday_id in number default hr_api.g_number,

222: --
223: procedure update_std_hol_abs
224: (p_std_holiday_absences_id in number,
225: p_date_not_taken in date default hr_api.g_date,
226: p_standard_holiday_id in number default hr_api.g_number,
227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 227: p_actual_date_taken in date default hr_api.g_date,

223: procedure update_std_hol_abs
224: (p_std_holiday_absences_id in number,
225: p_date_not_taken in date default hr_api.g_date,
226: p_standard_holiday_id in number default hr_api.g_number,
227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 228: p_reason in varchar2 default hr_api.g_varchar2,

224: (p_std_holiday_absences_id in number,
225: p_date_not_taken in date default hr_api.g_date,
226: p_standard_holiday_id in number default hr_api.g_number,
227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 229: p_expired in varchar2 default hr_api.g_varchar2,

225: p_date_not_taken in date default hr_api.g_date,
226: p_standard_holiday_id in number default hr_api.g_number,
227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 230: p_attribute_category in varchar2 default hr_api.g_varchar2,

226: p_standard_holiday_id in number default hr_api.g_number,
227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 231: p_attribute1 in varchar2 default hr_api.g_varchar2,

227: p_actual_date_taken in date default hr_api.g_date,
228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 232: p_attribute2 in varchar2 default hr_api.g_varchar2,

228: p_reason in varchar2 default hr_api.g_varchar2,
229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 233: p_attribute3 in varchar2 default hr_api.g_varchar2,

229: p_expired in varchar2 default hr_api.g_varchar2,
230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 234: p_attribute4 in varchar2 default hr_api.g_varchar2,

230: p_attribute_category in varchar2 default hr_api.g_varchar2,
231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 235: p_attribute5 in varchar2 default hr_api.g_varchar2,

231: p_attribute1 in varchar2 default hr_api.g_varchar2,
232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 236: p_attribute6 in varchar2 default hr_api.g_varchar2,

232: p_attribute2 in varchar2 default hr_api.g_varchar2,
233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 237: p_attribute7 in varchar2 default hr_api.g_varchar2,

233: p_attribute3 in varchar2 default hr_api.g_varchar2,
234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 238: p_attribute8 in varchar2 default hr_api.g_varchar2,

234: p_attribute4 in varchar2 default hr_api.g_varchar2,
235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 239: p_attribute9 in varchar2 default hr_api.g_varchar2,

235: p_attribute5 in varchar2 default hr_api.g_varchar2,
236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 240: p_attribute10 in varchar2 default hr_api.g_varchar2,

236: p_attribute6 in varchar2 default hr_api.g_varchar2,
237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 241: p_attribute11 in varchar2 default hr_api.g_varchar2,

237: p_attribute7 in varchar2 default hr_api.g_varchar2,
238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 242: p_attribute12 in varchar2 default hr_api.g_varchar2,

238: p_attribute8 in varchar2 default hr_api.g_varchar2,
239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 243: p_attribute13 in varchar2 default hr_api.g_varchar2,

239: p_attribute9 in varchar2 default hr_api.g_varchar2,
240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 244: p_attribute14 in varchar2 default hr_api.g_varchar2,

240: p_attribute10 in varchar2 default hr_api.g_varchar2,
241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 245: p_attribute15 in varchar2 default hr_api.g_varchar2,

241: p_attribute11 in varchar2 default hr_api.g_varchar2,
242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,
249: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 246: p_attribute16 in varchar2 default hr_api.g_varchar2,

242: p_attribute12 in varchar2 default hr_api.g_varchar2,
243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,
249: p_attribute19 in varchar2 default hr_api.g_varchar2,
250: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 247: p_attribute17 in varchar2 default hr_api.g_varchar2,

243: p_attribute13 in varchar2 default hr_api.g_varchar2,
244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,
249: p_attribute19 in varchar2 default hr_api.g_varchar2,
250: p_attribute20 in varchar2 default hr_api.g_varchar2,
251: p_object_version_number in out nocopy number,

Line 248: p_attribute18 in varchar2 default hr_api.g_varchar2,

244: p_attribute14 in varchar2 default hr_api.g_varchar2,
245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,
249: p_attribute19 in varchar2 default hr_api.g_varchar2,
250: p_attribute20 in varchar2 default hr_api.g_varchar2,
251: p_object_version_number in out nocopy number,
252: p_validate in boolean default false,

Line 249: p_attribute19 in varchar2 default hr_api.g_varchar2,

245: p_attribute15 in varchar2 default hr_api.g_varchar2,
246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,
249: p_attribute19 in varchar2 default hr_api.g_varchar2,
250: p_attribute20 in varchar2 default hr_api.g_varchar2,
251: p_object_version_number in out nocopy number,
252: p_validate in boolean default false,
253: p_effective_date in date

Line 250: p_attribute20 in varchar2 default hr_api.g_varchar2,

246: p_attribute16 in varchar2 default hr_api.g_varchar2,
247: p_attribute17 in varchar2 default hr_api.g_varchar2,
248: p_attribute18 in varchar2 default hr_api.g_varchar2,
249: p_attribute19 in varchar2 default hr_api.g_varchar2,
250: p_attribute20 in varchar2 default hr_api.g_varchar2,
251: p_object_version_number in out nocopy number,
252: p_validate in boolean default false,
253: p_effective_date in date
254: )

Line 312: when hr_api.cannot_find_prog_unit then

308: ,p_object_version_number => p_object_version_number
309: ,p_effective_date => p_effective_date
310: );
311: exception
312: when hr_api.cannot_find_prog_unit then
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'UPDATE_STD_HOL_ABS',
315: p_hook_type => 'BP'
316: );

Line 313: hr_api.cannot_find_prog_unit_error

309: ,p_effective_date => p_effective_date
310: );
311: exception
312: when hr_api.cannot_find_prog_unit then
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'UPDATE_STD_HOL_ABS',
315: p_hook_type => 'BP'
316: );
317: end;

Line 390: when hr_api.cannot_find_prog_unit then

386: ,p_object_version_number => l_object_version_number
387: ,p_effective_date => p_effective_date
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'UPDATE_STD_HOL_ABS',
393: p_hook_type => 'AP'
394: );

Line 391: hr_api.cannot_find_prog_unit_error

387: ,p_effective_date => p_effective_date
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'UPDATE_STD_HOL_ABS',
393: p_hook_type => 'AP'
394: );
395: end;

Line 403: raise hr_api.validate_enabled;

399: --
400: -- When in validation only mode raise the Validate_Enabled exception
401: --
402: if p_validate then
403: raise hr_api.validate_enabled;
404: end if;
405: --
406: p_object_version_number := l_object_version_number;
407: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 409: when hr_api.validate_enabled then

405: --
406: p_object_version_number := l_object_version_number;
407: hr_utility.set_location(' Leaving:'||l_proc, 11);
408: exception
409: when hr_api.validate_enabled then
410: --
411: -- As the Validate_Enabled exception has been raised
412: -- we must rollback to the savepoint
413: --

Line 466: when hr_api.cannot_find_prog_unit then

462: (p_std_holiday_absences_id => p_std_holiday_absences_id
463: ,p_object_version_number => p_object_version_number
464: );
465: exception
466: when hr_api.cannot_find_prog_unit then
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'DELETE_STD_HOL_ABS',
469: p_hook_type => 'BP'
470: );

Line 467: hr_api.cannot_find_prog_unit_error

463: ,p_object_version_number => p_object_version_number
464: );
465: exception
466: when hr_api.cannot_find_prog_unit then
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'DELETE_STD_HOL_ABS',
469: p_hook_type => 'BP'
470: );
471: end;

Line 488: when hr_api.cannot_find_prog_unit then

484: (p_std_holiday_absences_id => p_std_holiday_absences_id
485: ,p_object_version_number => p_object_version_number
486: );
487: exception
488: when hr_api.cannot_find_prog_unit then
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'DELETE_STD_HOL_ABS',
491: p_hook_type => 'AP'
492: );

Line 489: hr_api.cannot_find_prog_unit_error

485: ,p_object_version_number => p_object_version_number
486: );
487: exception
488: when hr_api.cannot_find_prog_unit then
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'DELETE_STD_HOL_ABS',
491: p_hook_type => 'AP'
492: );
493: end;

Line 501: raise hr_api.validate_enabled;

497: --
498: -- When in validation only mode raise the Validate_Enabled exception
499: --
500: if p_validate then
501: raise hr_api.validate_enabled;
502: end if;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 11);
505: exception

Line 506: when hr_api.validate_enabled then

502: end if;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 11);
505: exception
506: when hr_api.validate_enabled then
507: --
508: -- As the Validate_Enabled exception has been raised
509: -- we must rollback to the savepoint
510: --