APPS.OTA_OCL_UPD dependencies on HR_API

Line 106: When hr_api.check_integrity_violated Then

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

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

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

Line 111: When hr_api.parent_integrity_violated Then

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

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

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

Line 116: When hr_api.unique_integrity_violated Then

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

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

116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: ota_ocl_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;
124: End update_dml;

Line 325: when hr_api.cannot_find_prog_unit then

321: );
322: --
323: exception
324: --
325: when hr_api.cannot_find_prog_unit then
326: --
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'OTA_COMPETENCE_LANGUAGES'
329: ,p_hook_type => 'AU');

Line 327: hr_api.cannot_find_prog_unit_error

323: exception
324: --
325: when hr_api.cannot_find_prog_unit then
326: --
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'OTA_COMPETENCE_LANGUAGES'
329: ,p_hook_type => 'AU');
330: --
331: end;

Line 390: If (p_rec.competence_id = hr_api.g_number) then

386: -- p_rec plsql record structure
387: -- to see if a system default is being used. If a system default
388: -- is being used then we must set to the 'current' argument value.
389: --
390: If (p_rec.competence_id = hr_api.g_number) then
391: p_rec.competence_id :=
392: ota_ocl_shd.g_old_rec.competence_id;
393: End If;
394: If (p_rec.language_code = hr_api.g_varchar2) then

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

390: If (p_rec.competence_id = hr_api.g_number) then
391: p_rec.competence_id :=
392: ota_ocl_shd.g_old_rec.competence_id;
393: End If;
394: If (p_rec.language_code = hr_api.g_varchar2) then
395: p_rec.language_code :=
396: ota_ocl_shd.g_old_rec.language_code;
397: End If;
398: If (p_rec.min_proficiency_level_id = hr_api.g_number) then

Line 398: If (p_rec.min_proficiency_level_id = hr_api.g_number) then

394: If (p_rec.language_code = hr_api.g_varchar2) then
395: p_rec.language_code :=
396: ota_ocl_shd.g_old_rec.language_code;
397: End If;
398: If (p_rec.min_proficiency_level_id = hr_api.g_number) then
399: p_rec.min_proficiency_level_id :=
400: ota_ocl_shd.g_old_rec.min_proficiency_level_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then

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

398: If (p_rec.min_proficiency_level_id = hr_api.g_number) then
399: p_rec.min_proficiency_level_id :=
400: ota_ocl_shd.g_old_rec.min_proficiency_level_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: ota_ocl_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.ocl_information_category = hr_api.g_varchar2) then

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

402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: ota_ocl_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.ocl_information_category = hr_api.g_varchar2) then
407: p_rec.ocl_information_category :=
408: ota_ocl_shd.g_old_rec.ocl_information_category;
409: End If;
410: If (p_rec.ocl_information1 = hr_api.g_varchar2) then

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

406: If (p_rec.ocl_information_category = hr_api.g_varchar2) then
407: p_rec.ocl_information_category :=
408: ota_ocl_shd.g_old_rec.ocl_information_category;
409: End If;
410: If (p_rec.ocl_information1 = hr_api.g_varchar2) then
411: p_rec.ocl_information1 :=
412: ota_ocl_shd.g_old_rec.ocl_information1;
413: End If;
414: If (p_rec.ocl_information2 = hr_api.g_varchar2) then

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

410: If (p_rec.ocl_information1 = hr_api.g_varchar2) then
411: p_rec.ocl_information1 :=
412: ota_ocl_shd.g_old_rec.ocl_information1;
413: End If;
414: If (p_rec.ocl_information2 = hr_api.g_varchar2) then
415: p_rec.ocl_information2 :=
416: ota_ocl_shd.g_old_rec.ocl_information2;
417: End If;
418: If (p_rec.ocl_information3 = hr_api.g_varchar2) then

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

414: If (p_rec.ocl_information2 = hr_api.g_varchar2) then
415: p_rec.ocl_information2 :=
416: ota_ocl_shd.g_old_rec.ocl_information2;
417: End If;
418: If (p_rec.ocl_information3 = hr_api.g_varchar2) then
419: p_rec.ocl_information3 :=
420: ota_ocl_shd.g_old_rec.ocl_information3;
421: End If;
422: If (p_rec.ocl_information4 = hr_api.g_varchar2) then

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

