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 28: (p_validate in number default hr_api.g_false_num

24: -- ----------------------------------------------------------------------------
25: -- |-----------------------< create_vehicle_allocation >----------------------|
26: -- ----------------------------------------------------------------------------
27: PROCEDURE create_vehicle_allocation
28: (p_validate in number default hr_api.g_false_num
29: ,p_effective_date in date
30: ,p_assignment_id in number
31: ,p_business_group_id in number
32: ,p_vehicle_repository_id in number default null

Line 122: hr_api.constant_to_boolean

118: --
119: -- Convert constant values to their corresponding boolean value
120: --
121: l_validate :=
122: hr_api.constant_to_boolean
123: (p_constant_value => p_validate);
124: --
125: -- Register Surrogate ID or user key values
126: --

Line 269: (p_validate in number default hr_api.g_false_num

265: -- ----------------------------------------------------------------------------
266: -- |-----------------------< delete_vehicle_allocation >----------------------|
267: -- ----------------------------------------------------------------------------
268: PROCEDURE delete_vehicle_allocation
269: (p_validate in number default hr_api.g_false_num
270: ,p_effective_date in date
271: ,p_datetrack_mode in varchar2
272: ,p_vehicle_allocation_id in number
273: ,p_object_version_number in out nocopy number

Line 305: hr_api.constant_to_boolean

301: --
302: -- Convert constant values to their corresponding boolean value
303: --
304: l_validate :=
305: hr_api.constant_to_boolean
306: (p_constant_value => p_validate);
307: --
308: -- Register Surrogate ID or user key values
309: --

Line 380: (p_validate in number default hr_api.g_false_num

376: -- ----------------------------------------------------------------------------
377: -- |-----------------------< update_vehicle_allocation >----------------------|
378: -- ----------------------------------------------------------------------------
379: PROCEDURE update_vehicle_allocation
380: (p_validate in number default hr_api.g_false_num
381: ,p_effective_date in date
382: ,p_datetrack_mode in varchar2
383: ,p_vehicle_allocation_id in number
384: ,p_object_version_number in out nocopy number

Line 385: ,p_assignment_id in number default hr_api.g_number

381: ,p_effective_date in date
382: ,p_datetrack_mode in varchar2
383: ,p_vehicle_allocation_id in number
384: ,p_object_version_number in out nocopy number
385: ,p_assignment_id in number default hr_api.g_number
386: ,p_business_group_id in number default hr_api.g_number
387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2

Line 386: ,p_business_group_id in number default hr_api.g_number

382: ,p_datetrack_mode in varchar2
383: ,p_vehicle_allocation_id in number
384: ,p_object_version_number in out nocopy number
385: ,p_assignment_id in number default hr_api.g_number
386: ,p_business_group_id in number default hr_api.g_number
387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number

Line 387: ,p_vehicle_repository_id in number default hr_api.g_number

383: ,p_vehicle_allocation_id in number
384: ,p_object_version_number in out nocopy number
385: ,p_assignment_id in number default hr_api.g_number
386: ,p_business_group_id in number default hr_api.g_number
387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number

Line 388: ,p_across_assignments in varchar2 default hr_api.g_varchar2

384: ,p_object_version_number in out nocopy number
385: ,p_assignment_id in number default hr_api.g_number
386: ,p_business_group_id in number default hr_api.g_number
387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2

Line 389: ,p_usage_type in varchar2 default hr_api.g_varchar2

385: ,p_assignment_id in number default hr_api.g_number
386: ,p_business_group_id in number default hr_api.g_number
387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2

Line 390: ,p_capital_contribution in number default hr_api.g_number

386: ,p_business_group_id in number default hr_api.g_number
387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2

Line 391: ,p_private_contribution in number default hr_api.g_number

387: ,p_vehicle_repository_id in number default hr_api.g_number
388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2

Line 392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2

388: ,p_across_assignments in varchar2 default hr_api.g_varchar2
389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number

Line 393: ,p_fuel_card in varchar2 default hr_api.g_varchar2

389: ,p_usage_type in varchar2 default hr_api.g_varchar2
390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number

Line 394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2

390: ,p_capital_contribution in number default hr_api.g_number
391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2

Line 395: ,p_calculation_method in varchar2 default hr_api.g_varchar2

391: ,p_private_contribution in number default hr_api.g_number
392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2

Line 396: ,p_rates_table_id in number default hr_api.g_number

392: ,p_default_vehicle in varchar2 default hr_api.g_varchar2
393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date

Line 397: ,p_element_type_id in number default hr_api.g_number

393: ,p_fuel_card in varchar2 default hr_api.g_varchar2
394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2

Line 398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2

394: ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2

Line 399: ,p_insurance_number in varchar2 default hr_api.g_varchar2

395: ,p_calculation_method in varchar2 default hr_api.g_varchar2
396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2

Line 400: ,p_insurance_expiry_date in date default hr_api.g_date

396: ,p_rates_table_id in number default hr_api.g_number
397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2

Line 401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2

397: ,p_element_type_id in number default hr_api.g_number
398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2

Line 402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2

398: ,p_private_use_flag in varchar2 default hr_api.g_varchar2
399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2

Line 403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2

399: ,p_insurance_number in varchar2 default hr_api.g_varchar2
400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2

Line 404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2

400: ,p_insurance_expiry_date in date default hr_api.g_date
401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2

Line 405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2

401: ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2

Line 406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2

402: ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2

Line 407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2

403: ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2

Line 408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2

404: ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2

Line 409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2

405: ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2

Line 410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2

406: ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2

Line 411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2

407: ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2

Line 412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2

408: ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2

Line 413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2

409: ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2

Line 414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2

410: ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2

Line 415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2

411: ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2

Line 416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2

412: ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2

Line 417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2

413: ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2

Line 418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2

414: ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2

Line 419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2

415: ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2

Line 420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2

416: ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2

Line 421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2

417: ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2

Line 422: ,p_val_information_category in varchar2 default hr_api.g_varchar2

418: ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2

Line 423: ,p_val_information1 in varchar2 default hr_api.g_varchar2

419: ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2

Line 424: ,p_val_information2 in varchar2 default hr_api.g_varchar2

420: ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2

Line 425: ,p_val_information3 in varchar2 default hr_api.g_varchar2

421: ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2

Line 426: ,p_val_information4 in varchar2 default hr_api.g_varchar2

422: ,p_val_information_category in varchar2 default hr_api.g_varchar2
423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2

Line 427: ,p_val_information5 in varchar2 default hr_api.g_varchar2

423: ,p_val_information1 in varchar2 default hr_api.g_varchar2
424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2

Line 428: ,p_val_information6 in varchar2 default hr_api.g_varchar2

424: ,p_val_information2 in varchar2 default hr_api.g_varchar2
425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2

Line 429: ,p_val_information7 in varchar2 default hr_api.g_varchar2

425: ,p_val_information3 in varchar2 default hr_api.g_varchar2
426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2

Line 430: ,p_val_information8 in varchar2 default hr_api.g_varchar2

426: ,p_val_information4 in varchar2 default hr_api.g_varchar2
427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2

Line 431: ,p_val_information9 in varchar2 default hr_api.g_varchar2

427: ,p_val_information5 in varchar2 default hr_api.g_varchar2
428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2

Line 432: ,p_val_information10 in varchar2 default hr_api.g_varchar2

428: ,p_val_information6 in varchar2 default hr_api.g_varchar2
429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2

Line 433: ,p_val_information11 in varchar2 default hr_api.g_varchar2

429: ,p_val_information7 in varchar2 default hr_api.g_varchar2
430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2

Line 434: ,p_val_information12 in varchar2 default hr_api.g_varchar2

430: ,p_val_information8 in varchar2 default hr_api.g_varchar2
431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2

Line 435: ,p_val_information13 in varchar2 default hr_api.g_varchar2

431: ,p_val_information9 in varchar2 default hr_api.g_varchar2
432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2

Line 436: ,p_val_information14 in varchar2 default hr_api.g_varchar2

432: ,p_val_information10 in varchar2 default hr_api.g_varchar2
433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2

Line 437: ,p_val_information15 in varchar2 default hr_api.g_varchar2

433: ,p_val_information11 in varchar2 default hr_api.g_varchar2
434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2

Line 438: ,p_val_information16 in varchar2 default hr_api.g_varchar2

434: ,p_val_information12 in varchar2 default hr_api.g_varchar2
435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2

Line 439: ,p_val_information17 in varchar2 default hr_api.g_varchar2

435: ,p_val_information13 in varchar2 default hr_api.g_varchar2
436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2
443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2

Line 440: ,p_val_information18 in varchar2 default hr_api.g_varchar2

436: ,p_val_information14 in varchar2 default hr_api.g_varchar2
437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2
443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
444: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2

Line 441: ,p_val_information19 in varchar2 default hr_api.g_varchar2

437: ,p_val_information15 in varchar2 default hr_api.g_varchar2
438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2
443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
444: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
445: ,p_effective_start_date out nocopy date

Line 442: ,p_val_information20 in varchar2 default hr_api.g_varchar2

438: ,p_val_information16 in varchar2 default hr_api.g_varchar2
439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2
443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
444: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
445: ,p_effective_start_date out nocopy date
446: ,p_effective_end_date out nocopy date

Line 443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2

439: ,p_val_information17 in varchar2 default hr_api.g_varchar2
440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2
443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
444: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
445: ,p_effective_start_date out nocopy date
446: ,p_effective_end_date out nocopy date
447: ,p_return_status out nocopy varchar2

Line 444: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2

440: ,p_val_information18 in varchar2 default hr_api.g_varchar2
441: ,p_val_information19 in varchar2 default hr_api.g_varchar2
442: ,p_val_information20 in varchar2 default hr_api.g_varchar2
443: ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
444: ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
445: ,p_effective_start_date out nocopy date
446: ,p_effective_end_date out nocopy date
447: ,p_return_status out nocopy varchar2
448: ) is

Line 476: hr_api.constant_to_boolean

472: --
473: -- Convert constant values to their corresponding boolean value
474: --
475: l_validate :=
476: hr_api.constant_to_boolean
477: (p_constant_value => p_validate);
478: --
479: -- Register Surrogate ID or user key values
480: --