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.

[Home] [Help]

APPS.PER_VACANCY_API dependencies on HR_API

Line 160: when hr_api.cannot_find_prog_unit then

156: , P_ATTRIBUTE29 => P_ATTRIBUTE29
157: , P_ATTRIBUTE30 => P_ATTRIBUTE30
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'create_vacancy'
163: ,p_hook_type => 'BP'
164: );

Line 161: hr_api.cannot_find_prog_unit_error

157: , P_ATTRIBUTE30 => P_ATTRIBUTE30
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'create_vacancy'
163: ,p_hook_type => 'BP'
164: );
165: end;

Line 287: when hr_api.cannot_find_prog_unit then

283: , p_inv_pos_grade_warning => l_inv_pos_grade_warning
284: , p_inv_job_grade_warning => l_inv_job_grade_warning
285: );
286: exception
287: when hr_api.cannot_find_prog_unit then
288: hr_api.cannot_find_prog_unit_error
289: (p_module_name => 'create_vacancy'
290: ,p_hook_type => 'AP'
291: );

Line 288: hr_api.cannot_find_prog_unit_error

284: , p_inv_job_grade_warning => l_inv_job_grade_warning
285: );
286: exception
287: when hr_api.cannot_find_prog_unit then
288: hr_api.cannot_find_prog_unit_error
289: (p_module_name => 'create_vacancy'
290: ,p_hook_type => 'AP'
291: );
292: end;

Line 297: raise hr_api.validate_enabled;

293: --
294: -- When in validation only mode raise the Validate_Enabled exception
295: --
296: if p_validate then
297: raise hr_api.validate_enabled;
298: end if;
299: --
300: -- Set all output arguments
301: --

Line 309: when hr_api.validate_enabled then

305: p_inv_job_grade_warning := l_inv_job_grade_warning;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 70);
308: exception
309: when hr_api.validate_enabled then
310: --
311: -- As the Validate_Enabled exception has been raised
312: -- we must rollback to the savepoint
313: --

Line 349: , P_DATE_FROM in date default hr_api.g_date

345: P_VALIDATE in boolean default false
346: , P_EFFECTIVE_DATE in date default null
347: , P_VACANCY_ID in number
348: , P_OBJECT_VERSION_NUMBER in out nocopy number
349: , P_DATE_FROM in date default hr_api.g_date
350: , P_POSITION_ID in number default hr_api.g_number
351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number

Line 350: , P_POSITION_ID in number default hr_api.g_number

346: , P_EFFECTIVE_DATE in date default null
347: , P_VACANCY_ID in number
348: , P_OBJECT_VERSION_NUMBER in out nocopy number
349: , P_DATE_FROM in date default hr_api.g_date
350: , P_POSITION_ID in number default hr_api.g_number
351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number

Line 351: , P_JOB_ID in number default hr_api.g_number

347: , P_VACANCY_ID in number
348: , P_OBJECT_VERSION_NUMBER in out nocopy number
349: , P_DATE_FROM in date default hr_api.g_date
350: , P_POSITION_ID in number default hr_api.g_number
351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number

Line 352: , P_GRADE_ID in number default hr_api.g_number

348: , P_OBJECT_VERSION_NUMBER in out nocopy number
349: , P_DATE_FROM in date default hr_api.g_date
350: , P_POSITION_ID in number default hr_api.g_number
351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number

Line 353: , P_ORGANIZATION_ID in number default hr_api.g_number

349: , P_DATE_FROM in date default hr_api.g_date
350: , P_POSITION_ID in number default hr_api.g_number
351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date

Line 354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number

350: , P_POSITION_ID in number default hr_api.g_number
351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2

Line 355: , P_LOCATION_ID in number default hr_api.g_number

351: , P_JOB_ID in number default hr_api.g_number
352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2

Line 356: , P_RECRUITER_ID in number default hr_api.g_number

352: , P_GRADE_ID in number default hr_api.g_number
353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number

Line 357: , P_DATE_TO in date default hr_api.g_date

353: , P_ORGANIZATION_ID in number default hr_api.g_number
354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2

Line 358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2

354: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2

Line 359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2

355: , P_LOCATION_ID in number default hr_api.g_number
356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number

Line 360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number

356: , P_RECRUITER_ID in number default hr_api.g_number
357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2

Line 361: , P_STATUS in varchar2 default hr_api.g_varchar2

357: , P_DATE_TO in date default hr_api.g_date
358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number

Line 362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2

358: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number

Line 363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number

359: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number

Line 364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2

360: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2

