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

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

Line: 43


    SELECT
            ID,
            STREAM_TYPE_NAME,
            INDEX_NUMBER,
            ACTIVITY_TYPE,
            SEQUENCE_NUMBER,
            SRE_DATE,
            AMOUNT,
            SIR_ID,
			STREAM_INTERFACE_ATTRIBUTE01,
			STREAM_INTERFACE_ATTRIBUTE02,
			STREAM_INTERFACE_ATTRIBUTE03,
			STREAM_INTERFACE_ATTRIBUTE04,
			STREAM_INTERFACE_ATTRIBUTE05,
			STREAM_INTERFACE_ATTRIBUTE06,
			STREAM_INTERFACE_ATTRIBUTE07,
			STREAM_INTERFACE_ATTRIBUTE08,
			STREAM_INTERFACE_ATTRIBUTE09,
			STREAM_INTERFACE_ATTRIBUTE10,
			STREAM_INTERFACE_ATTRIBUTE11,
			STREAM_INTERFACE_ATTRIBUTE12,
			STREAM_INTERFACE_ATTRIBUTE13,
			STREAM_INTERFACE_ATTRIBUTE14,
   			STREAM_INTERFACE_ATTRIBUTE15,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Sif_Ret_Strms
     WHERE okl_sif_ret_strms.id = p_id;

Line: 107


              l_srs_rec.LAST_UPDATED_BY,
              l_srs_rec.CREATION_DATE,
              l_srs_rec.LAST_UPDATE_DATE,
              l_srs_rec.LAST_UPDATE_LOGIN;

Line: 131


    SELECT
            ID,
            STREAM_TYPE_NAME,
            INDEX_NUMBER,
            ACTIVITY_TYPE,
            SEQUENCE_NUMBER,
            SRE_DATE,
            AMOUNT,
            SIR_ID,
			STREAM_INTERFACE_ATTRIBUTE01,
			STREAM_INTERFACE_ATTRIBUTE02,
			STREAM_INTERFACE_ATTRIBUTE03,
			STREAM_INTERFACE_ATTRIBUTE04,
			STREAM_INTERFACE_ATTRIBUTE05,
			STREAM_INTERFACE_ATTRIBUTE06,
			STREAM_INTERFACE_ATTRIBUTE07,
			STREAM_INTERFACE_ATTRIBUTE08,
			STREAM_INTERFACE_ATTRIBUTE09,
			STREAM_INTERFACE_ATTRIBUTE10,
			STREAM_INTERFACE_ATTRIBUTE11,
			STREAM_INTERFACE_ATTRIBUTE12,
			STREAM_INTERFACE_ATTRIBUTE13,
			STREAM_INTERFACE_ATTRIBUTE14,
   			STREAM_INTERFACE_ATTRIBUTE15,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Sif_Ret_Strms_V
     WHERE okl_sif_ret_strms_v.id = p_id;

Line: 195


              l_srsv_rec.LAST_UPDATED_BY,
              l_srsv_rec.CREATION_DATE,
              l_srsv_rec.LAST_UPDATE_DATE,
              l_srsv_rec.LAST_UPDATE_LOGIN;

Line: 293


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

Line: 299


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

Line: 302


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

Line: 667


  SELECT '1'
    FROM OKL_SIF_RETS_V
   WHERE OKL_SIF_RETS_V.id = p_id;

Line: 892


    p_to.last_updated_by := p_from.last_updated_by;

Line: 894


    p_to.last_update_date := p_from.last_update_date;

Line: 895


    p_to.last_update_login := p_from.last_update_login;

Line: 930


    p_to.last_updated_by := p_from.last_updated_by;

Line: 932


    p_to.last_update_date := p_from.last_update_date;

Line: 933


    p_to.last_update_login := p_from.last_update_login;

Line: 1102


  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_srs_rec                      IN srs_rec_type,
    x_srs_rec                      OUT NOCOPY srs_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1111


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

