112: --
113: -- When in validation only mode raise the Validate_Enabled exception
114: --
115: if p_validate then
116: raise hr_api.validate_enabled;
117: end if;
118: --
119: -- Set all output arguments
120: --
122: p_object_version_number := l_object_version_number;
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 70);
125: exception
126: when hr_api.validate_enabled then
127: --
128: -- As the Validate_Enabled exception has been raised
129: -- we must rollback to the savepoint
130: --
157: ,p_object_version_number in out nocopy number
158: ,p_application_id in number default null
159: ,p_form_id in number default null
160: ,p_form_template_id in number default null
161: ,p_help_target in varchar2 default hr_api.g_varchar2
162: ,p_information_category in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
158: ,p_application_id in number default null
159: ,p_form_id in number default null
160: ,p_form_template_id in number default null
161: ,p_help_target in varchar2 default hr_api.g_varchar2
162: ,p_information_category in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
159: ,p_form_id in number default null
160: ,p_form_template_id in number default null
161: ,p_help_target in varchar2 default hr_api.g_varchar2
162: ,p_information_category in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
160: ,p_form_template_id in number default null
161: ,p_help_target in varchar2 default hr_api.g_varchar2
162: ,p_information_category in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
161: ,p_help_target in varchar2 default hr_api.g_varchar2
162: ,p_information_category in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
162: ,p_information_category in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
163: ,p_information1 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
164: ,p_information2 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
165: ,p_information3 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
166: ,p_information4 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
167: ,p_information5 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
168: ,p_information6 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
169: ,p_information7 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
170: ,p_information8 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
171: ,p_information9 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
172: ,p_information10 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
173: ,p_information11 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
174: ,p_information12 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
175: ,p_information13 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
176: ,p_information14 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
177: ,p_information15 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
178: ,p_information16 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
179: ,p_information17 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
180: ,p_information18 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
181: ,p_information19 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
182: ,p_information20 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
183: ,p_information21 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
191: ,p_information29 in varchar2 default hr_api.g_varchar2
184: ,p_information22 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
191: ,p_information29 in varchar2 default hr_api.g_varchar2
192: ,p_information30 in varchar2 default hr_api.g_varchar2
185: ,p_information23 in varchar2 default hr_api.g_varchar2
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
191: ,p_information29 in varchar2 default hr_api.g_varchar2
192: ,p_information30 in varchar2 default hr_api.g_varchar2
193: ) is
186: ,p_information24 in varchar2 default hr_api.g_varchar2
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
191: ,p_information29 in varchar2 default hr_api.g_varchar2
192: ,p_information30 in varchar2 default hr_api.g_varchar2
193: ) is
194: --
187: ,p_information25 in varchar2 default hr_api.g_varchar2
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
191: ,p_information29 in varchar2 default hr_api.g_varchar2
192: ,p_information30 in varchar2 default hr_api.g_varchar2
193: ) is
194: --
195: -- Declare cursors and local variables
188: ,p_information26 in varchar2 default hr_api.g_varchar2
189: ,p_information27 in varchar2 default hr_api.g_varchar2
190: ,p_information28 in varchar2 default hr_api.g_varchar2
191: ,p_information29 in varchar2 default hr_api.g_varchar2
192: ,p_information30 in varchar2 default hr_api.g_varchar2
193: ) is
194: --
195: -- Declare cursors and local variables
196: --
315: --
316: hr_utility.set_location('At:'|| l_proc, 35);
317:
318: if p_validate then
319: raise hr_api.validate_enabled;
320: end if;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
320: end if;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
327: -- we must rollback to the savepoint
328: --
442: --
443: hr_utility.set_location('At:'|| l_proc, 35);
444:
445: if p_validate then
446: raise hr_api.validate_enabled;
447: end if;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: exception
447: end if;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: exception
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised
454: -- we must rollback to the savepoint
455: --
479: ,p_effective_date in date
480: ,p_application_id in number
481: ,p_form_id in number
482: ,p_form_template_id in number
483: ,p_help_target in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
480: ,p_application_id in number
481: ,p_form_id in number
482: ,p_form_template_id in number
483: ,p_help_target in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
481: ,p_form_id in number
482: ,p_form_template_id in number
483: ,p_help_target in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
482: ,p_form_template_id in number
483: ,p_help_target in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
483: ,p_help_target in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
484: ,p_information_category in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
485: ,p_information1 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
486: ,p_information2 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
487: ,p_information3 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
488: ,p_information4 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
489: ,p_information5 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
490: ,p_information6 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
491: ,p_information7 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
492: ,p_information8 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
493: ,p_information9 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
494: ,p_information10 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
495: ,p_information11 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
496: ,p_information12 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
497: ,p_information13 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
498: ,p_information14 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
499: ,p_information15 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
500: ,p_information16 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
501: ,p_information17 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
502: ,p_information18 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
503: ,p_information19 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
504: ,p_information20 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
505: ,p_information21 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
506: ,p_information22 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
507: ,p_information23 in varchar2 default hr_api.g_varchar2
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_form_property_id out nocopy number
508: ,p_information24 in varchar2 default hr_api.g_varchar2
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_form_property_id out nocopy number
516: ,p_object_version_number out nocopy number
509: ,p_information25 in varchar2 default hr_api.g_varchar2
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_form_property_id out nocopy number
516: ,p_object_version_number out nocopy number
517: ) is
510: ,p_information26 in varchar2 default hr_api.g_varchar2
511: ,p_information27 in varchar2 default hr_api.g_varchar2
512: ,p_information28 in varchar2 default hr_api.g_varchar2
513: ,p_information29 in varchar2 default hr_api.g_varchar2
514: ,p_information30 in varchar2 default hr_api.g_varchar2
515: ,p_form_property_id out nocopy number
516: ,p_object_version_number out nocopy number
517: ) is
518: --
559:
560: -- ask john , bpd says default for all is information1
561: CURSOR cur_form_properties
562: IS
563: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
564: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
560: -- ask john , bpd says default for all is information1
561: CURSOR cur_form_properties
562: IS
563: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
564: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
561: CURSOR cur_form_properties
562: IS
563: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
564: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
562: IS
563: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
564: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
563: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
564: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
564: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
565: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
566: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
567: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
568: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
569: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
570: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
571: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
572: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
573: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
574: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
575: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
576: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
577: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
578: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
579: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
580: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
581: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
582: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
583: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
584: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
585: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
586: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
587: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
588: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
589: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
597: WHERE fmp.application_id (+) = fnd.application_id
590: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
591: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
597: WHERE fmp.application_id (+) = fnd.application_id
598: AND fnd.application_id = p_application_id
688: --
689: hr_utility.set_location('At:'|| l_proc, 30);
690:
691: if p_validate then
692: raise hr_api.validate_enabled;
693: end if;
694: --
695: -- Set all output arguments
696: --
698: p_object_version_number := l_object_version_number;
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 70);
701: exception
702: when hr_api.validate_enabled then
703: --
704: -- As the Validate_Enabled exception has been raised
705: -- we must rollback to the savepoint
706: --
730: (p_validate in boolean default false
731: ,p_effective_date in date
732: ,p_form_template_id_to in number
733: ,p_form_template_id_from in number
734: ,p_help_target in varchar2 default hr_api.g_varchar2
735: ,p_information_category in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
731: ,p_effective_date in date
732: ,p_form_template_id_to in number
733: ,p_form_template_id_from in number
734: ,p_help_target in varchar2 default hr_api.g_varchar2
735: ,p_information_category in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
732: ,p_form_template_id_to in number
733: ,p_form_template_id_from in number
734: ,p_help_target in varchar2 default hr_api.g_varchar2
735: ,p_information_category in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
733: ,p_form_template_id_from in number
734: ,p_help_target in varchar2 default hr_api.g_varchar2
735: ,p_information_category in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
734: ,p_help_target in varchar2 default hr_api.g_varchar2
735: ,p_information_category in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
735: ,p_information_category in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
736: ,p_information1 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
737: ,p_information2 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
738: ,p_information3 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
739: ,p_information4 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
740: ,p_information5 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
741: ,p_information6 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
742: ,p_information7 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
743: ,p_information8 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
744: ,p_information9 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
745: ,p_information10 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
746: ,p_information11 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
747: ,p_information12 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
748: ,p_information13 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
749: ,p_information14 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
750: ,p_information15 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
751: ,p_information16 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
752: ,p_information17 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
753: ,p_information18 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
754: ,p_information19 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
755: ,p_information20 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
756: ,p_information21 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
764: ,p_information29 in varchar2 default hr_api.g_varchar2
757: ,p_information22 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
764: ,p_information29 in varchar2 default hr_api.g_varchar2
765: ,p_information30 in varchar2 default hr_api.g_varchar2
758: ,p_information23 in varchar2 default hr_api.g_varchar2
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
764: ,p_information29 in varchar2 default hr_api.g_varchar2
765: ,p_information30 in varchar2 default hr_api.g_varchar2
766: ,p_form_property_id out nocopy number
759: ,p_information24 in varchar2 default hr_api.g_varchar2
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
764: ,p_information29 in varchar2 default hr_api.g_varchar2
765: ,p_information30 in varchar2 default hr_api.g_varchar2
766: ,p_form_property_id out nocopy number
767: ,p_object_version_number out nocopy number
760: ,p_information25 in varchar2 default hr_api.g_varchar2
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
764: ,p_information29 in varchar2 default hr_api.g_varchar2
765: ,p_information30 in varchar2 default hr_api.g_varchar2
766: ,p_form_property_id out nocopy number
767: ,p_object_version_number out nocopy number
768: ) is
761: ,p_information26 in varchar2 default hr_api.g_varchar2
762: ,p_information27 in varchar2 default hr_api.g_varchar2
763: ,p_information28 in varchar2 default hr_api.g_varchar2
764: ,p_information29 in varchar2 default hr_api.g_varchar2
765: ,p_information30 in varchar2 default hr_api.g_varchar2
766: ,p_form_property_id out nocopy number
767: ,p_object_version_number out nocopy number
768: ) is
769: --
809:
810: -- ask john , bpd says default for all is information1
811: CURSOR cur_form_properties
812: IS
813: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
814: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
810: -- ask john , bpd says default for all is information1
811: CURSOR cur_form_properties
812: IS
813: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
814: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
811: CURSOR cur_form_properties
812: IS
813: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
814: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
812: IS
813: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
814: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
813: SELECT DECODE(p_help_target,hr_api.g_varchar2,fmp.help_target,p_help_target)
814: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
814: ,DECODE(p_information_category,hr_api.g_varchar2,fmp.information_category,p_information_category)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
815: ,DECODE(p_information1,hr_api.g_varchar2,fmp.information1,p_information1)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
816: ,DECODE(p_information2,hr_api.g_varchar2,fmp.information2,p_information2)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
817: ,DECODE(p_information3,hr_api.g_varchar2,fmp.information3,p_information3)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
818: ,DECODE(p_information4,hr_api.g_varchar2,fmp.information4,p_information4)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
819: ,DECODE(p_information5,hr_api.g_varchar2,fmp.information5,p_information5)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
820: ,DECODE(p_information6,hr_api.g_varchar2,fmp.information6,p_information6)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
821: ,DECODE(p_information7,hr_api.g_varchar2,fmp.information7,p_information7)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
822: ,DECODE(p_information8,hr_api.g_varchar2,fmp.information8,p_information8)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
823: ,DECODE(p_information9,hr_api.g_varchar2,fmp.information9,p_information9)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
824: ,DECODE(p_information10,hr_api.g_varchar2,fmp.information10,p_information10)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
825: ,DECODE(p_information11,hr_api.g_varchar2,fmp.information11,p_information11)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
826: ,DECODE(p_information12,hr_api.g_varchar2,fmp.information12,p_information12)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
827: ,DECODE(p_information13,hr_api.g_varchar2,fmp.information13,p_information13)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
828: ,DECODE(p_information14,hr_api.g_varchar2,fmp.information14,p_information14)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
829: ,DECODE(p_information15,hr_api.g_varchar2,fmp.information15,p_information15)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
830: ,DECODE(p_information16,hr_api.g_varchar2,fmp.information16,p_information16)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
831: ,DECODE(p_information17,hr_api.g_varchar2,fmp.information17,p_information17)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
832: ,DECODE(p_information18,hr_api.g_varchar2,fmp.information18,p_information18)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
833: ,DECODE(p_information19,hr_api.g_varchar2,fmp.information19,p_information19)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
834: ,DECODE(p_information20,hr_api.g_varchar2,fmp.information20,p_information20)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
835: ,DECODE(p_information21,hr_api.g_varchar2,fmp.information21,p_information21)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
836: ,DECODE(p_information22,hr_api.g_varchar2,fmp.information22,p_information22)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
837: ,DECODE(p_information23,hr_api.g_varchar2,fmp.information23,p_information23)
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
845: FROM hr_form_properties fmp
838: ,DECODE(p_information24,hr_api.g_varchar2,fmp.information24,p_information24)
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
845: FROM hr_form_properties fmp
846: ,hr_form_templates_b hft
839: ,DECODE(p_information25,hr_api.g_varchar2,fmp.information25,p_information25)
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
845: FROM hr_form_properties fmp
846: ,hr_form_templates_b hft
847: WHERE fmp.form_template_id (+) = hft.form_template_id
840: ,DECODE(p_information26,hr_api.g_varchar2,fmp.information26,p_information26)
841: ,DECODE(p_information27,hr_api.g_varchar2,fmp.information27,p_information27)
842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
845: FROM hr_form_properties fmp
846: ,hr_form_templates_b hft
847: WHERE fmp.form_template_id (+) = hft.form_template_id
848: AND hft.form_template_id = p_form_template_id_from;
944: --
945: hr_utility.set_location('At:'|| l_proc, 30);
946:
947: if p_validate then
948: raise hr_api.validate_enabled;
949: end if;
950: --
951: -- Set all output arguments
952: --
954: p_object_version_number := l_object_version_number;
955: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: exception
958: when hr_api.validate_enabled then
959: --
960: -- As the Validate_Enabled exception has been raised
961: -- we must rollback to the savepoint
962: --