DBA Data[Home] [Help]

APPS.OKL_GTT_PVT SQL Statements

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

Line: 20

    SELECT  ID
            ,OBJECT_VERSION_NUMBER
            ,GTS_ID
            ,VERSION
            ,START_DATE
            ,END_DATE
            ,TMPT_STATUS
            ,ATTRIBUTE_CATEGORY
            ,ATTRIBUTE1
            ,ATTRIBUTE2
            ,ATTRIBUTE3
            ,ATTRIBUTE4
            ,ATTRIBUTE5
            ,ATTRIBUTE6
            ,ATTRIBUTE7
            ,ATTRIBUTE8
            ,ATTRIBUTE9
            ,ATTRIBUTE10
            ,ATTRIBUTE11
            ,ATTRIBUTE12
            ,ATTRIBUTE13
            ,ATTRIBUTE14
            ,ATTRIBUTE15
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
    FROM OKL_ST_GEN_TEMPLATES
    WHERE OKL_ST_GEN_TEMPLATES.id = p_id;
Line: 87

        ,l_gtt_rec.last_updated_by
        ,l_gtt_rec.last_update_date
        ,l_gtt_rec.last_update_login;
Line: 113

    SELECT   ID
            ,OBJECT_VERSION_NUMBER
            ,GTS_ID
            ,VERSION
            ,START_DATE
            ,END_DATE
            ,TMPT_STATUS
            ,ATTRIBUTE_CATEGORY
            ,ATTRIBUTE1
            ,ATTRIBUTE2
            ,ATTRIBUTE3
            ,ATTRIBUTE4
            ,ATTRIBUTE5
            ,ATTRIBUTE6
            ,ATTRIBUTE7
            ,ATTRIBUTE8
            ,ATTRIBUTE9
            ,ATTRIBUTE10
            ,ATTRIBUTE11
            ,ATTRIBUTE12
            ,ATTRIBUTE13
            ,ATTRIBUTE14
            ,ATTRIBUTE15
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
    FROM OKL_ST_GEN_TEMPLATES
    WHERE OKL_ST_GEN_TEMPLATES.ID = p_id;
Line: 178

        ,l_gttv_rec.last_updated_by
        ,l_gttv_rec.last_update_date
        ,l_gttv_rec.last_update_login;
Line: 433

  SELECT '1'
  FROM OKL_ST_GEN_TMPT_SETS
  WHERE OKL_ST_GEN_TMPT_SETS.ID  = p_gts_id;
Line: 758

    IF (l_gttv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
      l_gttv_rec.last_updated_by := NULL;
Line: 761

    IF (l_gttv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
      l_gttv_rec.last_update_date := NULL;
Line: 764

    IF (l_gttv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
      l_gttv_rec.last_update_login := NULL;
Line: 805

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

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

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

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

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

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

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_gtt_rec                      IN gtt_rec_type,
    x_gtt_rec                      OUT NOCOPY gtt_rec_type ) AS

    -- Local Variables within the function
    l_api_version                 CONSTANT NUMBER := 1;
Line: 875

    l_api_name                    CONSTANT VARCHAR2(30) := 'insert_row';
Line: 915

    INSERT INTO OKL_ST_GEN_TEMPLATES(
         id
        ,object_version_number
        ,gts_id
        ,version
        ,start_date
        ,end_date
        ,tmpt_status
        ,attribute_category
        ,attribute1
        ,attribute2
        ,attribute3
        ,attribute4
        ,attribute5
        ,attribute6
        ,attribute7
        ,attribute8
        ,attribute9
        ,attribute10
        ,attribute11
        ,attribute12
        ,attribute13
        ,attribute14
        ,attribute15
        ,org_id
        ,created_by
        ,creation_date
        ,last_updated_by
        ,last_update_date
        ,last_update_login
    )
    VALUES (
         l_gtt_rec.id
        ,l_gtt_rec.object_version_number
        ,l_gtt_rec.gts_id
        ,l_gtt_rec.version
        ,l_gtt_rec.start_date
        ,l_gtt_rec.end_date
        ,l_gtt_rec.tmpt_status
        ,l_gtt_rec.attribute_category
        ,l_gtt_rec.attribute1
        ,l_gtt_rec.attribute2
        ,l_gtt_rec.attribute3
        ,l_gtt_rec.attribute4
        ,l_gtt_rec.attribute5
        ,l_gtt_rec.attribute6
        ,l_gtt_rec.attribute7
        ,l_gtt_rec.attribute8
        ,l_gtt_rec.attribute9
        ,l_gtt_rec.attribute10
        ,l_gtt_rec.attribute11
        ,l_gtt_rec.attribute12
        ,l_gtt_rec.attribute13
        ,l_gtt_rec.attribute14
        ,l_gtt_rec.attribute15
        ,l_gtt_rec.org_id
        ,l_gtt_rec.created_by
        ,l_gtt_rec.creation_date
        ,l_gtt_rec.last_updated_by
        ,l_gtt_rec.last_update_date
        ,l_gtt_rec.last_update_login
    );
Line: 1013

  END insert_row;
Line: 1015

  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_gttv_rec                     IN  gttv_rec_type,
    x_gttv_rec                     OUT NOCOPY gttv_rec_type ) IS

    -- Local Variables within the function
    l_api_version                  CONSTANT NUMBER := 1;
Line: 1026

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

      l_gttv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1043

      l_gttv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1044

      l_gttv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1124

    insert_row (
       p_api_version => l_api_version
      ,p_init_msg_list => p_init_msg_list
      ,x_return_status => x_return_status
      ,x_msg_count => x_msg_count
      ,x_msg_data  => x_msg_data
      ,p_gtt_rec => l_gtt_rec
      ,x_gtt_rec => lx_gtt_rec
    );
Line: 1176

  END; -- insert_row
Line: 1181

  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_gttv_tbl                     IN  gttv_tbl_type,
    x_gttv_tbl                     OUT NOCOPY gttv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1191

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

        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_gttv_rec                     => p_gttv_tbl(i),
          x_gttv_rec                     => x_gttv_tbl(i));
