DBA Data[Home] [Help]

APPS.OKL_GTS_PVT SQL Statements

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

Line: 19

    SELECT  ID
            ,OBJECT_VERSION_NUMBER
            ,NAME
            ,DESCRIPTION
            ,PRODUCT_TYPE
            ,TAX_OWNER
            ,DEAL_TYPE
            ,PRICING_ENGINE
            ,ORG_ID
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
            ,INTEREST_CALC_METH_CODE
            ,REVENUE_RECOG_METH_CODE
            ,DAYS_IN_MONTH_CODE
            ,DAYS_IN_YR_CODE
           ,ISG_ARREARS_PAY_DATES_OPTION
    FROM OKL_ST_GEN_TMPT_SETS
    WHERE OKL_ST_GEN_TMPT_SETS.id = p_id;
Line: 61

        ,l_gts_rec.last_updated_by
        ,l_gts_rec.last_update_date
        ,l_gts_rec.last_update_login
        ,l_gts_rec.interest_calc_meth_code
        ,l_gts_rec.revenue_recog_meth_code
        ,l_gts_rec.days_in_month_code
        ,l_gts_rec.days_in_yr_code
        ,l_gts_rec.isg_arrears_pay_dates_option;
Line: 93

    SELECT ID
        ,OBJECT_VERSION_NUMBER
        ,NAME
        ,DESCRIPTION
        ,PRODUCT_TYPE
        ,TAX_OWNER
        ,DEAL_TYPE
        ,PRICING_ENGINE
        ,ORG_ID
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        ,INTEREST_CALC_METH_CODE
        ,REVENUE_RECOG_METH_CODE
        ,DAYS_IN_MONTH_CODE
        ,DAYS_IN_YR_CODE
        ,ISG_ARREARS_PAY_DATES_OPTION
FROM OKL_ST_GEN_TMPT_SETS
    WHERE OKL_ST_GEN_TMPT_SETS.ID = p_id;
Line: 133

        ,l_gtsv_rec.last_updated_by
        ,l_gtsv_rec.last_update_date
        ,l_gtsv_rec.last_update_login
        ,l_gtsv_rec.interest_calc_meth_code
        ,l_gtsv_rec.revenue_recog_meth_code
        ,l_gtsv_rec.days_in_month_code
        ,l_gtsv_rec.days_in_yr_code
        ,l_gtsv_rec.isg_arrears_pay_dates_option;
Line: 323

    SELECT  ID
           ,name tmpt_set_name
    FROM OKL_ST_GEN_TMPT_SETS gts
    WHERE UPPER(gts.name) = upper( p_name );
Line: 1130

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

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

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

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

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

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

    IF (l_gtsv_rec.last_updated_by = okl_api.G_MISS_NUM) THEN
      l_gtsv_rec.last_updated_by := NULL;
Line: 1224

    IF (l_gtsv_rec.last_update_date = okl_api.G_MISS_DATE) THEN
      l_gtsv_rec.last_update_date := NULL;
Line: 1227

    IF (l_gtsv_rec.last_update_login = okl_api.G_MISS_NUM) THEN
      l_gtsv_rec.last_update_login := NULL;
Line: 1262

  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_gts_rec                      IN gts_rec_type,
    x_gts_rec                      OUT NOCOPY gts_rec_type ) IS

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

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

    INSERT INTO OKL_ST_GEN_TMPT_SETS(
       Id
      ,object_version_number
      ,name
      ,description
      ,product_type
      ,tax_owner
      ,deal_type
      ,pricing_engine
      ,org_id
      ,created_by
      ,creation_date
      ,last_updated_by
      ,last_update_date
      ,last_update_login
      ,interest_calc_meth_code
      ,revenue_recog_meth_code
      ,days_in_month_code
      ,days_in_yr_code
      ,isg_arrears_pay_dates_option
    )
    VALUES (
       l_gts_rec.Id
      ,l_gts_rec.object_version_number
      ,l_gts_rec.name
      ,l_gts_rec.description
      ,l_gts_rec.product_type
      ,l_gts_rec.tax_owner
      ,l_gts_rec.deal_type
      ,l_gts_rec.pricing_engine
      ,l_gts_rec.org_id
      ,l_gts_rec.created_by
      ,l_gts_rec.creation_date
      ,l_gts_rec.last_updated_by
      ,l_gts_rec.last_update_date
      ,l_gts_rec.last_update_login
      ,l_gts_rec.interest_calc_meth_code
      ,l_gts_rec.revenue_recog_meth_code
      ,l_gts_rec.days_in_month_code
      ,l_gts_rec.days_in_yr_code
      ,l_gts_rec.isg_arrears_pay_dates_option
    );
