APPS.PER_CHK_UPD dependencies on HR_API

Line 117: When hr_api.check_integrity_violated Then

113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error

Line 122: When hr_api.parent_integrity_violated Then

118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error

Line 127: When hr_api.unique_integrity_violated Then

123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_chk_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;
135: End update_dml;

Line 308: when hr_api.cannot_find_prog_unit then

304: );
305: --
306: exception
307: --
308: when hr_api.cannot_find_prog_unit then
309: --
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'per_checklist_items'
312: ,p_hook_type => 'AU');

Line 310: hr_api.cannot_find_prog_unit_error

306: exception
307: --
308: when hr_api.cannot_find_prog_unit then
309: --
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'per_checklist_items'
312: ,p_hook_type => 'AU');
313: --
314: end;

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

374: -- p_rec plsql record structure
375: -- to see if a system default is being used. If a system default
376: -- is being used then we must set to the 'current' argument value.
377: --
378: If (p_rec.person_id = hr_api.g_number) then
379: p_rec.person_id :=
380: per_chk_shd.g_old_rec.person_id;
381: End If;
382: If (p_rec.item_code = hr_api.g_varchar2) then

Line 382: If (p_rec.item_code = hr_api.g_varchar2) then

378: If (p_rec.person_id = hr_api.g_number) then
379: p_rec.person_id :=
380: per_chk_shd.g_old_rec.person_id;
381: End If;
382: If (p_rec.item_code = hr_api.g_varchar2) then
383: p_rec.item_code :=
384: per_chk_shd.g_old_rec.item_code;
385: End If;
386: If (p_rec.date_due = hr_api.g_date) then

Line 386: If (p_rec.date_due = hr_api.g_date) then

382: If (p_rec.item_code = hr_api.g_varchar2) then
383: p_rec.item_code :=
384: per_chk_shd.g_old_rec.item_code;
385: End If;
386: If (p_rec.date_due = hr_api.g_date) then
387: p_rec.date_due :=
388: per_chk_shd.g_old_rec.date_due;
389: End If;
390: If (p_rec.date_done = hr_api.g_date) then

Line 390: If (p_rec.date_done = hr_api.g_date) then

386: If (p_rec.date_due = hr_api.g_date) then
387: p_rec.date_due :=
388: per_chk_shd.g_old_rec.date_due;
389: End If;
390: If (p_rec.date_done = hr_api.g_date) then
391: p_rec.date_done :=
392: per_chk_shd.g_old_rec.date_done;
393: End If;
394: If (p_rec.status = hr_api.g_varchar2) then

Line 394: If (p_rec.status = hr_api.g_varchar2) then

390: If (p_rec.date_done = hr_api.g_date) then
391: p_rec.date_done :=
392: per_chk_shd.g_old_rec.date_done;
393: End If;
394: If (p_rec.status = hr_api.g_varchar2) then
395: p_rec.status :=
396: per_chk_shd.g_old_rec.status;
397: End If;
398: If (p_rec.notes = hr_api.g_varchar2) then

Line 398: If (p_rec.notes = hr_api.g_varchar2) then

394: If (p_rec.status = hr_api.g_varchar2) then
395: p_rec.status :=
396: per_chk_shd.g_old_rec.status;
397: End If;
398: If (p_rec.notes = hr_api.g_varchar2) then
399: p_rec.notes :=
400: per_chk_shd.g_old_rec.notes;
401: End If;
402: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

398: If (p_rec.notes = hr_api.g_varchar2) then
399: p_rec.notes :=
400: per_chk_shd.g_old_rec.notes;
401: End If;
402: If (p_rec.attribute_category = hr_api.g_varchar2) then
403: p_rec.attribute_category :=
404: per_chk_shd.g_old_rec.attribute_category;
405: End If;
406: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

402: If (p_rec.attribute_category = hr_api.g_varchar2) then
403: p_rec.attribute_category :=
404: per_chk_shd.g_old_rec.attribute_category;
405: End If;
406: If (p_rec.attribute1 = hr_api.g_varchar2) then
407: p_rec.attribute1 :=
408: per_chk_shd.g_old_rec.attribute1;
409: End If;
410: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

406: If (p_rec.attribute1 = hr_api.g_varchar2) then
407: p_rec.attribute1 :=
408: per_chk_shd.g_old_rec.attribute1;
409: End If;
410: If (p_rec.attribute2 = hr_api.g_varchar2) then
411: p_rec.attribute2 :=
412: per_chk_shd.g_old_rec.attribute2;
413: End If;
414: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

410: If (p_rec.attribute2 = hr_api.g_varchar2) then
411: p_rec.attribute2 :=
412: per_chk_shd.g_old_rec.attribute2;
413: End If;
414: If (p_rec.attribute3 = hr_api.g_varchar2) then
415: p_rec.attribute3 :=
416: per_chk_shd.g_old_rec.attribute3;
417: End If;
418: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

