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_VACANCY_API dependencies on HR_API

Line 162: when hr_api.cannot_find_prog_unit then

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

Line 163: hr_api.cannot_find_prog_unit_error

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

Line 291: when hr_api.cannot_find_prog_unit then

287: , p_inv_pos_grade_warning => l_inv_pos_grade_warning
288: , p_inv_job_grade_warning => l_inv_job_grade_warning
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'create_vacancy'
294: ,p_hook_type => 'AP'
295: );

Line 292: hr_api.cannot_find_prog_unit_error

288: , p_inv_job_grade_warning => l_inv_job_grade_warning
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'create_vacancy'
294: ,p_hook_type => 'AP'
295: );
296: end;

Line 301: raise hr_api.validate_enabled;

297: --
298: -- When in validation only mode raise the Validate_Enabled exception
299: --
300: if p_validate then
301: raise hr_api.validate_enabled;
302: end if;
303: --
304: -- Set all output arguments
305: --

Line 313: when hr_api.validate_enabled then

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

Line 353: , P_DATE_FROM in date default hr_api.g_date

349: P_VALIDATE in boolean default false
350: , P_EFFECTIVE_DATE in date default null
351: , P_VACANCY_ID in number
352: , P_OBJECT_VERSION_NUMBER in out nocopy number
353: , P_DATE_FROM in date default hr_api.g_date
354: , P_POSITION_ID in number default hr_api.g_number
355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number

Line 354: , P_POSITION_ID in number default hr_api.g_number

350: , P_EFFECTIVE_DATE in date default null
351: , P_VACANCY_ID in number
352: , P_OBJECT_VERSION_NUMBER in out nocopy number
353: , P_DATE_FROM in date default hr_api.g_date
354: , P_POSITION_ID in number default hr_api.g_number
355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number

Line 355: , P_JOB_ID in number default hr_api.g_number

351: , P_VACANCY_ID in number
352: , P_OBJECT_VERSION_NUMBER in out nocopy number
353: , P_DATE_FROM in date default hr_api.g_date
354: , P_POSITION_ID in number default hr_api.g_number
355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number

Line 356: , P_GRADE_ID in number default hr_api.g_number

352: , P_OBJECT_VERSION_NUMBER in out nocopy number
353: , P_DATE_FROM in date default hr_api.g_date
354: , P_POSITION_ID in number default hr_api.g_number
355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number

Line 357: , P_ORGANIZATION_ID in number default hr_api.g_number

353: , P_DATE_FROM in date default hr_api.g_date
354: , P_POSITION_ID in number default hr_api.g_number
355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date

Line 358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number

354: , P_POSITION_ID in number default hr_api.g_number
355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2

Line 359: , P_LOCATION_ID in number default hr_api.g_number

355: , P_JOB_ID in number default hr_api.g_number
356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2

Line 360: , P_RECRUITER_ID in number default hr_api.g_number

356: , P_GRADE_ID in number default hr_api.g_number
357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number

Line 361: , P_DATE_TO in date default hr_api.g_date

357: , P_ORGANIZATION_ID in number default hr_api.g_number
358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2

Line 362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2

358: , P_PEOPLE_GROUP_ID in number default hr_api.g_number
359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2

Line 363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2

359: , P_LOCATION_ID in number default hr_api.g_number
360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number

Line 364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number

360: , P_RECRUITER_ID in number default hr_api.g_number
361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2

Line 365: , P_STATUS in varchar2 default hr_api.g_varchar2

361: , P_DATE_TO in date default hr_api.g_date
362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number

Line 366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2

362: , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number

Line 367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number

363: , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number

Line 368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2

364: , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2

Line 369: , P_MANAGER_ID in number default hr_api.g_number

365: , P_STATUS in varchar2 default hr_api.g_varchar2
366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2

Line 370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number

366: , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2

Line 371: , P_ASSESSMENT_ID in number default hr_api.g_number

367: , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2

Line 372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2

368: , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2

Line 373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2

369: , P_MANAGER_ID in number default hr_api.g_number
370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2

Line 374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2

370: , P_PRIMARY_POSTING_ID in number default hr_api.g_number
371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2

Line 375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2

