DBA Data[Home] [Help]

APPS.OKC_CLS_PVT SQL Statements

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

Line: 42

    DELETE FROM OKC_CLASSES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_CLASSES_B B
         WHERE B.CODE = T.CODE
        );
Line: 49

    UPDATE OKC_CLASSES_TL T SET (
        MEANING,
        DESCRIPTION) = (SELECT
                                  B.MEANING,
                                  B.DESCRIPTION
                                FROM OKC_CLASSES_TL B
                               WHERE B.CODE = T.CODE
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.CODE,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.CODE,
                  SUBT.LANGUAGE
                FROM OKC_CLASSES_TL SUBB, OKC_CLASSES_TL SUBT
               WHERE SUBB.CODE = SUBT.CODE
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.MEANING <> SUBT.MEANING
                      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
              ));
Line: 72

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

    SELECT
            CODE,
            FFF_FUNCTION_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            APPLICATION_ID,
            ADV_SEARCH_FORM_FUNCTION_ID
      FROM Okc_Classes_B
     WHERE okc_classes_b.code   = p_code;
Line: 141

              l_cls_rec.LAST_UPDATED_BY,
              l_cls_rec.LAST_UPDATE_DATE,
              l_cls_rec.LAST_UPDATE_LOGIN,
              l_cls_rec.APPLICATION_ID,
              l_cls_rec.ADV_SEARCH_FORM_FUNCTION_ID;
Line: 167

    SELECT
            CODE,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            MEANING,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Classes_Tl
     WHERE okc_classes_tl.code  = p_code
       AND okc_classes_tl.language = p_language;
Line: 198

              l_okc_classes_tl_rec.LAST_UPDATED_BY,
              l_okc_classes_tl_rec.LAST_UPDATE_DATE,
              l_okc_classes_tl_rec.LAST_UPDATE_LOGIN;
Line: 221

    SELECT
            CODE,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            FFF_FUNCTION_ID,
            MEANING,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            APPLICATION_ID,
            ADV_SEARCH_FORM_FUNCTION_ID
      FROM Okc_Classes_V
     WHERE okc_classes_v.code   = p_code;
Line: 252

              l_clsv_rec.LAST_UPDATED_BY,
              l_clsv_rec.LAST_UPDATE_DATE,
              l_clsv_rec.LAST_UPDATE_LOGIN,
              l_clsv_rec.APPLICATION_ID,
              l_clsv_rec.ADV_SEARCH_FORM_FUNCTION_ID;
Line: 299

    IF (l_clsv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_clsv_rec.last_updated_by := NULL;
Line: 302

    IF (l_clsv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_clsv_rec.last_update_date := NULL;
Line: 305

    IF (l_clsv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_clsv_rec.last_update_login := NULL;
Line: 373

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

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

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

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

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

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

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

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

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

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

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

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

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cls_rec                      IN cls_rec_type,
    x_cls_rec                      OUT NOCOPY cls_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 586

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

    INSERT INTO OKC_CLASSES_B(
        code,
        fff_function_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        application_id,
        adv_search_form_function_id)
     VALUES (
        l_cls_rec.code,
        l_cls_rec.fff_function_id,
        l_cls_rec.object_version_number,
        l_cls_rec.created_by,
        l_cls_rec.creation_date,
        l_cls_rec.last_updated_by,
        l_cls_rec.last_update_date,
        l_cls_rec.last_update_login,
        l_cls_rec.application_id,
        l_cls_rec.adv_search_form_function_id);
Line: 678

  END insert_row;
Line: 682

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okc_classes_tl_rec           IN okc_classes_tl_rec_type,
    x_okc_classes_tl_rec           OUT NOCOPY okc_classes_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 691

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

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

      INSERT INTO OKC_CLASSES_TL(
          code,
          language,
          source_lang,
          sfwt_flag,
          meaning,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okc_classes_tl_rec.code,
          l_okc_classes_tl_rec.language,
          l_okc_classes_tl_rec.source_lang,
          l_okc_classes_tl_rec.sfwt_flag,
          l_okc_classes_tl_rec.meaning,
          l_okc_classes_tl_rec.description,
          l_okc_classes_tl_rec.created_by,
          l_okc_classes_tl_rec.creation_date,
          l_okc_classes_tl_rec.last_updated_by,
          l_okc_classes_tl_rec.last_update_date,
          l_okc_classes_tl_rec.last_update_login);
Line: 794

  END insert_row;
Line: 798

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clsv_rec                     IN clsv_rec_type,
    x_clsv_rec                     OUT NOCOPY clsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 808

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

      l_clsv_rec.LAST_UPDATE_DATE := l_clsv_rec.CREATION_DATE;
Line: 827

      l_clsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 828

      l_clsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 892

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cls_rec,
      lx_cls_rec
    );
Line: 906

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_classes_tl_rec,
      lx_okc_classes_tl_rec
    );
Line: 954

  END insert_row;
Line: 958

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clsv_tbl                     IN clsv_tbl_type,
    x_clsv_tbl                     OUT NOCOPY clsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 968

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

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_clsv_rec                     => p_clsv_tbl(i),
          x_clsv_rec                     => x_clsv_tbl(i));
