APPS.IGI_IAC_REBASE_PKG SQL Statements

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

Line: 29

   	Select price_index_id from igi_iac_price_indexes where
   	price_index_name = p_price_index_name;

Line: 36

   	Select cal_price_index_link_id from igi_iac_cal_price_indexes where
   	calendar_type = calendar and
   	price_index_id = p_price_index_id;

Line: 44

   	Select iciv.*,iciv.rowid from igi_iac_cal_idx_values  iciv where
   	cal_price_index_link_id = p_cal_price_link_id;

Line: 52

	  Select  iciv.current_price_index_value from
	  igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp
	 	where  fcp.start_date = iciv.date_from and
                       fcp.end_date = iciv.date_to and
		       fcp.calendar_type = p_calendar and
		       fcp.period_name = p_period and
		       iciv.cal_price_index_link_id = p_link_id;

Line: 60

   /*	Select iciv.current_price_index_value from igi_iac_cal_idx_values iciv , fa_calendar_periods fcp where
   	fcp.calendar_type = calendar and
   	fcp.period_name = period_name and
   	iciv.date_from = fcp.start_date and
   	iciv.date_to = fcp.end_date and
   	cal_price_index_link_id = p_link_id;*/

Line: 70

   	Select icpi.rowid , icpi.* from igi_iac_cal_price_indexes icpi
   	where icpi.cal_price_index_link_id = p_link_id;

Line: 77

   	Select fap.period_name from fa_calendar_periods fap
   	where start_date =l_date_from and  end_date = l_date_to and
   	      calendar_type= calendar;

Line: 83

   	select curr.precision
            from fnd_currencies curr, gl_sets_of_books sob
            where curr.currency_code = sob.currency_code
            and  sob.set_of_books_id =  p_sob_id;

Line: 181

   	/* Update the price indexes of all periods of the calendar using the factor */
   	for l_current_price_idx_rec in  c_get_curr_price_ind_val(l_link_id) loop
   		/* Get the period name */
		open c_get_period_name(l_current_price_idx_rec.date_from,l_current_price_idx_rec.date_to);

Line: 216

   		/* call to update the igi_iac_cal_idx_values using the TBH */

   		 igi_iac_cal_idx_values_pkg.update_row (
		      x_mode                              => 'R',
		      x_rowid                             => l_current_price_idx_rec.rowid,
		      x_cal_price_index_link_id           => l_current_price_idx_rec.cal_price_index_link_id,
		      x_date_from                         => l_current_price_idx_rec.date_from,
		      x_date_to                           => l_current_price_idx_rec.date_to,
		      x_original_price_index_value        => l_current_price_idx_rec.original_price_index_value,
		      x_current_price_index_value         => l_new_curr_price_idx_val
		    );

Line: 236

	/*Update the igi_iac_cal_price_indexes table to record the rebase period name and price_index details */
	igi_iac_cal_price_indexes_pkg.update_row (
   		   x_mode                              => 'R',
		   x_rowid                             => l_cal_price_indexes_rec.rowid,
		   x_cal_price_index_link_id           => l_cal_price_indexes_rec.cal_price_index_link_id,
	           x_price_index_id                    => l_cal_price_indexes_rec.price_index_id,
		   x_calendar_type                     => l_cal_price_indexes_rec.calendar_type,
     		   x_previous_rebase_period_name       => period_name,
		   x_previous_rebase_date              => trunc(sysdate),
		   x_previous_rebase_index_before      => l_factor_price_index,
		   x_previous_rebase_index_after       => new_price_index_value
	    );