Line: 1256

  END insert_row;
Line: 1273

  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_gtt_rec                      IN  gtt_rec_type,
    x_gtt_rec                      OUT NOCOPY gtt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1282

    l_api_name                     CONSTANT VARCHAR2(30) := 'OPTS_update_row';
Line: 1386

      IF (x_gtt_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_gtt_rec.last_updated_by := l_gtt_rec.last_updated_by;
Line: 1390

      IF (x_gtt_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_gtt_rec.last_update_date := l_gtt_rec.last_update_date;
Line: 1394

      IF (x_gtt_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_gtt_rec.last_update_login := l_gtt_rec.last_update_login;
Line: 1441

    UPDATE  OKL_ST_GEN_TEMPLATES
    SET ID                     = l_def_gtt_rec.id
        ,OBJECT_VERSION_NUMBER  = l_def_gtt_rec.object_version_number
        ,GTS_ID                = l_def_gtt_rec.gts_id
        ,VERSION               = l_def_gtt_rec.version
        ,START_DATE            = l_def_gtt_rec.start_date
        ,END_DATE              = l_def_gtt_rec.end_date
        ,TMPT_STATUS           = l_def_gtt_rec.tmpt_status
        ,ATTRIBUTE_CATEGORY    = l_def_gtt_rec.attribute_category
        ,ATTRIBUTE1            = l_def_gtt_rec.attribute1
        ,ATTRIBUTE2            = l_def_gtt_rec.attribute2
        ,ATTRIBUTE3            = l_def_gtt_rec.attribute3
        ,ATTRIBUTE4            = l_def_gtt_rec.attribute4
        ,ATTRIBUTE5            = l_def_gtt_rec.attribute5
        ,ATTRIBUTE6            = l_def_gtt_rec.attribute6
        ,ATTRIBUTE7            = l_def_gtt_rec.attribute7
        ,ATTRIBUTE8            = l_def_gtt_rec.attribute8
        ,ATTRIBUTE9            = l_def_gtt_rec.attribute9
        ,ATTRIBUTE10           = l_def_gtt_rec.attribute10
        ,ATTRIBUTE11           = l_def_gtt_rec.attribute11
        ,ATTRIBUTE12           = l_def_gtt_rec.attribute12
        ,ATTRIBUTE13           = l_def_gtt_rec.attribute13
        ,ATTRIBUTE14           = l_def_gtt_rec.attribute14
        ,ATTRIBUTE15           = l_def_gtt_rec.attribute15
        ,ORG_ID                = l_def_gtt_rec.org_id
        ,CREATED_BY            = l_def_gtt_rec.created_by
        ,CREATION_DATE         = l_def_gtt_rec.creation_date
        ,LAST_UPDATED_BY       = l_def_gtt_rec.last_updated_by
        ,LAST_UPDATE_DATE      = l_def_gtt_rec.last_update_date
        ,LAST_UPDATE_LOGIN     = l_def_gtt_rec.last_update_login
    WHERE ID = l_def_gtt_rec.id;
Line: 1507

  END update_row;
Line: 1509

    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_gttv_rec                      IN  gttv_rec_type,
    x_gttv_rec                      OUT NOCOPY gttv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1519

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

      l_gttv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1534

      l_gttv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1535

      l_gttv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1637

      IF (x_gttv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_gttv_rec.last_updated_by := l_gttv_rec.last_updated_by;
Line: 1641

      IF (x_gttv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_gttv_rec.last_update_date := l_gttv_rec.last_update_date;
Line: 1645

      IF (x_gttv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_gttv_rec.last_update_login := l_gttv_rec.last_update_login;
Line: 1719

    update_row(
      p_init_msg_list => p_init_msg_list,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data => x_msg_data,
      p_gtt_rec => l_gtt_rec,
      x_gtt_rec => lx_gtt_rec
    );
Line: 1775

  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_gttv_tbl                     IN  gttv_tbl_type,
    x_gttv_tbl                     OUT NOCOPY gttv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1785

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

        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_gttv_rec                     => p_gttv_tbl(i),
          x_gttv_rec                     => x_gttv_tbl(i));
Line: 1849

  END update_row;
Line: 1857

  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_gtt_rec                      IN  gtt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1865

    l_api_name                     CONSTANT VARCHAR2(30) := 'OPTS_delete_row';
Line: 1881

    DELETE FROM OKL_ST_GEN_TEMPLATES
     WHERE ID = l_gtt_rec.id;
Line: 1917

  END delete_row;
Line: 1922

  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_gttv_rec                     IN  gttv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1931

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

    delete_row(
      p_init_msg_list => p_init_msg_list,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data => x_msg_data,
      p_gtt_rec => l_gtt_rec
    );
Line: 2000

  END delete_row;
Line: 2005

  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_gttv_tbl                     IN  gttv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2014

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

        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_gttv_rec                     => p_gttv_tbl(i));
Line: 2078

  END delete_row;