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 100: hr_api.constant_to_boolean

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

Line 245: (p_validate in number default hr_api.g_false_num

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

Line 275: hr_api.constant_to_boolean

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

Line 339: (p_validate in number default hr_api.g_false_num

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

Line 343: ,p_date_from in date default hr_api.g_date

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

Line 344: ,p_position_id in number default hr_api.g_number

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

Line 345: ,p_job_id in number default hr_api.g_number

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

Line 346: ,p_grade_id in number default hr_api.g_number

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

Line 347: ,p_organization_id in number default hr_api.g_number

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

Line 348: ,p_people_group_id in number default hr_api.g_number

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

Line 349: ,p_location_id in number default hr_api.g_number

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

Line 350: ,p_recruiter_id in number default hr_api.g_number

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

Line 351: ,p_date_to in date default hr_api.g_date

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

Line 352: ,p_security_method in varchar2 default hr_api.g_varchar2

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

Line 353: ,p_description in varchar2 default hr_api.g_varchar2

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

Line 354: ,p_number_of_openings in number default hr_api.g_number

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

Line 355: ,p_status in varchar2 default hr_api.g_varchar2

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

Line 356: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2

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

Line 357: ,p_budget_measurement_value in number default hr_api.g_number

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

Line 358: ,p_vacancy_category in varchar2 default hr_api.g_varchar2

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

Line 359: ,p_manager_id in number default hr_api.g_number

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

Line 360: ,p_primary_posting_id in number default hr_api.g_number

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

Line 361: ,p_assessment_id in number default hr_api.g_number

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

Line 362: ,p_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 363: ,p_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 364: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 365: ,p_attribute3 in varchar2 default hr_api.g_varchar2

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

Line 366: ,p_attribute4 in varchar2 default hr_api.g_varchar2

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

Line 367: ,p_attribute5 in varchar2 default hr_api.g_varchar2

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

Line 368: ,p_attribute6 in varchar2 default hr_api.g_varchar2

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

Line 369: ,p_attribute7 in varchar2 default hr_api.g_varchar2

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

Line 370: ,p_attribute8 in varchar2 default hr_api.g_varchar2

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

Line 371: ,p_attribute9 in varchar2 default hr_api.g_varchar2

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

Line 372: ,p_attribute10 in varchar2 default hr_api.g_varchar2

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

Line 373: ,p_attribute11 in varchar2 default hr_api.g_varchar2

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

Line 374: ,p_attribute12 in varchar2 default hr_api.g_varchar2

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

Line 375: ,p_attribute13 in varchar2 default hr_api.g_varchar2

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

Line 376: ,p_attribute14 in varchar2 default hr_api.g_varchar2

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

Line 377: ,p_attribute15 in varchar2 default hr_api.g_varchar2

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

Line 378: ,p_attribute16 in varchar2 default hr_api.g_varchar2

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

Line 379: ,p_attribute17 in varchar2 default hr_api.g_varchar2

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

Line 380: ,p_attribute18 in varchar2 default hr_api.g_varchar2

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

Line 381: ,p_attribute19 in varchar2 default hr_api.g_varchar2

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

Line 382: ,p_attribute20 in varchar2 default hr_api.g_varchar2

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

Line 383: ,p_attribute21 in varchar2 default hr_api.g_varchar2

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

Line 384: ,p_attribute22 in varchar2 default hr_api.g_varchar2

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

Line 385: ,p_attribute23 in varchar2 default hr_api.g_varchar2

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

Line 386: ,p_attribute24 in varchar2 default hr_api.g_varchar2

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

Line 387: ,p_attribute25 in varchar2 default hr_api.g_varchar2

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

Line 388: ,p_attribute26 in varchar2 default hr_api.g_varchar2

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

Line 389: ,p_attribute27 in varchar2 default hr_api.g_varchar2

385: ,p_attribute23 in varchar2 default hr_api.g_varchar2
386: ,p_attribute24 in varchar2 default hr_api.g_varchar2
387: ,p_attribute25 in varchar2 default hr_api.g_varchar2
388: ,p_attribute26 in varchar2 default hr_api.g_varchar2
389: ,p_attribute27 in varchar2 default hr_api.g_varchar2
390: ,p_attribute28 in varchar2 default hr_api.g_varchar2
391: ,p_attribute29 in varchar2 default hr_api.g_varchar2
392: ,p_attribute30 in varchar2 default hr_api.g_varchar2
393: ,p_assignment_changed out nocopy number

Line 390: ,p_attribute28 in varchar2 default hr_api.g_varchar2

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

Line 391: ,p_attribute29 in varchar2 default hr_api.g_varchar2

387: ,p_attribute25 in varchar2 default hr_api.g_varchar2
388: ,p_attribute26 in varchar2 default hr_api.g_varchar2
389: ,p_attribute27 in varchar2 default hr_api.g_varchar2
390: ,p_attribute28 in varchar2 default hr_api.g_varchar2
391: ,p_attribute29 in varchar2 default hr_api.g_varchar2
392: ,p_attribute30 in varchar2 default hr_api.g_varchar2
393: ,p_assignment_changed out nocopy number
394: ,p_return_status out nocopy varchar2
395: ) is

Line 392: ,p_attribute30 in varchar2 default hr_api.g_varchar2

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

Line 426: hr_api.constant_to_boolean

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

Line 429: hr_api.constant_to_boolean

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

Line 520: hr_api.boolean_to_constant

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

Line 572: ,p_validate in number default hr_api.g_false_num

568: procedure process_api
569: (
570: p_document in CLOB
571: ,p_return_status out nocopy VARCHAR2
572: ,p_validate in number default hr_api.g_false_num
573: ,p_effective_date in date default null
574: )
575: IS
576: l_postState VARCHAR2(2);

Line 773: gmisc_value in number default hr_api.g_number)

769: --
770: Function getNumberValueP2(
771: commitNode in xmldom.DOMNode,
772: attributeName in VARCHAR2,
773: gmisc_value in number default hr_api.g_number)
774: return NUMBER IS
775: --
776: l_number NUMBER(22,2);
777: l_isNull VARCHAR2(22);

Line 886: from hr_api_transactions hrt

882: l_proc varchar2(72) := g_package || 'finalize_transaction';
883: --
884: cursor csr_vacancy_id is
885: select transaction_ref_id
886: from hr_api_transactions hrt
887: where hrt.transaction_id = p_transaction_id;
888: --
889: begin
890: --