The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_DataDefaultedUpdateable BOOLEAN;
l_DataDefaultedUpdateable,
FALSE,
false,
p_addon_rates,
p_report_line_id,
p_daily_breakup_id,
p_start_date,
p_end_date,
p_amount,
p_number_of_meals,
p_meals_amount,
p_breakfast_flag,
p_lunch_flag,
p_dinner_flag,
p_accommodation_amount,
p_accommodation_flag,
p_hotel_name,
p_night_rate_Type,
p_night_rate_amount,
p_pdm_rate,
p_rate_Type_code,
p_pdm_breakup_dest_id,
p_pdm_destination_id,
p_dest_start_date,
p_dest_end_date,
p_location_id,
p_cust_meals_amount,
p_cust_accommodation_amount,
p_cust_night_rate_amount,
p_cust_pdm_rate
);
l_DataDefaultedUpdateable,
FALSE,
TRUE, -- for Blue Gray UI,
p_addon_rates,
p_report_line_id,
p_daily_breakup_id,
p_start_date,
p_end_date,
p_amount,
p_number_of_meals,
p_meals_amount,
p_breakfast_flag,
p_lunch_flag,
p_dinner_flag,
p_accommodation_amount,
p_accommodation_flag,
p_hotel_name,
p_night_rate_Type,
p_night_rate_amount,
p_pdm_rate,
p_rate_Type_code,
p_pdm_breakup_dest_id,
p_pdm_destination_id,
p_dest_start_date,
p_dest_end_date,
p_location_id,
p_cust_meals_amount,
p_cust_accommodation_amount,
p_cust_night_rate_amount,
p_cust_pdm_rate
);
p_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN,
p_bCalling_from_disconnected IN BOOLEAN,
p_bForBlueGray IN BOOLEAN default FALSE,
p_addon_rates IN OIE_ADDON_RATES_T DEFAULT NULL,
p_report_line_id IN NUMBER DEFAULT NULL,
p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,
p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL,
p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL,
p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,
p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL,
p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,
p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
)
----------------------------------------------------------------------------
IS
l_receipt_custom_fields_array AP_WEB_DFLEX_PKG.CustomFields_A;
p_DataDefaultedUpdateable := TRUE;
p_DataDefaultedUpdateable := FALSE;
select TIME_BASED_ENTRY_FLAG into l_time_based_entry_flag from AP_POL_HEADERS aph, AP_EXPENSE_REPORT_PARAMS_ALL param where aph.POLICY_ID = param.COMPANY_POLICY_ID and param.PARAMETER_ID = p_report_line_info.parameter_id;
debug_info := 'No expense type selected';
l_DataDefaultedUpdateable BOOLEAN;
l_DataDefaultedUpdateable,
p_bCalling_from_disconnected,
false,
p_addon_rates,
p_report_line_id,
p_daily_breakup_id,
p_start_date,
p_end_date,
p_amount,
p_number_of_meals,
p_meals_amount,
p_breakfast_flag,
p_lunch_flag,
p_dinner_flag,
p_accommodation_amount,
p_accommodation_flag,
p_hotel_name,
p_night_rate_Type,
p_night_rate_amount,
p_pdm_rate,
p_rate_Type_code,
p_pdm_breakup_dest_id,
p_pdm_destination_id,
p_dest_start_date,
p_dest_end_date,
p_location_id,
p_cust_meals_amount,
p_cust_accommodation_amount,
p_cust_night_rate_amount,
p_cust_pdm_rate
);
IF (l_DataDefaultedUpdateable) THEN
fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');