DBA Data[Home] [Help]

APPS.HR_OBJECTIVE_LIBRARY_SWI dependencies on HR_API

Line 13: (p_validate in number default hr_api.g_false_num

9: -- ----------------------------------------------------------------------------
10: -- |-----------------------< create_library_objective >-----------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE create_library_objective
13: (p_validate in number default hr_api.g_false_num
14: ,p_effective_date in date
15: ,p_objective_name in varchar2
16: ,p_valid_from in date default null
17: ,p_valid_to in date default null

Line 99: hr_api.constant_to_boolean

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

Line 252: (p_validate in number default hr_api.g_false_num

248: -- ----------------------------------------------------------------------------
249: -- |-----------------------< delete_library_objective >-----------------------|
250: -- ----------------------------------------------------------------------------
251: PROCEDURE delete_library_objective
252: (p_validate in number default hr_api.g_false_num
253: ,p_objective_id in number
254: ,p_object_version_number in number
255: ,p_return_status out nocopy varchar2
256: ) is

Line 282: hr_api.constant_to_boolean

278: --
279: -- Convert constant values to their corresponding boolean value
280: --
281: l_validate :=
282: hr_api.constant_to_boolean
283: (p_constant_value => p_validate);
284: --
285: -- Register Surrogate ID or user key values
286: --

Line 346: (p_validate in number default hr_api.g_false_num

342: -- ----------------------------------------------------------------------------
343: -- |-----------------------< update_library_objective >-----------------------|
344: -- ----------------------------------------------------------------------------
345: PROCEDURE update_library_objective
346: (p_validate in number default hr_api.g_false_num
347: ,p_effective_date in date
348: ,p_objective_id in number
349: ,p_objective_name in varchar2 default hr_api.g_varchar2
350: ,p_valid_from in date default hr_api.g_date

Line 349: ,p_objective_name in varchar2 default hr_api.g_varchar2

345: PROCEDURE update_library_objective
346: (p_validate in number default hr_api.g_false_num
347: ,p_effective_date in date
348: ,p_objective_id in number
349: ,p_objective_name in varchar2 default hr_api.g_varchar2
350: ,p_valid_from in date default hr_api.g_date
351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date

Line 350: ,p_valid_from in date default hr_api.g_date

346: (p_validate in number default hr_api.g_false_num
347: ,p_effective_date in date
348: ,p_objective_id in number
349: ,p_objective_name in varchar2 default hr_api.g_varchar2
350: ,p_valid_from in date default hr_api.g_date
351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2

Line 351: ,p_valid_to in date default hr_api.g_date

347: ,p_effective_date in date
348: ,p_objective_id in number
349: ,p_objective_name in varchar2 default hr_api.g_varchar2
350: ,p_valid_from in date default hr_api.g_date
351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2

Line 352: ,p_target_date in date default hr_api.g_date

348: ,p_objective_id in number
349: ,p_objective_name in varchar2 default hr_api.g_varchar2
350: ,p_valid_from in date default hr_api.g_date
351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2

Line 353: ,p_next_review_date in date default hr_api.g_date

349: ,p_objective_name in varchar2 default hr_api.g_varchar2
350: ,p_valid_from in date default hr_api.g_date
351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number

Line 354: ,p_group_code in varchar2 default hr_api.g_varchar2

350: ,p_valid_from in date default hr_api.g_date
351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2

Line 355: ,p_priority_code in varchar2 default hr_api.g_varchar2

351: ,p_valid_to in date default hr_api.g_date
352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2

Line 356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2

352: ,p_target_date in date default hr_api.g_date
353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number

Line 357: ,p_weighting_percent in number default hr_api.g_number

353: ,p_next_review_date in date default hr_api.g_date
354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2

Line 358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2

354: ,p_group_code in varchar2 default hr_api.g_varchar2
355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2

Line 359: ,p_measure_name in varchar2 default hr_api.g_varchar2

355: ,p_priority_code in varchar2 default hr_api.g_varchar2
356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2

Line 360: ,p_target_value in number default hr_api.g_number

356: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2

Line 361: ,p_uom_code in varchar2 default hr_api.g_varchar2

357: ,p_weighting_percent in number default hr_api.g_number
358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2

Line 362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2

358: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2

Line 363: ,p_measure_comments in varchar2 default hr_api.g_varchar2

359: ,p_measure_name in varchar2 default hr_api.g_varchar2
360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2

Line 364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2

360: ,p_target_value in number default hr_api.g_number
361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 365: ,p_details in varchar2 default hr_api.g_varchar2

361: ,p_uom_code in varchar2 default hr_api.g_varchar2
362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 366: ,p_success_criteria in varchar2 default hr_api.g_varchar2

362: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 367: ,p_comments in varchar2 default hr_api.g_varchar2

363: ,p_measure_comments in varchar2 default hr_api.g_varchar2
364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute_category in varchar2 default hr_api.g_varchar2

364: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 369: ,p_attribute1 in varchar2 default hr_api.g_varchar2

365: ,p_details in varchar2 default hr_api.g_varchar2
366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 370: ,p_attribute2 in varchar2 default hr_api.g_varchar2

366: ,p_success_criteria in varchar2 default hr_api.g_varchar2
367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 371: ,p_attribute3 in varchar2 default hr_api.g_varchar2

367: ,p_comments in varchar2 default hr_api.g_varchar2
368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 372: ,p_attribute4 in varchar2 default hr_api.g_varchar2

368: ,p_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 373: ,p_attribute5 in varchar2 default hr_api.g_varchar2

369: ,p_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 374: ,p_attribute6 in varchar2 default hr_api.g_varchar2

370: ,p_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 375: ,p_attribute7 in varchar2 default hr_api.g_varchar2

371: ,p_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 376: ,p_attribute8 in varchar2 default hr_api.g_varchar2

372: ,p_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 377: ,p_attribute9 in varchar2 default hr_api.g_varchar2

373: ,p_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 378: ,p_attribute10 in varchar2 default hr_api.g_varchar2

374: ,p_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 379: ,p_attribute11 in varchar2 default hr_api.g_varchar2

375: ,p_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 380: ,p_attribute12 in varchar2 default hr_api.g_varchar2

376: ,p_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 381: ,p_attribute13 in varchar2 default hr_api.g_varchar2

377: ,p_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 382: ,p_attribute14 in varchar2 default hr_api.g_varchar2

378: ,p_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 383: ,p_attribute15 in varchar2 default hr_api.g_varchar2

379: ,p_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 384: ,p_attribute16 in varchar2 default hr_api.g_varchar2

380: ,p_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 385: ,p_attribute17 in varchar2 default hr_api.g_varchar2

381: ,p_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 386: ,p_attribute18 in varchar2 default hr_api.g_varchar2

382: ,p_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 387: ,p_attribute19 in varchar2 default hr_api.g_varchar2

383: ,p_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 388: ,p_attribute20 in varchar2 default hr_api.g_varchar2

384: ,p_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 389: ,p_attribute21 in varchar2 default hr_api.g_varchar2

385: ,p_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 390: ,p_attribute22 in varchar2 default hr_api.g_varchar2

386: ,p_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 391: ,p_attribute23 in varchar2 default hr_api.g_varchar2

387: ,p_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 392: ,p_attribute24 in varchar2 default hr_api.g_varchar2

388: ,p_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 393: ,p_attribute25 in varchar2 default hr_api.g_varchar2

389: ,p_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 394: ,p_attribute26 in varchar2 default hr_api.g_varchar2

390: ,p_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 395: ,p_attribute27 in varchar2 default hr_api.g_varchar2

391: ,p_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number

Line 396: ,p_attribute28 in varchar2 default hr_api.g_varchar2

392: ,p_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number
400: ,p_return_status out nocopy varchar2

Line 397: ,p_attribute29 in varchar2 default hr_api.g_varchar2

393: ,p_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number
400: ,p_return_status out nocopy varchar2
401: ) is

Line 398: ,p_attribute30 in varchar2 default hr_api.g_varchar2

394: ,p_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number
400: ,p_return_status out nocopy varchar2
401: ) is
402: --

Line 432: hr_api.constant_to_boolean

428: --
429: -- Convert constant values to their corresponding boolean value
430: --
431: l_validate :=
432: hr_api.constant_to_boolean
433: (p_constant_value => p_validate);
434: --
435: -- Register Surrogate ID or user key values
436: --

Line 610: (p_validate in number default hr_api.g_false_num

606: -- {End Of Comments}
607: --
608:
609: procedure create_eligy_profile
610: (p_validate in number default hr_api.g_false_num
611: ,p_name in varchar2 default null
612: ,p_bnft_cagr_prtn_cd in varchar2 default null
613: ,p_stat_cd in varchar2 default null
614: ,p_asmt_to_use_cd in varchar2 default null

Line 653: hr_api.constant_to_boolean

649: --
650: -- Convert constant values to their corresponding boolean value
651: --
652: l_validate :=
653: hr_api.constant_to_boolean
654: (p_constant_value => p_validate);
655: --
656: -- Register Surrogate ID or user key values
657: --

Line 760: ( p_validate in number default hr_api.g_false_num

756: --
757: -- {End Of Comments}
758: --
759: procedure update_eligy_profile
760: ( p_validate in number default hr_api.g_false_num
761: ,p_effective_date in date
762: ,p_business_group_id in number
763: ,p_name in varchar2 default null
764: ,p_bnft_cagr_prtn_cd in varchar2 default null

Line 800: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);

796: --
797: --
798: -- Convert constant values to their corresponding boolean value
799: --
800: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);
801: --
802: HR_OBJECTIVE_LIBRARY_api.update_eligy_profile
803: (
804: p_validate => l_validate

Line 897: (p_validate in number default hr_api.g_false_num

893: --
894: -- {End Of Comments}
895: --
896: procedure create_eligy_object
897: (p_validate in number default hr_api.g_false_num
898: ,p_elig_obj_id in out nocopy number
899: ,p_effective_start_date out nocopy date
900: ,p_effective_end_date out nocopy date
901: ,p_business_group_id in number

Line 932: hr_api.constant_to_boolean

928: --
929: -- Convert constant values to their corresponding boolean value
930: --
931: l_validate :=
932: hr_api.constant_to_boolean
933: (p_constant_value => p_validate);
934: --
935: -- Register Surrogate ID or user key values
936: --

Line 1005: (p_validate in number default hr_api.g_false_num

1001: --
1002: -- {End Of Comments}
1003: --
1004: procedure update_eligy_object
1005: (p_validate in number default hr_api.g_false_num
1006: ,p_elig_obj_id in number
1007: ,p_effective_start_date out nocopy date
1008: ,p_effective_end_date out nocopy date
1009: ,p_business_group_id in number default hr_api.g_number

Line 1009: ,p_business_group_id in number default hr_api.g_number

1005: (p_validate in number default hr_api.g_false_num
1006: ,p_elig_obj_id in number
1007: ,p_effective_start_date out nocopy date
1008: ,p_effective_end_date out nocopy date
1009: ,p_business_group_id in number default hr_api.g_number
1010: ,p_table_name in varchar2 default hr_api.g_varchar2
1011: ,p_column_name in varchar2 default hr_api.g_varchar2
1012: ,p_column_value in varchar2 default hr_api.g_varchar2
1013: ,p_object_version_number in out nocopy number

Line 1010: ,p_table_name in varchar2 default hr_api.g_varchar2

1006: ,p_elig_obj_id in number
1007: ,p_effective_start_date out nocopy date
1008: ,p_effective_end_date out nocopy date
1009: ,p_business_group_id in number default hr_api.g_number
1010: ,p_table_name in varchar2 default hr_api.g_varchar2
1011: ,p_column_name in varchar2 default hr_api.g_varchar2
1012: ,p_column_value in varchar2 default hr_api.g_varchar2
1013: ,p_object_version_number in out nocopy number
1014: ,p_effective_date in date

Line 1011: ,p_column_name in varchar2 default hr_api.g_varchar2

1007: ,p_effective_start_date out nocopy date
1008: ,p_effective_end_date out nocopy date
1009: ,p_business_group_id in number default hr_api.g_number
1010: ,p_table_name in varchar2 default hr_api.g_varchar2
1011: ,p_column_name in varchar2 default hr_api.g_varchar2
1012: ,p_column_value in varchar2 default hr_api.g_varchar2
1013: ,p_object_version_number in out nocopy number
1014: ,p_effective_date in date
1015: ,p_datetrack_mode in varchar2

Line 1012: ,p_column_value in varchar2 default hr_api.g_varchar2

1008: ,p_effective_end_date out nocopy date
1009: ,p_business_group_id in number default hr_api.g_number
1010: ,p_table_name in varchar2 default hr_api.g_varchar2
1011: ,p_column_name in varchar2 default hr_api.g_varchar2
1012: ,p_column_value in varchar2 default hr_api.g_varchar2
1013: ,p_object_version_number in out nocopy number
1014: ,p_effective_date in date
1015: ,p_datetrack_mode in varchar2
1016: ) is

Line 1041: hr_api.constant_to_boolean

1037: --
1038: -- Convert constant values to their corresponding boolean value
1039: --
1040: l_validate :=
1041: hr_api.constant_to_boolean
1042: (p_constant_value => p_validate);
1043: --
1044: -- Register Surrogate ID or user key values
1045: --

Line 1113: (p_validate number default hr_api.g_false_num

1109: --
1110: -- {End Of Comments}
1111: --
1112: procedure delete_eligy_object
1113: (p_validate number default hr_api.g_false_num
1114: ,p_elig_obj_id in number
1115: ,p_effective_start_date out nocopy date
1116: ,p_effective_end_date out nocopy date
1117: ,p_object_version_number in out nocopy number

Line 1145: hr_api.constant_to_boolean

1141: --
1142: -- Convert constant values to their corresponding boolean value
1143: --
1144: l_validate :=
1145: hr_api.constant_to_boolean
1146: (p_constant_value => p_validate);
1147: --
1148: -- Register Surrogate ID or user key values
1149: --

Line 1213: (p_validate in number default hr_api.g_false_num

1209: --
1210: -- {End Of Comments}
1211: --
1212: procedure create_elig_obj_elig_prfl
1213: (p_validate in number default hr_api.g_false_num
1214: ,p_elig_obj_elig_prfl_id in out nocopy number
1215: ,p_effective_start_date out nocopy date
1216: ,p_effective_end_date out nocopy date
1217: ,p_business_group_id in number default null

Line 1247: hr_api.constant_to_boolean

1243: --
1244: -- Convert constant values to their corresponding boolean value
1245: --
1246: l_validate :=
1247: hr_api.constant_to_boolean
1248: (p_constant_value => p_validate);
1249: --
1250: -- Register Surrogate ID or user key values
1251: --

Line 1323: (p_validate in number default hr_api.g_false_num

1319: --
1320: -- {End Of Comments}
1321: --
1322: procedure update_elig_obj_elig_prfl
1323: (p_validate in number default hr_api.g_false_num
1324: ,p_elig_obj_elig_prfl_id in number
1325: ,p_effective_start_date out nocopy date
1326: ,p_effective_end_date out nocopy date
1327: ,p_elig_obj_id in number default hr_api.g_number

Line 1327: ,p_elig_obj_id in number default hr_api.g_number

1323: (p_validate in number default hr_api.g_false_num
1324: ,p_elig_obj_elig_prfl_id in number
1325: ,p_effective_start_date out nocopy date
1326: ,p_effective_end_date out nocopy date
1327: ,p_elig_obj_id in number default hr_api.g_number
1328: ,p_elig_prfl_id in number default hr_api.g_number
1329: ,p_object_version_number in out nocopy number
1330: ,p_effective_date in date
1331: ,p_datetrack_mode in varchar2

Line 1328: ,p_elig_prfl_id in number default hr_api.g_number

1324: ,p_elig_obj_elig_prfl_id in number
1325: ,p_effective_start_date out nocopy date
1326: ,p_effective_end_date out nocopy date
1327: ,p_elig_obj_id in number default hr_api.g_number
1328: ,p_elig_prfl_id in number default hr_api.g_number
1329: ,p_object_version_number in out nocopy number
1330: ,p_effective_date in date
1331: ,p_datetrack_mode in varchar2
1332: ) is

Line 1357: hr_api.constant_to_boolean

1353: --
1354: -- Convert constant values to their corresponding boolean value
1355: --
1356: l_validate :=
1357: hr_api.constant_to_boolean
1358: (p_constant_value => p_validate);
1359: --
1360: -- Register Surrogate ID or user key values
1361: --

Line 1428: (p_validate in number default hr_api.g_false_num

1424: --
1425: -- {End Of Comments}
1426: --
1427: procedure delete_elig_obj_elig_prfl
1428: (p_validate in number default hr_api.g_false_num
1429: ,p_elig_obj_elig_prfl_id in number
1430: ,p_effective_start_date out nocopy date
1431: ,p_effective_end_date out nocopy date
1432: ,p_object_version_number in out nocopy number

Line 1460: hr_api.constant_to_boolean

1456: --
1457: -- Convert constant values to their corresponding boolean value
1458: --
1459: l_validate :=
1460: hr_api.constant_to_boolean
1461: (p_constant_value => p_validate);
1462: --
1463: -- Register Surrogate ID or user key values
1464: --

Line 1530: (p_validate in number default hr_api.g_false_num

1526: --
1527: -- {End Of Comments}
1528: --
1529: procedure create_eligy_grade
1530: (p_validate in number default hr_api.g_false_num
1531: ,p_elig_grd_prte_id in out nocopy number
1532: ,p_effective_start_date out nocopy date
1533: ,p_effective_end_date out nocopy date
1534: ,p_business_group_id in number default null

Line 1566: hr_api.constant_to_boolean

1562: --
1563: -- Convert constant values to their corresponding boolean value
1564: --
1565: l_validate :=
1566: hr_api.constant_to_boolean
1567: (p_constant_value => p_validate);
1568: --
1569: -- Register Surrogate ID or user key values
1570: --

Line 1643: (p_validate in number default hr_api.g_false_num

1639: --
1640: -- {End Of Comments}
1641: --
1642: procedure update_eligy_grade
1643: (p_validate in number default hr_api.g_false_num
1644: ,p_elig_grd_prte_id in number
1645: ,p_effective_start_date out nocopy date
1646: ,p_effective_end_date out nocopy date
1647: ,p_business_group_id in number default hr_api.g_number

Line 1647: ,p_business_group_id in number default hr_api.g_number

1643: (p_validate in number default hr_api.g_false_num
1644: ,p_elig_grd_prte_id in number
1645: ,p_effective_start_date out nocopy date
1646: ,p_effective_end_date out nocopy date
1647: ,p_business_group_id in number default hr_api.g_number
1648: ,p_eligy_prfl_id in number default hr_api.g_number
1649: ,p_grade_id in number default hr_api.g_number
1650: ,p_object_version_number in out nocopy number
1651: ,p_effective_date in date

Line 1648: ,p_eligy_prfl_id in number default hr_api.g_number

1644: ,p_elig_grd_prte_id in number
1645: ,p_effective_start_date out nocopy date
1646: ,p_effective_end_date out nocopy date
1647: ,p_business_group_id in number default hr_api.g_number
1648: ,p_eligy_prfl_id in number default hr_api.g_number
1649: ,p_grade_id in number default hr_api.g_number
1650: ,p_object_version_number in out nocopy number
1651: ,p_effective_date in date
1652: ,p_datetrack_mode in varchar2

Line 1649: ,p_grade_id in number default hr_api.g_number

1645: ,p_effective_start_date out nocopy date
1646: ,p_effective_end_date out nocopy date
1647: ,p_business_group_id in number default hr_api.g_number
1648: ,p_eligy_prfl_id in number default hr_api.g_number
1649: ,p_grade_id in number default hr_api.g_number
1650: ,p_object_version_number in out nocopy number
1651: ,p_effective_date in date
1652: ,p_datetrack_mode in varchar2
1653: ) is

Line 1678: hr_api.constant_to_boolean

1674: --
1675: -- Convert constant values to their corresponding boolean value
1676: --
1677: l_validate :=
1678: hr_api.constant_to_boolean
1679: (p_constant_value => p_validate);
1680: --
1681: -- Register Surrogate ID or user key values
1682: --

Line 1750: (p_validate in number default hr_api.g_false_num

1746: --
1747: -- {End Of Comments}
1748: --
1749: procedure delete_eligy_grade
1750: (p_validate in number default hr_api.g_false_num
1751: ,p_elig_grd_prte_id in number
1752: ,p_effective_start_date out nocopy date
1753: ,p_effective_end_date out nocopy date
1754: ,p_object_version_number in out nocopy number

Line 1782: hr_api.constant_to_boolean

1778: --
1779: -- Convert constant values to their corresponding boolean value
1780: --
1781: l_validate :=
1782: hr_api.constant_to_boolean
1783: (p_constant_value => p_validate);
1784: --
1785: -- Register Surrogate ID or user key values
1786: --

Line 1852: (p_validate in number default hr_api.g_false_num

1848: --
1849: -- {End Of Comments}
1850: --
1851: procedure create_eligy_org
1852: (p_validate in number default hr_api.g_false_num
1853: ,p_elig_org_unit_prte_id in out nocopy number
1854: ,p_effective_start_date out nocopy date
1855: ,p_effective_end_date out nocopy date
1856: ,p_business_group_id in number default null

Line 1887: hr_api.constant_to_boolean

1883: --
1884: -- Convert constant values to their corresponding boolean value
1885: --
1886: l_validate :=
1887: hr_api.constant_to_boolean
1888: (p_constant_value => p_validate);
1889: --
1890: -- Register Surrogate ID or user key values
1891: --

Line 1963: (p_validate in number default hr_api.g_false_num

1959: --
1960: -- {End Of Comments}
1961: --
1962: procedure update_eligy_org
1963: (p_validate in number default hr_api.g_false_num
1964: ,p_elig_org_unit_prte_id in number
1965: ,p_effective_start_date out nocopy date
1966: ,p_effective_end_date out nocopy date
1967: ,p_business_group_id in number default hr_api.g_number

Line 1967: ,p_business_group_id in number default hr_api.g_number

1963: (p_validate in number default hr_api.g_false_num
1964: ,p_elig_org_unit_prte_id in number
1965: ,p_effective_start_date out nocopy date
1966: ,p_effective_end_date out nocopy date
1967: ,p_business_group_id in number default hr_api.g_number
1968: ,p_eligy_prfl_id in number default hr_api.g_number
1969: ,p_organization_id in number default hr_api.g_number
1970: ,p_object_version_number in out nocopy number
1971: ,p_effective_date in date

Line 1968: ,p_eligy_prfl_id in number default hr_api.g_number

1964: ,p_elig_org_unit_prte_id in number
1965: ,p_effective_start_date out nocopy date
1966: ,p_effective_end_date out nocopy date
1967: ,p_business_group_id in number default hr_api.g_number
1968: ,p_eligy_prfl_id in number default hr_api.g_number
1969: ,p_organization_id in number default hr_api.g_number
1970: ,p_object_version_number in out nocopy number
1971: ,p_effective_date in date
1972: ,p_datetrack_mode in varchar2

Line 1969: ,p_organization_id in number default hr_api.g_number

1965: ,p_effective_start_date out nocopy date
1966: ,p_effective_end_date out nocopy date
1967: ,p_business_group_id in number default hr_api.g_number
1968: ,p_eligy_prfl_id in number default hr_api.g_number
1969: ,p_organization_id in number default hr_api.g_number
1970: ,p_object_version_number in out nocopy number
1971: ,p_effective_date in date
1972: ,p_datetrack_mode in varchar2
1973: ) is

Line 1998: hr_api.constant_to_boolean

1994: --
1995: -- Convert constant values to their corresponding boolean value
1996: --
1997: l_validate :=
1998: hr_api.constant_to_boolean
1999: (p_constant_value => p_validate);
2000: --
2001: -- Register Surrogate ID or user key values
2002: --

Line 2070: (p_validate in number default hr_api.g_false_num

2066: --
2067: -- {End Of Comments}
2068: --
2069: procedure delete_eligy_org
2070: (p_validate in number default hr_api.g_false_num
2071: ,p_elig_org_unit_prte_id in number
2072: ,p_effective_start_date out nocopy date
2073: ,p_effective_end_date out nocopy date
2074: ,p_object_version_number in out nocopy number

Line 2102: hr_api.constant_to_boolean

2098: --
2099: -- Convert constant values to their corresponding boolean value
2100: --
2101: l_validate :=
2102: hr_api.constant_to_boolean
2103: (p_constant_value => p_validate);
2104: --
2105: -- Register Surrogate ID or user key values
2106: --

Line 2172: (p_validate in number default hr_api.g_false_num

2168: --
2169: -- {End Of Comments}
2170: --
2171: procedure create_eligy_job
2172: (p_validate in number default hr_api.g_false_num
2173: ,p_elig_job_prte_id in out nocopy number
2174: ,p_effective_start_date out nocopy date
2175: ,p_effective_end_date out nocopy date
2176: ,p_business_group_id in number default null

Line 2207: hr_api.constant_to_boolean

2203: --
2204: -- Convert constant values to their corresponding boolean value
2205: --
2206: l_validate :=
2207: hr_api.constant_to_boolean
2208: (p_constant_value => p_validate);
2209: --
2210: -- Register Surrogate ID or user key values
2211: --

Line 2283: (p_validate in number default hr_api.g_false_num

2279: --
2280: -- {End Of Comments}
2281: --
2282: procedure update_eligy_job
2283: (p_validate in number default hr_api.g_false_num
2284: ,p_elig_job_prte_id in number
2285: ,p_effective_start_date out nocopy date
2286: ,p_effective_end_date out nocopy date
2287: ,p_business_group_id in number default hr_api.g_number

Line 2287: ,p_business_group_id in number default hr_api.g_number

2283: (p_validate in number default hr_api.g_false_num
2284: ,p_elig_job_prte_id in number
2285: ,p_effective_start_date out nocopy date
2286: ,p_effective_end_date out nocopy date
2287: ,p_business_group_id in number default hr_api.g_number
2288: ,p_eligy_prfl_id in number default hr_api.g_number
2289: ,p_job_id in number default hr_api.g_number
2290: ,p_object_version_number in out nocopy number
2291: ,p_effective_date in date

Line 2288: ,p_eligy_prfl_id in number default hr_api.g_number

2284: ,p_elig_job_prte_id in number
2285: ,p_effective_start_date out nocopy date
2286: ,p_effective_end_date out nocopy date
2287: ,p_business_group_id in number default hr_api.g_number
2288: ,p_eligy_prfl_id in number default hr_api.g_number
2289: ,p_job_id in number default hr_api.g_number
2290: ,p_object_version_number in out nocopy number
2291: ,p_effective_date in date
2292: ,p_datetrack_mode in varchar2

Line 2289: ,p_job_id in number default hr_api.g_number

2285: ,p_effective_start_date out nocopy date
2286: ,p_effective_end_date out nocopy date
2287: ,p_business_group_id in number default hr_api.g_number
2288: ,p_eligy_prfl_id in number default hr_api.g_number
2289: ,p_job_id in number default hr_api.g_number
2290: ,p_object_version_number in out nocopy number
2291: ,p_effective_date in date
2292: ,p_datetrack_mode in varchar2
2293: ) is

Line 2318: hr_api.constant_to_boolean

2314: --
2315: -- Convert constant values to their corresponding boolean value
2316: --
2317: l_validate :=
2318: hr_api.constant_to_boolean
2319: (p_constant_value => p_validate);
2320: --
2321: -- Register Surrogate ID or user key values
2322: --

Line 2390: (p_validate in number default hr_api.g_false_num

2386: --
2387: -- {End Of Comments}
2388: --
2389: procedure delete_eligy_job
2390: (p_validate in number default hr_api.g_false_num
2391: ,p_elig_job_prte_id in number
2392: ,p_effective_start_date out nocopy date
2393: ,p_effective_end_date out nocopy date
2394: ,p_object_version_number in out nocopy number

Line 2422: hr_api.constant_to_boolean

2418: --
2419: -- Convert constant values to their corresponding boolean value
2420: --
2421: l_validate :=
2422: hr_api.constant_to_boolean
2423: (p_constant_value => p_validate);
2424: --
2425: -- Register Surrogate ID or user key values
2426: --

Line 2492: (p_validate in number default hr_api.g_false_num

2488: --
2489: -- {End Of Comments}
2490: --
2491: procedure create_eligy_position
2492: (p_validate in number default hr_api.g_false_num
2493: ,p_elig_pstn_prte_id in out nocopy number
2494: ,p_effective_start_date out nocopy date
2495: ,p_effective_end_date out nocopy date
2496: ,p_business_group_id in number default null

Line 2527: hr_api.constant_to_boolean

2523: --
2524: -- Convert constant values to their corresponding boolean value
2525: --
2526: l_validate :=
2527: hr_api.constant_to_boolean
2528: (p_constant_value => p_validate);
2529: --
2530: -- Register Surrogate ID or user key values
2531: --

Line 2603: (p_validate in number default hr_api.g_false_num

2599: --
2600: -- {End Of Comments}
2601: --
2602: procedure update_eligy_position
2603: (p_validate in number default hr_api.g_false_num
2604: ,p_elig_pstn_prte_id in number
2605: ,p_effective_start_date out nocopy date
2606: ,p_effective_end_date out nocopy date
2607: ,p_business_group_id in number default hr_api.g_number

Line 2607: ,p_business_group_id in number default hr_api.g_number

2603: (p_validate in number default hr_api.g_false_num
2604: ,p_elig_pstn_prte_id in number
2605: ,p_effective_start_date out nocopy date
2606: ,p_effective_end_date out nocopy date
2607: ,p_business_group_id in number default hr_api.g_number
2608: ,p_eligy_prfl_id in number default hr_api.g_number
2609: ,p_position_id in number default hr_api.g_number
2610: ,p_object_version_number in out nocopy number
2611: ,p_effective_date in date

Line 2608: ,p_eligy_prfl_id in number default hr_api.g_number

2604: ,p_elig_pstn_prte_id in number
2605: ,p_effective_start_date out nocopy date
2606: ,p_effective_end_date out nocopy date
2607: ,p_business_group_id in number default hr_api.g_number
2608: ,p_eligy_prfl_id in number default hr_api.g_number
2609: ,p_position_id in number default hr_api.g_number
2610: ,p_object_version_number in out nocopy number
2611: ,p_effective_date in date
2612: ,p_datetrack_mode in varchar2

Line 2609: ,p_position_id in number default hr_api.g_number

2605: ,p_effective_start_date out nocopy date
2606: ,p_effective_end_date out nocopy date
2607: ,p_business_group_id in number default hr_api.g_number
2608: ,p_eligy_prfl_id in number default hr_api.g_number
2609: ,p_position_id in number default hr_api.g_number
2610: ,p_object_version_number in out nocopy number
2611: ,p_effective_date in date
2612: ,p_datetrack_mode in varchar2
2613: ) is

Line 2638: hr_api.constant_to_boolean

2634: --
2635: -- Convert constant values to their corresponding boolean value
2636: --
2637: l_validate :=
2638: hr_api.constant_to_boolean
2639: (p_constant_value => p_validate);
2640: --
2641: -- Register Surrogate ID or user key values
2642: --

Line 2710: (p_validate in number default hr_api.g_false_num

2706: --
2707: -- {End Of Comments}
2708: --
2709: procedure delete_eligy_position
2710: (p_validate in number default hr_api.g_false_num
2711: ,p_elig_pstn_prte_id in number
2712: ,p_effective_start_date out nocopy date
2713: ,p_effective_end_date out nocopy date
2714: ,p_object_version_number in out nocopy number

Line 2742: hr_api.constant_to_boolean

2738: --
2739: -- Convert constant values to their corresponding boolean value
2740: --
2741: l_validate :=
2742: hr_api.constant_to_boolean
2743: (p_constant_value => p_validate);
2744: --
2745: -- Register Surrogate ID or user key values
2746: --