APPS.HR_CANVAS_PROPERTIES_BSI dependencies on HR_API

Line 120: raise hr_api.validate_enabled;

116: --
117: -- When in validation only mode raise the Validate_Enabled exception
118: --
119: if p_validate then
120: raise hr_api.validate_enabled;
121: end if;
122: --
123: -- Set all output arguments
124: --

Line 130: when hr_api.validate_enabled then

126: p_object_version_number := l_object_version_number;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 70);
129: exception
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --

Line 164: ,p_height in number default hr_api.g_number

160: ,p_canvas_property_id in number default null
161: ,p_object_version_number in out nocopy number
162: ,p_form_canvas_id in number default null
163: ,p_template_canvas_id in number default null
164: ,p_height in number default hr_api.g_number
165: ,p_visible in number default hr_api.g_number
166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number

Line 165: ,p_visible in number default hr_api.g_number

161: ,p_object_version_number in out nocopy number
162: ,p_form_canvas_id in number default null
163: ,p_template_canvas_id in number default null
164: ,p_height in number default hr_api.g_number
165: ,p_visible in number default hr_api.g_number
166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 166: ,p_width in number default hr_api.g_number

162: ,p_form_canvas_id in number default null
163: ,p_template_canvas_id in number default null
164: ,p_height in number default hr_api.g_number
165: ,p_visible in number default hr_api.g_number
166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 167: ,p_x_position in number default hr_api.g_number

163: ,p_template_canvas_id in number default null
164: ,p_height in number default hr_api.g_number
165: ,p_visible in number default hr_api.g_number
166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 168: ,p_y_position in number default hr_api.g_number

164: ,p_height in number default hr_api.g_number
165: ,p_visible in number default hr_api.g_number
166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 169: ,p_information_category in varchar2 default hr_api.g_varchar2

165: ,p_visible in number default hr_api.g_number
166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 170: ,p_information1 in varchar2 default hr_api.g_varchar2

166: ,p_width in number default hr_api.g_number
167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 171: ,p_information2 in varchar2 default hr_api.g_varchar2

167: ,p_x_position in number default hr_api.g_number
168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 172: ,p_information3 in varchar2 default hr_api.g_varchar2

168: ,p_y_position in number default hr_api.g_number
169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 173: ,p_information4 in varchar2 default hr_api.g_varchar2

169: ,p_information_category in varchar2 default hr_api.g_varchar2
170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 174: ,p_information5 in varchar2 default hr_api.g_varchar2

170: ,p_information1 in varchar2 default hr_api.g_varchar2
171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 175: ,p_information6 in varchar2 default hr_api.g_varchar2

171: ,p_information2 in varchar2 default hr_api.g_varchar2
172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 176: ,p_information7 in varchar2 default hr_api.g_varchar2

172: ,p_information3 in varchar2 default hr_api.g_varchar2
173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 177: ,p_information8 in varchar2 default hr_api.g_varchar2

173: ,p_information4 in varchar2 default hr_api.g_varchar2
174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 178: ,p_information9 in varchar2 default hr_api.g_varchar2

174: ,p_information5 in varchar2 default hr_api.g_varchar2
175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 179: ,p_information10 in varchar2 default hr_api.g_varchar2

175: ,p_information6 in varchar2 default hr_api.g_varchar2
176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 180: ,p_information11 in varchar2 default hr_api.g_varchar2

176: ,p_information7 in varchar2 default hr_api.g_varchar2
177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 181: ,p_information12 in varchar2 default hr_api.g_varchar2

177: ,p_information8 in varchar2 default hr_api.g_varchar2
178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 182: ,p_information13 in varchar2 default hr_api.g_varchar2

178: ,p_information9 in varchar2 default hr_api.g_varchar2
179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 183: ,p_information14 in varchar2 default hr_api.g_varchar2

179: ,p_information10 in varchar2 default hr_api.g_varchar2
180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 184: ,p_information15 in varchar2 default hr_api.g_varchar2

180: ,p_information11 in varchar2 default hr_api.g_varchar2
181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 185: ,p_information16 in varchar2 default hr_api.g_varchar2

