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_SPP_PVT SQL Statements

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

Line: 39


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            NAME,
			VERSION,
            DATE_START,
            DATE_END,
            DESCRIPTION,
            SPS_CODE,
            DYP_CODE,
            ARRAY_YN,
			XML_TAG,
			ATTRIBUTE_CATEGORY,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Sif_Price_Parms
     WHERE okl_sif_price_parms.id = p_id;

Line: 109


              l_spp_rec.LAST_UPDATED_BY,
              l_spp_rec.CREATION_DATE,
              l_spp_rec.LAST_UPDATE_DATE,
              l_spp_rec.LAST_UPDATE_LOGIN;

Line: 132


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            NAME,
			VERSION,
            DATE_START,
            DATE_END,
            DESCRIPTION,
            SPS_CODE,
            DYP_CODE,
            ARRAY_YN,
            XML_TAG,
			ATTRIBUTE_CATEGORY,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_SIF_PRICE_PARMS_V
     WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;

Line: 202


              l_sppv_rec.LAST_UPDATED_BY,
              l_sppv_rec.CREATION_DATE,
              l_sppv_rec.LAST_UPDATE_DATE,
              l_sppv_rec.LAST_UPDATE_LOGIN;

Line: 309


    IF (l_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_sppv_rec.last_updated_by := NULL;

Line: 315


    IF (l_sppv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_sppv_rec.last_update_date := NULL;

Line: 318


    IF (l_sppv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_sppv_rec.last_update_login := NULL;

Line: 994


  SELECT '1'
  FROM okl_sif_price_parms_v
  WHERE name				= p_rec.name
  AND   version				= p_rec.version
  AND   id     <> NVL(p_rec.id,-9999);

Line: 1112


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1114


    p_to.last_update_date := p_from.last_update_date;

Line: 1115


    p_to.last_update_login := p_from.last_update_login;

Line: 1151


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1153


    p_to.last_update_date := p_from.last_update_date;

Line: 1154


    p_to.last_update_login := p_from.last_update_login;

Line: 1319


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spp_rec                      IN spp_rec_type,
    x_spp_rec                      OUT NOCOPY spp_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 1327


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

Line: 1363


    INSERT INTO OKL_SIF_PRICE_PARMS(
        id,
        object_version_number,
        name,
		version,
        date_start,
        date_end,
        description,
        sps_code,
        dyp_code,
        array_yn,
        xml_tag,
		attribute_category,
  		attribute1,
  		attribute2,
  		attribute3,
  		attribute4,
  		attribute5,
  		attribute6,
  		attribute7,
  		attribute8,
  		attribute9,
  		attribute10,
  		attribute11,
  		attribute12,
  		attribute13,
  		attribute14,
  		attribute15,
        created_by,
        last_updated_by,
        creation_date,
        last_update_date,
        last_update_login)
      VALUES (
        l_spp_rec.id,
        l_spp_rec.object_version_number,
        l_spp_rec.name,
        l_spp_rec.version,
        l_spp_rec.date_start,
        l_spp_rec.date_end,
        l_spp_rec.description,
        l_spp_rec.sps_code,
        l_spp_rec.dyp_code,
        l_spp_rec.array_yn,
        l_spp_rec.xml_tag,
        l_spp_rec.attribute_category,
        l_spp_rec.attribute1,
        l_spp_rec.attribute2,
        l_spp_rec.attribute3,
        l_spp_rec.attribute4,
        l_spp_rec.attribute5,
        l_spp_rec.attribute6,
        l_spp_rec.attribute7,
        l_spp_rec.attribute8,
        l_spp_rec.attribute9,
        l_spp_rec.attribute10,
        l_spp_rec.attribute11,
        l_spp_rec.attribute12,
        l_spp_rec.attribute13,
        l_spp_rec.attribute14,
        l_spp_rec.attribute15,
        l_spp_rec.created_by,
        l_spp_rec.last_updated_by,
        l_spp_rec.creation_date,
        l_spp_rec.last_update_date,
        l_spp_rec.last_update_login);

Line: 1463


  END insert_row;

Line: 1467


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sppv_rec                     IN sppv_rec_type,
    x_sppv_rec                     OUT NOCOPY sppv_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 1476


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

Line: 1492


      l_sppv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1493


      l_sppv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1494


      l_sppv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1558


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_spp_rec,
      lx_spp_rec
    );

Line: 1606


  END insert_row;

Line: 1610


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sppv_tbl                     IN sppv_tbl_type,
    x_sppv_tbl                     OUT NOCOPY sppv_tbl_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 1619


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

Line: 1632


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sppv_rec                     => p_sppv_tbl(i),
          x_sppv_rec                     => x_sppv_tbl(i));

Line: 1687


  END insert_row;

Line: 1703


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_PRICE_PARMS
     WHERE ID = p_spp_rec.id
       AND OBJECT_VERSION_NUMBER = p_spp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1709


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_PRICE_PARMS
    WHERE ID = p_spp_rec.id;

Line: 1749


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1758


      OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 1958


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spp_rec                      IN spp_rec_type,
    x_spp_rec                      OUT NOCOPY spp_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 1966


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

Line: 2100


      IF (x_spp_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_spp_rec.last_updated_by := l_spp_rec.last_updated_by;

Line: 2108


      IF (x_spp_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_spp_rec.last_update_date := l_spp_rec.last_update_date;

Line: 2112


      IF (x_spp_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_spp_rec.last_update_login := l_spp_rec.last_update_login;

Line: 2156


    UPDATE  OKL_SIF_PRICE_PARMS
    SET OBJECT_VERSION_NUMBER = l_def_spp_rec.object_version_number,
        NAME = l_def_spp_rec.name,
        version = l_def_spp_rec.version,
        DATE_START = l_def_spp_rec.date_start,
        DATE_END = l_def_spp_rec.date_end,
        DESCRIPTION = l_def_spp_rec.description,
        SPS_CODE = l_def_spp_rec.sps_code,
        DYP_CODE = l_def_spp_rec.dyp_code,
        ARRAY_YN = l_def_spp_rec.array_yn,
        XML_TAG = l_def_spp_rec.xml_tag,
		ATTRIBUTE_CATEGORY = l_def_spp_rec.attribute_category,
		ATTRIBUTE1 = l_def_spp_rec.attribute1,
		ATTRIBUTE2 = l_def_spp_rec.attribute2,
		ATTRIBUTE3 = l_def_spp_rec.attribute3,
		ATTRIBUTE4 = l_def_spp_rec.attribute4,
		ATTRIBUTE5 = l_def_spp_rec.attribute5,
		ATTRIBUTE6 = l_def_spp_rec.attribute6,
		ATTRIBUTE7 = l_def_spp_rec.attribute7,
		ATTRIBUTE8 = l_def_spp_rec.attribute8,
		ATTRIBUTE9 = l_def_spp_rec.attribute9,
		ATTRIBUTE10 = l_def_spp_rec.attribute10,
		ATTRIBUTE11 = l_def_spp_rec.attribute11,
		ATTRIBUTE12 = l_def_spp_rec.attribute12,
		ATTRIBUTE13 = l_def_spp_rec.attribute13,
		ATTRIBUTE14 = l_def_spp_rec.attribute14,
		ATTRIBUTE15 = l_def_spp_rec.attribute15,
        CREATED_BY = l_def_spp_rec.created_by,
        LAST_UPDATED_BY = l_def_spp_rec.last_updated_by,
        CREATION_DATE = l_def_spp_rec.creation_date,
        LAST_UPDATE_DATE = l_def_spp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_spp_rec.last_update_login
    WHERE ID = l_def_spp_rec.id;

Line: 2222


  END update_row;

Line: 2226


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sppv_rec                     IN sppv_rec_type,
    x_sppv_rec                     OUT NOCOPY sppv_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 2235


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

Line: 2249


      l_sppv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2250


      l_sppv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2251


      l_sppv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2383


      IF (x_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sppv_rec.last_updated_by := l_sppv_rec.last_updated_by;

Line: 2391


      IF (x_sppv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sppv_rec.last_update_date := l_sppv_rec.last_update_date;

Line: 2395


      IF (x_sppv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sppv_rec.last_update_login := l_sppv_rec.last_update_login;

Line: 2465


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_spp_rec,
      lx_spp_rec
    );

Line: 2512


  END update_row;

Line: 2516


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sppv_tbl                     IN sppv_tbl_type,
    x_sppv_tbl                     OUT NOCOPY sppv_tbl_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 2525


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

Line: 2538


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sppv_rec                     => p_sppv_tbl(i),
          x_sppv_rec                     => x_sppv_tbl(i));

Line: 2593


  END update_row;

Line: 2600


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spp_rec                      IN spp_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 2607


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

Line: 2621


    DELETE FROM OKL_SIF_PRICE_PARMS
     WHERE ID = l_spp_rec.id;

Line: 2655


  END delete_row;

Line: 2659


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sppv_rec                     IN sppv_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 2667


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

Line: 2691


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_spp_rec
    );

Line: 2735


  END delete_row;

Line: 2739


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sppv_tbl                     IN sppv_tbl_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 2747


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

Line: 2760


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sppv_rec                     => p_sppv_tbl(i));

Line: 2814


  END delete_row;