46: ,p_hierarchy_version_id => p_hierarchy_version_id
47: ,p_hierarchy_name => p_hierarchy_name
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (p_module_name => 'create_vac_rec_area_value'
53: ,p_hook_type => 'BP'
54: );
47: ,p_hierarchy_name => p_hierarchy_name
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (p_module_name => 'create_vac_rec_area_value'
53: ,p_hook_type => 'BP'
54: );
55: end;
79: ,p_vac_rec_area_id => l_vac_rec_area_id
80: ,p_object_version_number => l_object_version_number
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'create_vac_rec_area_value'
86: ,p_hook_type => 'AP'
87: );
80: ,p_object_version_number => l_object_version_number
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'create_vac_rec_area_value'
86: ,p_hook_type => 'AP'
87: );
88: end;
89: --
90: -- When in validation only mode raise the Validate_Enabled exception
91: --
92: if p_validate then
93: raise hr_api.validate_enabled;
94: end if;
95: --
96: -- Set all IN OUT and OUT parameters with out values
97: --
99: p_object_version_number := l_object_version_number;
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 70);
102: exception
103: when hr_api.validate_enabled then
104: --
105: -- As the Validate_Enabled exception has been raised
106: -- we must rollback to the savepoint
107: --
241: ,p_attribute29 => p_attribute29
242: ,p_attribute30 => p_attribute30
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'create_location_preference'
248: ,p_hook_type => 'BP'
249: );
242: ,p_attribute30 => p_attribute30
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'create_location_preference'
248: ,p_hook_type => 'BP'
249: );
250: end;
342: ,p_location_pref_id => l_location_pref_id
343: ,p_object_version_number=> l_object_version_number
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'create_location_preference'
349: ,p_hook_type => 'AP'
350: );
343: ,p_object_version_number=> l_object_version_number
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'create_location_preference'
349: ,p_hook_type => 'AP'
350: );
351: end;
352: --
353: -- When in validation only mode raise the Validate_Enabled exception
354: --
355: if p_validate then
356: raise hr_api.validate_enabled;
357: end if;
358: --
359: -- Set all IN OUT and OUT parameters with out values
360: --
362: p_object_version_number := l_object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: exception
366: when hr_api.validate_enabled then
367: --
368: -- As the Validate_Enabled exception has been raised
369: -- we must rollback to the savepoint
370: --
424: (p_vac_rec_area_id
425: ,p_object_version_number
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'delete_vac_rec_area_value'
431: ,p_hook_type => 'BP'
432: );
425: ,p_object_version_number
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'delete_vac_rec_area_value'
431: ,p_hook_type => 'BP'
432: );
433: end;
448: (p_vac_rec_area_id
449: ,p_object_version_number
450: );
451: exception
452: when hr_api.cannot_find_prog_unit then
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'delete_vac_rec_area_value'
455: ,p_hook_type => 'AP'
456: );
449: ,p_object_version_number
450: );
451: exception
452: when hr_api.cannot_find_prog_unit then
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'delete_vac_rec_area_value'
455: ,p_hook_type => 'AP'
456: );
457: end;
458: --
459: -- When in validation only mode raise the Validate_Enabled exception
460: --
461: if p_validate then
462: raise hr_api.validate_enabled;
463: end if;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
463: end if;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised
470: -- we must rollback to the savepoint
471: --
511: (p_location_pref_id
512: ,p_object_version_number
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'delete_location_preference'
518: ,p_hook_type => 'BP'
519: );
512: ,p_object_version_number
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'delete_location_preference'
518: ,p_hook_type => 'BP'
519: );
520: end;
535: (p_location_pref_id
536: ,p_object_version_number
537: );
538: exception
539: when hr_api.cannot_find_prog_unit then
540: hr_api.cannot_find_prog_unit_error
541: (p_module_name => 'delete_location_preference'
542: ,p_hook_type => 'AP'
543: );
536: ,p_object_version_number
537: );
538: exception
539: when hr_api.cannot_find_prog_unit then
540: hr_api.cannot_find_prog_unit_error
541: (p_module_name => 'delete_location_preference'
542: ,p_hook_type => 'AP'
543: );
544: end;
545: --
546: -- When in validation only mode raise the Validate_Enabled exception
547: --
548: if p_validate then
549: raise hr_api.validate_enabled;
550: end if;
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: exception
550: end if;
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: exception
554: when hr_api.validate_enabled then
555: --
556: -- As the Validate_Enabled exception has been raised
557: -- we must rollback to the savepoint
558: --
575: --
576: procedure update_vac_rec_area_value
577: (p_validate in boolean default false
578: ,p_effective_date in date
579: ,p_vacancy_id in number default hr_api.g_number
580: ,p_hierarchy_version_id in number default hr_api.g_number
581: ,p_hierarchy_name in varchar2 default hr_api.g_varchar2
582: ,p_vac_rec_area_id in number
583: ,p_object_version_number in out nocopy number
576: procedure update_vac_rec_area_value
577: (p_validate in boolean default false
578: ,p_effective_date in date
579: ,p_vacancy_id in number default hr_api.g_number
580: ,p_hierarchy_version_id in number default hr_api.g_number
581: ,p_hierarchy_name in varchar2 default hr_api.g_varchar2
582: ,p_vac_rec_area_id in number
583: ,p_object_version_number in out nocopy number
584: ) is
577: (p_validate in boolean default false
578: ,p_effective_date in date
579: ,p_vacancy_id in number default hr_api.g_number
580: ,p_hierarchy_version_id in number default hr_api.g_number
581: ,p_hierarchy_name in varchar2 default hr_api.g_varchar2
582: ,p_vac_rec_area_id in number
583: ,p_object_version_number in out nocopy number
584: ) is
585: --
610: ,p_hierarchy_version_id => p_hierarchy_version_id
611: ,p_hierarchy_name => p_hierarchy_name
612: );
613: exception
614: when hr_api.cannot_find_prog_unit then
615: hr_api.cannot_find_prog_unit_error
616: (p_module_name => 'update_vac_rec_area_value'
617: ,p_hook_type => 'BP'
618: );
611: ,p_hierarchy_name => p_hierarchy_name
612: );
613: exception
614: when hr_api.cannot_find_prog_unit then
615: hr_api.cannot_find_prog_unit_error
616: (p_module_name => 'update_vac_rec_area_value'
617: ,p_hook_type => 'BP'
618: );
619: end;
642: ,p_vac_rec_area_id => p_vac_rec_area_id
643: ,p_object_version_number => l_object_version_number
644: );
645: exception
646: when hr_api.cannot_find_prog_unit then
647: hr_api.cannot_find_prog_unit_error
648: (p_module_name => 'update_vac_rec_area_value'
649: ,p_hook_type => 'AP'
650: );
643: ,p_object_version_number => l_object_version_number
644: );
645: exception
646: when hr_api.cannot_find_prog_unit then
647: hr_api.cannot_find_prog_unit_error
648: (p_module_name => 'update_vac_rec_area_value'
649: ,p_hook_type => 'AP'
650: );
651: end;
652: --
653: -- When in validation only mode raise the Validate_Enabled exception
654: --
655: if p_validate then
656: raise hr_api.validate_enabled;
657: end if;
658: --
659: -- Set all IN OUT and OUT parameters with out values
660: --
661: p_object_version_number := l_object_version_number;
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 70);
664: exception
665: when hr_api.validate_enabled then
666: --
667: -- As the Validate_Enabled exception has been raised
668: -- we must rollback to the savepoint
669: --