APPS.OTA_ACI_UPD dependencies on HR_API

Line 110: When hr_api.check_integrity_violated Then

106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
113: ota_aci_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
113: ota_aci_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error

Line 115: When hr_api.parent_integrity_violated Then

111: -- A check constraint has been violated
112: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
113: ota_aci_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
123: ota_aci_shd.constraint_error

Line 120: When hr_api.unique_integrity_violated Then

116: -- Parent integrity has been violated
117: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
118: ota_aci_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
123: ota_aci_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
123: ota_aci_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
128: End update_dml;

Line 339: when hr_api.cannot_find_prog_unit then

335: );
336: --
337: exception
338: --
339: when hr_api.cannot_find_prog_unit then
340: --
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'
343: ,p_hook_type => 'AU');

Line 341: hr_api.cannot_find_prog_unit_error

337: exception
338: --
339: when hr_api.cannot_find_prog_unit then
340: --
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'
343: ,p_hook_type => 'AU');
344: --
345: end;

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

400: -- p_rec plsql record structure
401: -- to see if a system default is being used. If a system default
402: -- is being used then we must set to the 'current' argument value.
403: --
404: If (p_rec.activity_category = hr_api.g_varchar2) then
405: p_rec.activity_category :=
406: ota_aci_shd.g_old_rec.activity_category;
407: End If;
408: If (p_rec.event_id = hr_api.g_number) then

Line 408: If (p_rec.event_id = hr_api.g_number) then

404: If (p_rec.activity_category = hr_api.g_varchar2) then
405: p_rec.activity_category :=
406: ota_aci_shd.g_old_rec.activity_category;
407: End If;
408: If (p_rec.event_id = hr_api.g_number) then
409: p_rec.event_id :=
410: ota_aci_shd.g_old_rec.event_id;
411: End If;
412: If (p_rec.comments = hr_api.g_varchar2) then

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

408: If (p_rec.event_id = hr_api.g_number) then
409: p_rec.event_id :=
410: ota_aci_shd.g_old_rec.event_id;
411: End If;
412: If (p_rec.comments = hr_api.g_varchar2) then
413: p_rec.comments :=
414: ota_aci_shd.g_old_rec.comments;
415: End If;
416: If (p_rec.aci_information_category = hr_api.g_varchar2) then

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

412: If (p_rec.comments = hr_api.g_varchar2) then
413: p_rec.comments :=
414: ota_aci_shd.g_old_rec.comments;
415: End If;
416: If (p_rec.aci_information_category = hr_api.g_varchar2) then
417: p_rec.aci_information_category :=
418: ota_aci_shd.g_old_rec.aci_information_category;
419: End If;
420: If (p_rec.aci_information1 = hr_api.g_varchar2) then

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

416: If (p_rec.aci_information_category = hr_api.g_varchar2) then
417: p_rec.aci_information_category :=
418: ota_aci_shd.g_old_rec.aci_information_category;
419: End If;
420: If (p_rec.aci_information1 = hr_api.g_varchar2) then
421: p_rec.aci_information1 :=
422: ota_aci_shd.g_old_rec.aci_information1;
423: End If;
424: If (p_rec.aci_information2 = hr_api.g_varchar2) then

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

420: If (p_rec.aci_information1 = hr_api.g_varchar2) then
421: p_rec.aci_information1 :=
422: ota_aci_shd.g_old_rec.aci_information1;
423: End If;
424: If (p_rec.aci_information2 = hr_api.g_varchar2) then
425: p_rec.aci_information2 :=
426: ota_aci_shd.g_old_rec.aci_information2;
427: End If;
428: If (p_rec.aci_information3 = hr_api.g_varchar2) then

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

424: If (p_rec.aci_information2 = hr_api.g_varchar2) then
425: p_rec.aci_information2 :=
426: ota_aci_shd.g_old_rec.aci_information2;
427: End If;
428: If (p_rec.aci_information3 = hr_api.g_varchar2) then
429: p_rec.aci_information3 :=
430: ota_aci_shd.g_old_rec.aci_information3;
431: End If;
432: If (p_rec.aci_information4 = hr_api.g_varchar2) then

Line 432: If (p_rec.aci_information4 = hr_api.g_varchar2) then

428: If (p_rec.aci_information3 = hr_api.g_varchar2) then
429: p_rec.aci_information3 :=
430: ota_aci_shd.g_old_rec.aci_information3;
431: End If;
432: If (p_rec.aci_information4 = hr_api.g_varchar2) then
433: p_rec.aci_information4 :=
434: ota_aci_shd.g_old_rec.aci_information4;
435: End If;
436: If (p_rec.aci_information5 = hr_api.g_varchar2) then