418: If (p_rec.ocl_information3 = hr_api.g_varchar2) then
419: p_rec.ocl_information3 :=
420: ota_ocl_shd.g_old_rec.ocl_information3;
421: End If;
422: If (p_rec.ocl_information4 = hr_api.g_varchar2) then
423: p_rec.ocl_information4 :=
424: ota_ocl_shd.g_old_rec.ocl_information4;
425: End If;
426: If (p_rec.ocl_information5 = hr_api.g_varchar2) then

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

422: If (p_rec.ocl_information4 = hr_api.g_varchar2) then
423: p_rec.ocl_information4 :=
424: ota_ocl_shd.g_old_rec.ocl_information4;
425: End If;
426: If (p_rec.ocl_information5 = hr_api.g_varchar2) then
427: p_rec.ocl_information5 :=
428: ota_ocl_shd.g_old_rec.ocl_information5;
429: End If;
430: If (p_rec.ocl_information6 = hr_api.g_varchar2) then

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

426: If (p_rec.ocl_information5 = hr_api.g_varchar2) then
427: p_rec.ocl_information5 :=
428: ota_ocl_shd.g_old_rec.ocl_information5;
429: End If;
430: If (p_rec.ocl_information6 = hr_api.g_varchar2) then
431: p_rec.ocl_information6 :=
432: ota_ocl_shd.g_old_rec.ocl_information6;
433: End If;
434: If (p_rec.ocl_information7 = hr_api.g_varchar2) then

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

430: If (p_rec.ocl_information6 = hr_api.g_varchar2) then
431: p_rec.ocl_information6 :=
432: ota_ocl_shd.g_old_rec.ocl_information6;
433: End If;
434: If (p_rec.ocl_information7 = hr_api.g_varchar2) then
435: p_rec.ocl_information7 :=
436: ota_ocl_shd.g_old_rec.ocl_information7;
437: End If;
438: If (p_rec.ocl_information8 = hr_api.g_varchar2) then

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

434: If (p_rec.ocl_information7 = hr_api.g_varchar2) then
435: p_rec.ocl_information7 :=
436: ota_ocl_shd.g_old_rec.ocl_information7;
437: End If;
438: If (p_rec.ocl_information8 = hr_api.g_varchar2) then
439: p_rec.ocl_information8 :=
440: ota_ocl_shd.g_old_rec.ocl_information8;
441: End If;
442: If (p_rec.ocl_information9 = hr_api.g_varchar2) then

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

438: If (p_rec.ocl_information8 = hr_api.g_varchar2) then
439: p_rec.ocl_information8 :=
440: ota_ocl_shd.g_old_rec.ocl_information8;
441: End If;
442: If (p_rec.ocl_information9 = hr_api.g_varchar2) then
443: p_rec.ocl_information9 :=
444: ota_ocl_shd.g_old_rec.ocl_information9;
445: End If;
446: If (p_rec.ocl_information10 = hr_api.g_varchar2) then

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

442: If (p_rec.ocl_information9 = hr_api.g_varchar2) then
443: p_rec.ocl_information9 :=
444: ota_ocl_shd.g_old_rec.ocl_information9;
445: End If;
446: If (p_rec.ocl_information10 = hr_api.g_varchar2) then
447: p_rec.ocl_information10 :=
448: ota_ocl_shd.g_old_rec.ocl_information10;
449: End If;
450: If (p_rec.ocl_information11 = hr_api.g_varchar2) then

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

446: If (p_rec.ocl_information10 = hr_api.g_varchar2) then
447: p_rec.ocl_information10 :=
448: ota_ocl_shd.g_old_rec.ocl_information10;
449: End If;
450: If (p_rec.ocl_information11 = hr_api.g_varchar2) then
451: p_rec.ocl_information11 :=
452: ota_ocl_shd.g_old_rec.ocl_information11;
453: End If;
454: If (p_rec.ocl_information12 = hr_api.g_varchar2) then

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

