11: --
12: procedure create_tab_page_property
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_tab_page_id in number default null
17: ,p_template_tab_page_id in number default null
18: ,p_label in varchar2 default null
19: ,p_navigation_direction in varchar2 default null
75: -- instead of p_language_code from now on, to allow an IN OUT parameter to
76: -- be passed through.
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82: --
83: --
129: --
130: -- When in validation only mode raise the Validate_Enabled exception
131: --
132: if p_validate then
133: raise hr_api.validate_enabled;
134: end if;
135: --
136: -- Set all output arguments
137: --
140: --p_override_value_warning := l_override_value_warning;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: exception
144: when hr_api.validate_enabled then
145: --
146: -- As the Validate_Enabled exception has been raised
147: -- we must rollback to the savepoint
148: --
172: procedure update_tab_page_property
173: (p_validate in boolean default false
174: ,p_effective_date in date
175: ,p_object_version_number in out nocopy number
176: ,p_language_code in varchar2 default hr_api.userenv_lang
177: ,p_tab_page_property_id in number default null
178: ,p_form_tab_page_id in number default null
179: ,p_template_tab_page_id in number default null
180: ,p_label in varchar2 default hr_api.g_varchar2
176: ,p_language_code in varchar2 default hr_api.userenv_lang
177: ,p_tab_page_property_id in number default null
178: ,p_form_tab_page_id in number default null
179: ,p_template_tab_page_id in number default null
180: ,p_label in varchar2 default hr_api.g_varchar2
181: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
177: ,p_tab_page_property_id in number default null
178: ,p_form_tab_page_id in number default null
179: ,p_template_tab_page_id in number default null
180: ,p_label in varchar2 default hr_api.g_varchar2
181: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
178: ,p_form_tab_page_id in number default null
179: ,p_template_tab_page_id in number default null
180: ,p_label in varchar2 default hr_api.g_varchar2
181: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
179: ,p_template_tab_page_id in number default null
180: ,p_label in varchar2 default hr_api.g_varchar2
181: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
180: ,p_label in varchar2 default hr_api.g_varchar2
181: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
181: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
182: ,p_visible in number default hr_api.g_number
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
183: ,p_information_category in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
184: ,p_information1 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
185: ,p_information2 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
186: ,p_information3 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
187: ,p_information4 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
188: ,p_information5 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
189: ,p_information6 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
190: ,p_information7 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
191: ,p_information8 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
192: ,p_information9 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
193: ,p_information10 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
194: ,p_information11 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
195: ,p_information12 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
196: ,p_information13 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
197: ,p_information14 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
198: ,p_information15 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
199: ,p_information16 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
200: ,p_information17 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
201: ,p_information18 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
202: ,p_information19 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
203: ,p_information20 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
204: ,p_information21 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
212: ,p_information29 in varchar2 default hr_api.g_varchar2
205: ,p_information22 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
212: ,p_information29 in varchar2 default hr_api.g_varchar2
213: ,p_information30 in varchar2 default hr_api.g_varchar2
206: ,p_information23 in varchar2 default hr_api.g_varchar2
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
212: ,p_information29 in varchar2 default hr_api.g_varchar2
213: ,p_information30 in varchar2 default hr_api.g_varchar2
214: --,p_override_value_warning out boolean
207: ,p_information24 in varchar2 default hr_api.g_varchar2
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
212: ,p_information29 in varchar2 default hr_api.g_varchar2
213: ,p_information30 in varchar2 default hr_api.g_varchar2
214: --,p_override_value_warning out boolean
215: ) is
208: ,p_information25 in varchar2 default hr_api.g_varchar2
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
212: ,p_information29 in varchar2 default hr_api.g_varchar2
213: ,p_information30 in varchar2 default hr_api.g_varchar2
214: --,p_override_value_warning out boolean
215: ) is
216: --
209: ,p_information26 in varchar2 default hr_api.g_varchar2
210: ,p_information27 in varchar2 default hr_api.g_varchar2
211: ,p_information28 in varchar2 default hr_api.g_varchar2
212: ,p_information29 in varchar2 default hr_api.g_varchar2
213: ,p_information30 in varchar2 default hr_api.g_varchar2
214: --,p_override_value_warning out boolean
215: ) is
216: --
217: -- Declare cursors and local variables
247: -- be passed through.
248: --
249: l_language_code := p_language_code;
250:
251: hr_api.validate_language_code(p_language_code => l_language_code);
252: --
253: hr_utility.set_location(l_proc, 20);
254: --
255: --
341: --
342: -- When in validation only mode raise the Validate_Enabled exception
343: --
344: if p_validate then
345: raise hr_api.validate_enabled;
346: end if;
347: --
348: -- Set all output arguments
349: --
350: --
351: --p_override_value_warning := l_override_value_warning;
352: hr_utility.set_location(' Leaving:'||l_proc, 70);
353: exception
354: when hr_api.validate_enabled then
355: --
356: -- As the Validate_Enabled exception has been raised
357: -- we must rollback to the savepoint
358: --
469: --
470: -- When in validation only mode raise the Validate_Enabled exception
471: --
472: if p_validate then
473: raise hr_api.validate_enabled;
474: end if;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 70);
477: exception
474: end if;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 70);
477: exception
478: when hr_api.validate_enabled then
479: --
480: -- As the Validate_Enabled exception has been raised
481: -- we must rollback to the savepoint
482: --
503: --
504: procedure copy_tab_page_property
505: (p_validate in boolean default false
506: ,p_effective_date in date
507: ,p_language_code in varchar2 default hr_api.userenv_lang
508: ,p_form_tab_page_id in number
509: ,p_template_tab_page_id in number
510: ,p_label in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
506: ,p_effective_date in date
507: ,p_language_code in varchar2 default hr_api.userenv_lang
508: ,p_form_tab_page_id in number
509: ,p_template_tab_page_id in number
510: ,p_label in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
507: ,p_language_code in varchar2 default hr_api.userenv_lang
508: ,p_form_tab_page_id in number
509: ,p_template_tab_page_id in number
510: ,p_label in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
508: ,p_form_tab_page_id in number
509: ,p_template_tab_page_id in number
510: ,p_label in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
509: ,p_template_tab_page_id in number
510: ,p_label in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
510: ,p_label in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
511: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
512: ,p_visible in number default hr_api.g_number
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
513: ,p_information_category in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
514: ,p_information1 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
515: ,p_information2 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
516: ,p_information3 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
517: ,p_information4 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
518: ,p_information5 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
519: ,p_information6 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
520: ,p_information7 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
521: ,p_information8 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
522: ,p_information9 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
523: ,p_information10 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
524: ,p_information11 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
525: ,p_information12 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
526: ,p_information13 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
527: ,p_information14 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
528: ,p_information15 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
529: ,p_information16 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
530: ,p_information17 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
531: ,p_information18 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
532: ,p_information19 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
533: ,p_information20 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
534: ,p_information21 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
542: ,p_information29 in varchar2 default hr_api.g_varchar2
535: ,p_information22 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
542: ,p_information29 in varchar2 default hr_api.g_varchar2
543: ,p_information30 in varchar2 default hr_api.g_varchar2
536: ,p_information23 in varchar2 default hr_api.g_varchar2
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
542: ,p_information29 in varchar2 default hr_api.g_varchar2
543: ,p_information30 in varchar2 default hr_api.g_varchar2
544: ,p_tab_page_property_id out nocopy number
537: ,p_information24 in varchar2 default hr_api.g_varchar2
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
542: ,p_information29 in varchar2 default hr_api.g_varchar2
543: ,p_information30 in varchar2 default hr_api.g_varchar2
544: ,p_tab_page_property_id out nocopy number
545: ,p_object_version_number out nocopy number
538: ,p_information25 in varchar2 default hr_api.g_varchar2
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
542: ,p_information29 in varchar2 default hr_api.g_varchar2
543: ,p_information30 in varchar2 default hr_api.g_varchar2
544: ,p_tab_page_property_id out nocopy number
545: ,p_object_version_number out nocopy number
546: --,p_override_value_warning out boolean
539: ,p_information26 in varchar2 default hr_api.g_varchar2
540: ,p_information27 in varchar2 default hr_api.g_varchar2
541: ,p_information28 in varchar2 default hr_api.g_varchar2
542: ,p_information29 in varchar2 default hr_api.g_varchar2
543: ,p_information30 in varchar2 default hr_api.g_varchar2
544: ,p_tab_page_property_id out nocopy number
545: ,p_object_version_number out nocopy number
546: --,p_override_value_warning out boolean
547: ) is
593: AND ttp.form_tab_page_id = p_form_tab_page_id;
594:
595: CURSOR cur_tab_prop
596: IS
597: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
594:
595: CURSOR cur_tab_prop
596: IS
597: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
595: CURSOR cur_tab_prop
596: IS
597: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
596: IS
597: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
597: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
630: FROM hr_tab_page_properties_b tpp
623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
630: FROM hr_tab_page_properties_b tpp
631: WHERE tpp.form_tab_page_id = p_form_tab_page_id;
624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
630: FROM hr_tab_page_properties_b tpp
631: WHERE tpp.form_tab_page_id = p_form_tab_page_id;
632:
625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
630: FROM hr_tab_page_properties_b tpp
631: WHERE tpp.form_tab_page_id = p_form_tab_page_id;
632:
633: CURSOR cur_tab_tl
633: CURSOR cur_tab_tl
634: IS
635: SELECT COUNT(0)
636: ,tpptl.source_lang
637: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label
638: FROM hr_tab_page_properties_tl tpptl
639: ,hr_tab_page_properties_b tpp
640: WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
641: AND tpp.form_tab_page_id = p_form_tab_page_id
639: ,hr_tab_page_properties_b tpp
640: WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
641: AND tpp.form_tab_page_id = p_form_tab_page_id
642: GROUP BY tpptl.source_lang
643: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)
644: ORDER BY 1;
645:
646: l_check number;
647: l_tab_page_property_id number;
662: -- instead of p_language_code from now on, to allow an IN OUT parameter to
663: -- be passed through.
664: --
665: l_language_code := p_language_code;
666: hr_api.validate_language_code(p_language_code => l_language_code);
667: --
668: hr_utility.set_location(l_proc, 20);
669: --
670: --
726: ,p_tab_page_property_id => l_tab_page_property_id
727: ,p_object_version_number => l_object_version_number);
728: --,p_override_value_warning => l_override_value_warning);
729:
730: IF p_label <> hr_api.g_varchar2 THEN
731:
732: hr_tpt_ins.ins_tl(p_language_code => l_language_code
733: ,p_tab_page_property_id => l_tab_page_property_id
734: ,p_label => p_label);
749: --
750: -- When in validation only mode raise the Validate_Enabled exception
751: --
752: if p_validate then
753: raise hr_api.validate_enabled;
754: end if;
755: --
756: -- Set all output arguments
757: --
760: --p_override_value_warning := l_override_value_warning;
761: --
762: hr_utility.set_location(' Leaving:'||l_proc, 70);
763: exception
764: when hr_api.validate_enabled then
765: --
766: -- As the Validate_Enabled exception has been raised
767: -- we must rollback to the savepoint
768: --
790: --
791: procedure copy_tab_page_property
792: (p_validate in boolean default false
793: ,p_effective_date in date
794: ,p_language_code in varchar2 default hr_api.userenv_lang
795: ,p_template_tab_page_id_from in number
796: ,p_template_tab_page_id_to in number
797: ,p_label in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
793: ,p_effective_date in date
794: ,p_language_code in varchar2 default hr_api.userenv_lang
795: ,p_template_tab_page_id_from in number
796: ,p_template_tab_page_id_to in number
797: ,p_label in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
794: ,p_language_code in varchar2 default hr_api.userenv_lang
795: ,p_template_tab_page_id_from in number
796: ,p_template_tab_page_id_to in number
797: ,p_label in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
795: ,p_template_tab_page_id_from in number
796: ,p_template_tab_page_id_to in number
797: ,p_label in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
796: ,p_template_tab_page_id_to in number
797: ,p_label in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
797: ,p_label in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
798: ,p_navigation_direction in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
799: ,p_visible in number default hr_api.g_number
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
800: ,p_information_category in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
801: ,p_information1 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
802: ,p_information2 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
803: ,p_information3 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
804: ,p_information4 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
805: ,p_information5 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
806: ,p_information6 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
807: ,p_information7 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
808: ,p_information8 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
809: ,p_information9 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
810: ,p_information10 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
811: ,p_information11 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
812: ,p_information12 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
813: ,p_information13 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
814: ,p_information14 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
815: ,p_information15 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
816: ,p_information16 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
817: ,p_information17 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
818: ,p_information18 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
819: ,p_information19 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
820: ,p_information20 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
821: ,p_information21 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
829: ,p_information29 in varchar2 default hr_api.g_varchar2
822: ,p_information22 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
829: ,p_information29 in varchar2 default hr_api.g_varchar2
830: ,p_information30 in varchar2 default hr_api.g_varchar2
823: ,p_information23 in varchar2 default hr_api.g_varchar2
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
829: ,p_information29 in varchar2 default hr_api.g_varchar2
830: ,p_information30 in varchar2 default hr_api.g_varchar2
831: ,p_tab_page_property_id out nocopy number
824: ,p_information24 in varchar2 default hr_api.g_varchar2
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
829: ,p_information29 in varchar2 default hr_api.g_varchar2
830: ,p_information30 in varchar2 default hr_api.g_varchar2
831: ,p_tab_page_property_id out nocopy number
832: ,p_object_version_number out nocopy number
825: ,p_information25 in varchar2 default hr_api.g_varchar2
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
829: ,p_information29 in varchar2 default hr_api.g_varchar2
830: ,p_information30 in varchar2 default hr_api.g_varchar2
831: ,p_tab_page_property_id out nocopy number
832: ,p_object_version_number out nocopy number
833: --,p_override_value_warning out boolean
826: ,p_information26 in varchar2 default hr_api.g_varchar2
827: ,p_information27 in varchar2 default hr_api.g_varchar2
828: ,p_information28 in varchar2 default hr_api.g_varchar2
829: ,p_information29 in varchar2 default hr_api.g_varchar2
830: ,p_information30 in varchar2 default hr_api.g_varchar2
831: ,p_tab_page_property_id out nocopy number
832: ,p_object_version_number out nocopy number
833: --,p_override_value_warning out boolean
834: ) is
883: WHERE ttp.template_tab_page_id = p_template_tab_page_id_to;
884:
885: CURSOR cur_tab_prop
886: IS
887: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
884:
885: CURSOR cur_tab_prop
886: IS
887: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
885: CURSOR cur_tab_prop
886: IS
887: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
886: IS
887: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
887: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)
888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
920: FROM hr_tab_page_properties_b tpp
913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
920: FROM hr_tab_page_properties_b tpp
921: WHERE tpp.template_tab_page_id = p_template_tab_page_id_from;
914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
920: FROM hr_tab_page_properties_b tpp
921: WHERE tpp.template_tab_page_id = p_template_tab_page_id_from;
922:
915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)
916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)
917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)
918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)
919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)
920: FROM hr_tab_page_properties_b tpp
921: WHERE tpp.template_tab_page_id = p_template_tab_page_id_from;
922:
923: CURSOR cur_tab_tl
923: CURSOR cur_tab_tl
924: IS
925: SELECT COUNT(0)
926: ,tpptl.source_lang
927: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label
928: FROM hr_tab_page_properties_tl tpptl
929: ,hr_tab_page_properties_b tpp
930: WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
931: AND tpp.template_tab_page_id = p_template_tab_page_id_from
929: ,hr_tab_page_properties_b tpp
930: WHERE tpptl.tab_page_property_id = tpp.tab_page_property_id
931: AND tpp.template_tab_page_id = p_template_tab_page_id_from
932: GROUP BY tpptl.source_lang
933: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)
934: ORDER BY 1;
935:
936: l_check number;
937: l_tab_page_property_id number;
952: -- instead of p_language_code from now on, to allow an IN OUT parameter to
953: -- be passed through.
954: --
955: l_language_code := p_language_code;
956: hr_api.validate_language_code(p_language_code => l_language_code);
957: --
958: hr_utility.set_location(l_proc, 20);
959: --
960: --
1016: ,p_tab_page_property_id => l_tab_page_property_id
1017: ,p_object_version_number => l_object_version_number);
1018: --,p_override_value_warning => l_override_value_warning);
1019:
1020: IF p_label <> hr_api.g_varchar2 THEN
1021:
1022: hr_tpt_ins.ins_tl(p_language_code => l_language_code
1023: ,p_tab_page_property_id => l_tab_page_property_id
1024: ,p_label => p_label);
1039: --
1040: -- When in validation only mode raise the Validate_Enabled exception
1041: --
1042: if p_validate then
1043: raise hr_api.validate_enabled;
1044: end if;
1045: --
1046: -- Set all output arguments
1047: --
1050: --p_override_value_warning := l_override_value_warning;
1051: --
1052: hr_utility.set_location(' Leaving:'||l_proc, 70);
1053: exception
1054: when hr_api.validate_enabled then
1055: --
1056: -- As the Validate_Enabled exception has been raised
1057: -- we must rollback to the savepoint
1058: --