181: ,p_information12 in varchar2 default hr_api.g_varchar2
182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 186: ,p_information17 in varchar2 default hr_api.g_varchar2

182: ,p_information13 in varchar2 default hr_api.g_varchar2
183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 187: ,p_information18 in varchar2 default hr_api.g_varchar2

183: ,p_information14 in varchar2 default hr_api.g_varchar2
184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 188: ,p_information19 in varchar2 default hr_api.g_varchar2

184: ,p_information15 in varchar2 default hr_api.g_varchar2
185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 189: ,p_information20 in varchar2 default hr_api.g_varchar2

185: ,p_information16 in varchar2 default hr_api.g_varchar2
186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 190: ,p_information21 in varchar2 default hr_api.g_varchar2

186: ,p_information17 in varchar2 default hr_api.g_varchar2
187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 191: ,p_information22 in varchar2 default hr_api.g_varchar2

187: ,p_information18 in varchar2 default hr_api.g_varchar2
188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 192: ,p_information23 in varchar2 default hr_api.g_varchar2

188: ,p_information19 in varchar2 default hr_api.g_varchar2
189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 193: ,p_information24 in varchar2 default hr_api.g_varchar2

189: ,p_information20 in varchar2 default hr_api.g_varchar2
190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 194: ,p_information25 in varchar2 default hr_api.g_varchar2

190: ,p_information21 in varchar2 default hr_api.g_varchar2
191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2
198: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 195: ,p_information26 in varchar2 default hr_api.g_varchar2

191: ,p_information22 in varchar2 default hr_api.g_varchar2
192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2
198: ,p_information29 in varchar2 default hr_api.g_varchar2
199: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 196: ,p_information27 in varchar2 default hr_api.g_varchar2

192: ,p_information23 in varchar2 default hr_api.g_varchar2
193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2
198: ,p_information29 in varchar2 default hr_api.g_varchar2
199: ,p_information30 in varchar2 default hr_api.g_varchar2
200: ) is

Line 197: ,p_information28 in varchar2 default hr_api.g_varchar2

193: ,p_information24 in varchar2 default hr_api.g_varchar2
194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2
198: ,p_information29 in varchar2 default hr_api.g_varchar2
199: ,p_information30 in varchar2 default hr_api.g_varchar2
200: ) is
201: --

Line 198: ,p_information29 in varchar2 default hr_api.g_varchar2

194: ,p_information25 in varchar2 default hr_api.g_varchar2
195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2
198: ,p_information29 in varchar2 default hr_api.g_varchar2
199: ,p_information30 in varchar2 default hr_api.g_varchar2
200: ) is
201: --
202: -- Declare cursors and local variables

Line 199: ,p_information30 in varchar2 default hr_api.g_varchar2

195: ,p_information26 in varchar2 default hr_api.g_varchar2
196: ,p_information27 in varchar2 default hr_api.g_varchar2
197: ,p_information28 in varchar2 default hr_api.g_varchar2
198: ,p_information29 in varchar2 default hr_api.g_varchar2
199: ,p_information30 in varchar2 default hr_api.g_varchar2
200: ) is
201: --
202: -- Declare cursors and local variables
203: --

Line 326: raise hr_api.validate_enabled;

322: --
323: hr_utility.set_location('At:'|| l_proc, 50);
324:
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 70);
330: exception

Line 331: when hr_api.validate_enabled then

327: end if;
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 70);
330: exception
331: when hr_api.validate_enabled then
332: --
333: -- As the Validate_Enabled exception has been raised
334: -- we must rollback to the savepoint
335: --

Line 453: raise hr_api.validate_enabled;

449: --
450: hr_utility.set_location('At:'|| l_proc, 50);
451:
452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 70);
457: exception

Line 458: when hr_api.validate_enabled then

454: end if;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 70);
457: exception
458: when hr_api.validate_enabled then
459: --
460: -- As the Validate_Enabled exception has been raised
461: -- we must rollback to the savepoint
462: --

Line 489: ,p_height in number default hr_api.g_number