Line 436: If (p_rec.aci_information5 = hr_api.g_varchar2) then

432: If (p_rec.aci_information4 = hr_api.g_varchar2) then
433: p_rec.aci_information4 :=
434: ota_aci_shd.g_old_rec.aci_information4;
435: End If;
436: If (p_rec.aci_information5 = hr_api.g_varchar2) then
437: p_rec.aci_information5 :=
438: ota_aci_shd.g_old_rec.aci_information5;
439: End If;
440: If (p_rec.aci_information6 = hr_api.g_varchar2) then

Line 440: If (p_rec.aci_information6 = hr_api.g_varchar2) then

436: If (p_rec.aci_information5 = hr_api.g_varchar2) then
437: p_rec.aci_information5 :=
438: ota_aci_shd.g_old_rec.aci_information5;
439: End If;
440: If (p_rec.aci_information6 = hr_api.g_varchar2) then
441: p_rec.aci_information6 :=
442: ota_aci_shd.g_old_rec.aci_information6;
443: End If;
444: If (p_rec.aci_information7 = hr_api.g_varchar2) then

Line 444: If (p_rec.aci_information7 = hr_api.g_varchar2) then

440: If (p_rec.aci_information6 = hr_api.g_varchar2) then
441: p_rec.aci_information6 :=
442: ota_aci_shd.g_old_rec.aci_information6;
443: End If;
444: If (p_rec.aci_information7 = hr_api.g_varchar2) then
445: p_rec.aci_information7 :=
446: ota_aci_shd.g_old_rec.aci_information7;
447: End If;
448: If (p_rec.aci_information8 = hr_api.g_varchar2) then

Line 448: If (p_rec.aci_information8 = hr_api.g_varchar2) then

444: If (p_rec.aci_information7 = hr_api.g_varchar2) then
445: p_rec.aci_information7 :=
446: ota_aci_shd.g_old_rec.aci_information7;
447: End If;
448: If (p_rec.aci_information8 = hr_api.g_varchar2) then
449: p_rec.aci_information8 :=
450: ota_aci_shd.g_old_rec.aci_information8;
451: End If;
452: If (p_rec.aci_information9 = hr_api.g_varchar2) then

Line 452: If (p_rec.aci_information9 = hr_api.g_varchar2) then

448: If (p_rec.aci_information8 = hr_api.g_varchar2) then
449: p_rec.aci_information8 :=
450: ota_aci_shd.g_old_rec.aci_information8;
451: End If;
452: If (p_rec.aci_information9 = hr_api.g_varchar2) then
453: p_rec.aci_information9 :=
454: ota_aci_shd.g_old_rec.aci_information9;
455: End If;
456: If (p_rec.aci_information10 = hr_api.g_varchar2) then

Line 456: If (p_rec.aci_information10 = hr_api.g_varchar2) then

452: If (p_rec.aci_information9 = hr_api.g_varchar2) then
453: p_rec.aci_information9 :=
454: ota_aci_shd.g_old_rec.aci_information9;
455: End If;
456: If (p_rec.aci_information10 = hr_api.g_varchar2) then
457: p_rec.aci_information10 :=
458: ota_aci_shd.g_old_rec.aci_information10;
459: End If;
460: If (p_rec.aci_information11 = hr_api.g_varchar2) then

Line 460: If (p_rec.aci_information11 = hr_api.g_varchar2) then

456: If (p_rec.aci_information10 = hr_api.g_varchar2) then
457: p_rec.aci_information10 :=
458: ota_aci_shd.g_old_rec.aci_information10;
459: End If;
460: If (p_rec.aci_information11 = hr_api.g_varchar2) then
461: p_rec.aci_information11 :=
462: ota_aci_shd.g_old_rec.aci_information11;
463: End If;
464: If (p_rec.aci_information12 = hr_api.g_varchar2) then

Line 464: If (p_rec.aci_information12 = hr_api.g_varchar2) then

460: If (p_rec.aci_information11 = hr_api.g_varchar2) then
461: p_rec.aci_information11 :=
462: ota_aci_shd.g_old_rec.aci_information11;
463: End If;
464: If (p_rec.aci_information12 = hr_api.g_varchar2) then
465: p_rec.aci_information12 :=
466: ota_aci_shd.g_old_rec.aci_information12;
467: End If;
468: If (p_rec.aci_information13 = hr_api.g_varchar2) then

