[Home] [Help]
291: csr ref_cursor;
292: BEGIN
293: OPEN csr FOR
294: SELECT Vehtrn.*,lkp.meaning vehicletype from (SELECT
295: hr_transaction_api.get_number_Value
296: ( p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
297: ,hr_transaction_api.get_number_Value
298: ( p_transaction_step_id, 'P_PERSON_ID' ) person_id
299: ,hr_transaction_api.get_number_Value
293: OPEN csr FOR
294: SELECT Vehtrn.*,lkp.meaning vehicletype from (SELECT
295: hr_transaction_api.get_number_Value
296: ( p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
297: ,hr_transaction_api.get_number_Value
298: ( p_transaction_step_id, 'P_PERSON_ID' ) person_id
299: ,hr_transaction_api.get_number_Value
300: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
301: ,hr_transaction_api.get_date_Value
295: hr_transaction_api.get_number_Value
296: ( p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
297: ,hr_transaction_api.get_number_Value
298: ( p_transaction_step_id, 'P_PERSON_ID' ) person_id
299: ,hr_transaction_api.get_number_Value
300: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
301: ,hr_transaction_api.get_date_Value
302: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
303: ,hr_transaction_api.get_number_Value
297: ,hr_transaction_api.get_number_Value
298: ( p_transaction_step_id, 'P_PERSON_ID' ) person_id
299: ,hr_transaction_api.get_number_Value
300: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
301: ,hr_transaction_api.get_date_Value
302: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
303: ,hr_transaction_api.get_number_Value
304: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
305: ,hr_transaction_api.get_number_Value
299: ,hr_transaction_api.get_number_Value
300: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
301: ,hr_transaction_api.get_date_Value
302: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
303: ,hr_transaction_api.get_number_Value
304: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
305: ,hr_transaction_api.get_number_Value
306: (p_transaction_step_id, 'P_item_key') item_key
307: ,hr_transaction_api.get_number_Value
301: ,hr_transaction_api.get_date_Value
302: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
303: ,hr_transaction_api.get_number_Value
304: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
305: ,hr_transaction_api.get_number_Value
306: (p_transaction_step_id, 'P_item_key') item_key
307: ,hr_transaction_api.get_number_Value
308: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
309: ,hr_transaction_api.get_varchar2_Value
303: ,hr_transaction_api.get_number_Value
304: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
305: ,hr_transaction_api.get_number_Value
306: (p_transaction_step_id, 'P_item_key') item_key
307: ,hr_transaction_api.get_number_Value
308: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
309: ,hr_transaction_api.get_varchar2_Value
310: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
311: ,hr_transaction_api.get_varchar2_Value
305: ,hr_transaction_api.get_number_Value
306: (p_transaction_step_id, 'P_item_key') item_key
307: ,hr_transaction_api.get_number_Value
308: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
309: ,hr_transaction_api.get_varchar2_Value
310: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
311: ,hr_transaction_api.get_varchar2_Value
312: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
313: ,hr_transaction_api.get_varchar2_Value
307: ,hr_transaction_api.get_number_Value
308: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
309: ,hr_transaction_api.get_varchar2_Value
310: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
311: ,hr_transaction_api.get_varchar2_Value
312: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
313: ,hr_transaction_api.get_varchar2_Value
314: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
315: ,hr_transaction_api.get_varchar2_Value
309: ,hr_transaction_api.get_varchar2_Value
310: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
311: ,hr_transaction_api.get_varchar2_Value
312: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
313: ,hr_transaction_api.get_varchar2_Value
314: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
315: ,hr_transaction_api.get_varchar2_Value
316: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
317: ,hr_transaction_api.get_number_Value
311: ,hr_transaction_api.get_varchar2_Value
312: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
313: ,hr_transaction_api.get_varchar2_Value
314: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
315: ,hr_transaction_api.get_varchar2_Value
316: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
317: ,hr_transaction_api.get_number_Value
318: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
319: ,hr_transaction_api.get_varchar2_Value
313: ,hr_transaction_api.get_varchar2_Value
314: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
315: ,hr_transaction_api.get_varchar2_Value
316: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
317: ,hr_transaction_api.get_number_Value
318: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
319: ,hr_transaction_api.get_varchar2_Value
320: (p_transaction_step_id, 'P_MAKE') make
321: ,hr_transaction_api.get_number_Value
315: ,hr_transaction_api.get_varchar2_Value
316: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
317: ,hr_transaction_api.get_number_Value
318: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
319: ,hr_transaction_api.get_varchar2_Value
320: (p_transaction_step_id, 'P_MAKE') make
321: ,hr_transaction_api.get_number_Value
322: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
323: , hr_transaction_api.get_number_Value
317: ,hr_transaction_api.get_number_Value
318: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
319: ,hr_transaction_api.get_varchar2_Value
320: (p_transaction_step_id, 'P_MAKE') make
321: ,hr_transaction_api.get_number_Value
322: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
323: , hr_transaction_api.get_number_Value
324: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
325: ,hr_transaction_api.get_varchar2_Value
319: ,hr_transaction_api.get_varchar2_Value
320: (p_transaction_step_id, 'P_MAKE') make
321: ,hr_transaction_api.get_number_Value
322: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
323: , hr_transaction_api.get_number_Value
324: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
325: ,hr_transaction_api.get_varchar2_Value
326: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
327: ,hr_transaction_api.get_date_Value
321: ,hr_transaction_api.get_number_Value
322: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
323: , hr_transaction_api.get_number_Value
324: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
325: ,hr_transaction_api.get_varchar2_Value
326: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
327: ,hr_transaction_api.get_date_Value
328: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
329: ,hr_transaction_api.get_varchar2_Value
323: , hr_transaction_api.get_number_Value
324: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
325: ,hr_transaction_api.get_varchar2_Value
326: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
327: ,hr_transaction_api.get_date_Value
328: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
329: ,hr_transaction_api.get_varchar2_Value
330: (p_transaction_step_id, 'P_MODEL' ) model
331: ,hr_transaction_api.get_number_value
325: ,hr_transaction_api.get_varchar2_Value
326: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
327: ,hr_transaction_api.get_date_Value
328: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
329: ,hr_transaction_api.get_varchar2_Value
330: (p_transaction_step_id, 'P_MODEL' ) model
331: ,hr_transaction_api.get_number_value
332: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
333: ,hr_transaction_api.get_number_Value
327: ,hr_transaction_api.get_date_Value
328: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
329: ,hr_transaction_api.get_varchar2_Value
330: (p_transaction_step_id, 'P_MODEL' ) model
331: ,hr_transaction_api.get_number_value
332: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
333: ,hr_transaction_api.get_number_Value
334: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
335: FROM DUAL) Vehtrn
329: ,hr_transaction_api.get_varchar2_Value
330: (p_transaction_step_id, 'P_MODEL' ) model
331: ,hr_transaction_api.get_number_value
332: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
333: ,hr_transaction_api.get_number_Value
334: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
335: FROM DUAL) Vehtrn
336: ,hr_lookups lkp
337: WHERE vehtrn.vehicle_type=lkp.lookup_code
391: csr ref_cursor;
392: BEGIN
393: OPEN csr FOR
394: SELECT
395: hr_transaction_api.get_number_Value
396: (p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
397: ,hr_transaction_api.get_number_Value
398: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
399: ,hr_transaction_api.get_number_Value
393: OPEN csr FOR
394: SELECT
395: hr_transaction_api.get_number_Value
396: (p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
397: ,hr_transaction_api.get_number_Value
398: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
399: ,hr_transaction_api.get_number_Value
400: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
401: ,hr_transaction_api.get_date_Value
395: hr_transaction_api.get_number_Value
396: (p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
397: ,hr_transaction_api.get_number_Value
398: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
399: ,hr_transaction_api.get_number_Value
400: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
401: ,hr_transaction_api.get_date_Value
402: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
403: ,hr_transaction_api.get_number_Value
397: ,hr_transaction_api.get_number_Value
398: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
399: ,hr_transaction_api.get_number_Value
400: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
401: ,hr_transaction_api.get_date_Value
402: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
403: ,hr_transaction_api.get_number_Value
404: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
405: ,hr_transaction_api.get_number_Value
399: ,hr_transaction_api.get_number_Value
400: (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
401: ,hr_transaction_api.get_date_Value
402: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
403: ,hr_transaction_api.get_number_Value
404: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
405: ,hr_transaction_api.get_number_Value
406: (p_transaction_step_id, 'P_item_key') item_key
407: ,hr_transaction_api.get_number_Value
401: ,hr_transaction_api.get_date_Value
402: (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
403: ,hr_transaction_api.get_number_Value
404: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
405: ,hr_transaction_api.get_number_Value
406: (p_transaction_step_id, 'P_item_key') item_key
407: ,hr_transaction_api.get_number_Value
408: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
409: ,hr_transaction_api.get_varchar2_Value
403: ,hr_transaction_api.get_number_Value
404: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
405: ,hr_transaction_api.get_number_Value
406: (p_transaction_step_id, 'P_item_key') item_key
407: ,hr_transaction_api.get_number_Value
408: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
409: ,hr_transaction_api.get_varchar2_Value
410: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
411: ,hr_transaction_api.get_varchar2_Value
405: ,hr_transaction_api.get_number_Value
406: (p_transaction_step_id, 'P_item_key') item_key
407: ,hr_transaction_api.get_number_Value
408: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
409: ,hr_transaction_api.get_varchar2_Value
410: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
411: ,hr_transaction_api.get_varchar2_Value
412: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
413: ,hr_transaction_api.get_varchar2_Value
407: ,hr_transaction_api.get_number_Value
408: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
409: ,hr_transaction_api.get_varchar2_Value
410: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
411: ,hr_transaction_api.get_varchar2_Value
412: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
413: ,hr_transaction_api.get_varchar2_Value
414: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
415: ,hr_transaction_api.get_varchar2_Value
409: ,hr_transaction_api.get_varchar2_Value
410: (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
411: ,hr_transaction_api.get_varchar2_Value
412: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
413: ,hr_transaction_api.get_varchar2_Value
414: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
415: ,hr_transaction_api.get_varchar2_Value
416: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
417: ,hr_transaction_api.get_number_Value
411: ,hr_transaction_api.get_varchar2_Value
412: (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
413: ,hr_transaction_api.get_varchar2_Value
414: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
415: ,hr_transaction_api.get_varchar2_Value
416: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
417: ,hr_transaction_api.get_number_Value
418: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
419: ,hr_transaction_api.get_varchar2_Value
413: ,hr_transaction_api.get_varchar2_Value
414: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
415: ,hr_transaction_api.get_varchar2_Value
416: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
417: ,hr_transaction_api.get_number_Value
418: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
419: ,hr_transaction_api.get_varchar2_Value
420: (p_transaction_step_id, 'P_MAKE') make
421: ,hr_transaction_api.get_number_Value
415: ,hr_transaction_api.get_varchar2_Value
416: (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
417: ,hr_transaction_api.get_number_Value
418: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
419: ,hr_transaction_api.get_varchar2_Value
420: (p_transaction_step_id, 'P_MAKE') make
421: ,hr_transaction_api.get_number_Value
422: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
423: , hr_transaction_api.get_number_Value
417: ,hr_transaction_api.get_number_Value
418: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
419: ,hr_transaction_api.get_varchar2_Value
420: (p_transaction_step_id, 'P_MAKE') make
421: ,hr_transaction_api.get_number_Value
422: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
423: , hr_transaction_api.get_number_Value
424: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
425: ,hr_transaction_api.get_varchar2_Value
419: ,hr_transaction_api.get_varchar2_Value
420: (p_transaction_step_id, 'P_MAKE') make
421: ,hr_transaction_api.get_number_Value
422: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
423: , hr_transaction_api.get_number_Value
424: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
425: ,hr_transaction_api.get_varchar2_Value
426: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
427: ,hr_transaction_api.get_date_Value
421: ,hr_transaction_api.get_number_Value
422: (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
423: , hr_transaction_api.get_number_Value
424: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
425: ,hr_transaction_api.get_varchar2_Value
426: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
427: ,hr_transaction_api.get_date_Value
428: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
429: ,hr_transaction_api.get_varchar2_Value
423: , hr_transaction_api.get_number_Value
424: (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
425: ,hr_transaction_api.get_varchar2_Value
426: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
427: ,hr_transaction_api.get_date_Value
428: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
429: ,hr_transaction_api.get_varchar2_Value
430: (p_transaction_step_id, 'P_MODEL' ) model
431: ,hr_transaction_api.get_varchar2_Value
425: ,hr_transaction_api.get_varchar2_Value
426: (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
427: ,hr_transaction_api.get_date_Value
428: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
429: ,hr_transaction_api.get_varchar2_Value
430: (p_transaction_step_id, 'P_MODEL' ) model
431: ,hr_transaction_api.get_varchar2_Value
432: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
433: ,hr_transaction_api.get_number_Value
427: ,hr_transaction_api.get_date_Value
428: (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
429: ,hr_transaction_api.get_varchar2_Value
430: (p_transaction_step_id, 'P_MODEL' ) model
431: ,hr_transaction_api.get_varchar2_Value
432: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
433: ,hr_transaction_api.get_number_Value
434: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
435: ,hr_transaction_api.get_number_Value
429: ,hr_transaction_api.get_varchar2_Value
430: (p_transaction_step_id, 'P_MODEL' ) model
431: ,hr_transaction_api.get_varchar2_Value
432: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
433: ,hr_transaction_api.get_number_Value
434: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
435: ,hr_transaction_api.get_number_Value
436: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
437: ,hr_transaction_api.get_varchar2_Value
431: ,hr_transaction_api.get_varchar2_Value
432: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
433: ,hr_transaction_api.get_number_Value
434: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
435: ,hr_transaction_api.get_number_Value
436: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
437: ,hr_transaction_api.get_varchar2_Value
438: (p_transaction_step_id, 'P_CURRENCY_CODE') currency_code
439: ,hr_transaction_api.get_date_Value
433: ,hr_transaction_api.get_number_Value
434: (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
435: ,hr_transaction_api.get_number_Value
436: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
437: ,hr_transaction_api.get_varchar2_Value
438: (p_transaction_step_id, 'P_CURRENCY_CODE') currency_code
439: ,hr_transaction_api.get_date_Value
440: (p_transaction_step_id, 'P_INITIAL_REGISTRATION') initial_registration
441: ,hr_transaction_api.get_date_Value
435: ,hr_transaction_api.get_number_Value
436: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
437: ,hr_transaction_api.get_varchar2_Value
438: (p_transaction_step_id, 'P_CURRENCY_CODE') currency_code
439: ,hr_transaction_api.get_date_Value
440: (p_transaction_step_id, 'P_INITIAL_REGISTRATION') initial_registration
441: ,hr_transaction_api.get_date_Value
442: (p_transaction_step_id, 'P_LAST_REGISTRATION_RENEW_DATE' )
443: last_registration_renew_date
437: ,hr_transaction_api.get_varchar2_Value
438: (p_transaction_step_id, 'P_CURRENCY_CODE') currency_code
439: ,hr_transaction_api.get_date_Value
440: (p_transaction_step_id, 'P_INITIAL_REGISTRATION') initial_registration
441: ,hr_transaction_api.get_date_Value
442: (p_transaction_step_id, 'P_LAST_REGISTRATION_RENEW_DATE' )
443: last_registration_renew_date
444: ,hr_transaction_api.get_number_Value
445: (p_transaction_step_id, 'P_FISCAL_RATINGS' ) fiscal_ratings
440: (p_transaction_step_id, 'P_INITIAL_REGISTRATION') initial_registration
441: ,hr_transaction_api.get_date_Value
442: (p_transaction_step_id, 'P_LAST_REGISTRATION_RENEW_DATE' )
443: last_registration_renew_date
444: ,hr_transaction_api.get_number_Value
445: (p_transaction_step_id, 'P_FISCAL_RATINGS' ) fiscal_ratings
446: ,hr_transaction_api.get_varchar2_Value
447: (p_transaction_step_id, 'P_SHARED_VEHICLE' ) shared_vehicle
448: ,hr_transaction_api.get_varchar2_Value
442: (p_transaction_step_id, 'P_LAST_REGISTRATION_RENEW_DATE' )
443: last_registration_renew_date
444: ,hr_transaction_api.get_number_Value
445: (p_transaction_step_id, 'P_FISCAL_RATINGS' ) fiscal_ratings
446: ,hr_transaction_api.get_varchar2_Value
447: (p_transaction_step_id, 'P_SHARED_VEHICLE' ) shared_vehicle
448: ,hr_transaction_api.get_varchar2_Value
449: (p_transaction_step_id, 'P_COLOR' ) color
450: ,hr_transaction_api.get_number_Value
444: ,hr_transaction_api.get_number_Value
445: (p_transaction_step_id, 'P_FISCAL_RATINGS' ) fiscal_ratings
446: ,hr_transaction_api.get_varchar2_Value
447: (p_transaction_step_id, 'P_SHARED_VEHICLE' ) shared_vehicle
448: ,hr_transaction_api.get_varchar2_Value
449: (p_transaction_step_id, 'P_COLOR' ) color
450: ,hr_transaction_api.get_number_Value
451: (p_transaction_step_id, 'P_SEATING_CAPACITY' ) seating_capacity
452: ,hr_transaction_api.get_number_Value
446: ,hr_transaction_api.get_varchar2_Value
447: (p_transaction_step_id, 'P_SHARED_VEHICLE' ) shared_vehicle
448: ,hr_transaction_api.get_varchar2_Value
449: (p_transaction_step_id, 'P_COLOR' ) color
450: ,hr_transaction_api.get_number_Value
451: (p_transaction_step_id, 'P_SEATING_CAPACITY' ) seating_capacity
452: ,hr_transaction_api.get_number_Value
453: (p_transaction_step_id, 'P_WEIGHT' ) weight
454: ,hr_transaction_api.get_varchar2_Value
448: ,hr_transaction_api.get_varchar2_Value
449: (p_transaction_step_id, 'P_COLOR' ) color
450: ,hr_transaction_api.get_number_Value
451: (p_transaction_step_id, 'P_SEATING_CAPACITY' ) seating_capacity
452: ,hr_transaction_api.get_number_Value
453: (p_transaction_step_id, 'P_WEIGHT' ) weight
454: ,hr_transaction_api.get_varchar2_Value
455: (p_transaction_step_id, 'P_WEIGHT_UOM' ) weight_uom
456: ,hr_transaction_api.get_varchar2_Value
450: ,hr_transaction_api.get_number_Value
451: (p_transaction_step_id, 'P_SEATING_CAPACITY' ) seating_capacity
452: ,hr_transaction_api.get_number_Value
453: (p_transaction_step_id, 'P_WEIGHT' ) weight
454: ,hr_transaction_api.get_varchar2_Value
455: (p_transaction_step_id, 'P_WEIGHT_UOM' ) weight_uom
456: ,hr_transaction_api.get_varchar2_Value
457: (p_transaction_step_id, 'P_TAXATION_METHOD' ) taxation_method
458: ,hr_transaction_api.get_varchar2_Value
452: ,hr_transaction_api.get_number_Value
453: (p_transaction_step_id, 'P_WEIGHT' ) weight
454: ,hr_transaction_api.get_varchar2_Value
455: (p_transaction_step_id, 'P_WEIGHT_UOM' ) weight_uom
456: ,hr_transaction_api.get_varchar2_Value
457: (p_transaction_step_id, 'P_TAXATION_METHOD' ) taxation_method
458: ,hr_transaction_api.get_varchar2_Value
459: (p_transaction_step_id, 'P_COMMENTS' ) comments
460: ,hr_transaction_api.get_varchar2_value
454: ,hr_transaction_api.get_varchar2_Value
455: (p_transaction_step_id, 'P_WEIGHT_UOM' ) weight_uom
456: ,hr_transaction_api.get_varchar2_Value
457: (p_transaction_step_id, 'P_TAXATION_METHOD' ) taxation_method
458: ,hr_transaction_api.get_varchar2_Value
459: (p_transaction_step_id, 'P_COMMENTS' ) comments
460: ,hr_transaction_api.get_varchar2_value
461: (p_transaction_step_id, 'P_VRE_ATTRIBUTE_CATEGORY')
462: vre_attribute_category
456: ,hr_transaction_api.get_varchar2_Value
457: (p_transaction_step_id, 'P_TAXATION_METHOD' ) taxation_method
458: ,hr_transaction_api.get_varchar2_Value
459: (p_transaction_step_id, 'P_COMMENTS' ) comments
460: ,hr_transaction_api.get_varchar2_value
461: (p_transaction_step_id, 'P_VRE_ATTRIBUTE_CATEGORY')
462: vre_attribute_category
463: ,hr_transaction_api.get_varchar2_value
464: (p_transaction_step_id, 'P_VRE_ATTRIBUTE1') vre_attribute1
459: (p_transaction_step_id, 'P_COMMENTS' ) comments
460: ,hr_transaction_api.get_varchar2_value
461: (p_transaction_step_id, 'P_VRE_ATTRIBUTE_CATEGORY')
462: vre_attribute_category
463: ,hr_transaction_api.get_varchar2_value
464: (p_transaction_step_id, 'P_VRE_ATTRIBUTE1') vre_attribute1
465: ,hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id, 'P_VRE_ATTRIBUTE2') vre_attribute2
467: ,hr_transaction_api.get_varchar2_value
461: (p_transaction_step_id, 'P_VRE_ATTRIBUTE_CATEGORY')
462: vre_attribute_category
463: ,hr_transaction_api.get_varchar2_value
464: (p_transaction_step_id, 'P_VRE_ATTRIBUTE1') vre_attribute1
465: ,hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id, 'P_VRE_ATTRIBUTE2') vre_attribute2
467: ,hr_transaction_api.get_varchar2_value
468: (p_transaction_step_id, 'P_VRE_ATTRIBUTE3') vre_attribute3
469: ,hr_transaction_api.get_varchar2_value
463: ,hr_transaction_api.get_varchar2_value
464: (p_transaction_step_id, 'P_VRE_ATTRIBUTE1') vre_attribute1
465: ,hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id, 'P_VRE_ATTRIBUTE2') vre_attribute2
467: ,hr_transaction_api.get_varchar2_value
468: (p_transaction_step_id, 'P_VRE_ATTRIBUTE3') vre_attribute3
469: ,hr_transaction_api.get_varchar2_value
470: (p_transaction_step_id, 'P_VRE_ATTRIBUTE4') vre_attribute4
471: ,hr_transaction_api.get_varchar2_value
465: ,hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id, 'P_VRE_ATTRIBUTE2') vre_attribute2
467: ,hr_transaction_api.get_varchar2_value
468: (p_transaction_step_id, 'P_VRE_ATTRIBUTE3') vre_attribute3
469: ,hr_transaction_api.get_varchar2_value
470: (p_transaction_step_id, 'P_VRE_ATTRIBUTE4') vre_attribute4
471: ,hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id, 'P_VRE_ATTRIBUTE5') vre_attribute5
473: ,hr_transaction_api.get_varchar2_value
467: ,hr_transaction_api.get_varchar2_value
468: (p_transaction_step_id, 'P_VRE_ATTRIBUTE3') vre_attribute3
469: ,hr_transaction_api.get_varchar2_value
470: (p_transaction_step_id, 'P_VRE_ATTRIBUTE4') vre_attribute4
471: ,hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id, 'P_VRE_ATTRIBUTE5') vre_attribute5
473: ,hr_transaction_api.get_varchar2_value
474: (p_transaction_step_id, 'P_VRE_ATTRIBUTE6') vre_attribute6
475: ,hr_transaction_api.get_varchar2_value
469: ,hr_transaction_api.get_varchar2_value
470: (p_transaction_step_id, 'P_VRE_ATTRIBUTE4') vre_attribute4
471: ,hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id, 'P_VRE_ATTRIBUTE5') vre_attribute5
473: ,hr_transaction_api.get_varchar2_value
474: (p_transaction_step_id, 'P_VRE_ATTRIBUTE6') vre_attribute6
475: ,hr_transaction_api.get_varchar2_value
476: (p_transaction_step_id, 'P_VRE_ATTRIBUTE7') vre_attribute7
477: ,hr_transaction_api.get_varchar2_value
471: ,hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id, 'P_VRE_ATTRIBUTE5') vre_attribute5
473: ,hr_transaction_api.get_varchar2_value
474: (p_transaction_step_id, 'P_VRE_ATTRIBUTE6') vre_attribute6
475: ,hr_transaction_api.get_varchar2_value
476: (p_transaction_step_id, 'P_VRE_ATTRIBUTE7') vre_attribute7
477: ,hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id, 'P_VRE_ATTRIBUTE8') vre_attribute8
479: ,hr_transaction_api.get_varchar2_value
473: ,hr_transaction_api.get_varchar2_value
474: (p_transaction_step_id, 'P_VRE_ATTRIBUTE6') vre_attribute6
475: ,hr_transaction_api.get_varchar2_value
476: (p_transaction_step_id, 'P_VRE_ATTRIBUTE7') vre_attribute7
477: ,hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id, 'P_VRE_ATTRIBUTE8') vre_attribute8
479: ,hr_transaction_api.get_varchar2_value
480: (p_transaction_step_id, 'P_VRE_ATTRIBUTE9') vre_attribute9
481: ,hr_transaction_api.get_varchar2_value
475: ,hr_transaction_api.get_varchar2_value
476: (p_transaction_step_id, 'P_VRE_ATTRIBUTE7') vre_attribute7
477: ,hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id, 'P_VRE_ATTRIBUTE8') vre_attribute8
479: ,hr_transaction_api.get_varchar2_value
480: (p_transaction_step_id, 'P_VRE_ATTRIBUTE9') vre_attribute9
481: ,hr_transaction_api.get_varchar2_value
482: (p_transaction_step_id, 'P_VRE_ATTRIBUTE10') vre_attribute10
483: ,hr_transaction_api.get_varchar2_value
477: ,hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id, 'P_VRE_ATTRIBUTE8') vre_attribute8
479: ,hr_transaction_api.get_varchar2_value
480: (p_transaction_step_id, 'P_VRE_ATTRIBUTE9') vre_attribute9
481: ,hr_transaction_api.get_varchar2_value
482: (p_transaction_step_id, 'P_VRE_ATTRIBUTE10') vre_attribute10
483: ,hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id, 'P_VRE_ATTRIBUTE11')vre_attribute11
485: ,hr_transaction_api.get_varchar2_value
479: ,hr_transaction_api.get_varchar2_value
480: (p_transaction_step_id, 'P_VRE_ATTRIBUTE9') vre_attribute9
481: ,hr_transaction_api.get_varchar2_value
482: (p_transaction_step_id, 'P_VRE_ATTRIBUTE10') vre_attribute10
483: ,hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id, 'P_VRE_ATTRIBUTE11')vre_attribute11
485: ,hr_transaction_api.get_varchar2_value
486: (p_transaction_step_id, 'P_VRE_ATTRIBUTE12') vre_attribute12
487: ,hr_transaction_api.get_varchar2_value
481: ,hr_transaction_api.get_varchar2_value
482: (p_transaction_step_id, 'P_VRE_ATTRIBUTE10') vre_attribute10
483: ,hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id, 'P_VRE_ATTRIBUTE11')vre_attribute11
485: ,hr_transaction_api.get_varchar2_value
486: (p_transaction_step_id, 'P_VRE_ATTRIBUTE12') vre_attribute12
487: ,hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id, 'P_VRE_ATTRIBUTE13') vre_attribute13
489: ,hr_transaction_api.get_varchar2_value
483: ,hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id, 'P_VRE_ATTRIBUTE11')vre_attribute11
485: ,hr_transaction_api.get_varchar2_value
486: (p_transaction_step_id, 'P_VRE_ATTRIBUTE12') vre_attribute12
487: ,hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id, 'P_VRE_ATTRIBUTE13') vre_attribute13
489: ,hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id, 'P_VRE_ATTRIBUTE14') vre_attribute14
491: ,hr_transaction_api.get_varchar2_value
485: ,hr_transaction_api.get_varchar2_value
486: (p_transaction_step_id, 'P_VRE_ATTRIBUTE12') vre_attribute12
487: ,hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id, 'P_VRE_ATTRIBUTE13') vre_attribute13
489: ,hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id, 'P_VRE_ATTRIBUTE14') vre_attribute14
491: ,hr_transaction_api.get_varchar2_value
492: (p_transaction_step_id, 'P_VRE_ATTRIBUTE15') vre_attribute15
493: ,hr_transaction_api.get_varchar2_value
487: ,hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id, 'P_VRE_ATTRIBUTE13') vre_attribute13
489: ,hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id, 'P_VRE_ATTRIBUTE14') vre_attribute14
491: ,hr_transaction_api.get_varchar2_value
492: (p_transaction_step_id, 'P_VRE_ATTRIBUTE15') vre_attribute15
493: ,hr_transaction_api.get_varchar2_value
494: (p_transaction_step_id, 'P_VRE_ATTRIBUTE16') vre_attribute16
495: ,hr_transaction_api.get_varchar2_value
489: ,hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id, 'P_VRE_ATTRIBUTE14') vre_attribute14
491: ,hr_transaction_api.get_varchar2_value
492: (p_transaction_step_id, 'P_VRE_ATTRIBUTE15') vre_attribute15
493: ,hr_transaction_api.get_varchar2_value
494: (p_transaction_step_id, 'P_VRE_ATTRIBUTE16') vre_attribute16
495: ,hr_transaction_api.get_varchar2_value
496: (p_transaction_step_id, 'P_VRE_ATTRIBUTE17') vre_attribute17
497: ,hr_transaction_api.get_varchar2_value
491: ,hr_transaction_api.get_varchar2_value
492: (p_transaction_step_id, 'P_VRE_ATTRIBUTE15') vre_attribute15
493: ,hr_transaction_api.get_varchar2_value
494: (p_transaction_step_id, 'P_VRE_ATTRIBUTE16') vre_attribute16
495: ,hr_transaction_api.get_varchar2_value
496: (p_transaction_step_id, 'P_VRE_ATTRIBUTE17') vre_attribute17
497: ,hr_transaction_api.get_varchar2_value
498: (p_transaction_step_id, 'P_VRE_ATTRIBUTE18') vre_attribute18
499: ,hr_transaction_api.get_varchar2_value
493: ,hr_transaction_api.get_varchar2_value
494: (p_transaction_step_id, 'P_VRE_ATTRIBUTE16') vre_attribute16
495: ,hr_transaction_api.get_varchar2_value
496: (p_transaction_step_id, 'P_VRE_ATTRIBUTE17') vre_attribute17
497: ,hr_transaction_api.get_varchar2_value
498: (p_transaction_step_id, 'P_VRE_ATTRIBUTE18') vre_attribute18
499: ,hr_transaction_api.get_varchar2_value
500: (p_transaction_step_id, 'P_VRE_ATTRIBUTE19') vre_attribute19
501: ,hr_transaction_api.get_varchar2_value
495: ,hr_transaction_api.get_varchar2_value
496: (p_transaction_step_id, 'P_VRE_ATTRIBUTE17') vre_attribute17
497: ,hr_transaction_api.get_varchar2_value
498: (p_transaction_step_id, 'P_VRE_ATTRIBUTE18') vre_attribute18
499: ,hr_transaction_api.get_varchar2_value
500: (p_transaction_step_id, 'P_VRE_ATTRIBUTE19') vre_attribute19
501: ,hr_transaction_api.get_varchar2_value
502: (p_transaction_step_id, 'P_VRE_ATTRIBUTE20') vre_attribute20
503: ,hr_transaction_api.get_varchar2_value
497: ,hr_transaction_api.get_varchar2_value
498: (p_transaction_step_id, 'P_VRE_ATTRIBUTE18') vre_attribute18
499: ,hr_transaction_api.get_varchar2_value
500: (p_transaction_step_id, 'P_VRE_ATTRIBUTE19') vre_attribute19
501: ,hr_transaction_api.get_varchar2_value
502: (p_transaction_step_id, 'P_VRE_ATTRIBUTE20') vre_attribute20
503: ,hr_transaction_api.get_varchar2_value
504: (p_transaction_step_id, 'P_VRE_INFORMATION_CATEGORY')
505: vre_information_category
499: ,hr_transaction_api.get_varchar2_value
500: (p_transaction_step_id, 'P_VRE_ATTRIBUTE19') vre_attribute19
501: ,hr_transaction_api.get_varchar2_value
502: (p_transaction_step_id, 'P_VRE_ATTRIBUTE20') vre_attribute20
503: ,hr_transaction_api.get_varchar2_value
504: (p_transaction_step_id, 'P_VRE_INFORMATION_CATEGORY')
505: vre_information_category
506: ,hr_transaction_api.get_varchar2_value
507: (p_transaction_step_id, 'P_VRE_INFORMATION1') vre_information1
502: (p_transaction_step_id, 'P_VRE_ATTRIBUTE20') vre_attribute20
503: ,hr_transaction_api.get_varchar2_value
504: (p_transaction_step_id, 'P_VRE_INFORMATION_CATEGORY')
505: vre_information_category
506: ,hr_transaction_api.get_varchar2_value
507: (p_transaction_step_id, 'P_VRE_INFORMATION1') vre_information1
508: ,hr_transaction_api.get_varchar2_value
509: (p_transaction_step_id, 'P_VRE_INFORMATION2') vre_information2
510: ,hr_transaction_api.get_varchar2_value
504: (p_transaction_step_id, 'P_VRE_INFORMATION_CATEGORY')
505: vre_information_category
506: ,hr_transaction_api.get_varchar2_value
507: (p_transaction_step_id, 'P_VRE_INFORMATION1') vre_information1
508: ,hr_transaction_api.get_varchar2_value
509: (p_transaction_step_id, 'P_VRE_INFORMATION2') vre_information2
510: ,hr_transaction_api.get_varchar2_value
511: (p_transaction_step_id, 'P_VRE_INFORMATION3') vre_information3
512: ,hr_transaction_api.get_varchar2_value
506: ,hr_transaction_api.get_varchar2_value
507: (p_transaction_step_id, 'P_VRE_INFORMATION1') vre_information1
508: ,hr_transaction_api.get_varchar2_value
509: (p_transaction_step_id, 'P_VRE_INFORMATION2') vre_information2
510: ,hr_transaction_api.get_varchar2_value
511: (p_transaction_step_id, 'P_VRE_INFORMATION3') vre_information3
512: ,hr_transaction_api.get_varchar2_value
513: (p_transaction_step_id, 'P_VRE_INFORMATION4') vre_information4
514: ,hr_transaction_api.get_varchar2_value
508: ,hr_transaction_api.get_varchar2_value
509: (p_transaction_step_id, 'P_VRE_INFORMATION2') vre_information2
510: ,hr_transaction_api.get_varchar2_value
511: (p_transaction_step_id, 'P_VRE_INFORMATION3') vre_information3
512: ,hr_transaction_api.get_varchar2_value
513: (p_transaction_step_id, 'P_VRE_INFORMATION4') vre_information4
514: ,hr_transaction_api.get_varchar2_value
515: (p_transaction_step_id, 'P_VRE_INFORMATION5') vre_information5
516: ,hr_transaction_api.get_varchar2_value
510: ,hr_transaction_api.get_varchar2_value
511: (p_transaction_step_id, 'P_VRE_INFORMATION3') vre_information3
512: ,hr_transaction_api.get_varchar2_value
513: (p_transaction_step_id, 'P_VRE_INFORMATION4') vre_information4
514: ,hr_transaction_api.get_varchar2_value
515: (p_transaction_step_id, 'P_VRE_INFORMATION5') vre_information5
516: ,hr_transaction_api.get_varchar2_value
517: (p_transaction_step_id, 'P_VRE_INFORMATION6') vre_information6
518: ,hr_transaction_api.get_varchar2_value
512: ,hr_transaction_api.get_varchar2_value
513: (p_transaction_step_id, 'P_VRE_INFORMATION4') vre_information4
514: ,hr_transaction_api.get_varchar2_value
515: (p_transaction_step_id, 'P_VRE_INFORMATION5') vre_information5
516: ,hr_transaction_api.get_varchar2_value
517: (p_transaction_step_id, 'P_VRE_INFORMATION6') vre_information6
518: ,hr_transaction_api.get_varchar2_value
519: (p_transaction_step_id, 'P_VRE_INFORMATION7') vre_information7
520: ,hr_transaction_api.get_varchar2_value
514: ,hr_transaction_api.get_varchar2_value
515: (p_transaction_step_id, 'P_VRE_INFORMATION5') vre_information5
516: ,hr_transaction_api.get_varchar2_value
517: (p_transaction_step_id, 'P_VRE_INFORMATION6') vre_information6
518: ,hr_transaction_api.get_varchar2_value
519: (p_transaction_step_id, 'P_VRE_INFORMATION7') vre_information7
520: ,hr_transaction_api.get_varchar2_value
521: (p_transaction_step_id, 'P_VRE_INFORMATION8') vre_information8
522: ,hr_transaction_api.get_varchar2_value
516: ,hr_transaction_api.get_varchar2_value
517: (p_transaction_step_id, 'P_VRE_INFORMATION6') vre_information6
518: ,hr_transaction_api.get_varchar2_value
519: (p_transaction_step_id, 'P_VRE_INFORMATION7') vre_information7
520: ,hr_transaction_api.get_varchar2_value
521: (p_transaction_step_id, 'P_VRE_INFORMATION8') vre_information8
522: ,hr_transaction_api.get_varchar2_value
523: (p_transaction_step_id, 'P_VRE_INFORMATION9') vre_information9
524: ,hr_transaction_api.get_varchar2_value
518: ,hr_transaction_api.get_varchar2_value
519: (p_transaction_step_id, 'P_VRE_INFORMATION7') vre_information7
520: ,hr_transaction_api.get_varchar2_value
521: (p_transaction_step_id, 'P_VRE_INFORMATION8') vre_information8
522: ,hr_transaction_api.get_varchar2_value
523: (p_transaction_step_id, 'P_VRE_INFORMATION9') vre_information9
524: ,hr_transaction_api.get_varchar2_value
525: (p_transaction_step_id, 'P_VRE_INFORMATION10') vre_information10
526: ,hr_transaction_api.get_varchar2_value
520: ,hr_transaction_api.get_varchar2_value
521: (p_transaction_step_id, 'P_VRE_INFORMATION8') vre_information8
522: ,hr_transaction_api.get_varchar2_value
523: (p_transaction_step_id, 'P_VRE_INFORMATION9') vre_information9
524: ,hr_transaction_api.get_varchar2_value
525: (p_transaction_step_id, 'P_VRE_INFORMATION10') vre_information10
526: ,hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id, 'P_VRE_INFORMATION11') vre_information11
528: ,hr_transaction_api.get_varchar2_value
522: ,hr_transaction_api.get_varchar2_value
523: (p_transaction_step_id, 'P_VRE_INFORMATION9') vre_information9
524: ,hr_transaction_api.get_varchar2_value
525: (p_transaction_step_id, 'P_VRE_INFORMATION10') vre_information10
526: ,hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id, 'P_VRE_INFORMATION11') vre_information11
528: ,hr_transaction_api.get_varchar2_value
529: (p_transaction_step_id, 'P_VRE_INFORMATION12') vre_information12
530: ,hr_transaction_api.get_varchar2_value
524: ,hr_transaction_api.get_varchar2_value
525: (p_transaction_step_id, 'P_VRE_INFORMATION10') vre_information10
526: ,hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id, 'P_VRE_INFORMATION11') vre_information11
528: ,hr_transaction_api.get_varchar2_value
529: (p_transaction_step_id, 'P_VRE_INFORMATION12') vre_information12
530: ,hr_transaction_api.get_varchar2_value
531: (p_transaction_step_id, 'P_VRE_INFORMATION13') vre_information13
532: ,hr_transaction_api.get_varchar2_value
526: ,hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id, 'P_VRE_INFORMATION11') vre_information11
528: ,hr_transaction_api.get_varchar2_value
529: (p_transaction_step_id, 'P_VRE_INFORMATION12') vre_information12
530: ,hr_transaction_api.get_varchar2_value
531: (p_transaction_step_id, 'P_VRE_INFORMATION13') vre_information13
532: ,hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id, 'P_VRE_INFORMATION14') vre_information14
534: ,hr_transaction_api.get_varchar2_value
528: ,hr_transaction_api.get_varchar2_value
529: (p_transaction_step_id, 'P_VRE_INFORMATION12') vre_information12
530: ,hr_transaction_api.get_varchar2_value
531: (p_transaction_step_id, 'P_VRE_INFORMATION13') vre_information13
532: ,hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id, 'P_VRE_INFORMATION14') vre_information14
534: ,hr_transaction_api.get_varchar2_value
535: (p_transaction_step_id, 'P_VRE_INFORMATION15') vre_information15
536: ,hr_transaction_api.get_varchar2_value
530: ,hr_transaction_api.get_varchar2_value
531: (p_transaction_step_id, 'P_VRE_INFORMATION13') vre_information13
532: ,hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id, 'P_VRE_INFORMATION14') vre_information14
534: ,hr_transaction_api.get_varchar2_value
535: (p_transaction_step_id, 'P_VRE_INFORMATION15') vre_information15
536: ,hr_transaction_api.get_varchar2_value
537: (p_transaction_step_id, 'P_VRE_INFORMATION16') vre_information16
538: ,hr_transaction_api.get_varchar2_value
532: ,hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id, 'P_VRE_INFORMATION14') vre_information14
534: ,hr_transaction_api.get_varchar2_value
535: (p_transaction_step_id, 'P_VRE_INFORMATION15') vre_information15
536: ,hr_transaction_api.get_varchar2_value
537: (p_transaction_step_id, 'P_VRE_INFORMATION16') vre_information16
538: ,hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id, 'P_VRE_INFORMATION17') vre_information17
540: ,hr_transaction_api.get_varchar2_value
534: ,hr_transaction_api.get_varchar2_value
535: (p_transaction_step_id, 'P_VRE_INFORMATION15') vre_information15
536: ,hr_transaction_api.get_varchar2_value
537: (p_transaction_step_id, 'P_VRE_INFORMATION16') vre_information16
538: ,hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id, 'P_VRE_INFORMATION17') vre_information17
540: ,hr_transaction_api.get_varchar2_value
541: (p_transaction_step_id, 'P_VRE_INFORMATION18') vre_information18
542: ,hr_transaction_api.get_varchar2_value
536: ,hr_transaction_api.get_varchar2_value
537: (p_transaction_step_id, 'P_VRE_INFORMATION16') vre_information16
538: ,hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id, 'P_VRE_INFORMATION17') vre_information17
540: ,hr_transaction_api.get_varchar2_value
541: (p_transaction_step_id, 'P_VRE_INFORMATION18') vre_information18
542: ,hr_transaction_api.get_varchar2_value
543: (p_transaction_step_id, 'P_VRE_INFORMATION19') vre_information19
544: ,hr_transaction_api.get_varchar2_value
538: ,hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id, 'P_VRE_INFORMATION17') vre_information17
540: ,hr_transaction_api.get_varchar2_value
541: (p_transaction_step_id, 'P_VRE_INFORMATION18') vre_information18
542: ,hr_transaction_api.get_varchar2_value
543: (p_transaction_step_id, 'P_VRE_INFORMATION19') vre_information19
544: ,hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id, 'P_VRE_INFORMATION20') vre_information20
546: ,hr_transaction_api.get_varchar2_value
540: ,hr_transaction_api.get_varchar2_value
541: (p_transaction_step_id, 'P_VRE_INFORMATION18') vre_information18
542: ,hr_transaction_api.get_varchar2_value
543: (p_transaction_step_id, 'P_VRE_INFORMATION19') vre_information19
544: ,hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id, 'P_VRE_INFORMATION20') vre_information20
546: ,hr_transaction_api.get_varchar2_value
547: (p_transaction_step_id, 'P_ACROSS_ASSIGNMENTS') across_assignments
548: ,hr_transaction_api.get_varchar2_value
542: ,hr_transaction_api.get_varchar2_value
543: (p_transaction_step_id, 'P_VRE_INFORMATION19') vre_information19
544: ,hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id, 'P_VRE_INFORMATION20') vre_information20
546: ,hr_transaction_api.get_varchar2_value
547: (p_transaction_step_id, 'P_ACROSS_ASSIGNMENTS') across_assignments
548: ,hr_transaction_api.get_varchar2_value
549: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
550: ,hr_transaction_api.get_varchar2_value
544: ,hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id, 'P_VRE_INFORMATION20') vre_information20
546: ,hr_transaction_api.get_varchar2_value
547: (p_transaction_step_id, 'P_ACROSS_ASSIGNMENTS') across_assignments
548: ,hr_transaction_api.get_varchar2_value
549: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
550: ,hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id, 'P_DEFAULT_VEHICLE') default_vehicle
552: ,hr_transaction_api.get_varchar2_value
546: ,hr_transaction_api.get_varchar2_value
547: (p_transaction_step_id, 'P_ACROSS_ASSIGNMENTS') across_assignments
548: ,hr_transaction_api.get_varchar2_value
549: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
550: ,hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id, 'P_DEFAULT_VEHICLE') default_vehicle
552: ,hr_transaction_api.get_varchar2_value
553: (p_transaction_step_id, 'P_FUEL_CARD') fuel_card
554: ,hr_transaction_api.get_varchar2_value
548: ,hr_transaction_api.get_varchar2_value
549: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
550: ,hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id, 'P_DEFAULT_VEHICLE') default_vehicle
552: ,hr_transaction_api.get_varchar2_value
553: (p_transaction_step_id, 'P_FUEL_CARD') fuel_card
554: ,hr_transaction_api.get_varchar2_value
555: (p_transaction_step_id, 'P_FUEL_CARD_NUMBER') fuel_card_number
556: ,hr_transaction_api.get_varchar2_value
550: ,hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id, 'P_DEFAULT_VEHICLE') default_vehicle
552: ,hr_transaction_api.get_varchar2_value
553: (p_transaction_step_id, 'P_FUEL_CARD') fuel_card
554: ,hr_transaction_api.get_varchar2_value
555: (p_transaction_step_id, 'P_FUEL_CARD_NUMBER') fuel_card_number
556: ,hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id, 'P_FUEL_BENEFIT') fuel_benefit
558: ,hr_transaction_api.get_number_value
552: ,hr_transaction_api.get_varchar2_value
553: (p_transaction_step_id, 'P_FUEL_CARD') fuel_card
554: ,hr_transaction_api.get_varchar2_value
555: (p_transaction_step_id, 'P_FUEL_CARD_NUMBER') fuel_card_number
556: ,hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id, 'P_FUEL_BENEFIT') fuel_benefit
558: ,hr_transaction_api.get_number_value
559: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
560: ,hr_transaction_api.get_varchar2_value
554: ,hr_transaction_api.get_varchar2_value
555: (p_transaction_step_id, 'P_FUEL_CARD_NUMBER') fuel_card_number
556: ,hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id, 'P_FUEL_BENEFIT') fuel_benefit
558: ,hr_transaction_api.get_number_value
559: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
560: ,hr_transaction_api.get_varchar2_value
561: (p_transaction_step_id, 'P_VAL_ATTRIBUTE_CATEGORY')
562: val_attribute_category
556: ,hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id, 'P_FUEL_BENEFIT') fuel_benefit
558: ,hr_transaction_api.get_number_value
559: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
560: ,hr_transaction_api.get_varchar2_value
561: (p_transaction_step_id, 'P_VAL_ATTRIBUTE_CATEGORY')
562: val_attribute_category
563: ,hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id, 'P_VAL_ATTRIBUTE1') val_attribute1
559: (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
560: ,hr_transaction_api.get_varchar2_value
561: (p_transaction_step_id, 'P_VAL_ATTRIBUTE_CATEGORY')
562: val_attribute_category
563: ,hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id, 'P_VAL_ATTRIBUTE1') val_attribute1
565: ,hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id, 'P_VAL_ATTRIBUTE2') val_attribute2
567: ,hr_transaction_api.get_varchar2_value
561: (p_transaction_step_id, 'P_VAL_ATTRIBUTE_CATEGORY')
562: val_attribute_category
563: ,hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id, 'P_VAL_ATTRIBUTE1') val_attribute1
565: ,hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id, 'P_VAL_ATTRIBUTE2') val_attribute2
567: ,hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id, 'P_VAL_ATTRIBUTE3') val_attribute3
569: ,hr_transaction_api.get_varchar2_value
563: ,hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id, 'P_VAL_ATTRIBUTE1') val_attribute1
565: ,hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id, 'P_VAL_ATTRIBUTE2') val_attribute2
567: ,hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id, 'P_VAL_ATTRIBUTE3') val_attribute3
569: ,hr_transaction_api.get_varchar2_value
570: (p_transaction_step_id, 'P_VAL_ATTRIBUTE4') val_attribute4
571: ,hr_transaction_api.get_varchar2_value
565: ,hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id, 'P_VAL_ATTRIBUTE2') val_attribute2
567: ,hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id, 'P_VAL_ATTRIBUTE3') val_attribute3
569: ,hr_transaction_api.get_varchar2_value
570: (p_transaction_step_id, 'P_VAL_ATTRIBUTE4') val_attribute4
571: ,hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id, 'P_VAL_ATTRIBUTE5') val_attribute5
573: ,hr_transaction_api.get_varchar2_value
567: ,hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id, 'P_VAL_ATTRIBUTE3') val_attribute3
569: ,hr_transaction_api.get_varchar2_value
570: (p_transaction_step_id, 'P_VAL_ATTRIBUTE4') val_attribute4
571: ,hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id, 'P_VAL_ATTRIBUTE5') val_attribute5
573: ,hr_transaction_api.get_varchar2_value
574: (p_transaction_step_id, 'P_VAL_ATTRIBUTE6') val_attribute6
575: ,hr_transaction_api.get_varchar2_value
569: ,hr_transaction_api.get_varchar2_value
570: (p_transaction_step_id, 'P_VAL_ATTRIBUTE4') val_attribute4
571: ,hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id, 'P_VAL_ATTRIBUTE5') val_attribute5
573: ,hr_transaction_api.get_varchar2_value
574: (p_transaction_step_id, 'P_VAL_ATTRIBUTE6') val_attribute6
575: ,hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id, 'P_VAL_ATTRIBUTE7') val_attribute7
577: ,hr_transaction_api.get_varchar2_value
571: ,hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id, 'P_VAL_ATTRIBUTE5') val_attribute5
573: ,hr_transaction_api.get_varchar2_value
574: (p_transaction_step_id, 'P_VAL_ATTRIBUTE6') val_attribute6
575: ,hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id, 'P_VAL_ATTRIBUTE7') val_attribute7
577: ,hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id, 'P_VAL_ATTRIBUTE8') val_attribute8
579: ,hr_transaction_api.get_varchar2_value
573: ,hr_transaction_api.get_varchar2_value
574: (p_transaction_step_id, 'P_VAL_ATTRIBUTE6') val_attribute6
575: ,hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id, 'P_VAL_ATTRIBUTE7') val_attribute7
577: ,hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id, 'P_VAL_ATTRIBUTE8') val_attribute8
579: ,hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id, 'P_VAL_ATTRIBUTE9') val_attribute9
581: ,hr_transaction_api.get_varchar2_value
575: ,hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id, 'P_VAL_ATTRIBUTE7') val_attribute7
577: ,hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id, 'P_VAL_ATTRIBUTE8') val_attribute8
579: ,hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id, 'P_VAL_ATTRIBUTE9') val_attribute9
581: ,hr_transaction_api.get_varchar2_value
582: (p_transaction_step_id, 'P_VAL_ATTRIBUTE10') val_attribute10
583: ,hr_transaction_api.get_varchar2_value
577: ,hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id, 'P_VAL_ATTRIBUTE8') val_attribute8
579: ,hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id, 'P_VAL_ATTRIBUTE9') val_attribute9
581: ,hr_transaction_api.get_varchar2_value
582: (p_transaction_step_id, 'P_VAL_ATTRIBUTE10') val_attribute10
583: ,hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id, 'P_VAL_ATTRIBUTE11') val_attribute11
585: ,hr_transaction_api.get_varchar2_value
579: ,hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id, 'P_VAL_ATTRIBUTE9') val_attribute9
581: ,hr_transaction_api.get_varchar2_value
582: (p_transaction_step_id, 'P_VAL_ATTRIBUTE10') val_attribute10
583: ,hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id, 'P_VAL_ATTRIBUTE11') val_attribute11
585: ,hr_transaction_api.get_varchar2_value
586: (p_transaction_step_id, 'P_VAL_ATTRIBUTE12') val_attribute12
587: ,hr_transaction_api.get_varchar2_value
581: ,hr_transaction_api.get_varchar2_value
582: (p_transaction_step_id, 'P_VAL_ATTRIBUTE10') val_attribute10
583: ,hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id, 'P_VAL_ATTRIBUTE11') val_attribute11
585: ,hr_transaction_api.get_varchar2_value
586: (p_transaction_step_id, 'P_VAL_ATTRIBUTE12') val_attribute12
587: ,hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id, 'P_VAL_ATTRIBUTE13') val_attribute13
589: ,hr_transaction_api.get_varchar2_value
583: ,hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id, 'P_VAL_ATTRIBUTE11') val_attribute11
585: ,hr_transaction_api.get_varchar2_value
586: (p_transaction_step_id, 'P_VAL_ATTRIBUTE12') val_attribute12
587: ,hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id, 'P_VAL_ATTRIBUTE13') val_attribute13
589: ,hr_transaction_api.get_varchar2_value
590: (p_transaction_step_id, 'P_VAL_ATTRIBUTE14') val_attribute14
591: ,hr_transaction_api.get_varchar2_value
585: ,hr_transaction_api.get_varchar2_value
586: (p_transaction_step_id, 'P_VAL_ATTRIBUTE12') val_attribute12
587: ,hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id, 'P_VAL_ATTRIBUTE13') val_attribute13
589: ,hr_transaction_api.get_varchar2_value
590: (p_transaction_step_id, 'P_VAL_ATTRIBUTE14') val_attribute14
591: ,hr_transaction_api.get_varchar2_value
592: (p_transaction_step_id, 'P_VAL_ATTRIBUTE15') val_attribute15
593: ,hr_transaction_api.get_varchar2_value
587: ,hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id, 'P_VAL_ATTRIBUTE13') val_attribute13
589: ,hr_transaction_api.get_varchar2_value
590: (p_transaction_step_id, 'P_VAL_ATTRIBUTE14') val_attribute14
591: ,hr_transaction_api.get_varchar2_value
592: (p_transaction_step_id, 'P_VAL_ATTRIBUTE15') val_attribute15
593: ,hr_transaction_api.get_varchar2_value
594: (p_transaction_step_id, 'P_VAL_ATTRIBUTE16') val_attribute16
595: ,hr_transaction_api.get_varchar2_value
589: ,hr_transaction_api.get_varchar2_value
590: (p_transaction_step_id, 'P_VAL_ATTRIBUTE14') val_attribute14
591: ,hr_transaction_api.get_varchar2_value
592: (p_transaction_step_id, 'P_VAL_ATTRIBUTE15') val_attribute15
593: ,hr_transaction_api.get_varchar2_value
594: (p_transaction_step_id, 'P_VAL_ATTRIBUTE16') val_attribute16
595: ,hr_transaction_api.get_varchar2_value
596: (p_transaction_step_id, 'P_VAL_ATTRIBUTE17') val_attribute17
597: ,hr_transaction_api.get_varchar2_value
591: ,hr_transaction_api.get_varchar2_value
592: (p_transaction_step_id, 'P_VAL_ATTRIBUTE15') val_attribute15
593: ,hr_transaction_api.get_varchar2_value
594: (p_transaction_step_id, 'P_VAL_ATTRIBUTE16') val_attribute16
595: ,hr_transaction_api.get_varchar2_value
596: (p_transaction_step_id, 'P_VAL_ATTRIBUTE17') val_attribute17
597: ,hr_transaction_api.get_varchar2_value
598: (p_transaction_step_id, 'P_VAL_ATTRIBUTE18') val_attribute18
599: ,hr_transaction_api.get_varchar2_value
593: ,hr_transaction_api.get_varchar2_value
594: (p_transaction_step_id, 'P_VAL_ATTRIBUTE16') val_attribute16
595: ,hr_transaction_api.get_varchar2_value
596: (p_transaction_step_id, 'P_VAL_ATTRIBUTE17') val_attribute17
597: ,hr_transaction_api.get_varchar2_value
598: (p_transaction_step_id, 'P_VAL_ATTRIBUTE18') val_attribute18
599: ,hr_transaction_api.get_varchar2_value
600: (p_transaction_step_id, 'P_VAL_ATTRIBUTE19') val_attribute19
601: ,hr_transaction_api.get_varchar2_value
595: ,hr_transaction_api.get_varchar2_value
596: (p_transaction_step_id, 'P_VAL_ATTRIBUTE17') val_attribute17
597: ,hr_transaction_api.get_varchar2_value
598: (p_transaction_step_id, 'P_VAL_ATTRIBUTE18') val_attribute18
599: ,hr_transaction_api.get_varchar2_value
600: (p_transaction_step_id, 'P_VAL_ATTRIBUTE19') val_attribute19
601: ,hr_transaction_api.get_varchar2_value
602: (p_transaction_step_id, 'P_VAL_ATTRIBUTE20') val_attribute20
603: ,hr_transaction_api.get_varchar2_value
597: ,hr_transaction_api.get_varchar2_value
598: (p_transaction_step_id, 'P_VAL_ATTRIBUTE18') val_attribute18
599: ,hr_transaction_api.get_varchar2_value
600: (p_transaction_step_id, 'P_VAL_ATTRIBUTE19') val_attribute19
601: ,hr_transaction_api.get_varchar2_value
602: (p_transaction_step_id, 'P_VAL_ATTRIBUTE20') val_attribute20
603: ,hr_transaction_api.get_varchar2_value
604: (p_transaction_step_id, 'P_VAL_INFORMATION_CATEGORY')
605: val_information_category
599: ,hr_transaction_api.get_varchar2_value
600: (p_transaction_step_id, 'P_VAL_ATTRIBUTE19') val_attribute19
601: ,hr_transaction_api.get_varchar2_value
602: (p_transaction_step_id, 'P_VAL_ATTRIBUTE20') val_attribute20
603: ,hr_transaction_api.get_varchar2_value
604: (p_transaction_step_id, 'P_VAL_INFORMATION_CATEGORY')
605: val_information_category
606: ,hr_transaction_api.get_varchar2_value
607: (p_transaction_step_id, 'P_VAL_INFORMATION1') val_information1
602: (p_transaction_step_id, 'P_VAL_ATTRIBUTE20') val_attribute20
603: ,hr_transaction_api.get_varchar2_value
604: (p_transaction_step_id, 'P_VAL_INFORMATION_CATEGORY')
605: val_information_category
606: ,hr_transaction_api.get_varchar2_value
607: (p_transaction_step_id, 'P_VAL_INFORMATION1') val_information1
608: ,hr_transaction_api.get_varchar2_value
609: (p_transaction_step_id, 'P_VAL_INFORMATION2') val_information2
610: ,hr_transaction_api.get_varchar2_value
604: (p_transaction_step_id, 'P_VAL_INFORMATION_CATEGORY')
605: val_information_category
606: ,hr_transaction_api.get_varchar2_value
607: (p_transaction_step_id, 'P_VAL_INFORMATION1') val_information1
608: ,hr_transaction_api.get_varchar2_value
609: (p_transaction_step_id, 'P_VAL_INFORMATION2') val_information2
610: ,hr_transaction_api.get_varchar2_value
611: (p_transaction_step_id, 'P_VAL_INFORMATION3') val_information3
612: ,hr_transaction_api.get_varchar2_value
606: ,hr_transaction_api.get_varchar2_value
607: (p_transaction_step_id, 'P_VAL_INFORMATION1') val_information1
608: ,hr_transaction_api.get_varchar2_value
609: (p_transaction_step_id, 'P_VAL_INFORMATION2') val_information2
610: ,hr_transaction_api.get_varchar2_value
611: (p_transaction_step_id, 'P_VAL_INFORMATION3') val_information3
612: ,hr_transaction_api.get_varchar2_value
613: (p_transaction_step_id, 'P_VAL_INFORMATION4') val_information4
614: ,hr_transaction_api.get_varchar2_value
608: ,hr_transaction_api.get_varchar2_value
609: (p_transaction_step_id, 'P_VAL_INFORMATION2') val_information2
610: ,hr_transaction_api.get_varchar2_value
611: (p_transaction_step_id, 'P_VAL_INFORMATION3') val_information3
612: ,hr_transaction_api.get_varchar2_value
613: (p_transaction_step_id, 'P_VAL_INFORMATION4') val_information4
614: ,hr_transaction_api.get_varchar2_value
615: (p_transaction_step_id, 'P_VAL_INFORMATION5') val_information5
616: ,hr_transaction_api.get_varchar2_value
610: ,hr_transaction_api.get_varchar2_value
611: (p_transaction_step_id, 'P_VAL_INFORMATION3') val_information3
612: ,hr_transaction_api.get_varchar2_value
613: (p_transaction_step_id, 'P_VAL_INFORMATION4') val_information4
614: ,hr_transaction_api.get_varchar2_value
615: (p_transaction_step_id, 'P_VAL_INFORMATION5') val_information5
616: ,hr_transaction_api.get_varchar2_value
617: (p_transaction_step_id, 'P_VAL_INFORMATION6') val_information6
618: ,hr_transaction_api.get_varchar2_value
612: ,hr_transaction_api.get_varchar2_value
613: (p_transaction_step_id, 'P_VAL_INFORMATION4') val_information4
614: ,hr_transaction_api.get_varchar2_value
615: (p_transaction_step_id, 'P_VAL_INFORMATION5') val_information5
616: ,hr_transaction_api.get_varchar2_value
617: (p_transaction_step_id, 'P_VAL_INFORMATION6') val_information6
618: ,hr_transaction_api.get_varchar2_value
619: (p_transaction_step_id, 'P_VAL_INFORMATION7') val_information7
620: ,hr_transaction_api.get_varchar2_value
614: ,hr_transaction_api.get_varchar2_value
615: (p_transaction_step_id, 'P_VAL_INFORMATION5') val_information5
616: ,hr_transaction_api.get_varchar2_value
617: (p_transaction_step_id, 'P_VAL_INFORMATION6') val_information6
618: ,hr_transaction_api.get_varchar2_value
619: (p_transaction_step_id, 'P_VAL_INFORMATION7') val_information7
620: ,hr_transaction_api.get_varchar2_value
621: (p_transaction_step_id, 'P_VAL_INFORMATION8') val_information8
622: ,hr_transaction_api.get_varchar2_value
616: ,hr_transaction_api.get_varchar2_value
617: (p_transaction_step_id, 'P_VAL_INFORMATION6') val_information6
618: ,hr_transaction_api.get_varchar2_value
619: (p_transaction_step_id, 'P_VAL_INFORMATION7') val_information7
620: ,hr_transaction_api.get_varchar2_value
621: (p_transaction_step_id, 'P_VAL_INFORMATION8') val_information8
622: ,hr_transaction_api.get_varchar2_value
623: (p_transaction_step_id, 'P_VAL_INFORMATION9') val_information9
624: ,hr_transaction_api.get_varchar2_value
618: ,hr_transaction_api.get_varchar2_value
619: (p_transaction_step_id, 'P_VAL_INFORMATION7') val_information7
620: ,hr_transaction_api.get_varchar2_value
621: (p_transaction_step_id, 'P_VAL_INFORMATION8') val_information8
622: ,hr_transaction_api.get_varchar2_value
623: (p_transaction_step_id, 'P_VAL_INFORMATION9') val_information9
624: ,hr_transaction_api.get_varchar2_value
625: (p_transaction_step_id, 'P_VAL_INFORMATION10') val_information10
626: ,hr_transaction_api.get_varchar2_value
620: ,hr_transaction_api.get_varchar2_value
621: (p_transaction_step_id, 'P_VAL_INFORMATION8') val_information8
622: ,hr_transaction_api.get_varchar2_value
623: (p_transaction_step_id, 'P_VAL_INFORMATION9') val_information9
624: ,hr_transaction_api.get_varchar2_value
625: (p_transaction_step_id, 'P_VAL_INFORMATION10') val_information10
626: ,hr_transaction_api.get_varchar2_value
627: (p_transaction_step_id, 'P_VAL_INFORMATION11') val_information11
628: ,hr_transaction_api.get_varchar2_value
622: ,hr_transaction_api.get_varchar2_value
623: (p_transaction_step_id, 'P_VAL_INFORMATION9') val_information9
624: ,hr_transaction_api.get_varchar2_value
625: (p_transaction_step_id, 'P_VAL_INFORMATION10') val_information10
626: ,hr_transaction_api.get_varchar2_value
627: (p_transaction_step_id, 'P_VAL_INFORMATION11') val_information11
628: ,hr_transaction_api.get_varchar2_value
629: (p_transaction_step_id, 'P_VAL_INFORMATION12') val_information12
630: ,hr_transaction_api.get_varchar2_value
624: ,hr_transaction_api.get_varchar2_value
625: (p_transaction_step_id, 'P_VAL_INFORMATION10') val_information10
626: ,hr_transaction_api.get_varchar2_value
627: (p_transaction_step_id, 'P_VAL_INFORMATION11') val_information11
628: ,hr_transaction_api.get_varchar2_value
629: (p_transaction_step_id, 'P_VAL_INFORMATION12') val_information12
630: ,hr_transaction_api.get_varchar2_value
631: (p_transaction_step_id, 'P_VAL_INFORMATION13') val_information13
632: ,hr_transaction_api.get_varchar2_value
626: ,hr_transaction_api.get_varchar2_value
627: (p_transaction_step_id, 'P_VAL_INFORMATION11') val_information11
628: ,hr_transaction_api.get_varchar2_value
629: (p_transaction_step_id, 'P_VAL_INFORMATION12') val_information12
630: ,hr_transaction_api.get_varchar2_value
631: (p_transaction_step_id, 'P_VAL_INFORMATION13') val_information13
632: ,hr_transaction_api.get_varchar2_value
633: (p_transaction_step_id, 'P_VAL_INFORMATION14') val_information14
634: ,hr_transaction_api.get_varchar2_value
628: ,hr_transaction_api.get_varchar2_value
629: (p_transaction_step_id, 'P_VAL_INFORMATION12') val_information12
630: ,hr_transaction_api.get_varchar2_value
631: (p_transaction_step_id, 'P_VAL_INFORMATION13') val_information13
632: ,hr_transaction_api.get_varchar2_value
633: (p_transaction_step_id, 'P_VAL_INFORMATION14') val_information14
634: ,hr_transaction_api.get_varchar2_value
635: (p_transaction_step_id, 'P_VAL_INFORMATION15') val_information15
636: ,hr_transaction_api.get_varchar2_value
630: ,hr_transaction_api.get_varchar2_value
631: (p_transaction_step_id, 'P_VAL_INFORMATION13') val_information13
632: ,hr_transaction_api.get_varchar2_value
633: (p_transaction_step_id, 'P_VAL_INFORMATION14') val_information14
634: ,hr_transaction_api.get_varchar2_value
635: (p_transaction_step_id, 'P_VAL_INFORMATION15') val_information15
636: ,hr_transaction_api.get_varchar2_value
637: (p_transaction_step_id, 'P_VAL_INFORMATION16') val_information16
638: ,hr_transaction_api.get_varchar2_value
632: ,hr_transaction_api.get_varchar2_value
633: (p_transaction_step_id, 'P_VAL_INFORMATION14') val_information14
634: ,hr_transaction_api.get_varchar2_value
635: (p_transaction_step_id, 'P_VAL_INFORMATION15') val_information15
636: ,hr_transaction_api.get_varchar2_value
637: (p_transaction_step_id, 'P_VAL_INFORMATION16') val_information16
638: ,hr_transaction_api.get_varchar2_value
639: (p_transaction_step_id, 'P_VAL_INFORMATION17') val_information17
640: ,hr_transaction_api.get_varchar2_value
634: ,hr_transaction_api.get_varchar2_value
635: (p_transaction_step_id, 'P_VAL_INFORMATION15') val_information15
636: ,hr_transaction_api.get_varchar2_value
637: (p_transaction_step_id, 'P_VAL_INFORMATION16') val_information16
638: ,hr_transaction_api.get_varchar2_value
639: (p_transaction_step_id, 'P_VAL_INFORMATION17') val_information17
640: ,hr_transaction_api.get_varchar2_value
641: (p_transaction_step_id, 'P_VAL_INFORMATION18') val_information18
642: ,hr_transaction_api.get_varchar2_value
636: ,hr_transaction_api.get_varchar2_value
637: (p_transaction_step_id, 'P_VAL_INFORMATION16') val_information16
638: ,hr_transaction_api.get_varchar2_value
639: (p_transaction_step_id, 'P_VAL_INFORMATION17') val_information17
640: ,hr_transaction_api.get_varchar2_value
641: (p_transaction_step_id, 'P_VAL_INFORMATION18') val_information18
642: ,hr_transaction_api.get_varchar2_value
643: (p_transaction_step_id, 'P_VAL_INFORMATION19') val_information19
644: ,hr_transaction_api.get_varchar2_value
638: ,hr_transaction_api.get_varchar2_value
639: (p_transaction_step_id, 'P_VAL_INFORMATION17') val_information17
640: ,hr_transaction_api.get_varchar2_value
641: (p_transaction_step_id, 'P_VAL_INFORMATION18') val_information18
642: ,hr_transaction_api.get_varchar2_value
643: (p_transaction_step_id, 'P_VAL_INFORMATION19') val_information19
644: ,hr_transaction_api.get_varchar2_value
645: (p_transaction_step_id, 'P_VAL_INFORMATION20') val_information20
646: FROM DUAL;
640: ,hr_transaction_api.get_varchar2_value
641: (p_transaction_step_id, 'P_VAL_INFORMATION18') val_information18
642: ,hr_transaction_api.get_varchar2_value
643: (p_transaction_step_id, 'P_VAL_INFORMATION19') val_information19
644: ,hr_transaction_api.get_varchar2_value
645: (p_transaction_step_id, 'P_VAL_INFORMATION20') val_information20
646: FROM DUAL;
647:
648: RETURN csr;
2082: l_trans_tbl(l_count).param_value := x_vehicle_allocation_id;
2083: l_trans_tbl(l_count).param_data_type := 'NUMBER';
2084:
2085: IF x_transaction_id is NULl THEN
2086: hr_transaction_api.create_transaction(
2087: p_validate => false
2088: ,p_creator_person_id => x_login_person_id
2089: ,p_transaction_privilege => 'PRIVATE'
2090: ,p_product_code => 'PQP'
2112: ,aname => 'TRANSACTION_ID'
2113: ,avalue => l_transaction_id);
2114: x_transaction_id := l_transaction_id;
2115: --Create transaction steps
2116: hr_transaction_api.create_transaction_step
2117: (p_validate => false
2118: ,p_creator_person_id => x_login_person_id
2119: ,p_transaction_id => l_transaction_id
2120: ,p_api_name => l_api_name
2139:
2140: FOR i in 1..l_trans_tbl.count
2141: LOOP
2142: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
2143: hr_transaction_api.set_varchar2_value
2144: (p_transaction_step_id => l_transaction_step_id
2145: ,p_person_id => x_person_id
2146: ,p_name => l_trans_tbl (i).param_name
2147: ,p_value => l_trans_tbl (i).param_value
2147: ,p_value => l_trans_tbl (i).param_value
2148: );
2149:
2150: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
2151: hr_transaction_api.set_date_value
2152: (
2153: p_transaction_step_id => l_transaction_step_id
2154: ,p_person_id => x_person_id
2155: ,p_name => l_trans_tbl (i).param_name
2158: -- ,p_original_value );
2159:
2160:
2161: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
2162: hr_transaction_api.set_number_value
2163: (
2164: p_transaction_step_id => l_transaction_step_id
2165: ,p_person_id => x_person_id
2166: ,p_name =>l_trans_tbl (i).param_name
3234: -- If there are no error messages then insert values into transaction table
3235: SAVEPOINT pqp_create_transaction;
3236: IF x_transaction_id is NULl THEN
3237: hr_utility.set_location('Entering create_transaction :',10);
3238: hr_transaction_api.create_transaction(
3239: p_validate => false
3240: ,p_creator_person_id => x_login_person_id
3241: ,p_transaction_privilege => 'PRIVATE'
3242: ,p_product_code => 'PQP'
3269:
3270: x_transaction_id := l_transaction_id;
3271: hr_utility.set_location('Leaving setitemattrnumber :',20);
3272: --Create transaction steps
3273: hr_transaction_api.create_transaction_step
3274: (p_validate =>false
3275: ,p_creator_person_id =>x_login_person_id
3276: ,p_transaction_id =>l_transaction_id
3277: ,p_api_name =>l_api_name
3284: );
3285: hr_utility.set_location('Leaving create_transaction_step :',25);
3286: ELSE
3287: hr_utility.set_location('Entering update transaction :',10);
3288: hr_transaction_api.update_transaction
3289: (p_transaction_id => x_transaction_id
3290: ,p_status => x_status
3291: );
3292: hr_utility.set_location('leaving update transaction :',15);
3304: LOOP
3305: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
3306: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);
3307: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);
3308: hr_transaction_api.set_varchar2_value
3309: (p_transaction_step_id =>l_transaction_step_id
3310: ,p_person_id =>x_person_id
3311: ,p_name =>l_trans_tbl (i).param_name
3312: ,p_value =>l_trans_tbl (i).param_value
3316: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3317: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3318: hr_utility.set_location('Enter date Param Value||
3319: l_trans_tbl (i).param_value :',10);
3320: hr_transaction_api.set_date_value
3321: (
3322: p_transaction_step_id => l_transaction_step_id
3323: ,p_person_id => x_person_id
3324: ,p_name => l_trans_tbl (i).param_name
3327: hr_utility.set_location('Leaving param date :',20);
3328: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3329: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3330: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3331: hr_transaction_api.set_number_value
3332: (
3333: p_transaction_step_id => l_transaction_step_id
3334: ,p_person_id => x_person_id
3335: ,p_name =>l_trans_tbl (i).param_name
3399: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3400: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
3401: l_effective_date DATE;
3402: BEGIN
3403: l_person_id := hr_transaction_api.get_number_value (
3404: p_transaction_step_id => p_transaction_step_id,
3405: p_name =>'P_PERSON_ID' );
3406:
3407: l_effective_date := hr_transaction_api.get_date_value (
3403: l_person_id := hr_transaction_api.get_number_value (
3404: p_transaction_step_id => p_transaction_step_id,
3405: p_name =>'P_PERSON_ID' );
3406:
3407: l_effective_date := hr_transaction_api.get_date_value (
3408: p_transaction_step_id => p_transaction_step_id,
3409: p_name =>'P_EFFECTIVE_DATE' );
3410: l_assignment_id :=hr_transaction_api.get_number_value (
3411: p_transaction_step_id => p_transaction_step_id,
3406:
3407: l_effective_date := hr_transaction_api.get_date_value (
3408: p_transaction_step_id => p_transaction_step_id,
3409: p_name =>'P_EFFECTIVE_DATE' );
3410: l_assignment_id :=hr_transaction_api.get_number_value (
3411: p_transaction_step_id => p_transaction_step_id,
3412: p_name =>'P_ASSIGNMENT_ID' );
3413:
3414: l_business_group_id :=hr_transaction_api.get_number_value (
3410: l_assignment_id :=hr_transaction_api.get_number_value (
3411: p_transaction_step_id => p_transaction_step_id,
3412: p_name =>'P_ASSIGNMENT_ID' );
3413:
3414: l_business_group_id :=hr_transaction_api.get_number_value (
3415: p_transaction_step_id => p_transaction_step_id,
3416: p_name =>'P_BUSINESS_GROUP_ID' );
3417: l_allocation_id :=hr_transaction_api.get_number_value (
3418: p_transaction_step_id => p_transaction_step_id,
3413:
3414: l_business_group_id :=hr_transaction_api.get_number_value (
3415: p_transaction_step_id => p_transaction_step_id,
3416: p_name =>'P_BUSINESS_GROUP_ID' );
3417: l_allocation_id :=hr_transaction_api.get_number_value (
3418: p_transaction_step_id => p_transaction_step_id,
3419: p_name =>'P_ALLOCATION_ID' );
3420:
3421:
3615: l_transaction_id :=get_transaction_id(
3616: p_transaction_step_id =>p_transaction_step_id);
3617:
3618:
3619: l_person_id := hr_transaction_api.get_number_value (
3620: p_transaction_step_id => p_transaction_step_id,
3621: p_name =>'P_PERSON_ID' );
3622:
3623:
3620: p_transaction_step_id => p_transaction_step_id,
3621: p_name =>'P_PERSON_ID' );
3622:
3623:
3624: l_effective_date := hr_transaction_api.get_date_value (
3625: p_transaction_step_id => p_transaction_step_id,
3626: p_name =>'P_EFFECTIVE_DATE' );
3627:
3628: l_registration_number := hr_transaction_api.get_varchar2_value (
3624: l_effective_date := hr_transaction_api.get_date_value (
3625: p_transaction_step_id => p_transaction_step_id,
3626: p_name =>'P_EFFECTIVE_DATE' );
3627:
3628: l_registration_number := hr_transaction_api.get_varchar2_value (
3629: p_transaction_step_id => p_transaction_step_id,
3630: p_name =>'P_REGISTRATION_NUMBER' );
3631:
3632: l_vehicle_type := hr_transaction_api.get_varchar2_value (
3628: l_registration_number := hr_transaction_api.get_varchar2_value (
3629: p_transaction_step_id => p_transaction_step_id,
3630: p_name =>'P_REGISTRATION_NUMBER' );
3631:
3632: l_vehicle_type := hr_transaction_api.get_varchar2_value (
3633: p_transaction_step_id => p_transaction_step_id,
3634: p_name =>'P_VEHICLE_TYPE' );
3635:
3636: l_vehicle_id_number := hr_transaction_api.get_varchar2_value (
3632: l_vehicle_type := hr_transaction_api.get_varchar2_value (
3633: p_transaction_step_id => p_transaction_step_id,
3634: p_name =>'P_VEHICLE_TYPE' );
3635:
3636: l_vehicle_id_number := hr_transaction_api.get_varchar2_value (
3637: p_transaction_step_id => p_transaction_step_id,
3638: p_name =>'P_VEHICLE_ID_NUMBER' );
3639: l_business_group_id := hr_transaction_api.get_number_value (
3640: p_transaction_step_id => p_transaction_step_id,
3635:
3636: l_vehicle_id_number := hr_transaction_api.get_varchar2_value (
3637: p_transaction_step_id => p_transaction_step_id,
3638: p_name =>'P_VEHICLE_ID_NUMBER' );
3639: l_business_group_id := hr_transaction_api.get_number_value (
3640: p_transaction_step_id => p_transaction_step_id,
3641: p_name =>'P_BUSINESS_GROUP_ID');
3642:
3643: l_make := hr_transaction_api.get_varchar2_value (
3639: l_business_group_id := hr_transaction_api.get_number_value (
3640: p_transaction_step_id => p_transaction_step_id,
3641: p_name =>'P_BUSINESS_GROUP_ID');
3642:
3643: l_make := hr_transaction_api.get_varchar2_value (
3644: p_transaction_step_id => p_transaction_step_id,
3645: p_name =>'P_MAKE' );
3646:
3647: l_engine_capacity_in_cc := hr_transaction_api.get_number_value (
3643: l_make := hr_transaction_api.get_varchar2_value (
3644: p_transaction_step_id => p_transaction_step_id,
3645: p_name =>'P_MAKE' );
3646:
3647: l_engine_capacity_in_cc := hr_transaction_api.get_number_value (
3648: p_transaction_step_id => p_transaction_step_id,
3649: p_name =>'P_ENGINE_CAPACITY_IN_CC');
3650:
3651: l_fuel_type := hr_transaction_api.get_varchar2_value (
3647: l_engine_capacity_in_cc := hr_transaction_api.get_number_value (
3648: p_transaction_step_id => p_transaction_step_id,
3649: p_name =>'P_ENGINE_CAPACITY_IN_CC');
3650:
3651: l_fuel_type := hr_transaction_api.get_varchar2_value (
3652: p_transaction_step_id => p_transaction_step_id,
3653: p_name =>'P_FUEL_TYPE');
3654:
3655: l_currency_code := hr_transaction_api.get_varchar2_value (
3651: l_fuel_type := hr_transaction_api.get_varchar2_value (
3652: p_transaction_step_id => p_transaction_step_id,
3653: p_name =>'P_FUEL_TYPE');
3654:
3655: l_currency_code := hr_transaction_api.get_varchar2_value (
3656: p_transaction_step_id => p_transaction_step_id,
3657: p_name =>'P_CURRENCY_CODE');
3658:
3659: l_model := hr_transaction_api.get_varchar2_value (
3655: l_currency_code := hr_transaction_api.get_varchar2_value (
3656: p_transaction_step_id => p_transaction_step_id,
3657: p_name =>'P_CURRENCY_CODE');
3658:
3659: l_model := hr_transaction_api.get_varchar2_value (
3660: p_transaction_step_id => p_transaction_step_id,
3661: p_name =>'P_MODEL' );
3662:
3663: l_initial_registration := hr_transaction_api.get_date_value (
3659: l_model := hr_transaction_api.get_varchar2_value (
3660: p_transaction_step_id => p_transaction_step_id,
3661: p_name =>'P_MODEL' );
3662:
3663: l_initial_registration := hr_transaction_api.get_date_value (
3664: p_transaction_step_id => p_transaction_step_id,
3665: p_name =>'P_INITIAL_REGISTRATION');
3666:
3667: l_last_registration_renew_date := hr_transaction_api.get_date_value (
3663: l_initial_registration := hr_transaction_api.get_date_value (
3664: p_transaction_step_id => p_transaction_step_id,
3665: p_name =>'P_INITIAL_REGISTRATION');
3666:
3667: l_last_registration_renew_date := hr_transaction_api.get_date_value (
3668: p_transaction_step_id => p_transaction_step_id,
3669: p_name =>'P_LAST_REGISTRATION_RENEW_DATE');
3670:
3671: l_fiscal_ratings := hr_transaction_api.get_number_value (
3667: l_last_registration_renew_date := hr_transaction_api.get_date_value (
3668: p_transaction_step_id => p_transaction_step_id,
3669: p_name =>'P_LAST_REGISTRATION_RENEW_DATE');
3670:
3671: l_fiscal_ratings := hr_transaction_api.get_number_value (
3672: p_transaction_step_id => p_transaction_step_id,
3673: p_name =>'P_FISCAL_RATINGS' );
3674:
3675: l_vehicle_ownership := hr_transaction_api.get_varchar2_value (
3671: l_fiscal_ratings := hr_transaction_api.get_number_value (
3672: p_transaction_step_id => p_transaction_step_id,
3673: p_name =>'P_FISCAL_RATINGS' );
3674:
3675: l_vehicle_ownership := hr_transaction_api.get_varchar2_value (
3676: p_transaction_step_id => p_transaction_step_id,
3677: p_name =>'P_VEHICLE_OWNERSHIP');
3678:
3679: l_shared_vehicle := hr_transaction_api.get_varchar2_value (
3675: l_vehicle_ownership := hr_transaction_api.get_varchar2_value (
3676: p_transaction_step_id => p_transaction_step_id,
3677: p_name =>'P_VEHICLE_OWNERSHIP');
3678:
3679: l_shared_vehicle := hr_transaction_api.get_varchar2_value (
3680: p_transaction_step_id => p_transaction_step_id,
3681: p_name =>'P_SHARED_VEHICLE' );
3682:
3683: l_color := hr_transaction_api.get_varchar2_value (
3679: l_shared_vehicle := hr_transaction_api.get_varchar2_value (
3680: p_transaction_step_id => p_transaction_step_id,
3681: p_name =>'P_SHARED_VEHICLE' );
3682:
3683: l_color := hr_transaction_api.get_varchar2_value (
3684: p_transaction_step_id => p_transaction_step_id,
3685: p_name =>'P_COLOR' );
3686:
3687: l_seating_capacity := hr_transaction_api.get_number_value (
3683: l_color := hr_transaction_api.get_varchar2_value (
3684: p_transaction_step_id => p_transaction_step_id,
3685: p_name =>'P_COLOR' );
3686:
3687: l_seating_capacity := hr_transaction_api.get_number_value (
3688: p_transaction_step_id => p_transaction_step_id,
3689: p_name =>'P_SEATING_CAPACITY' );
3690:
3691: l_weight := hr_transaction_api.get_number_value (
3687: l_seating_capacity := hr_transaction_api.get_number_value (
3688: p_transaction_step_id => p_transaction_step_id,
3689: p_name =>'P_SEATING_CAPACITY' );
3690:
3691: l_weight := hr_transaction_api.get_number_value (
3692: p_transaction_step_id => p_transaction_step_id,
3693: p_name =>'P_WEIGHT' );
3694:
3695: l_weight_uom := hr_transaction_api.get_varchar2_value (
3691: l_weight := hr_transaction_api.get_number_value (
3692: p_transaction_step_id => p_transaction_step_id,
3693: p_name =>'P_WEIGHT' );
3694:
3695: l_weight_uom := hr_transaction_api.get_varchar2_value (
3696: p_transaction_step_id => p_transaction_step_id,
3697: p_name =>'P_WEIGHT_UOM' );
3698:
3699: l_model_year := hr_transaction_api.get_number_value (
3695: l_weight_uom := hr_transaction_api.get_varchar2_value (
3696: p_transaction_step_id => p_transaction_step_id,
3697: p_name =>'P_WEIGHT_UOM' );
3698:
3699: l_model_year := hr_transaction_api.get_number_value (
3700: p_transaction_step_id => p_transaction_step_id,
3701: p_name =>'P_MODEL_YEAR' );
3702:
3703: l_insurance_number := hr_transaction_api.get_varchar2_value (
3699: l_model_year := hr_transaction_api.get_number_value (
3700: p_transaction_step_id => p_transaction_step_id,
3701: p_name =>'P_MODEL_YEAR' );
3702:
3703: l_insurance_number := hr_transaction_api.get_varchar2_value (
3704: p_transaction_step_id => p_transaction_step_id,
3705: p_name =>'P_INSURANCE_NUMBER' );
3706:
3707: l_insurance_expiry_date := hr_transaction_api.get_date_value (
3703: l_insurance_number := hr_transaction_api.get_varchar2_value (
3704: p_transaction_step_id => p_transaction_step_id,
3705: p_name =>'P_INSURANCE_NUMBER' );
3706:
3707: l_insurance_expiry_date := hr_transaction_api.get_date_value (
3708: p_transaction_step_id => p_transaction_step_id,
3709: p_name =>'P_INSURANCE_EXPIRY_DATE' );
3710:
3711: l_taxation_method := hr_transaction_api.get_varchar2_value (
3707: l_insurance_expiry_date := hr_transaction_api.get_date_value (
3708: p_transaction_step_id => p_transaction_step_id,
3709: p_name =>'P_INSURANCE_EXPIRY_DATE' );
3710:
3711: l_taxation_method := hr_transaction_api.get_varchar2_value (
3712: p_transaction_step_id => p_transaction_step_id,
3713: p_name =>'P_TAXATION_METHOD');
3714:
3715: l_comments := hr_transaction_api.get_varchar2_value (
3711: l_taxation_method := hr_transaction_api.get_varchar2_value (
3712: p_transaction_step_id => p_transaction_step_id,
3713: p_name =>'P_TAXATION_METHOD');
3714:
3715: l_comments := hr_transaction_api.get_varchar2_value (
3716: p_transaction_step_id => p_transaction_step_id,
3717: p_name =>'P_COMMENTS' );
3718:
3719: l_vre_attribute_category := hr_transaction_api.get_varchar2_value (
3715: l_comments := hr_transaction_api.get_varchar2_value (
3716: p_transaction_step_id => p_transaction_step_id,
3717: p_name =>'P_COMMENTS' );
3718:
3719: l_vre_attribute_category := hr_transaction_api.get_varchar2_value (
3720: p_transaction_step_id => p_transaction_step_id,
3721: p_name =>'P_VRE_ATTRIBUTE_CATEGORY' );
3722:
3723: l_vre_attribute1 := hr_transaction_api.get_varchar2_value (
3719: l_vre_attribute_category := hr_transaction_api.get_varchar2_value (
3720: p_transaction_step_id => p_transaction_step_id,
3721: p_name =>'P_VRE_ATTRIBUTE_CATEGORY' );
3722:
3723: l_vre_attribute1 := hr_transaction_api.get_varchar2_value (
3724: p_transaction_step_id => p_transaction_step_id,
3725: p_name =>'P_VRE_ATTRIBUTE1' );
3726:
3727: l_vre_attribute2 := hr_transaction_api.get_varchar2_value (
3723: l_vre_attribute1 := hr_transaction_api.get_varchar2_value (
3724: p_transaction_step_id => p_transaction_step_id,
3725: p_name =>'P_VRE_ATTRIBUTE1' );
3726:
3727: l_vre_attribute2 := hr_transaction_api.get_varchar2_value (
3728: p_transaction_step_id => p_transaction_step_id,
3729: p_name =>'P_VRE_ATTRIBUTE2' );
3730:
3731: l_vre_attribute3 := hr_transaction_api.get_varchar2_value (
3727: l_vre_attribute2 := hr_transaction_api.get_varchar2_value (
3728: p_transaction_step_id => p_transaction_step_id,
3729: p_name =>'P_VRE_ATTRIBUTE2' );
3730:
3731: l_vre_attribute3 := hr_transaction_api.get_varchar2_value (
3732: p_transaction_step_id => p_transaction_step_id,
3733: p_name =>'P_VRE_ATTRIBUTE3' );
3734:
3735: l_vre_attribute4 := hr_transaction_api.get_varchar2_value (
3731: l_vre_attribute3 := hr_transaction_api.get_varchar2_value (
3732: p_transaction_step_id => p_transaction_step_id,
3733: p_name =>'P_VRE_ATTRIBUTE3' );
3734:
3735: l_vre_attribute4 := hr_transaction_api.get_varchar2_value (
3736: p_transaction_step_id => p_transaction_step_id,
3737: p_name =>'P_VRE_ATTRIBUTE4' );
3738:
3739:
3736: p_transaction_step_id => p_transaction_step_id,
3737: p_name =>'P_VRE_ATTRIBUTE4' );
3738:
3739:
3740: l_vre_attribute5 := hr_transaction_api.get_varchar2_value (
3741: p_transaction_step_id => p_transaction_step_id,
3742: p_name =>'P_VRE_ATTRIBUTE5' );
3743:
3744: l_vre_attribute6 := hr_transaction_api.get_varchar2_value (
3740: l_vre_attribute5 := hr_transaction_api.get_varchar2_value (
3741: p_transaction_step_id => p_transaction_step_id,
3742: p_name =>'P_VRE_ATTRIBUTE5' );
3743:
3744: l_vre_attribute6 := hr_transaction_api.get_varchar2_value (
3745: p_transaction_step_id => p_transaction_step_id,
3746: p_name =>'P_VRE_ATTRIBUTE6' );
3747:
3748: l_vre_attribute7 := hr_transaction_api.get_varchar2_value (
3744: l_vre_attribute6 := hr_transaction_api.get_varchar2_value (
3745: p_transaction_step_id => p_transaction_step_id,
3746: p_name =>'P_VRE_ATTRIBUTE6' );
3747:
3748: l_vre_attribute7 := hr_transaction_api.get_varchar2_value (
3749: p_transaction_step_id => p_transaction_step_id,
3750: p_name =>'P_VRE_ATTRIBUTE7' );
3751:
3752: l_vre_attribute8 := hr_transaction_api.get_varchar2_value (
3748: l_vre_attribute7 := hr_transaction_api.get_varchar2_value (
3749: p_transaction_step_id => p_transaction_step_id,
3750: p_name =>'P_VRE_ATTRIBUTE7' );
3751:
3752: l_vre_attribute8 := hr_transaction_api.get_varchar2_value (
3753: p_transaction_step_id => p_transaction_step_id,
3754: p_name =>'P_VRE_ATTRIBUTE8' );
3755:
3756: l_vre_attribute9 := hr_transaction_api.get_varchar2_value (
3752: l_vre_attribute8 := hr_transaction_api.get_varchar2_value (
3753: p_transaction_step_id => p_transaction_step_id,
3754: p_name =>'P_VRE_ATTRIBUTE8' );
3755:
3756: l_vre_attribute9 := hr_transaction_api.get_varchar2_value (
3757: p_transaction_step_id => p_transaction_step_id,
3758: p_name =>'P_VRE_ATTRIBUTE9' );
3759:
3760: l_vre_attribute10 := hr_transaction_api.get_varchar2_value (
3756: l_vre_attribute9 := hr_transaction_api.get_varchar2_value (
3757: p_transaction_step_id => p_transaction_step_id,
3758: p_name =>'P_VRE_ATTRIBUTE9' );
3759:
3760: l_vre_attribute10 := hr_transaction_api.get_varchar2_value (
3761: p_transaction_step_id => p_transaction_step_id,
3762: p_name =>'P_VRE_ATTRIBUTE10' );
3763:
3764: l_vre_attribute11 := hr_transaction_api.get_varchar2_value (
3760: l_vre_attribute10 := hr_transaction_api.get_varchar2_value (
3761: p_transaction_step_id => p_transaction_step_id,
3762: p_name =>'P_VRE_ATTRIBUTE10' );
3763:
3764: l_vre_attribute11 := hr_transaction_api.get_varchar2_value (
3765: p_transaction_step_id => p_transaction_step_id,
3766: p_name =>'P_VRE_ATTRIBUTE11' );
3767:
3768: l_vre_attribute12 := hr_transaction_api.get_varchar2_value (
3764: l_vre_attribute11 := hr_transaction_api.get_varchar2_value (
3765: p_transaction_step_id => p_transaction_step_id,
3766: p_name =>'P_VRE_ATTRIBUTE11' );
3767:
3768: l_vre_attribute12 := hr_transaction_api.get_varchar2_value (
3769: p_transaction_step_id => p_transaction_step_id,
3770: p_name =>'P_VRE_ATTRIBUTE12' );
3771:
3772: l_vre_attribute13 := hr_transaction_api.get_varchar2_value (
3768: l_vre_attribute12 := hr_transaction_api.get_varchar2_value (
3769: p_transaction_step_id => p_transaction_step_id,
3770: p_name =>'P_VRE_ATTRIBUTE12' );
3771:
3772: l_vre_attribute13 := hr_transaction_api.get_varchar2_value (
3773: p_transaction_step_id => p_transaction_step_id,
3774: p_name =>'P_VRE_ATTRIBUTE13' );
3775:
3776: l_vre_attribute14 := hr_transaction_api.get_varchar2_value (
3772: l_vre_attribute13 := hr_transaction_api.get_varchar2_value (
3773: p_transaction_step_id => p_transaction_step_id,
3774: p_name =>'P_VRE_ATTRIBUTE13' );
3775:
3776: l_vre_attribute14 := hr_transaction_api.get_varchar2_value (
3777: p_transaction_step_id => p_transaction_step_id,
3778: p_name =>'P_VRE_ATTRIBUTE14' );
3779:
3780: l_vre_attribute15 := hr_transaction_api.get_varchar2_value (
3776: l_vre_attribute14 := hr_transaction_api.get_varchar2_value (
3777: p_transaction_step_id => p_transaction_step_id,
3778: p_name =>'P_VRE_ATTRIBUTE14' );
3779:
3780: l_vre_attribute15 := hr_transaction_api.get_varchar2_value (
3781: p_transaction_step_id => p_transaction_step_id,
3782: p_name =>'P_VRE_ATTRIBUTE15' );
3783:
3784: l_vre_attribute16 := hr_transaction_api.get_varchar2_value (
3780: l_vre_attribute15 := hr_transaction_api.get_varchar2_value (
3781: p_transaction_step_id => p_transaction_step_id,
3782: p_name =>'P_VRE_ATTRIBUTE15' );
3783:
3784: l_vre_attribute16 := hr_transaction_api.get_varchar2_value (
3785: p_transaction_step_id => p_transaction_step_id,
3786: p_name =>'P_VRE_ATTRIBUTE16' );
3787:
3788: l_vre_attribute17 := hr_transaction_api.get_varchar2_value (
3784: l_vre_attribute16 := hr_transaction_api.get_varchar2_value (
3785: p_transaction_step_id => p_transaction_step_id,
3786: p_name =>'P_VRE_ATTRIBUTE16' );
3787:
3788: l_vre_attribute17 := hr_transaction_api.get_varchar2_value (
3789: p_transaction_step_id => p_transaction_step_id,
3790: p_name =>'P_VRE_ATTRIBUTE17' );
3791:
3792: l_vre_attribute18 := hr_transaction_api.get_varchar2_value (
3788: l_vre_attribute17 := hr_transaction_api.get_varchar2_value (
3789: p_transaction_step_id => p_transaction_step_id,
3790: p_name =>'P_VRE_ATTRIBUTE17' );
3791:
3792: l_vre_attribute18 := hr_transaction_api.get_varchar2_value (
3793: p_transaction_step_id => p_transaction_step_id,
3794: p_name =>'P_VRE_ATTRIBUTE18' );
3795:
3796: l_vre_attribute19 := hr_transaction_api.get_varchar2_value (
3792: l_vre_attribute18 := hr_transaction_api.get_varchar2_value (
3793: p_transaction_step_id => p_transaction_step_id,
3794: p_name =>'P_VRE_ATTRIBUTE18' );
3795:
3796: l_vre_attribute19 := hr_transaction_api.get_varchar2_value (
3797: p_transaction_step_id => p_transaction_step_id,
3798: p_name =>'P_VRE_ATTRIBUTE19' );
3799:
3800: l_vre_attribute20 := hr_transaction_api.get_varchar2_value (
3796: l_vre_attribute19 := hr_transaction_api.get_varchar2_value (
3797: p_transaction_step_id => p_transaction_step_id,
3798: p_name =>'P_VRE_ATTRIBUTE19' );
3799:
3800: l_vre_attribute20 := hr_transaction_api.get_varchar2_value (
3801: p_transaction_step_id => p_transaction_step_id,
3802: p_name =>'P_VRE_ATTRIBUTE20' );
3803:
3804: l_vre_information_category := hr_transaction_api.get_varchar2_value (
3800: l_vre_attribute20 := hr_transaction_api.get_varchar2_value (
3801: p_transaction_step_id => p_transaction_step_id,
3802: p_name =>'P_VRE_ATTRIBUTE20' );
3803:
3804: l_vre_information_category := hr_transaction_api.get_varchar2_value (
3805: p_transaction_step_id => p_transaction_step_id,
3806: p_name =>'P_VRE_INFORMATION_CATEGORY' );
3807:
3808: l_vre_information1 := hr_transaction_api.get_varchar2_value (
3804: l_vre_information_category := hr_transaction_api.get_varchar2_value (
3805: p_transaction_step_id => p_transaction_step_id,
3806: p_name =>'P_VRE_INFORMATION_CATEGORY' );
3807:
3808: l_vre_information1 := hr_transaction_api.get_varchar2_value (
3809: p_transaction_step_id => p_transaction_step_id,
3810: p_name =>'P_VRE_INFORMATION1' );
3811:
3812: l_vre_information2 := hr_transaction_api.get_varchar2_value (
3808: l_vre_information1 := hr_transaction_api.get_varchar2_value (
3809: p_transaction_step_id => p_transaction_step_id,
3810: p_name =>'P_VRE_INFORMATION1' );
3811:
3812: l_vre_information2 := hr_transaction_api.get_varchar2_value (
3813: p_transaction_step_id => p_transaction_step_id,
3814: p_name =>'P_VRE_INFORMATION2' );
3815:
3816: l_vre_information3 := hr_transaction_api.get_varchar2_value (
3812: l_vre_information2 := hr_transaction_api.get_varchar2_value (
3813: p_transaction_step_id => p_transaction_step_id,
3814: p_name =>'P_VRE_INFORMATION2' );
3815:
3816: l_vre_information3 := hr_transaction_api.get_varchar2_value (
3817: p_transaction_step_id => p_transaction_step_id,
3818: p_name =>'P_VRE_INFORMATION3' );
3819:
3820: l_vre_information4 := hr_transaction_api.get_varchar2_value (
3816: l_vre_information3 := hr_transaction_api.get_varchar2_value (
3817: p_transaction_step_id => p_transaction_step_id,
3818: p_name =>'P_VRE_INFORMATION3' );
3819:
3820: l_vre_information4 := hr_transaction_api.get_varchar2_value (
3821: p_transaction_step_id => p_transaction_step_id,
3822: p_name =>'P_VRE_INFORMATION4' );
3823:
3824: l_vre_information5 := hr_transaction_api.get_varchar2_value (
3820: l_vre_information4 := hr_transaction_api.get_varchar2_value (
3821: p_transaction_step_id => p_transaction_step_id,
3822: p_name =>'P_VRE_INFORMATION4' );
3823:
3824: l_vre_information5 := hr_transaction_api.get_varchar2_value (
3825: p_transaction_step_id => p_transaction_step_id,
3826: p_name =>'P_VRE_INFORMATION5' );
3827:
3828: l_vre_information6 := hr_transaction_api.get_varchar2_value (
3824: l_vre_information5 := hr_transaction_api.get_varchar2_value (
3825: p_transaction_step_id => p_transaction_step_id,
3826: p_name =>'P_VRE_INFORMATION5' );
3827:
3828: l_vre_information6 := hr_transaction_api.get_varchar2_value (
3829: p_transaction_step_id => p_transaction_step_id,
3830: p_name =>'P_VRE_INFORMATION6' );
3831:
3832: l_vre_information7 := hr_transaction_api.get_varchar2_value (
3828: l_vre_information6 := hr_transaction_api.get_varchar2_value (
3829: p_transaction_step_id => p_transaction_step_id,
3830: p_name =>'P_VRE_INFORMATION6' );
3831:
3832: l_vre_information7 := hr_transaction_api.get_varchar2_value (
3833: p_transaction_step_id => p_transaction_step_id,
3834: p_name =>'P_VRE_INFORMATION7' );
3835:
3836: l_vre_information8 := hr_transaction_api.get_varchar2_value (
3832: l_vre_information7 := hr_transaction_api.get_varchar2_value (
3833: p_transaction_step_id => p_transaction_step_id,
3834: p_name =>'P_VRE_INFORMATION7' );
3835:
3836: l_vre_information8 := hr_transaction_api.get_varchar2_value (
3837: p_transaction_step_id => p_transaction_step_id,
3838: p_name =>'P_VRE_INFORMATION8' );
3839:
3840: l_vre_information9 := hr_transaction_api.get_varchar2_value (
3836: l_vre_information8 := hr_transaction_api.get_varchar2_value (
3837: p_transaction_step_id => p_transaction_step_id,
3838: p_name =>'P_VRE_INFORMATION8' );
3839:
3840: l_vre_information9 := hr_transaction_api.get_varchar2_value (
3841: p_transaction_step_id => p_transaction_step_id,
3842: p_name =>'P_VRE_INFORMATION9' );
3843:
3844: l_vre_information10 := hr_transaction_api.get_varchar2_value (
3840: l_vre_information9 := hr_transaction_api.get_varchar2_value (
3841: p_transaction_step_id => p_transaction_step_id,
3842: p_name =>'P_VRE_INFORMATION9' );
3843:
3844: l_vre_information10 := hr_transaction_api.get_varchar2_value (
3845: p_transaction_step_id => p_transaction_step_id,
3846: p_name =>'P_VRE_INFORMATION10' );
3847:
3848: l_vre_information11 := hr_transaction_api.get_varchar2_value (
3844: l_vre_information10 := hr_transaction_api.get_varchar2_value (
3845: p_transaction_step_id => p_transaction_step_id,
3846: p_name =>'P_VRE_INFORMATION10' );
3847:
3848: l_vre_information11 := hr_transaction_api.get_varchar2_value (
3849: p_transaction_step_id => p_transaction_step_id,
3850: p_name =>'P_VRE_INFORMATION11' );
3851:
3852: l_vre_information12 := hr_transaction_api.get_varchar2_value (
3848: l_vre_information11 := hr_transaction_api.get_varchar2_value (
3849: p_transaction_step_id => p_transaction_step_id,
3850: p_name =>'P_VRE_INFORMATION11' );
3851:
3852: l_vre_information12 := hr_transaction_api.get_varchar2_value (
3853: p_transaction_step_id => p_transaction_step_id,
3854: p_name =>'P_VRE_INFORMATION12' );
3855:
3856: l_vre_information13 := hr_transaction_api.get_varchar2_value (
3852: l_vre_information12 := hr_transaction_api.get_varchar2_value (
3853: p_transaction_step_id => p_transaction_step_id,
3854: p_name =>'P_VRE_INFORMATION12' );
3855:
3856: l_vre_information13 := hr_transaction_api.get_varchar2_value (
3857: p_transaction_step_id => p_transaction_step_id,
3858: p_name =>'P_VRE_INFORMATION13' );
3859:
3860: l_vre_information14 := hr_transaction_api.get_varchar2_value (
3856: l_vre_information13 := hr_transaction_api.get_varchar2_value (
3857: p_transaction_step_id => p_transaction_step_id,
3858: p_name =>'P_VRE_INFORMATION13' );
3859:
3860: l_vre_information14 := hr_transaction_api.get_varchar2_value (
3861: p_transaction_step_id => p_transaction_step_id,
3862: p_name =>'P_VRE_INFORMATION14' );
3863:
3864: l_vre_information15 := hr_transaction_api.get_varchar2_value (
3860: l_vre_information14 := hr_transaction_api.get_varchar2_value (
3861: p_transaction_step_id => p_transaction_step_id,
3862: p_name =>'P_VRE_INFORMATION14' );
3863:
3864: l_vre_information15 := hr_transaction_api.get_varchar2_value (
3865: p_transaction_step_id => p_transaction_step_id,
3866: p_name =>'P_VRE_INFORMATION15' );
3867:
3868: l_vre_information16 := hr_transaction_api.get_varchar2_value (
3864: l_vre_information15 := hr_transaction_api.get_varchar2_value (
3865: p_transaction_step_id => p_transaction_step_id,
3866: p_name =>'P_VRE_INFORMATION15' );
3867:
3868: l_vre_information16 := hr_transaction_api.get_varchar2_value (
3869: p_transaction_step_id => p_transaction_step_id,
3870: p_name =>'P_VRE_INFORMATION16' );
3871:
3872: l_vre_information17 := hr_transaction_api.get_varchar2_value (
3868: l_vre_information16 := hr_transaction_api.get_varchar2_value (
3869: p_transaction_step_id => p_transaction_step_id,
3870: p_name =>'P_VRE_INFORMATION16' );
3871:
3872: l_vre_information17 := hr_transaction_api.get_varchar2_value (
3873: p_transaction_step_id => p_transaction_step_id,
3874: p_name =>'P_VRE_INFORMATION17' );
3875:
3876: l_vre_information18 := hr_transaction_api.get_varchar2_value (
3872: l_vre_information17 := hr_transaction_api.get_varchar2_value (
3873: p_transaction_step_id => p_transaction_step_id,
3874: p_name =>'P_VRE_INFORMATION17' );
3875:
3876: l_vre_information18 := hr_transaction_api.get_varchar2_value (
3877: p_transaction_step_id => p_transaction_step_id,
3878: p_name =>'P_VRE_INFORMATION18' );
3879:
3880:
3877: p_transaction_step_id => p_transaction_step_id,
3878: p_name =>'P_VRE_INFORMATION18' );
3879:
3880:
3881: l_vre_information19 := hr_transaction_api.get_varchar2_value (
3882: p_transaction_step_id => p_transaction_step_id,
3883: p_name =>'P_VRE_INFORMATION19' );
3884:
3885:
3882: p_transaction_step_id => p_transaction_step_id,
3883: p_name =>'P_VRE_INFORMATION19' );
3884:
3885:
3886: l_vre_information20 := hr_transaction_api.get_varchar2_value (
3887: p_transaction_step_id => p_transaction_step_id,
3888: p_name =>'P_VRE_INFORMATION20' );
3889:
3890:
3887: p_transaction_step_id => p_transaction_step_id,
3888: p_name =>'P_VRE_INFORMATION20' );
3889:
3890:
3891: l_across_assignments := hr_transaction_api.get_varchar2_value (
3892: p_transaction_step_id => p_transaction_step_id,
3893: p_name =>'P_ACROSS_ASSIGNMENTS');
3894:
3895:
3892: p_transaction_step_id => p_transaction_step_id,
3893: p_name =>'P_ACROSS_ASSIGNMENTS');
3894:
3895:
3896: l_usage_type := hr_transaction_api.get_varchar2_value (
3897: p_transaction_step_id => p_transaction_step_id,
3898: p_name =>'P_USAGE_TYPE');
3899:
3900: l_default_vehicle := hr_transaction_api.get_varchar2_value (
3896: l_usage_type := hr_transaction_api.get_varchar2_value (
3897: p_transaction_step_id => p_transaction_step_id,
3898: p_name =>'P_USAGE_TYPE');
3899:
3900: l_default_vehicle := hr_transaction_api.get_varchar2_value (
3901: p_transaction_step_id => p_transaction_step_id,
3902: p_name =>'P_DEFAULT_VEHICLE');
3903:
3904: l_fuel_card := hr_transaction_api.get_varchar2_value (
3900: l_default_vehicle := hr_transaction_api.get_varchar2_value (
3901: p_transaction_step_id => p_transaction_step_id,
3902: p_name =>'P_DEFAULT_VEHICLE');
3903:
3904: l_fuel_card := hr_transaction_api.get_varchar2_value (
3905: p_transaction_step_id => p_transaction_step_id,
3906: p_name =>'P_FUEL_CARD');
3907:
3908: l_fuel_card_number := hr_transaction_api.get_varchar2_value (
3904: l_fuel_card := hr_transaction_api.get_varchar2_value (
3905: p_transaction_step_id => p_transaction_step_id,
3906: p_name =>'P_FUEL_CARD');
3907:
3908: l_fuel_card_number := hr_transaction_api.get_varchar2_value (
3909: p_transaction_step_id => p_transaction_step_id,
3910: p_name =>'P_FUEL_CARD_NUMBER');
3911:
3912: l_val_attribute_category := hr_transaction_api.get_varchar2_value (
3908: l_fuel_card_number := hr_transaction_api.get_varchar2_value (
3909: p_transaction_step_id => p_transaction_step_id,
3910: p_name =>'P_FUEL_CARD_NUMBER');
3911:
3912: l_val_attribute_category := hr_transaction_api.get_varchar2_value (
3913: p_transaction_step_id => p_transaction_step_id,
3914: p_name =>'P_VAL_ATTRIBUTE_CATEGORY');
3915:
3916: l_val_attribute1 := hr_transaction_api.get_varchar2_value (
3912: l_val_attribute_category := hr_transaction_api.get_varchar2_value (
3913: p_transaction_step_id => p_transaction_step_id,
3914: p_name =>'P_VAL_ATTRIBUTE_CATEGORY');
3915:
3916: l_val_attribute1 := hr_transaction_api.get_varchar2_value (
3917: p_transaction_step_id => p_transaction_step_id,
3918: p_name =>'P_VAL_ATTRIBUTE1');
3919:
3920: l_val_attribute2 := hr_transaction_api.get_varchar2_value (
3916: l_val_attribute1 := hr_transaction_api.get_varchar2_value (
3917: p_transaction_step_id => p_transaction_step_id,
3918: p_name =>'P_VAL_ATTRIBUTE1');
3919:
3920: l_val_attribute2 := hr_transaction_api.get_varchar2_value (
3921: p_transaction_step_id => p_transaction_step_id,
3922: p_name =>'P_VAL_ATTRIBUTE2');
3923:
3924: l_val_attribute3 := hr_transaction_api.get_varchar2_value (
3920: l_val_attribute2 := hr_transaction_api.get_varchar2_value (
3921: p_transaction_step_id => p_transaction_step_id,
3922: p_name =>'P_VAL_ATTRIBUTE2');
3923:
3924: l_val_attribute3 := hr_transaction_api.get_varchar2_value (
3925: p_transaction_step_id => p_transaction_step_id,
3926: p_name =>'P_VAL_ATTRIBUTE3');
3927:
3928: l_val_attribute4 := hr_transaction_api.get_varchar2_value (
3924: l_val_attribute3 := hr_transaction_api.get_varchar2_value (
3925: p_transaction_step_id => p_transaction_step_id,
3926: p_name =>'P_VAL_ATTRIBUTE3');
3927:
3928: l_val_attribute4 := hr_transaction_api.get_varchar2_value (
3929: p_transaction_step_id => p_transaction_step_id,
3930: p_name =>'P_VAL_ATTRIBUTE4');
3931:
3932: l_val_attribute5 := hr_transaction_api.get_varchar2_value (
3928: l_val_attribute4 := hr_transaction_api.get_varchar2_value (
3929: p_transaction_step_id => p_transaction_step_id,
3930: p_name =>'P_VAL_ATTRIBUTE4');
3931:
3932: l_val_attribute5 := hr_transaction_api.get_varchar2_value (
3933: p_transaction_step_id => p_transaction_step_id,
3934: p_name =>'P_VAL_ATTRIBUTE5');
3935: l_val_attribute6 :=hr_transaction_api.get_varchar2_value (
3936: p_transaction_step_id => p_transaction_step_id,
3931:
3932: l_val_attribute5 := hr_transaction_api.get_varchar2_value (
3933: p_transaction_step_id => p_transaction_step_id,
3934: p_name =>'P_VAL_ATTRIBUTE5');
3935: l_val_attribute6 :=hr_transaction_api.get_varchar2_value (
3936: p_transaction_step_id => p_transaction_step_id,
3937: p_name =>'P_VAL_ATTRIBUTE6');
3938: l_val_attribute7 :=hr_transaction_api.get_varchar2_value (
3939: p_transaction_step_id => p_transaction_step_id,
3934: p_name =>'P_VAL_ATTRIBUTE5');
3935: l_val_attribute6 :=hr_transaction_api.get_varchar2_value (
3936: p_transaction_step_id => p_transaction_step_id,
3937: p_name =>'P_VAL_ATTRIBUTE6');
3938: l_val_attribute7 :=hr_transaction_api.get_varchar2_value (
3939: p_transaction_step_id => p_transaction_step_id,
3940: p_name =>'P_VAL_ATTRIBUTE7');
3941: l_val_attribute8 :=hr_transaction_api.get_varchar2_value (
3942: p_transaction_step_id => p_transaction_step_id,
3937: p_name =>'P_VAL_ATTRIBUTE6');
3938: l_val_attribute7 :=hr_transaction_api.get_varchar2_value (
3939: p_transaction_step_id => p_transaction_step_id,
3940: p_name =>'P_VAL_ATTRIBUTE7');
3941: l_val_attribute8 :=hr_transaction_api.get_varchar2_value (
3942: p_transaction_step_id => p_transaction_step_id,
3943: p_name =>'P_VAL_ATTRIBUTE8');
3944: l_val_attribute9 :=hr_transaction_api.get_varchar2_value (
3945: p_transaction_step_id => p_transaction_step_id,
3940: p_name =>'P_VAL_ATTRIBUTE7');
3941: l_val_attribute8 :=hr_transaction_api.get_varchar2_value (
3942: p_transaction_step_id => p_transaction_step_id,
3943: p_name =>'P_VAL_ATTRIBUTE8');
3944: l_val_attribute9 :=hr_transaction_api.get_varchar2_value (
3945: p_transaction_step_id => p_transaction_step_id,
3946: p_name =>'P_VAL_ATTRIBUTE9');
3947: l_val_attribute10 :=hr_transaction_api.get_varchar2_value (
3948: p_transaction_step_id => p_transaction_step_id,
3943: p_name =>'P_VAL_ATTRIBUTE8');
3944: l_val_attribute9 :=hr_transaction_api.get_varchar2_value (
3945: p_transaction_step_id => p_transaction_step_id,
3946: p_name =>'P_VAL_ATTRIBUTE9');
3947: l_val_attribute10 :=hr_transaction_api.get_varchar2_value (
3948: p_transaction_step_id => p_transaction_step_id,
3949: p_name =>'P_VAL_ATTRIBUTE10');
3950: l_val_attribute11 := hr_transaction_api.get_varchar2_value (
3951: p_transaction_step_id => p_transaction_step_id,
3946: p_name =>'P_VAL_ATTRIBUTE9');
3947: l_val_attribute10 :=hr_transaction_api.get_varchar2_value (
3948: p_transaction_step_id => p_transaction_step_id,
3949: p_name =>'P_VAL_ATTRIBUTE10');
3950: l_val_attribute11 := hr_transaction_api.get_varchar2_value (
3951: p_transaction_step_id => p_transaction_step_id,
3952: p_name =>'P_VAL_ATTRIBUTE11');
3953:
3954: l_val_attribute12 :=hr_transaction_api.get_varchar2_value (
3950: l_val_attribute11 := hr_transaction_api.get_varchar2_value (
3951: p_transaction_step_id => p_transaction_step_id,
3952: p_name =>'P_VAL_ATTRIBUTE11');
3953:
3954: l_val_attribute12 :=hr_transaction_api.get_varchar2_value (
3955: p_transaction_step_id => p_transaction_step_id,
3956: p_name =>'P_VAL_ATTRIBUTE12');
3957: l_val_attribute13 :=hr_transaction_api.get_varchar2_value (
3958: p_transaction_step_id => p_transaction_step_id,
3953:
3954: l_val_attribute12 :=hr_transaction_api.get_varchar2_value (
3955: p_transaction_step_id => p_transaction_step_id,
3956: p_name =>'P_VAL_ATTRIBUTE12');
3957: l_val_attribute13 :=hr_transaction_api.get_varchar2_value (
3958: p_transaction_step_id => p_transaction_step_id,
3959: p_name =>'P_VAL_ATTRIBUTE13');
3960: l_val_attribute14 :=hr_transaction_api.get_varchar2_value (
3961: p_transaction_step_id => p_transaction_step_id,
3956: p_name =>'P_VAL_ATTRIBUTE12');
3957: l_val_attribute13 :=hr_transaction_api.get_varchar2_value (
3958: p_transaction_step_id => p_transaction_step_id,
3959: p_name =>'P_VAL_ATTRIBUTE13');
3960: l_val_attribute14 :=hr_transaction_api.get_varchar2_value (
3961: p_transaction_step_id => p_transaction_step_id,
3962: p_name =>'P_VAL_ATTRIBUTE14');
3963: l_val_attribute15 :=hr_transaction_api.get_varchar2_value (
3964: p_transaction_step_id => p_transaction_step_id,
3959: p_name =>'P_VAL_ATTRIBUTE13');
3960: l_val_attribute14 :=hr_transaction_api.get_varchar2_value (
3961: p_transaction_step_id => p_transaction_step_id,
3962: p_name =>'P_VAL_ATTRIBUTE14');
3963: l_val_attribute15 :=hr_transaction_api.get_varchar2_value (
3964: p_transaction_step_id => p_transaction_step_id,
3965: p_name =>'P_VAL_ATTRIBUTE15');
3966: l_val_attribute16 :=hr_transaction_api.get_varchar2_value (
3967: p_transaction_step_id => p_transaction_step_id,
3962: p_name =>'P_VAL_ATTRIBUTE14');
3963: l_val_attribute15 :=hr_transaction_api.get_varchar2_value (
3964: p_transaction_step_id => p_transaction_step_id,
3965: p_name =>'P_VAL_ATTRIBUTE15');
3966: l_val_attribute16 :=hr_transaction_api.get_varchar2_value (
3967: p_transaction_step_id => p_transaction_step_id,
3968: p_name =>'P_VAL_ATTRIBUTE16');
3969: l_val_attribute17 :=hr_transaction_api.get_varchar2_value (
3970: p_transaction_step_id => p_transaction_step_id,
3965: p_name =>'P_VAL_ATTRIBUTE15');
3966: l_val_attribute16 :=hr_transaction_api.get_varchar2_value (
3967: p_transaction_step_id => p_transaction_step_id,
3968: p_name =>'P_VAL_ATTRIBUTE16');
3969: l_val_attribute17 :=hr_transaction_api.get_varchar2_value (
3970: p_transaction_step_id => p_transaction_step_id,
3971: p_name =>'P_VAL_ATTRIBUTE17');
3972: l_val_attribute18 :=hr_transaction_api.get_varchar2_value (
3973: p_transaction_step_id => p_transaction_step_id,
3968: p_name =>'P_VAL_ATTRIBUTE16');
3969: l_val_attribute17 :=hr_transaction_api.get_varchar2_value (
3970: p_transaction_step_id => p_transaction_step_id,
3971: p_name =>'P_VAL_ATTRIBUTE17');
3972: l_val_attribute18 :=hr_transaction_api.get_varchar2_value (
3973: p_transaction_step_id => p_transaction_step_id,
3974: p_name =>'P_VAL_ATTRIBUTE18');
3975: l_val_attribute19 :=hr_transaction_api.get_varchar2_value (
3976: p_transaction_step_id => p_transaction_step_id,
3971: p_name =>'P_VAL_ATTRIBUTE17');
3972: l_val_attribute18 :=hr_transaction_api.get_varchar2_value (
3973: p_transaction_step_id => p_transaction_step_id,
3974: p_name =>'P_VAL_ATTRIBUTE18');
3975: l_val_attribute19 :=hr_transaction_api.get_varchar2_value (
3976: p_transaction_step_id => p_transaction_step_id,
3977: p_name =>'P_VAL_ATTRIBUTE19');
3978: l_val_attribute20 :=hr_transaction_api.get_varchar2_value (
3979: p_transaction_step_id => p_transaction_step_id,
3974: p_name =>'P_VAL_ATTRIBUTE18');
3975: l_val_attribute19 :=hr_transaction_api.get_varchar2_value (
3976: p_transaction_step_id => p_transaction_step_id,
3977: p_name =>'P_VAL_ATTRIBUTE19');
3978: l_val_attribute20 :=hr_transaction_api.get_varchar2_value (
3979: p_transaction_step_id => p_transaction_step_id,
3980: p_name =>'P_VAL_ATTRIBUTE20');
3981: l_val_information_category := hr_transaction_api.get_varchar2_value (
3982: p_transaction_step_id => p_transaction_step_id,
3977: p_name =>'P_VAL_ATTRIBUTE19');
3978: l_val_attribute20 :=hr_transaction_api.get_varchar2_value (
3979: p_transaction_step_id => p_transaction_step_id,
3980: p_name =>'P_VAL_ATTRIBUTE20');
3981: l_val_information_category := hr_transaction_api.get_varchar2_value (
3982: p_transaction_step_id => p_transaction_step_id,
3983: p_name =>'P_VAL_INFORMATION_CATEGORY');
3984:
3985: l_val_information1 := hr_transaction_api.get_varchar2_value (
3981: l_val_information_category := hr_transaction_api.get_varchar2_value (
3982: p_transaction_step_id => p_transaction_step_id,
3983: p_name =>'P_VAL_INFORMATION_CATEGORY');
3984:
3985: l_val_information1 := hr_transaction_api.get_varchar2_value (
3986: p_transaction_step_id => p_transaction_step_id,
3987: p_name =>'P_VAL_INFORMATION1');
3988:
3989:
3986: p_transaction_step_id => p_transaction_step_id,
3987: p_name =>'P_VAL_INFORMATION1');
3988:
3989:
3990: l_val_information2 := hr_transaction_api.get_varchar2_value (
3991: p_transaction_step_id => p_transaction_step_id,
3992: p_name =>'P_VAL_INFORMATION2');
3993:
3994: l_val_information3 := hr_transaction_api.get_varchar2_value (
3990: l_val_information2 := hr_transaction_api.get_varchar2_value (
3991: p_transaction_step_id => p_transaction_step_id,
3992: p_name =>'P_VAL_INFORMATION2');
3993:
3994: l_val_information3 := hr_transaction_api.get_varchar2_value (
3995: p_transaction_step_id => p_transaction_step_id,
3996: p_name =>'P_VAL_INFORMATION3');
3997:
3998: l_val_information4 := hr_transaction_api.get_varchar2_value (
3994: l_val_information3 := hr_transaction_api.get_varchar2_value (
3995: p_transaction_step_id => p_transaction_step_id,
3996: p_name =>'P_VAL_INFORMATION3');
3997:
3998: l_val_information4 := hr_transaction_api.get_varchar2_value (
3999: p_transaction_step_id => p_transaction_step_id,
4000: p_name =>'P_VAL_INFORMATION4');
4001:
4002: l_val_information5 := hr_transaction_api.get_varchar2_value (
3998: l_val_information4 := hr_transaction_api.get_varchar2_value (
3999: p_transaction_step_id => p_transaction_step_id,
4000: p_name =>'P_VAL_INFORMATION4');
4001:
4002: l_val_information5 := hr_transaction_api.get_varchar2_value (
4003: p_transaction_step_id => p_transaction_step_id,
4004: p_name =>'P_VAL_INFORMATION5');
4005:
4006: l_val_information6 := hr_transaction_api.get_varchar2_value (
4002: l_val_information5 := hr_transaction_api.get_varchar2_value (
4003: p_transaction_step_id => p_transaction_step_id,
4004: p_name =>'P_VAL_INFORMATION5');
4005:
4006: l_val_information6 := hr_transaction_api.get_varchar2_value (
4007: p_transaction_step_id => p_transaction_step_id,
4008: p_name =>'P_VAL_INFORMATION6');
4009:
4010: l_val_information7 := hr_transaction_api.get_varchar2_value (
4006: l_val_information6 := hr_transaction_api.get_varchar2_value (
4007: p_transaction_step_id => p_transaction_step_id,
4008: p_name =>'P_VAL_INFORMATION6');
4009:
4010: l_val_information7 := hr_transaction_api.get_varchar2_value (
4011: p_transaction_step_id => p_transaction_step_id,
4012: p_name =>'P_VAL_INFORMATION7');
4013:
4014: l_val_information8 := hr_transaction_api.get_varchar2_value (
4010: l_val_information7 := hr_transaction_api.get_varchar2_value (
4011: p_transaction_step_id => p_transaction_step_id,
4012: p_name =>'P_VAL_INFORMATION7');
4013:
4014: l_val_information8 := hr_transaction_api.get_varchar2_value (
4015: p_transaction_step_id => p_transaction_step_id,
4016: p_name =>'P_VAL_INFORMATION8');
4017:
4018: l_val_information9 := hr_transaction_api.get_varchar2_value (
4014: l_val_information8 := hr_transaction_api.get_varchar2_value (
4015: p_transaction_step_id => p_transaction_step_id,
4016: p_name =>'P_VAL_INFORMATION8');
4017:
4018: l_val_information9 := hr_transaction_api.get_varchar2_value (
4019: p_transaction_step_id => p_transaction_step_id,
4020: p_name =>'P_VAL_INFORMATION9');
4021:
4022: l_val_information10 := hr_transaction_api.get_varchar2_value (
4018: l_val_information9 := hr_transaction_api.get_varchar2_value (
4019: p_transaction_step_id => p_transaction_step_id,
4020: p_name =>'P_VAL_INFORMATION9');
4021:
4022: l_val_information10 := hr_transaction_api.get_varchar2_value (
4023: p_transaction_step_id => p_transaction_step_id,
4024: p_name =>'P_VAL_INFORMATION10');
4025:
4026: l_val_information11 := hr_transaction_api.get_varchar2_value (
4022: l_val_information10 := hr_transaction_api.get_varchar2_value (
4023: p_transaction_step_id => p_transaction_step_id,
4024: p_name =>'P_VAL_INFORMATION10');
4025:
4026: l_val_information11 := hr_transaction_api.get_varchar2_value (
4027: p_transaction_step_id => p_transaction_step_id,
4028: p_name =>'P_VAL_INFORMATION11');
4029:
4030: l_val_information12 := hr_transaction_api.get_varchar2_value (
4026: l_val_information11 := hr_transaction_api.get_varchar2_value (
4027: p_transaction_step_id => p_transaction_step_id,
4028: p_name =>'P_VAL_INFORMATION11');
4029:
4030: l_val_information12 := hr_transaction_api.get_varchar2_value (
4031: p_transaction_step_id => p_transaction_step_id,
4032: p_name =>'P_VAL_INFORMATION12');
4033:
4034: l_val_information13 := hr_transaction_api.get_varchar2_value (
4030: l_val_information12 := hr_transaction_api.get_varchar2_value (
4031: p_transaction_step_id => p_transaction_step_id,
4032: p_name =>'P_VAL_INFORMATION12');
4033:
4034: l_val_information13 := hr_transaction_api.get_varchar2_value (
4035: p_transaction_step_id => p_transaction_step_id,
4036: p_name =>'P_VAL_INFORMATION13');
4037:
4038: l_val_information14 := hr_transaction_api.get_varchar2_value (
4034: l_val_information13 := hr_transaction_api.get_varchar2_value (
4035: p_transaction_step_id => p_transaction_step_id,
4036: p_name =>'P_VAL_INFORMATION13');
4037:
4038: l_val_information14 := hr_transaction_api.get_varchar2_value (
4039: p_transaction_step_id => p_transaction_step_id,
4040: p_name =>'P_VAL_INFORMATION14');
4041:
4042: l_val_information15 := hr_transaction_api.get_varchar2_value (
4038: l_val_information14 := hr_transaction_api.get_varchar2_value (
4039: p_transaction_step_id => p_transaction_step_id,
4040: p_name =>'P_VAL_INFORMATION14');
4041:
4042: l_val_information15 := hr_transaction_api.get_varchar2_value (
4043: p_transaction_step_id => p_transaction_step_id,
4044: p_name =>'P_VAL_INFORMATION15');
4045:
4046: l_val_information16 := hr_transaction_api.get_varchar2_value (
4042: l_val_information15 := hr_transaction_api.get_varchar2_value (
4043: p_transaction_step_id => p_transaction_step_id,
4044: p_name =>'P_VAL_INFORMATION15');
4045:
4046: l_val_information16 := hr_transaction_api.get_varchar2_value (
4047: p_transaction_step_id => p_transaction_step_id,
4048: p_name =>'P_VAL_INFORMATION16');
4049:
4050: l_val_information17 := hr_transaction_api.get_varchar2_value (
4046: l_val_information16 := hr_transaction_api.get_varchar2_value (
4047: p_transaction_step_id => p_transaction_step_id,
4048: p_name =>'P_VAL_INFORMATION16');
4049:
4050: l_val_information17 := hr_transaction_api.get_varchar2_value (
4051: p_transaction_step_id => p_transaction_step_id,
4052: p_name =>'P_VAL_INFORMATION17');
4053:
4054: l_val_information18 := hr_transaction_api.get_varchar2_value (
4050: l_val_information17 := hr_transaction_api.get_varchar2_value (
4051: p_transaction_step_id => p_transaction_step_id,
4052: p_name =>'P_VAL_INFORMATION17');
4053:
4054: l_val_information18 := hr_transaction_api.get_varchar2_value (
4055: p_transaction_step_id => p_transaction_step_id,
4056: p_name =>'P_VAL_INFORMATION18');
4057:
4058: l_val_information19 := hr_transaction_api.get_varchar2_value (
4054: l_val_information18 := hr_transaction_api.get_varchar2_value (
4055: p_transaction_step_id => p_transaction_step_id,
4056: p_name =>'P_VAL_INFORMATION18');
4057:
4058: l_val_information19 := hr_transaction_api.get_varchar2_value (
4059: p_transaction_step_id => p_transaction_step_id,
4060: p_name =>'P_VAL_INFORMATION19');
4061:
4062: l_val_information20 := hr_transaction_api.get_varchar2_value (
4058: l_val_information19 := hr_transaction_api.get_varchar2_value (
4059: p_transaction_step_id => p_transaction_step_id,
4060: p_name =>'P_VAL_INFORMATION19');
4061:
4062: l_val_information20 := hr_transaction_api.get_varchar2_value (
4063: p_transaction_step_id => p_transaction_step_id,
4064: p_name =>'P_VAL_INFORMATION20');
4065:
4066: l_fuel_benefit := hr_transaction_api.get_varchar2_value (
4062: l_val_information20 := hr_transaction_api.get_varchar2_value (
4063: p_transaction_step_id => p_transaction_step_id,
4064: p_name =>'P_VAL_INFORMATION20');
4065:
4066: l_fuel_benefit := hr_transaction_api.get_varchar2_value (
4067: p_transaction_step_id => p_transaction_step_id,
4068: p_name =>'P_FUEL_BENEFIT');
4069:
4070:
4067: p_transaction_step_id => p_transaction_step_id,
4068: p_name =>'P_FUEL_BENEFIT');
4069:
4070:
4071: l_vehicle_repository_id := hr_transaction_api.get_number_value (
4072: p_transaction_step_id => p_transaction_step_id,
4073: p_name =>'P_VEHICLE_REPOSITORY_ID');
4074: l_vehicle_allocation_id := hr_transaction_api.get_number_value (
4075: p_transaction_step_id => p_transaction_step_id,
4070:
4071: l_vehicle_repository_id := hr_transaction_api.get_number_value (
4072: p_transaction_step_id => p_transaction_step_id,
4073: p_name =>'P_VEHICLE_REPOSITORY_ID');
4074: l_vehicle_allocation_id := hr_transaction_api.get_number_value (
4075: p_transaction_step_id => p_transaction_step_id,
4076: p_name =>'P_VEHICLE_ALLOCATION_ID');
4077: l_object_version_number := hr_transaction_api.get_number_value (
4078: p_transaction_step_id => p_transaction_step_id,
4073: p_name =>'P_VEHICLE_REPOSITORY_ID');
4074: l_vehicle_allocation_id := hr_transaction_api.get_number_value (
4075: p_transaction_step_id => p_transaction_step_id,
4076: p_name =>'P_VEHICLE_ALLOCATION_ID');
4077: l_object_version_number := hr_transaction_api.get_number_value (
4078: p_transaction_step_id => p_transaction_step_id,
4079: p_name =>'P_OBJECT_VERSION_NUMBER');
4080:
4081:
4084: CLOSE c_get_count;
4085:
4086: FOR i in 1..l_get_count
4087: LOOP
4088: l_user_info (i).person_id :=hr_transaction_api.get_number_value (
4089: p_transaction_step_id => p_transaction_step_id,
4090: p_name =>'P_PERSON_USR_ID'||i);
4091:
4092: l_user_info (i).assignment_id :=hr_transaction_api.get_number_value (
4088: l_user_info (i).person_id :=hr_transaction_api.get_number_value (
4089: p_transaction_step_id => p_transaction_step_id,
4090: p_name =>'P_PERSON_USR_ID'||i);
4091:
4092: l_user_info (i).assignment_id :=hr_transaction_api.get_number_value (
4093: p_transaction_step_id => p_transaction_step_id,
4094: p_name =>'P_ASSIGNMENT_USR_ID'||i);
4095:
4096:
4093: p_transaction_step_id => p_transaction_step_id,
4094: p_name =>'P_ASSIGNMENT_USR_ID'||i);
4095:
4096:
4097: l_user_info (i).user_type :=hr_transaction_api.get_varchar2_value (
4098: p_transaction_step_id => p_transaction_step_id,
4099: p_name =>'P_USER_TYPE'||i);
4100:
4101: