APPS.CN_SEASONALITIES_PVT SQL Statements

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

Line: 35

PROCEDURE Update_Seasonalities
 ( p_api_version             IN     NUMBER  ,
   p_init_msg_list           IN     VARCHAR2 := FND_API.G_FALSE     ,
   p_commit                  IN     VARCHAR2 := FND_API.G_FALSE     ,
   p_validation_level        IN     NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   p_seasonalities_rec_type  IN     seasonalities_rec_type,
   x_return_status           OUT NOCOPY    VARCHAR2 ,
   x_msg_count               OUT NOCOPY    NUMBER ,
   x_msg_data                OUT NOCOPY    VARCHAR2
 ) IS
      l_api_name     CONSTANT VARCHAR2(30) := 'Update_Seasonalities';

Line: 58

   SAVEPOINT   Update_Seasonalities;

Line: 78

   SELECT OBJECT_VERSION_NUMBER,NAME,DESCRIPTION INTO l_rec.object_version_number,l_rec.name,l_rec.description
   FROM CN_SEAS_SCHEDULES WHERE SEAS_SCHEDULE_ID = p_seasonalities_rec_type.SEAS_SCHEDULE_ID;

Line: 85

    cn_seas_schedules_PVT.Update_Seas_Schedule
    ( p_api_version          => 1.0,
      p_init_msg_list        => FND_API.G_FALSE,
      p_commit               => FND_API.G_FALSE,
      p_validation_level     => FND_API.G_VALID_LEVEL_FULL,
      p_seas_schedules_rec_type => l_rec,
      x_return_status        => l_return_status ,
      x_msg_count            => l_msg_count,
      x_msg_data             => l_msg_data
    );

Line: 105

    CN_SEASONALITIES_pkg.update_row
    (
          P_SEASONALITY_ID        => p_seasonalities_rec_type.seasonality_id,
          P_SEAS_SCHEDULE_ID      => p_seasonalities_rec_type.SEAS_SCHEDULE_ID,
          p_CAL_PER_INT_TYPE_ID   => FND_API.G_MISS_NUM,
          P_PERIOD_ID             => FND_API.G_MISS_NUM,
          P_PCT_SEASONALITY       => p_seasonalities_rec_type.pct_seasonality,
          P_OBJECT_VERSION_NUMBER => p_seasonalities_rec_type.OBJECT_VERSION_NUMBER
    );

Line: 118

   << end_Update_Seasonalities >>
   NULL;

Line: 135

      ROLLBACK TO Update_Seasonalities  ;

Line: 145

      ROLLBACK TO Update_Seasonalities ;

Line: 154

      ROLLBACK TO Update_Seasonalities ;

Line: 176

END Update_Seasonalities;

Line: 227

      SELECT PCT_SEASONALITY FROM CN_SEASONALITIES
      WHERE seas_schedule_id = p_seas_sch_id;

Line: 262

    SELECT NAME,DESCRIPTION,PERIOD_YEAR,START_DATE,END_DATE INTO l_rec.name,l_rec.description,
           l_rec.period_year,l_rec.start_date,L_rec.end_date from cn_seas_schedules
           where seas_schedule_id = p_seas_schedule_rec_type.SEAS_SCHEDULE_ID;

Line: 266

    cn_seas_schedules_PVT.Update_Seas_Schedule
    ( p_api_version          => 1.0,
      p_init_msg_list        => FND_API.G_FALSE,
      p_commit               => FND_API.G_FALSE,
      p_validation_level     => FND_API.G_VALID_LEVEL_FULL,
      p_seas_schedules_rec_type => l_rec,
      x_return_status        => l_return_status ,
      x_msg_count            => l_msg_count,
      x_msg_data             => l_msg_data
    );