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.IRC_AGENCY_VACANCIES_API dependencies on HR_API

Line 119: when hr_api.cannot_find_prog_unit then

115: ,p_attribute29 => p_attribute29
116: ,p_attribute30 => p_attribute30
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_AGENCY_VACANCY'
122: ,p_hook_type => 'BP'
123: );

Line 120: hr_api.cannot_find_prog_unit_error

116: ,p_attribute30 => p_attribute30
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_AGENCY_VACANCY'
122: ,p_hook_type => 'BP'
123: );
124: end;

Line 216: when hr_api.cannot_find_prog_unit then

212: ,p_attribute30 => p_attribute30
213: ,p_object_version_number => l_object_version_number
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'CREATE_AGENCY_VACANCY'
219: ,p_hook_type => 'AP'
220: );

Line 217: hr_api.cannot_find_prog_unit_error

213: ,p_object_version_number => l_object_version_number
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'CREATE_AGENCY_VACANCY'
219: ,p_hook_type => 'AP'
220: );
221: end;

Line 226: raise hr_api.validate_enabled;

222: --
223: -- When in validation only mode raise the Validate_Enabled exception
224: --
225: if p_validate then
226: raise hr_api.validate_enabled;
227: end if;
228: --
229: -- Set all IN OUT and OUT parameters with out values
230: --

Line 236: when hr_api.validate_enabled then

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

Line 276: ,p_max_allowed_applicants in number default hr_api.g_number

272: ,p_agency_id in number
273: ,p_vacancy_id in number
274: ,p_start_date in date
275: ,p_end_date in date
276: ,p_max_allowed_applicants in number default hr_api.g_number
277: ,p_manage_applicants_allowed in varchar2 default 'N'
278: ,p_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 278: ,p_attribute_category in varchar2 default hr_api.g_varchar2

274: ,p_start_date in date
275: ,p_end_date in date
276: ,p_max_allowed_applicants in number default hr_api.g_number
277: ,p_manage_applicants_allowed in varchar2 default 'N'
278: ,p_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 279: ,p_attribute1 in varchar2 default hr_api.g_varchar2

275: ,p_end_date in date
276: ,p_max_allowed_applicants in number default hr_api.g_number
277: ,p_manage_applicants_allowed in varchar2 default 'N'
278: ,p_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 280: ,p_attribute2 in varchar2 default hr_api.g_varchar2

276: ,p_max_allowed_applicants in number default hr_api.g_number
277: ,p_manage_applicants_allowed in varchar2 default 'N'
278: ,p_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 281: ,p_attribute3 in varchar2 default hr_api.g_varchar2

277: ,p_manage_applicants_allowed in varchar2 default 'N'
278: ,p_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 282: ,p_attribute4 in varchar2 default hr_api.g_varchar2

278: ,p_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 283: ,p_attribute5 in varchar2 default hr_api.g_varchar2

279: ,p_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 284: ,p_attribute6 in varchar2 default hr_api.g_varchar2

280: ,p_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 285: ,p_attribute7 in varchar2 default hr_api.g_varchar2

281: ,p_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 286: ,p_attribute8 in varchar2 default hr_api.g_varchar2

282: ,p_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute9 in varchar2 default hr_api.g_varchar2

283: ,p_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute10 in varchar2 default hr_api.g_varchar2

284: ,p_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute11 in varchar2 default hr_api.g_varchar2

285: ,p_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute12 in varchar2 default hr_api.g_varchar2

286: ,p_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute13 in varchar2 default hr_api.g_varchar2

287: ,p_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute14 in varchar2 default hr_api.g_varchar2

288: ,p_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute15 in varchar2 default hr_api.g_varchar2

289: ,p_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute16 in varchar2 default hr_api.g_varchar2

290: ,p_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute17 in varchar2 default hr_api.g_varchar2

291: ,p_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute18 in varchar2 default hr_api.g_varchar2

292: ,p_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute19 in varchar2 default hr_api.g_varchar2

293: ,p_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute20 in varchar2 default hr_api.g_varchar2

294: ,p_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute21 in varchar2 default hr_api.g_varchar2

295: ,p_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 300: ,p_attribute22 in varchar2 default hr_api.g_varchar2

296: ,p_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 301: ,p_attribute23 in varchar2 default hr_api.g_varchar2

297: ,p_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 302: ,p_attribute24 in varchar2 default hr_api.g_varchar2