414: If (p_rec.attribute3 = hr_api.g_varchar2) then
415: p_rec.attribute3 :=
416: per_chk_shd.g_old_rec.attribute3;
417: End If;
418: If (p_rec.attribute4 = hr_api.g_varchar2) then
419: p_rec.attribute4 :=
420: per_chk_shd.g_old_rec.attribute4;
421: End If;
422: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

418: If (p_rec.attribute4 = hr_api.g_varchar2) then
419: p_rec.attribute4 :=
420: per_chk_shd.g_old_rec.attribute4;
421: End If;
422: If (p_rec.attribute5 = hr_api.g_varchar2) then
423: p_rec.attribute5 :=
424: per_chk_shd.g_old_rec.attribute5;
425: End If;
426: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

422: If (p_rec.attribute5 = hr_api.g_varchar2) then
423: p_rec.attribute5 :=
424: per_chk_shd.g_old_rec.attribute5;
425: End If;
426: If (p_rec.attribute6 = hr_api.g_varchar2) then
427: p_rec.attribute6 :=
428: per_chk_shd.g_old_rec.attribute6;
429: End If;
430: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

426: If (p_rec.attribute6 = hr_api.g_varchar2) then
427: p_rec.attribute6 :=
428: per_chk_shd.g_old_rec.attribute6;
429: End If;
430: If (p_rec.attribute7 = hr_api.g_varchar2) then
431: p_rec.attribute7 :=
432: per_chk_shd.g_old_rec.attribute7;
433: End If;
434: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

430: If (p_rec.attribute7 = hr_api.g_varchar2) then
431: p_rec.attribute7 :=
432: per_chk_shd.g_old_rec.attribute7;
433: End If;
434: If (p_rec.attribute8 = hr_api.g_varchar2) then
435: p_rec.attribute8 :=
436: per_chk_shd.g_old_rec.attribute8;
437: End If;
438: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

434: If (p_rec.attribute8 = hr_api.g_varchar2) then
435: p_rec.attribute8 :=
436: per_chk_shd.g_old_rec.attribute8;
437: End If;
438: If (p_rec.attribute9 = hr_api.g_varchar2) then
439: p_rec.attribute9 :=
440: per_chk_shd.g_old_rec.attribute9;
441: End If;
442: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

438: If (p_rec.attribute9 = hr_api.g_varchar2) then
439: p_rec.attribute9 :=
440: per_chk_shd.g_old_rec.attribute9;
441: End If;
442: If (p_rec.attribute10 = hr_api.g_varchar2) then
443: p_rec.attribute10 :=
444: per_chk_shd.g_old_rec.attribute10;
445: End If;
446: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

442: If (p_rec.attribute10 = hr_api.g_varchar2) then
443: p_rec.attribute10 :=
444: per_chk_shd.g_old_rec.attribute10;
445: End If;
446: If (p_rec.attribute11 = hr_api.g_varchar2) then
447: p_rec.attribute11 :=
448: per_chk_shd.g_old_rec.attribute11;
449: End If;
450: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

446: If (p_rec.attribute11 = hr_api.g_varchar2) then
447: p_rec.attribute11 :=
448: per_chk_shd.g_old_rec.attribute11;
449: End If;
450: If (p_rec.attribute12 = hr_api.g_varchar2) then
451: p_rec.attribute12 :=
452: per_chk_shd.g_old_rec.attribute12;
453: End If;
454: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

450: If (p_rec.attribute12 = hr_api.g_varchar2) then
451: p_rec.attribute12 :=
452: per_chk_shd.g_old_rec.attribute12;
453: End If;
454: If (p_rec.attribute13 = hr_api.g_varchar2) then
455: p_rec.attribute13 :=
456: per_chk_shd.g_old_rec.attribute13;
457: End If;
458: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

454: If (p_rec.attribute13 = hr_api.g_varchar2) then
455: p_rec.attribute13 :=
456: per_chk_shd.g_old_rec.attribute13;
457: End If;
458: If (p_rec.attribute14 = hr_api.g_varchar2) then
459: p_rec.attribute14 :=
460: per_chk_shd.g_old_rec.attribute14;
461: End If;
462: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

458: If (p_rec.attribute14 = hr_api.g_varchar2) then
459: p_rec.attribute14 :=
460: per_chk_shd.g_old_rec.attribute14;
461: End If;
462: If (p_rec.attribute15 = hr_api.g_varchar2) then
463: p_rec.attribute15 :=
464: per_chk_shd.g_old_rec.attribute15;
465: End If;
466: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

