11: --
12: procedure create_window_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_window_id in number default null
17: ,p_template_window_id in number default null
18: ,p_height in number default null
19: ,p_title in varchar2 default null
75: -- instead of p_language_code from now on, to allow an IN OUT parameter to
76: -- be passed through.
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82: --
83: --
132: --
133: -- When in validation only mode raise the Validate_Enabled exception
134: --
135: if p_validate then
136: raise hr_api.validate_enabled;
137: end if;
138: --
139: -- Set all output arguments
140: --
141: p_window_property_id := l_window_property_id;
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: exception
145: when hr_api.validate_enabled then
146: --
147: -- As the Validate_Enabled exception has been raised
148: -- we must rollback to the savepoint
149: --
171: --
172: procedure update_window_property
173: (p_validate in boolean default false
174: ,p_effective_date in date
175: ,p_language_code in varchar2 default hr_api.userenv_lang
176: ,p_window_property_id in number default null
177: ,p_form_window_id in number default null
178: ,p_template_window_id in number default null
179: ,p_height in number default hr_api.g_number
175: ,p_language_code in varchar2 default hr_api.userenv_lang
176: ,p_window_property_id in number default null
177: ,p_form_window_id in number default null
178: ,p_template_window_id in number default null
179: ,p_height in number default hr_api.g_number
180: ,p_title in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
176: ,p_window_property_id in number default null
177: ,p_form_window_id in number default null
178: ,p_template_window_id in number default null
179: ,p_height in number default hr_api.g_number
180: ,p_title in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
177: ,p_form_window_id in number default null
178: ,p_template_window_id in number default null
179: ,p_height in number default hr_api.g_number
180: ,p_title in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
178: ,p_template_window_id in number default null
179: ,p_height in number default hr_api.g_number
180: ,p_title in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
179: ,p_height in number default hr_api.g_number
180: ,p_title in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
180: ,p_title in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
181: ,p_width in number default hr_api.g_number
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
182: ,p_x_position in number default hr_api.g_number
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
183: ,p_y_position in number default hr_api.g_number
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
184: ,p_information_category in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
185: ,p_information1 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
186: ,p_information2 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
187: ,p_information3 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
188: ,p_information4 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
189: ,p_information5 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
190: ,p_information6 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
191: ,p_information7 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
192: ,p_information8 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
193: ,p_information9 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
194: ,p_information10 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
195: ,p_information11 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
196: ,p_information12 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
197: ,p_information13 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
198: ,p_information14 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
199: ,p_information15 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
200: ,p_information16 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
201: ,p_information17 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
202: ,p_information18 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
203: ,p_information19 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
204: ,p_information20 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
205: ,p_information21 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
213: ,p_information29 in varchar2 default hr_api.g_varchar2
206: ,p_information22 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
213: ,p_information29 in varchar2 default hr_api.g_varchar2
214: ,p_information30 in varchar2 default hr_api.g_varchar2
207: ,p_information23 in varchar2 default hr_api.g_varchar2
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
213: ,p_information29 in varchar2 default hr_api.g_varchar2
214: ,p_information30 in varchar2 default hr_api.g_varchar2
215: ) is
208: ,p_information24 in varchar2 default hr_api.g_varchar2
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
213: ,p_information29 in varchar2 default hr_api.g_varchar2
214: ,p_information30 in varchar2 default hr_api.g_varchar2
215: ) is
216: --
209: ,p_information25 in varchar2 default hr_api.g_varchar2
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
213: ,p_information29 in varchar2 default hr_api.g_varchar2
214: ,p_information30 in varchar2 default hr_api.g_varchar2
215: ) is
216: --
217: -- Declare cursors and local variables
210: ,p_information26 in varchar2 default hr_api.g_varchar2
211: ,p_information27 in varchar2 default hr_api.g_varchar2
212: ,p_information28 in varchar2 default hr_api.g_varchar2
213: ,p_information29 in varchar2 default hr_api.g_varchar2
214: ,p_information30 in varchar2 default hr_api.g_varchar2
215: ) is
216: --
217: -- Declare cursors and local variables
218: --
247: -- instead of p_language_code from now on, to allow an IN OUT parameter to
248: -- be passed through.
249: --
250: l_language_code := p_language_code;
251: hr_api.validate_language_code(p_language_code => l_language_code);
252: --
253: hr_utility.set_location(l_proc, 20);
254: --
255: --
351: --
352: -- When in validation only mode raise the Validate_Enabled exception
353: --
354: if p_validate then
355: raise hr_api.validate_enabled;
356: end if;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 70);
359: exception
356: end if;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 70);
359: exception
360: when hr_api.validate_enabled then
361: --
362: -- As the Validate_Enabled exception has been raised
363: -- we must rollback to the savepoint
364: --
476: --
477: -- When in validation only mode raise the Validate_Enabled exception
478: --
479: if p_validate then
480: raise hr_api.validate_enabled;
481: end if;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 70);
484: exception
481: end if;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 70);
484: exception
485: when hr_api.validate_enabled then
486: --
487: -- As the Validate_Enabled exception has been raised
488: -- we must rollback to the savepoint
489: --
510: --
511: procedure copy_window_property
512: (p_validate in boolean default false
513: ,p_effective_date in date
514: ,p_language_code in varchar2 default hr_api.userenv_lang
515: ,p_form_window_id in number
516: ,p_template_window_id in number
517: ,p_height in number default hr_api.g_number
518: ,p_title in varchar2 default hr_api.g_varchar2
513: ,p_effective_date in date
514: ,p_language_code in varchar2 default hr_api.userenv_lang
515: ,p_form_window_id in number
516: ,p_template_window_id in number
517: ,p_height in number default hr_api.g_number
518: ,p_title in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
514: ,p_language_code in varchar2 default hr_api.userenv_lang
515: ,p_form_window_id in number
516: ,p_template_window_id in number
517: ,p_height in number default hr_api.g_number
518: ,p_title in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
515: ,p_form_window_id in number
516: ,p_template_window_id in number
517: ,p_height in number default hr_api.g_number
518: ,p_title in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
516: ,p_template_window_id in number
517: ,p_height in number default hr_api.g_number
518: ,p_title in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
517: ,p_height in number default hr_api.g_number
518: ,p_title in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
518: ,p_title in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
519: ,p_width in number default hr_api.g_number
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
520: ,p_x_position in number default hr_api.g_number
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
521: ,p_y_position in number default hr_api.g_number
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
522: ,p_information_category in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
523: ,p_information1 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
524: ,p_information2 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
525: ,p_information3 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
526: ,p_information4 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
527: ,p_information5 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
528: ,p_information6 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
529: ,p_information7 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
530: ,p_information8 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
531: ,p_information9 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
532: ,p_information10 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
533: ,p_information11 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
534: ,p_information12 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
535: ,p_information13 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
536: ,p_information14 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
537: ,p_information15 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
538: ,p_information16 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
539: ,p_information17 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
540: ,p_information18 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
541: ,p_information19 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
542: ,p_information20 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
543: ,p_information21 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
551: ,p_information29 in varchar2 default hr_api.g_varchar2
544: ,p_information22 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
551: ,p_information29 in varchar2 default hr_api.g_varchar2
552: ,p_information30 in varchar2 default hr_api.g_varchar2
545: ,p_information23 in varchar2 default hr_api.g_varchar2
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
551: ,p_information29 in varchar2 default hr_api.g_varchar2
552: ,p_information30 in varchar2 default hr_api.g_varchar2
553: ,p_window_property_id out nocopy number
546: ,p_information24 in varchar2 default hr_api.g_varchar2
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
551: ,p_information29 in varchar2 default hr_api.g_varchar2
552: ,p_information30 in varchar2 default hr_api.g_varchar2
553: ,p_window_property_id out nocopy number
554: ) is
547: ,p_information25 in varchar2 default hr_api.g_varchar2
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
551: ,p_information29 in varchar2 default hr_api.g_varchar2
552: ,p_information30 in varchar2 default hr_api.g_varchar2
553: ,p_window_property_id out nocopy number
554: ) is
555: --
548: ,p_information26 in varchar2 default hr_api.g_varchar2
549: ,p_information27 in varchar2 default hr_api.g_varchar2
550: ,p_information28 in varchar2 default hr_api.g_varchar2
551: ,p_information29 in varchar2 default hr_api.g_varchar2
552: ,p_information30 in varchar2 default hr_api.g_varchar2
553: ,p_window_property_id out nocopy number
554: ) is
555: --
556: -- Declare cursors and local variables
596: l_rec l_rec_type;
597:
598: CURSOR cur_win_prop
599: IS
600: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
597:
598: CURSOR cur_win_prop
599: IS
600: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
598: CURSOR cur_win_prop
599: IS
600: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
599: IS
600: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
600: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
636: FROM hr_window_properties_b wnp
629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
636: FROM hr_window_properties_b wnp
637: WHERE wnp.form_window_id = p_form_window_id;
630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
636: FROM hr_window_properties_b wnp
637: WHERE wnp.form_window_id = p_form_window_id;
638:
631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
636: FROM hr_window_properties_b wnp
637: WHERE wnp.form_window_id = p_form_window_id;
638:
639: CURSOR cur_check
646: CURSOR cur_win_tl
647: IS
648: SELECT COUNT(0)
649: ,wnptl.source_lang
650: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title
651: FROM hr_window_properties_tl wnptl
652: ,hr_window_properties_b wnp
653: WHERE wnptl.window_property_id = wnp.window_property_id
654: AND wnp.form_window_id = p_form_window_id
652: ,hr_window_properties_b wnp
653: WHERE wnptl.window_property_id = wnp.window_property_id
654: AND wnp.form_window_id = p_form_window_id
655: GROUP BY wnptl.source_lang
656: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)
657: ORDER BY 1;
658:
659: l_check number;
660: l_window_property_id number ;
673: -- instead of p_language_code from now on, to allow an IN OUT parameter to
674: -- be passed through.
675: --
676: l_language_code := p_language_code;
677: hr_api.validate_language_code(p_language_code => l_language_code);
678: --
679: hr_utility.set_location(l_proc, 20);
680: --
681: --
745: ,p_window_property_id => l_window_property_id);
746:
747: hr_utility.set_location('At:'|| l_proc, 30);
748:
749: IF p_title <> hr_api.g_varchar2 THEN
750: hr_utility.set_location('At:'|| l_proc, 35);
751:
752: hr_wpt_ins.ins_tl(
753: p_language_code => l_language_code
780: --
781: -- When in validation only mode raise the Validate_Enabled exception
782: --
783: if p_validate then
784: raise hr_api.validate_enabled;
785: end if;
786: --
787: -- Set all output arguments
788: --
789: p_window_property_id := l_window_property_id;
790: --
791: hr_utility.set_location(' Leaving:'||l_proc, 70);
792: exception
793: when hr_api.validate_enabled then
794: --
795: -- As the Validate_Enabled exception has been raised
796: -- we must rollback to the savepoint
797: --
819: --
820: procedure copy_window_property
821: (p_validate in boolean default false
822: ,p_effective_date in date
823: ,p_language_code in varchar2 default hr_api.userenv_lang
824: ,p_template_window_id_from in number
825: ,p_template_window_id_to in number
826: ,p_height in number default hr_api.g_number
827: ,p_title in varchar2 default hr_api.g_varchar2
822: ,p_effective_date in date
823: ,p_language_code in varchar2 default hr_api.userenv_lang
824: ,p_template_window_id_from in number
825: ,p_template_window_id_to in number
826: ,p_height in number default hr_api.g_number
827: ,p_title in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
823: ,p_language_code in varchar2 default hr_api.userenv_lang
824: ,p_template_window_id_from in number
825: ,p_template_window_id_to in number
826: ,p_height in number default hr_api.g_number
827: ,p_title in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
824: ,p_template_window_id_from in number
825: ,p_template_window_id_to in number
826: ,p_height in number default hr_api.g_number
827: ,p_title in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
825: ,p_template_window_id_to in number
826: ,p_height in number default hr_api.g_number
827: ,p_title in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
826: ,p_height in number default hr_api.g_number
827: ,p_title in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
827: ,p_title in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
828: ,p_width in number default hr_api.g_number
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
829: ,p_x_position in number default hr_api.g_number
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
830: ,p_y_position in number default hr_api.g_number
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
831: ,p_information_category in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
832: ,p_information1 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
833: ,p_information2 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
834: ,p_information3 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
835: ,p_information4 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
836: ,p_information5 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
837: ,p_information6 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
838: ,p_information7 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
839: ,p_information8 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
840: ,p_information9 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
841: ,p_information10 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
842: ,p_information11 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
843: ,p_information12 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
844: ,p_information13 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
845: ,p_information14 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
846: ,p_information15 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
847: ,p_information16 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
848: ,p_information17 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
849: ,p_information18 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
850: ,p_information19 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
851: ,p_information20 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
852: ,p_information21 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
860: ,p_information29 in varchar2 default hr_api.g_varchar2
853: ,p_information22 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
860: ,p_information29 in varchar2 default hr_api.g_varchar2
861: ,p_information30 in varchar2 default hr_api.g_varchar2
854: ,p_information23 in varchar2 default hr_api.g_varchar2
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
860: ,p_information29 in varchar2 default hr_api.g_varchar2
861: ,p_information30 in varchar2 default hr_api.g_varchar2
862: ,p_window_property_id out nocopy number
855: ,p_information24 in varchar2 default hr_api.g_varchar2
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
860: ,p_information29 in varchar2 default hr_api.g_varchar2
861: ,p_information30 in varchar2 default hr_api.g_varchar2
862: ,p_window_property_id out nocopy number
863: ) is
856: ,p_information25 in varchar2 default hr_api.g_varchar2
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
860: ,p_information29 in varchar2 default hr_api.g_varchar2
861: ,p_information30 in varchar2 default hr_api.g_varchar2
862: ,p_window_property_id out nocopy number
863: ) is
864: --
857: ,p_information26 in varchar2 default hr_api.g_varchar2
858: ,p_information27 in varchar2 default hr_api.g_varchar2
859: ,p_information28 in varchar2 default hr_api.g_varchar2
860: ,p_information29 in varchar2 default hr_api.g_varchar2
861: ,p_information30 in varchar2 default hr_api.g_varchar2
862: ,p_window_property_id out nocopy number
863: ) is
864: --
865: -- Declare cursors and local variables
905: l_rec l_rec_type;
906:
907: CURSOR cur_win_prop
908: IS
909: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
906:
907: CURSOR cur_win_prop
908: IS
909: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
907: CURSOR cur_win_prop
908: IS
909: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
908: IS
909: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
909: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)
910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
945: FROM hr_window_properties_b wnp
938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
945: FROM hr_window_properties_b wnp
946: WHERE wnp.template_window_id = p_template_window_id_from;
939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
945: FROM hr_window_properties_b wnp
946: WHERE wnp.template_window_id = p_template_window_id_from;
947:
940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)
941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)
942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)
943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)
944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)
945: FROM hr_window_properties_b wnp
946: WHERE wnp.template_window_id = p_template_window_id_from;
947:
948: l_form_window_id number;
960: CURSOR cur_win_tl
961: IS
962: SELECT COUNT(0)
963: ,wnptl.source_lang
964: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title
965: FROM hr_window_properties_tl wnptl
966: ,hr_window_properties_b wnp
967: WHERE wnptl.window_property_id = wnp.window_property_id
968: AND wnp.form_window_id = l_form_window_id
966: ,hr_window_properties_b wnp
967: WHERE wnptl.window_property_id = wnp.window_property_id
968: AND wnp.form_window_id = l_form_window_id
969: GROUP BY wnptl.source_lang
970: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)
971: ORDER BY 1;
972:
973: l_window_property_id number ;
974: l_proc varchar2(72) := g_package||'copy_window_property';
986: -- instead of p_language_code from now on, to allow an IN OUT parameter to
987: -- be passed through.
988: --
989: l_language_code := p_language_code;
990: hr_api.validate_language_code(p_language_code => l_language_code);
991: --
992: hr_utility.set_location(l_proc, 20);
993: --
994: --
1058: ,p_window_property_id => l_window_property_id);
1059:
1060: hr_utility.set_location('At:'|| l_proc, 30);
1061:
1062: IF p_title <> hr_api.g_varchar2 THEN
1063: hr_utility.set_location('At:'|| l_proc, 35);
1064:
1065: hr_wpt_ins.ins_tl(
1066: p_language_code => l_language_code
1091: --
1092: -- When in validation only mode raise the Validate_Enabled exception
1093: --
1094: if p_validate then
1095: raise hr_api.validate_enabled;
1096: end if;
1097: --
1098: -- Set all output arguments
1099: --
1100: p_window_property_id := l_window_property_id;
1101: --
1102: hr_utility.set_location(' Leaving:'||l_proc, 70);
1103: exception
1104: when hr_api.validate_enabled then
1105: --
1106: -- As the Validate_Enabled exception has been raised
1107: -- we must rollback to the savepoint
1108: --