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

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

Line: 43


    SELECT
            ID,
            SIR_ID,
            ERROR_CODE,
            ERROR_MESSAGE,
            TAG_NAME,
            TAG_ATTRIBUTE_NAME,
            TAG_ATTRIBUTE_VALUE,
            DESCRIPTION,
			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_Errors
     WHERE okl_sif_ret_errors.id = p_id;

Line: 107


              l_srm_rec.LAST_UPDATED_BY,
              l_srm_rec.CREATION_DATE,
              l_srm_rec.LAST_UPDATE_DATE,
              l_srm_rec.LAST_UPDATE_LOGIN;

Line: 131


    SELECT
            ID,
            SIR_ID,
            ERROR_CODE,
            ERROR_MESSAGE,
            TAG_NAME,
            TAG_ATTRIBUTE_NAME,
            TAG_ATTRIBUTE_VALUE,
            DESCRIPTION,
			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_ERRORS_V
     WHERE OKL_SIF_RET_ERRORS_V.id = p_id;

Line: 195


              l_srmv_rec.LAST_UPDATED_BY,
              l_srmv_rec.CREATION_DATE,
              l_srmv_rec.LAST_UPDATE_DATE,
              l_srmv_rec.LAST_UPDATE_LOGIN;

Line: 295


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

Line: 301


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

Line: 304


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

Line: 412


            SELECT '1'
            FROM OKL_SIF_RETS
            WHERE ID = p_srmv_rec.sir_id;

Line: 659


    p_to.last_updated_by := p_from.last_updated_by;

Line: 661


    p_to.last_update_date := p_from.last_update_date;

Line: 662


    p_to.last_update_login := p_from.last_update_login;

Line: 694


    p_to.last_updated_by := p_from.last_updated_by;

Line: 696


    p_to.last_update_date := p_from.last_update_date;

Line: 697


    p_to.last_update_login := p_from.last_update_login;

Line: 869


  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_srm_rec                      IN srm_rec_type,
    x_srm_rec                      OUT NOCOPY srm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 878


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

Line: 914


    INSERT INTO OKL_SIF_RET_ERRORS(
        id,
        sir_id,
        error_code,
        error_message,
        tag_name,
        tag_attribute_name,
        tag_attribute_value,
        description,
		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)
      VALUES (
        l_srm_rec.id,
        l_srm_rec.sir_id,
        l_srm_rec.error_code,
        l_srm_rec.error_message,
        l_srm_rec.tag_name,
        l_srm_rec.tag_attribute_name,
        l_srm_rec.tag_attribute_value,
        l_srm_rec.description,
		l_srm_rec.stream_interface_attribute01,
		l_srm_rec.stream_interface_attribute02,
		l_srm_rec.stream_interface_attribute03,
		l_srm_rec.stream_interface_attribute04,
		l_srm_rec.stream_interface_attribute05,
		l_srm_rec.stream_interface_attribute06,
		l_srm_rec.stream_interface_attribute07,
		l_srm_rec.stream_interface_attribute08,
		l_srm_rec.stream_interface_attribute09,
		l_srm_rec.stream_interface_attribute10,
		l_srm_rec.stream_interface_attribute11,
		l_srm_rec.stream_interface_attribute12,
		l_srm_rec.stream_interface_attribute13,
		l_srm_rec.stream_interface_attribute14,
		l_srm_rec.stream_interface_attribute15,
        l_srm_rec.object_version_number,
        l_srm_rec.created_by,
        l_srm_rec.last_updated_by,
        l_srm_rec.creation_date,
        l_srm_rec.last_update_date,
        l_srm_rec.last_update_login);

Line: 1008


  END insert_row;

Line: 1012


  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_srmv_rec                     IN srmv_rec_type,
    x_srmv_rec                     OUT NOCOPY srmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1022


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

Line: 1038


      l_srmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1039


      l_srmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1040


      l_srmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1104


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_srm_rec,
      lx_srm_rec
    );

Line: 1152


  END insert_row;

Line: 1156


  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_srmv_tbl                     IN srmv_tbl_type,
    x_srmv_tbl                     OUT NOCOPY srmv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1166


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

Line: 1180


        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_srmv_rec                     => p_srmv_tbl(i),
          x_srmv_rec                     => x_srmv_tbl(i));

Line: 1237


  END insert_row;

Line: 1255


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_ERRORS
     WHERE ID = p_srm_rec.id
       AND OBJECT_VERSION_NUMBER = p_srm_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1262


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_ERRORS
    WHERE ID = p_srm_rec.id;