Line: 1148


    INSERT INTO OKL_SIF_RET_STRMS(
        id,
        stream_type_name,
        index_number,
        activity_type,
        sequence_number,
		stream_interface_attribute01,
		stream_interface_attribute02,
		stream_interface_attribute03,
		stream_interface_attribute04,
		stream_interface_attribute05,
		stream_interface_attribute06,
		stream_interface_attribute07,
		stream_interface_attribute08,
		stream_interface_attribute09,
		stream_interface_attribute10,
		stream_interface_attribute11,
		stream_interface_attribute12,
		stream_interface_attribute13,
		stream_interface_attribute14,
     	stream_interface_attribute15,
        sre_date,
        amount,
        sir_id,
        object_version_number,
        created_by,
        last_updated_by,
        creation_date,
        last_update_date,
        last_update_login)
      VALUES (
        l_srs_rec.id,
        l_srs_rec.stream_type_name,
        l_srs_rec.index_number,
        l_srs_rec.activity_type,
        l_srs_rec.sequence_number,
		l_srs_rec.stream_interface_attribute01,
		l_srs_rec.stream_interface_attribute02,
		l_srs_rec.stream_interface_attribute03,
		l_srs_rec.stream_interface_attribute04,
		l_srs_rec.stream_interface_attribute05,
		l_srs_rec.stream_interface_attribute06,
		l_srs_rec.stream_interface_attribute07,
		l_srs_rec.stream_interface_attribute08,
		l_srs_rec.stream_interface_attribute09,
		l_srs_rec.stream_interface_attribute10,
		l_srs_rec.stream_interface_attribute11,
		l_srs_rec.stream_interface_attribute12,
		l_srs_rec.stream_interface_attribute13,
		l_srs_rec.stream_interface_attribute14,
		l_srs_rec.stream_interface_attribute15,
        l_srs_rec.sre_date,
        l_srs_rec.amount,
        l_srs_rec.sir_id,
        l_srs_rec.object_version_number,
        l_srs_rec.created_by,
        l_srs_rec.last_updated_by,
        l_srs_rec.creation_date,
        l_srs_rec.last_update_date,
        l_srs_rec.last_update_login);

Line: 1242


  END insert_row;

Line: 1250


  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_srsv_rec                     IN srsv_rec_type,
    x_srsv_rec                     OUT NOCOPY srsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1260


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

Line: 1277


      l_srsv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1278


      l_srsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1279


      l_srsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1343


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_srs_rec,
      lx_srs_rec
    );

Line: 1393


  END insert_row;

Line: 1399


  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_srsv_tbl                     IN srsv_tbl_type,
    x_srsv_tbl                     OUT NOCOPY srsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1409


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

Line: 1422


        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_srsv_rec                     => p_srsv_tbl(i),
          x_srsv_rec                     => x_srsv_tbl(i));

Line: 1477


  END insert_row;

Line: 1495


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_STRMS
     WHERE ID = p_srs_rec.id
       AND OBJECT_VERSION_NUMBER = p_srs_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1502


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_STRMS
    WHERE ID = p_srs_rec.id;

Line: 1543


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1552


      OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 1755


  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_srs_rec                      IN srs_rec_type,
    x_srs_rec                      OUT NOCOPY srs_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1764


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

Line: 1886


      IF (x_srs_rec.last_updated_by IS NULL)
      THEN
        x_srs_rec.last_updated_by := l_srs_rec.last_updated_by;

Line: 1894


      IF (x_srs_rec.last_update_date IS NULL)
      THEN
        x_srs_rec.last_update_date := l_srs_rec.last_update_date;

Line: 1898


      IF (x_srs_rec.last_update_login IS NULL)
      THEN
        x_srs_rec.last_update_login := l_srs_rec.last_update_login;

Line: 1942


    UPDATE  OKL_SIF_RET_STRMS
    SET STREAM_TYPE_NAME = l_def_srs_rec.stream_type_name,
        INDEX_NUMBER = l_def_srs_rec.index_number,
        ACTIVITY_TYPE = l_def_srs_rec.activity_type,
        SEQUENCE_NUMBER = l_def_srs_rec.sequence_number,
		STREAM_INTERFACE_ATTRIBUTE01 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE01,
		STREAM_INTERFACE_ATTRIBUTE02 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE02,
		STREAM_INTERFACE_ATTRIBUTE03 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE03,
		STREAM_INTERFACE_ATTRIBUTE04 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE04,
		STREAM_INTERFACE_ATTRIBUTE05 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE05,
		STREAM_INTERFACE_ATTRIBUTE06 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE06,
		STREAM_INTERFACE_ATTRIBUTE07 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE07,
		STREAM_INTERFACE_ATTRIBUTE08 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE08,
		STREAM_INTERFACE_ATTRIBUTE09 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE09,
		STREAM_INTERFACE_ATTRIBUTE10 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE10,
		STREAM_INTERFACE_ATTRIBUTE11 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE11,
		STREAM_INTERFACE_ATTRIBUTE12 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE12,
		STREAM_INTERFACE_ATTRIBUTE13 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE13,
		STREAM_INTERFACE_ATTRIBUTE14 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE14,
		STREAM_INTERFACE_ATTRIBUTE15 = l_def_srs_rec.STREAM_INTERFACE_ATTRIBUTE15,
        SRE_DATE = l_def_srs_rec.sre_date,
        AMOUNT = l_def_srs_rec.amount,
        SIR_ID = l_def_srs_rec.sir_id,
        OBJECT_VERSION_NUMBER = l_def_srs_rec.object_version_number,
        CREATED_BY = l_def_srs_rec.created_by,
        LAST_UPDATED_BY = l_def_srs_rec.last_updated_by,
        CREATION_DATE = l_def_srs_rec.creation_date,
        LAST_UPDATE_DATE = l_def_srs_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_srs_rec.last_update_login
    WHERE ID = l_def_srs_rec.id;

Line: 2006


  END update_row;

