APPS.CN_SEAS_SCHEDULES_PKG SQL Statements

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

Line: 4

PROCEDURE insert_row
  (P_SEAS_SCHEDULE_ID  IN cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE,
   P_NAME              IN cn_seas_schedules.NAME%TYPE,
   P_DESCRIPTION       IN cn_seas_schedules.DESCRIPTION%TYPE := NULL,
   P_PERIOD_YEAR       IN cn_seas_schedules.PERIOD_YEAR%TYPE,
   P_START_DATE        IN cn_seas_schedules.START_DATE%TYPE,
   P_END_DATE          IN cn_seas_schedules.END_DATE%TYPE,
   P_VALIDATION_STATUS IN cn_seas_schedules.VALIDATION_STATUS%TYPE,
   p_attribute_category IN cn_seas_schedules.attribute_category%TYPE := NULL,
   p_attribute1 IN cn_seas_schedules.attribute1%TYPE := NULL,
   p_attribute2 IN cn_seas_schedules.attribute2%TYPE := NULL,
   p_attribute3 IN cn_seas_schedules.attribute3%TYPE := NULL,
   p_attribute4 IN cn_seas_schedules.attribute4%TYPE := NULL,
   p_attribute5 IN cn_seas_schedules.attribute5%TYPE := NULL,
   p_attribute6 IN cn_seas_schedules.attribute6%TYPE := NULL,
   p_attribute7 IN cn_seas_schedules.attribute7%TYPE := NULL,
   p_attribute8 IN cn_seas_schedules.attribute8%TYPE := NULL,
   p_attribute9 IN cn_seas_schedules.attribute9%TYPE := NULL,
   p_attribute10 IN cn_seas_schedules.attribute10%TYPE := NULL,
   p_attribute11 IN cn_seas_schedules.attribute11%TYPE := NULL,
   p_attribute12 IN cn_seas_schedules.attribute12%TYPE := NULL,
   p_attribute13 IN cn_seas_schedules.attribute13%TYPE := NULL,
   p_attribute14 IN cn_seas_schedules.attribute14%TYPE := NULL,
   p_attribute15 IN cn_seas_schedules.attribute15%TYPE := NULL,
   p_created_by IN  cn_seas_schedules.created_by%TYPE := NULL,
   p_creation_date IN cn_seas_schedules.creation_date%TYPE := NULL,
   p_last_update_login IN cn_seas_schedules.last_update_login%TYPE := NULL,
   p_last_update_date IN cn_seas_schedules.last_update_date%TYPE := NULL,
   p_last_updated_by IN cn_seas_schedules.last_updated_by%TYPE := NULL,
   p_OBJECT_VERSION_NUMBER IN cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE := NULL)
   IS
   MN NUMBER        := FND_API.G_MISS_NUM;

Line: 40

   INSERT INTO cn_seas_schedules(
     SEAS_SCHEDULE_ID,
     NAME,
     DESCRIPTION,
     PERIOD_YEAR,
     START_DATE,
     END_DATE,
     VALIDATION_STATUS,
     attribute_category,
     attribute1,
     attribute2,
     attribute3,
     attribute4,
     attribute5,
     attribute6,
     attribute7,
     attribute8,
     attribute9,
     attribute10,
     attribute11,
     attribute12,
     attribute13,
     attribute14,
     attribute15,
     CREATED_BY,
     CREATION_DATE,
     LAST_UPDATE_LOGIN,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     object_version_number
   )
   SELECT
     cn_seas_schedules_s.nextval,
     P_NAME,
     decode(P_DESCRIPTION,mc,null,P_DESCRIPTION),
     decode(P_PERIOD_YEAR,mn,null,P_PERIOD_YEAR),
     decode(P_START_DATE,md,null,P_START_DATE),
     decode(P_END_DATE,md,null,P_END_DATE),
     decode(P_VALIDATION_STATUS,mc,null,P_VALIDATION_STATUS),
     decode(p_attribute_category, mc, null, p_attribute_category),
     decode(p_attribute1, mc, null, p_attribute1),
     decode(p_attribute2, mc, null, p_attribute2),
     decode(p_attribute3, mc, null, p_attribute3),
     decode(p_attribute4, mc, null, p_attribute4),
     decode(p_attribute5, mc, null, p_attribute5),
     decode(p_attribute6, mc, null, p_attribute6),
     decode(p_attribute7, mc, null, p_attribute7),
     decode(p_attribute8, mc, null, p_attribute8),
     decode(p_attribute9, mc, null, p_attribute9),
     decode(p_attribute10, mc, null, p_attribute10),
     decode(p_attribute11, mc, null, p_attribute11),
     decode(p_attribute12, mc, null, p_attribute12),
     decode(p_attribute13, mc, null, p_attribute13),
     decode(p_attribute14, mc, null, p_attribute14),
     decode(p_attribute15, mc, null, p_attribute15),
     fnd_global.user_id,
     sysdate,
     fnd_global.login_id,
     sysdate,
     fnd_global.user_id,
     1
    FROM dual;

Line: 102

END insert_row;

Line: 105

