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

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

Line: 43


    SELECT
            ID,
            STY_ID,
            CAH_ID,
            OBJECT_VERSION_NUMBER,
            ADD_YN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Srch_Strm_Typs
     WHERE okl_srch_strm_typs.id = p_id;

Line: 102


              l_sst_rec.LAST_UPDATED_BY,
              l_sst_rec.LAST_UPDATE_DATE,
              l_sst_rec.LAST_UPDATE_LOGIN;

Line: 125


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            STY_ID,
            CAH_ID,
            ADD_YN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Srch_Strm_Typs_V
     WHERE okl_srch_strm_typs_v.id = p_id;

Line: 184


              l_sstv_rec.LAST_UPDATED_BY,
              l_sstv_rec.LAST_UPDATE_DATE,
              l_sstv_rec.LAST_UPDATE_LOGIN;

Line: 274


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

Line: 277


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

Line: 280


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

Line: 302


   SELECT '1'
   FROM   okl_csh_allct_srchs
   WHERE  id = p_sstv_rec.cah_id;

Line: 372


   SELECT '1'
   FROM   okl_strm_type_b
   WHERE  id = p_sstv_rec.sty_id;

Line: 398


		 SELECT 'x'
		 FROM okl_srch_strm_typs
		 WHERE sty_id = p_sstv_rec.sty_id
		 AND   cah_id = p_sstv_rec.cah_id
		 AND   id <> NVL(p_sstv_rec.id,-99999);

Line: 417


					    p_msg_name		=> 'YOU HAVE SELECTED DUPLICATE BILLING TYPES',
					    p_token1		=> 'VALUE1',
					    p_token1_value	=> p_sstv_rec.sty_id,
					    p_token2		=> 'VALUE2',
					    p_token2_value	=> NVL(p_sstv_rec.cah_id,' '));

Line: 551


    p_to.last_updated_by := p_from.last_updated_by;

Line: 552


    p_to.last_update_date := p_from.last_update_date;

Line: 553


    p_to.last_update_login := p_from.last_update_login;

Line: 583


    p_to.last_updated_by := p_from.last_updated_by;

Line: 584


    p_to.last_update_date := p_from.last_update_date;

Line: 585


    p_to.last_update_login := p_from.last_update_login;

Line: 616


    p_to.last_updated_by := p_from.last_updated_by;

Line: 617


    p_to.last_update_date := p_from.last_update_date;

Line: 618


    p_to.last_update_login := p_from.last_update_login;

Line: 792


  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_okl_srch_strm_typs_h_rec     IN okl_srch_strm_typs_h_rec_type,
    x_okl_srch_strm_typs_h_rec     OUT NOCOPY okl_srch_strm_typs_h_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 801


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

Line: 837


    INSERT INTO OKL_SRCH_STRM_TYPS_H(
        id,
        major_version,
        sty_id,
        cah_id,
        object_version_number,
        add_yn,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okl_srch_strm_typs_h_rec.id,
        l_okl_srch_strm_typs_h_rec.major_version,
        l_okl_srch_strm_typs_h_rec.sty_id,
        l_okl_srch_strm_typs_h_rec.cah_id,
        l_okl_srch_strm_typs_h_rec.object_version_number,
        l_okl_srch_strm_typs_h_rec.add_yn,
        l_okl_srch_strm_typs_h_rec.attribute_category,
        l_okl_srch_strm_typs_h_rec.attribute1,
        l_okl_srch_strm_typs_h_rec.attribute2,
        l_okl_srch_strm_typs_h_rec.attribute3,
        l_okl_srch_strm_typs_h_rec.attribute4,
        l_okl_srch_strm_typs_h_rec.attribute5,
        l_okl_srch_strm_typs_h_rec.attribute6,
        l_okl_srch_strm_typs_h_rec.attribute7,
        l_okl_srch_strm_typs_h_rec.attribute8,
        l_okl_srch_strm_typs_h_rec.attribute9,
        l_okl_srch_strm_typs_h_rec.attribute10,
        l_okl_srch_strm_typs_h_rec.attribute11,
        l_okl_srch_strm_typs_h_rec.attribute12,
        l_okl_srch_strm_typs_h_rec.attribute13,
        l_okl_srch_strm_typs_h_rec.attribute14,
        l_okl_srch_strm_typs_h_rec.attribute15,
        l_okl_srch_strm_typs_h_rec.created_by,
        l_okl_srch_strm_typs_h_rec.creation_date,
        l_okl_srch_strm_typs_h_rec.last_updated_by,
        l_okl_srch_strm_typs_h_rec.last_update_date,
        l_okl_srch_strm_typs_h_rec.last_update_login);

Line: 927


  END insert_row;

Line: 933


  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_sst_rec                      IN sst_rec_type,
    x_sst_rec                      OUT NOCOPY sst_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 942


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

Line: 978


    INSERT INTO OKL_SRCH_STRM_TYPS(
        id,
        sty_id,
        cah_id,
        object_version_number,
        add_yn,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_sst_rec.id,
        l_sst_rec.sty_id,
        l_sst_rec.cah_id,
        l_sst_rec.object_version_number,
        l_sst_rec.add_yn,
        l_sst_rec.attribute_category,
        l_sst_rec.attribute1,
        l_sst_rec.attribute2,
        l_sst_rec.attribute3,
        l_sst_rec.attribute4,
        l_sst_rec.attribute5,
        l_sst_rec.attribute6,
        l_sst_rec.attribute7,
        l_sst_rec.attribute8,
        l_sst_rec.attribute9,
        l_sst_rec.attribute10,
        l_sst_rec.attribute11,
        l_sst_rec.attribute12,
        l_sst_rec.attribute13,
        l_sst_rec.attribute14,
        l_sst_rec.attribute15,
        l_sst_rec.created_by,
        l_sst_rec.creation_date,
        l_sst_rec.last_updated_by,
        l_sst_rec.last_update_date,
        l_sst_rec.last_update_login);