371: , P_ASSESSMENT_ID in number default hr_api.g_number
372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2

Line 376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2

372: , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2

Line 377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2

373: , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2

Line 378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2

374: , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2

Line 379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2

375: , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2

Line 380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2

376: , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2

Line 381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2

377: , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2

Line 382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2

378: , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2

Line 383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2

379: , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2

Line 384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2

380: , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2

Line 385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2

381: , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2

Line 386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2

382: , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2

Line 387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2

383: , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2

Line 388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2

384: , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2

Line 389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2

385: , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2

Line 390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2

386: , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2

Line 391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2

387: , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2

Line 392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2

388: , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2

Line 393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2

389: , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2

Line 394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2

390: , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2

Line 395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2

391: , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2

Line 396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2

392: , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2

Line 397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2

393: , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2

Line 398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2

394: , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2

Line 399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2

395: , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
403: , P_vacancy_region_type in varchar2 default hr_api.g_varchar2

Line 400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2

396: , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
403: , P_vacancy_region_type in varchar2 default hr_api.g_varchar2
404: , P_ASSIGNMENT_CHANGED out nocopy boolean

Line 401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2

397: , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
403: , P_vacancy_region_type in varchar2 default hr_api.g_varchar2
404: , P_ASSIGNMENT_CHANGED out nocopy boolean
405: ,p_inv_pos_grade_warning out nocopy boolean

Line 402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2

398: , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
403: , P_vacancy_region_type in varchar2 default hr_api.g_varchar2
404: , P_ASSIGNMENT_CHANGED out nocopy boolean
405: ,p_inv_pos_grade_warning out nocopy boolean
406: ,p_inv_job_grade_warning out nocopy boolean

Line 403: , P_vacancy_region_type in varchar2 default hr_api.g_varchar2

399: , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
400: , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
401: , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
402: , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
403: , P_vacancy_region_type in varchar2 default hr_api.g_varchar2
404: , P_ASSIGNMENT_CHANGED out nocopy boolean
405: ,p_inv_pos_grade_warning out nocopy boolean
406: ,p_inv_job_grade_warning out nocopy boolean
407: )

Line 515: when hr_api.cannot_find_prog_unit then

511: , P_ATTRIBUTE30 => P_ATTRIBUTE30
512: , P_vacancy_region_type => P_vacancy_region_type
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'update_vacancy'
518: ,p_hook_type => 'BP'
519: );

Line 516: hr_api.cannot_find_prog_unit_error

512: , P_vacancy_region_type => P_vacancy_region_type
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'update_vacancy'
518: ,p_hook_type => 'BP'
519: );
520: end;

Line 583: and (nvl(p_organization_id,0) <> hr_api.g_number)

579: l_ASSIGNMENT_CHANGED := FALSE;
580: --
581: -- start changes for bug 8518955
582: if (nvl(p_organization_id,0) <> nvl(per_vac_shd.g_old_rec.organization_id,0))
583: and (nvl(p_organization_id,0) <> hr_api.g_number)
584: then
585: l_ASSIGNMENT_CHANGED := TRUE;
586: --l_organization_id := p_organization_id;
587: --l_position_id := p_position_id;

Line 591: and (nvl(p_job_id,0) <> hr_api.g_number)

587: --l_position_id := p_position_id;
588: end if;
589: --
590: if (nvl(p_job_id,0) <> nvl(per_vac_shd.g_old_rec.job_id,0))
591: and (nvl(p_job_id,0) <> hr_api.g_number)
592: then
593: l_ASSIGNMENT_CHANGED := TRUE;
594: --l_job_id := p_job_id;
595: --l_position_id := p_position_id;

Line 599: and (nvl(p_grade_id,0) <> hr_api.g_number)

595: --l_position_id := p_position_id;
596: end if;
597: --
598: if (nvl(p_grade_id,0)<> nvl(per_vac_shd.g_old_rec.grade_id,0))
599: and (nvl(p_grade_id,0) <> hr_api.g_number)
600: then
601: l_ASSIGNMENT_CHANGED := TRUE;
602: --l_grade_id := p_grade_id;
603: end if;