485: (p_validate in boolean default false
486: ,p_effective_date in date
487: ,p_form_canvas_id in number
488: ,p_template_canvas_id in number
489: ,p_height in number default hr_api.g_number
490: ,p_visible in number default hr_api.g_number
491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number

Line 490: ,p_visible in number default hr_api.g_number

486: ,p_effective_date in date
487: ,p_form_canvas_id in number
488: ,p_template_canvas_id in number
489: ,p_height in number default hr_api.g_number
490: ,p_visible in number default hr_api.g_number
491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 491: ,p_width in number default hr_api.g_number

487: ,p_form_canvas_id in number
488: ,p_template_canvas_id in number
489: ,p_height in number default hr_api.g_number
490: ,p_visible in number default hr_api.g_number
491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 492: ,p_x_position in number default hr_api.g_number

488: ,p_template_canvas_id in number
489: ,p_height in number default hr_api.g_number
490: ,p_visible in number default hr_api.g_number
491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 493: ,p_y_position in number default hr_api.g_number

489: ,p_height in number default hr_api.g_number
490: ,p_visible in number default hr_api.g_number
491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 494: ,p_information_category in varchar2 default hr_api.g_varchar2

490: ,p_visible in number default hr_api.g_number
491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 495: ,p_information1 in varchar2 default hr_api.g_varchar2

491: ,p_width in number default hr_api.g_number
492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 496: ,p_information2 in varchar2 default hr_api.g_varchar2

492: ,p_x_position in number default hr_api.g_number
493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 497: ,p_information3 in varchar2 default hr_api.g_varchar2

493: ,p_y_position in number default hr_api.g_number
494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 498: ,p_information4 in varchar2 default hr_api.g_varchar2

494: ,p_information_category in varchar2 default hr_api.g_varchar2
495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 499: ,p_information5 in varchar2 default hr_api.g_varchar2

495: ,p_information1 in varchar2 default hr_api.g_varchar2
496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 500: ,p_information6 in varchar2 default hr_api.g_varchar2

496: ,p_information2 in varchar2 default hr_api.g_varchar2
497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 501: ,p_information7 in varchar2 default hr_api.g_varchar2

497: ,p_information3 in varchar2 default hr_api.g_varchar2
498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 502: ,p_information8 in varchar2 default hr_api.g_varchar2

498: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 503: ,p_information9 in varchar2 default hr_api.g_varchar2

499: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 504: ,p_information10 in varchar2 default hr_api.g_varchar2

500: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 505: ,p_information11 in varchar2 default hr_api.g_varchar2

501: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 506: ,p_information12 in varchar2 default hr_api.g_varchar2

502: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 507: ,p_information13 in varchar2 default hr_api.g_varchar2

503: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 508: ,p_information14 in varchar2 default hr_api.g_varchar2

504: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 509: ,p_information15 in varchar2 default hr_api.g_varchar2

505: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 510: ,p_information16 in varchar2 default hr_api.g_varchar2

506: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 511: ,p_information17 in varchar2 default hr_api.g_varchar2

507: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 512: ,p_information18 in varchar2 default hr_api.g_varchar2

508: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 513: ,p_information19 in varchar2 default hr_api.g_varchar2

509: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 514: ,p_information20 in varchar2 default hr_api.g_varchar2

510: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 515: ,p_information21 in varchar2 default hr_api.g_varchar2

511: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 516: ,p_information22 in varchar2 default hr_api.g_varchar2

512: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 517: ,p_information23 in varchar2 default hr_api.g_varchar2

513: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 518: ,p_information24 in varchar2 default hr_api.g_varchar2

514: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 519: ,p_information25 in varchar2 default hr_api.g_varchar2

515: ,p_information21 in varchar2 default hr_api.g_varchar2
516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2
523: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 520: ,p_information26 in varchar2 default hr_api.g_varchar2

516: ,p_information22 in varchar2 default hr_api.g_varchar2
517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2
523: ,p_information29 in varchar2 default hr_api.g_varchar2
524: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 521: ,p_information27 in varchar2 default hr_api.g_varchar2

517: ,p_information23 in varchar2 default hr_api.g_varchar2
518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2
523: ,p_information29 in varchar2 default hr_api.g_varchar2
524: ,p_information30 in varchar2 default hr_api.g_varchar2
525: ,p_canvas_property_id out nocopy number

Line 522: ,p_information28 in varchar2 default hr_api.g_varchar2

518: ,p_information24 in varchar2 default hr_api.g_varchar2
519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2
523: ,p_information29 in varchar2 default hr_api.g_varchar2
524: ,p_information30 in varchar2 default hr_api.g_varchar2
525: ,p_canvas_property_id out nocopy number
526: ,p_object_version_number out nocopy number

Line 523: ,p_information29 in varchar2 default hr_api.g_varchar2

519: ,p_information25 in varchar2 default hr_api.g_varchar2
520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2
523: ,p_information29 in varchar2 default hr_api.g_varchar2
524: ,p_information30 in varchar2 default hr_api.g_varchar2
525: ,p_canvas_property_id out nocopy number
526: ,p_object_version_number out nocopy number
527: ) is