462: If (p_rec.attribute15 = hr_api.g_varchar2) then
463: p_rec.attribute15 :=
464: per_chk_shd.g_old_rec.attribute15;
465: End If;
466: If (p_rec.attribute16 = hr_api.g_varchar2) then
467: p_rec.attribute16 :=
468: per_chk_shd.g_old_rec.attribute16;
469: End If;
470: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

466: If (p_rec.attribute16 = hr_api.g_varchar2) then
467: p_rec.attribute16 :=
468: per_chk_shd.g_old_rec.attribute16;
469: End If;
470: If (p_rec.attribute17 = hr_api.g_varchar2) then
471: p_rec.attribute17 :=
472: per_chk_shd.g_old_rec.attribute17;
473: End If;
474: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

470: If (p_rec.attribute17 = hr_api.g_varchar2) then
471: p_rec.attribute17 :=
472: per_chk_shd.g_old_rec.attribute17;
473: End If;
474: If (p_rec.attribute18 = hr_api.g_varchar2) then
475: p_rec.attribute18 :=
476: per_chk_shd.g_old_rec.attribute18;
477: End If;
478: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

474: If (p_rec.attribute18 = hr_api.g_varchar2) then
475: p_rec.attribute18 :=
476: per_chk_shd.g_old_rec.attribute18;
477: End If;
478: If (p_rec.attribute19 = hr_api.g_varchar2) then
479: p_rec.attribute19 :=
480: per_chk_shd.g_old_rec.attribute19;
481: End If;
482: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

478: If (p_rec.attribute19 = hr_api.g_varchar2) then
479: p_rec.attribute19 :=
480: per_chk_shd.g_old_rec.attribute19;
481: End If;
482: If (p_rec.attribute20 = hr_api.g_varchar2) then
483: p_rec.attribute20 :=
484: per_chk_shd.g_old_rec.attribute20;
485: End If;
486: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 486: If (p_rec.attribute21 = hr_api.g_varchar2) then

482: If (p_rec.attribute20 = hr_api.g_varchar2) then
483: p_rec.attribute20 :=
484: per_chk_shd.g_old_rec.attribute20;
485: End If;
486: If (p_rec.attribute21 = hr_api.g_varchar2) then
487: p_rec.attribute21 :=
488: per_chk_shd.g_old_rec.attribute21;
489: End If;
490: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 490: If (p_rec.attribute22 = hr_api.g_varchar2) then

486: If (p_rec.attribute21 = hr_api.g_varchar2) then
487: p_rec.attribute21 :=
488: per_chk_shd.g_old_rec.attribute21;
489: End If;
490: If (p_rec.attribute22 = hr_api.g_varchar2) then
491: p_rec.attribute22 :=
492: per_chk_shd.g_old_rec.attribute22;
493: End If;
494: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 494: If (p_rec.attribute23 = hr_api.g_varchar2) then

490: If (p_rec.attribute22 = hr_api.g_varchar2) then
491: p_rec.attribute22 :=
492: per_chk_shd.g_old_rec.attribute22;
493: End If;
494: If (p_rec.attribute23 = hr_api.g_varchar2) then
495: p_rec.attribute23 :=
496: per_chk_shd.g_old_rec.attribute23;
497: End If;
498: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 498: If (p_rec.attribute24 = hr_api.g_varchar2) then

494: If (p_rec.attribute23 = hr_api.g_varchar2) then
495: p_rec.attribute23 :=
496: per_chk_shd.g_old_rec.attribute23;
497: End If;
498: If (p_rec.attribute24 = hr_api.g_varchar2) then
499: p_rec.attribute24 :=
500: per_chk_shd.g_old_rec.attribute24;
501: End If;
502: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 502: If (p_rec.attribute25 = hr_api.g_varchar2) then

498: If (p_rec.attribute24 = hr_api.g_varchar2) then
499: p_rec.attribute24 :=
500: per_chk_shd.g_old_rec.attribute24;
501: End If;
502: If (p_rec.attribute25 = hr_api.g_varchar2) then
503: p_rec.attribute25 :=
504: per_chk_shd.g_old_rec.attribute25;
505: End If;
506: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 506: If (p_rec.attribute26 = hr_api.g_varchar2) then

502: If (p_rec.attribute25 = hr_api.g_varchar2) then
503: p_rec.attribute25 :=
504: per_chk_shd.g_old_rec.attribute25;
505: End If;
506: If (p_rec.attribute26 = hr_api.g_varchar2) then
507: p_rec.attribute26 :=
508: per_chk_shd.g_old_rec.attribute26;
509: End If;
510: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 510: If (p_rec.attribute27 = hr_api.g_varchar2) then

