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

Line 14: ,p_language_code in varchar2 default hr_api.userenv_lang

10: -- ----------------------------------------------------------------------------
11: --
12: procedure CREATE_RECRUITING_SITE
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_effective_date in date
16: ,p_site_name in varchar2
17: ,p_date_from in date default null
18: ,p_date_to in date default null

Line 85: hr_api.validate_language_code(p_language_code => l_language_code);

81: --
82: l_effective_date := trunc(p_effective_date);
83:
84: l_language_code := p_language_code;
85: hr_api.validate_language_code(p_language_code => l_language_code);
86: --
87: -- Call Before Process User Hook
88: --
89: begin

Line 142: when hr_api.cannot_find_prog_unit then

138: ,p_attribute30 => p_attribute30
139: );
140: hr_utility.set_location(l_proc, 30);
141: exception
142: when hr_api.cannot_find_prog_unit then
143: hr_api.cannot_find_prog_unit_error
144: (p_module_name => 'CREATE_RECRUITING_SITE'
145: ,p_hook_type => 'BP'
146: );

Line 143: hr_api.cannot_find_prog_unit_error

139: );
140: hr_utility.set_location(l_proc, 30);
141: exception
142: when hr_api.cannot_find_prog_unit then
143: hr_api.cannot_find_prog_unit_error
144: (p_module_name => 'CREATE_RECRUITING_SITE'
145: ,p_hook_type => 'BP'
146: );
147: end;

Line 273: when hr_api.cannot_find_prog_unit then

269: ,p_recruiting_site_id => l_recruiting_site_id
270: );
271: hr_utility.set_location(l_proc, 60);
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'CREATE_RECRUITING_SITE'
276: ,p_hook_type => 'AP'
277: );

Line 274: hr_api.cannot_find_prog_unit_error

270: );
271: hr_utility.set_location(l_proc, 60);
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'CREATE_RECRUITING_SITE'
276: ,p_hook_type => 'AP'
277: );
278: end;

Line 283: raise hr_api.validate_enabled;

279: --
280: -- When in validation only mode raise the Validate_Enabled exception
281: --
282: if p_validate then
283: raise hr_api.validate_enabled;
284: end if;
285: --
286: -- Set all output arguments
287: --

Line 293: when hr_api.validate_enabled then

289: p_recruiting_site_id := l_recruiting_site_id;
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 70);
292: exception
293: when hr_api.validate_enabled then
294: --
295: -- As the Validate_Enabled exception has been raised
296: -- we must rollback to the savepoint
297: --

Line 332: ,p_language_code in varchar2 default hr_api.userenv_lang

