DBA Data[Home] [Help]

APPS.OKL_GTP_PVT SQL Statements

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

Line: 21

    SELECT  ID
            ,OBJECT_VERSION_NUMBER
            ,NAME
            ,DESCRIPTION
            ,DISPLAY_YN
            ,UPDATE_YN
            ,PRC_ENG_IDENT
            ,DEFAULT_VALUE
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
            ,GTT_ID
    FROM OKL_ST_GEN_PRC_PARAMS
    WHERE OKL_ST_GEN_PRC_PARAMS.id = p_id;
Line: 53

        ,l_gtp_rec.update_yn
        ,l_gtp_rec.prc_eng_ident
        ,l_gtp_rec.default_value
        ,l_gtp_rec.org_id
        ,l_gtp_rec.created_by
        ,l_gtp_rec.creation_date
        ,l_gtp_rec.last_updated_by
        ,l_gtp_rec.last_update_date
        ,l_gtp_rec.last_update_login
        ,l_gtp_rec.gtt_id;
Line: 86

    SELECT   ID
            ,OBJECT_VERSION_NUMBER
            ,NAME
            ,DESCRIPTION
            ,DISPLAY_YN
            ,UPDATE_YN
            ,PRC_ENG_IDENT
            ,DEFAULT_VALUE
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
            ,GTT_ID
    FROM OKL_ST_GEN_PRC_PARAMS
    WHERE OKL_ST_GEN_PRC_PARAMS.ID = p_id;
Line: 116

        ,l_gtpv_rec.update_yn
        ,l_gtpv_rec.prc_eng_ident
        ,l_gtpv_rec.default_value
        ,l_gtpv_rec.org_id
        ,l_gtpv_rec.created_by
        ,l_gtpv_rec.creation_date
        ,l_gtpv_rec.last_updated_by
        ,l_gtpv_rec.last_update_date
        ,l_gtpv_rec.last_update_login
        ,l_gtpv_rec.gtt_id;
Line: 175

    IF ( p_gtpv_rec.display_yn = 'Y' AND ( p_gtpv_rec.update_yn NOT IN  ( 'Y' , 'N' ) ) )
    THEN
     okl_api.SET_MESSAGE(   p_app_name     => g_app_name,
                                p_msg_name     => 'OKL_DUMMY_MESSAGE',
                                p_token1       => 'TOKEN1',
                                p_token1_value => 'UPDATE_YN cannot have a value with out a value in DISPLAY_YN');
Line: 311

    SELECT  ID,
            NAME PRC_PARAM_NAME
    FROM OKL_ST_GEN_PRC_PARAMS gtp
    WHERE UPPER(gtp.name) = upper( p_name )
     AND  gtp.gtt_id = p_gtt_id;
Line: 373

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

  PROCEDURE Validate_update_yn(
    p_gtpv_rec      IN   gtpv_rec_type,
    x_return_status OUT NOCOPY  VARCHAR2
  ) IS

  BEGIN
    -- initialize return status
    x_return_status := Okl_Api.G_RET_STS_SUCCESS;
Line: 502

    IF p_gtpv_rec.update_yn IS NOT NULL AND p_gtpv_rec.update_yn NOT IN ( 'Y', 'N' )
       AND p_gtpv_rec.update_yn <> Okl_Api.G_MISS_CHAR    THEN
      Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'UPDATE_YN');
Line: 527

  END Validate_update_yn;
Line: 637

    Validate_update_yn(p_gtpv_rec, x_return_status);