Line 524: ,p_information30 in varchar2 default hr_api.g_varchar2

520: ,p_information26 in varchar2 default hr_api.g_varchar2
521: ,p_information27 in varchar2 default hr_api.g_varchar2
522: ,p_information28 in varchar2 default hr_api.g_varchar2
523: ,p_information29 in varchar2 default hr_api.g_varchar2
524: ,p_information30 in varchar2 default hr_api.g_varchar2
525: ,p_canvas_property_id out nocopy number
526: ,p_object_version_number out nocopy number
527: ) is
528: --

Line 582: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)

578: -- added a outer join so that the correct values are returned
579: -- if there are no entries in the properties table
580: CURSOR cur_can_prop
581: IS
582: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)

Line 583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)

579: -- if there are no entries in the properties table
580: CURSOR cur_can_prop
581: IS
582: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)

Line 584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)

580: CURSOR cur_can_prop
581: IS
582: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)

Line 585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)

581: IS
582: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)

Line 586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)

582: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)

Line 587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)

583: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)

Line 588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)

584: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)

Line 589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)

585: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)

Line 590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)

586: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)

Line 591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)

587: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)

Line 592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)

588: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)

Line 593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)

589: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)

Line 594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)

590: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)

Line 595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)

591: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)

Line 596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)

592: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)

Line 597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)

593: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)

Line 598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)

594: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)

Line 599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)

595: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)

Line 600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)

596: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)

Line 601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)

597: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)

Line 602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)

598: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)

Line 603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)

599: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)

Line 604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)

600: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)

Line 605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)

601: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)

Line 606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)

602: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)

Line 607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)

603: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)

Line 608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)

604: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)

Line 609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)

605: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)

Line 610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)

606: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)

Line 611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)

607: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)

Line 612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)

608: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)

Line 613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)

609: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)

Line 614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)

610: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
618: FROM hr_canvas_properties cnp

Line 615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)

611: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
618: FROM hr_canvas_properties cnp
619: , hr_form_canvases_b hfc

Line 616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)

612: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
618: FROM hr_canvas_properties cnp
619: , hr_form_canvases_b hfc
620: WHERE cnp.form_canvas_id (+) = hfc.form_canvas_id

Line 617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)

613: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
614: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
615: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
616: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
617: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
618: FROM hr_canvas_properties cnp
619: , hr_form_canvases_b hfc
620: WHERE cnp.form_canvas_id (+) = hfc.form_canvas_id
621: AND hfc.form_canvas_id = p_form_canvas_id;

Line 705: raise hr_api.validate_enabled;

701: --
702: hr_utility.set_location('At:'|| l_proc, 40);
703:
704: if p_validate then
705: raise hr_api.validate_enabled;
706: end if;
707: --
708: -- Set all output arguments
709: --

Line 715: when hr_api.validate_enabled then

711: p_object_version_number := l_object_version_number;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 70);
714: exception
715: when hr_api.validate_enabled then
716: --
717: -- As the Validate_Enabled exception has been raised
718: -- we must rollback to the savepoint
719: --

Line 747: ,p_height in number default hr_api.g_number

