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

APPS.PER_REQUISITIONS_API dependencies on HR_API

Line 122: when hr_api.cannot_find_prog_unit then

118: ,p_attribute29 => p_attribute29
119: ,p_attribute30 => p_attribute30
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'CREATE_REQUISITION'
125: ,p_hook_type => 'BP'
126: );

Line 123: hr_api.cannot_find_prog_unit_error

119: ,p_attribute30 => p_attribute30
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'CREATE_REQUISITION'
125: ,p_hook_type => 'BP'
126: );
127: end;

Line 214: when hr_api.cannot_find_prog_unit then

210: ,p_attribute29 => p_attribute29
211: ,p_attribute30 => p_attribute30
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'CREATE_REQUISITION'
217: ,p_hook_type => 'AP'
218: );

Line 215: hr_api.cannot_find_prog_unit_error

211: ,p_attribute30 => p_attribute30
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'CREATE_REQUISITION'
217: ,p_hook_type => 'AP'
218: );
219: end;

Line 224: raise hr_api.validate_enabled;

220: --
221: -- When in validation only mode raise the Validate_Enabled exception
222: --
223: if p_validate then
224: raise hr_api.validate_enabled;
225: end if;
226: --
227: -- Set all output arguments
228: --

Line 234: when hr_api.validate_enabled then

230: p_object_version_number := l_object_version_number;
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 70);
233: exception
234: when hr_api.validate_enabled then
235: --
236: -- As the Validate_Enabled exception has been raised
237: -- we must rollback to the savepoint
238: --

Line 267: ,p_date_from in date default hr_api.g_date

263: procedure update_requisition
264: (p_validate in boolean default false
265: ,p_requisition_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2

Line 268: ,p_person_id in number default hr_api.g_number

264: (p_validate in boolean default false
265: ,p_requisition_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 269: ,p_comments in varchar2 default hr_api.g_varchar2

265: ,p_requisition_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 270: ,p_date_to in date default hr_api.g_date

266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 271: ,p_description in varchar2 default hr_api.g_varchar2

267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 272: ,p_attribute_category in varchar2 default hr_api.g_varchar2

268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 273: ,p_attribute1 in varchar2 default hr_api.g_varchar2

269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 274: ,p_attribute2 in varchar2 default hr_api.g_varchar2

270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 275: ,p_attribute3 in varchar2 default hr_api.g_varchar2

271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 276: ,p_attribute4 in varchar2 default hr_api.g_varchar2

272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 277: ,p_attribute5 in varchar2 default hr_api.g_varchar2

273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 278: ,p_attribute6 in varchar2 default hr_api.g_varchar2

274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 279: ,p_attribute7 in varchar2 default hr_api.g_varchar2

275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 280: ,p_attribute8 in varchar2 default hr_api.g_varchar2

276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 281: ,p_attribute9 in varchar2 default hr_api.g_varchar2

277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 282: ,p_attribute10 in varchar2 default hr_api.g_varchar2

278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 283: ,p_attribute11 in varchar2 default hr_api.g_varchar2

279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 284: ,p_attribute12 in varchar2 default hr_api.g_varchar2

280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 285: ,p_attribute13 in varchar2 default hr_api.g_varchar2

281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 286: ,p_attribute14 in varchar2 default hr_api.g_varchar2

282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute15 in varchar2 default hr_api.g_varchar2

283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute16 in varchar2 default hr_api.g_varchar2

284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute17 in varchar2 default hr_api.g_varchar2

285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute18 in varchar2 default hr_api.g_varchar2

286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute19 in varchar2 default hr_api.g_varchar2

287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute20 in varchar2 default hr_api.g_varchar2

288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute21 in varchar2 default hr_api.g_varchar2

289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute22 in varchar2 default hr_api.g_varchar2

290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute23 in varchar2 default hr_api.g_varchar2

291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute24 in varchar2 default hr_api.g_varchar2

292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute25 in varchar2 default hr_api.g_varchar2

293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute26 in varchar2 default hr_api.g_varchar2

294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute27 in varchar2 default hr_api.g_varchar2

295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is

Line 300: ,p_attribute28 in varchar2 default hr_api.g_varchar2

296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
304: --

Line 301: ,p_attribute29 in varchar2 default hr_api.g_varchar2

297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
304: --
305: -- Declare cursors and local variables

Line 302: ,p_attribute30 in varchar2 default hr_api.g_varchar2

298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
304: --
305: -- Declare cursors and local variables
306: --

Line 370: when hr_api.cannot_find_prog_unit then

366: ,p_attribute29 => p_attribute29
367: ,p_attribute30 => p_attribute30
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'UPDATE_REQUISITION'
373: ,p_hook_type => 'BP'
374: );

Line 371: hr_api.cannot_find_prog_unit_error

367: ,p_attribute30 => p_attribute30
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'UPDATE_REQUISITION'
373: ,p_hook_type => 'BP'
374: );
375: end;

