DBA Data[Home] [Help]

APPS.OKC_RLD_PVT SQL Statements

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

Line: 107

    DELETE FROM OKC_RULE_DEFS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_RULE_DEFS_TL B
         WHERE B.RULE_CODE =T.RULE_CODE
        );
Line: 114

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

    INSERT INTO OKC_RULE_DEFS_TL (
        RULE_CODE,
        MEANING,
        DESCRIPTION,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.RULE_CODE,
            B.MEANING,
            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 OKC_RULE_DEFS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKC_RULE_DEFS_TL T
                     WHERE T.RULE_CODE = B.RULE_CODE
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 179

    SELECT
            APPLICATION_ID,
            APPLICATION_NAME,
            RULE_CODE,
            DESCRIPTIVE_FLEXFIELD_NAME,
            MEANING,
            DESCRIPTION,
            SFWT_FLAG,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Rule_Defs_V
     WHERE okc_rule_defs_v.rule_code = p_rule_code;
Line: 212

              l_okc_rule_defs_v_rec.last_updated_by,
              l_okc_rule_defs_v_rec.last_update_date,
              l_okc_rule_defs_v_rec.last_update_login;
Line: 256

    SELECT
            RULE_CODE,
            APPLICATION_ID,
            DESCRIPTIVE_FLEXFIELD_NAME,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Rule_Defs_B
     WHERE okc_rule_defs_b.rule_code = p_rule_code;
Line: 281

              l_okc_rule_defs_b_rec.last_updated_by,
              l_okc_rule_defs_b_rec.last_update_date,
              l_okc_rule_defs_b_rec.last_update_login;
Line: 326

    SELECT
            RULE_CODE,
            MEANING,
            DESCRIPTION,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Rule_Defs_Tl
     WHERE okc_rule_defs_tl.rule_code = p_rule_code
       AND okc_rule_defs_tl.language = p_language;
Line: 357

              l_okc_rule_defs_tl_rec.last_updated_by,
              l_okc_rule_defs_tl_rec.last_update_date,
              l_okc_rule_defs_tl_rec.last_update_login;
Line: 432

    IF (l_okc_rule_defs_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_okc_rule_defs_v_rec.last_updated_by := NULL;
Line: 435

    IF (l_okc_rule_defs_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_okc_rule_defs_v_rec.last_update_date := NULL;
Line: 438

    IF (l_okc_rule_defs_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_okc_rule_defs_v_rec.last_update_login := NULL;
Line: 451

  	  select '!'
	  from FND_APPLICATION
  	  where application_id = p_application_id;
Line: 491

  	  select '!'
	  from FND_APPLICATION
  	  where application_short_name = p_application_name;
Line: 562

  	  select distinct '!'
	  from FND_DESCR_FLEX_CONTEXTS_VL
  	  where descriptive_flexfield_name = p_descriptive_flexfield_name;
Line: 684

  	  select distinct '!'
	  from FND_DESCR_FLEX_CONTEXTS_VL
  	  where
  	   APPLICATION_ID = p_application_id
  	  and
  	   DESCRIPTIVE_FLEX_CONTEXT_CODE = p_rule_code
  	  and
  	   DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
Line: 862

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

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

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

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

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

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

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

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

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

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

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

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

  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_rule_defs_b_rec          IN okc_rule_defs_b_rec_type,
    x_okc_rule_defs_b_rec          OUT NOCOPY okc_rule_defs_b_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1164

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

    INSERT INTO OKC_RULE_DEFS_B(
      rule_code,
      application_id,
      descriptive_flexfield_name,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_okc_rule_defs_b_rec.rule_code,
      l_okc_rule_defs_b_rec.application_id,
      l_okc_rule_defs_b_rec.descriptive_flexfield_name,
      l_okc_rule_defs_b_rec.object_version_number,
      l_okc_rule_defs_b_rec.created_by,
      l_okc_rule_defs_b_rec.creation_date,
      l_okc_rule_defs_b_rec.last_updated_by,
      l_okc_rule_defs_b_rec.last_update_date,
      l_okc_rule_defs_b_rec.last_update_login);
Line: 1255

  END insert_row;
Line: 1259

  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_rule_defs_tl_rec         IN okc_rule_defs_tl_rec_type,
    x_okc_rule_defs_tl_rec         OUT NOCOPY okc_rule_defs_tl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1268

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

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

      INSERT INTO OKC_RULE_DEFS_TL(
        rule_code,
        meaning,
        description,
        language,
        source_lang,
        sfwt_flag,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okc_rule_defs_tl_rec.rule_code,
        l_okc_rule_defs_tl_rec.meaning,
        l_okc_rule_defs_tl_rec.description,
        l_okc_rule_defs_tl_rec.language,
        l_okc_rule_defs_tl_rec.source_lang,
        l_okc_rule_defs_tl_rec.sfwt_flag,
        l_okc_rule_defs_tl_rec.created_by,
        l_okc_rule_defs_tl_rec.creation_date,
        l_okc_rule_defs_tl_rec.last_updated_by,
        l_okc_rule_defs_tl_rec.last_update_date,
        l_okc_rule_defs_tl_rec.last_update_login);
Line: 1372

  END insert_row;
Line: 1376

  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_okc_rule_defs_v_rec          IN okc_rule_defs_v_rec_type,
    x_okc_rule_defs_v_rec          OUT NOCOPY okc_rule_defs_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1386

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

      l_okc_rule_defs_v_rec.LAST_UPDATE_DATE := l_okc_rule_defs_v_rec.CREATION_DATE;
Line: 1405

      l_okc_rule_defs_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1406

      l_okc_rule_defs_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1473

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rule_defs_b_rec,
      lx_okc_rule_defs_b_rec
    );
Line: 1487

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rule_defs_tl_rec,
      lx_okc_rule_defs_tl_rec
    );
Line: 1536

  END insert_row;
Line: 1540

  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_okc_rule_defs_v_tbl          IN okc_rule_defs_v_tbl_type,
    x_okc_rule_defs_v_tbl          OUT NOCOPY okc_rule_defs_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1551

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

          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_okc_rule_defs_v_rec          => p_okc_rule_defs_v_tbl(i),
            x_okc_rule_defs_v_rec          => x_okc_rule_defs_v_tbl(i));
Line: 1633

  END insert_row;
Line: 1638

  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_okc_rule_defs_v_tbl          IN okc_rule_defs_v_tbl_type,
    x_okc_rule_defs_v_tbl          OUT NOCOPY okc_rule_defs_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1648

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

      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_okc_rule_defs_v_tbl          => p_okc_rule_defs_v_tbl,
        x_okc_rule_defs_v_tbl          => x_okc_rule_defs_v_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1697

  END insert_row;
Line: 1715

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RULE_DEFS_B
     WHERE RULE_CODE = p_okc_rule_defs_b_rec.rule_code
       AND OBJECT_VERSION_NUMBER = p_okc_rule_defs_b_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1722

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RULE_DEFS_B
     WHERE RULE_CODE = p_okc_rule_defs_b_rec.rule_code;
Line: 1763

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

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

    SELECT *
      FROM OKC_RULE_DEFS_TL
     WHERE RULE_CODE = p_okc_rule_defs_tl_rec.rule_code
    FOR UPDATE NOWAIT;
Line: 1858

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

  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_rule_defs_b_rec          IN okc_rule_defs_b_rec_type,
    x_okc_rule_defs_b_rec          OUT NOCOPY okc_rule_defs_b_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2161

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

        IF (x_okc_rule_defs_b_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_okc_rule_defs_b_rec.last_updated_by := l_okc_rule_defs_b_rec.last_updated_by;
Line: 2209

        IF (x_okc_rule_defs_b_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_okc_rule_defs_b_rec.last_update_date := l_okc_rule_defs_b_rec.last_update_date;
Line: 2213

        IF (x_okc_rule_defs_b_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_okc_rule_defs_b_rec.last_update_login := l_okc_rule_defs_b_rec.last_update_login;
Line: 2259

    UPDATE OKC_RULE_DEFS_B
    SET APPLICATION_ID = l_def_okc_rule_defs_b_rec.application_id,
        DESCRIPTIVE_FLEXFIELD_NAME = l_def_okc_rule_defs_b_rec.descriptive_flexfield_name,
        OBJECT_VERSION_NUMBER = l_def_okc_rule_defs_b_rec.object_version_number,
        CREATED_BY = l_def_okc_rule_defs_b_rec.created_by,
        CREATION_DATE = l_def_okc_rule_defs_b_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_rule_defs_b_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_rule_defs_b_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_rule_defs_b_rec.last_update_login
    WHERE RULE_CODE = l_def_okc_rule_defs_b_rec.rule_code;
Line: 2304

  END update_row;
Line: 2308

  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_rule_defs_tl_rec         IN okc_rule_defs_tl_rec_type,
    x_okc_rule_defs_tl_rec         OUT NOCOPY okc_rule_defs_tl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2317

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

        IF (x_okc_rule_defs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_okc_rule_defs_tl_rec.last_updated_by := l_okc_rule_defs_tl_rec.last_updated_by;
Line: 2373

        IF (x_okc_rule_defs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_okc_rule_defs_tl_rec.last_update_date := l_okc_rule_defs_tl_rec.last_update_date;
Line: 2377

        IF (x_okc_rule_defs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_okc_rule_defs_tl_rec.last_update_login := l_okc_rule_defs_tl_rec.last_update_login;
Line: 2424

    UPDATE OKC_RULE_DEFS_TL
    SET MEANING = l_def_okc_rule_defs_tl_rec.meaning,
        DESCRIPTION = l_def_okc_rule_defs_tl_rec.description,
        CREATED_BY = l_def_okc_rule_defs_tl_rec.created_by,
        CREATION_DATE = l_def_okc_rule_defs_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_rule_defs_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_rule_defs_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_rule_defs_tl_rec.last_update_login
    WHERE RULE_CODE = l_def_okc_rule_defs_tl_rec.rule_code
      AND SOURCE_LANG = USERENV('LANG');
Line: 2435

    UPDATE OKC_RULE_DEFS_TL
    SET SFWT_FLAG = 'Y'
    WHERE RULE_CODE = l_def_okc_rule_defs_tl_rec.rule_code
      AND SOURCE_LANG <> USERENV('LANG');
Line: 2474

  END update_row;
Line: 2478

  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_okc_rule_defs_v_rec          IN okc_rule_defs_v_rec_type,
    x_okc_rule_defs_v_rec          OUT NOCOPY okc_rule_defs_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2488

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

      l_okc_rule_defs_v_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2506

      l_okc_rule_defs_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2507

      l_okc_rule_defs_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2562

        IF (x_okc_rule_defs_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_okc_rule_defs_v_rec.last_updated_by := l_db_okc_rule_defs_v_rec.last_updated_by;
Line: 2566

        IF (x_okc_rule_defs_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_okc_rule_defs_v_rec.last_update_date := l_db_okc_rule_defs_v_rec.last_update_date;
Line: 2570

        IF (x_okc_rule_defs_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_okc_rule_defs_v_rec.last_update_login := l_db_okc_rule_defs_v_rec.last_update_login;
Line: 2656

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rule_defs_b_rec,
      lx_okc_rule_defs_b_rec
    );
Line: 2670

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rule_defs_tl_rec,
      lx_okc_rule_defs_tl_rec
    );
Line: 2718

  END update_row;
Line: 2722

  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_okc_rule_defs_v_tbl          IN okc_rule_defs_v_tbl_type,
    x_okc_rule_defs_v_tbl          OUT NOCOPY okc_rule_defs_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2733

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

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_okc_rule_defs_v_rec          => p_okc_rule_defs_v_tbl(i),
            x_okc_rule_defs_v_rec          => x_okc_rule_defs_v_tbl(i));
Line: 2815

  END update_row;
Line: 2820

  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_okc_rule_defs_v_tbl          IN okc_rule_defs_v_tbl_type,
    x_okc_rule_defs_v_tbl          OUT NOCOPY okc_rule_defs_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2830

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

      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_okc_rule_defs_v_tbl          => p_okc_rule_defs_v_tbl,
        x_okc_rule_defs_v_tbl          => x_okc_rule_defs_v_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2879

  END update_row;
Line: 2887

  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_rule_defs_b_rec          IN okc_rule_defs_b_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2895

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

    DELETE FROM OKC_RULE_DEFS_B
     WHERE RULE_CODE = p_okc_rule_defs_b_rec.rule_code;
Line: 2946

  END delete_row;
Line: 2950

  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_rule_defs_tl_rec         IN okc_rule_defs_tl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2958

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

    DELETE FROM OKC_RULE_DEFS_TL
     WHERE RULE_CODE = p_okc_rule_defs_tl_rec.rule_code;
Line: 3009

  END delete_row;
Line: 3013

  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_okc_rule_defs_v_rec          IN okc_rule_defs_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3022

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rule_defs_tl_rec
    );
Line: 3060

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rule_defs_b_rec
    );
Line: 3105

  END delete_row;
Line: 3109

  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_okc_rule_defs_v_tbl          IN okc_rule_defs_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3119

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

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_okc_rule_defs_v_rec          => p_okc_rule_defs_v_tbl(i));
Line: 3200

  END delete_row;
Line: 3205

  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_okc_rule_defs_v_tbl          IN okc_rule_defs_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3214

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

      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_okc_rule_defs_v_tbl          => p_okc_rule_defs_v_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3262

  END delete_row;
Line: 3269

SELECT application_id ,descriptive_flexfield_name
FROM   okc_rule_defs_b
where rule_code = r_c;
Line: 3323

SELECT
    'Y'
FROM
    FND_DESCRIPTIVE_FLEXS B,
    FND_DESCR_FLEX_CONTEXTS A
WHERE
    A.DESCRIPTIVE_FLEX_CONTEXT_CODE = rule_code
and (A.APPLICATION_ID = B.APPLICATION_ID
and B.APPLICATION_ID = appl_id)
and (A.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
and B.DESCRIPTIVE_FLEXFIELD_NAME= dff_name);