Line 606: and (nvl(p_people_group_id,0) <> hr_api.g_number)

602: --l_grade_id := p_grade_id;
603: end if;
604: --
605: if (nvl(p_people_group_id,0) <> nvl(per_vac_shd.g_old_rec.people_group_id,0))
606: and (nvl(p_people_group_id,0) <> hr_api.g_number)
607: then
608: l_ASSIGNMENT_CHANGED := TRUE;
609: --l_people_group_id := p_people_group_id;
610: end if;

Line 613: and (nvl(p_position_id,0) <> hr_api.g_number)

609: --l_people_group_id := p_people_group_id;
610: end if;
611: --
612: if (nvl(p_position_id,0) <> nvl(per_vac_shd.g_old_rec.position_id,0))
613: and (nvl(p_position_id,0) <> hr_api.g_number)
614: then
615: l_ASSIGNMENT_CHANGED := TRUE;
616: --l_position_id := p_position_id;
617: end if;

Line 620: and (nvl(p_location_id,0) <> hr_api.g_number)

616: --l_position_id := p_position_id;
617: end if;
618: --
619: if (nvl(p_location_id,0) <> nvl(per_vac_shd.g_old_rec.location_id,0))
620: and (nvl(p_location_id,0) <> hr_api.g_number)
621: then
622: l_ASSIGNMENT_CHANGED := TRUE;
623: --l_location_id := p_location_id;
624: end if;

Line 627: and (nvl(p_recruiter_id,0) <> hr_api.g_number)

623: --l_location_id := p_location_id;
624: end if;
625: --
626: if (nvl(p_recruiter_id,0) <> nvl(per_vac_shd.g_old_rec.recruiter_id,0))
627: and (nvl(p_recruiter_id,0) <> hr_api.g_number)
628: then
629: l_ASSIGNMENT_CHANGED := TRUE;
630: --l_recruiter_id := p_recruiter_id;
631: end if;

Line 634: and (nvl(p_manager_id,0) <> hr_api.g_number)

630: --l_recruiter_id := p_recruiter_id;
631: end if;
632: --
633: if (nvl(p_manager_id,0) <> nvl(per_vac_shd.g_old_rec.manager_id,0))
634: and (nvl(p_manager_id,0) <> hr_api.g_number)
635: then
636: l_ASSIGNMENT_CHANGED := TRUE;
637: --l_manager_id := p_manager_id;
638: end if;

