APPS.OTA_CME_UPD dependencies on HR_API

Line 107: When hr_api.check_integrity_violated Then

103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: --
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ota_cme_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ota_cme_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error

Line 112: When hr_api.parent_integrity_violated Then

108: -- A check constraint has been violated
109: --
110: ota_cme_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_cme_shd.constraint_error

Line 117: When hr_api.unique_integrity_violated Then

113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_cme_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.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_cme_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
125: End update_dml;

Line 330: when hr_api.cannot_find_prog_unit then

326: );
327: --
328: exception
329: --
330: when hr_api.cannot_find_prog_unit then
331: --
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'OTA_CERT_MBR_ENROLLMENTS'
334: ,p_hook_type => 'AU');

Line 332: hr_api.cannot_find_prog_unit_error

328: exception
329: --
330: when hr_api.cannot_find_prog_unit then
331: --
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'OTA_CERT_MBR_ENROLLMENTS'
334: ,p_hook_type => 'AU');
335: --
336: end;

Line 395: If (p_rec.cert_prd_enrollment_id = hr_api.g_number) then

391: -- p_rec plsql record structure
392: -- to see if a system default is being used. If a system default
393: -- is being used then we must set to the 'current' argument value.
394: --
395: If (p_rec.cert_prd_enrollment_id = hr_api.g_number) then
396: p_rec.cert_prd_enrollment_id :=
397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;
398: End If;
399: If (p_rec.cert_member_id = hr_api.g_number) then

Line 399: If (p_rec.cert_member_id = hr_api.g_number) then

395: If (p_rec.cert_prd_enrollment_id = hr_api.g_number) then
396: p_rec.cert_prd_enrollment_id :=
397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;
398: End If;
399: If (p_rec.cert_member_id = hr_api.g_number) then
400: p_rec.cert_member_id :=
401: ota_cme_shd.g_old_rec.cert_member_id;
402: End If;
403: If (p_rec.member_status_code = hr_api.g_varchar2) then

Line 403: If (p_rec.member_status_code = hr_api.g_varchar2) then

399: If (p_rec.cert_member_id = hr_api.g_number) then
400: p_rec.cert_member_id :=
401: ota_cme_shd.g_old_rec.cert_member_id;
402: End If;
403: If (p_rec.member_status_code = hr_api.g_varchar2) then
404: p_rec.member_status_code :=
405: ota_cme_shd.g_old_rec.member_status_code;
406: End If;
407: If (p_rec.completion_date = hr_api.g_date) then

Line 407: If (p_rec.completion_date = hr_api.g_date) then

403: If (p_rec.member_status_code = hr_api.g_varchar2) then
404: p_rec.member_status_code :=
405: ota_cme_shd.g_old_rec.member_status_code;
406: End If;
407: If (p_rec.completion_date = hr_api.g_date) then
408: p_rec.completion_date :=
409: ota_cme_shd.g_old_rec.completion_date;
410: End If;
411: If (p_rec.business_group_id = hr_api.g_number) then

Line 411: If (p_rec.business_group_id = hr_api.g_number) then

407: If (p_rec.completion_date = hr_api.g_date) then
408: p_rec.completion_date :=
409: ota_cme_shd.g_old_rec.completion_date;
410: End If;
411: If (p_rec.business_group_id = hr_api.g_number) then
412: p_rec.business_group_id :=
413: ota_cme_shd.g_old_rec.business_group_id;
414: End If;
415: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

411: If (p_rec.business_group_id = hr_api.g_number) then
412: p_rec.business_group_id :=
413: ota_cme_shd.g_old_rec.business_group_id;
414: End If;
415: If (p_rec.attribute_category = hr_api.g_varchar2) then
416: p_rec.attribute_category :=
417: ota_cme_shd.g_old_rec.attribute_category;
418: End If;
419: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

415: If (p_rec.attribute_category = hr_api.g_varchar2) then
416: p_rec.attribute_category :=
417: ota_cme_shd.g_old_rec.attribute_category;
418: End If;
419: If (p_rec.attribute1 = hr_api.g_varchar2) then
420: p_rec.attribute1 :=
421: ota_cme_shd.g_old_rec.attribute1;
422: End If;
423: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

419: If (p_rec.attribute1 = hr_api.g_varchar2) then
420: p_rec.attribute1 :=
421: ota_cme_shd.g_old_rec.attribute1;
422: End If;
423: If (p_rec.attribute2 = hr_api.g_varchar2) then
424: p_rec.attribute2 :=
425: ota_cme_shd.g_old_rec.attribute2;
426: End If;
427: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