Line 468: If (p_rec.aci_information13 = hr_api.g_varchar2) then

464: If (p_rec.aci_information12 = hr_api.g_varchar2) then
465: p_rec.aci_information12 :=
466: ota_aci_shd.g_old_rec.aci_information12;
467: End If;
468: If (p_rec.aci_information13 = hr_api.g_varchar2) then
469: p_rec.aci_information13 :=
470: ota_aci_shd.g_old_rec.aci_information13;
471: End If;
472: If (p_rec.aci_information14 = hr_api.g_varchar2) then

Line 472: If (p_rec.aci_information14 = hr_api.g_varchar2) then

468: If (p_rec.aci_information13 = hr_api.g_varchar2) then
469: p_rec.aci_information13 :=
470: ota_aci_shd.g_old_rec.aci_information13;
471: End If;
472: If (p_rec.aci_information14 = hr_api.g_varchar2) then
473: p_rec.aci_information14 :=
474: ota_aci_shd.g_old_rec.aci_information14;
475: End If;
476: If (p_rec.aci_information15 = hr_api.g_varchar2) then

Line 476: If (p_rec.aci_information15 = hr_api.g_varchar2) then

472: If (p_rec.aci_information14 = hr_api.g_varchar2) then
473: p_rec.aci_information14 :=
474: ota_aci_shd.g_old_rec.aci_information14;
475: End If;
476: If (p_rec.aci_information15 = hr_api.g_varchar2) then
477: p_rec.aci_information15 :=
478: ota_aci_shd.g_old_rec.aci_information15;
479: End If;
480: If (p_rec.aci_information16 = hr_api.g_varchar2) then

Line 480: If (p_rec.aci_information16 = hr_api.g_varchar2) then

476: If (p_rec.aci_information15 = hr_api.g_varchar2) then
477: p_rec.aci_information15 :=
478: ota_aci_shd.g_old_rec.aci_information15;
479: End If;
480: If (p_rec.aci_information16 = hr_api.g_varchar2) then
481: p_rec.aci_information16 :=
482: ota_aci_shd.g_old_rec.aci_information16;
483: End If;
484: If (p_rec.aci_information17 = hr_api.g_varchar2) then

Line 484: If (p_rec.aci_information17 = hr_api.g_varchar2) then

480: If (p_rec.aci_information16 = hr_api.g_varchar2) then
481: p_rec.aci_information16 :=
482: ota_aci_shd.g_old_rec.aci_information16;
483: End If;
484: If (p_rec.aci_information17 = hr_api.g_varchar2) then
485: p_rec.aci_information17 :=
486: ota_aci_shd.g_old_rec.aci_information17;
487: End If;
488: If (p_rec.aci_information18 = hr_api.g_varchar2) then

Line 488: If (p_rec.aci_information18 = hr_api.g_varchar2) then

484: If (p_rec.aci_information17 = hr_api.g_varchar2) then
485: p_rec.aci_information17 :=
486: ota_aci_shd.g_old_rec.aci_information17;
487: End If;
488: If (p_rec.aci_information18 = hr_api.g_varchar2) then
489: p_rec.aci_information18 :=
490: ota_aci_shd.g_old_rec.aci_information18;
491: End If;
492: If (p_rec.aci_information19 = hr_api.g_varchar2) then

Line 492: If (p_rec.aci_information19 = hr_api.g_varchar2) then

488: If (p_rec.aci_information18 = hr_api.g_varchar2) then
489: p_rec.aci_information18 :=
490: ota_aci_shd.g_old_rec.aci_information18;
491: End If;
492: If (p_rec.aci_information19 = hr_api.g_varchar2) then
493: p_rec.aci_information19 :=
494: ota_aci_shd.g_old_rec.aci_information19;
495: End If;
496: If (p_rec.aci_information20 = hr_api.g_varchar2) then

Line 496: If (p_rec.aci_information20 = hr_api.g_varchar2) then

492: If (p_rec.aci_information19 = hr_api.g_varchar2) then
493: p_rec.aci_information19 :=
494: ota_aci_shd.g_old_rec.aci_information19;
495: End If;
496: If (p_rec.aci_information20 = hr_api.g_varchar2) then
497: p_rec.aci_information20 :=
498: ota_aci_shd.g_old_rec.aci_information20;
499: End If;
500: If (p_rec.start_date_active = hr_api.g_date) then

Line 500: If (p_rec.start_date_active = hr_api.g_date) then

