eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPM_PVT SQL Statements

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

Line: 20


    SELECT  ID
            ,OBJECT_VERSION_NUMBER
            ,SIF_ID
            ,khr_id
            ,NAME
            ,DISPLAY_YN
            ,UPDATE_YN
            ,DEFAULT_VALUE
            ,PARAMETER_VALUE
            ,PRC_ENG_IDENT
            ,DESCRIPTION
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
    FROM OKL_SIF_PRICING_PARAMS
    WHERE OKL_SIF_PRICING_PARAMS.id = p_id;

Line: 54


        ,l_spm_rec.update_yn
        ,l_spm_rec.default_value
        ,l_spm_rec.parameter_value
        ,l_spm_rec.prc_eng_ident
        ,l_spm_rec.description
        ,l_spm_rec.created_by
        ,l_spm_rec.creation_date
        ,l_spm_rec.last_updated_by
        ,l_spm_rec.last_update_date
        ,l_spm_rec.last_update_login;

Line: 87


    SELECT   ID
            ,OBJECT_VERSION_NUMBER
            ,SIF_ID
            ,KHR_ID
            ,NAME
            ,DISPLAY_YN
            ,UPDATE_YN

            ,DEFAULT_VALUE
            ,PARAMETER_VALUE
            ,PRC_ENG_IDENT
            ,DESCRIPTION
            ,CREATED_BY
            ,CREATION_DATE
            ,LAST_UPDATED_BY
            ,LAST_UPDATE_DATE
            ,LAST_UPDATE_LOGIN
    FROM  OKL_SIF_PRICING_PARAMS_V
    WHERE OKL_SIF_PRICING_PARAMS_V.ID = p_id;

Line: 120


        ,l_spmv_rec.update_yn
        ,l_spmv_rec.default_value
        ,l_spmv_rec.parameter_value
        ,l_spmv_rec.prc_eng_ident
        ,l_spmv_rec.description
        ,l_spmv_rec.created_by
        ,l_spmv_rec.creation_date
        ,l_spmv_rec.last_updated_by
        ,l_spmv_rec.last_update_date
        ,l_spmv_rec.last_update_login;

Line: 427


    IF (l_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
        l_spmv_rec.update_yn := NULL;

Line: 448


    IF (l_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
        l_spmv_rec.last_updated_by := NULL;

Line: 451


    IF (l_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
        l_spmv_rec.last_update_date := NULL;

Line: 454


    IF (l_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
        l_spmv_rec.last_update_login := NULL;

Line: 476


    p_to.update_yn := p_from.update_yn;

Line: 483


    p_to.last_updated_by := p_from.last_updated_by;

Line: 484


    p_to.last_update_date := p_from.last_update_date;

Line: 485


    p_to.last_update_login := p_from.last_update_login;

Line: 502


    p_to.update_yn := p_from.update_yn;

Line: 509


    p_to.last_updated_by := p_from.last_updated_by;

Line: 510


    p_to.last_update_date := p_from.last_update_date;

Line: 511


    p_to.last_update_login := p_from.last_update_login;

Line: 527


  PROCEDURE insert_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_spm_rec                      IN spm_rec_type) AS

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

Line: 536


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

Line: 579


    INSERT INTO OKL_SIF_PRICING_PARAMS(
        ID
        ,OBJECT_VERSION_NUMBER
        ,SIF_ID
        ,KHR_ID
        ,NAME
        ,DISPLAY_YN
        ,UPDATE_YN
        ,DEFAULT_VALUE
        ,PARAMETER_VALUE
        ,PRC_ENG_IDENT
        ,DESCRIPTION
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        )
    VALUES (
         l_spm_rec.id
        ,l_spm_rec.object_version_number
        ,l_spm_rec.sif_id
        ,l_spm_rec.khr_id
        ,l_spm_rec.name
        ,l_spm_rec.display_yn
        ,l_spm_rec.update_yn
        ,l_spm_rec.default_value
        ,l_spm_rec.parameter_value
        ,l_spm_rec.prc_eng_ident
        ,l_spm_rec.description
        ,l_spm_rec.created_by
        ,l_spm_rec.creation_date
        ,l_spm_rec.last_updated_by
        ,l_spm_rec.last_update_date
        ,l_spm_rec.last_update_login
    );

Line: 651


  END insert_row;

Line: 656


  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_spmv_rec                     IN  spmv_rec_type) AS


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

Line: 667


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

Line: 683


      l_spmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 684


      l_spmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 685


      l_spmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 766


    insert_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_spm_rec => l_spm_rec
    );

Line: 816


  END; -- insert_row

Line: 821


  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_spmv_tbl                     IN  spmv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 830


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

Line: 842


        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_spmv_rec                     => p_spmv_tbl(i));

Line: 895


  END insert_row;

Line: 910


  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_spm_rec                      IN  spm_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 918


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

Line: 964


      IF (x_spm_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
        x_spm_rec.update_yn := l_spm_rec.update_yn;

Line: 988


      IF (x_spm_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_spm_rec.last_updated_by := l_spm_rec.last_updated_by;

Line: 992


      IF (x_spm_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_spm_rec.last_update_date := l_spm_rec.last_update_date;

Line: 996


      IF (x_spm_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_spm_rec.last_update_login := l_spm_rec.last_update_login;

Line: 1046


    UPDATE OKL_SIF_PRICING_PARAMS
    SET ID                      = l_def_spm_rec.id
        ,OBJECT_VERSION_NUMBER  = l_def_spm_rec.object_version_number
        ,SIF_ID                 = l_def_spm_rec.sif_id
        ,KHR_ID                 = l_def_spm_rec.khr_id
        ,NAME                   = l_def_spm_rec.name
        ,DISPLAY_YN             = l_def_spm_rec.display_yn
        ,UPDATE_YN              = l_def_spm_rec.update_yn
        ,DEFAULT_VALUE          = l_def_spm_rec.default_value
        ,PARAMETER_VALUE        = l_def_spm_rec.parameter_value
        ,PRC_ENG_IDENT          = l_def_spm_rec.prc_eng_ident
        ,DESCRIPTION            = l_def_spm_rec.description
        ,CREATED_BY             = l_def_spm_rec.created_by
        ,CREATION_DATE          = l_def_spm_rec.creation_date
        ,LAST_UPDATED_BY        = l_def_spm_rec.last_updated_by
        ,LAST_UPDATE_DATE       = l_def_spm_rec.last_update_date
        ,LAST_UPDATE_LOGIN      = l_def_spm_rec.last_update_login
    WHERE ID = l_def_spm_rec.id;

Line: 1098


  END update_row;

Line: 1103


  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_spmv_rec                     IN  spmv_rec_type)  IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1112


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

Line: 1126


      l_spmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1127


      l_spmv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1128


      l_spmv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1172


            IF (x_spmv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

        x_spmv_rec.update_yn := l_spmv_rec.update_yn;

Line: 1196


      IF (x_spmv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_spmv_rec.last_updated_by := l_spmv_rec.last_updated_by;

Line: 1200


      IF (x_spmv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_spmv_rec.last_update_date := l_spmv_rec.last_update_date;

Line: 1204


      IF (x_spmv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_spmv_rec.last_update_login := l_spmv_rec.last_update_login;

Line: 1279


    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_spm_rec => l_spm_rec
    );

Line: 1331


  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_spmv_tbl                     IN  spmv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1340


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

Line: 1351


        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_spmv_rec                     => p_spmv_tbl(i));

Line: 1404


  END update_row;