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

APPS.HR_WINDOW_PROPERTIES_BSI dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

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

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

75: -- instead of p_language_code from now on, to allow an IN OUT parameter to
76: -- be passed through.
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82: --
83: --

Line 136: raise hr_api.validate_enabled;

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

Line 145: when hr_api.validate_enabled then

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

Line 175: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 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

Line 180: ,p_title in varchar2 default hr_api.g_varchar2

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

Line 181: ,p_width in number default hr_api.g_number

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

Line 182: ,p_x_position in number default hr_api.g_number

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

Line 183: ,p_y_position in number default hr_api.g_number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 214: ,p_information30 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
218: --

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

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

Line 355: raise hr_api.validate_enabled;

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

Line 360: when hr_api.validate_enabled then

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

Line 480: raise hr_api.validate_enabled;

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

Line 485: when hr_api.validate_enabled then

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

Line 514: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 517: ,p_height in number default hr_api.g_number

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

Line 518: ,p_title in varchar2 default hr_api.g_varchar2

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

Line 519: ,p_width in number default hr_api.g_number

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

Line 520: ,p_x_position in number default hr_api.g_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
524: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 521: ,p_y_position in number default hr_api.g_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
525: ,p_information3 in varchar2 default hr_api.g_varchar2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 550: ,p_information28 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
554: ) is

Line 551: ,p_information29 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
555: --

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

Line 600: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)

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)

Line 601: -- ,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)

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)

Line 602: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)

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)

Line 603: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)

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)

Line 604: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)

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)

Line 605: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)

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)

Line 606: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)

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)

Line 607: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)

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)

Line 608: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)

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)

Line 609: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)

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)

Line 610: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)

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)

Line 611: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)

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)

Line 612: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)

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)

Line 613: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)

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)

Line 614: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)

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)

Line 615: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)

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)

Line 616: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)

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)

Line 617: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)

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)

Line 618: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)

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)

Line 619: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)

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)

Line 620: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)

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)

Line 621: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)

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)

Line 622: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)

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)

Line 623: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)

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)

Line 624: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)

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)

Line 625: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)

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)

Line 626: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)

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)

Line 627: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)

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)

Line 628: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)

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)

Line 629: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)

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)

Line 630: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)

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)

Line 631: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)

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)

Line 632: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)

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

Line 633: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)

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;

Line 634: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)

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:

Line 635: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)

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

Line 650: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title

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

Line 656: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)

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 ;

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

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

Line 749: IF p_title <> hr_api.g_varchar2 THEN

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

Line 784: raise hr_api.validate_enabled;

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

Line 793: when hr_api.validate_enabled then

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

Line 823: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 826: ,p_height in number default hr_api.g_number

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

Line 827: ,p_title in varchar2 default hr_api.g_varchar2

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

Line 828: ,p_width in number default hr_api.g_number

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

Line 829: ,p_x_position in number default hr_api.g_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
833: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 830: ,p_y_position in number default hr_api.g_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
834: ,p_information3 in varchar2 default hr_api.g_varchar2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 859: ,p_information28 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
863: ) is

Line 860: ,p_information29 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
864: --

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

Line 909: SELECT DECODE(p_height,hr_api.g_number,wnp.height,p_height)

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)

Line 910: --,DECODE(p_title,hr_api.g_varchar2,wnp.title,p_title)

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)

Line 911: ,DECODE(p_width,hr_api.g_number,wnp.width,p_width)

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)

Line 912: ,DECODE(p_x_position,hr_api.g_number,wnp.x_position,p_x_position)

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)

Line 913: ,DECODE(p_y_position,hr_api.g_number,wnp.y_position,p_y_position)

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)

Line 914: ,DECODE(p_information_category,hr_api.g_varchar2,wnp.information_category,p_information_category)

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)

Line 915: ,DECODE(p_information1,hr_api.g_varchar2,wnp.information1,p_information1)

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)

Line 916: ,DECODE(p_information2,hr_api.g_varchar2,wnp.information2,p_information2)

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)

Line 917: ,DECODE(p_information3,hr_api.g_varchar2,wnp.information3,p_information3)

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)

Line 918: ,DECODE(p_information4,hr_api.g_varchar2,wnp.information4,p_information4)

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)

Line 919: ,DECODE(p_information5,hr_api.g_varchar2,wnp.information5,p_information5)

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)

Line 920: ,DECODE(p_information6,hr_api.g_varchar2,wnp.information6,p_information6)

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)

Line 921: ,DECODE(p_information7,hr_api.g_varchar2,wnp.information7,p_information7)

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)

Line 922: ,DECODE(p_information8,hr_api.g_varchar2,wnp.information8,p_information8)

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)

Line 923: ,DECODE(p_information9,hr_api.g_varchar2,wnp.information9,p_information9)

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)

Line 924: ,DECODE(p_information10,hr_api.g_varchar2,wnp.information10,p_information10)

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)

Line 925: ,DECODE(p_information11,hr_api.g_varchar2,wnp.information11,p_information11)

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)

Line 926: ,DECODE(p_information12,hr_api.g_varchar2,wnp.information12,p_information12)

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)

Line 927: ,DECODE(p_information13,hr_api.g_varchar2,wnp.information13,p_information13)

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)

Line 928: ,DECODE(p_information14,hr_api.g_varchar2,wnp.information14,p_information14)

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)

Line 929: ,DECODE(p_information15,hr_api.g_varchar2,wnp.information15,p_information15)

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)

Line 930: ,DECODE(p_information16,hr_api.g_varchar2,wnp.information16,p_information16)

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)

Line 931: ,DECODE(p_information17,hr_api.g_varchar2,wnp.information17,p_information17)

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)

Line 932: ,DECODE(p_information18,hr_api.g_varchar2,wnp.information18,p_information18)

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)

Line 933: ,DECODE(p_information19,hr_api.g_varchar2,wnp.information19,p_information19)

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)

Line 934: ,DECODE(p_information20,hr_api.g_varchar2,wnp.information20,p_information20)

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)

Line 935: ,DECODE(p_information21,hr_api.g_varchar2,wnp.information21,p_information21)

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)

Line 936: ,DECODE(p_information22,hr_api.g_varchar2,wnp.information22,p_information22)

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)

Line 937: ,DECODE(p_information23,hr_api.g_varchar2,wnp.information23,p_information23)

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)

Line 938: ,DECODE(p_information24,hr_api.g_varchar2,wnp.information24,p_information24)

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)

Line 939: ,DECODE(p_information25,hr_api.g_varchar2,wnp.information25,p_information25)

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)

Line 940: ,DECODE(p_information26,hr_api.g_varchar2,wnp.information26,p_information26)

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)

Line 941: ,DECODE(p_information27,hr_api.g_varchar2,wnp.information27,p_information27)

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

Line 942: ,DECODE(p_information28,hr_api.g_varchar2,wnp.information28,p_information28)

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;

Line 943: ,DECODE(p_information29,hr_api.g_varchar2,wnp.information29,p_information29)

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:

Line 944: ,DECODE(p_information30,hr_api.g_varchar2,wnp.information30,p_information30)

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;

Line 964: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title) title

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

Line 970: ,DECODE(p_title,hr_api.g_varchar2,wnptl.title,p_title)

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

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

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

Line 1062: IF p_title <> hr_api.g_varchar2 THEN

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

Line 1095: raise hr_api.validate_enabled;

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

Line 1104: when hr_api.validate_enabled then

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