eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TAB_PAGE_PROPERTIES_BSI dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

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

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

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

Line 133: raise hr_api.validate_enabled;

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

Line 144: when hr_api.validate_enabled then

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

Line 176: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 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

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

Line 182: ,p_visible in number default hr_api.g_number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 211: ,p_information28 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
215: ) is

Line 212: ,p_information29 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
216: --

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

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

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

Line 345: raise hr_api.validate_enabled;

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

Line 354: when hr_api.validate_enabled then

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

Line 473: raise hr_api.validate_enabled;

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

Line 478: when hr_api.validate_enabled then

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

Line 507: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 510: ,p_label 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

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

Line 512: ,p_visible in number default hr_api.g_number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 541: ,p_information28 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
545: ,p_object_version_number out nocopy number

Line 542: ,p_information29 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
546: --,p_override_value_warning out boolean

Line 543: ,p_information30 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
547: ) is

Line 597: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)

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)

Line 598: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)

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)

Line 599: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)

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)

Line 600: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)

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)

Line 601: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)

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)

Line 602: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)

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)

Line 603: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)

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)

Line 604: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)

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)

Line 605: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)

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)

Line 606: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)

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)

Line 607: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)

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)

Line 608: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)

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)

Line 609: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)

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)

Line 610: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)

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)

Line 611: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)

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)

Line 612: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)

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)

Line 613: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)

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)

Line 614: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)

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)

Line 615: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)

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)

Line 616: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)

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)

Line 617: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)

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)

Line 618: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)

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)

Line 619: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)

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)

Line 620: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)

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)

Line 621: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)

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)

Line 622: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)

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)

Line 623: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)

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)

Line 624: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)

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)

Line 625: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)

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)

Line 626: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)

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

Line 627: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)

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;

Line 628: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)

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:

Line 629: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)

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

Line 637: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label

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

Line 643: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)

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;

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

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

Line 730: IF p_label <> hr_api.g_varchar2 THEN

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

Line 753: raise hr_api.validate_enabled;

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

Line 764: when hr_api.validate_enabled then

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

Line 794: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 797: ,p_label 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

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

Line 799: ,p_visible in number default hr_api.g_number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 828: ,p_information28 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
832: ,p_object_version_number out nocopy number

Line 829: ,p_information29 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
833: --,p_override_value_warning out boolean

Line 830: ,p_information30 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
834: ) is

Line 887: SELECT DECODE(p_navigation_direction,hr_api.g_varchar2,tpp.navigation_direction,p_navigation_direction)

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)

Line 888: ,DECODE(p_visible,hr_api.g_number,tpp.visible,p_visible)

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)

Line 889: ,DECODE(p_information_category,hr_api.g_varchar2,tpp.information_category,p_information_category)

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)

Line 890: ,DECODE(p_information1,hr_api.g_varchar2,tpp.information1,p_information1)

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)

Line 891: ,DECODE(p_information2,hr_api.g_varchar2,tpp.information2,p_information2)

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)

Line 892: ,DECODE(p_information3,hr_api.g_varchar2,tpp.information3,p_information3)

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)

Line 893: ,DECODE(p_information4,hr_api.g_varchar2,tpp.information4,p_information4)

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)

Line 894: ,DECODE(p_information5,hr_api.g_varchar2,tpp.information5,p_information5)

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)

Line 895: ,DECODE(p_information6,hr_api.g_varchar2,tpp.information6,p_information6)

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)

Line 896: ,DECODE(p_information7,hr_api.g_varchar2,tpp.information7,p_information7)

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)

Line 897: ,DECODE(p_information8,hr_api.g_varchar2,tpp.information8,p_information8)

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)

Line 898: ,DECODE(p_information9,hr_api.g_varchar2,tpp.information9,p_information9)

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)

Line 899: ,DECODE(p_information10,hr_api.g_varchar2,tpp.information10,p_information10)

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)

Line 900: ,DECODE(p_information11,hr_api.g_varchar2,tpp.information11,p_information11)

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)

Line 901: ,DECODE(p_information12,hr_api.g_varchar2,tpp.information12,p_information12)

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)

Line 902: ,DECODE(p_information13,hr_api.g_varchar2,tpp.information13,p_information13)

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)

Line 903: ,DECODE(p_information14,hr_api.g_varchar2,tpp.information14,p_information14)

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)

Line 904: ,DECODE(p_information15,hr_api.g_varchar2,tpp.information15,p_information15)

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)

Line 905: ,DECODE(p_information16,hr_api.g_varchar2,tpp.information16,p_information16)

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)

Line 906: ,DECODE(p_information17,hr_api.g_varchar2,tpp.information17,p_information17)

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)

Line 907: ,DECODE(p_information18,hr_api.g_varchar2,tpp.information18,p_information18)

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)

Line 908: ,DECODE(p_information19,hr_api.g_varchar2,tpp.information19,p_information19)

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)

Line 909: ,DECODE(p_information20,hr_api.g_varchar2,tpp.information20,p_information20)

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)

Line 910: ,DECODE(p_information21,hr_api.g_varchar2,tpp.information21,p_information21)

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)

Line 911: ,DECODE(p_information22,hr_api.g_varchar2,tpp.information22,p_information22)

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)

Line 912: ,DECODE(p_information23,hr_api.g_varchar2,tpp.information23,p_information23)

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)

Line 913: ,DECODE(p_information24,hr_api.g_varchar2,tpp.information24,p_information24)

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)

Line 914: ,DECODE(p_information25,hr_api.g_varchar2,tpp.information25,p_information25)

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)

Line 915: ,DECODE(p_information26,hr_api.g_varchar2,tpp.information26,p_information26)

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)

Line 916: ,DECODE(p_information27,hr_api.g_varchar2,tpp.information27,p_information27)

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

Line 917: ,DECODE(p_information28,hr_api.g_varchar2,tpp.information28,p_information28)

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;

Line 918: ,DECODE(p_information29,hr_api.g_varchar2,tpp.information29,p_information29)

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:

Line 919: ,DECODE(p_information30,hr_api.g_varchar2,tpp.information30,p_information30)

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

Line 927: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label) label

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

Line 933: ,DECODE(p_label,hr_api.g_varchar2,tpptl.label,p_label)

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;

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

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

Line 1020: IF p_label <> hr_api.g_varchar2 THEN

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

Line 1043: raise hr_api.validate_enabled;

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

Line 1054: when hr_api.validate_enabled then

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