450: If (p_rec.ocl_information11 = hr_api.g_varchar2) then
451: p_rec.ocl_information11 :=
452: ota_ocl_shd.g_old_rec.ocl_information11;
453: End If;
454: If (p_rec.ocl_information12 = hr_api.g_varchar2) then
455: p_rec.ocl_information12 :=
456: ota_ocl_shd.g_old_rec.ocl_information12;
457: End If;
458: If (p_rec.ocl_information13 = hr_api.g_varchar2) then

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

454: If (p_rec.ocl_information12 = hr_api.g_varchar2) then
455: p_rec.ocl_information12 :=
456: ota_ocl_shd.g_old_rec.ocl_information12;
457: End If;
458: If (p_rec.ocl_information13 = hr_api.g_varchar2) then
459: p_rec.ocl_information13 :=
460: ota_ocl_shd.g_old_rec.ocl_information13;
461: End If;
462: If (p_rec.ocl_information14 = hr_api.g_varchar2) then

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

458: If (p_rec.ocl_information13 = hr_api.g_varchar2) then
459: p_rec.ocl_information13 :=
460: ota_ocl_shd.g_old_rec.ocl_information13;
461: End If;
462: If (p_rec.ocl_information14 = hr_api.g_varchar2) then
463: p_rec.ocl_information14 :=
464: ota_ocl_shd.g_old_rec.ocl_information14;
465: End If;
466: If (p_rec.ocl_information15 = hr_api.g_varchar2) then

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

462: If (p_rec.ocl_information14 = hr_api.g_varchar2) then
463: p_rec.ocl_information14 :=
464: ota_ocl_shd.g_old_rec.ocl_information14;
465: End If;
466: If (p_rec.ocl_information15 = hr_api.g_varchar2) then
467: p_rec.ocl_information15 :=
468: ota_ocl_shd.g_old_rec.ocl_information15;
469: End If;
470: If (p_rec.ocl_information16 = hr_api.g_varchar2) then

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

466: If (p_rec.ocl_information15 = hr_api.g_varchar2) then
467: p_rec.ocl_information15 :=
468: ota_ocl_shd.g_old_rec.ocl_information15;
469: End If;
470: If (p_rec.ocl_information16 = hr_api.g_varchar2) then
471: p_rec.ocl_information16 :=
472: ota_ocl_shd.g_old_rec.ocl_information16;
473: End If;
474: If (p_rec.ocl_information17 = hr_api.g_varchar2) then

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

470: If (p_rec.ocl_information16 = hr_api.g_varchar2) then
471: p_rec.ocl_information16 :=
472: ota_ocl_shd.g_old_rec.ocl_information16;
473: End If;
474: If (p_rec.ocl_information17 = hr_api.g_varchar2) then
475: p_rec.ocl_information17 :=
476: ota_ocl_shd.g_old_rec.ocl_information17;
477: End If;
478: If (p_rec.ocl_information18 = hr_api.g_varchar2) then

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

474: If (p_rec.ocl_information17 = hr_api.g_varchar2) then
475: p_rec.ocl_information17 :=
476: ota_ocl_shd.g_old_rec.ocl_information17;
477: End If;
478: If (p_rec.ocl_information18 = hr_api.g_varchar2) then
479: p_rec.ocl_information18 :=
480: ota_ocl_shd.g_old_rec.ocl_information18;
481: End If;
482: If (p_rec.ocl_information19 = hr_api.g_varchar2) then

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

478: If (p_rec.ocl_information18 = hr_api.g_varchar2) then
479: p_rec.ocl_information18 :=
480: ota_ocl_shd.g_old_rec.ocl_information18;
481: End If;
482: If (p_rec.ocl_information19 = hr_api.g_varchar2) then
483: p_rec.ocl_information19 :=
484: ota_ocl_shd.g_old_rec.ocl_information19;
485: End If;
486: If (p_rec.ocl_information20 = hr_api.g_varchar2) then

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