298: ,p_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 303: ,p_attribute25 in varchar2 default hr_api.g_varchar2

299: ,p_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 304: ,p_attribute26 in varchar2 default hr_api.g_varchar2

300: ,p_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 305: ,p_attribute27 in varchar2 default hr_api.g_varchar2

301: ,p_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number

Line 306: ,p_attribute28 in varchar2 default hr_api.g_varchar2

302: ,p_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ) is

Line 307: ,p_attribute29 in varchar2 default hr_api.g_varchar2

303: ,p_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ) is
311: --

Line 308: ,p_attribute30 in varchar2 default hr_api.g_varchar2

304: ,p_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ) is
311: --
312: -- Declare cursors and local variables

Line 377: when hr_api.cannot_find_prog_unit then

373: ,p_attribute30 => p_attribute30
374: ,p_object_version_number => l_object_version_number
375: );
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'UPDATE_AGENCY_VACANCY'
380: ,p_hook_type => 'BP'
381: );

Line 378: hr_api.cannot_find_prog_unit_error

374: ,p_object_version_number => l_object_version_number
375: );
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'UPDATE_AGENCY_VACANCY'
380: ,p_hook_type => 'BP'
381: );
382: end;

Line 478: when hr_api.cannot_find_prog_unit then

474: ,p_attribute30 => p_attribute30
475: ,p_object_version_number => l_object_version_number
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'UPDATE_AGENCY_VACANCY'
481: ,p_hook_type => 'AP'
482: );

Line 479: hr_api.cannot_find_prog_unit_error

475: ,p_object_version_number => l_object_version_number
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'UPDATE_AGENCY_VACANCY'
481: ,p_hook_type => 'AP'
482: );
483: end;

Line 488: raise hr_api.validate_enabled;

484: --
485: -- When in validation only mode raise the Validate_Enabled exception
486: --
487: if p_validate then
488: raise hr_api.validate_enabled;
489: end if;
490: --
491: -- Set all IN OUT and OUT parameters with out values
492: --

Line 497: when hr_api.validate_enabled then

493: p_object_version_number := l_object_version_number;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 70);
496: exception
497: when hr_api.validate_enabled then
498: --
499: -- As the Validate_Enabled exception has been raised
500: -- we must rollback to the savepoint
501: --

Line 553: when hr_api.cannot_find_prog_unit then

549: (p_agency_vacancy_id => p_agency_vacancy_id
550: ,p_object_version_number => p_object_version_number
551: );
552: exception
553: when hr_api.cannot_find_prog_unit then
554: hr_api.cannot_find_prog_unit_error
555: (p_module_name => 'DELETE_AGENCY_VACANCY'
556: ,p_hook_type => 'BP'
557: );

Line 554: hr_api.cannot_find_prog_unit_error

550: ,p_object_version_number => p_object_version_number
551: );
552: exception
553: when hr_api.cannot_find_prog_unit then
554: hr_api.cannot_find_prog_unit_error
555: (p_module_name => 'DELETE_AGENCY_VACANCY'
556: ,p_hook_type => 'BP'
557: );
558: end;

Line 576: when hr_api.cannot_find_prog_unit then

572: (p_agency_vacancy_id => p_agency_vacancy_id
573: ,p_object_version_number => p_object_version_number
574: );
575: exception
576: when hr_api.cannot_find_prog_unit then
577: hr_api.cannot_find_prog_unit_error
578: (p_module_name => 'DELETE_AGENCY_VACANCY'
579: ,p_hook_type => 'AP'
580: );

Line 577: hr_api.cannot_find_prog_unit_error

573: ,p_object_version_number => p_object_version_number
574: );
575: exception
576: when hr_api.cannot_find_prog_unit then
577: hr_api.cannot_find_prog_unit_error
578: (p_module_name => 'DELETE_AGENCY_VACANCY'
579: ,p_hook_type => 'AP'
580: );
581: end;

Line 586: raise hr_api.validate_enabled;

582: --
583: -- When in validation only mode raise the Validate_Enabled exception
584: --
585: if p_validate then
586: raise hr_api.validate_enabled;
587: end if;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 70);
590: exception

Line 591: when hr_api.validate_enabled then

587: end if;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 70);
590: exception
591: when hr_api.validate_enabled then
592: --
593: -- As the Validate_Enabled exception has been raised
594: -- we must rollback to the savepoint
595: --