DBA Data[Home] [Help]

APPS.OKL_OVT_PVT SQL Statements

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

Line: 43

    SELECT
            ID,
            RUL_ID,
            SEQUENCE_NUMBER,
            OVD_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Ovd_Rul_Tmls
     WHERE okl_ovd_rul_tmls.id  = p_id;
Line: 70

              l_ovt_rec.LAST_UPDATED_BY,
              l_ovt_rec.LAST_UPDATE_DATE,
              l_ovt_rec.LAST_UPDATE_LOGIN;
Line: 93

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            OVD_ID,
            RUL_ID,
            SEQUENCE_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Ovd_Rul_Tmls_V
     WHERE okl_ovd_rul_tmls_v.id = p_id;
Line: 120

              l_ovtv_rec.LAST_UPDATED_BY,
              l_ovtv_rec.LAST_UPDATE_DATE,
              l_ovtv_rec.LAST_UPDATE_LOGIN;
Line: 162

    IF (l_ovtv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_ovtv_rec.last_updated_by := NULL;
Line: 165

    IF (l_ovtv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_ovtv_rec.last_update_date := NULL;
Line: 168

    IF (l_ovtv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_ovtv_rec.last_update_login := NULL;
Line: 234

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              OBJECT1_ID1,
              OBJECT2_ID1,
              OBJECT3_ID1,
              OBJECT1_ID2,
              OBJECT2_ID2,
              OBJECT3_ID2,
              JTOT_OBJECT1_CODE,
              JTOT_OBJECT2_CODE,
              JTOT_OBJECT3_CODE,
              DNZ_CHR_ID,
              RGP_ID,
              PRIORITY,
              STD_TEMPLATE_YN,
-- removed references to okc_rules_tl
              --COMMENTS,
              WARN_YN,
              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,
              TEXT,
              RULE_INFORMATION_CATEGORY,
              RULE_INFORMATION1,
              RULE_INFORMATION2,
              RULE_INFORMATION3,
              RULE_INFORMATION4,
              RULE_INFORMATION5,
              RULE_INFORMATION6,
              RULE_INFORMATION7,
              RULE_INFORMATION8,
              RULE_INFORMATION9,
              RULE_INFORMATION10,
              RULE_INFORMATION11,
              RULE_INFORMATION12,
              RULE_INFORMATION13,
              RULE_INFORMATION14,
              RULE_INFORMATION15
        FROM Okc_Rules_b
       WHERE okc_rules_b.id       = p_id;
Line: 392

      SELECT  '1'
        FROM okl_opv_rules_v
       WHERE okl_opv_rules_v.id = p_id;
Line: 466

      SELECT  '1'
        FROM okc_rules_b
       WHERE okc_rules_b.id = p_id;
Line: 757

  SELECT '1'
  FROM okl_ovd_rul_tmls_v
  WHERE  ovd_id = p_ovd_id
  AND    rul_id = p_rul_id
  AND    id <> nvl(p_ovtv_rec.id,-9999);
Line: 864

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

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

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

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

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

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

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovt_rec                      IN ovt_rec_type,
    x_ovt_rec                      OUT NOCOPY ovt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1053

    l_api_name                     CONSTANT VARCHAR2(30) := 'TMLS_insert_row';
Line: 1089

    INSERT INTO OKL_OVD_RUL_TMLS(
        id,
        rul_id,
        sequence_number,
        ovd_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_ovt_rec.id,
        l_ovt_rec.rul_id,
        l_ovt_rec.sequence_number,
        l_ovt_rec.ovd_id,
        l_ovt_rec.object_version_number,
        l_ovt_rec.created_by,
        l_ovt_rec.creation_date,
        l_ovt_rec.last_updated_by,
        l_ovt_rec.last_update_date,
        l_ovt_rec.last_update_login);
Line: 1145

  END insert_row;
Line: 1149

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovtv_rec                     IN ovtv_rec_type,
    x_ovtv_rec                     OUT NOCOPY ovtv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1159

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

      l_ovtv_rec.LAST_UPDATE_DATE := l_ovtv_rec.CREATION_DATE;
Line: 1176

      l_ovtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1177

      l_ovtv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1241

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ovt_rec,
      lx_ovt_rec
    );
Line: 1289

  END insert_row;
Line: 1293

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovtv_tbl                     IN ovtv_tbl_type,
    x_ovtv_tbl                     OUT NOCOPY ovtv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1303

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

        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_ovtv_rec                     => p_ovtv_tbl(i),
          x_ovtv_rec                     => x_ovtv_tbl(i));
Line: 1364

  END insert_row;
Line: 1382

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OVD_RUL_TMLS
     WHERE ID = p_ovt_rec.id
       AND OBJECT_VERSION_NUMBER = p_ovt_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1389

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OVD_RUL_TMLS
    WHERE ID = p_ovt_rec.id;
Line: 1430

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

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

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovt_rec                      IN ovt_rec_type,
    x_ovt_rec                      OUT NOCOPY ovt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1644

    l_api_name                     CONSTANT VARCHAR2(30) := 'TMLS_update_row';
Line: 1694

      IF (x_ovt_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_ovt_rec.last_updated_by := l_ovt_rec.last_updated_by;
Line: 1698

      IF (x_ovt_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_ovt_rec.last_update_date := l_ovt_rec.last_update_date;
Line: 1702

      IF (x_ovt_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_ovt_rec.last_update_login := l_ovt_rec.last_update_login;
Line: 1746

    UPDATE  OKL_OVD_RUL_TMLS
    SET RUL_ID = l_def_ovt_rec.rul_id,
        SEQUENCE_NUMBER = l_def_ovt_rec.sequence_number,
        OVD_ID = l_def_ovt_rec.ovd_id,
        OBJECT_VERSION_NUMBER = l_def_ovt_rec.object_version_number,
        CREATED_BY = l_def_ovt_rec.created_by,
        CREATION_DATE = l_def_ovt_rec.creation_date,
        LAST_UPDATED_BY = l_def_ovt_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ovt_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ovt_rec.last_update_login
    WHERE ID = l_def_ovt_rec.id;
Line: 1791

  END update_row;
Line: 1795

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovtv_rec                     IN ovtv_rec_type,
    x_ovtv_rec                     OUT NOCOPY ovtv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1805

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

      l_ovtv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1820

      l_ovtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1821

      l_ovtv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1869

      IF (x_ovtv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_ovtv_rec.last_updated_by := l_ovtv_rec.last_updated_by;
Line: 1873

      IF (x_ovtv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_ovtv_rec.last_update_date := l_ovtv_rec.last_update_date;
Line: 1877

      IF (x_ovtv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_ovtv_rec.last_update_login := l_ovtv_rec.last_update_login;
Line: 1948

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ovt_rec,
      lx_ovt_rec
    );
Line: 1995

  END update_row;
Line: 1999

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovtv_tbl                     IN ovtv_tbl_type,
    x_ovtv_tbl                     OUT NOCOPY ovtv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2009

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

        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_ovtv_rec                     => p_ovtv_tbl(i),
          x_ovtv_rec                     => x_ovtv_tbl(i));
Line: 2070

  END update_row;
Line: 2078

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovt_rec                      IN ovt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2086

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

    DELETE FROM OKL_OVD_RUL_TMLS
     WHERE ID = l_ovt_rec.id;
Line: 2135

  END delete_row;
Line: 2139

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovtv_rec                     IN ovtv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2148

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ovt_rec
    );
Line: 2216

  END delete_row;
Line: 2220

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ovtv_tbl                     IN ovtv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2229

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

        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_ovtv_rec                     => p_ovtv_tbl(i));
Line: 2289

  END delete_row;