482: If (p_rec.ocl_information19 = hr_api.g_varchar2) then
483: p_rec.ocl_information19 :=
484: ota_ocl_shd.g_old_rec.ocl_information19;
485: End If;
486: If (p_rec.ocl_information20 = hr_api.g_varchar2) then
487: p_rec.ocl_information20 :=
488: ota_ocl_shd.g_old_rec.ocl_information20;
489: End If;
490: --

Line 548: ,p_competence_id in number default hr_api.g_number

544: Procedure upd
545: (p_effective_date in date
546: ,p_competence_language_id in number
547: ,p_object_version_number in out nocopy number
548: ,p_competence_id in number default hr_api.g_number
549: ,p_language_code in varchar2 default hr_api.g_varchar2
550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2

Line 549: ,p_language_code in varchar2 default hr_api.g_varchar2

545: (p_effective_date in date
546: ,p_competence_language_id in number
547: ,p_object_version_number in out nocopy number
548: ,p_competence_id in number default hr_api.g_number
549: ,p_language_code in varchar2 default hr_api.g_varchar2
550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2

Line 550: ,p_business_group_id in number default hr_api.g_number

546: ,p_competence_language_id in number
547: ,p_object_version_number in out nocopy number
548: ,p_competence_id in number default hr_api.g_number
549: ,p_language_code in varchar2 default hr_api.g_varchar2
550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2

Line 551: ,p_min_proficiency_level_id in number default hr_api.g_number

547: ,p_object_version_number in out nocopy number
548: ,p_competence_id in number default hr_api.g_number
549: ,p_language_code in varchar2 default hr_api.g_varchar2
550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2

Line 552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2

548: ,p_competence_id in number default hr_api.g_number
549: ,p_language_code in varchar2 default hr_api.g_varchar2
550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2

Line 553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2

549: ,p_language_code in varchar2 default hr_api.g_varchar2
550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2

Line 554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2

550: ,p_business_group_id in number default hr_api.g_number
551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2

Line 555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2

551: ,p_min_proficiency_level_id in number default hr_api.g_number
552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2

Line 556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2

552: ,p_ocl_information_category in varchar2 default hr_api.g_varchar2
553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2

Line 557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2

553: ,p_ocl_information1 in varchar2 default hr_api.g_varchar2
554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2

Line 558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2

554: ,p_ocl_information2 in varchar2 default hr_api.g_varchar2
555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2

Line 559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2

555: ,p_ocl_information3 in varchar2 default hr_api.g_varchar2
556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2

Line 560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2

556: ,p_ocl_information4 in varchar2 default hr_api.g_varchar2
557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2

Line 561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2

557: ,p_ocl_information5 in varchar2 default hr_api.g_varchar2
558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2

Line 562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2

558: ,p_ocl_information6 in varchar2 default hr_api.g_varchar2
559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2

Line 563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2

559: ,p_ocl_information7 in varchar2 default hr_api.g_varchar2
560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2

Line 564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2

560: ,p_ocl_information8 in varchar2 default hr_api.g_varchar2
561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2

Line 565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2

561: ,p_ocl_information9 in varchar2 default hr_api.g_varchar2
562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2

Line 566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2

562: ,p_ocl_information10 in varchar2 default hr_api.g_varchar2
563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2

Line 567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2

563: ,p_ocl_information11 in varchar2 default hr_api.g_varchar2
564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2

Line 568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2

564: ,p_ocl_information12 in varchar2 default hr_api.g_varchar2
565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2

Line 569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2

565: ,p_ocl_information13 in varchar2 default hr_api.g_varchar2
566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
573: ) is

Line 570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2

566: ,p_ocl_information14 in varchar2 default hr_api.g_varchar2
567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
573: ) is
574: --

Line 571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2

567: ,p_ocl_information15 in varchar2 default hr_api.g_varchar2
568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
573: ) is
574: --
575: l_rec ota_ocl_shd.g_rec_type;

Line 572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2

568: ,p_ocl_information16 in varchar2 default hr_api.g_varchar2
569: ,p_ocl_information17 in varchar2 default hr_api.g_varchar2
570: ,p_ocl_information18 in varchar2 default hr_api.g_varchar2
571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
573: ) is
574: --
575: l_rec ota_ocl_shd.g_rec_type;
576: l_proc varchar2(72) := g_package||'upd';