743: (p_validate in boolean default false
744: ,p_effective_date in date
745: ,p_template_canvas_id_from in number
746: ,p_template_canvas_id_to in number
747: ,p_height in number default hr_api.g_number
748: ,p_visible in number default hr_api.g_number
749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number

Line 748: ,p_visible in number default hr_api.g_number

744: ,p_effective_date in date
745: ,p_template_canvas_id_from in number
746: ,p_template_canvas_id_to in number
747: ,p_height in number default hr_api.g_number
748: ,p_visible in number default hr_api.g_number
749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 749: ,p_width in number default hr_api.g_number

745: ,p_template_canvas_id_from in number
746: ,p_template_canvas_id_to in number
747: ,p_height in number default hr_api.g_number
748: ,p_visible in number default hr_api.g_number
749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 750: ,p_x_position in number default hr_api.g_number

746: ,p_template_canvas_id_to in number
747: ,p_height in number default hr_api.g_number
748: ,p_visible in number default hr_api.g_number
749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 751: ,p_y_position in number default hr_api.g_number

747: ,p_height in number default hr_api.g_number
748: ,p_visible in number default hr_api.g_number
749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 752: ,p_information_category in varchar2 default hr_api.g_varchar2

748: ,p_visible in number default hr_api.g_number
749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 753: ,p_information1 in varchar2 default hr_api.g_varchar2

749: ,p_width in number default hr_api.g_number
750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 754: ,p_information2 in varchar2 default hr_api.g_varchar2

750: ,p_x_position in number default hr_api.g_number
751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 755: ,p_information3 in varchar2 default hr_api.g_varchar2

751: ,p_y_position in number default hr_api.g_number
752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 756: ,p_information4 in varchar2 default hr_api.g_varchar2

752: ,p_information_category in varchar2 default hr_api.g_varchar2
753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 757: ,p_information5 in varchar2 default hr_api.g_varchar2

753: ,p_information1 in varchar2 default hr_api.g_varchar2
754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 758: ,p_information6 in varchar2 default hr_api.g_varchar2

754: ,p_information2 in varchar2 default hr_api.g_varchar2
755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 759: ,p_information7 in varchar2 default hr_api.g_varchar2

755: ,p_information3 in varchar2 default hr_api.g_varchar2
756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 760: ,p_information8 in varchar2 default hr_api.g_varchar2

756: ,p_information4 in varchar2 default hr_api.g_varchar2
757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 761: ,p_information9 in varchar2 default hr_api.g_varchar2

757: ,p_information5 in varchar2 default hr_api.g_varchar2
758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 762: ,p_information10 in varchar2 default hr_api.g_varchar2

758: ,p_information6 in varchar2 default hr_api.g_varchar2
759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 763: ,p_information11 in varchar2 default hr_api.g_varchar2

759: ,p_information7 in varchar2 default hr_api.g_varchar2
760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 764: ,p_information12 in varchar2 default hr_api.g_varchar2

760: ,p_information8 in varchar2 default hr_api.g_varchar2
761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 765: ,p_information13 in varchar2 default hr_api.g_varchar2

761: ,p_information9 in varchar2 default hr_api.g_varchar2
762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 766: ,p_information14 in varchar2 default hr_api.g_varchar2

762: ,p_information10 in varchar2 default hr_api.g_varchar2
763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 767: ,p_information15 in varchar2 default hr_api.g_varchar2

763: ,p_information11 in varchar2 default hr_api.g_varchar2
764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 768: ,p_information16 in varchar2 default hr_api.g_varchar2

764: ,p_information12 in varchar2 default hr_api.g_varchar2
765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 769: ,p_information17 in varchar2 default hr_api.g_varchar2

765: ,p_information13 in varchar2 default hr_api.g_varchar2
766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 770: ,p_information18 in varchar2 default hr_api.g_varchar2

766: ,p_information14 in varchar2 default hr_api.g_varchar2
767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 771: ,p_information19 in varchar2 default hr_api.g_varchar2

767: ,p_information15 in varchar2 default hr_api.g_varchar2
768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 772: ,p_information20 in varchar2 default hr_api.g_varchar2

768: ,p_information16 in varchar2 default hr_api.g_varchar2
769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 773: ,p_information21 in varchar2 default hr_api.g_varchar2

769: ,p_information17 in varchar2 default hr_api.g_varchar2
770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 774: ,p_information22 in varchar2 default hr_api.g_varchar2

770: ,p_information18 in varchar2 default hr_api.g_varchar2
771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 775: ,p_information23 in varchar2 default hr_api.g_varchar2

771: ,p_information19 in varchar2 default hr_api.g_varchar2
772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 776: ,p_information24 in varchar2 default hr_api.g_varchar2

772: ,p_information20 in varchar2 default hr_api.g_varchar2
773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 777: ,p_information25 in varchar2 default hr_api.g_varchar2

773: ,p_information21 in varchar2 default hr_api.g_varchar2
774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2
781: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 778: ,p_information26 in varchar2 default hr_api.g_varchar2

774: ,p_information22 in varchar2 default hr_api.g_varchar2
775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2
781: ,p_information29 in varchar2 default hr_api.g_varchar2
782: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 779: ,p_information27 in varchar2 default hr_api.g_varchar2

775: ,p_information23 in varchar2 default hr_api.g_varchar2
776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2
781: ,p_information29 in varchar2 default hr_api.g_varchar2
782: ,p_information30 in varchar2 default hr_api.g_varchar2
783: ,p_canvas_property_id out nocopy number

Line 780: ,p_information28 in varchar2 default hr_api.g_varchar2

776: ,p_information24 in varchar2 default hr_api.g_varchar2
777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2
781: ,p_information29 in varchar2 default hr_api.g_varchar2
782: ,p_information30 in varchar2 default hr_api.g_varchar2
783: ,p_canvas_property_id out nocopy number
784: ,p_object_version_number out nocopy number

Line 781: ,p_information29 in varchar2 default hr_api.g_varchar2

777: ,p_information25 in varchar2 default hr_api.g_varchar2
778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2
781: ,p_information29 in varchar2 default hr_api.g_varchar2
782: ,p_information30 in varchar2 default hr_api.g_varchar2
783: ,p_canvas_property_id out nocopy number
784: ,p_object_version_number out nocopy number
785: ) is

