APPS.AP_WEB_VALIDATE_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 220

  l_DataDefaultedUpdateable BOOLEAN;

Line: 331

        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
        );

Line: 395

        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
      );

Line: 1124

	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;

Line: 1346

          p_DataDefaultedUpdateable := TRUE;

Line: 1348

          p_DataDefaultedUpdateable := FALSE;

Line: 1595

	  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;

Line: 2094

	 debug_info := 'No expense type selected';

Line: 2409

  l_DataDefaultedUpdateable     BOOLEAN;

Line: 2524

			       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
                         );

Line: 2557

  IF (l_DataDefaultedUpdateable) THEN
    fnd_message.set_name('SQLAP', 'OIE_DATA_CALCULATED_DIFFER');