APPS.CN_SEAS_SCHEDULES_PVT SQL Statements

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

Line: 58

      SELECT cp.period_id,cp.period_name,ccpit.interval_number,ccpit.cal_per_int_type_id
      FROM cn_period_statuses cp,cn_cal_per_int_types ccpit
      WHERE period_year = p_period_year and cp.period_id = ccpit.cal_period_id and interval_type_id = -1002;

Line: 112

   SELECT COUNT(*) INTO l_count FROM CN_SEAS_SCHEDULES WHERE UPPER(NAME) LIKE UPPER(p_seas_schedules_rec_type.name);

Line: 124

   select min(start_date),max(end_date) into l_start_date,l_end_date
   from cn_period_statuses
   where period_year = p_seas_schedules_rec_type.period_year
   group by period_year;

Line: 131

   CN_SEAS_SCHEDULES_pkg.insert_row (
     P_SEAS_SCHEDULE_ID => p_seas_schedules_rec_type.seas_schedule_id,
     P_NAME             => p_seas_schedules_rec_type.name,
     P_DESCRIPTION      => p_seas_schedules_rec_type.description,
     P_PERIOD_YEAR      => p_seas_schedules_rec_type.period_year,
     P_START_DATE       => l_start_date,
     P_END_DATE         => l_end_date,
     P_VALIDATION_STATUS => 'INVALID'
   );

Line: 144

   SELECT SEAS_SCHEDULE_ID INTO l_seas_schedule_id
   FROM CN_SEAS_SCHEDULES WHERE NAME like p_seas_schedules_rec_type.name;

Line: 151

   SELECT COUNT(*) INTO l_cal_int_types
      FROM cn_period_statuses cp,cn_cal_per_int_types ccpit
      WHERE period_year = p_seas_schedules_rec_type.period_year and cp.period_id = ccpit.cal_period_id and interval_type_id = -1002;

Line: 168

        CN_SEASONALITIES_pkg.insert_row(
            P_SEASONALITY_ID    => -99,
            P_SEAS_SCHEDULE_ID  => l_seas_schedule_id,
            P_CAL_PER_INT_TYPE_ID => l_seas_sch.CAL_PER_INT_TYPE_ID,
            P_PERIOD_ID         => l_seas_sch.PERIOD_ID,
            P_PCT_SEASONALITY   => 0.0
        );

Line: 267

PROCEDURE Update_Seas_Schedule
 ( 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_seas_schedules_rec_type IN     seas_schedules_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_Seas_Schedule';

Line: 289

   SAVEPOINT   Update_Seas_Schedule;

Line: 305

    select COUNT(*) INTO l_srp_count from cn_srp_role_dtls t1,cn_role_quota_cates t2,cn_srp_roles t3
    where t1.srp_role_id = t3.srp_role_id
    and t2.role_id = t3.role_id
    and t1.status not in ('PENDING')
    and t2.seas_schedule_id = p_seas_schedules_rec_type.seas_schedule_id;

Line: 346

   SELECT COUNT(*) INTO l_count FROM CN_SEAS_SCHEDULES WHERE UPPER(NAME) LIKE UPPER(p_seas_schedules_rec_type.name) AND SEAS_SCHEDULE_ID <> p_seas_schedules_rec_type.seas_schedule_id;

Line: 375

   CN_SEAS_SCHEDULES_pkg.update_row
   (
     P_SEAS_SCHEDULE_ID  => p_seas_schedules_rec_type.seas_schedule_id,
     P_NAME              => p_seas_schedules_rec_type.name,
     P_DESCRIPTION       => p_seas_schedules_rec_type.description,
     P_PERIOD_YEAR       => p_seas_schedules_rec_type.period_year,
     P_START_DATE        => l_start_date,
     P_END_DATE          => l_end_date,
     P_VALIDATION_STATUS => l_validation_status,
     p_object_version_number => p_seas_schedules_rec_type.object_version_number
    );

Line: 389

   << end_Update_Seas_Schedule >>
   NULL;

Line: 406

      ROLLBACK TO Update_Seas_Schedule  ;

Line: 416

      ROLLBACK TO Update_Seas_Schedule ;

Line: 425

      ROLLBACK TO Update_Seas_Schedule ;

Line: 447

END Update_Seas_Schedule;

Line: 480

PROCEDURE Delete_Seas_Schedule
 ( 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_SEAS_SCHEDULE_ID        IN     cn_seas_schedules.seas_schedule_id%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) := 'Delete_Seas_Schedule';

Line: 498

   SAVEPOINT   Delete_Seas_Schedule;

Line: 520

   SELECT COUNT(role_id) INTO l_role_quota_cate_count FROM CN_ROLE_QUOTA_CATES WHERE seas_schedule_id = P_SEAS_SCHEDULE_ID;

Line: 531

   CN_SEAS_SCHEDULES_pkg.delete_row (P_SEAS_SCHEDULE_ID => l_seas_sch_id);

Line: 534

   CN_SEASONALITIES_pkg.delete_row (P_SEAS_SCHEDULE_ID => l_seas_sch_id);

Line: 537

   << end_Delete_Seas_Schedule >>
   NULL;

Line: 554

      ROLLBACK TO Delete_Seas_Schedule  ;

Line: 564

      ROLLBACK TO Delete_Seas_Schedule ;

Line: 573

      ROLLBACK TO Delete_Seas_Schedule ;

Line: 595

END Delete_Seas_Schedule;

Line: 660

   select seas_schedule_id,sum(pct_seasonality) into l_seas_schedule_id,l_pct_seasonality
   from cn_seasonalities
   where seas_schedule_id = p_seas_schedules_id group by seas_schedule_id;

Line: 667

   << end_Delete_Seas_Schedule >>
   NULL;