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_STREAMS_UTIL dependencies on OKL_STREAM_INTERFACES

Line 1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,

1771:
1772: -- Gets the status of the stream generation request for external generator
1773: PROCEDURE get_transaction_status
1774: (
1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,
1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,
1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )

Line 1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,

1772: -- Gets the status of the stream generation request for external generator
1773: PROCEDURE get_transaction_status
1774: (
1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,
1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,
1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS

Line 1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,

1773: PROCEDURE get_transaction_status
1774: (
1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,
1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,
1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS
1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;

Line 1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;

1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS
1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;
1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;
1783:
1784: CURSOR intf_status_csr(trx_number NUMBER)
1785: IS

Line 1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;

1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS
1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;
1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;
1783:
1784: CURSOR intf_status_csr(trx_number NUMBER)
1785: IS
1786: SELECT sis_code, log_file FROM okl_stream_interfaces

Line 1786: SELECT sis_code, log_file FROM okl_stream_interfaces

1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;
1783:
1784: CURSOR intf_status_csr(trx_number NUMBER)
1785: IS
1786: SELECT sis_code, log_file FROM okl_stream_interfaces
1787: WHERE transaction_number = trx_number;
1788:
1789: BEGIN
1790:

Line 2755: p_trx_number IN okl_stream_interfaces.TRANSACTION_NUMBER%TYPE,

2751: -- Version : kthiruva 1.0 Created
2752: -- End of Commnets
2753: --------------------------------------------------------------------------------
2754: PROCEDURE get_line_id(
2755: p_trx_number IN okl_stream_interfaces.TRANSACTION_NUMBER%TYPE,
2756: p_index_number IN okl_sif_ret_levels.INDEX_NUMBER%TYPE,
2757: x_kle_id OUT NOCOPY NUMBER,
2758: x_return_status OUT NOCOPY VARCHAR2)
2759: AS

Line 2767: OKL_STREAM_INTERFACES SIFB,

2763: IS
2764: SELECT SILB.KLE_ID
2765: FROM OKL_SIF_RET_LEVELS SRLB,
2766: OKL_SIF_RETS SIRB,
2767: OKL_STREAM_INTERFACES SIFB,
2768: OKL_SIF_LINES SILB
2769: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2770: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2771: AND SILB.SIF_ID = SIFB.ID