DBA Data[Home] [Help]

APPS.OKL_PMV_PVT SQL Statements

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

Line: 43

    SELECT
            ID,
            PTL_ID,
            PTQ_ID,
            PTV_ID,
            OBJECT_VERSION_NUMBER,
            FROM_DATE,
            TO_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Ptl_Ptq_Vals
     WHERE okl_ptl_ptq_vals.id  = p_id;
Line: 74

              l_pmv_rec.LAST_UPDATED_BY,
              l_pmv_rec.LAST_UPDATE_DATE,
              l_pmv_rec.LAST_UPDATE_LOGIN;
Line: 97

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            PTV_ID,
            PTL_ID,
            PTQ_ID,
            FROM_DATE,
            TO_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Ptl_Ptq_Vals_V
     WHERE okl_ptl_ptq_vals_v.id = p_id;
Line: 128

              l_pmvv_rec.LAST_UPDATED_BY,
              l_pmvv_rec.LAST_UPDATE_DATE,
              l_pmvv_rec.LAST_UPDATE_LOGIN;
Line: 176

    IF (l_pmvv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_pmvv_rec.last_updated_by := NULL;
Line: 179

    IF (l_pmvv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_pmvv_rec.last_update_date := NULL;
Line: 182

    IF (l_pmvv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_pmvv_rec.last_update_login := NULL;
Line: 318

      SELECT  '1'
        FROM okl_pdt_templates_v
       WHERE okl_pdt_templates_v.id = p_id;
Line: 394

      SELECT  '1'
        FROM okl_ptl_qualitys_v
       WHERE okl_ptl_qualitys_v.id = p_id;
Line: 469

      SELECT  '1'
        FROM okl_ptq_values_v
       WHERE okl_ptq_values_v.id = p_id;
Line: 825

  SELECT '1'
  FROM okl_ptl_ptq_vals_v
  WHERE  ptl_id = p_ptl_id
  AND    ptq_id = p_ptq_id
  AND    id <> nvl(p_pmvv_rec.id,-9999);
Line: 948

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

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

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

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

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

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

  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_pmv_rec                      IN pmv_rec_type,
    x_pmv_rec                      OUT NOCOPY pmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1140

    l_api_name                     CONSTANT VARCHAR2(30) := 'VALS_insert_row';
Line: 1176

    INSERT INTO OKL_PTL_PTQ_VALS(
        id,
        ptl_id,
        ptq_id,
        ptv_id,
        object_version_number,
        from_date,
        to_date,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_pmv_rec.id,
        l_pmv_rec.ptl_id,
        l_pmv_rec.ptq_id,
        l_pmv_rec.ptv_id,
        l_pmv_rec.object_version_number,
        l_pmv_rec.from_date,
        l_pmv_rec.to_date,
        l_pmv_rec.created_by,
        l_pmv_rec.creation_date,
        l_pmv_rec.last_updated_by,
        l_pmv_rec.last_update_date,
        l_pmv_rec.last_update_login);
Line: 1236

  END insert_row;
Line: 1240

  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_pmvv_rec                     IN pmvv_rec_type,
    x_pmvv_rec                     OUT NOCOPY pmvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1250

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

      l_pmvv_rec.LAST_UPDATE_DATE := l_pmvv_rec.CREATION_DATE;
Line: 1267

      l_pmvv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1268

      l_pmvv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1332

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pmv_rec,
      lx_pmv_rec
    );
Line: 1380

  END insert_row;
Line: 1384

  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_pmvv_tbl                     IN pmvv_tbl_type,
    x_pmvv_tbl                     OUT NOCOPY pmvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1394

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

        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_pmvv_rec                     => p_pmvv_tbl(i),
          x_pmvv_rec                     => x_pmvv_tbl(i));
Line: 1455

  END insert_row;
Line: 1473

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PTL_PTQ_VALS
     WHERE ID = p_pmv_rec.id
       AND OBJECT_VERSION_NUMBER = p_pmv_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1480

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PTL_PTQ_VALS
    WHERE ID = p_pmv_rec.id;
Line: 1521

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

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

  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_pmv_rec                      IN pmv_rec_type,
    x_pmv_rec                      OUT NOCOPY pmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1735

    l_api_name                     CONSTANT VARCHAR2(30) := 'VALS_update_row';
Line: 1793

      IF (x_pmv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pmv_rec.last_updated_by := l_pmv_rec.last_updated_by;
Line: 1797

      IF (x_pmv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pmv_rec.last_update_date := l_pmv_rec.last_update_date;
Line: 1801

      IF (x_pmv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pmv_rec.last_update_login := l_pmv_rec.last_update_login;
Line: 1845

    UPDATE  OKL_PTL_PTQ_VALS
    SET PTL_ID = l_def_pmv_rec.ptl_id,
        PTQ_ID = l_def_pmv_rec.ptq_id,
        PTV_ID = l_def_pmv_rec.ptv_id,
        OBJECT_VERSION_NUMBER = l_def_pmv_rec.object_version_number,
        FROM_DATE = l_def_pmv_rec.from_date,
        TO_DATE = l_def_pmv_rec.to_date,
        CREATED_BY = l_def_pmv_rec.created_by,
        CREATION_DATE = l_def_pmv_rec.creation_date,
        LAST_UPDATED_BY = l_def_pmv_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pmv_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pmv_rec.last_update_login
    WHERE ID = l_def_pmv_rec.id;
Line: 1892

  END update_row;
Line: 1896

  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_pmvv_rec                     IN pmvv_rec_type,
    x_pmvv_rec                     OUT NOCOPY pmvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1906

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

      l_pmvv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1921

      l_pmvv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1922

      l_pmvv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1978

      IF (x_pmvv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pmvv_rec.last_updated_by := l_pmvv_rec.last_updated_by;
Line: 1982

      IF (x_pmvv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pmvv_rec.last_update_date := l_pmvv_rec.last_update_date;
Line: 1986

      IF (x_pmvv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pmvv_rec.last_update_login := l_pmvv_rec.last_update_login;
Line: 2057

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pmv_rec,
      lx_pmv_rec
    );
Line: 2104

  END update_row;
Line: 2108

  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_pmvv_tbl                     IN pmvv_tbl_type,
    x_pmvv_tbl                     OUT NOCOPY pmvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2118

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

        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_pmvv_rec                     => p_pmvv_tbl(i),
          x_pmvv_rec                     => x_pmvv_tbl(i));
Line: 2179

  END update_row;
Line: 2187

  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_pmv_rec                      IN pmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2195

    l_api_name                     CONSTANT VARCHAR2(30) := 'VALS_delete_row';
Line: 2209

    DELETE FROM OKL_PTL_PTQ_VALS
     WHERE ID = l_pmv_rec.id;
Line: 2244

  END delete_row;
Line: 2248

  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_pmvv_rec                     IN pmvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2257

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pmv_rec
    );
Line: 2325

  END delete_row;
Line: 2329

  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_pmvv_tbl                     IN pmvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2338

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

        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_pmvv_rec                     => p_pmvv_tbl(i));
Line: 2398

  END delete_row;