496: If (p_rec.aci_information20 = hr_api.g_varchar2) then
497: p_rec.aci_information20 :=
498: ota_aci_shd.g_old_rec.aci_information20;
499: End If;
500: If (p_rec.start_date_active = hr_api.g_date) then
501: p_rec.start_date_active :=
502: ota_aci_shd.g_old_rec.start_date_active;
503: End If;
504: If (p_rec.end_date_active = hr_api.g_date) then

Line 504: If (p_rec.end_date_active = hr_api.g_date) then

500: If (p_rec.start_date_active = hr_api.g_date) then
501: p_rec.start_date_active :=
502: ota_aci_shd.g_old_rec.start_date_active;
503: End If;
504: If (p_rec.end_date_active = hr_api.g_date) then
505: p_rec.end_date_active :=
506: ota_aci_shd.g_old_rec.end_date_active;
507: End If;
508: If (p_rec.primary_flag = hr_api.g_varchar2) then

Line 508: If (p_rec.primary_flag = hr_api.g_varchar2) then

504: If (p_rec.end_date_active = hr_api.g_date) then
505: p_rec.end_date_active :=
506: ota_aci_shd.g_old_rec.end_date_active;
507: End If;
508: If (p_rec.primary_flag = hr_api.g_varchar2) then
509: p_rec.primary_flag :=
510: ota_aci_shd.g_old_rec.primary_flag;
511: End If;
512: --

Line 578: ,p_activity_category in varchar2 default hr_api.g_varchar2

574: (p_effective_date in date
575: ,p_activity_version_id in number
576: ,p_category_usage_id in number
577: ,p_object_version_number in out nocopy number
578: ,p_activity_category in varchar2 default hr_api.g_varchar2
579: ,p_event_id in number default hr_api.g_number
580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2

Line 579: ,p_event_id in number default hr_api.g_number

575: ,p_activity_version_id in number
576: ,p_category_usage_id in number
577: ,p_object_version_number in out nocopy number
578: ,p_activity_category in varchar2 default hr_api.g_varchar2
579: ,p_event_id in number default hr_api.g_number
580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2

Line 580: ,p_comments in varchar2 default hr_api.g_varchar2

576: ,p_category_usage_id in number
577: ,p_object_version_number in out nocopy number
578: ,p_activity_category in varchar2 default hr_api.g_varchar2
579: ,p_event_id in number default hr_api.g_number
580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2

Line 581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2

577: ,p_object_version_number in out nocopy number
578: ,p_activity_category in varchar2 default hr_api.g_varchar2
579: ,p_event_id in number default hr_api.g_number
580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2

Line 582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2

578: ,p_activity_category in varchar2 default hr_api.g_varchar2
579: ,p_event_id in number default hr_api.g_number
580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2

Line 583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2

579: ,p_event_id in number default hr_api.g_number
580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2

Line 584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2

580: ,p_comments in varchar2 default hr_api.g_varchar2
581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2

Line 585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2

581: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2

Line 586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2

582: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2

Line 587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2

583: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2

Line 588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2

584: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2

Line 589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2

585: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2

Line 590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2

586: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2

Line 591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2

587: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2

Line 592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2

588: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2

Line 593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2

589: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2

Line 594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2

590: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2

Line 595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2

591: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2

Line 596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2

592: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2

Line 597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2

593: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2

Line 598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2

594: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date

Line 599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2

595: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date
603: ,p_end_date_active in date default hr_api.g_date

Line 600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2

596: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date
603: ,p_end_date_active in date default hr_api.g_date
604: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2

597: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date
603: ,p_end_date_active in date default hr_api.g_date
604: ,p_primary_flag in varchar2 default hr_api.g_varchar2
605: ) is

Line 602: ,p_start_date_active in date default hr_api.g_date

598: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date
603: ,p_end_date_active in date default hr_api.g_date
604: ,p_primary_flag in varchar2 default hr_api.g_varchar2
605: ) is
606: --

Line 603: ,p_end_date_active in date default hr_api.g_date

599: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date
603: ,p_end_date_active in date default hr_api.g_date
604: ,p_primary_flag in varchar2 default hr_api.g_varchar2
605: ) is
606: --
607: l_rec ota_aci_shd.g_rec_type;

Line 604: ,p_primary_flag in varchar2 default hr_api.g_varchar2

600: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
601: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
602: ,p_start_date_active in date default hr_api.g_date
603: ,p_end_date_active in date default hr_api.g_date
604: ,p_primary_flag in varchar2 default hr_api.g_varchar2
605: ) is
606: --
607: l_rec ota_aci_shd.g_rec_type;
608: l_proc varchar2(72) := g_package||'upd';