80: ,p_business_group_id in number default null
81: ,p_shared_type_name in varchar2 default null
82: ,p_shared_type_code in varchar2 default null
83: ,p_system_type_cd in varchar2 default null
84: ,p_language_code in varchar2 default hr_api.userenv_lang
85: ,p_information1 in varchar2 default null
86: ,p_information2 in varchar2 default null
87: ,p_information3 in varchar2 default null
88: ,p_information4 in varchar2 default null
134: savepoint create_shared_type;
135: --
136: --
137: l_language_code := p_language_code;
138: hr_api.validate_language_code(p_language_code => l_language_code);
139: --
140: hr_utility.set_location(l_proc, 20);
141: --
142: -- Process Logic
185: ,p_lookup_type => p_lookup_type
186: ,p_effective_date => trunc(p_effective_date)
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (
192: p_module_name => 'CREATE_shared_types'
193: ,p_hook_type => 'BP'
186: ,p_effective_date => trunc(p_effective_date)
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (
192: p_module_name => 'CREATE_shared_types'
193: ,p_hook_type => 'BP'
194: );
291: ,p_lookup_type => p_lookup_type
292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_shared_types'
298: ,p_hook_type => 'AP'
299: );
292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_shared_types'
298: ,p_hook_type => 'AP'
299: );
300: --
306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: -- Set all output arguments
314: --
318: hr_utility.set_location(' Leaving:'||l_proc, 70);
319: --
320: exception
321: --
322: when hr_api.validate_enabled then
323: --
324: -- As the Validate_Enabled exception has been raised
325: -- we must rollback to the savepoint
326: --
350: --
351: procedure update_shared_type
352: (p_validate in boolean default false
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
351: procedure update_shared_type
352: (p_validate in boolean default false
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
352: (p_validate in boolean default false
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
392: ,p_effective_date in date
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
392: ,p_effective_date in date
393: ) is
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
392: ,p_effective_date in date
393: ) is
394: --
395: -- Declare cursors and local variables
408: savepoint update_shared_type;
409: --
410: --
411: l_language_code := p_language_code;
412: hr_api.validate_language_code(p_language_code => l_language_code);
413: --
414: hr_utility.set_location(l_proc, 20);
415: --
416: -- Process Logic
463: ,p_lookup_type => p_lookup_type
464: ,p_effective_date => trunc(p_effective_date)
465: );
466: exception
467: when hr_api.cannot_find_prog_unit then
468: hr_api.cannot_find_prog_unit_error
469: (p_module_name => 'UPDATE_shared_types'
470: ,p_hook_type => 'BP'
471: );
464: ,p_effective_date => trunc(p_effective_date)
465: );
466: exception
467: when hr_api.cannot_find_prog_unit then
468: hr_api.cannot_find_prog_unit_error
469: (p_module_name => 'UPDATE_shared_types'
470: ,p_hook_type => 'BP'
471: );
472: --
567: ,p_lookup_type => p_lookup_type
568: ,p_effective_date => trunc(p_effective_date)
569: );
570: exception
571: when hr_api.cannot_find_prog_unit then
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'UPDATE_shared_types'
574: ,p_hook_type => 'AP'
575: );
568: ,p_effective_date => trunc(p_effective_date)
569: );
570: exception
571: when hr_api.cannot_find_prog_unit then
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'UPDATE_shared_types'
574: ,p_hook_type => 'AP'
575: );
576: --
582: --
583: -- When in validation only mode raise the Validate_Enabled exception
584: --
585: if p_validate then
586: raise hr_api.validate_enabled;
587: end if;
588: --
589: -- Set all output arguments
590: --
593: hr_utility.set_location(' Leaving:'||l_proc, 70);
594: --
595: exception
596: --
597: when hr_api.validate_enabled then
598: --
599: -- As the Validate_Enabled exception has been raised
600: -- we must rollback to the savepoint
601: --
657: ,p_object_version_number => p_object_version_number
658: ,p_effective_date => trunc(p_effective_date)
659: );
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'DELETE_shared_types'
664: ,p_hook_type => 'BP'
665: );
658: ,p_effective_date => trunc(p_effective_date)
659: );
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'DELETE_shared_types'
664: ,p_hook_type => 'BP'
665: );
666: --
695: ,p_object_version_number => l_object_version_number
696: ,p_effective_date => trunc(p_effective_date)
697: );
698: exception
699: when hr_api.cannot_find_prog_unit then
700: hr_api.cannot_find_prog_unit_error
701: (p_module_name => 'DELETE_shared_types'
702: ,p_hook_type => 'AP'
703: );
696: ,p_effective_date => trunc(p_effective_date)
697: );
698: exception
699: when hr_api.cannot_find_prog_unit then
700: hr_api.cannot_find_prog_unit_error
701: (p_module_name => 'DELETE_shared_types'
702: ,p_hook_type => 'AP'
703: );
704: --
710: --
711: -- When in validation only mode raise the Validate_Enabled exception
712: --
713: if p_validate then
714: raise hr_api.validate_enabled;
715: end if;
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 70);
718: --
717: hr_utility.set_location(' Leaving:'||l_proc, 70);
718: --
719: exception
720: --
721: when hr_api.validate_enabled then
722: --
723: -- As the Validate_Enabled exception has been raised
724: -- we must rollback to the savepoint
725: --