[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;
2095: l_trans_tbl(l_count).param_value := x_vehicle_allocation_id;
2096: l_trans_tbl(l_count).param_data_type := 'NUMBER';
2097:
2098: IF x_transaction_id is NULl THEN
2099: hr_transaction_api.create_transaction(
2100: p_validate => false
2101: ,p_creator_person_id => x_login_person_id
2102: ,p_transaction_privilege => 'PRIVATE'
2103: ,p_product_code => 'PQP'
2125: ,aname => 'TRANSACTION_ID'
2126: ,avalue => l_transaction_id);
2127: x_transaction_id := l_transaction_id;
2128: --Create transaction steps
2129: hr_transaction_api.create_transaction_step
2130: (p_validate => false
2131: ,p_creator_person_id => x_login_person_id
2132: ,p_transaction_id => l_transaction_id
2133: ,p_api_name => l_api_name
2152:
2153: FOR i in 1..l_trans_tbl.count
2154: LOOP
2155: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
2156: hr_transaction_api.set_varchar2_value
2157: (p_transaction_step_id => l_transaction_step_id
2158: ,p_person_id => x_person_id
2159: ,p_name => l_trans_tbl (i).param_name
2160: ,p_value => l_trans_tbl (i).param_value
2160: ,p_value => l_trans_tbl (i).param_value
2161: );
2162:
2163: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
2164: hr_transaction_api.set_date_value
2165: (
2166: p_transaction_step_id => l_transaction_step_id
2167: ,p_person_id => x_person_id
2168: ,p_name => l_trans_tbl (i).param_name
2171: -- ,p_original_value );
2172:
2173:
2174: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
2175: hr_transaction_api.set_number_value
2176: (
2177: p_transaction_step_id => l_transaction_step_id
2178: ,p_person_id => x_person_id
2179: ,p_name =>l_trans_tbl (i).param_name
3259: -- If there are no error messages then insert values into transaction table
3260: SAVEPOINT pqp_create_transaction;
3261: IF x_transaction_id is NULl THEN
3262: hr_utility.set_location('Entering create_transaction :',10);
3263: hr_transaction_api.create_transaction(
3264: p_validate => false
3265: ,p_creator_person_id => x_login_person_id
3266: ,p_transaction_privilege => 'PRIVATE'
3267: ,p_product_code => 'PQP'
3294:
3295: x_transaction_id := l_transaction_id;
3296: hr_utility.set_location('Leaving setitemattrnumber :',20);
3297: --Create transaction steps
3298: hr_transaction_api.create_transaction_step
3299: (p_validate =>false
3300: ,p_creator_person_id =>x_login_person_id
3301: ,p_transaction_id =>l_transaction_id
3302: ,p_api_name =>l_api_name
3309: );
3310: hr_utility.set_location('Leaving create_transaction_step :',25);
3311: ELSE
3312: hr_utility.set_location('Entering update transaction :',10);
3313: hr_transaction_api.update_transaction
3314: (p_transaction_id => x_transaction_id
3315: ,p_status => x_status
3316: );
3317: hr_utility.set_location('leaving update transaction :',15);
3329: LOOP
3330: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
3331: hr_utility.set_location('Enter varchar param||l_trans_tbl (i).param_name :',10);
3332: hr_utility.set_location('Enter varchar param value||l_trans_tbl (i).param_value :',10);
3333: hr_transaction_api.set_varchar2_value
3334: (p_transaction_step_id =>l_transaction_step_id
3335: ,p_person_id =>x_person_id
3336: ,p_name =>l_trans_tbl (i).param_name
3337: ,p_value =>l_trans_tbl (i).param_value
3341: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
3342: hr_utility.set_location('Enter date Param||l_trans_tbl (i).param_name :',10);
3343: hr_utility.set_location('Enter date Param Value||
3344: l_trans_tbl (i).param_value :',10);
3345: hr_transaction_api.set_date_value
3346: (
3347: p_transaction_step_id => l_transaction_step_id
3348: ,p_person_id => x_person_id
3349: ,p_name => l_trans_tbl (i).param_name
3352: hr_utility.set_location('Leaving param date :',20);
3353: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
3354: hr_utility.set_location('Enter number param||l_trans_tbl (i).param_name :',10);
3355: hr_utility.set_location('Enter number param value||l_trans_tbl (i).param_value :',10);
3356: hr_transaction_api.set_number_value
3357: (
3358: p_transaction_step_id => l_transaction_step_id
3359: ,p_person_id => x_person_id
3360: ,p_name =>l_trans_tbl (i).param_name
3424: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3425: l_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
3426: l_effective_date DATE;
3427: BEGIN
3428: l_person_id := hr_transaction_api.get_number_value (
3429: p_transaction_step_id => p_transaction_step_id,
3430: p_name =>'P_PERSON_ID' );
3431:
3432: l_effective_date := hr_transaction_api.get_date_value (
3428: l_person_id := hr_transaction_api.get_number_value (
3429: p_transaction_step_id => p_transaction_step_id,
3430: p_name =>'P_PERSON_ID' );
3431:
3432: l_effective_date := hr_transaction_api.get_date_value (
3433: p_transaction_step_id => p_transaction_step_id,
3434: p_name =>'P_EFFECTIVE_DATE' );
3435: l_assignment_id :=hr_transaction_api.get_number_value (
3436: p_transaction_step_id => p_transaction_step_id,
3431:
3432: l_effective_date := hr_transaction_api.get_date_value (
3433: p_transaction_step_id => p_transaction_step_id,
3434: p_name =>'P_EFFECTIVE_DATE' );
3435: l_assignment_id :=hr_transaction_api.get_number_value (
3436: p_transaction_step_id => p_transaction_step_id,
3437: p_name =>'P_ASSIGNMENT_ID' );
3438:
3439: l_business_group_id :=hr_transaction_api.get_number_value (
3435: l_assignment_id :=hr_transaction_api.get_number_value (
3436: p_transaction_step_id => p_transaction_step_id,
3437: p_name =>'P_ASSIGNMENT_ID' );
3438:
3439: l_business_group_id :=hr_transaction_api.get_number_value (
3440: p_transaction_step_id => p_transaction_step_id,
3441: p_name =>'P_BUSINESS_GROUP_ID' );
3442: l_allocation_id :=hr_transaction_api.get_number_value (
3443: p_transaction_step_id => p_transaction_step_id,
3438:
3439: l_business_group_id :=hr_transaction_api.get_number_value (
3440: p_transaction_step_id => p_transaction_step_id,
3441: p_name =>'P_BUSINESS_GROUP_ID' );
3442: l_allocation_id :=hr_transaction_api.get_number_value (
3443: p_transaction_step_id => p_transaction_step_id,
3444: p_name =>'P_ALLOCATION_ID' );
3445:
3446:
3640: l_transaction_id :=get_transaction_id(
3641: p_transaction_step_id =>p_transaction_step_id);
3642:
3643:
3644: l_person_id := hr_transaction_api.get_number_value (
3645: p_transaction_step_id => p_transaction_step_id,
3646: p_name =>'P_PERSON_ID' );
3647:
3648:
3645: p_transaction_step_id => p_transaction_step_id,
3646: p_name =>'P_PERSON_ID' );
3647:
3648:
3649: l_effective_date := hr_transaction_api.get_date_value (
3650: p_transaction_step_id => p_transaction_step_id,
3651: p_name =>'P_EFFECTIVE_DATE' );
3652:
3653: l_registration_number := hr_transaction_api.get_varchar2_value (
3649: l_effective_date := hr_transaction_api.get_date_value (
3650: p_transaction_step_id => p_transaction_step_id,
3651: p_name =>'P_EFFECTIVE_DATE' );
3652:
3653: l_registration_number := hr_transaction_api.get_varchar2_value (
3654: p_transaction_step_id => p_transaction_step_id,
3655: p_name =>'P_REGISTRATION_NUMBER' );
3656:
3657: l_vehicle_type := hr_transaction_api.get_varchar2_value (
3653: l_registration_number := hr_transaction_api.get_varchar2_value (
3654: p_transaction_step_id => p_transaction_step_id,
3655: p_name =>'P_REGISTRATION_NUMBER' );
3656:
3657: l_vehicle_type := hr_transaction_api.get_varchar2_value (
3658: p_transaction_step_id => p_transaction_step_id,
3659: p_name =>'P_VEHICLE_TYPE' );
3660:
3661: l_vehicle_id_number := hr_transaction_api.get_varchar2_value (
3657: l_vehicle_type := hr_transaction_api.get_varchar2_value (
3658: p_transaction_step_id => p_transaction_step_id,
3659: p_name =>'P_VEHICLE_TYPE' );
3660:
3661: l_vehicle_id_number := hr_transaction_api.get_varchar2_value (
3662: p_transaction_step_id => p_transaction_step_id,
3663: p_name =>'P_VEHICLE_ID_NUMBER' );
3664: l_business_group_id := hr_transaction_api.get_number_value (
3665: p_transaction_step_id => p_transaction_step_id,
3660:
3661: l_vehicle_id_number := hr_transaction_api.get_varchar2_value (
3662: p_transaction_step_id => p_transaction_step_id,
3663: p_name =>'P_VEHICLE_ID_NUMBER' );
3664: l_business_group_id := hr_transaction_api.get_number_value (
3665: p_transaction_step_id => p_transaction_step_id,
3666: p_name =>'P_BUSINESS_GROUP_ID');
3667:
3668: l_make := hr_transaction_api.get_varchar2_value (
3664: l_business_group_id := hr_transaction_api.get_number_value (
3665: p_transaction_step_id => p_transaction_step_id,
3666: p_name =>'P_BUSINESS_GROUP_ID');
3667:
3668: l_make := hr_transaction_api.get_varchar2_value (
3669: p_transaction_step_id => p_transaction_step_id,
3670: p_name =>'P_MAKE' );
3671:
3672: l_engine_capacity_in_cc := hr_transaction_api.get_number_value (
3668: l_make := hr_transaction_api.get_varchar2_value (
3669: p_transaction_step_id => p_transaction_step_id,
3670: p_name =>'P_MAKE' );
3671:
3672: l_engine_capacity_in_cc := hr_transaction_api.get_number_value (
3673: p_transaction_step_id => p_transaction_step_id,
3674: p_name =>'P_ENGINE_CAPACITY_IN_CC');
3675:
3676: l_fuel_type := hr_transaction_api.get_varchar2_value (
3672: l_engine_capacity_in_cc := hr_transaction_api.get_number_value (
3673: p_transaction_step_id => p_transaction_step_id,
3674: p_name =>'P_ENGINE_CAPACITY_IN_CC');
3675:
3676: l_fuel_type := hr_transaction_api.get_varchar2_value (
3677: p_transaction_step_id => p_transaction_step_id,
3678: p_name =>'P_FUEL_TYPE');
3679:
3680: l_currency_code := hr_transaction_api.get_varchar2_value (
3676: l_fuel_type := hr_transaction_api.get_varchar2_value (
3677: p_transaction_step_id => p_transaction_step_id,
3678: p_name =>'P_FUEL_TYPE');
3679:
3680: l_currency_code := hr_transaction_api.get_varchar2_value (
3681: p_transaction_step_id => p_transaction_step_id,
3682: p_name =>'P_CURRENCY_CODE');
3683:
3684: l_model := hr_transaction_api.get_varchar2_value (
3680: l_currency_code := hr_transaction_api.get_varchar2_value (
3681: p_transaction_step_id => p_transaction_step_id,
3682: p_name =>'P_CURRENCY_CODE');
3683:
3684: l_model := hr_transaction_api.get_varchar2_value (
3685: p_transaction_step_id => p_transaction_step_id,
3686: p_name =>'P_MODEL' );
3687:
3688: l_initial_registration := hr_transaction_api.get_date_value (
3684: l_model := hr_transaction_api.get_varchar2_value (
3685: p_transaction_step_id => p_transaction_step_id,
3686: p_name =>'P_MODEL' );
3687:
3688: l_initial_registration := hr_transaction_api.get_date_value (
3689: p_transaction_step_id => p_transaction_step_id,
3690: p_name =>'P_INITIAL_REGISTRATION');
3691:
3692: l_last_registration_renew_date := hr_transaction_api.get_date_value (
3688: l_initial_registration := hr_transaction_api.get_date_value (
3689: p_transaction_step_id => p_transaction_step_id,
3690: p_name =>'P_INITIAL_REGISTRATION');
3691:
3692: l_last_registration_renew_date := hr_transaction_api.get_date_value (
3693: p_transaction_step_id => p_transaction_step_id,
3694: p_name =>'P_LAST_REGISTRATION_RENEW_DATE');
3695:
3696: l_fiscal_ratings := hr_transaction_api.get_number_value (
3692: l_last_registration_renew_date := hr_transaction_api.get_date_value (
3693: p_transaction_step_id => p_transaction_step_id,
3694: p_name =>'P_LAST_REGISTRATION_RENEW_DATE');
3695:
3696: l_fiscal_ratings := hr_transaction_api.get_number_value (
3697: p_transaction_step_id => p_transaction_step_id,
3698: p_name =>'P_FISCAL_RATINGS' );
3699:
3700: l_vehicle_ownership := hr_transaction_api.get_varchar2_value (
3696: l_fiscal_ratings := hr_transaction_api.get_number_value (
3697: p_transaction_step_id => p_transaction_step_id,
3698: p_name =>'P_FISCAL_RATINGS' );
3699:
3700: l_vehicle_ownership := hr_transaction_api.get_varchar2_value (
3701: p_transaction_step_id => p_transaction_step_id,
3702: p_name =>'P_VEHICLE_OWNERSHIP');
3703:
3704: l_shared_vehicle := hr_transaction_api.get_varchar2_value (
3700: l_vehicle_ownership := hr_transaction_api.get_varchar2_value (
3701: p_transaction_step_id => p_transaction_step_id,
3702: p_name =>'P_VEHICLE_OWNERSHIP');
3703:
3704: l_shared_vehicle := hr_transaction_api.get_varchar2_value (
3705: p_transaction_step_id => p_transaction_step_id,
3706: p_name =>'P_SHARED_VEHICLE' );
3707:
3708: l_color := hr_transaction_api.get_varchar2_value (
3704: l_shared_vehicle := hr_transaction_api.get_varchar2_value (
3705: p_transaction_step_id => p_transaction_step_id,
3706: p_name =>'P_SHARED_VEHICLE' );
3707:
3708: l_color := hr_transaction_api.get_varchar2_value (
3709: p_transaction_step_id => p_transaction_step_id,
3710: p_name =>'P_COLOR' );
3711:
3712: l_seating_capacity := hr_transaction_api.get_number_value (
3708: l_color := hr_transaction_api.get_varchar2_value (
3709: p_transaction_step_id => p_transaction_step_id,
3710: p_name =>'P_COLOR' );
3711:
3712: l_seating_capacity := hr_transaction_api.get_number_value (
3713: p_transaction_step_id => p_transaction_step_id,
3714: p_name =>'P_SEATING_CAPACITY' );
3715:
3716: l_weight := hr_transaction_api.get_number_value (
3712: l_seating_capacity := hr_transaction_api.get_number_value (
3713: p_transaction_step_id => p_transaction_step_id,
3714: p_name =>'P_SEATING_CAPACITY' );
3715:
3716: l_weight := hr_transaction_api.get_number_value (
3717: p_transaction_step_id => p_transaction_step_id,
3718: p_name =>'P_WEIGHT' );
3719:
3720: l_weight_uom := hr_transaction_api.get_varchar2_value (
3716: l_weight := hr_transaction_api.get_number_value (
3717: p_transaction_step_id => p_transaction_step_id,
3718: p_name =>'P_WEIGHT' );
3719:
3720: l_weight_uom := hr_transaction_api.get_varchar2_value (
3721: p_transaction_step_id => p_transaction_step_id,
3722: p_name =>'P_WEIGHT_UOM' );
3723:
3724: l_model_year := hr_transaction_api.get_number_value (
3720: l_weight_uom := hr_transaction_api.get_varchar2_value (
3721: p_transaction_step_id => p_transaction_step_id,
3722: p_name =>'P_WEIGHT_UOM' );
3723:
3724: l_model_year := hr_transaction_api.get_number_value (
3725: p_transaction_step_id => p_transaction_step_id,
3726: p_name =>'P_MODEL_YEAR' );
3727:
3728: l_insurance_number := hr_transaction_api.get_varchar2_value (
3724: l_model_year := hr_transaction_api.get_number_value (
3725: p_transaction_step_id => p_transaction_step_id,
3726: p_name =>'P_MODEL_YEAR' );
3727:
3728: l_insurance_number := hr_transaction_api.get_varchar2_value (
3729: p_transaction_step_id => p_transaction_step_id,
3730: p_name =>'P_INSURANCE_NUMBER' );
3731:
3732: l_insurance_expiry_date := hr_transaction_api.get_date_value (
3728: l_insurance_number := hr_transaction_api.get_varchar2_value (
3729: p_transaction_step_id => p_transaction_step_id,
3730: p_name =>'P_INSURANCE_NUMBER' );
3731:
3732: l_insurance_expiry_date := hr_transaction_api.get_date_value (
3733: p_transaction_step_id => p_transaction_step_id,
3734: p_name =>'P_INSURANCE_EXPIRY_DATE' );
3735:
3736: l_taxation_method := hr_transaction_api.get_varchar2_value (
3732: l_insurance_expiry_date := hr_transaction_api.get_date_value (
3733: p_transaction_step_id => p_transaction_step_id,
3734: p_name =>'P_INSURANCE_EXPIRY_DATE' );
3735:
3736: l_taxation_method := hr_transaction_api.get_varchar2_value (
3737: p_transaction_step_id => p_transaction_step_id,
3738: p_name =>'P_TAXATION_METHOD');
3739:
3740: l_comments := hr_transaction_api.get_varchar2_value (
3736: l_taxation_method := hr_transaction_api.get_varchar2_value (
3737: p_transaction_step_id => p_transaction_step_id,
3738: p_name =>'P_TAXATION_METHOD');
3739:
3740: l_comments := hr_transaction_api.get_varchar2_value (
3741: p_transaction_step_id => p_transaction_step_id,
3742: p_name =>'P_COMMENTS' );
3743:
3744: l_vre_attribute_category := hr_transaction_api.get_varchar2_value (
3740: l_comments := hr_transaction_api.get_varchar2_value (
3741: p_transaction_step_id => p_transaction_step_id,
3742: p_name =>'P_COMMENTS' );
3743:
3744: l_vre_attribute_category := hr_transaction_api.get_varchar2_value (
3745: p_transaction_step_id => p_transaction_step_id,
3746: p_name =>'P_VRE_ATTRIBUTE_CATEGORY' );
3747:
3748: l_vre_attribute1 := hr_transaction_api.get_varchar2_value (
3744: l_vre_attribute_category := hr_transaction_api.get_varchar2_value (
3745: p_transaction_step_id => p_transaction_step_id,
3746: p_name =>'P_VRE_ATTRIBUTE_CATEGORY' );
3747:
3748: l_vre_attribute1 := hr_transaction_api.get_varchar2_value (
3749: p_transaction_step_id => p_transaction_step_id,
3750: p_name =>'P_VRE_ATTRIBUTE1' );
3751:
3752: l_vre_attribute2 := hr_transaction_api.get_varchar2_value (
3748: l_vre_attribute1 := hr_transaction_api.get_varchar2_value (
3749: p_transaction_step_id => p_transaction_step_id,
3750: p_name =>'P_VRE_ATTRIBUTE1' );
3751:
3752: l_vre_attribute2 := hr_transaction_api.get_varchar2_value (
3753: p_transaction_step_id => p_transaction_step_id,
3754: p_name =>'P_VRE_ATTRIBUTE2' );
3755:
3756: l_vre_attribute3 := hr_transaction_api.get_varchar2_value (
3752: l_vre_attribute2 := hr_transaction_api.get_varchar2_value (
3753: p_transaction_step_id => p_transaction_step_id,
3754: p_name =>'P_VRE_ATTRIBUTE2' );
3755:
3756: l_vre_attribute3 := hr_transaction_api.get_varchar2_value (
3757: p_transaction_step_id => p_transaction_step_id,
3758: p_name =>'P_VRE_ATTRIBUTE3' );
3759:
3760: l_vre_attribute4 := hr_transaction_api.get_varchar2_value (
3756: l_vre_attribute3 := hr_transaction_api.get_varchar2_value (
3757: p_transaction_step_id => p_transaction_step_id,
3758: p_name =>'P_VRE_ATTRIBUTE3' );
3759:
3760: l_vre_attribute4 := hr_transaction_api.get_varchar2_value (
3761: p_transaction_step_id => p_transaction_step_id,
3762: p_name =>'P_VRE_ATTRIBUTE4' );
3763:
3764:
3761: p_transaction_step_id => p_transaction_step_id,
3762: p_name =>'P_VRE_ATTRIBUTE4' );
3763:
3764:
3765: l_vre_attribute5 := hr_transaction_api.get_varchar2_value (
3766: p_transaction_step_id => p_transaction_step_id,
3767: p_name =>'P_VRE_ATTRIBUTE5' );
3768:
3769: l_vre_attribute6 := hr_transaction_api.get_varchar2_value (
3765: l_vre_attribute5 := hr_transaction_api.get_varchar2_value (
3766: p_transaction_step_id => p_transaction_step_id,
3767: p_name =>'P_VRE_ATTRIBUTE5' );
3768:
3769: l_vre_attribute6 := hr_transaction_api.get_varchar2_value (
3770: p_transaction_step_id => p_transaction_step_id,
3771: p_name =>'P_VRE_ATTRIBUTE6' );
3772:
3773: l_vre_attribute7 := hr_transaction_api.get_varchar2_value (
3769: l_vre_attribute6 := hr_transaction_api.get_varchar2_value (
3770: p_transaction_step_id => p_transaction_step_id,
3771: p_name =>'P_VRE_ATTRIBUTE6' );
3772:
3773: l_vre_attribute7 := hr_transaction_api.get_varchar2_value (
3774: p_transaction_step_id => p_transaction_step_id,
3775: p_name =>'P_VRE_ATTRIBUTE7' );
3776:
3777: l_vre_attribute8 := hr_transaction_api.get_varchar2_value (
3773: l_vre_attribute7 := hr_transaction_api.get_varchar2_value (
3774: p_transaction_step_id => p_transaction_step_id,
3775: p_name =>'P_VRE_ATTRIBUTE7' );
3776:
3777: l_vre_attribute8 := hr_transaction_api.get_varchar2_value (
3778: p_transaction_step_id => p_transaction_step_id,
3779: p_name =>'P_VRE_ATTRIBUTE8' );
3780:
3781: l_vre_attribute9 := hr_transaction_api.get_varchar2_value (
3777: l_vre_attribute8 := hr_transaction_api.get_varchar2_value (
3778: p_transaction_step_id => p_transaction_step_id,
3779: p_name =>'P_VRE_ATTRIBUTE8' );
3780:
3781: l_vre_attribute9 := hr_transaction_api.get_varchar2_value (
3782: p_transaction_step_id => p_transaction_step_id,
3783: p_name =>'P_VRE_ATTRIBUTE9' );
3784:
3785: l_vre_attribute10 := hr_transaction_api.get_varchar2_value (
3781: l_vre_attribute9 := hr_transaction_api.get_varchar2_value (
3782: p_transaction_step_id => p_transaction_step_id,
3783: p_name =>'P_VRE_ATTRIBUTE9' );
3784:
3785: l_vre_attribute10 := hr_transaction_api.get_varchar2_value (
3786: p_transaction_step_id => p_transaction_step_id,
3787: p_name =>'P_VRE_ATTRIBUTE10' );
3788:
3789: l_vre_attribute11 := hr_transaction_api.get_varchar2_value (
3785: l_vre_attribute10 := hr_transaction_api.get_varchar2_value (
3786: p_transaction_step_id => p_transaction_step_id,
3787: p_name =>'P_VRE_ATTRIBUTE10' );
3788:
3789: l_vre_attribute11 := hr_transaction_api.get_varchar2_value (
3790: p_transaction_step_id => p_transaction_step_id,
3791: p_name =>'P_VRE_ATTRIBUTE11' );
3792:
3793: l_vre_attribute12 := hr_transaction_api.get_varchar2_value (
3789: l_vre_attribute11 := hr_transaction_api.get_varchar2_value (
3790: p_transaction_step_id => p_transaction_step_id,
3791: p_name =>'P_VRE_ATTRIBUTE11' );
3792:
3793: l_vre_attribute12 := hr_transaction_api.get_varchar2_value (
3794: p_transaction_step_id => p_transaction_step_id,
3795: p_name =>'P_VRE_ATTRIBUTE12' );
3796:
3797: l_vre_attribute13 := hr_transaction_api.get_varchar2_value (
3793: l_vre_attribute12 := hr_transaction_api.get_varchar2_value (
3794: p_transaction_step_id => p_transaction_step_id,
3795: p_name =>'P_VRE_ATTRIBUTE12' );
3796:
3797: l_vre_attribute13 := hr_transaction_api.get_varchar2_value (
3798: p_transaction_step_id => p_transaction_step_id,
3799: p_name =>'P_VRE_ATTRIBUTE13' );
3800:
3801: l_vre_attribute14 := hr_transaction_api.get_varchar2_value (
3797: l_vre_attribute13 := hr_transaction_api.get_varchar2_value (
3798: p_transaction_step_id => p_transaction_step_id,
3799: p_name =>'P_VRE_ATTRIBUTE13' );
3800:
3801: l_vre_attribute14 := hr_transaction_api.get_varchar2_value (
3802: p_transaction_step_id => p_transaction_step_id,
3803: p_name =>'P_VRE_ATTRIBUTE14' );
3804:
3805: l_vre_attribute15 := hr_transaction_api.get_varchar2_value (
3801: l_vre_attribute14 := hr_transaction_api.get_varchar2_value (
3802: p_transaction_step_id => p_transaction_step_id,
3803: p_name =>'P_VRE_ATTRIBUTE14' );
3804:
3805: l_vre_attribute15 := hr_transaction_api.get_varchar2_value (
3806: p_transaction_step_id => p_transaction_step_id,
3807: p_name =>'P_VRE_ATTRIBUTE15' );
3808:
3809: l_vre_attribute16 := hr_transaction_api.get_varchar2_value (
3805: l_vre_attribute15 := hr_transaction_api.get_varchar2_value (
3806: p_transaction_step_id => p_transaction_step_id,
3807: p_name =>'P_VRE_ATTRIBUTE15' );
3808:
3809: l_vre_attribute16 := hr_transaction_api.get_varchar2_value (
3810: p_transaction_step_id => p_transaction_step_id,
3811: p_name =>'P_VRE_ATTRIBUTE16' );
3812:
3813: l_vre_attribute17 := hr_transaction_api.get_varchar2_value (
3809: l_vre_attribute16 := hr_transaction_api.get_varchar2_value (
3810: p_transaction_step_id => p_transaction_step_id,
3811: p_name =>'P_VRE_ATTRIBUTE16' );
3812:
3813: l_vre_attribute17 := hr_transaction_api.get_varchar2_value (
3814: p_transaction_step_id => p_transaction_step_id,
3815: p_name =>'P_VRE_ATTRIBUTE17' );
3816:
3817: l_vre_attribute18 := hr_transaction_api.get_varchar2_value (
3813: l_vre_attribute17 := hr_transaction_api.get_varchar2_value (
3814: p_transaction_step_id => p_transaction_step_id,
3815: p_name =>'P_VRE_ATTRIBUTE17' );
3816:
3817: l_vre_attribute18 := hr_transaction_api.get_varchar2_value (
3818: p_transaction_step_id => p_transaction_step_id,
3819: p_name =>'P_VRE_ATTRIBUTE18' );
3820:
3821: l_vre_attribute19 := hr_transaction_api.get_varchar2_value (
3817: l_vre_attribute18 := hr_transaction_api.get_varchar2_value (
3818: p_transaction_step_id => p_transaction_step_id,
3819: p_name =>'P_VRE_ATTRIBUTE18' );
3820:
3821: l_vre_attribute19 := hr_transaction_api.get_varchar2_value (
3822: p_transaction_step_id => p_transaction_step_id,
3823: p_name =>'P_VRE_ATTRIBUTE19' );
3824:
3825: l_vre_attribute20 := hr_transaction_api.get_varchar2_value (
3821: l_vre_attribute19 := hr_transaction_api.get_varchar2_value (
3822: p_transaction_step_id => p_transaction_step_id,
3823: p_name =>'P_VRE_ATTRIBUTE19' );
3824:
3825: l_vre_attribute20 := hr_transaction_api.get_varchar2_value (
3826: p_transaction_step_id => p_transaction_step_id,
3827: p_name =>'P_VRE_ATTRIBUTE20' );
3828:
3829: l_vre_information_category := hr_transaction_api.get_varchar2_value (
3825: l_vre_attribute20 := hr_transaction_api.get_varchar2_value (
3826: p_transaction_step_id => p_transaction_step_id,
3827: p_name =>'P_VRE_ATTRIBUTE20' );
3828:
3829: l_vre_information_category := hr_transaction_api.get_varchar2_value (
3830: p_transaction_step_id => p_transaction_step_id,
3831: p_name =>'P_VRE_INFORMATION_CATEGORY' );
3832:
3833: l_vre_information1 := hr_transaction_api.get_varchar2_value (
3829: l_vre_information_category := hr_transaction_api.get_varchar2_value (
3830: p_transaction_step_id => p_transaction_step_id,
3831: p_name =>'P_VRE_INFORMATION_CATEGORY' );
3832:
3833: l_vre_information1 := hr_transaction_api.get_varchar2_value (
3834: p_transaction_step_id => p_transaction_step_id,
3835: p_name =>'P_VRE_INFORMATION1' );
3836:
3837: l_vre_information2 := hr_transaction_api.get_varchar2_value (
3833: l_vre_information1 := hr_transaction_api.get_varchar2_value (
3834: p_transaction_step_id => p_transaction_step_id,
3835: p_name =>'P_VRE_INFORMATION1' );
3836:
3837: l_vre_information2 := hr_transaction_api.get_varchar2_value (
3838: p_transaction_step_id => p_transaction_step_id,
3839: p_name =>'P_VRE_INFORMATION2' );
3840:
3841: l_vre_information3 := hr_transaction_api.get_varchar2_value (
3837: l_vre_information2 := hr_transaction_api.get_varchar2_value (
3838: p_transaction_step_id => p_transaction_step_id,
3839: p_name =>'P_VRE_INFORMATION2' );
3840:
3841: l_vre_information3 := hr_transaction_api.get_varchar2_value (
3842: p_transaction_step_id => p_transaction_step_id,
3843: p_name =>'P_VRE_INFORMATION3' );
3844:
3845: l_vre_information4 := hr_transaction_api.get_varchar2_value (
3841: l_vre_information3 := hr_transaction_api.get_varchar2_value (
3842: p_transaction_step_id => p_transaction_step_id,
3843: p_name =>'P_VRE_INFORMATION3' );
3844:
3845: l_vre_information4 := hr_transaction_api.get_varchar2_value (
3846: p_transaction_step_id => p_transaction_step_id,
3847: p_name =>'P_VRE_INFORMATION4' );
3848:
3849: l_vre_information5 := hr_transaction_api.get_varchar2_value (
3845: l_vre_information4 := hr_transaction_api.get_varchar2_value (
3846: p_transaction_step_id => p_transaction_step_id,
3847: p_name =>'P_VRE_INFORMATION4' );
3848:
3849: l_vre_information5 := hr_transaction_api.get_varchar2_value (
3850: p_transaction_step_id => p_transaction_step_id,
3851: p_name =>'P_VRE_INFORMATION5' );
3852:
3853: l_vre_information6 := hr_transaction_api.get_varchar2_value (
3849: l_vre_information5 := hr_transaction_api.get_varchar2_value (
3850: p_transaction_step_id => p_transaction_step_id,
3851: p_name =>'P_VRE_INFORMATION5' );
3852:
3853: l_vre_information6 := hr_transaction_api.get_varchar2_value (
3854: p_transaction_step_id => p_transaction_step_id,
3855: p_name =>'P_VRE_INFORMATION6' );
3856:
3857: l_vre_information7 := hr_transaction_api.get_varchar2_value (
3853: l_vre_information6 := hr_transaction_api.get_varchar2_value (
3854: p_transaction_step_id => p_transaction_step_id,
3855: p_name =>'P_VRE_INFORMATION6' );
3856:
3857: l_vre_information7 := hr_transaction_api.get_varchar2_value (
3858: p_transaction_step_id => p_transaction_step_id,
3859: p_name =>'P_VRE_INFORMATION7' );
3860:
3861: l_vre_information8 := hr_transaction_api.get_varchar2_value (
3857: l_vre_information7 := hr_transaction_api.get_varchar2_value (
3858: p_transaction_step_id => p_transaction_step_id,
3859: p_name =>'P_VRE_INFORMATION7' );
3860:
3861: l_vre_information8 := hr_transaction_api.get_varchar2_value (
3862: p_transaction_step_id => p_transaction_step_id,
3863: p_name =>'P_VRE_INFORMATION8' );
3864:
3865: l_vre_information9 := hr_transaction_api.get_varchar2_value (
3861: l_vre_information8 := hr_transaction_api.get_varchar2_value (
3862: p_transaction_step_id => p_transaction_step_id,
3863: p_name =>'P_VRE_INFORMATION8' );
3864:
3865: l_vre_information9 := hr_transaction_api.get_varchar2_value (
3866: p_transaction_step_id => p_transaction_step_id,
3867: p_name =>'P_VRE_INFORMATION9' );
3868:
3869: l_vre_information10 := hr_transaction_api.get_varchar2_value (
3865: l_vre_information9 := hr_transaction_api.get_varchar2_value (
3866: p_transaction_step_id => p_transaction_step_id,
3867: p_name =>'P_VRE_INFORMATION9' );
3868:
3869: l_vre_information10 := hr_transaction_api.get_varchar2_value (
3870: p_transaction_step_id => p_transaction_step_id,
3871: p_name =>'P_VRE_INFORMATION10' );
3872:
3873: l_vre_information11 := hr_transaction_api.get_varchar2_value (
3869: l_vre_information10 := hr_transaction_api.get_varchar2_value (
3870: p_transaction_step_id => p_transaction_step_id,
3871: p_name =>'P_VRE_INFORMATION10' );
3872:
3873: l_vre_information11 := hr_transaction_api.get_varchar2_value (
3874: p_transaction_step_id => p_transaction_step_id,
3875: p_name =>'P_VRE_INFORMATION11' );
3876:
3877: l_vre_information12 := hr_transaction_api.get_varchar2_value (
3873: l_vre_information11 := hr_transaction_api.get_varchar2_value (
3874: p_transaction_step_id => p_transaction_step_id,
3875: p_name =>'P_VRE_INFORMATION11' );
3876:
3877: l_vre_information12 := hr_transaction_api.get_varchar2_value (
3878: p_transaction_step_id => p_transaction_step_id,
3879: p_name =>'P_VRE_INFORMATION12' );
3880:
3881: l_vre_information13 := hr_transaction_api.get_varchar2_value (
3877: l_vre_information12 := hr_transaction_api.get_varchar2_value (
3878: p_transaction_step_id => p_transaction_step_id,
3879: p_name =>'P_VRE_INFORMATION12' );
3880:
3881: l_vre_information13 := hr_transaction_api.get_varchar2_value (
3882: p_transaction_step_id => p_transaction_step_id,
3883: p_name =>'P_VRE_INFORMATION13' );
3884:
3885: l_vre_information14 := hr_transaction_api.get_varchar2_value (
3881: l_vre_information13 := hr_transaction_api.get_varchar2_value (
3882: p_transaction_step_id => p_transaction_step_id,
3883: p_name =>'P_VRE_INFORMATION13' );
3884:
3885: l_vre_information14 := hr_transaction_api.get_varchar2_value (
3886: p_transaction_step_id => p_transaction_step_id,
3887: p_name =>'P_VRE_INFORMATION14' );
3888:
3889: l_vre_information15 := hr_transaction_api.get_varchar2_value (
3885: l_vre_information14 := hr_transaction_api.get_varchar2_value (
3886: p_transaction_step_id => p_transaction_step_id,
3887: p_name =>'P_VRE_INFORMATION14' );
3888:
3889: l_vre_information15 := hr_transaction_api.get_varchar2_value (
3890: p_transaction_step_id => p_transaction_step_id,
3891: p_name =>'P_VRE_INFORMATION15' );
3892:
3893: l_vre_information16 := hr_transaction_api.get_varchar2_value (
3889: l_vre_information15 := hr_transaction_api.get_varchar2_value (
3890: p_transaction_step_id => p_transaction_step_id,
3891: p_name =>'P_VRE_INFORMATION15' );
3892:
3893: l_vre_information16 := hr_transaction_api.get_varchar2_value (
3894: p_transaction_step_id => p_transaction_step_id,
3895: p_name =>'P_VRE_INFORMATION16' );
3896:
3897: l_vre_information17 := hr_transaction_api.get_varchar2_value (
3893: l_vre_information16 := hr_transaction_api.get_varchar2_value (
3894: p_transaction_step_id => p_transaction_step_id,
3895: p_name =>'P_VRE_INFORMATION16' );
3896:
3897: l_vre_information17 := hr_transaction_api.get_varchar2_value (
3898: p_transaction_step_id => p_transaction_step_id,
3899: p_name =>'P_VRE_INFORMATION17' );
3900:
3901: l_vre_information18 := hr_transaction_api.get_varchar2_value (
3897: l_vre_information17 := hr_transaction_api.get_varchar2_value (
3898: p_transaction_step_id => p_transaction_step_id,
3899: p_name =>'P_VRE_INFORMATION17' );
3900:
3901: l_vre_information18 := hr_transaction_api.get_varchar2_value (
3902: p_transaction_step_id => p_transaction_step_id,
3903: p_name =>'P_VRE_INFORMATION18' );
3904:
3905:
3902: p_transaction_step_id => p_transaction_step_id,
3903: p_name =>'P_VRE_INFORMATION18' );
3904:
3905:
3906: l_vre_information19 := hr_transaction_api.get_varchar2_value (
3907: p_transaction_step_id => p_transaction_step_id,
3908: p_name =>'P_VRE_INFORMATION19' );
3909:
3910:
3907: p_transaction_step_id => p_transaction_step_id,
3908: p_name =>'P_VRE_INFORMATION19' );
3909:
3910:
3911: l_vre_information20 := hr_transaction_api.get_varchar2_value (
3912: p_transaction_step_id => p_transaction_step_id,
3913: p_name =>'P_VRE_INFORMATION20' );
3914:
3915:
3912: p_transaction_step_id => p_transaction_step_id,
3913: p_name =>'P_VRE_INFORMATION20' );
3914:
3915:
3916: l_across_assignments := hr_transaction_api.get_varchar2_value (
3917: p_transaction_step_id => p_transaction_step_id,
3918: p_name =>'P_ACROSS_ASSIGNMENTS');
3919:
3920:
3917: p_transaction_step_id => p_transaction_step_id,
3918: p_name =>'P_ACROSS_ASSIGNMENTS');
3919:
3920:
3921: l_usage_type := hr_transaction_api.get_varchar2_value (
3922: p_transaction_step_id => p_transaction_step_id,
3923: p_name =>'P_USAGE_TYPE');
3924:
3925: l_default_vehicle := hr_transaction_api.get_varchar2_value (
3921: l_usage_type := hr_transaction_api.get_varchar2_value (
3922: p_transaction_step_id => p_transaction_step_id,
3923: p_name =>'P_USAGE_TYPE');
3924:
3925: l_default_vehicle := hr_transaction_api.get_varchar2_value (
3926: p_transaction_step_id => p_transaction_step_id,
3927: p_name =>'P_DEFAULT_VEHICLE');
3928:
3929: l_fuel_card := hr_transaction_api.get_varchar2_value (
3925: l_default_vehicle := hr_transaction_api.get_varchar2_value (
3926: p_transaction_step_id => p_transaction_step_id,
3927: p_name =>'P_DEFAULT_VEHICLE');
3928:
3929: l_fuel_card := hr_transaction_api.get_varchar2_value (
3930: p_transaction_step_id => p_transaction_step_id,
3931: p_name =>'P_FUEL_CARD');
3932:
3933: l_fuel_card_number := hr_transaction_api.get_varchar2_value (
3929: l_fuel_card := hr_transaction_api.get_varchar2_value (
3930: p_transaction_step_id => p_transaction_step_id,
3931: p_name =>'P_FUEL_CARD');
3932:
3933: l_fuel_card_number := hr_transaction_api.get_varchar2_value (
3934: p_transaction_step_id => p_transaction_step_id,
3935: p_name =>'P_FUEL_CARD_NUMBER');
3936:
3937: l_val_attribute_category := hr_transaction_api.get_varchar2_value (
3933: l_fuel_card_number := hr_transaction_api.get_varchar2_value (
3934: p_transaction_step_id => p_transaction_step_id,
3935: p_name =>'P_FUEL_CARD_NUMBER');
3936:
3937: l_val_attribute_category := hr_transaction_api.get_varchar2_value (
3938: p_transaction_step_id => p_transaction_step_id,
3939: p_name =>'P_VAL_ATTRIBUTE_CATEGORY');
3940:
3941: l_val_attribute1 := hr_transaction_api.get_varchar2_value (
3937: l_val_attribute_category := hr_transaction_api.get_varchar2_value (
3938: p_transaction_step_id => p_transaction_step_id,
3939: p_name =>'P_VAL_ATTRIBUTE_CATEGORY');
3940:
3941: l_val_attribute1 := hr_transaction_api.get_varchar2_value (
3942: p_transaction_step_id => p_transaction_step_id,
3943: p_name =>'P_VAL_ATTRIBUTE1');
3944:
3945: l_val_attribute2 := hr_transaction_api.get_varchar2_value (
3941: l_val_attribute1 := hr_transaction_api.get_varchar2_value (
3942: p_transaction_step_id => p_transaction_step_id,
3943: p_name =>'P_VAL_ATTRIBUTE1');
3944:
3945: l_val_attribute2 := hr_transaction_api.get_varchar2_value (
3946: p_transaction_step_id => p_transaction_step_id,
3947: p_name =>'P_VAL_ATTRIBUTE2');
3948:
3949: l_val_attribute3 := hr_transaction_api.get_varchar2_value (
3945: l_val_attribute2 := hr_transaction_api.get_varchar2_value (
3946: p_transaction_step_id => p_transaction_step_id,
3947: p_name =>'P_VAL_ATTRIBUTE2');
3948:
3949: l_val_attribute3 := hr_transaction_api.get_varchar2_value (
3950: p_transaction_step_id => p_transaction_step_id,
3951: p_name =>'P_VAL_ATTRIBUTE3');
3952:
3953: l_val_attribute4 := hr_transaction_api.get_varchar2_value (
3949: l_val_attribute3 := hr_transaction_api.get_varchar2_value (
3950: p_transaction_step_id => p_transaction_step_id,
3951: p_name =>'P_VAL_ATTRIBUTE3');
3952:
3953: l_val_attribute4 := hr_transaction_api.get_varchar2_value (
3954: p_transaction_step_id => p_transaction_step_id,
3955: p_name =>'P_VAL_ATTRIBUTE4');
3956:
3957: l_val_attribute5 := hr_transaction_api.get_varchar2_value (
3953: l_val_attribute4 := hr_transaction_api.get_varchar2_value (
3954: p_transaction_step_id => p_transaction_step_id,
3955: p_name =>'P_VAL_ATTRIBUTE4');
3956:
3957: l_val_attribute5 := hr_transaction_api.get_varchar2_value (
3958: p_transaction_step_id => p_transaction_step_id,
3959: p_name =>'P_VAL_ATTRIBUTE5');
3960: l_val_attribute6 :=hr_transaction_api.get_varchar2_value (
3961: p_transaction_step_id => p_transaction_step_id,
3956:
3957: l_val_attribute5 := hr_transaction_api.get_varchar2_value (
3958: p_transaction_step_id => p_transaction_step_id,
3959: p_name =>'P_VAL_ATTRIBUTE5');
3960: l_val_attribute6 :=hr_transaction_api.get_varchar2_value (
3961: p_transaction_step_id => p_transaction_step_id,
3962: p_name =>'P_VAL_ATTRIBUTE6');
3963: l_val_attribute7 :=hr_transaction_api.get_varchar2_value (
3964: p_transaction_step_id => p_transaction_step_id,
3959: p_name =>'P_VAL_ATTRIBUTE5');
3960: l_val_attribute6 :=hr_transaction_api.get_varchar2_value (
3961: p_transaction_step_id => p_transaction_step_id,
3962: p_name =>'P_VAL_ATTRIBUTE6');
3963: l_val_attribute7 :=hr_transaction_api.get_varchar2_value (
3964: p_transaction_step_id => p_transaction_step_id,
3965: p_name =>'P_VAL_ATTRIBUTE7');
3966: l_val_attribute8 :=hr_transaction_api.get_varchar2_value (
3967: p_transaction_step_id => p_transaction_step_id,
3962: p_name =>'P_VAL_ATTRIBUTE6');
3963: l_val_attribute7 :=hr_transaction_api.get_varchar2_value (
3964: p_transaction_step_id => p_transaction_step_id,
3965: p_name =>'P_VAL_ATTRIBUTE7');
3966: l_val_attribute8 :=hr_transaction_api.get_varchar2_value (
3967: p_transaction_step_id => p_transaction_step_id,
3968: p_name =>'P_VAL_ATTRIBUTE8');
3969: l_val_attribute9 :=hr_transaction_api.get_varchar2_value (
3970: p_transaction_step_id => p_transaction_step_id,
3965: p_name =>'P_VAL_ATTRIBUTE7');
3966: l_val_attribute8 :=hr_transaction_api.get_varchar2_value (
3967: p_transaction_step_id => p_transaction_step_id,
3968: p_name =>'P_VAL_ATTRIBUTE8');
3969: l_val_attribute9 :=hr_transaction_api.get_varchar2_value (
3970: p_transaction_step_id => p_transaction_step_id,
3971: p_name =>'P_VAL_ATTRIBUTE9');
3972: l_val_attribute10 :=hr_transaction_api.get_varchar2_value (
3973: p_transaction_step_id => p_transaction_step_id,
3968: p_name =>'P_VAL_ATTRIBUTE8');
3969: l_val_attribute9 :=hr_transaction_api.get_varchar2_value (
3970: p_transaction_step_id => p_transaction_step_id,
3971: p_name =>'P_VAL_ATTRIBUTE9');
3972: l_val_attribute10 :=hr_transaction_api.get_varchar2_value (
3973: p_transaction_step_id => p_transaction_step_id,
3974: p_name =>'P_VAL_ATTRIBUTE10');
3975: l_val_attribute11 := hr_transaction_api.get_varchar2_value (
3976: p_transaction_step_id => p_transaction_step_id,
3971: p_name =>'P_VAL_ATTRIBUTE9');
3972: l_val_attribute10 :=hr_transaction_api.get_varchar2_value (
3973: p_transaction_step_id => p_transaction_step_id,
3974: p_name =>'P_VAL_ATTRIBUTE10');
3975: l_val_attribute11 := hr_transaction_api.get_varchar2_value (
3976: p_transaction_step_id => p_transaction_step_id,
3977: p_name =>'P_VAL_ATTRIBUTE11');
3978:
3979: l_val_attribute12 :=hr_transaction_api.get_varchar2_value (
3975: l_val_attribute11 := hr_transaction_api.get_varchar2_value (
3976: p_transaction_step_id => p_transaction_step_id,
3977: p_name =>'P_VAL_ATTRIBUTE11');
3978:
3979: l_val_attribute12 :=hr_transaction_api.get_varchar2_value (
3980: p_transaction_step_id => p_transaction_step_id,
3981: p_name =>'P_VAL_ATTRIBUTE12');
3982: l_val_attribute13 :=hr_transaction_api.get_varchar2_value (
3983: p_transaction_step_id => p_transaction_step_id,
3978:
3979: l_val_attribute12 :=hr_transaction_api.get_varchar2_value (
3980: p_transaction_step_id => p_transaction_step_id,
3981: p_name =>'P_VAL_ATTRIBUTE12');
3982: l_val_attribute13 :=hr_transaction_api.get_varchar2_value (
3983: p_transaction_step_id => p_transaction_step_id,
3984: p_name =>'P_VAL_ATTRIBUTE13');
3985: l_val_attribute14 :=hr_transaction_api.get_varchar2_value (
3986: p_transaction_step_id => p_transaction_step_id,
3981: p_name =>'P_VAL_ATTRIBUTE12');
3982: l_val_attribute13 :=hr_transaction_api.get_varchar2_value (
3983: p_transaction_step_id => p_transaction_step_id,
3984: p_name =>'P_VAL_ATTRIBUTE13');
3985: l_val_attribute14 :=hr_transaction_api.get_varchar2_value (
3986: p_transaction_step_id => p_transaction_step_id,
3987: p_name =>'P_VAL_ATTRIBUTE14');
3988: l_val_attribute15 :=hr_transaction_api.get_varchar2_value (
3989: p_transaction_step_id => p_transaction_step_id,
3984: p_name =>'P_VAL_ATTRIBUTE13');
3985: l_val_attribute14 :=hr_transaction_api.get_varchar2_value (
3986: p_transaction_step_id => p_transaction_step_id,
3987: p_name =>'P_VAL_ATTRIBUTE14');
3988: l_val_attribute15 :=hr_transaction_api.get_varchar2_value (
3989: p_transaction_step_id => p_transaction_step_id,
3990: p_name =>'P_VAL_ATTRIBUTE15');
3991: l_val_attribute16 :=hr_transaction_api.get_varchar2_value (
3992: p_transaction_step_id => p_transaction_step_id,
3987: p_name =>'P_VAL_ATTRIBUTE14');
3988: l_val_attribute15 :=hr_transaction_api.get_varchar2_value (
3989: p_transaction_step_id => p_transaction_step_id,
3990: p_name =>'P_VAL_ATTRIBUTE15');
3991: l_val_attribute16 :=hr_transaction_api.get_varchar2_value (
3992: p_transaction_step_id => p_transaction_step_id,
3993: p_name =>'P_VAL_ATTRIBUTE16');
3994: l_val_attribute17 :=hr_transaction_api.get_varchar2_value (
3995: p_transaction_step_id => p_transaction_step_id,
3990: p_name =>'P_VAL_ATTRIBUTE15');
3991: l_val_attribute16 :=hr_transaction_api.get_varchar2_value (
3992: p_transaction_step_id => p_transaction_step_id,
3993: p_name =>'P_VAL_ATTRIBUTE16');
3994: l_val_attribute17 :=hr_transaction_api.get_varchar2_value (
3995: p_transaction_step_id => p_transaction_step_id,
3996: p_name =>'P_VAL_ATTRIBUTE17');
3997: l_val_attribute18 :=hr_transaction_api.get_varchar2_value (
3998: p_transaction_step_id => p_transaction_step_id,
3993: p_name =>'P_VAL_ATTRIBUTE16');
3994: l_val_attribute17 :=hr_transaction_api.get_varchar2_value (
3995: p_transaction_step_id => p_transaction_step_id,
3996: p_name =>'P_VAL_ATTRIBUTE17');
3997: l_val_attribute18 :=hr_transaction_api.get_varchar2_value (
3998: p_transaction_step_id => p_transaction_step_id,
3999: p_name =>'P_VAL_ATTRIBUTE18');
4000: l_val_attribute19 :=hr_transaction_api.get_varchar2_value (
4001: p_transaction_step_id => p_transaction_step_id,
3996: p_name =>'P_VAL_ATTRIBUTE17');
3997: l_val_attribute18 :=hr_transaction_api.get_varchar2_value (
3998: p_transaction_step_id => p_transaction_step_id,
3999: p_name =>'P_VAL_ATTRIBUTE18');
4000: l_val_attribute19 :=hr_transaction_api.get_varchar2_value (
4001: p_transaction_step_id => p_transaction_step_id,
4002: p_name =>'P_VAL_ATTRIBUTE19');
4003: l_val_attribute20 :=hr_transaction_api.get_varchar2_value (
4004: p_transaction_step_id => p_transaction_step_id,
3999: p_name =>'P_VAL_ATTRIBUTE18');
4000: l_val_attribute19 :=hr_transaction_api.get_varchar2_value (
4001: p_transaction_step_id => p_transaction_step_id,
4002: p_name =>'P_VAL_ATTRIBUTE19');
4003: l_val_attribute20 :=hr_transaction_api.get_varchar2_value (
4004: p_transaction_step_id => p_transaction_step_id,
4005: p_name =>'P_VAL_ATTRIBUTE20');
4006: l_val_information_category := hr_transaction_api.get_varchar2_value (
4007: p_transaction_step_id => p_transaction_step_id,
4002: p_name =>'P_VAL_ATTRIBUTE19');
4003: l_val_attribute20 :=hr_transaction_api.get_varchar2_value (
4004: p_transaction_step_id => p_transaction_step_id,
4005: p_name =>'P_VAL_ATTRIBUTE20');
4006: l_val_information_category := hr_transaction_api.get_varchar2_value (
4007: p_transaction_step_id => p_transaction_step_id,
4008: p_name =>'P_VAL_INFORMATION_CATEGORY');
4009:
4010: l_val_information1 := hr_transaction_api.get_varchar2_value (
4006: l_val_information_category := hr_transaction_api.get_varchar2_value (
4007: p_transaction_step_id => p_transaction_step_id,
4008: p_name =>'P_VAL_INFORMATION_CATEGORY');
4009:
4010: l_val_information1 := hr_transaction_api.get_varchar2_value (
4011: p_transaction_step_id => p_transaction_step_id,
4012: p_name =>'P_VAL_INFORMATION1');
4013:
4014:
4011: p_transaction_step_id => p_transaction_step_id,
4012: p_name =>'P_VAL_INFORMATION1');
4013:
4014:
4015: l_val_information2 := hr_transaction_api.get_varchar2_value (
4016: p_transaction_step_id => p_transaction_step_id,
4017: p_name =>'P_VAL_INFORMATION2');
4018:
4019: l_val_information3 := hr_transaction_api.get_varchar2_value (
4015: l_val_information2 := hr_transaction_api.get_varchar2_value (
4016: p_transaction_step_id => p_transaction_step_id,
4017: p_name =>'P_VAL_INFORMATION2');
4018:
4019: l_val_information3 := hr_transaction_api.get_varchar2_value (
4020: p_transaction_step_id => p_transaction_step_id,
4021: p_name =>'P_VAL_INFORMATION3');
4022:
4023: l_val_information4 := hr_transaction_api.get_varchar2_value (
4019: l_val_information3 := hr_transaction_api.get_varchar2_value (
4020: p_transaction_step_id => p_transaction_step_id,
4021: p_name =>'P_VAL_INFORMATION3');
4022:
4023: l_val_information4 := hr_transaction_api.get_varchar2_value (
4024: p_transaction_step_id => p_transaction_step_id,
4025: p_name =>'P_VAL_INFORMATION4');
4026:
4027: l_val_information5 := hr_transaction_api.get_varchar2_value (
4023: l_val_information4 := hr_transaction_api.get_varchar2_value (
4024: p_transaction_step_id => p_transaction_step_id,
4025: p_name =>'P_VAL_INFORMATION4');
4026:
4027: l_val_information5 := hr_transaction_api.get_varchar2_value (
4028: p_transaction_step_id => p_transaction_step_id,
4029: p_name =>'P_VAL_INFORMATION5');
4030:
4031: l_val_information6 := hr_transaction_api.get_varchar2_value (
4027: l_val_information5 := hr_transaction_api.get_varchar2_value (
4028: p_transaction_step_id => p_transaction_step_id,
4029: p_name =>'P_VAL_INFORMATION5');
4030:
4031: l_val_information6 := hr_transaction_api.get_varchar2_value (
4032: p_transaction_step_id => p_transaction_step_id,
4033: p_name =>'P_VAL_INFORMATION6');
4034:
4035: l_val_information7 := hr_transaction_api.get_varchar2_value (
4031: l_val_information6 := hr_transaction_api.get_varchar2_value (
4032: p_transaction_step_id => p_transaction_step_id,
4033: p_name =>'P_VAL_INFORMATION6');
4034:
4035: l_val_information7 := hr_transaction_api.get_varchar2_value (
4036: p_transaction_step_id => p_transaction_step_id,
4037: p_name =>'P_VAL_INFORMATION7');
4038:
4039: l_val_information8 := hr_transaction_api.get_varchar2_value (
4035: l_val_information7 := hr_transaction_api.get_varchar2_value (
4036: p_transaction_step_id => p_transaction_step_id,
4037: p_name =>'P_VAL_INFORMATION7');
4038:
4039: l_val_information8 := hr_transaction_api.get_varchar2_value (
4040: p_transaction_step_id => p_transaction_step_id,
4041: p_name =>'P_VAL_INFORMATION8');
4042:
4043: l_val_information9 := hr_transaction_api.get_varchar2_value (
4039: l_val_information8 := hr_transaction_api.get_varchar2_value (
4040: p_transaction_step_id => p_transaction_step_id,
4041: p_name =>'P_VAL_INFORMATION8');
4042:
4043: l_val_information9 := hr_transaction_api.get_varchar2_value (
4044: p_transaction_step_id => p_transaction_step_id,
4045: p_name =>'P_VAL_INFORMATION9');
4046:
4047: l_val_information10 := hr_transaction_api.get_varchar2_value (
4043: l_val_information9 := hr_transaction_api.get_varchar2_value (
4044: p_transaction_step_id => p_transaction_step_id,
4045: p_name =>'P_VAL_INFORMATION9');
4046:
4047: l_val_information10 := hr_transaction_api.get_varchar2_value (
4048: p_transaction_step_id => p_transaction_step_id,
4049: p_name =>'P_VAL_INFORMATION10');
4050:
4051: l_val_information11 := hr_transaction_api.get_varchar2_value (
4047: l_val_information10 := hr_transaction_api.get_varchar2_value (
4048: p_transaction_step_id => p_transaction_step_id,
4049: p_name =>'P_VAL_INFORMATION10');
4050:
4051: l_val_information11 := hr_transaction_api.get_varchar2_value (
4052: p_transaction_step_id => p_transaction_step_id,
4053: p_name =>'P_VAL_INFORMATION11');
4054:
4055: l_val_information12 := hr_transaction_api.get_varchar2_value (
4051: l_val_information11 := hr_transaction_api.get_varchar2_value (
4052: p_transaction_step_id => p_transaction_step_id,
4053: p_name =>'P_VAL_INFORMATION11');
4054:
4055: l_val_information12 := hr_transaction_api.get_varchar2_value (
4056: p_transaction_step_id => p_transaction_step_id,
4057: p_name =>'P_VAL_INFORMATION12');
4058:
4059: l_val_information13 := hr_transaction_api.get_varchar2_value (
4055: l_val_information12 := hr_transaction_api.get_varchar2_value (
4056: p_transaction_step_id => p_transaction_step_id,
4057: p_name =>'P_VAL_INFORMATION12');
4058:
4059: l_val_information13 := hr_transaction_api.get_varchar2_value (
4060: p_transaction_step_id => p_transaction_step_id,
4061: p_name =>'P_VAL_INFORMATION13');
4062:
4063: l_val_information14 := hr_transaction_api.get_varchar2_value (
4059: l_val_information13 := hr_transaction_api.get_varchar2_value (
4060: p_transaction_step_id => p_transaction_step_id,
4061: p_name =>'P_VAL_INFORMATION13');
4062:
4063: l_val_information14 := hr_transaction_api.get_varchar2_value (
4064: p_transaction_step_id => p_transaction_step_id,
4065: p_name =>'P_VAL_INFORMATION14');
4066:
4067: l_val_information15 := hr_transaction_api.get_varchar2_value (
4063: l_val_information14 := hr_transaction_api.get_varchar2_value (
4064: p_transaction_step_id => p_transaction_step_id,
4065: p_name =>'P_VAL_INFORMATION14');
4066:
4067: l_val_information15 := hr_transaction_api.get_varchar2_value (
4068: p_transaction_step_id => p_transaction_step_id,
4069: p_name =>'P_VAL_INFORMATION15');
4070:
4071: l_val_information16 := hr_transaction_api.get_varchar2_value (
4067: l_val_information15 := hr_transaction_api.get_varchar2_value (
4068: p_transaction_step_id => p_transaction_step_id,
4069: p_name =>'P_VAL_INFORMATION15');
4070:
4071: l_val_information16 := hr_transaction_api.get_varchar2_value (
4072: p_transaction_step_id => p_transaction_step_id,
4073: p_name =>'P_VAL_INFORMATION16');
4074:
4075: l_val_information17 := hr_transaction_api.get_varchar2_value (
4071: l_val_information16 := hr_transaction_api.get_varchar2_value (
4072: p_transaction_step_id => p_transaction_step_id,
4073: p_name =>'P_VAL_INFORMATION16');
4074:
4075: l_val_information17 := hr_transaction_api.get_varchar2_value (
4076: p_transaction_step_id => p_transaction_step_id,
4077: p_name =>'P_VAL_INFORMATION17');
4078:
4079: l_val_information18 := hr_transaction_api.get_varchar2_value (
4075: l_val_information17 := hr_transaction_api.get_varchar2_value (
4076: p_transaction_step_id => p_transaction_step_id,
4077: p_name =>'P_VAL_INFORMATION17');
4078:
4079: l_val_information18 := hr_transaction_api.get_varchar2_value (
4080: p_transaction_step_id => p_transaction_step_id,
4081: p_name =>'P_VAL_INFORMATION18');
4082:
4083: l_val_information19 := hr_transaction_api.get_varchar2_value (
4079: l_val_information18 := hr_transaction_api.get_varchar2_value (
4080: p_transaction_step_id => p_transaction_step_id,
4081: p_name =>'P_VAL_INFORMATION18');
4082:
4083: l_val_information19 := hr_transaction_api.get_varchar2_value (
4084: p_transaction_step_id => p_transaction_step_id,
4085: p_name =>'P_VAL_INFORMATION19');
4086:
4087: l_val_information20 := hr_transaction_api.get_varchar2_value (
4083: l_val_information19 := hr_transaction_api.get_varchar2_value (
4084: p_transaction_step_id => p_transaction_step_id,
4085: p_name =>'P_VAL_INFORMATION19');
4086:
4087: l_val_information20 := hr_transaction_api.get_varchar2_value (
4088: p_transaction_step_id => p_transaction_step_id,
4089: p_name =>'P_VAL_INFORMATION20');
4090:
4091: l_fuel_benefit := hr_transaction_api.get_varchar2_value (
4087: l_val_information20 := hr_transaction_api.get_varchar2_value (
4088: p_transaction_step_id => p_transaction_step_id,
4089: p_name =>'P_VAL_INFORMATION20');
4090:
4091: l_fuel_benefit := hr_transaction_api.get_varchar2_value (
4092: p_transaction_step_id => p_transaction_step_id,
4093: p_name =>'P_FUEL_BENEFIT');
4094:
4095:
4092: p_transaction_step_id => p_transaction_step_id,
4093: p_name =>'P_FUEL_BENEFIT');
4094:
4095:
4096: l_vehicle_repository_id := hr_transaction_api.get_number_value (
4097: p_transaction_step_id => p_transaction_step_id,
4098: p_name =>'P_VEHICLE_REPOSITORY_ID');
4099: l_vehicle_allocation_id := hr_transaction_api.get_number_value (
4100: p_transaction_step_id => p_transaction_step_id,
4095:
4096: l_vehicle_repository_id := hr_transaction_api.get_number_value (
4097: p_transaction_step_id => p_transaction_step_id,
4098: p_name =>'P_VEHICLE_REPOSITORY_ID');
4099: l_vehicle_allocation_id := hr_transaction_api.get_number_value (
4100: p_transaction_step_id => p_transaction_step_id,
4101: p_name =>'P_VEHICLE_ALLOCATION_ID');
4102: l_object_version_number := hr_transaction_api.get_number_value (
4103: p_transaction_step_id => p_transaction_step_id,
4098: p_name =>'P_VEHICLE_REPOSITORY_ID');
4099: l_vehicle_allocation_id := hr_transaction_api.get_number_value (
4100: p_transaction_step_id => p_transaction_step_id,
4101: p_name =>'P_VEHICLE_ALLOCATION_ID');
4102: l_object_version_number := hr_transaction_api.get_number_value (
4103: p_transaction_step_id => p_transaction_step_id,
4104: p_name =>'P_OBJECT_VERSION_NUMBER');
4105:
4106:
4109: CLOSE c_get_count;
4110:
4111: FOR i in 1..l_get_count
4112: LOOP
4113: l_user_info (i).person_id :=hr_transaction_api.get_number_value (
4114: p_transaction_step_id => p_transaction_step_id,
4115: p_name =>'P_PERSON_USR_ID'||i);
4116:
4117: l_user_info (i).assignment_id :=hr_transaction_api.get_number_value (
4113: l_user_info (i).person_id :=hr_transaction_api.get_number_value (
4114: p_transaction_step_id => p_transaction_step_id,
4115: p_name =>'P_PERSON_USR_ID'||i);
4116:
4117: l_user_info (i).assignment_id :=hr_transaction_api.get_number_value (
4118: p_transaction_step_id => p_transaction_step_id,
4119: p_name =>'P_ASSIGNMENT_USR_ID'||i);
4120:
4121:
4118: p_transaction_step_id => p_transaction_step_id,
4119: p_name =>'P_ASSIGNMENT_USR_ID'||i);
4120:
4121:
4122: l_user_info (i).user_type :=hr_transaction_api.get_varchar2_value (
4123: p_transaction_step_id => p_transaction_step_id,
4124: p_name =>'P_USER_TYPE'||i);
4125:
4126: