451: -- p_addon_rates used for mileage category only
452: p_addon_rates IN OIE_ADDON_RATES_T, -- array of additional rate types
453: p_report_line_id IN NUMBER DEFAULT NULL, -- report line id
454: -- below fields are used for per diem category only
455: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identifer for daily breakups
456: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date
457: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date
458: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of amount
459: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of number of meals
454: -- below fields are used for per diem category only
455: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identifer for daily breakups
456: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date
457: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date
458: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of amount
459: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of number of meals
460: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of meals amount
461: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,-- array of breakfast flag
462: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of lunch flag
455: p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identifer for daily breakups
456: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date
457: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date
458: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of amount
459: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of number of meals
460: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of meals amount
461: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,-- array of breakfast flag
462: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of lunch flag
463: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of dinner flag
456: p_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date
457: p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date
458: p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of amount
459: p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of number of meals
460: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of meals amount
461: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,-- array of breakfast flag
462: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of lunch flag
463: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of dinner flag
464: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of accommodation amount
460: p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of meals amount
461: p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,-- array of breakfast flag
462: p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of lunch flag
463: p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of dinner flag
464: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of accommodation amount
465: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of accommodation flag
466: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of hotel name
467: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of night rate type
468: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of night rate amount
464: p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of accommodation amount
465: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of accommodation flag
466: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of hotel name
467: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of night rate type
468: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of night rate amount
469: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of pdm rate
470: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of rate type code
471: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identified for multiple destinations
472: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations for each breakup period
465: p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of accommodation flag
466: p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of hotel name
467: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of night rate type
468: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of night rate amount
469: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of pdm rate
470: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of rate type code
471: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identified for multiple destinations
472: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations for each breakup period
473: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date for each location
467: p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of night rate type
468: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of night rate amount
469: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of pdm rate
470: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of rate type code
471: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identified for multiple destinations
472: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations for each breakup period
473: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date for each location
474: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date for each location
475: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
468: p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of night rate amount
469: p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of pdm rate
470: p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of rate type code
471: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identified for multiple destinations
472: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations for each breakup period
473: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date for each location
474: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date for each location
475: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
476: -- bug 5358186
471: p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identified for multiple destinations
472: p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations for each breakup period
473: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date for each location
474: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date for each location
475: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
476: -- bug 5358186
477: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T, -- array of modified meals amount
478: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified accommodation amount
479: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified night rate amount
473: p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date for each location
474: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date for each location
475: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
476: -- bug 5358186
477: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T, -- array of modified meals amount
478: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified accommodation amount
479: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified night rate amount
480: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T-- array of modified pdm rate
481: )
474: p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date for each location
475: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
476: -- bug 5358186
477: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T, -- array of modified meals amount
478: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified accommodation amount
479: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified night rate amount
480: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T-- array of modified pdm rate
481: )
482: ---------------------------------------------------------------------------
475: p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
476: -- bug 5358186
477: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T, -- array of modified meals amount
478: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified accommodation amount
479: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified night rate amount
480: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T-- array of modified pdm rate
481: )
482: ---------------------------------------------------------------------------
483: IS
476: -- bug 5358186
477: p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T, -- array of modified meals amount
478: p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified accommodation amount
479: p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified night rate amount
480: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T-- array of modified pdm rate
481: )
482: ---------------------------------------------------------------------------
483: IS
484: l_miles NUMBER;