Line 365: , P_MANAGER_ID in number default hr_api.g_number

361: , P_STATUS in varchar2 default hr_api.g_varchar2
362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2

Line 366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number

362: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2

Line 367: , P_ASSESSMENT_ID in number default hr_api.g_number

363: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2

Line 368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2

364: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2

Line 369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2

365: , P_MANAGER_ID in number default hr_api.g_number
366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2

Line 370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2

366: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2

Line 371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2

367: , P_ASSESSMENT_ID in number default hr_api.g_number
368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2

Line 372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2

368: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2

Line 373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2

369: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2

Line 374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2

370: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2

Line 375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2

371: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2

Line 376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2

372: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2

Line 377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2

373: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2

Line 378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2

374: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2

Line 379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2

375: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2

Line 380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2

376: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2

Line 381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2

377: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2

Line 382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2

378: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2

Line 383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2

379: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2

Line 384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2

380: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2

Line 385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2

381: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2

Line 386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2

382: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2

Line 387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2

383: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2

Line 388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2

384: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2

Line 389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2

385: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2

Line 390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2

386: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2

Line 391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2

387: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2

Line 392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2

388: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2

Line 393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2

389: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2

Line 394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2

390: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2

Line 395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2

391: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
399: , P_ASSIGNMENT_CHANGED out nocopy boolean

Line 396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2

392: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
399: , P_ASSIGNMENT_CHANGED out nocopy boolean
400: ,p_inv_pos_grade_warning out nocopy boolean

Line 397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2

393: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
399: , P_ASSIGNMENT_CHANGED out nocopy boolean
400: ,p_inv_pos_grade_warning out nocopy boolean
401: ,p_inv_job_grade_warning out nocopy boolean

Line 398: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2

394: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
399: , P_ASSIGNMENT_CHANGED out nocopy boolean
400: ,p_inv_pos_grade_warning out nocopy boolean
401: ,p_inv_job_grade_warning out nocopy boolean
402: )

Line 509: when hr_api.cannot_find_prog_unit then

505: , P_ATTRIBUTE29 => P_ATTRIBUTE29
506: , P_ATTRIBUTE30 => P_ATTRIBUTE30
507: );
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'update_vacancy'
512: ,p_hook_type => 'BP'
513: );

Line 510: hr_api.cannot_find_prog_unit_error

506: , P_ATTRIBUTE30 => P_ATTRIBUTE30
507: );
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'update_vacancy'
512: ,p_hook_type => 'BP'
513: );
514: end;

Line 575: and (p_organization_id <> hr_api.g_number)

571: --
572: l_ASSIGNMENT_CHANGED := FALSE;
573: --
574: if (p_organization_id <> per_vac_shd.g_old_rec.organization_id)
575: and (p_organization_id <> hr_api.g_number)
576: then
577: l_ASSIGNMENT_CHANGED := TRUE;
578: l_organization_id := p_organization_id;
579: l_position_id := p_position_id;

Line 583: and (p_job_id <> hr_api.g_number)

579: l_position_id := p_position_id;
580: end if;
581: --
582: if (p_job_id <> per_vac_shd.g_old_rec.job_id)
583: and (p_job_id <> hr_api.g_number)
584: then
585: l_ASSIGNMENT_CHANGED := TRUE;
586: l_job_id := p_job_id;
587: l_position_id := p_position_id;

Line 591: and (p_grade_id <> hr_api.g_number)

587: l_position_id := p_position_id;
588: end if;
589: --
590: if (p_grade_id <> per_vac_shd.g_old_rec.grade_id)
591: and (p_grade_id <> hr_api.g_number)
592: then
593: l_ASSIGNMENT_CHANGED := TRUE;
594: l_grade_id := p_grade_id;
595: end if;

Line 598: and (p_people_group_id <> hr_api.g_number)

594: l_grade_id := p_grade_id;
595: end if;
596: --
597: if (p_people_group_id <> per_vac_shd.g_old_rec.people_group_id)
598: and (p_people_group_id <> hr_api.g_number)
599: then
600: l_ASSIGNMENT_CHANGED := TRUE;
601: l_people_group_id := p_people_group_id;
602: end if;

Line 605: and (p_position_id <> hr_api.g_number)

601: l_people_group_id := p_people_group_id;
602: end if;
603: --
604: if (p_position_id <> per_vac_shd.g_old_rec.position_id)
605: and (p_position_id <> hr_api.g_number)
606: then
607: l_ASSIGNMENT_CHANGED := TRUE;
608: l_position_id := p_position_id;
609: end if;

Line 612: and (p_location_id <> hr_api.g_number)

608: l_position_id := p_position_id;
609: end if;
610: --
611: if (p_location_id <> per_vac_shd.g_old_rec.location_id)
612: and (p_location_id <> hr_api.g_number)
613: then
614: l_ASSIGNMENT_CHANGED := TRUE;
615: l_location_id := p_location_id;
616: end if;

Line 619: and (p_recruiter_id <> hr_api.g_number)

615: l_location_id := p_location_id;
616: end if;
617: --
618: if (p_recruiter_id <> per_vac_shd.g_old_rec.recruiter_id)
619: and (p_recruiter_id <> hr_api.g_number)
620: then
621: l_ASSIGNMENT_CHANGED := TRUE;
622: l_recruiter_id := p_recruiter_id;
623: end if;

Line 626: and (p_manager_id <> hr_api.g_number)

622: l_recruiter_id := p_recruiter_id;
623: end if;
624: --
625: if (p_manager_id <> per_vac_shd.g_old_rec.manager_id)
626: and (p_manager_id <> hr_api.g_number)
627: then
628: l_ASSIGNMENT_CHANGED := TRUE;
629: l_manager_id := p_manager_id;
630: end if;

Line 730: when hr_api.cannot_find_prog_unit then

726: ,p_inv_job_grade_warning => l_inv_job_grade_warning
727:
728: );
729: exception
730: when hr_api.cannot_find_prog_unit then
731: hr_api.cannot_find_prog_unit_error
732: (p_module_name => 'update_vacancy'
733: ,p_hook_type => 'AP'
734: );

Line 731: hr_api.cannot_find_prog_unit_error

727:
728: );
729: exception
730: when hr_api.cannot_find_prog_unit then
731: hr_api.cannot_find_prog_unit_error
732: (p_module_name => 'update_vacancy'
733: ,p_hook_type => 'AP'
734: );
735: end;

Line 740: raise hr_api.validate_enabled;

736: --
737: -- When in validation only mode raise the Validate_Enabled exception
738: --
739: if p_validate then
740: raise hr_api.validate_enabled;
741: end if;
742: --
743: -- Set all output arguments
744: --

Line 752: when hr_api.validate_enabled then

748: p_inv_job_grade_warning := l_inv_job_grade_warning;
749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 70);
751: exception
752: when hr_api.validate_enabled then
753: --
754: -- As the Validate_Enabled exception has been raised
755: -- we must rollback to the savepoint
756: --

Line 816: when hr_api.cannot_find_prog_unit then

812: P_OBJECT_VERSION_NUMBER
813: ,P_VACANCY_ID
814: );
815: exception
816: when hr_api.cannot_find_prog_unit then
817: hr_api.cannot_find_prog_unit_error
818: (p_module_name => 'delete_vacancy'
819: ,p_hook_type => 'BP'
820: );

Line 817: hr_api.cannot_find_prog_unit_error

813: ,P_VACANCY_ID
814: );
815: exception
816: when hr_api.cannot_find_prog_unit then
817: hr_api.cannot_find_prog_unit_error
818: (p_module_name => 'delete_vacancy'
819: ,p_hook_type => 'BP'
820: );
821: end;

Line 842: when hr_api.cannot_find_prog_unit then

838: P_OBJECT_VERSION_NUMBER
839: ,P_VACANCY_ID
840: );
841: exception
842: when hr_api.cannot_find_prog_unit then
843: hr_api.cannot_find_prog_unit_error
844: (p_module_name => 'delete_vacancy'
845: ,p_hook_type => 'AP'
846: );

Line 843: hr_api.cannot_find_prog_unit_error

839: ,P_VACANCY_ID
840: );
841: exception
842: when hr_api.cannot_find_prog_unit then
843: hr_api.cannot_find_prog_unit_error
844: (p_module_name => 'delete_vacancy'
845: ,p_hook_type => 'AP'
846: );
847: end;

Line 852: raise hr_api.validate_enabled;

848: --
849: -- When in validation only mode raise the Validate_Enabled exception
850: --
851: if p_validate then
852: raise hr_api.validate_enabled;
853: end if;
854: --
855: -- Set all output arguments
856: --

Line 860: when hr_api.validate_enabled then

856: --
857: --
858: hr_utility.set_location(' Leaving:'||l_proc, 70);
859: exception
860: when hr_api.validate_enabled then
861: --
862: -- As the Validate_Enabled exception has been raised
863: -- we must rollback to the savepoint
864: --