Line 461: when hr_api.cannot_find_prog_unit then

457: ,p_attribute29 => p_attribute29
458: ,p_attribute30 => p_attribute30
459: );
460: exception
461: when hr_api.cannot_find_prog_unit then
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'UPDATE_REQUISITION'
464: ,p_hook_type => 'AP'
465: );

Line 462: hr_api.cannot_find_prog_unit_error

458: ,p_attribute30 => p_attribute30
459: );
460: exception
461: when hr_api.cannot_find_prog_unit then
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'UPDATE_REQUISITION'
464: ,p_hook_type => 'AP'
465: );
466: end;

Line 471: raise hr_api.validate_enabled;

467: --
468: -- When in validation only mode raise the Validate_Enabled exception
469: --
470: if p_validate then
471: raise hr_api.validate_enabled;
472: end if;
473: --
474: -- Set all output arguments
475: --

Line 480: when hr_api.validate_enabled then

476: p_object_version_number := l_object_version_number;
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 70);
479: exception
480: when hr_api.validate_enabled then
481: --
482: -- As the Validate_Enabled exception has been raised
483: -- we must rollback to the savepoint
484: --

Line 533: when hr_api.cannot_find_prog_unit then

529: p_requisition_id => p_requisition_id
530: ,p_object_version_number => p_object_version_number
531: );
532: exception
533: when hr_api.cannot_find_prog_unit then
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'DELETE_REQUISITION'
536: ,p_hook_type => 'BP'
537: );

Line 534: hr_api.cannot_find_prog_unit_error

530: ,p_object_version_number => p_object_version_number
531: );
532: exception
533: when hr_api.cannot_find_prog_unit then
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'DELETE_REQUISITION'
536: ,p_hook_type => 'BP'
537: );
538: end;

Line 561: when hr_api.cannot_find_prog_unit then

557: p_requisition_id => p_requisition_id
558: ,p_object_version_number => p_object_version_number
559: );
560: exception
561: when hr_api.cannot_find_prog_unit then
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'DELETE_REQUISITION'
564: ,p_hook_type => 'AP'
565: );

Line 562: hr_api.cannot_find_prog_unit_error

558: ,p_object_version_number => p_object_version_number
559: );
560: exception
561: when hr_api.cannot_find_prog_unit then
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'DELETE_REQUISITION'
564: ,p_hook_type => 'AP'
565: );
566: end;

Line 571: raise hr_api.validate_enabled;

567: --
568: -- When in validation only mode raise the Validate_Enabled exception
569: --
570: if p_validate then
571: raise hr_api.validate_enabled;
572: end if;
573: --
574: -- Set all output arguments
575: --

Line 579: when hr_api.validate_enabled then

575: --
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 70);
578: exception
579: when hr_api.validate_enabled then
580: --
581: -- As the Validate_Enabled exception has been raised
582: -- we must rollback to the savepoint
583: --