Line 782: ,p_information30 in varchar2 default hr_api.g_varchar2

778: ,p_information26 in varchar2 default hr_api.g_varchar2
779: ,p_information27 in varchar2 default hr_api.g_varchar2
780: ,p_information28 in varchar2 default hr_api.g_varchar2
781: ,p_information29 in varchar2 default hr_api.g_varchar2
782: ,p_information30 in varchar2 default hr_api.g_varchar2
783: ,p_canvas_property_id out nocopy number
784: ,p_object_version_number out nocopy number
785: ) is
786: --

Line 843: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)

839: WHERE tcn.template_canvas_id = p_template_canvas_id_to;
840:
841: CURSOR cur_can_prop
842: IS
843: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)

Line 844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)

840:
841: CURSOR cur_can_prop
842: IS
843: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)

Line 845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)

841: CURSOR cur_can_prop
842: IS
843: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)

Line 846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)

842: IS
843: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)

Line 847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)

843: SELECT DECODE(p_height,hr_api.g_number,cnp.height,p_height)
844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)

Line 848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)

844: ,DECODE(p_visible,hr_api.g_number,cnp.visible,p_visible)
845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)

Line 849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)

845: ,DECODE(p_width,hr_api.g_number,cnp.width,p_width)
846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)

Line 850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)

846: ,DECODE(p_x_position,hr_api.g_number,cnp.x_position,p_x_position)
847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)

Line 851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)

847: ,DECODE(p_y_position,hr_api.g_number,cnp.y_position,p_y_position)
848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)

Line 852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)

848: ,DECODE(p_information_category,hr_api.g_varchar2,cnp.information_category,p_information_category)
849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)

Line 853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)

849: ,DECODE(p_information1,hr_api.g_varchar2,cnp.information1,p_information1)
850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)

Line 854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)

850: ,DECODE(p_information2,hr_api.g_varchar2,cnp.information2,p_information2)
851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)

Line 855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)

851: ,DECODE(p_information3,hr_api.g_varchar2,cnp.information3,p_information3)
852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)

Line 856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)

852: ,DECODE(p_information4,hr_api.g_varchar2,cnp.information4,p_information4)
853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)

Line 857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)