423: If (p_rec.attribute2 = hr_api.g_varchar2) then
424: p_rec.attribute2 :=
425: ota_cme_shd.g_old_rec.attribute2;
426: End If;
427: If (p_rec.attribute3 = hr_api.g_varchar2) then
428: p_rec.attribute3 :=
429: ota_cme_shd.g_old_rec.attribute3;
430: End If;
431: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

427: If (p_rec.attribute3 = hr_api.g_varchar2) then
428: p_rec.attribute3 :=
429: ota_cme_shd.g_old_rec.attribute3;
430: End If;
431: If (p_rec.attribute4 = hr_api.g_varchar2) then
432: p_rec.attribute4 :=
433: ota_cme_shd.g_old_rec.attribute4;
434: End If;
435: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

431: If (p_rec.attribute4 = hr_api.g_varchar2) then
432: p_rec.attribute4 :=
433: ota_cme_shd.g_old_rec.attribute4;
434: End If;
435: If (p_rec.attribute5 = hr_api.g_varchar2) then
436: p_rec.attribute5 :=
437: ota_cme_shd.g_old_rec.attribute5;
438: End If;
439: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

435: If (p_rec.attribute5 = hr_api.g_varchar2) then
436: p_rec.attribute5 :=
437: ota_cme_shd.g_old_rec.attribute5;
438: End If;
439: If (p_rec.attribute6 = hr_api.g_varchar2) then
440: p_rec.attribute6 :=
441: ota_cme_shd.g_old_rec.attribute6;
442: End If;
443: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

439: If (p_rec.attribute6 = hr_api.g_varchar2) then
440: p_rec.attribute6 :=
441: ota_cme_shd.g_old_rec.attribute6;
442: End If;
443: If (p_rec.attribute7 = hr_api.g_varchar2) then
444: p_rec.attribute7 :=
445: ota_cme_shd.g_old_rec.attribute7;
446: End If;
447: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

443: If (p_rec.attribute7 = hr_api.g_varchar2) then
444: p_rec.attribute7 :=
445: ota_cme_shd.g_old_rec.attribute7;
446: End If;
447: If (p_rec.attribute8 = hr_api.g_varchar2) then
448: p_rec.attribute8 :=
449: ota_cme_shd.g_old_rec.attribute8;
450: End If;
451: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

447: If (p_rec.attribute8 = hr_api.g_varchar2) then
448: p_rec.attribute8 :=
449: ota_cme_shd.g_old_rec.attribute8;
450: End If;
451: If (p_rec.attribute9 = hr_api.g_varchar2) then
452: p_rec.attribute9 :=
453: ota_cme_shd.g_old_rec.attribute9;
454: End If;
455: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

451: If (p_rec.attribute9 = hr_api.g_varchar2) then
452: p_rec.attribute9 :=
453: ota_cme_shd.g_old_rec.attribute9;
454: End If;
455: If (p_rec.attribute10 = hr_api.g_varchar2) then
456: p_rec.attribute10 :=
457: ota_cme_shd.g_old_rec.attribute10;
458: End If;
459: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

455: If (p_rec.attribute10 = hr_api.g_varchar2) then
456: p_rec.attribute10 :=
457: ota_cme_shd.g_old_rec.attribute10;
458: End If;
459: If (p_rec.attribute11 = hr_api.g_varchar2) then
460: p_rec.attribute11 :=
461: ota_cme_shd.g_old_rec.attribute11;
462: End If;
463: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

459: If (p_rec.attribute11 = hr_api.g_varchar2) then
460: p_rec.attribute11 :=
461: ota_cme_shd.g_old_rec.attribute11;
462: End If;
463: If (p_rec.attribute12 = hr_api.g_varchar2) then
464: p_rec.attribute12 :=
465: ota_cme_shd.g_old_rec.attribute12;
466: End If;
467: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

463: If (p_rec.attribute12 = hr_api.g_varchar2) then
464: p_rec.attribute12 :=
465: ota_cme_shd.g_old_rec.attribute12;
466: End If;
467: If (p_rec.attribute13 = hr_api.g_varchar2) then
468: p_rec.attribute13 :=
469: ota_cme_shd.g_old_rec.attribute13;
470: End If;
471: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

467: If (p_rec.attribute13 = hr_api.g_varchar2) then
468: p_rec.attribute13 :=
469: ota_cme_shd.g_old_rec.attribute13;
470: End If;
471: If (p_rec.attribute14 = hr_api.g_varchar2) then
472: p_rec.attribute14 :=
473: ota_cme_shd.g_old_rec.attribute14;
474: End If;
475: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