Line: 2010


  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_srsv_rec                     IN srsv_rec_type,
    x_srsv_rec                     OUT NOCOPY srsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2020


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

Line: 2034


      l_srsv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2035


      l_srsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2036


      l_srsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2156


      IF (x_srsv_rec.last_updated_by IS NULL)
      THEN
        x_srsv_rec.last_updated_by := l_srsv_rec.last_updated_by;

Line: 2164


      IF (x_srsv_rec.last_update_date IS NULL)
      THEN
        x_srsv_rec.last_update_date := l_srsv_rec.last_update_date;

Line: 2168


      IF (x_srsv_rec.last_update_login IS NULL)
      THEN
        x_srsv_rec.last_update_login := l_srsv_rec.last_update_login;

Line: 2243


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_srs_rec,
      lx_srs_rec
    );

Line: 2290


  END update_row;

Line: 2294


  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_srsv_tbl                     IN srsv_tbl_type,
    x_srsv_tbl                     OUT NOCOPY srsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2304


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

Line: 2317


        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_srsv_rec                     => p_srsv_tbl(i),
          x_srsv_rec                     => x_srsv_tbl(i));

Line: 2372


  END update_row;

Line: 2380


  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_srs_rec                      IN srs_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2388


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

Line: 2402


    DELETE FROM OKL_SIF_RET_STRMS
     WHERE ID = l_srs_rec.id;

Line: 2437


  END delete_row;

Line: 2441


  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_srsv_rec                     IN srsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2450


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

Line: 2474


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

Line: 2518


  END delete_row;

Line: 2522


  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_srsv_tbl                     IN srsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2531


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

Line: 2544


        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_srsv_rec                     => p_srsv_tbl(i));

Line: 2598


  END delete_row;

Line: 2614


  PROCEDURE insert_row_per(
    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_srsv_rec                     IN srsv_rec_type,
    x_srsv_rec                     OUT NOCOPY srsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2624


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

Line: 2642


      l_srsv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2643


      l_srsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2644


      l_srsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2722


  END insert_row_per;

Line: 2733


  PROCEDURE insert_row_upg(p_srsv_tbl srsv_Tbl_type) IS
    l_tabsize                         NUMBER := p_srsv_tbl.COUNT;

Line: 2760


    in_last_updated_by                Okl_Streams_Util.NumberTabTyp;

Line: 2762


    in_last_update_date               Okl_Streams_Util.DateTabTyp;

Line: 2763


    in_last_update_login              Okl_Streams_Util.NumberTabTyp;

Line: 2770


    l_last_updated_by                NUMBER;

Line: 2772


    l_last_update_date               DATE;

Line: 2773


    l_last_update_login              NUMBER;

Line: 2782


      l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 2784


      l_last_update_date := SYSDATE;

Line: 2785


      l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 2821


      in_last_updated_by(j) := l_last_updated_by;

Line: 2823


      in_last_update_date(j) := l_last_update_date;

Line: 2824


      in_last_update_login(j) := l_last_update_login;

Line: 2830


      INSERT INTO OKL_SIF_RET_STRMS(
                  id,
                  stream_type_name,
                  index_number,
                  activity_type,
                  sequence_number,
                  stream_interface_attribute01,
                  stream_interface_attribute02,
                  stream_interface_attribute03,
                  stream_interface_attribute04,
                  stream_interface_attribute05,
                  stream_interface_attribute06,
                  stream_interface_attribute07,
                  stream_interface_attribute08,
                  stream_interface_attribute09,
                  stream_interface_attribute10,
                  stream_interface_attribute11,
                  stream_interface_attribute12,
                  stream_interface_attribute13,
                  stream_interface_attribute14,
                  stream_interface_attribute15,
                  sre_date,
                  amount,
                  sir_id,
                  object_version_number,
                  created_by,
                  last_updated_by,
                  creation_date,
                  last_update_date,
                  last_update_login)
      VALUES (in_id(i),
              in_stream_type_name(i),
              in_index_number(i),
              in_activity_type(i),
              in_sequence_number(i),
              in_stream_int_attribute01(i),
              in_stream_int_attribute02(i),
              in_stream_int_attribute03(i),
              in_stream_int_attribute04(i),
              in_stream_int_attribute05(i),
              in_stream_int_attribute06(i),
              in_stream_int_attribute07(i),
              in_stream_int_attribute08(i),
              in_stream_int_attribute09(i),
              in_stream_int_attribute10(i),
              in_stream_int_attribute11(i),
              in_stream_int_attribute12(i),
              in_stream_int_attribute13(i),
              in_stream_int_attribute14(i),
              in_stream_int_attribute15(i),
              in_sre_date(i),
              in_amount(i),
              in_sir_id(i),
              in_object_version_number(i),
              in_created_by(i),
              in_last_updated_by(i),
              in_creation_date(i),
              in_last_update_date(i),
              in_last_update_login(i));

Line: 2890


  END insert_row_upg;