506: If (p_rec.attribute26 = hr_api.g_varchar2) then
507: p_rec.attribute26 :=
508: per_chk_shd.g_old_rec.attribute26;
509: End If;
510: If (p_rec.attribute27 = hr_api.g_varchar2) then
511: p_rec.attribute27 :=
512: per_chk_shd.g_old_rec.attribute27;
513: End If;
514: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 514: If (p_rec.attribute28 = hr_api.g_varchar2) then

510: If (p_rec.attribute27 = hr_api.g_varchar2) then
511: p_rec.attribute27 :=
512: per_chk_shd.g_old_rec.attribute27;
513: End If;
514: If (p_rec.attribute28 = hr_api.g_varchar2) then
515: p_rec.attribute28 :=
516: per_chk_shd.g_old_rec.attribute28;
517: End If;
518: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 518: If (p_rec.attribute29 = hr_api.g_varchar2) then

514: If (p_rec.attribute28 = hr_api.g_varchar2) then
515: p_rec.attribute28 :=
516: per_chk_shd.g_old_rec.attribute28;
517: End If;
518: If (p_rec.attribute29 = hr_api.g_varchar2) then
519: p_rec.attribute29 :=
520: per_chk_shd.g_old_rec.attribute29;
521: End If;
522: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 522: If (p_rec.attribute30 = hr_api.g_varchar2) then

518: If (p_rec.attribute29 = hr_api.g_varchar2) then
519: p_rec.attribute29 :=
520: per_chk_shd.g_old_rec.attribute29;
521: End If;
522: If (p_rec.attribute30 = hr_api.g_varchar2) then
523: p_rec.attribute30 :=
524: per_chk_shd.g_old_rec.attribute30;
525: End If;
526: --

Line 584: p_person_id in number default hr_api.g_number,

580: Procedure upd
581: (
582: p_effective_date in date,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,

Line 585: p_item_code in varchar2 default hr_api.g_varchar2,

581: (
582: p_effective_date in date,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,

Line 586: p_date_due in date default hr_api.g_date,

582: p_effective_date in date,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,

Line 587: p_date_done in date default hr_api.g_date,

583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 588: p_status in varchar2 default hr_api.g_varchar2,

584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 589: p_notes in varchar2 default hr_api.g_varchar2,

585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 591: p_attribute_category in varchar2 default hr_api.g_varchar2,

587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 592: p_attribute1 in varchar2 default hr_api.g_varchar2,

588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 593: p_attribute2 in varchar2 default hr_api.g_varchar2,

589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 594: p_attribute3 in varchar2 default hr_api.g_varchar2,

590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 595: p_attribute4 in varchar2 default hr_api.g_varchar2,

591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 596: p_attribute5 in varchar2 default hr_api.g_varchar2,

592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 597: p_attribute6 in varchar2 default hr_api.g_varchar2,

593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 598: p_attribute7 in varchar2 default hr_api.g_varchar2,

594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 599: p_attribute8 in varchar2 default hr_api.g_varchar2,

595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 600: p_attribute9 in varchar2 default hr_api.g_varchar2,

596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 601: p_attribute10 in varchar2 default hr_api.g_varchar2,

597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 602: p_attribute11 in varchar2 default hr_api.g_varchar2,

598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 603: p_attribute12 in varchar2 default hr_api.g_varchar2,

599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 604: p_attribute13 in varchar2 default hr_api.g_varchar2,

600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 605: p_attribute14 in varchar2 default hr_api.g_varchar2,

601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 606: p_attribute15 in varchar2 default hr_api.g_varchar2,

602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 607: p_attribute16 in varchar2 default hr_api.g_varchar2,

603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 608: p_attribute17 in varchar2 default hr_api.g_varchar2,

604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 609: p_attribute18 in varchar2 default hr_api.g_varchar2,

605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 610: p_attribute19 in varchar2 default hr_api.g_varchar2,

606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 611: p_attribute20 in varchar2 default hr_api.g_varchar2,

607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 612: p_attribute21 in varchar2 default hr_api.g_varchar2,

608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 613: p_attribute22 in varchar2 default hr_api.g_varchar2,

609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 614: p_attribute23 in varchar2 default hr_api.g_varchar2,

610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 615: p_attribute24 in varchar2 default hr_api.g_varchar2,

611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 616: p_attribute25 in varchar2 default hr_api.g_varchar2,

612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 617: p_attribute26 in varchar2 default hr_api.g_varchar2,

613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2

Line 618: p_attribute27 in varchar2 default hr_api.g_varchar2,

614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is

Line 619: p_attribute28 in varchar2 default hr_api.g_varchar2,

615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --

Line 620: p_attribute29 in varchar2 default hr_api.g_varchar2,

616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --
624: l_rec per_chk_shd.g_rec_type;

Line 621: p_attribute30 in varchar2 default hr_api.g_varchar2

617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --
624: l_rec per_chk_shd.g_rec_type;
625: l_proc varchar2(72) := g_package||'upd';