853: ,DECODE(p_information5,hr_api.g_varchar2,cnp.information5,p_information5)
854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)

Line 858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)

854: ,DECODE(p_information6,hr_api.g_varchar2,cnp.information6,p_information6)
855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)

Line 859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)

855: ,DECODE(p_information7,hr_api.g_varchar2,cnp.information7,p_information7)
856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)

Line 860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)

856: ,DECODE(p_information8,hr_api.g_varchar2,cnp.information8,p_information8)
857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)

Line 861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)

857: ,DECODE(p_information9,hr_api.g_varchar2,cnp.information9,p_information9)
858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)

Line 862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)

858: ,DECODE(p_information10,hr_api.g_varchar2,cnp.information10,p_information10)
859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)

Line 863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)

859: ,DECODE(p_information11,hr_api.g_varchar2,cnp.information11,p_information11)
860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)

Line 864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)

860: ,DECODE(p_information12,hr_api.g_varchar2,cnp.information12,p_information12)
861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)

Line 865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)

861: ,DECODE(p_information13,hr_api.g_varchar2,cnp.information13,p_information13)
862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)

Line 866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)

862: ,DECODE(p_information14,hr_api.g_varchar2,cnp.information14,p_information14)
863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)

Line 867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)

863: ,DECODE(p_information15,hr_api.g_varchar2,cnp.information15,p_information15)
864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)

Line 868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)

864: ,DECODE(p_information16,hr_api.g_varchar2,cnp.information16,p_information16)
865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)

Line 869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)

865: ,DECODE(p_information17,hr_api.g_varchar2,cnp.information17,p_information17)
866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)

Line 870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)

866: ,DECODE(p_information18,hr_api.g_varchar2,cnp.information18,p_information18)
867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)

Line 871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)

867: ,DECODE(p_information19,hr_api.g_varchar2,cnp.information19,p_information19)
868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)

Line 872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)

868: ,DECODE(p_information20,hr_api.g_varchar2,cnp.information20,p_information20)
869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)

Line 873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)

869: ,DECODE(p_information21,hr_api.g_varchar2,cnp.information21,p_information21)
870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)

Line 874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)

870: ,DECODE(p_information22,hr_api.g_varchar2,cnp.information22,p_information22)
871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)

Line 875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)

871: ,DECODE(p_information23,hr_api.g_varchar2,cnp.information23,p_information23)
872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
879: FROM hr_canvas_properties cnp

Line 876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)

872: ,DECODE(p_information24,hr_api.g_varchar2,cnp.information24,p_information24)
873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
879: FROM hr_canvas_properties cnp
880: , hr_template_canvases_b htc

Line 877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)

873: ,DECODE(p_information25,hr_api.g_varchar2,cnp.information25,p_information25)
874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
879: FROM hr_canvas_properties cnp
880: , hr_template_canvases_b htc
881: WHERE cnp.template_canvas_id (+) = htc.template_canvas_id

Line 878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)

874: ,DECODE(p_information26,hr_api.g_varchar2,cnp.information26,p_information26)
875: ,DECODE(p_information27,hr_api.g_varchar2,cnp.information27,p_information27)
876: ,DECODE(p_information28,hr_api.g_varchar2,cnp.information28,p_information28)
877: ,DECODE(p_information29,hr_api.g_varchar2,cnp.information29,p_information29)
878: ,DECODE(p_information30,hr_api.g_varchar2,cnp.information30,p_information30)
879: FROM hr_canvas_properties cnp
880: , hr_template_canvases_b htc
881: WHERE cnp.template_canvas_id (+) = htc.template_canvas_id
882: and htc.template_canvas_id = p_template_canvas_id_from;

Line 967: raise hr_api.validate_enabled;

963: --
964: hr_utility.set_location('At:'|| l_proc, 50);
965:
966: if p_validate then
967: raise hr_api.validate_enabled;
968: end if;
969: --
970: -- Set all output arguments
971: --

Line 977: when hr_api.validate_enabled then

973: p_object_version_number := l_object_Version_number;
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 70);
976: exception
977: when hr_api.validate_enabled then
978: --
979: -- As the Validate_Enabled exception has been raised
980: -- we must rollback to the savepoint
981: --