Line: 1391

  END insert_row;
Line: 1393

  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_gtsv_rec                     IN gtsv_rec_type,
    x_gtsv_rec                     OUT NOCOPY gtsv_rec_type ) IS

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

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

      l_gtsv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1421

      l_gtsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1422

      l_gtsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1496

    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_gts_rec => l_gts_rec,
      x_gts_rec => lx_gts_rec
    );
Line: 1547

  END; -- insert_row
Line: 1552

  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_gtsv_tbl                     IN  gtsv_tbl_type,
    x_gtsv_tbl                     OUT NOCOPY gtsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1562

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

        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_gtsv_rec                     => p_gtsv_tbl(i),
          x_gtsv_rec                     => x_gtsv_tbl(i));
Line: 1627

  END insert_row;
Line: 1643

  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_gts_rec                      IN  gts_rec_type,
    x_gts_rec                      OUT NOCOPY gts_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1652

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

      IF (x_gts_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_gts_rec.last_updated_by := l_gts_rec.last_updated_by;
Line: 1724

      IF (x_gts_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_gts_rec.last_update_date := l_gts_rec.last_update_date;
Line: 1728

      IF (x_gts_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_gts_rec.last_update_login := l_gts_rec.last_update_login;
Line: 1801

    UPDATE  OKL_ST_GEN_TMPT_SETS
    SET ID                     = l_def_gts_rec.id
        ,OBJECT_VERSION_NUMBER = l_def_gts_rec.object_version_number
        ,NAME                  = l_def_gts_rec.name
        ,DESCRIPTION           = l_def_gts_rec.description
        ,PRODUCT_TYPE          = l_def_gts_rec.product_type
        ,TAX_OWNER             = l_def_gts_rec.tax_owner
        ,DEAL_TYPE             = l_def_gts_rec.deal_type
        ,PRICING_ENGINE        = l_def_gts_rec.pricing_engine
        ,ORG_ID                = l_def_gts_rec.org_id
        ,CREATED_BY            = l_def_gts_rec.created_by
        ,CREATION_DATE         = l_def_gts_rec.creation_date
        ,LAST_UPDATED_BY       = l_def_gts_rec.last_updated_by
        ,LAST_UPDATE_DATE      = l_def_gts_rec.last_update_date
        ,LAST_UPDATE_LOGIN     = l_def_gts_rec.last_update_login
        ,INTEREST_CALC_METH_CODE = l_def_gts_rec.INTEREST_CALC_METH_CODE
        ,REVENUE_RECOG_METH_CODE = l_def_gts_rec.REVENUE_RECOG_METH_CODE
        ,DAYS_IN_MONTH_CODE  	= l_def_gts_rec.DAYS_IN_MONTH_CODE
        ,DAYS_IN_YR_CODE        = l_def_gts_rec.DAYS_IN_YR_CODE
       ,ISG_ARREARS_PAY_DATES_OPTION        = l_def_gts_rec.ISG_ARREARS_PAY_DATES_OPTION
    WHERE ID = l_def_gts_rec.id;
Line: 1856

  END update_row;
Line: 1858

  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_gtsv_rec                      IN  gtsv_rec_type,
    x_gtsv_rec                      OUT NOCOPY gtsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1868

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

      l_gtsv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1883

      l_gtsv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1884

      l_gtsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1950

      IF (x_gtsv_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_gtsv_rec.last_updated_by := l_gtsv_rec.last_updated_by;
Line: 1954

      IF (x_gtsv_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_gtsv_rec.last_update_date := l_gtsv_rec.last_update_date;
Line: 1958

      IF (x_gtsv_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_gtsv_rec.last_update_login := l_gtsv_rec.last_update_login;
Line: 2040

    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_gts_rec => l_gts_rec,
      x_gts_rec => lx_gts_rec
    );
Line: 2094

  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_gtsv_tbl                     IN  gtsv_tbl_type,
    x_gtsv_tbl                     OUT NOCOPY gtsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2104

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

        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_gtsv_rec                     => p_gtsv_tbl(i),
          x_gtsv_rec                     => x_gtsv_tbl(i));
Line: 2168

  END update_row;
Line: 2177

  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_gts_rec                      IN  gts_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2185

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

    DELETE FROM OKL_ST_GEN_TMPT_SETS
     WHERE ID = l_gts_rec.id;
Line: 2237

  END delete_row;
Line: 2242

  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_gtsv_rec                     IN  gtsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2251

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

    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_gts_rec => l_gts_rec
    );
Line: 2320

  END delete_row;
Line: 2326

  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_gtsv_tbl                     IN  gtsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2335

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

        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_gtsv_rec                     => p_gtsv_tbl(i));
Line: 2399

  END delete_row;