APPS.HR_FORM_TAB_PAGES_API dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 87: hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 140: when hr_api.cannot_find_prog_unit then

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: );

Line 141: hr_api.cannot_find_prog_unit_error

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;

Line 269: when hr_api.cannot_find_prog_unit then

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: );

Line 270: hr_api.cannot_find_prog_unit_error

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;

Line 281: raise hr_api.validate_enabled;

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: --

Line 292: when hr_api.validate_enabled then

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: --

Line 350: when hr_api.cannot_find_prog_unit then

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: );

Line 351: hr_api.cannot_find_prog_unit_error

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;

Line 391: when hr_api.cannot_find_prog_unit then

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: );

Line 392: hr_api.cannot_find_prog_unit_error

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;

Line 403: raise hr_api.validate_enabled;

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

Line 408: when hr_api.validate_enabled then

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: --

Line 436: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 439: ,p_tab_page_name in varchar2 default hr_api.g_varchar2

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

Line 440: ,p_display_order in number default hr_api.g_number

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

Line 441: ,p_user_tab_page_name 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

Line 442: ,p_description in varchar2 default hr_api.g_varchar2

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

Line 443: ,p_label in varchar2 default hr_api.g_varchar2

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

Line 444: ,p_navigation_direction 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

Line 445: ,p_visible 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
449: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 446: ,p_visible_override in number default hr_api.g_number

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

Line 447: ,p_information_category 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

Line 448: ,p_information1 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

Line 449: ,p_information2 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

Line 450: ,p_information3 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

Line 451: ,p_information4 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

Line 452: ,p_information5 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

Line 453: ,p_information6 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

Line 454: ,p_information7 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

Line 455: ,p_information8 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

Line 456: ,p_information9 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

Line 457: ,p_information10 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

Line 458: ,p_information11 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

Line 459: ,p_information12 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

Line 460: ,p_information13 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

Line 461: ,p_information14 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

Line 462: ,p_information15 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

Line 463: ,p_information16 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

Line 464: ,p_information17 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

Line 465: ,p_information18 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

Line 466: ,p_information19 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

Line 467: ,p_information20 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

Line 468: ,p_information21 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

Line 469: ,p_information22 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

Line 470: ,p_information23 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

Line 471: ,p_information24 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

Line 472: ,p_information25 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

Line 473: ,p_information26 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

Line 474: ,p_information27 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

Line 475: ,p_information28 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
479: ) is

Line 476: ,p_information29 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
480: --

Line 477: ,p_information30 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: --
481: -- Declare cursors and local variables

Line 488: SELECT DECODE(p_visible,hr_api.g_number,visible,p_visible),

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:

Line 489: DECODE(p_visible_override,hr_api.g_number,visible_override,p_visible_override)

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;

Line 517: hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 570: when hr_api.cannot_find_prog_unit then

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: );

Line 571: hr_api.cannot_find_prog_unit_error

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;

Line 700: when hr_api.cannot_find_prog_unit then

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: );

Line 701: hr_api.cannot_find_prog_unit_error

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;

Line 712: raise hr_api.validate_enabled;

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: --

Line 722: when hr_api.validate_enabled then

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: --