Line: 1078


  END insert_row;

Line: 1082


  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_sstv_rec                     IN sstv_rec_type,
    x_sstv_rec                     OUT NOCOPY sstv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1092


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

Line: 1108


      l_sstv_rec.LAST_UPDATE_DATE := l_sstv_rec.CREATION_DATE;

Line: 1109


      l_sstv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1110


      l_sstv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1174


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sst_rec,
      lx_sst_rec
    );

Line: 1234


  END insert_row;

Line: 1238


  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_sstv_tbl                     IN sstv_tbl_type,
    x_sstv_tbl                     OUT NOCOPY sstv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1248


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

Line: 1262


        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_sstv_rec                     => p_sstv_tbl(i),
          x_sstv_rec                     => x_sstv_tbl(i));

Line: 1321


  END insert_row;

Line: 1339


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SRCH_STRM_TYPS
     WHERE ID = p_sst_rec.id
       AND OBJECT_VERSION_NUMBER = p_sst_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1346


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SRCH_STRM_TYPS
    WHERE ID = p_sst_rec.id;

Line: 1387


      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1396


      Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1604


  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_sst_rec                      IN sst_rec_type,
    x_sst_rec                      OUT NOCOPY sst_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1613


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

Line: 1734


      IF (x_sst_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_sst_rec.last_updated_by := l_sst_rec.last_updated_by;

Line: 1738


      IF (x_sst_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_sst_rec.last_update_date := l_sst_rec.last_update_date;

Line: 1742


      IF (x_sst_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_sst_rec.last_update_login := l_sst_rec.last_update_login;

Line: 1786


    UPDATE  OKL_SRCH_STRM_TYPS
    SET STY_ID = l_def_sst_rec.sty_id,
        CAH_ID = l_def_sst_rec.cah_id,
        OBJECT_VERSION_NUMBER = l_def_sst_rec.object_version_number,
        ADD_YN = l_def_sst_rec.add_yn,
        ATTRIBUTE_CATEGORY = l_def_sst_rec.attribute_category,
        ATTRIBUTE1 = l_def_sst_rec.attribute1,
        ATTRIBUTE2 = l_def_sst_rec.attribute2,
        ATTRIBUTE3 = l_def_sst_rec.attribute3,
        ATTRIBUTE4 = l_def_sst_rec.attribute4,
        ATTRIBUTE5 = l_def_sst_rec.attribute5,
        ATTRIBUTE6 = l_def_sst_rec.attribute6,
        ATTRIBUTE7 = l_def_sst_rec.attribute7,
        ATTRIBUTE8 = l_def_sst_rec.attribute8,
        ATTRIBUTE9 = l_def_sst_rec.attribute9,
        ATTRIBUTE10 = l_def_sst_rec.attribute10,
        ATTRIBUTE11 = l_def_sst_rec.attribute11,
        ATTRIBUTE12 = l_def_sst_rec.attribute12,
        ATTRIBUTE13 = l_def_sst_rec.attribute13,
        ATTRIBUTE14 = l_def_sst_rec.attribute14,
        ATTRIBUTE15 = l_def_sst_rec.attribute15,
        CREATED_BY = l_def_sst_rec.created_by,
        CREATION_DATE = l_def_sst_rec.creation_date,
        LAST_UPDATED_BY = l_def_sst_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sst_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sst_rec.last_update_login
    WHERE ID = l_def_sst_rec.id;

Line: 1816


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_srch_strm_typs_h_rec,
      lx_okl_srch_strm_typs_h_rec
    );

Line: 1863


  END update_row;

Line: 1867


  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_sstv_rec                     IN sstv_rec_type,
    x_sstv_rec                     OUT NOCOPY sstv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1877


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

Line: 1891


      l_sstv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1892


      l_sstv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1893


      l_sstv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 2005


      IF (x_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_sstv_rec.last_updated_by := l_sstv_rec.last_updated_by;

Line: 2009


      IF (x_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_sstv_rec.last_update_date := l_sstv_rec.last_update_date;

Line: 2013


      IF (x_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_sstv_rec.last_update_login := l_sstv_rec.last_update_login;

Line: 2084


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sst_rec,
      lx_sst_rec
    );

Line: 2131


  END update_row;

Line: 2135


  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_sstv_tbl                     IN sstv_tbl_type,
    x_sstv_tbl                     OUT NOCOPY sstv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2145


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

Line: 2158


        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_sstv_rec                     => p_sstv_tbl(i),
          x_sstv_rec                     => x_sstv_tbl(i));

Line: 2217


  END update_row;

Line: 2225


  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_sst_rec                      IN sst_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2233


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

Line: 2259


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_srch_strm_typs_h_rec,
      lx_okl_srch_strm_typs_h_rec
    );

Line: 2273


    DELETE FROM OKL_SRCH_STRM_TYPS
     WHERE ID = l_sst_rec.id;

Line: 2308


  END delete_row;

Line: 2312


  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_sstv_rec                     IN sstv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2321


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

Line: 2345


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

Line: 2389


  END delete_row;

Line: 2393


  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_sstv_tbl                     IN sstv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2402


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

Line: 2416


        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_sstv_rec                     => p_sstv_tbl(i));

Line: 2474


  END delete_row;