PROCEDURE update_row
  (P_SEAS_SCHEDULE_ID  IN cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE,
   P_NAME              IN cn_seas_schedules.NAME%TYPE,
   P_DESCRIPTION       IN cn_seas_schedules.DESCRIPTION%TYPE := NULL,
   P_PERIOD_YEAR       IN cn_seas_schedules.PERIOD_YEAR%TYPE,
   P_START_DATE        IN cn_seas_schedules.START_DATE%TYPE,
   P_END_DATE          IN cn_seas_schedules.END_DATE%TYPE,
   P_VALIDATION_STATUS IN cn_seas_schedules.VALIDATION_STATUS%TYPE,
   p_attribute_category IN cn_seas_schedules.attribute_category%TYPE := NULL,
   p_attribute1 IN cn_seas_schedules.attribute1%TYPE := NULL,
   p_attribute2 IN cn_seas_schedules.attribute2%TYPE := NULL,
   p_attribute3 IN cn_seas_schedules.attribute3%TYPE := NULL,
   p_attribute4 IN cn_seas_schedules.attribute4%TYPE := NULL,
   p_attribute5 IN cn_seas_schedules.attribute5%TYPE := NULL,
   p_attribute6 IN cn_seas_schedules.attribute6%TYPE := NULL,
   p_attribute7 IN cn_seas_schedules.attribute7%TYPE := NULL,
   p_attribute8 IN cn_seas_schedules.attribute8%TYPE := NULL,
   p_attribute9 IN cn_seas_schedules.attribute9%TYPE := NULL,
   p_attribute10 IN cn_seas_schedules.attribute10%TYPE := NULL,
   p_attribute11 IN cn_seas_schedules.attribute11%TYPE := NULL,
   p_attribute12 IN cn_seas_schedules.attribute12%TYPE := NULL,
   p_attribute13 IN cn_seas_schedules.attribute13%TYPE := NULL,
   p_attribute14 IN cn_seas_schedules.attribute14%TYPE := NULL,
   p_attribute15 IN cn_seas_schedules.attribute15%TYPE := NULL,
   p_last_update_login IN cn_seas_schedules.last_update_login%TYPE := NULL,
   p_last_update_date IN cn_seas_schedules.last_update_date%TYPE := NULL,
   p_last_updated_by IN cn_seas_schedules.last_updated_by%TYPE := NULL,
   p_object_version_number IN cn_seas_schedules.object_version_number%TYPE)   IS
   CURSOR l_old_csr IS
      SELECT *
	FROM cn_seas_schedules
       WHERE SEAS_SCHEDULE_ID = P_SEAS_SCHEDULE_ID;

Line: 151

   SELECT decode(p_object_version_number, mn,
                 l_old_rec.object_version_number, p_object_version_number)
   INTO l_object_version_number
   FROM dual;

Line: 163

   UPDATE cn_seas_schedules SET
    (name,
     description,
     start_date,
     end_date,
     validation_status,
     attribute_category,
     attribute1,
     attribute2,
     attribute3,
     attribute4,
     attribute5,
     attribute6,
     attribute7,
     attribute8,
     attribute9,
     attribute10,
     attribute11,
     attribute12,
     attribute13,
     attribute14,
     attribute15,
     object_version_number,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN
   ) =
     (
      SELECT
        decode(p_name, mc, l_old_rec.name, p_name),
        decode(p_description, mc, l_old_rec.description, p_description),
        decode(p_start_date, md, l_old_rec.start_date, p_start_date),
        decode(p_end_date, md, l_old_rec.end_date, p_end_date),
        decode(p_validation_status, mc, l_old_rec.validation_status, p_validation_status),
        decode(p_attribute_category, mc, l_old_rec.attribute_category,p_attribute_category),
        decode(p_attribute1, mc, l_old_rec.attribute1, p_attribute1),
        decode(p_attribute2, mc, l_old_rec.attribute2, p_attribute2),
        decode(p_attribute3, mc, l_old_rec.attribute3, p_attribute3),
        decode(p_attribute4, mc, l_old_rec.attribute4, p_attribute4),
        decode(p_attribute5, mc, l_old_rec.attribute5, p_attribute5),
        decode(p_attribute6, mc, l_old_rec.attribute6, p_attribute6),
        decode(p_attribute7, mc, l_old_rec.attribute7, p_attribute7),
        decode(p_attribute8, mc, l_old_rec.attribute8, p_attribute8),
        decode(p_attribute9, mc, l_old_rec.attribute9, p_attribute9),
        decode(p_attribute10, mc, l_old_rec.attribute10, p_attribute10),
        decode(p_attribute11, mc, l_old_rec.attribute11, p_attribute11),
        decode(p_attribute12, mc, l_old_rec.attribute12, p_attribute12),
        decode(p_attribute13, mc, l_old_rec.attribute13, p_attribute13),
        decode(p_attribute14, mc, l_old_rec.attribute14, p_attribute14),
        decode(p_attribute15, mc, l_old_rec.attribute15, p_attribute15),
        decode(p_object_version_number, mn,l_old_rec.object_version_number, p_object_version_number+1),
        sysdate,
        fnd_global.user_id,
        fnd_global.login_id
       FROM dual)
       WHERE seas_schedule_id = p_seas_schedule_id;

Line: 219

END update_row;

Line: 222

PROCEDURE delete_row
  (P_SEAS_SCHEDULE_ID  IN cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE) IS
BEGIN
   DELETE FROM cn_seas_schedules
     WHERE SEAS_SCHEDULE_ID = P_SEAS_SCHEDULE_ID;

Line: 228

END delete_row;