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.PQP_VEHICLE_ALLOCATIONS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_vehicle_allocation >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_vehicle_allocation
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_assignment_id in number
15: ,p_business_group_id in number
16: ,p_vehicle_repository_id in number default null

Line 106: hr_api.constant_to_boolean

102: --
103: -- Convert constant values to their corresponding boolean value
104: --
105: l_validate :=
106: hr_api.constant_to_boolean
107: (p_constant_value => p_validate);
108: --
109: -- Register Surrogate ID or user key values
110: --

Line 242: (p_validate in number default hr_api.g_false_num

238: -- ----------------------------------------------------------------------------
239: -- |-----------------------< delete_vehicle_allocation >----------------------|
240: -- ----------------------------------------------------------------------------
241: PROCEDURE delete_vehicle_allocation
242: (p_validate in number default hr_api.g_false_num
243: ,p_effective_date in date
244: ,p_datetrack_mode in varchar2
245: ,p_vehicle_allocation_id in number
246: ,p_object_version_number in out nocopy number

Line 278: hr_api.constant_to_boolean

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

Line 353: (p_validate in number default hr_api.g_false_num

349: -- ----------------------------------------------------------------------------
350: -- |-----------------------< update_vehicle_allocation >----------------------|
351: -- ----------------------------------------------------------------------------
352: PROCEDURE update_vehicle_allocation
353: (p_validate in number default hr_api.g_false_num
354: ,p_effective_date in date
355: ,p_datetrack_mode in varchar2
356: ,p_vehicle_allocation_id in number
357: ,p_object_version_number in out nocopy number

Line 358: ,p_assignment_id in number default hr_api.g_number

354: ,p_effective_date in date
355: ,p_datetrack_mode in varchar2
356: ,p_vehicle_allocation_id in number
357: ,p_object_version_number in out nocopy number
358: ,p_assignment_id in number default hr_api.g_number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2

Line 359: ,p_business_group_id in number default hr_api.g_number

355: ,p_datetrack_mode in varchar2
356: ,p_vehicle_allocation_id in number
357: ,p_object_version_number in out nocopy number
358: ,p_assignment_id in number default hr_api.g_number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number

Line 360: ,p_vehicle_repository_id in number default hr_api.g_number

356: ,p_vehicle_allocation_id in number
357: ,p_object_version_number in out nocopy number
358: ,p_assignment_id in number default hr_api.g_number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number

Line 361: ,p_across_assignments in varchar2 default hr_api.g_varchar2

357: ,p_object_version_number in out nocopy number
358: ,p_assignment_id in number default hr_api.g_number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2

Line 362: ,p_usage_type in varchar2 default hr_api.g_varchar2

358: ,p_assignment_id in number default hr_api.g_number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2

Line 363: ,p_capital_contribution in number default hr_api.g_number

359: ,p_business_group_id in number default hr_api.g_number
360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2

Line 364: ,p_private_contribution in number default hr_api.g_number

360: ,p_vehicle_repository_id in number default hr_api.g_number
361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2

Line 365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2

361: ,p_across_assignments in varchar2 default hr_api.g_varchar2
362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number

Line 366: ,p_fuel_card in varchar2 default hr_api.g_varchar2

362: ,p_usage_type in varchar2 default hr_api.g_varchar2
363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number

Line 367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2

363: ,p_capital_contribution in number default hr_api.g_number
364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2

Line 368: ,p_calculation_method in varchar2 default hr_api.g_varchar2

364: ,p_private_contribution in number default hr_api.g_number
365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2

Line 369: ,p_rates_table_id in number default hr_api.g_number

365: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date

Line 370: ,p_element_type_id in number default hr_api.g_number

366: ,p_fuel_card in varchar2 default hr_api.g_varchar2
367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2

Line 371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2

367: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2

Line 372: ,p_insurance_number in varchar2 default hr_api.g_varchar2

368: ,p_calculation_method in varchar2 default hr_api.g_varchar2
369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2

Line 373: ,p_insurance_expiry_date in date default hr_api.g_date

369: ,p_rates_table_id in number default hr_api.g_number
370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2

Line 374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2

370: ,p_element_type_id in number default hr_api.g_number
371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2

Line 375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2

371: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2

Line 376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2

372: ,p_insurance_number in varchar2 default hr_api.g_varchar2
373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2

Line 377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2

373: ,p_insurance_expiry_date in date default hr_api.g_date
374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2

Line 378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2

374: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2

Line 379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2

375: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2

Line 380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2

376: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2

Line 381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2

377: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2

Line 382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2

378: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2

Line 383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2

379: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2

Line 384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2

380: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2

Line 385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2

381: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2

Line 386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2

382: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2

Line 387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2

383: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2

Line 388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2

384: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2

Line 389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2

385: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2

Line 390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2

386: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2

Line 391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2

387: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2

Line 392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2

388: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2

Line 393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2

389: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2

Line 394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2

390: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2

Line 395: ,p_val_information_category in varchar2 default hr_api.g_varchar2

391: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2

Line 396: ,p_val_information1 in varchar2 default hr_api.g_varchar2

392: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2

Line 397: ,p_val_information2 in varchar2 default hr_api.g_varchar2

393: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2

Line 398: ,p_val_information3 in varchar2 default hr_api.g_varchar2

394: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2

Line 399: ,p_val_information4 in varchar2 default hr_api.g_varchar2

395: ,p_val_information_category in varchar2 default hr_api.g_varchar2
396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2

Line 400: ,p_val_information5 in varchar2 default hr_api.g_varchar2

396: ,p_val_information1 in varchar2 default hr_api.g_varchar2
397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2

Line 401: ,p_val_information6 in varchar2 default hr_api.g_varchar2

397: ,p_val_information2 in varchar2 default hr_api.g_varchar2
398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2

Line 402: ,p_val_information7 in varchar2 default hr_api.g_varchar2

398: ,p_val_information3 in varchar2 default hr_api.g_varchar2
399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2

Line 403: ,p_val_information8 in varchar2 default hr_api.g_varchar2

399: ,p_val_information4 in varchar2 default hr_api.g_varchar2
400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2

Line 404: ,p_val_information9 in varchar2 default hr_api.g_varchar2

400: ,p_val_information5 in varchar2 default hr_api.g_varchar2
401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2

Line 405: ,p_val_information10 in varchar2 default hr_api.g_varchar2

401: ,p_val_information6 in varchar2 default hr_api.g_varchar2
402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2

Line 406: ,p_val_information11 in varchar2 default hr_api.g_varchar2

402: ,p_val_information7 in varchar2 default hr_api.g_varchar2
403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2

Line 407: ,p_val_information12 in varchar2 default hr_api.g_varchar2

403: ,p_val_information8 in varchar2 default hr_api.g_varchar2
404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2

Line 408: ,p_val_information13 in varchar2 default hr_api.g_varchar2

404: ,p_val_information9 in varchar2 default hr_api.g_varchar2
405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2

Line 409: ,p_val_information14 in varchar2 default hr_api.g_varchar2

405: ,p_val_information10 in varchar2 default hr_api.g_varchar2
406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2

Line 410: ,p_val_information15 in varchar2 default hr_api.g_varchar2

406: ,p_val_information11 in varchar2 default hr_api.g_varchar2
407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2

Line 411: ,p_val_information16 in varchar2 default hr_api.g_varchar2

407: ,p_val_information12 in varchar2 default hr_api.g_varchar2
408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2

Line 412: ,p_val_information17 in varchar2 default hr_api.g_varchar2

408: ,p_val_information13 in varchar2 default hr_api.g_varchar2
409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2
416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2

Line 413: ,p_val_information18 in varchar2 default hr_api.g_varchar2

409: ,p_val_information14 in varchar2 default hr_api.g_varchar2
410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2
416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
417: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2

Line 414: ,p_val_information19 in varchar2 default hr_api.g_varchar2

410: ,p_val_information15 in varchar2 default hr_api.g_varchar2
411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2
416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
417: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
418: ,p_effective_start_date out nocopy date

Line 415: ,p_val_information20 in varchar2 default hr_api.g_varchar2

411: ,p_val_information16 in varchar2 default hr_api.g_varchar2
412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2
416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
417: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
418: ,p_effective_start_date out nocopy date
419: ,p_effective_end_date out nocopy date

Line 416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2

412: ,p_val_information17 in varchar2 default hr_api.g_varchar2
413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2
416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
417: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
418: ,p_effective_start_date out nocopy date
419: ,p_effective_end_date out nocopy date
420: ,p_return_status out nocopy varchar2

Line 417: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2

413: ,p_val_information18 in varchar2 default hr_api.g_varchar2
414: ,p_val_information19 in varchar2 default hr_api.g_varchar2
415: ,p_val_information20 in varchar2 default hr_api.g_varchar2
416: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
417: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
418: ,p_effective_start_date out nocopy date
419: ,p_effective_end_date out nocopy date
420: ,p_return_status out nocopy varchar2
421: ) is

Line 449: hr_api.constant_to_boolean

445: --
446: -- Convert constant values to their corresponding boolean value
447: --
448: l_validate :=
449: hr_api.constant_to_boolean
450: (p_constant_value => p_validate);
451: --
452: -- Register Surrogate ID or user key values
453: --