APPS.QPR_COLLECT_TIME_DATA SQL Statements

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

Line: 55

  r_time_data.CALENDAR_CODE.delete;

Line: 56

  r_time_data.YEAR.delete;

Line: 57

  r_time_data.YEAR_DESC.delete;

Line: 58

  r_time_data.YEAR_STDT.delete;

Line: 59

  r_time_data.YEAR_ENDT.delete;

Line: 60

  r_time_data.QUARTER.delete;

Line: 61

  r_time_data.QUARTER_DESC.delete;

Line: 62

  r_time_data.QUARTER_STDT.delete;

Line: 63

  r_time_data.QUARTER_ENDT.delete;

Line: 64

  r_time_data.MONTH.delete;

Line: 65

  r_time_data.MONTH_DESC.delete;

Line: 66

  r_time_data.MONTH_STDT.delete;

Line: 67

  r_time_data.MONTH_ENDT.delete;

Line: 68

  r_time_data.DAY.delete;

Line: 69

  r_time_data.DAY_DESC.delete;

Line: 74

  r_fis_cal.CALENDAR_CODE.delete;

Line: 75

  r_fis_cal.YEAR.delete;

Line: 76

  r_fis_cal.YEAR_DESC.delete;

Line: 77

  r_fis_cal.YEAR_STDT.delete;

Line: 78

  r_fis_cal.YEAR_ENDT.delete;

Line: 79

  r_fis_cal.QUARTER.delete;

Line: 80

  r_fis_cal.QUARTER_DESC.delete;

Line: 81

  r_fis_cal.QUARTER_STDT.delete;

Line: 82

  r_fis_cal.QUARTER_ENDT.delete;

Line: 83

  r_fis_cal.MONTH.delete;

Line: 84

  r_fis_cal.MONTH_DESC.delete;

Line: 85

  r_fis_cal.MONTH_STDT.delete;

Line: 86

  r_fis_cal.MONTH_ENDT.delete;

Line: 89

procedure insert_time_data(p_instance_id in number,
                           p_cal_type in number) is
begin
  forall i in r_time_data.YEAR.first..r_time_data.YEAR.last
    insert into QPR_TIME(TIME_ID,INSTANCE_ID,CALENDAR_TYPE, CALENDAR_CODE,
                         YEAR,YEAR_DESCRIPTION,YEAR_START_DATE,
                         YEAR_END_DATE,QUARTER,QUARTER_DESCRIPTION,
                         QUARTER_START_DATE,QUARTER_END_DATE,MONTH,
                         MONTH_DESCRIPTION,MONTH_START_DATE,MONTH_END_DATE, DAY,
                         DAY_DESCRIPTION,CREATION_DATE, CREATED_BY,
                         LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
                         PROGRAM_APPLICATION_ID,PROGRAM_ID,REQUEST_ID)
            values(QPR_TIME_S.nextval, p_instance_id, p_cal_type,
                   r_time_data.CALENDAR_CODE(i), r_time_data.YEAR(i),
                   r_time_data.YEAR_DESC(i),
                   r_time_data.YEAR_STDT(i),
                   r_time_data.YEAR_ENDT(i),
                   r_time_data.QUARTER(i),
                   r_time_data.QUARTER_DESC(i),
                   r_time_data.QUARTER_STDT(i),
                   r_time_data.QUARTER_ENDT(i),
                   r_time_data.MONTH(i),
                   r_time_data.MONTH_DESC(i),
                   r_time_data.MONTH_STDT(i),
                   r_time_data.MONTH_ENDT(i),
                   r_time_data.DAY(i), r_time_data.DAY_DESC(i),
                   sys_date, user_id, sys_date, user_id,login_id,
                   prg_appl_id, prg_id, request_id);

Line: 120

      fnd_file.put_line(fnd_file.log, 'ERROR INSERTING TIME DATA');

Line: 123

end insert_time_data;

Line: 135

        'Inserting values for fiscal year ' || prev_year || ' of calendar code '
        || prev_cal_code);

Line: 137

        insert_time_data(p_instance_id, FISCAL_CALENDAR);

Line: 164

        'Inserting values for fiscal year ' || prev_year || ' of calendar code '
        || prev_cal_code);

Line: 166

    insert_time_data(p_instance_id, FISCAL_CALENDAR);

Line: 323

    insert_time_data(-1, GREGORIAN_CALENDAR);

Line: 359

    delete QPR_TIME
    where CALENDAR_TYPE = GREGORIAN_CALENDAR
    and day between date_from and date_to;

Line: 369

    l_sql_check_cal := 'select count(period_set_name) from ';

Line: 387

      delete QPR_TIME
      where INSTANCE_ID = p_instance_id
      and CALENDAR_TYPE = FISCAL_CALENDAR
      and day between date_from and date_to;

Line: 392

      delete QPR_TIME
      where INSTANCE_ID = p_instance_id
      and CALENDAR_TYPE = FISCAL_CALENDAR
      and CALENDAR_CODE = p_calendar_code
      and day between date_from and date_to;

Line: 401

    s_sql := 'select CALENDAR_CODE, YEAR,YEAR_DESCRIPTION,YEAR_START_DATE, ';