Line: 714

    IF (l_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
        l_gtpv_rec.update_yn := NULL;
Line: 732

    IF (l_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
      l_gtpv_rec.last_updated_by := NULL;
Line: 735

    IF (l_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
      l_gtpv_rec.last_update_date := NULL;
Line: 738

    IF (l_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
      l_gtpv_rec.last_update_login := NULL;
Line: 762

    p_to.update_yn := p_from.update_yn;
Line: 768

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

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

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

    p_to.update_yn := p_from.update_yn;
Line: 794

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

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

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

  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_gtp_rec                      IN gtp_rec_type,
    x_gtp_rec                      OUT NOCOPY gtp_rec_type ) AS

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

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

    INSERT INTO OKL_ST_GEN_PRC_PARAMS(
        ID
        ,OBJECT_VERSION_NUMBER
        ,NAME
        ,DESCRIPTION
        ,DISPLAY_YN
        ,UPDATE_YN
        ,PRC_ENG_IDENT
        ,DEFAULT_VALUE
        ,ORG_ID
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        ,GTT_ID
        )
    VALUES (
         l_gtp_rec.id
        ,l_gtp_rec.object_version_number
        ,l_gtp_rec.name
        ,l_gtp_rec.description
        ,l_gtp_rec.display_yn
        ,l_gtp_rec.update_yn
        ,l_gtp_rec.prc_eng_ident
        ,l_gtp_rec.default_value
        ,l_gtp_rec.org_id
        ,l_gtp_rec.created_by
        ,l_gtp_rec.creation_date
        ,l_gtp_rec.last_updated_by
        ,l_gtp_rec.last_update_date
        ,l_gtp_rec.last_update_login
        ,l_gtp_rec.gtt_id
    );
Line: 935

  END insert_row;
Line: 937

  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_gtpv_rec                     IN  gtpv_rec_type,
    x_gtpv_rec                     OUT NOCOPY gtpv_rec_type ) IS

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

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

      l_gtpv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 965

      l_gtpv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 966

      l_gtpv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1045

    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_gtp_rec => l_gtp_rec
      ,x_gtp_rec => lx_gtp_rec
    );
Line: 1097

  END; -- insert_row
Line: 1102

  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_gtpv_tbl                     IN  gtpv_tbl_type,
    x_gtpv_tbl                     OUT NOCOPY gtpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1112

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

        insert_row (
          p_api_version                  => l_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_gtpv_rec                     => p_gtpv_tbl(i),
          x_gtpv_rec                     => x_gtpv_tbl(i));
Line: 1177

  END insert_row;
Line: 1193

  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_gtp_rec                      IN  gtp_rec_type,
    x_gtp_rec                      OUT NOCOPY gtp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1202

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

            IF (x_gtp_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
        x_gtp_rec.update_yn := l_gtp_rec.update_yn;
Line: 1264

      IF (x_gtp_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_gtp_rec.last_updated_by := l_gtp_rec.last_updated_by;
Line: 1268

      IF (x_gtp_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_gtp_rec.last_update_date := l_gtp_rec.last_update_date;
Line: 1272

      IF (x_gtp_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_gtp_rec.last_update_login := l_gtp_rec.last_update_login;
Line: 1323

    UPDATE  OKL_ST_GEN_PRC_PARAMS
    SET ID                      = l_def_gtp_rec.id
        ,OBJECT_VERSION_NUMBER  = l_def_gtp_rec.object_version_number
        ,NAME                   = l_def_gtp_rec.name
        ,DESCRIPTION            = l_def_gtp_rec.description
        ,DISPLAY_YN             = l_def_gtp_rec.display_yn
        ,UPDATE_YN              = l_def_gtp_rec.update_yn
        ,PRC_ENG_IDENT          = l_def_gtp_rec.prc_eng_ident
        ,DEFAULT_VALUE          = l_def_gtp_rec.default_value
        ,ORG_ID                 = l_def_gtp_rec.org_id
        ,CREATED_BY             = l_def_gtp_rec.created_by
        ,CREATION_DATE          = l_def_gtp_rec.creation_date
        ,LAST_UPDATED_BY        = l_def_gtp_rec.last_updated_by
        ,LAST_UPDATE_DATE       = l_def_gtp_rec.last_update_date
        ,LAST_UPDATE_LOGIN      = l_def_gtp_rec.last_update_login
        ,GTT_ID                 = l_def_gtp_rec.gtt_id
    WHERE ID = l_def_gtp_rec.id;
Line: 1374

  END update_row;
Line: 1377

  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_gtpv_rec                     IN  gtpv_rec_type,
    x_gtpv_rec                     OUT NOCOPY gtpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1387

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

      l_gtpv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1402

      l_gtpv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1403

      l_gtpv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1442

            IF (x_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
        x_gtpv_rec.update_yn := l_gtpv_rec.update_yn;
Line: 1464

      IF (x_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_gtpv_rec.last_updated_by := l_gtpv_rec.last_updated_by;
Line: 1468

      IF (x_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_gtpv_rec.last_update_date := l_gtpv_rec.last_update_date;
Line: 1472

      IF (x_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_gtpv_rec.last_update_login := l_gtpv_rec.last_update_login;
Line: 1547

    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_gtp_rec => l_gtp_rec,
      x_gtp_rec => lx_gtp_rec
    );
Line: 1601

  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_gtpv_tbl                     IN  gtpv_tbl_type,
    x_gtpv_tbl                     OUT NOCOPY gtpv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1611

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

        update_row (
          p_api_version                  => l_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_gtpv_rec                     => p_gtpv_tbl(i),
          x_gtpv_rec                     => x_gtpv_tbl(i));
Line: 1675

  END update_row;
Line: 1683

  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_gtp_rec                      IN  gtp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1691

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

    DELETE FROM OKL_ST_GEN_PRC_PARAMS
     WHERE ID = l_gtp_rec.id;
Line: 1743

  END delete_row;
Line: 1748

  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_gtpv_rec                     IN  gtpv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1757

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

    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_gtp_rec => l_gtp_rec
    );
Line: 1827

  END delete_row;
Line: 1834

  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_gtpv_tbl                     IN  gtpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1843

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

        delete_row (
          p_api_version                  => l_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_gtpv_rec                     => p_gtpv_tbl(i));
Line: 1906

  END delete_row;