DBA Data[Home] [Help]

APPS.OKL_SIP_PVT SQL Statements

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

Line: 99

    DELETE FROM OKL_SUBSIDY_POOLS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_SUBSIDY_POOLS_B B
         WHERE B.ID =T.ID
        );
Line: 106

    UPDATE OKL_SUBSIDY_POOLS_TL T SET(
        SHORT_DESCRIPTION,
        DESCRIPTION) = (SELECT
                                  B.SHORT_DESCRIPTION,
                                  B.DESCRIPTION
                                FROM OKL_SUBSIDY_POOLS_TL B
                               WHERE B.ID = T.ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE ( T.ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.LANGUAGE
                FROM OKL_SUBSIDY_POOLS_TL SUBB, OKL_SUBSIDY_POOLS_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
                      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
              ));
Line: 128

    INSERT INTO OKL_SUBSIDY_POOLS_TL (
        ID,
        SHORT_DESCRIPTION,
        DESCRIPTION,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            B.SHORT_DESCRIPTION,
            B.DESCRIPTION,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_SUBSIDY_POOLS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_SUBSIDY_POOLS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 171

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            POOL_TYPE_CODE,
            SUBSIDY_POOL_NAME,
            SHORT_DESCRIPTION,
            DESCRIPTION,
            EFFECTIVE_FROM_DATE,
            EFFECTIVE_TO_DATE,
            CURRENCY_CODE,
            CURRENCY_CONVERSION_TYPE,
            DECISION_STATUS_CODE,
            SUBSIDY_POOL_ID,
            REPORTING_POOL_LIMIT,
            TOTAL_BUDGETS,
            TOTAL_SUBSIDY_AMOUNT,
            DECISION_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Subsidy_Pools_V
     WHERE okl_subsidy_pools_v.id = p_id;
Line: 254

              l_sipv_rec.last_updated_by,
              l_sipv_rec.last_update_date,
              l_sipv_rec.last_update_login;
Line: 299

    SELECT
            ID,
            SHORT_DESCRIPTION,
            DESCRIPTION,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Subsidy_Pools_Tl
     WHERE okl_subsidy_pools_tl.id = p_id
       AND okl_subsidy_pools_tl.language = p_language;
Line: 330

              l_okl_subsidy_pools_tl_rec.last_updated_by,
              l_okl_subsidy_pools_tl_rec.last_update_date,
              l_okl_subsidy_pools_tl_rec.last_update_login;
Line: 375

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            POOL_TYPE_CODE,
            SUBSIDY_POOL_NAME,
            EFFECTIVE_FROM_DATE,
            EFFECTIVE_TO_DATE,
            CURRENCY_CODE,
            CURRENCY_CONVERSION_TYPE,
            DECISION_STATUS_CODE,
            SUBSIDY_POOL_ID,
            REPORTING_POOL_LIMIT,
            TOTAL_BUDGETS,
            TOTAL_SUBSIDY_AMOUNT,
            DECISION_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Subsidy_Pools_B
     WHERE okl_subsidy_pools_b.id = p_id;
Line: 452

              l_sip_rec.last_updated_by,
              l_sip_rec.last_update_date,
              l_sip_rec.last_update_login;
Line: 601

    IF (l_sipv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_sipv_rec.last_updated_by := NULL;
Line: 604

    IF (l_sipv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_sipv_rec.last_update_date := NULL;
Line: 607

    IF (l_sipv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_sipv_rec.last_update_login := NULL;
Line: 759

select 1
from okl_subsidy_pools_b sub
where sub.id = p_id
;
Line: 764

cursor c_unique_insert is
select 1
from okl_subsidy_pools_b sub
where sub.subsidy_pool_name = p_name
;
Line: 770

cursor c_unique_update is
select 1
from okl_subsidy_pools_b sub
where sub.id <> p_id
and sub.subsidy_pool_name = p_name
;
Line: 793

      open c_unique_update;
Line: 794

      fetch c_unique_update into l_dummy;
Line: 795

      l_dup_row_found := c_unique_update%found;
Line: 796

      close c_unique_update;
Line: 798

    ELSE -- insert mode
      open c_unique_insert;
Line: 800

      fetch c_unique_insert into l_dummy;
Line: 801

      l_dup_row_found := c_unique_insert%found;
Line: 802

      close c_unique_insert;
Line: 867

      SELECT '1'
      FROM fnd_lookups
      WHERE lookup_type = 'OKL_SUBSIDY_POOL_STATUS'
      AND lookup_code = p_decision_status_code  ;
Line: 933

SELECT  subsidy_pool_id
FROM okl_subsidy_pools_v
WHERE id = cp_pool_id ;
Line: 938

  SELECT subsidy_pool_name
  FROM okl_subsidy_pools_v
  WHERE id = cp_pool_id;
Line: 1059

     SELECT pool_type_code
       FROM okl_subsidy_pools_b
      WHERE id = p_subsidy_pool_id;
Line: 1294

      p_to.last_updated_by := p_from.last_updated_by;
Line: 1295

      p_to.last_update_date := p_from.last_update_date;
Line: 1296

      p_to.last_update_login := p_from.last_update_login;
Line: 1309

      p_to.last_updated_by := p_from.last_updated_by;
Line: 1310

      p_to.last_update_date := p_from.last_update_date;
Line: 1311

      p_to.last_update_login := p_from.last_update_login;
Line: 1350

      p_to.last_updated_by := p_from.last_updated_by;
Line: 1351

      p_to.last_update_date := p_from.last_update_date;
Line: 1352

      p_to.last_update_login := p_from.last_update_login;
Line: 1391

      p_to.last_updated_by := p_from.last_updated_by;
Line: 1392

      p_to.last_update_date := p_from.last_update_date;
Line: 1393

      p_to.last_update_login := p_from.last_update_login;
Line: 1639

    PROCEDURE insert_row(
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sip_rec                      IN sip_rec_type,
      x_sip_rec                      OUT NOCOPY sip_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 1648

      l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 1684

      INSERT INTO OKL_SUBSIDY_POOLS_B(
        id,
        object_version_number,
        pool_type_code,
        subsidy_pool_name,
        effective_from_date,
        effective_to_date,
        currency_code,
        currency_conversion_type,
        decision_status_code,
        subsidy_pool_id,
        reporting_pool_limit,
        total_budgets,
        total_subsidy_amount,
        decision_date,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_sip_rec.id,
        l_sip_rec.object_version_number,
        l_sip_rec.pool_type_code,
        l_sip_rec.subsidy_pool_name,
        l_sip_rec.effective_from_date,
        l_sip_rec.effective_to_date,
        l_sip_rec.currency_code,
        l_sip_rec.currency_conversion_type,
        l_sip_rec.decision_status_code,
        l_sip_rec.subsidy_pool_id,
        l_sip_rec.reporting_pool_limit,
        l_sip_rec.total_budgets,
        l_sip_rec.total_subsidy_amount,
        l_sip_rec.decision_date,
        l_sip_rec.attribute_category,
        l_sip_rec.attribute1,
        l_sip_rec.attribute2,
        l_sip_rec.attribute3,
        l_sip_rec.attribute4,
        l_sip_rec.attribute5,
        l_sip_rec.attribute6,
        l_sip_rec.attribute7,
        l_sip_rec.attribute8,
        l_sip_rec.attribute9,
        l_sip_rec.attribute10,
        l_sip_rec.attribute11,
        l_sip_rec.attribute12,
        l_sip_rec.attribute13,
        l_sip_rec.attribute14,
        l_sip_rec.attribute15,
        l_sip_rec.created_by,
        l_sip_rec.creation_date,
        l_sip_rec.last_updated_by,
        l_sip_rec.last_update_date,
        l_sip_rec.last_update_login);
Line: 1791

    END insert_row;
Line: 1795

    PROCEDURE insert_row(
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_okl_subsidy_pools_tl_rec     IN okl_subsidy_pools_tl_rec_type,
      x_okl_subsidy_pools_tl_rec     OUT NOCOPY okl_subsidy_pools_tl_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 1804

      l_api_name                     CONSTANT VARCHAR2(30) := 'TL_insert_row';
Line: 1809

        SELECT *
          FROM FND_LANGUAGES
         WHERE INSTALLED_FLAG IN ('I', 'B');
Line: 1848

        INSERT INTO OKL_SUBSIDY_POOLS_TL(
          id,
          short_description,
          description,
          language,
          source_lang,
          sfwt_flag,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_subsidy_pools_tl_rec.id,
          l_okl_subsidy_pools_tl_rec.short_description,
          l_okl_subsidy_pools_tl_rec.description,
          l_okl_subsidy_pools_tl_rec.language,
          l_okl_subsidy_pools_tl_rec.source_lang,
          l_okl_subsidy_pools_tl_rec.sfwt_flag,
          l_okl_subsidy_pools_tl_rec.created_by,
          l_okl_subsidy_pools_tl_rec.creation_date,
          l_okl_subsidy_pools_tl_rec.last_updated_by,
          l_okl_subsidy_pools_tl_rec.last_update_date,
          l_okl_subsidy_pools_tl_rec.last_update_login);
Line: 1908

    END insert_row;
Line: 1912

    PROCEDURE insert_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_rec                     IN sipv_rec_type,
      x_sipv_rec                     OUT NOCOPY sipv_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 1922

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1940

        l_sipv_rec.LAST_UPDATE_DATE := l_sipv_rec.CREATION_DATE;
Line: 1941

        l_sipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1942

        l_sipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2008

      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_sip_rec,
        lx_sip_rec
      );
Line: 2022

      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_okl_subsidy_pools_tl_rec,
        lx_okl_subsidy_pools_tl_rec
      );
Line: 2071

    END insert_row;
Line: 2075

    PROCEDURE insert_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_tbl                     IN sipv_tbl_type,
      x_sipv_tbl                     OUT NOCOPY sipv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 2086

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 2100

            insert_row (
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_API.G_FALSE,
              x_return_status                => l_error_rec.error_type,
              x_msg_count                    => l_error_rec.msg_count,
              x_msg_data                     => l_error_rec.msg_data,
              p_sipv_rec                     => p_sipv_tbl(i),
              x_sipv_rec                     => x_sipv_tbl(i));
Line: 2168

    END insert_row;
Line: 2173

    PROCEDURE insert_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_tbl                     IN sipv_tbl_type,
      x_sipv_tbl                     OUT NOCOPY sipv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 2183

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 2190

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sipv_tbl                     => p_sipv_tbl,
          x_sipv_tbl                     => x_sipv_tbl,
          px_error_tbl                   => l_error_tbl);
Line: 2232

    END insert_row;
Line: 2250

      SELECT OBJECT_VERSION_NUMBER
        FROM OKL_SUBSIDY_POOLS_B
       WHERE ID = p_sip_rec.id
         AND OBJECT_VERSION_NUMBER = p_sip_rec.object_version_number
      FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2257

      SELECT OBJECT_VERSION_NUMBER
        FROM OKL_SUBSIDY_POOLS_B
       WHERE ID = p_sip_rec.id;
Line: 2298

        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2307

        OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2357

      SELECT *
        FROM OKL_SUBSIDY_POOLS_TL
       WHERE ID = p_okl_subsidy_pools_tl_rec.id
      FOR UPDATE NOWAIT;
Line: 2393

        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2687

    PROCEDURE update_row(
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sip_rec                      IN sip_rec_type,
      x_sip_rec                      OUT NOCOPY sip_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 2696

      l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 2844

          IF (x_sip_rec.last_updated_by = OKL_API.G_MISS_NUM)
          THEN
            x_sip_rec.last_updated_by := l_sip_rec.last_updated_by;
Line: 2848

          IF (x_sip_rec.last_update_date = OKL_API.G_MISS_DATE)
          THEN
            x_sip_rec.last_update_date := l_sip_rec.last_update_date;
Line: 2852

          IF (x_sip_rec.last_update_login = OKL_API.G_MISS_NUM)
          THEN
            x_sip_rec.last_update_login := l_sip_rec.last_update_login;
Line: 2898

      UPDATE OKL_SUBSIDY_POOLS_B
      SET OBJECT_VERSION_NUMBER = l_def_sip_rec.object_version_number,
          POOL_TYPE_CODE = l_def_sip_rec.pool_type_code,
          SUBSIDY_POOL_NAME = l_def_sip_rec.subsidy_pool_name,
          EFFECTIVE_FROM_DATE = l_def_sip_rec.effective_from_date,
          EFFECTIVE_TO_DATE = l_def_sip_rec.effective_to_date,
          CURRENCY_CODE = l_def_sip_rec.currency_code,
          CURRENCY_CONVERSION_TYPE = l_def_sip_rec.currency_conversion_type,
          DECISION_STATUS_CODE = l_def_sip_rec.decision_status_code,
          SUBSIDY_POOL_ID = l_def_sip_rec.subsidy_pool_id,
          REPORTING_POOL_LIMIT = l_def_sip_rec.reporting_pool_limit,
          TOTAL_BUDGETS = l_def_sip_rec.total_budgets,
          TOTAL_SUBSIDY_AMOUNT = l_def_sip_rec.total_subsidy_amount,
          DECISION_DATE = l_def_sip_rec.decision_date,
          ATTRIBUTE_CATEGORY = l_def_sip_rec.attribute_category,
          ATTRIBUTE1 = l_def_sip_rec.attribute1,
          ATTRIBUTE2 = l_def_sip_rec.attribute2,
          ATTRIBUTE3 = l_def_sip_rec.attribute3,
          ATTRIBUTE4 = l_def_sip_rec.attribute4,
          ATTRIBUTE5 = l_def_sip_rec.attribute5,
          ATTRIBUTE6 = l_def_sip_rec.attribute6,
          ATTRIBUTE7 = l_def_sip_rec.attribute7,
          ATTRIBUTE8 = l_def_sip_rec.attribute8,
          ATTRIBUTE9 = l_def_sip_rec.attribute9,
          ATTRIBUTE10 = l_def_sip_rec.attribute10,
          ATTRIBUTE11 = l_def_sip_rec.attribute11,
          ATTRIBUTE12 = l_def_sip_rec.attribute12,
          ATTRIBUTE13 = l_def_sip_rec.attribute13,
          ATTRIBUTE14 = l_def_sip_rec.attribute14,
          ATTRIBUTE15 = l_def_sip_rec.attribute15,
          CREATED_BY = l_def_sip_rec.created_by,
          CREATION_DATE = l_def_sip_rec.creation_date,
          LAST_UPDATED_BY = l_def_sip_rec.last_updated_by,
          LAST_UPDATE_DATE = l_def_sip_rec.last_update_date,
          LAST_UPDATE_LOGIN = l_def_sip_rec.last_update_login
      WHERE ID = l_def_sip_rec.id;
Line: 2969

    END update_row;
Line: 2973

    PROCEDURE update_row(
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_okl_subsidy_pools_tl_rec     IN okl_subsidy_pools_tl_rec_type,
      x_okl_subsidy_pools_tl_rec     OUT NOCOPY okl_subsidy_pools_tl_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 2982

      l_api_name                     CONSTANT VARCHAR2(30) := 'TL_update_row';
Line: 3034

          IF (x_okl_subsidy_pools_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
          THEN
            x_okl_subsidy_pools_tl_rec.last_updated_by := l_okl_subsidy_pools_tl_rec.last_updated_by;
Line: 3038

          IF (x_okl_subsidy_pools_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
          THEN
            x_okl_subsidy_pools_tl_rec.last_update_date := l_okl_subsidy_pools_tl_rec.last_update_date;
Line: 3042

          IF (x_okl_subsidy_pools_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
          THEN
            x_okl_subsidy_pools_tl_rec.last_update_login := l_okl_subsidy_pools_tl_rec.last_update_login;
Line: 3089

      UPDATE OKL_SUBSIDY_POOLS_TL
      SET SHORT_DESCRIPTION = l_def_okl_subsidy_pools_tl_rec.short_description,
          DESCRIPTION = l_def_okl_subsidy_pools_tl_rec.description,
          CREATED_BY = l_def_okl_subsidy_pools_tl_rec.created_by,
          CREATION_DATE = l_def_okl_subsidy_pools_tl_rec.creation_date,
          LAST_UPDATED_BY = l_def_okl_subsidy_pools_tl_rec.last_updated_by,
          LAST_UPDATE_DATE = l_def_okl_subsidy_pools_tl_rec.last_update_date,
          LAST_UPDATE_LOGIN = l_def_okl_subsidy_pools_tl_rec.last_update_login
      WHERE ID = l_def_okl_subsidy_pools_tl_rec.id
        AND SOURCE_LANG = USERENV('LANG');
Line: 3100

      UPDATE OKL_SUBSIDY_POOLS_TL
      SET SFWT_FLAG = 'Y'
      WHERE ID = l_def_okl_subsidy_pools_tl_rec.id
        AND SOURCE_LANG <> USERENV('LANG');
Line: 3139

    END update_row;
Line: 3143

    PROCEDURE update_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_rec                     IN sipv_rec_type,
      x_sipv_rec                     OUT NOCOPY sipv_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3153

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 3170

        l_sipv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 3171

        l_sipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3172

        l_sipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3331

          IF (x_sipv_rec.last_updated_by = OKL_API.G_MISS_NUM)
          THEN
            x_sipv_rec.last_updated_by := l_db_sipv_rec.last_updated_by;
Line: 3335

          IF (x_sipv_rec.last_update_date = OKL_API.G_MISS_DATE)
          THEN
            x_sipv_rec.last_update_date := l_db_sipv_rec.last_update_date;
Line: 3339

          IF (x_sipv_rec.last_update_login = OKL_API.G_MISS_NUM)
          THEN
            x_sipv_rec.last_update_login := l_db_sipv_rec.last_update_login;
Line: 3426

      update_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_sip_rec,
        lx_sip_rec
      );
Line: 3440

      update_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_okl_subsidy_pools_tl_rec,
        lx_okl_subsidy_pools_tl_rec
      );
Line: 3488

    END update_row;
Line: 3492

    PROCEDURE update_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_tbl                     IN sipv_tbl_type,
      x_sipv_tbl                     OUT NOCOPY sipv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3503

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 3517

            update_row (
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_API.G_FALSE,
              x_return_status                => l_error_rec.error_type,
              x_msg_count                    => l_error_rec.msg_count,
              x_msg_data                     => l_error_rec.msg_data,
              p_sipv_rec                     => p_sipv_tbl(i),
              x_sipv_rec                     => x_sipv_tbl(i));
Line: 3585

    END update_row;
Line: 3590

    PROCEDURE update_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_tbl                     IN sipv_tbl_type,
      x_sipv_tbl                     OUT NOCOPY sipv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3600

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 3607

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sipv_tbl                     => p_sipv_tbl,
          x_sipv_tbl                     => x_sipv_tbl,
          px_error_tbl                   => l_error_tbl);
Line: 3649

    END update_row;
Line: 3657

    PROCEDURE delete_row(
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sip_rec                      IN sip_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3665

      l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 3680

      DELETE FROM OKL_SUBSIDY_POOLS_B
       WHERE ID = p_sip_rec.id;
Line: 3716

    END delete_row;
Line: 3720

    PROCEDURE delete_row(
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_okl_subsidy_pools_tl_rec     IN okl_subsidy_pools_tl_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3728

      l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_row';
Line: 3743

      DELETE FROM OKL_SUBSIDY_POOLS_TL
       WHERE ID = p_okl_subsidy_pools_tl_rec.id;
Line: 3779

    END delete_row;
Line: 3783

    PROCEDURE delete_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_rec                     IN sipv_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3792

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 3818

      delete_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_okl_subsidy_pools_tl_rec
      );
Line: 3830

      delete_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_sip_rec
      );
Line: 3875

    END delete_row;
Line: 3879

    PROCEDURE delete_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_tbl                     IN sipv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3889

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 3903

            delete_row (
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_API.G_FALSE,
              x_return_status                => l_error_rec.error_type,
              x_msg_count                    => l_error_rec.msg_count,
              x_msg_data                     => l_error_rec.msg_data,
              p_sipv_rec                     => p_sipv_tbl(i));
Line: 3970

    END delete_row;
Line: 3975

    PROCEDURE delete_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_sipv_tbl                     IN sipv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;
Line: 3984

      l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 3991

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sipv_tbl                     => p_sipv_tbl,
          px_error_tbl                   => l_error_tbl);
Line: 4032

    END delete_row;