11: --
12: procedure create_form_tab_page
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_form_canvas_id in number
17: ,p_tab_page_name in varchar2
18: ,p_display_order in number
19: ,p_user_tab_page_name in varchar2
83: -- instead of p_language_code from now on, to allow an IN OUT parameter to
84: -- be passed through.
85: --
86: l_language_code := p_language_code;
87: hr_api.validate_language_code(p_language_code => l_language_code);
88: --
89: hr_utility.set_location(l_proc, 20);
90: --
91: --
136: ,p_information29 => p_information29
137: ,p_information30 => p_information30
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (p_module_name => 'create_form_tab_page'
143: ,p_hook_type => 'BP'
144: );
137: ,p_information30 => p_information30
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (p_module_name => 'create_form_tab_page'
143: ,p_hook_type => 'BP'
144: );
145: end;
265: ,p_object_version_number => l_object_version_number
266: ,p_override_value_warning => l_override_value_warning
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'create_form_tab_page'
272: ,p_hook_type => 'AP'
273: );
266: ,p_override_value_warning => l_override_value_warning
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'create_form_tab_page'
272: ,p_hook_type => 'AP'
273: );
274: end;
277: --
278: hr_utility.set_location('At:'|| l_proc, 40);
279:
280: if p_validate then
281: raise hr_api.validate_enabled;
282: end if;
283: --
284: -- Set all output arguments
285: --
288: p_override_value_warning := l_override_value_warning;
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 70);
291: exception
292: when hr_api.validate_enabled then
293: --
294: -- As the Validate_Enabled exception has been raised
295: -- we must rollback to the savepoint
296: --
346: (p_form_tab_page_id => p_form_tab_page_id
347: ,p_object_version_number => p_object_version_number
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'delete_form_tab_page'
353: ,p_hook_type => 'BP'
354: );
347: ,p_object_version_number => p_object_version_number
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'delete_form_tab_page'
353: ,p_hook_type => 'BP'
354: );
355: end;
387: (p_form_tab_page_id => p_form_tab_page_id
388: ,p_object_version_number => p_object_version_number
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'delete_form_tab_page'
394: ,p_hook_type => 'AP'
395: );
388: ,p_object_version_number => p_object_version_number
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'delete_form_tab_page'
394: ,p_hook_type => 'AP'
395: );
396: end;
399: --
400: hr_utility.set_location('At:'|| l_proc, 40);
401:
402: if p_validate then
403: raise hr_api.validate_enabled;
404: end if;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 70);
407: exception
404: end if;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 70);
407: exception
408: when hr_api.validate_enabled then
409: --
410: -- As the Validate_Enabled exception has been raised
411: -- we must rollback to the savepoint
412: --
432: --
433: procedure update_form_tab_page
434: (p_validate in boolean default false
435: ,p_effective_date in date
436: ,p_language_code in varchar2 default hr_api.userenv_lang
437: ,p_form_tab_page_id in number
438: ,p_object_version_number in out nocopy number
439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
435: ,p_effective_date in date
436: ,p_language_code in varchar2 default hr_api.userenv_lang
437: ,p_form_tab_page_id in number
438: ,p_object_version_number in out nocopy number
439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
436: ,p_language_code in varchar2 default hr_api.userenv_lang
437: ,p_form_tab_page_id in number
438: ,p_object_version_number in out nocopy number
439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
437: ,p_form_tab_page_id in number
438: ,p_object_version_number in out nocopy number
439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
438: ,p_object_version_number in out nocopy number
439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
440: ,p_display_order in number default hr_api.g_number
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
441: ,p_user_tab_page_name in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
442: ,p_description in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
443: ,p_label in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
444: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
445: ,p_visible in number default hr_api.g_number
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
446: ,p_visible_override in number default hr_api.g_number
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
447: ,p_information_category in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
448: ,p_information1 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
449: ,p_information2 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
450: ,p_information3 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
451: ,p_information4 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
452: ,p_information5 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
453: ,p_information6 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
454: ,p_information7 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
455: ,p_information8 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
456: ,p_information9 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
457: ,p_information10 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
458: ,p_information11 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
459: ,p_information12 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
460: ,p_information13 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
461: ,p_information14 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
462: ,p_information15 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
463: ,p_information16 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
464: ,p_information17 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
465: ,p_information18 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
466: ,p_information19 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
467: ,p_information20 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
468: ,p_information21 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
476: ,p_information29 in varchar2 default hr_api.g_varchar2
469: ,p_information22 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
476: ,p_information29 in varchar2 default hr_api.g_varchar2
477: ,p_information30 in varchar2 default hr_api.g_varchar2
470: ,p_information23 in varchar2 default hr_api.g_varchar2
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
476: ,p_information29 in varchar2 default hr_api.g_varchar2
477: ,p_information30 in varchar2 default hr_api.g_varchar2
478: ,p_override_value_warning out nocopy boolean
471: ,p_information24 in varchar2 default hr_api.g_varchar2
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
476: ,p_information29 in varchar2 default hr_api.g_varchar2
477: ,p_information30 in varchar2 default hr_api.g_varchar2
478: ,p_override_value_warning out nocopy boolean
479: ) is
472: ,p_information25 in varchar2 default hr_api.g_varchar2
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
476: ,p_information29 in varchar2 default hr_api.g_varchar2
477: ,p_information30 in varchar2 default hr_api.g_varchar2
478: ,p_override_value_warning out nocopy boolean
479: ) is
480: --
473: ,p_information26 in varchar2 default hr_api.g_varchar2
474: ,p_information27 in varchar2 default hr_api.g_varchar2
475: ,p_information28 in varchar2 default hr_api.g_varchar2
476: ,p_information29 in varchar2 default hr_api.g_varchar2
477: ,p_information30 in varchar2 default hr_api.g_varchar2
478: ,p_override_value_warning out nocopy boolean
479: ) is
480: --
481: -- Declare cursors and local variables
484: l_language_code fnd_languages.language_code%TYPE;
485:
486: CURSOR cur_override
487: IS
488: SELECT DECODE(p_visible,hr_api.g_number,visible,p_visible),
489: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
490: FROM hr_form_tab_pages
491: WHERE form_tab_page_id = p_form_tab_page_id;
492:
485:
486: CURSOR cur_override
487: IS
488: SELECT DECODE(p_visible,hr_api.g_number,visible,p_visible),
489: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)
490: FROM hr_form_tab_pages
491: WHERE form_tab_page_id = p_form_tab_page_id;
492:
493: l_visible number;
513: -- instead of p_language_code from now on, to allow an IN OUT parameter to
514: -- be passed through.
515: --
516: l_language_code := p_language_code;
517: hr_api.validate_language_code(p_language_code => l_language_code);
518: --
519: hr_utility.set_location(l_proc, 20);
520: --
521: --
566: ,p_information28 => p_information28
567: ,p_information29 => p_information29
568: ,p_information30 => p_information30 );
569: exception
570: when hr_api.cannot_find_prog_unit then
571: hr_api.cannot_find_prog_unit_error
572: (p_module_name => 'update_form_tab_page'
573: ,p_hook_type => 'BP'
574: );
567: ,p_information29 => p_information29
568: ,p_information30 => p_information30 );
569: exception
570: when hr_api.cannot_find_prog_unit then
571: hr_api.cannot_find_prog_unit_error
572: (p_module_name => 'update_form_tab_page'
573: ,p_hook_type => 'BP'
574: );
575: end;
696: ,p_information29 => p_information29
697: ,p_information30 => p_information30
698: ,p_override_value_warning => l_override_value_warning);
699: exception
700: when hr_api.cannot_find_prog_unit then
701: hr_api.cannot_find_prog_unit_error
702: (p_module_name => 'update_form_tab_page'
703: ,p_hook_type => 'AP'
704: );
697: ,p_information30 => p_information30
698: ,p_override_value_warning => l_override_value_warning);
699: exception
700: when hr_api.cannot_find_prog_unit then
701: hr_api.cannot_find_prog_unit_error
702: (p_module_name => 'update_form_tab_page'
703: ,p_hook_type => 'AP'
704: );
705: end;
708: --
709: hr_utility.set_location('At:'|| l_proc, 40);
710:
711: if p_validate then
712: raise hr_api.validate_enabled;
713: end if;
714: --
715: -- Set all output arguments
716: --
718: p_override_value_warning := l_override_value_warning;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 70);
721: exception
722: when hr_api.validate_enabled then
723: --
724: -- As the Validate_Enabled exception has been raised
725: -- we must rollback to the savepoint
726: --