Line: 1303


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1312


      OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 1518


  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_srm_rec                      IN srm_rec_type,
    x_srm_rec                      OUT NOCOPY srm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1527


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

Line: 1649


      IF (x_srm_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_srm_rec.last_updated_by := l_srm_rec.last_updated_by;

Line: 1657


      IF (x_srm_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_srm_rec.last_update_date := l_srm_rec.last_update_date;

Line: 1661


      IF (x_srm_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_srm_rec.last_update_login := l_srm_rec.last_update_login;

Line: 1705


    UPDATE  OKL_SIF_RET_ERRORS
    SET SIR_ID = l_def_srm_rec.sir_id,
        ERROR_CODE = l_def_srm_rec.error_code,
        ERROR_MESSAGE = l_def_srm_rec.error_message,
        TAG_NAME = l_def_srm_rec.tag_name,
        TAG_ATTRIBUTE_NAME = l_def_srm_rec.tag_attribute_name,
        TAG_ATTRIBUTE_VALUE = l_def_srm_rec.tag_attribute_value,
        DESCRIPTION = l_def_srm_rec.description,
		STREAM_INTERFACE_ATTRIBUTE01 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE01,
		STREAM_INTERFACE_ATTRIBUTE02 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE02,
		STREAM_INTERFACE_ATTRIBUTE03 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE03,
		STREAM_INTERFACE_ATTRIBUTE04 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE04,
		STREAM_INTERFACE_ATTRIBUTE05 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE05,
		STREAM_INTERFACE_ATTRIBUTE06 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE06,
		STREAM_INTERFACE_ATTRIBUTE07 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE07,
		STREAM_INTERFACE_ATTRIBUTE08 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE08,
		STREAM_INTERFACE_ATTRIBUTE09 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE09,
		STREAM_INTERFACE_ATTRIBUTE10 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE10,
		STREAM_INTERFACE_ATTRIBUTE11 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE11,
		STREAM_INTERFACE_ATTRIBUTE12 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE12,
		STREAM_INTERFACE_ATTRIBUTE13 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE13,
		STREAM_INTERFACE_ATTRIBUTE14 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE14,
		STREAM_INTERFACE_ATTRIBUTE15 = l_def_srm_rec.STREAM_INTERFACE_ATTRIBUTE15,
        OBJECT_VERSION_NUMBER = l_def_srm_rec.object_version_number,
        CREATED_BY = l_def_srm_rec.created_by,
        LAST_UPDATED_BY = l_def_srm_rec.last_updated_by,
        CREATION_DATE = l_def_srm_rec.creation_date,
        LAST_UPDATE_DATE = l_def_srm_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_srm_rec.last_update_login
    WHERE ID = l_def_srm_rec.id;

Line: 1769


  END update_row;

Line: 1773


  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_srmv_rec                     IN srmv_rec_type,
    x_srmv_rec                     OUT NOCOPY srmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1783


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

Line: 1797


      l_srmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1798


      l_srmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1799


      l_srmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1919


      IF (x_srmv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_srmv_rec.last_updated_by := l_srmv_rec.last_updated_by;

Line: 1927


      IF (x_srmv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_srmv_rec.last_update_date := l_srmv_rec.last_update_date;

Line: 1931


      IF (x_srmv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_srmv_rec.last_update_login := l_srmv_rec.last_update_login;

Line: 2002


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_srm_rec,
      lx_srm_rec
    );

Line: 2049


  END update_row;

Line: 2053


  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_srmv_tbl                     IN srmv_tbl_type,
    x_srmv_tbl                     OUT NOCOPY srmv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2063


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

Line: 2077


        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_srmv_rec                     => p_srmv_tbl(i),
          x_srmv_rec                     => x_srmv_tbl(i));

Line: 2134


  END update_row;

Line: 2142


  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_srm_rec                      IN srm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2150


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

Line: 2164


    DELETE FROM OKL_SIF_RET_ERRORS
     WHERE ID = l_srm_rec.id;

Line: 2199


  END delete_row;

Line: 2203


  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_srmv_rec                     IN srmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2212


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

Line: 2236


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

Line: 2280


  END delete_row;

Line: 2284


  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_srmv_tbl                     IN srmv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2293


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

Line: 2307


        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_srmv_rec                     => p_srmv_tbl(i));

Line: 2363


  END delete_row;