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

Line 13: (p_validate in number default hr_api.g_false_num

9: -- ----------------------------------------------------------------------------
10: -- |----------------------------< create_vacancy >----------------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE create_vacancy
13: (p_validate in number default hr_api.g_false_num
14: ,p_effective_date in date
15: ,p_requisition_id in number
16: ,p_date_from in date
17: ,p_name in varchar2

Line 101: hr_api.constant_to_boolean

97: --
98: -- Convert constant values to their corresponding boolean value
99: --
100: l_validate :=
101: hr_api.constant_to_boolean
102: (p_constant_value => p_validate);
103: --
104: -- Register Surrogate ID or user key values
105: --

Line 247: (p_validate in number default hr_api.g_false_num

243: -- ----------------------------------------------------------------------------
244: -- |----------------------------< delete_vacancy >----------------------------|
245: -- ----------------------------------------------------------------------------
246: PROCEDURE delete_vacancy
247: (p_validate in number default hr_api.g_false_num
248: ,p_object_version_number in number
249: ,p_vacancy_id in number
250: ,p_return_status out nocopy varchar2
251: ) is

Line 277: hr_api.constant_to_boolean

273: --
274: -- Convert constant values to their corresponding boolean value
275: --
276: l_validate :=
277: hr_api.constant_to_boolean
278: (p_constant_value => p_validate);
279: --
280: -- Register Surrogate ID or user key values
281: --

Line 341: (p_validate in number default hr_api.g_false_num

337: -- ----------------------------------------------------------------------------
338: -- |----------------------------< update_vacancy >----------------------------|
339: -- ----------------------------------------------------------------------------
340: PROCEDURE update_vacancy
341: (p_validate in number default hr_api.g_false_num
342: ,p_effective_date in date
343: ,p_vacancy_id in number
344: ,p_object_version_number in out nocopy number
345: ,p_date_from in date default hr_api.g_date

Line 345: ,p_date_from in date default hr_api.g_date

341: (p_validate in number default hr_api.g_false_num
342: ,p_effective_date in date
343: ,p_vacancy_id in number
344: ,p_object_version_number in out nocopy number
345: ,p_date_from in date default hr_api.g_date
346: ,p_position_id in number default hr_api.g_number
347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number

Line 346: ,p_position_id in number default hr_api.g_number

342: ,p_effective_date in date
343: ,p_vacancy_id in number
344: ,p_object_version_number in out nocopy number
345: ,p_date_from in date default hr_api.g_date
346: ,p_position_id in number default hr_api.g_number
347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number

Line 347: ,p_job_id in number default hr_api.g_number

343: ,p_vacancy_id in number
344: ,p_object_version_number in out nocopy number
345: ,p_date_from in date default hr_api.g_date
346: ,p_position_id in number default hr_api.g_number
347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number

Line 348: ,p_grade_id in number default hr_api.g_number

344: ,p_object_version_number in out nocopy number
345: ,p_date_from in date default hr_api.g_date
346: ,p_position_id in number default hr_api.g_number
347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number

Line 349: ,p_organization_id in number default hr_api.g_number

345: ,p_date_from in date default hr_api.g_date
346: ,p_position_id in number default hr_api.g_number
347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date

Line 350: ,p_people_group_id in number default hr_api.g_number

346: ,p_position_id in number default hr_api.g_number
347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2

Line 351: ,p_location_id in number default hr_api.g_number

347: ,p_job_id in number default hr_api.g_number
348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2

Line 352: ,p_recruiter_id in number default hr_api.g_number

348: ,p_grade_id in number default hr_api.g_number
349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number

Line 353: ,p_date_to in date default hr_api.g_date

349: ,p_organization_id in number default hr_api.g_number
350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2

Line 354: ,p_security_method in varchar2 default hr_api.g_varchar2

350: ,p_people_group_id in number default hr_api.g_number
351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2

Line 355: ,p_description in varchar2 default hr_api.g_varchar2

351: ,p_location_id in number default hr_api.g_number
352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number

Line 356: ,p_number_of_openings in number default hr_api.g_number

352: ,p_recruiter_id in number default hr_api.g_number
353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2

Line 357: ,p_status in varchar2 default hr_api.g_varchar2

353: ,p_date_to in date default hr_api.g_date
354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number

Line 358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2

354: ,p_security_method in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number

Line 359: ,p_budget_measurement_value in number default hr_api.g_number

355: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number

Line 360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2

356: ,p_number_of_openings in number default hr_api.g_number
357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 361: ,p_manager_id in number default hr_api.g_number

357: ,p_status in varchar2 default hr_api.g_varchar2
358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 362: ,p_primary_posting_id in number default hr_api.g_number

358: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 363: ,p_assessment_id in number default hr_api.g_number

359: ,p_budget_measurement_value in number default hr_api.g_number
360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 364: ,p_attribute_category in varchar2 default hr_api.g_varchar2

360: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 365: ,p_attribute1 in varchar2 default hr_api.g_varchar2

361: ,p_manager_id in number default hr_api.g_number
362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 366: ,p_attribute2 in varchar2 default hr_api.g_varchar2

362: ,p_primary_posting_id in number default hr_api.g_number
363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 367: ,p_attribute3 in varchar2 default hr_api.g_varchar2

363: ,p_assessment_id in number default hr_api.g_number
364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute4 in varchar2 default hr_api.g_varchar2

364: ,p_attribute_category in varchar2 default hr_api.g_varchar2
365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 369: ,p_attribute5 in varchar2 default hr_api.g_varchar2

365: ,p_attribute1 in varchar2 default hr_api.g_varchar2
366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 370: ,p_attribute6 in varchar2 default hr_api.g_varchar2

366: ,p_attribute2 in varchar2 default hr_api.g_varchar2
367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 371: ,p_attribute7 in varchar2 default hr_api.g_varchar2

367: ,p_attribute3 in varchar2 default hr_api.g_varchar2
368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 372: ,p_attribute8 in varchar2 default hr_api.g_varchar2

368: ,p_attribute4 in varchar2 default hr_api.g_varchar2
369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 373: ,p_attribute9 in varchar2 default hr_api.g_varchar2

369: ,p_attribute5 in varchar2 default hr_api.g_varchar2
370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 374: ,p_attribute10 in varchar2 default hr_api.g_varchar2

370: ,p_attribute6 in varchar2 default hr_api.g_varchar2
371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 375: ,p_attribute11 in varchar2 default hr_api.g_varchar2

371: ,p_attribute7 in varchar2 default hr_api.g_varchar2
372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 376: ,p_attribute12 in varchar2 default hr_api.g_varchar2

372: ,p_attribute8 in varchar2 default hr_api.g_varchar2
373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 377: ,p_attribute13 in varchar2 default hr_api.g_varchar2

373: ,p_attribute9 in varchar2 default hr_api.g_varchar2
374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 378: ,p_attribute14 in varchar2 default hr_api.g_varchar2

374: ,p_attribute10 in varchar2 default hr_api.g_varchar2
375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 379: ,p_attribute15 in varchar2 default hr_api.g_varchar2

375: ,p_attribute11 in varchar2 default hr_api.g_varchar2
376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 380: ,p_attribute16 in varchar2 default hr_api.g_varchar2

376: ,p_attribute12 in varchar2 default hr_api.g_varchar2
377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 381: ,p_attribute17 in varchar2 default hr_api.g_varchar2

377: ,p_attribute13 in varchar2 default hr_api.g_varchar2
378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 382: ,p_attribute18 in varchar2 default hr_api.g_varchar2

378: ,p_attribute14 in varchar2 default hr_api.g_varchar2
379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 383: ,p_attribute19 in varchar2 default hr_api.g_varchar2

379: ,p_attribute15 in varchar2 default hr_api.g_varchar2
380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 384: ,p_attribute20 in varchar2 default hr_api.g_varchar2

380: ,p_attribute16 in varchar2 default hr_api.g_varchar2
381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 385: ,p_attribute21 in varchar2 default hr_api.g_varchar2

381: ,p_attribute17 in varchar2 default hr_api.g_varchar2
382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 386: ,p_attribute22 in varchar2 default hr_api.g_varchar2

382: ,p_attribute18 in varchar2 default hr_api.g_varchar2
383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 387: ,p_attribute23 in varchar2 default hr_api.g_varchar2

383: ,p_attribute19 in varchar2 default hr_api.g_varchar2
384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 388: ,p_attribute24 in varchar2 default hr_api.g_varchar2

384: ,p_attribute20 in varchar2 default hr_api.g_varchar2
385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 389: ,p_attribute25 in varchar2 default hr_api.g_varchar2

385: ,p_attribute21 in varchar2 default hr_api.g_varchar2
386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 390: ,p_attribute26 in varchar2 default hr_api.g_varchar2

386: ,p_attribute22 in varchar2 default hr_api.g_varchar2
387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2
394: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 391: ,p_attribute27 in varchar2 default hr_api.g_varchar2

387: ,p_attribute23 in varchar2 default hr_api.g_varchar2
388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2
394: ,p_attribute30 in varchar2 default hr_api.g_varchar2
395: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2

Line 392: ,p_attribute28 in varchar2 default hr_api.g_varchar2

388: ,p_attribute24 in varchar2 default hr_api.g_varchar2
389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2
394: ,p_attribute30 in varchar2 default hr_api.g_varchar2
395: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
396: ,p_assignment_changed out nocopy number

Line 393: ,p_attribute29 in varchar2 default hr_api.g_varchar2

389: ,p_attribute25 in varchar2 default hr_api.g_varchar2
390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2
394: ,p_attribute30 in varchar2 default hr_api.g_varchar2
395: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
396: ,p_assignment_changed out nocopy number
397: ,p_return_status out nocopy varchar2

Line 394: ,p_attribute30 in varchar2 default hr_api.g_varchar2

390: ,p_attribute26 in varchar2 default hr_api.g_varchar2
391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2
394: ,p_attribute30 in varchar2 default hr_api.g_varchar2
395: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
396: ,p_assignment_changed out nocopy number
397: ,p_return_status out nocopy varchar2
398: ) is

Line 395: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2

391: ,p_attribute27 in varchar2 default hr_api.g_varchar2
392: ,p_attribute28 in varchar2 default hr_api.g_varchar2
393: ,p_attribute29 in varchar2 default hr_api.g_varchar2
394: ,p_attribute30 in varchar2 default hr_api.g_varchar2
395: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
396: ,p_assignment_changed out nocopy number
397: ,p_return_status out nocopy varchar2
398: ) is
399: --

Line 429: hr_api.constant_to_boolean

425: --
426: -- Convert constant values to their corresponding boolean value
427: --
428: l_validate :=
429: hr_api.constant_to_boolean
430: (p_constant_value => p_validate);
431: l_assignment_changed :=
432: hr_api.constant_to_boolean
433: (p_constant_value => p_assignment_changed);

Line 432: hr_api.constant_to_boolean

428: l_validate :=
429: hr_api.constant_to_boolean
430: (p_constant_value => p_validate);
431: l_assignment_changed :=
432: hr_api.constant_to_boolean
433: (p_constant_value => p_assignment_changed);
434: --
435: -- Register Surrogate ID or user key values
436: --

Line 524: hr_api.boolean_to_constant

520: --
521: -- Convert API non-warning boolean parameter values
522: --
523: p_assignment_changed :=
524: hr_api.boolean_to_constant
525: (p_boolean_value => l_assignment_changed
526: );
527: --
528: -- Derive the API return status value based on whether

Line 576: ,p_validate in number default hr_api.g_false_num

572: procedure process_api
573: (
574: p_document in CLOB
575: ,p_return_status out nocopy VARCHAR2
576: ,p_validate in number default hr_api.g_false_num
577: ,p_effective_date in date default null
578: )
579: IS
580: l_postState VARCHAR2(2);

Line 779: gmisc_value in number default hr_api.g_number)

775: --
776: Function getNumberValueP2(
777: commitNode in xmldom.DOMNode,
778: attributeName in VARCHAR2,
779: gmisc_value in number default hr_api.g_number)
780: return NUMBER IS
781: --
782: l_number NUMBER(22,2);
783: l_isNull VARCHAR2(22);

Line 928: from hr_api_transactions hrt

924: l_proc varchar2(72) := g_package || 'finalize_transaction';
925: --
926: cursor csr_vacancy_id is
927: select transaction_ref_id
928: from hr_api_transactions hrt
929: where hrt.transaction_id = p_transaction_id;
930: --
931: begin
932: --