APPS.PER_SHA_UPD dependencies on HR_API

Line 97: When hr_api.check_integrity_violated Then

93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then

Line 100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: When hr_api.parent_integrity_violated Then

97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then

Line 104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 105: When hr_api.unique_integrity_violated Then

101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then

Line 108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: Raise;
111: End update_dml;
112: --

Line 257: when hr_api.cannot_find_prog_unit then

253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error
259: (p_module_name => 'PER_STD_HOLIDAY_ABSENCES'
260: ,p_hook_type => 'AU'
261: );

Line 258: hr_api.cannot_find_prog_unit_error

254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error
259: (p_module_name => 'PER_STD_HOLIDAY_ABSENCES'
260: ,p_hook_type => 'AU'
261: );
262: end;

Line 324: If (p_rec.date_not_taken = hr_api.g_date) then

320: -- p_rec plsql record structure
321: -- to see if a system default is being used. If a system default
322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.date_not_taken = hr_api.g_date) then
325: p_rec.date_not_taken :=
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then

Line 328: If (p_rec.person_id = hr_api.g_number) then

324: If (p_rec.date_not_taken = hr_api.g_date) then
325: p_rec.date_not_taken :=
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then

Line 332: If (p_rec.standard_holiday_id = hr_api.g_number) then

328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then

Line 336: If (p_rec.actual_date_taken = hr_api.g_date) then

332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then

Line 340: If (p_rec.reason = hr_api.g_varchar2) then

336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then

Line 344: If (p_rec.expired = hr_api.g_varchar2) then

340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 348: If (p_rec.attribute_category = hr_api.g_varchar2) then

344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 352: If (p_rec.attribute1 = hr_api.g_varchar2) then

348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 356: If (p_rec.attribute2 = hr_api.g_varchar2) then

352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 360: If (p_rec.attribute3 = hr_api.g_varchar2) then

356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 364: If (p_rec.attribute4 = hr_api.g_varchar2) then

360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 368: If (p_rec.attribute5 = hr_api.g_varchar2) then

364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 372: If (p_rec.attribute6 = hr_api.g_varchar2) then

368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 376: If (p_rec.attribute7 = hr_api.g_varchar2) then

372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 380: If (p_rec.attribute8 = hr_api.g_varchar2) then

376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 384: If (p_rec.attribute9 = hr_api.g_varchar2) then

380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 388: If (p_rec.attribute10 = hr_api.g_varchar2) then

384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 392: If (p_rec.attribute11 = hr_api.g_varchar2) then

388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 396: If (p_rec.attribute12 = hr_api.g_varchar2) then

392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 400: If (p_rec.attribute13 = hr_api.g_varchar2) then

396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 404: If (p_rec.attribute14 = hr_api.g_varchar2) then

400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 408: If (p_rec.attribute15 = hr_api.g_varchar2) then

404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 412: If (p_rec.attribute16 = hr_api.g_varchar2) then

408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 416: If (p_rec.attribute17 = hr_api.g_varchar2) then

412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 420: If (p_rec.attribute18 = hr_api.g_varchar2) then

416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 424: If (p_rec.attribute19 = hr_api.g_varchar2) then

420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 428: If (p_rec.attribute20 = hr_api.g_varchar2) then

424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
429: p_rec.attribute20 :=
430: per_sha_shd.g_old_rec.attribute20;
431: End If;
432:

Line 487: p_date_not_taken in date default hr_api.g_date,

483: -- ----------------------------------------------------------------------------
484: Procedure upd
485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,

Line 488: p_person_id in number default hr_api.g_number,

484: Procedure upd
485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,

Line 489: p_standard_holiday_id in number default hr_api.g_number,

485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 490: p_actual_date_taken in date default hr_api.g_date,

486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 491: p_reason in varchar2 default hr_api.g_varchar2,

487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 492: p_expired in varchar2 default hr_api.g_varchar2,

488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 493: p_attribute_category in varchar2 default hr_api.g_varchar2,

489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 494: p_attribute1 in varchar2 default hr_api.g_varchar2,

490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 495: p_attribute2 in varchar2 default hr_api.g_varchar2,

491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 496: p_attribute3 in varchar2 default hr_api.g_varchar2,

492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 497: p_attribute4 in varchar2 default hr_api.g_varchar2,

493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 498: p_attribute5 in varchar2 default hr_api.g_varchar2,

494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 499: p_attribute6 in varchar2 default hr_api.g_varchar2,

495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 500: p_attribute7 in varchar2 default hr_api.g_varchar2,

496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 501: p_attribute8 in varchar2 default hr_api.g_varchar2,

497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 502: p_attribute9 in varchar2 default hr_api.g_varchar2,

498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 503: p_attribute10 in varchar2 default hr_api.g_varchar2,

499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 504: p_attribute11 in varchar2 default hr_api.g_varchar2,

500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 505: p_attribute12 in varchar2 default hr_api.g_varchar2,

501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 506: p_attribute13 in varchar2 default hr_api.g_varchar2,

502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 507: p_attribute14 in varchar2 default hr_api.g_varchar2,

503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 508: p_attribute15 in varchar2 default hr_api.g_varchar2,

504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 509: p_attribute16 in varchar2 default hr_api.g_varchar2,

505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 510: p_attribute17 in varchar2 default hr_api.g_varchar2,

506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number

Line 511: p_attribute18 in varchar2 default hr_api.g_varchar2,

507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is

Line 512: p_attribute19 in varchar2 default hr_api.g_varchar2,

508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
516: --

Line 513: p_attribute20 in varchar2 default hr_api.g_varchar2,

509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
516: --
517: l_rec per_sha_shd.g_rec_type;