DBA Data[Home] [Help]

APPS.OKL_GTL_PVT SQL Statements

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

Line: 21

    SELECT  ID
            ,OBJECT_VERSION_NUMBER
            ,GTT_ID
            ,PRIMARY_YN
            ,PRIMARY_STY_ID
            ,DEPENDENT_STY_ID
            ,PRICING_NAME
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
    FROM OKL_ST_GEN_TMPT_LNS
    WHERE OKL_ST_GEN_TMPT_LNS.id = p_id;
Line: 56

        ,l_gtl_rec.last_updated_by
        ,l_gtl_rec.last_update_date
        ,l_gtl_rec.last_update_login;
Line: 82

    SELECT   ID
            ,OBJECT_VERSION_NUMBER
            ,GTT_ID
            ,PRIMARY_YN
            ,PRIMARY_STY_ID
            ,DEPENDENT_STY_ID
            ,PRICING_NAME
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
    FROM OKL_ST_GEN_TMPT_LNS
    WHERE OKL_ST_GEN_TMPT_LNS.ID = p_id;
Line: 115

        ,l_gtlv_rec.last_updated_by
        ,l_gtlv_rec.last_update_date
        ,l_gtlv_rec.last_update_login;
Line: 147

    SELECT NAME stream_name
    FROM OKL_STRM_TYPE_V
    WHERE ID IN
    (
        SELECT primary_Sty_id
        FROM OKL_ST_GEN_TMPT_LNS GTL
        WHERE GTL.GTT_ID  = p_gtt_id
        AND  GTL.PRIMARY_YN = 'Y'
        AND  GTL.PRIMARY_STY_ID = p_pri_sty_id
        AND  GTL.ID <> p_id
    );
Line: 163

    SELECT NAME stream_name
    FROM OKL_STRM_TYPE_V
    WHERE ID IN
    (
        SELECT dependent_sty_id
        FROM OKL_ST_GEN_TMPT_LNS GTL
        WHERE GTL.GTT_ID  = p_gtt_id
        AND  GTL.PRIMARY_YN = 'N'
        AND  GTL.PRIMARY_STY_ID = p_pri_sty_id
        AND  GTL.DEPENDENT_STY_ID = p_dep_sty_id
        AND  GTL.ID <> p_id
    );
Line: 333

  SELECT '1'
  FROM OKL_ST_GEN_TEMPLATES
  WHERE OKL_ST_GEN_TEMPLATES.ID  = p_gtt_id;
Line: 573

    IF (l_gtlv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
      l_gtlv_rec.last_updated_by := NULL;
Line: 576

    IF (l_gtlv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
      l_gtlv_rec.last_update_date := NULL;
Line: 579

    IF (l_gtlv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
      l_gtlv_rec.last_update_login := NULL;
Line: 604

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

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

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

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

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

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

  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_gtl_rec                      IN gtl_rec_type,
    x_gtl_rec                      OUT NOCOPY gtl_rec_type ) AS

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

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

    INSERT INTO OKL_ST_GEN_TMPT_LNS(
        ID
        ,OBJECT_VERSION_NUMBER
        ,GTT_ID
        ,PRIMARY_YN
        ,PRIMARY_STY_ID
        ,DEPENDENT_STY_ID
        ,PRICING_NAME
        ,ORG_ID
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        )
    VALUES (
         l_gtl_rec.id
        ,l_gtl_rec.object_version_number
        ,l_gtl_rec.gtt_id
        ,l_gtl_rec.primary_yn
        ,l_gtl_rec.primary_sty_id
        ,l_gtl_rec.dependent_sty_id
        ,l_gtl_rec.pricing_name
        ,l_gtl_rec.org_id
        ,l_gtl_rec.created_by
        ,l_gtl_rec.creation_date
        ,l_gtl_rec.last_updated_by
        ,l_gtl_rec.last_update_date
        ,l_gtl_rec.last_update_login
    );
Line: 765

  END insert_row;
Line: 768

  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_gtlv_rec                     IN  gtlv_rec_type,
    x_gtlv_rec                     OUT NOCOPY gtlv_rec_type ) IS

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

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

      l_gtlv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 796

      l_gtlv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 797

      l_gtlv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 877

    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_gtl_rec => l_gtl_rec
      ,x_gtl_rec => lx_gtl_rec
    );