471: If (p_rec.attribute14 = hr_api.g_varchar2) then
472: p_rec.attribute14 :=
473: ota_cme_shd.g_old_rec.attribute14;
474: End If;
475: If (p_rec.attribute15 = hr_api.g_varchar2) then
476: p_rec.attribute15 :=
477: ota_cme_shd.g_old_rec.attribute15;
478: End If;
479: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

475: If (p_rec.attribute15 = hr_api.g_varchar2) then
476: p_rec.attribute15 :=
477: ota_cme_shd.g_old_rec.attribute15;
478: End If;
479: If (p_rec.attribute16 = hr_api.g_varchar2) then
480: p_rec.attribute16 :=
481: ota_cme_shd.g_old_rec.attribute16;
482: End If;
483: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

479: If (p_rec.attribute16 = hr_api.g_varchar2) then
480: p_rec.attribute16 :=
481: ota_cme_shd.g_old_rec.attribute16;
482: End If;
483: If (p_rec.attribute17 = hr_api.g_varchar2) then
484: p_rec.attribute17 :=
485: ota_cme_shd.g_old_rec.attribute17;
486: End If;
487: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

483: If (p_rec.attribute17 = hr_api.g_varchar2) then
484: p_rec.attribute17 :=
485: ota_cme_shd.g_old_rec.attribute17;
486: End If;
487: If (p_rec.attribute18 = hr_api.g_varchar2) then
488: p_rec.attribute18 :=
489: ota_cme_shd.g_old_rec.attribute18;
490: End If;
491: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

487: If (p_rec.attribute18 = hr_api.g_varchar2) then
488: p_rec.attribute18 :=
489: ota_cme_shd.g_old_rec.attribute18;
490: End If;
491: If (p_rec.attribute19 = hr_api.g_varchar2) then
492: p_rec.attribute19 :=
493: ota_cme_shd.g_old_rec.attribute19;
494: End If;
495: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

491: If (p_rec.attribute19 = hr_api.g_varchar2) then
492: p_rec.attribute19 :=
493: ota_cme_shd.g_old_rec.attribute19;
494: End If;
495: If (p_rec.attribute20 = hr_api.g_varchar2) then
496: p_rec.attribute20 :=
497: ota_cme_shd.g_old_rec.attribute20;
498: End If;
499: --

Line 563: ,p_cert_prd_enrollment_id in number default hr_api.g_number

559: Procedure upd
560: (p_effective_date in date
561: ,p_cert_mbr_enrollment_id in number
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number

Line 564: ,p_cert_member_id in number default hr_api.g_number

560: (p_effective_date in date
561: ,p_cert_mbr_enrollment_id in number
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 565: ,p_member_status_code in varchar2 default hr_api.g_varchar2

561: ,p_cert_mbr_enrollment_id in number
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 566: ,p_completion_date in date default hr_api.g_date

562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 567: ,p_business_group_id in number default hr_api.g_number

563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 568: ,p_attribute_category in varchar2 default hr_api.g_varchar2

564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 569: ,p_attribute1 in varchar2 default hr_api.g_varchar2

565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 570: ,p_attribute2 in varchar2 default hr_api.g_varchar2

566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 571: ,p_attribute3 in varchar2 default hr_api.g_varchar2

567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 572: ,p_attribute4 in varchar2 default hr_api.g_varchar2

568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 573: ,p_attribute5 in varchar2 default hr_api.g_varchar2

569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 574: ,p_attribute6 in varchar2 default hr_api.g_varchar2

570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 575: ,p_attribute7 in varchar2 default hr_api.g_varchar2

571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 576: ,p_attribute8 in varchar2 default hr_api.g_varchar2

572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 577: ,p_attribute9 in varchar2 default hr_api.g_varchar2

573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 578: ,p_attribute10 in varchar2 default hr_api.g_varchar2

574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 579: ,p_attribute11 in varchar2 default hr_api.g_varchar2

575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 580: ,p_attribute12 in varchar2 default hr_api.g_varchar2

576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 581: ,p_attribute13 in varchar2 default hr_api.g_varchar2

577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 582: ,p_attribute14 in varchar2 default hr_api.g_varchar2

578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 583: ,p_attribute15 in varchar2 default hr_api.g_varchar2

579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 584: ,p_attribute16 in varchar2 default hr_api.g_varchar2

580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 585: ,p_attribute17 in varchar2 default hr_api.g_varchar2

581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is

Line 586: ,p_attribute18 in varchar2 default hr_api.g_varchar2

582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --

Line 587: ,p_attribute19 in varchar2 default hr_api.g_varchar2

583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --
591: l_rec ota_cme_shd.g_rec_type;

Line 588: ,p_attribute20 in varchar2 default hr_api.g_varchar2

584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --
591: l_rec ota_cme_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'upd';