Line 647: when nvl(p_job_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.job_id

643: --l_position_id := p_position_id;
644: hr_utility.set_location(l_proc, 40);
645:
646: l_job_id := case
647: when nvl(p_job_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.job_id
648: else p_job_id
649: end;
650:
651: l_grade_id := case

Line 652: when nvl(p_grade_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.grade_id

648: else p_job_id
649: end;
650:
651: l_grade_id := case
652: when nvl(p_grade_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.grade_id
653: else p_grade_id
654: end;
655:
656: l_people_group_id := case

Line 657: when nvl(p_people_group_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.people_group_id

653: else p_grade_id
654: end;
655:
656: l_people_group_id := case
657: when nvl(p_people_group_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.people_group_id
658: else P_people_group_id
659: end;
660:
661: l_organization_id := case

Line 662: when nvl(p_organization_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.organization_id

658: else P_people_group_id
659: end;
660:
661: l_organization_id := case
662: when nvl(p_organization_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.organization_id
663: else nvl(p_organization_id,per_vac_shd.g_old_rec.organization_id)
664: end;
665:
666: l_position_id := case

Line 667: when nvl(p_position_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.position_id

663: else nvl(p_organization_id,per_vac_shd.g_old_rec.organization_id)
664: end;
665:
666: l_position_id := case
667: when nvl(p_position_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.position_id
668: else p_position_id
669: end;
670:
671: l_location_id := case

Line 672: when nvl(p_location_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.location_id

668: else p_position_id
669: end;
670:
671: l_location_id := case
672: when nvl(p_location_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.location_id
673: else p_location_id
674: end;
675:
676: l_manager_id := case

Line 677: when nvl(p_manager_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.manager_id

673: else p_location_id
674: end;
675:
676: l_manager_id := case
677: when nvl(p_manager_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.manager_id
678: else p_manager_id
679: end;
680:
681: l_recruiter_id := case

Line 682: when nvl(p_recruiter_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.recruiter_id

678: else p_manager_id
679: end;
680:
681: l_recruiter_id := case
682: when nvl(p_recruiter_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.recruiter_id
683: else p_recruiter_id
684: end;
685: --
686: /*update per_all_assignments_f asg

Line 714: and f2.effective_end_date = hr_api.g_eot )

710: and asg.vacancy_id = p_vacancy_id
711: and exists ( select 1
712: from per_all_assignments_f f2
713: where asg.assignment_id = f2.assignment_id
714: and f2.effective_end_date = hr_api.g_eot )
715: and not exists ( select 1
716: from per_all_assignments_f f2
717: where asg.assignment_id = f2.assignment_id
718: and f2.assignment_status_type_id in ( select assignment_status_type_id

Line 802: when hr_api.cannot_find_prog_unit then

798: ,p_inv_job_grade_warning => l_inv_job_grade_warning
799:
800: );
801: exception
802: when hr_api.cannot_find_prog_unit then
803: hr_api.cannot_find_prog_unit_error
804: (p_module_name => 'update_vacancy'
805: ,p_hook_type => 'AP'
806: );

Line 803: hr_api.cannot_find_prog_unit_error

799:
800: );
801: exception
802: when hr_api.cannot_find_prog_unit then
803: hr_api.cannot_find_prog_unit_error
804: (p_module_name => 'update_vacancy'
805: ,p_hook_type => 'AP'
806: );
807: end;

Line 812: raise hr_api.validate_enabled;

808: --
809: -- When in validation only mode raise the Validate_Enabled exception
810: --
811: if p_validate then
812: raise hr_api.validate_enabled;
813: end if;
814: --
815: -- Set all output arguments
816: --

Line 824: when hr_api.validate_enabled then

820: p_inv_job_grade_warning := l_inv_job_grade_warning;
821: --
822: hr_utility.set_location(' Leaving:'||l_proc, 70);
823: exception
824: when hr_api.validate_enabled then
825: --
826: -- As the Validate_Enabled exception has been raised
827: -- we must rollback to the savepoint
828: --

Line 888: when hr_api.cannot_find_prog_unit then

884: P_OBJECT_VERSION_NUMBER
885: ,P_VACANCY_ID
886: );
887: exception
888: when hr_api.cannot_find_prog_unit then
889: hr_api.cannot_find_prog_unit_error
890: (p_module_name => 'delete_vacancy'
891: ,p_hook_type => 'BP'
892: );

Line 889: hr_api.cannot_find_prog_unit_error

885: ,P_VACANCY_ID
886: );
887: exception
888: when hr_api.cannot_find_prog_unit then
889: hr_api.cannot_find_prog_unit_error
890: (p_module_name => 'delete_vacancy'
891: ,p_hook_type => 'BP'
892: );
893: end;

Line 914: when hr_api.cannot_find_prog_unit then

910: P_OBJECT_VERSION_NUMBER
911: ,P_VACANCY_ID
912: );
913: exception
914: when hr_api.cannot_find_prog_unit then
915: hr_api.cannot_find_prog_unit_error
916: (p_module_name => 'delete_vacancy'
917: ,p_hook_type => 'AP'
918: );

Line 915: hr_api.cannot_find_prog_unit_error

911: ,P_VACANCY_ID
912: );
913: exception
914: when hr_api.cannot_find_prog_unit then
915: hr_api.cannot_find_prog_unit_error
916: (p_module_name => 'delete_vacancy'
917: ,p_hook_type => 'AP'
918: );
919: end;

Line 924: raise hr_api.validate_enabled;

920: --
921: -- When in validation only mode raise the Validate_Enabled exception
922: --
923: if p_validate then
924: raise hr_api.validate_enabled;
925: end if;
926: --
927: -- Set all output arguments
928: --

Line 932: when hr_api.validate_enabled then

928: --
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 70);
931: exception
932: when hr_api.validate_enabled then
933: --
934: -- As the Validate_Enabled exception has been raised
935: -- we must rollback to the savepoint
936: --