Line: 933

  END; -- insert_row
Line: 938

  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_gtlv_tbl                     IN  gtlv_tbl_type,
    x_gtlv_tbl                     OUT NOCOPY gtlv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 948

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

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => p_init_msg_list, -- Bug 4054596: Issue No. 3
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_gtlv_rec                     => p_gtlv_tbl(i),
          x_gtlv_rec                     => x_gtlv_tbl(i));
Line: 1013

  END insert_row;
Line: 1029

  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_gtl_rec                      IN  gtl_rec_type,
    x_gtl_rec                      OUT NOCOPY gtl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1038

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

      IF (x_gtl_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_gtl_rec.last_updated_by := l_gtl_rec.last_updated_by;
Line: 1102

      IF (x_gtl_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_gtl_rec.last_update_date := l_gtl_rec.last_update_date;
Line: 1106

      IF (x_gtl_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_gtl_rec.last_update_login := l_gtl_rec.last_update_login;
Line: 1153

    UPDATE  OKL_ST_GEN_TMPT_LNS
    SET ID                     = l_def_gtl_rec.id
        ,OBJECT_VERSION_NUMBER  = l_def_gtl_rec.object_version_number
        ,GTT_ID                 = l_def_gtl_rec.gtt_id
        ,PRIMARY_YN             = l_def_gtl_rec.primary_yn
        ,PRIMARY_STY_ID         = l_def_gtl_rec.primary_sty_id
        ,DEPENDENT_STY_ID       = l_def_gtl_rec.dependent_sty_id
        ,PRICING_NAME           = l_def_gtl_rec.pricing_name
        ,ORG_ID                 = l_def_gtl_rec.org_id
        ,CREATED_BY             = l_def_gtl_rec.created_by
        ,CREATION_DATE          = l_def_gtl_rec.creation_date
        ,LAST_UPDATED_BY        = l_def_gtl_rec.last_updated_by
        ,LAST_UPDATE_DATE       = l_def_gtl_rec.last_update_date
        ,LAST_UPDATE_LOGIN      = l_def_gtl_rec.last_update_login
    WHERE ID = l_def_gtl_rec.id;
Line: 1202

  END update_row;
Line: 1205

    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_gtlv_rec                     IN  gtlv_rec_type,
    x_gtlv_rec                     OUT NOCOPY gtlv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1215

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

      l_gtlv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1230

      l_gtlv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1231

      l_gtlv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1288

      IF (x_gtlv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_gtlv_rec.last_updated_by := l_gtlv_rec.last_updated_by;
Line: 1292

      IF (x_gtlv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_gtlv_rec.last_update_date := l_gtlv_rec.last_update_date;
Line: 1296

      IF (x_gtlv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_gtlv_rec.last_update_login := l_gtlv_rec.last_update_login;
Line: 1370

    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_gtl_rec => l_gtl_rec,
      x_gtl_rec => lx_gtl_rec
    );
Line: 1424

  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_gtlv_tbl                     IN  gtlv_tbl_type,
    x_gtlv_tbl                     OUT NOCOPY gtlv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1434

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

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => p_init_msg_list, -- Bug 4054596: Issue No. 3
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_gtlv_rec                     => p_gtlv_tbl(i),
          x_gtlv_rec                     => x_gtlv_tbl(i));
Line: 1498

  END update_row;
Line: 1506

  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_gtl_rec                      IN  gtl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1514

    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row';
Line: 1530

    DELETE FROM OKL_ST_GEN_TMPT_LNS
     WHERE ID = l_gtl_rec.id;
Line: 1566

  END delete_row;
Line: 1570

  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_gtlv_rec                     IN  gtlv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1579

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

    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_gtl_rec => l_gtl_rec
    );
Line: 1649

  END delete_row;
Line: 1654

  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_gtlv_tbl                     IN  gtlv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1663

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

        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_gtlv_rec                     => p_gtlv_tbl(i));
Line: 1726

  END delete_row;