Line: 1020

  END insert_row;
Line: 1038

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CLASSES_B
     WHERE CODE = p_cls_rec.code
       AND OBJECT_VERSION_NUMBER = p_cls_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1045

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CLASSES_B
    WHERE CODE = p_cls_rec.code;
Line: 1086

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1095

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1144

    SELECT *
      FROM OKC_CLASSES_TL
     WHERE CODE = p_okc_classes_tl_rec.code
    FOR UPDATE NOWAIT;
Line: 1180

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1381

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cls_rec                      IN cls_rec_type,
    x_cls_rec                      OUT NOCOPY cls_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1390

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

      IF (x_cls_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cls_rec.last_updated_by := l_cls_rec.last_updated_by;
Line: 1436

      IF (x_cls_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cls_rec.last_update_date := l_cls_rec.last_update_date;
Line: 1440

      IF (x_cls_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cls_rec.last_update_login := l_cls_rec.last_update_login;
Line: 1492

    UPDATE  OKC_CLASSES_B
    SET FFF_FUNCTION_ID = l_def_cls_rec.fff_function_id,
        OBJECT_VERSION_NUMBER = l_def_cls_rec.object_version_number,
        CREATED_BY = l_def_cls_rec.created_by,
        CREATION_DATE = l_def_cls_rec.creation_date,
        LAST_UPDATED_BY = l_def_cls_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cls_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cls_rec.last_update_login,
        APPLICATION_ID=l_def_cls_rec.application_id,
        ADV_SEARCH_FORM_FUNCTION_ID=l_def_cls_rec.adv_search_form_function_id
    WHERE CODE = l_def_cls_rec.code;
Line: 1537

  END update_row;
Line: 1541

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okc_classes_tl_rec           IN okc_classes_tl_rec_type,
    x_okc_classes_tl_rec           OUT NOCOPY okc_classes_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1550

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

      IF (x_okc_classes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okc_classes_tl_rec.last_updated_by := l_okc_classes_tl_rec.last_updated_by;
Line: 1608

      IF (x_okc_classes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okc_classes_tl_rec.last_update_date := l_okc_classes_tl_rec.last_update_date;
Line: 1612

      IF (x_okc_classes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okc_classes_tl_rec.last_update_login := l_okc_classes_tl_rec.last_update_login;
Line: 1658

    UPDATE  OKC_CLASSES_TL
    SET MEANING = l_def_okc_classes_tl_rec.meaning,
        DESCRIPTION = l_def_okc_classes_tl_rec.description,
        CREATED_BY = l_def_okc_classes_tl_rec.created_by,
        CREATION_DATE = l_def_okc_classes_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_classes_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_classes_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_classes_tl_rec.last_update_login
    WHERE CODE = l_def_okc_classes_tl_rec.code
      AND SOURCE_LANG = USERENV('LANG');
Line: 1669

    UPDATE  OKC_CLASSES_TL
    SET SFWT_FLAG = 'Y'
    WHERE CODE = l_def_okc_classes_tl_rec.code
      AND SOURCE_LANG <> USERENV('LANG');
Line: 1707

  END update_row;
Line: 1711

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clsv_rec                     IN clsv_rec_type,
    x_clsv_rec                     OUT NOCOPY clsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1721

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

      l_clsv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1738

      l_clsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1739

      l_clsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1791

      IF (x_clsv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_clsv_rec.last_updated_by := l_clsv_rec.last_updated_by;
Line: 1795

      IF (x_clsv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_clsv_rec.last_update_date := l_clsv_rec.last_update_date;
Line: 1799

      IF (x_clsv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_clsv_rec.last_update_login := l_clsv_rec.last_update_login;
Line: 1879

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_classes_tl_rec,
      lx_okc_classes_tl_rec
    );
Line: 1893

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cls_rec,
      lx_cls_rec
    );
Line: 1940

  END update_row;
Line: 1944

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clsv_tbl                     IN clsv_tbl_type,
    x_clsv_tbl                     OUT NOCOPY clsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1954

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

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_clsv_rec                     => p_clsv_tbl(i),
          x_clsv_rec                     => x_clsv_tbl(i));
Line: 2006

  END update_row;
Line: 2014

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cls_rec                      IN cls_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2022

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

    DELETE FROM OKC_CLASSES_B
     WHERE CODE = l_cls_rec.code;
Line: 2071

  END delete_row;
Line: 2075

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okc_classes_tl_rec           IN okc_classes_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2083

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

    DELETE FROM OKC_CLASSES_TL
     WHERE CODE = l_okc_classes_tl_rec.code;
Line: 2155

  END delete_row;
Line: 2159

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clsv_rec                     IN clsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2168

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_classes_tl_rec
    );
Line: 2206

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cls_rec
    );
Line: 2250

  END delete_row;
Line: 2254

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clsv_tbl                     IN clsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2263

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

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_clsv_rec                     => p_clsv_tbl(i));
Line: 2314

  END delete_row;