328: --
329: procedure UPDATE_RECRUITING_SITE
330: (p_recruiting_site_id in number
331: ,p_validate in boolean default false
332: ,p_language_code in varchar2 default hr_api.userenv_lang
333: ,p_effective_date in date
334: ,p_site_name in varchar2 default hr_api.g_varchar2
335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date

Line 334: ,p_site_name in varchar2 default hr_api.g_varchar2

330: (p_recruiting_site_id in number
331: ,p_validate in boolean default false
332: ,p_language_code in varchar2 default hr_api.userenv_lang
333: ,p_effective_date in date
334: ,p_site_name in varchar2 default hr_api.g_varchar2
335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2

Line 335: ,p_date_from in date default hr_api.g_date

331: ,p_validate in boolean default false
332: ,p_language_code in varchar2 default hr_api.userenv_lang
333: ,p_effective_date in date
334: ,p_site_name in varchar2 default hr_api.g_varchar2
335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2

Line 336: ,p_date_to in date default hr_api.g_date

332: ,p_language_code in varchar2 default hr_api.userenv_lang
333: ,p_effective_date in date
334: ,p_site_name in varchar2 default hr_api.g_varchar2
335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2

Line 337: ,p_posting_username in varchar2 default hr_api.g_varchar2

333: ,p_effective_date in date
334: ,p_site_name in varchar2 default hr_api.g_varchar2
335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2

Line 338: ,p_posting_password in varchar2 default hr_api.g_varchar2

334: ,p_site_name in varchar2 default hr_api.g_varchar2
335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2

Line 339: ,p_internal in varchar2 default hr_api.g_varchar2

335: ,p_date_from in date default hr_api.g_date
336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2

Line 340: ,p_external in varchar2 default hr_api.g_varchar2

336: ,p_date_to in date default hr_api.g_date
337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number

Line 341: ,p_third_party in varchar2 default hr_api.g_varchar2

337: ,p_posting_username in varchar2 default hr_api.g_varchar2
338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2

Line 342: ,p_redirection_url in varchar2 default hr_api.g_varchar2

338: ,p_posting_password in varchar2 default hr_api.g_varchar2
339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2

Line 343: ,p_posting_url in varchar2 default hr_api.g_varchar2

339: ,p_internal in varchar2 default hr_api.g_varchar2
340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2

Line 344: ,p_posting_cost in number default hr_api.g_number

340: ,p_external in varchar2 default hr_api.g_varchar2
341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2

341: ,p_third_party in varchar2 default hr_api.g_varchar2
342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2

342: ,p_redirection_url in varchar2 default hr_api.g_varchar2
343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 347: ,p_stylesheet in varchar2 default hr_api.g_varchar2

343: ,p_posting_url in varchar2 default hr_api.g_varchar2
344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 348: ,p_attribute_category in varchar2 default hr_api.g_varchar2

344: ,p_posting_cost in number default hr_api.g_number
345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 349: ,p_attribute1 in varchar2 default hr_api.g_varchar2

345: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 350: ,p_attribute2 in varchar2 default hr_api.g_varchar2

346: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 351: ,p_attribute3 in varchar2 default hr_api.g_varchar2

347: ,p_stylesheet in varchar2 default hr_api.g_varchar2
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 352: ,p_attribute4 in varchar2 default hr_api.g_varchar2

348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 353: ,p_attribute5 in varchar2 default hr_api.g_varchar2

349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 354: ,p_attribute6 in varchar2 default hr_api.g_varchar2

350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 355: ,p_attribute7 in varchar2 default hr_api.g_varchar2

351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 356: ,p_attribute8 in varchar2 default hr_api.g_varchar2

352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 357: ,p_attribute9 in varchar2 default hr_api.g_varchar2

353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 358: ,p_attribute10 in varchar2 default hr_api.g_varchar2

354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 359: ,p_attribute11 in varchar2 default hr_api.g_varchar2

355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 360: ,p_attribute12 in varchar2 default hr_api.g_varchar2

356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 361: ,p_attribute13 in varchar2 default hr_api.g_varchar2

357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 362: ,p_attribute14 in varchar2 default hr_api.g_varchar2

358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 363: ,p_attribute15 in varchar2 default hr_api.g_varchar2

359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 364: ,p_attribute16 in varchar2 default hr_api.g_varchar2

360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 365: ,p_attribute17 in varchar2 default hr_api.g_varchar2

361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 366: ,p_attribute18 in varchar2 default hr_api.g_varchar2

362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 367: ,p_attribute19 in varchar2 default hr_api.g_varchar2

363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute20 in varchar2 default hr_api.g_varchar2

364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 369: ,p_attribute21 in varchar2 default hr_api.g_varchar2

365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 370: ,p_attribute22 in varchar2 default hr_api.g_varchar2

366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 371: ,p_attribute23 in varchar2 default hr_api.g_varchar2

367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 372: ,p_attribute24 in varchar2 default hr_api.g_varchar2

368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 373: ,p_attribute25 in varchar2 default hr_api.g_varchar2

369: ,p_attribute21 in varchar2 default hr_api.g_varchar2
370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2
377: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 374: ,p_attribute26 in varchar2 default hr_api.g_varchar2

370: ,p_attribute22 in varchar2 default hr_api.g_varchar2
371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2
377: ,p_attribute29 in varchar2 default hr_api.g_varchar2
378: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 375: ,p_attribute27 in varchar2 default hr_api.g_varchar2

371: ,p_attribute23 in varchar2 default hr_api.g_varchar2
372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2
377: ,p_attribute29 in varchar2 default hr_api.g_varchar2
378: ,p_attribute30 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number

Line 376: ,p_attribute28 in varchar2 default hr_api.g_varchar2

372: ,p_attribute24 in varchar2 default hr_api.g_varchar2
373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2
377: ,p_attribute29 in varchar2 default hr_api.g_varchar2
378: ,p_attribute30 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ) is

Line 377: ,p_attribute29 in varchar2 default hr_api.g_varchar2

373: ,p_attribute25 in varchar2 default hr_api.g_varchar2
374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2
377: ,p_attribute29 in varchar2 default hr_api.g_varchar2
378: ,p_attribute30 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ) is
381: --

Line 378: ,p_attribute30 in varchar2 default hr_api.g_varchar2

374: ,p_attribute26 in varchar2 default hr_api.g_varchar2
375: ,p_attribute27 in varchar2 default hr_api.g_varchar2
376: ,p_attribute28 in varchar2 default hr_api.g_varchar2
377: ,p_attribute29 in varchar2 default hr_api.g_varchar2
378: ,p_attribute30 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ) is
381: --
382: -- Declare cursors and local variables

Line 402: hr_api.validate_language_code(p_language_code => l_language_code);

398: --
399: l_effective_date := trunc(p_effective_date);
400:
401: l_language_code:=p_language_code;
402: hr_api.validate_language_code(p_language_code => l_language_code);
403: --
404: -- Call Before Process User Hook
405: --
406: begin

Line 459: when hr_api.cannot_find_prog_unit then

455: ,p_attribute29 => p_attribute29
456: ,p_attribute30 => p_attribute30
457: );
458: exception
459: when hr_api.cannot_find_prog_unit then
460: hr_api.cannot_find_prog_unit_error
461: (p_module_name => 'UPDATE_RECRUITING_SITE'
462: ,p_hook_type => 'BP'
463: );

Line 460: hr_api.cannot_find_prog_unit_error

456: ,p_attribute30 => p_attribute30
457: );
458: exception
459: when hr_api.cannot_find_prog_unit then
460: hr_api.cannot_find_prog_unit_error
461: (p_module_name => 'UPDATE_RECRUITING_SITE'
462: ,p_hook_type => 'BP'
463: );
464: end;

Line 534: if (p_posting_password <>hr_api.g_varchar2) then

530: ,p_posting_url => p_posting_url
531: );
532: --
533: --save the password to the encrypted store
534: if (p_posting_password <>hr_api.g_varchar2) then
535: fnd_vault.put('IRC_SITE',p_recruiting_site_id,p_posting_password);
536: end if;
537: --
538: -- Call After Process User Hook

Line 593: when hr_api.cannot_find_prog_unit then

589: ,p_attribute29 => p_attribute29
590: ,p_attribute30 => p_attribute30
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'UPDATE_RECRUITING_SITE'
596: ,p_hook_type => 'AP'
597: );

Line 594: hr_api.cannot_find_prog_unit_error

590: ,p_attribute30 => p_attribute30
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'UPDATE_RECRUITING_SITE'
596: ,p_hook_type => 'AP'
597: );
598: end;

Line 603: raise hr_api.validate_enabled;

599: --
600: -- When in validation only mode raise the Validate_Enabled exception
601: --
602: if p_validate then
603: raise hr_api.validate_enabled;
604: end if;
605: --
606: -- Set all output arguments
607: --

Line 612: when hr_api.validate_enabled then

608: --
609: p_object_version_number := l_object_version_number;
610: hr_utility.set_location(' Leaving:'||l_proc, 70);
611: exception
612: when hr_api.validate_enabled then
613: --
614: -- As the Validate_Enabled exception has been raised
615: -- we must rollback to the savepoint
616: --

Line 673: when hr_api.cannot_find_prog_unit then

669: (p_recruiting_site_id => p_recruiting_site_id
670: ,p_object_version_number => p_object_version_number
671: );
672: exception
673: when hr_api.cannot_find_prog_unit then
674: hr_api.cannot_find_prog_unit_error
675: (p_module_name => 'DELETE_RECRUITING_SITE'
676: ,p_hook_type => 'BP'
677: );

Line 674: hr_api.cannot_find_prog_unit_error

670: ,p_object_version_number => p_object_version_number
671: );
672: exception
673: when hr_api.cannot_find_prog_unit then
674: hr_api.cannot_find_prog_unit_error
675: (p_module_name => 'DELETE_RECRUITING_SITE'
676: ,p_hook_type => 'BP'
677: );
678: end;

Line 716: when hr_api.cannot_find_prog_unit then

712: (p_recruiting_site_id => p_recruiting_site_id
713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'DELETE_RECRUITING_SITE'
719: ,p_hook_type => 'AP'
720: );

Line 717: hr_api.cannot_find_prog_unit_error

713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'DELETE_RECRUITING_SITE'
719: ,p_hook_type => 'AP'
720: );
721: end;

Line 726: raise hr_api.validate_enabled;

722: --
723: -- When in validation only mode raise the Validate_Enabled exception
724: --
725: if p_validate then
726: raise hr_api.validate_enabled;
727: end if;
728: --
729: -- Set all output arguments
730: --

Line 734: when hr_api.validate_enabled then

730: --
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 70);
733: exception
734: when hr_api.validate_enabled then
735: --
736: -- As the Validate_Enabled exception has been raised
737: -- we must rollback to the savepoint
738: --