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

Line 617: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

613: j NUMBER := 0;
614: p_line_number NUMBER := 1;
615: p_first_line_number NUMBER := 1;
616: l_yield_data_flag NUMBER := 0;
617: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
618: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
619: l_sirv_rec sirv_rec_type;
620: p_sirv_rec sirv_rec_type;
621: l_no_data_found BOOLEAN := FALSE;

Line 618: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

614: p_line_number NUMBER := 1;
615: p_first_line_number NUMBER := 1;
616: l_yield_data_flag NUMBER := 0;
617: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
618: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
619: l_sirv_rec sirv_rec_type;
620: p_sirv_rec sirv_rec_type;
621: l_no_data_found BOOLEAN := FALSE;
622: l_exception_data_found BOOLEAN := FALSE;

Line 650: OKL_STREAM_INTERFACES HEADER

646: FROM
647: OKL_SIF_RET_STRMS RETURN_STREAMS,
648: OKL_SIF_RETS RETURN_HEADER,
649: OKL_STRM_TYPE_B STREAM_TYPE,
650: OKL_STREAM_INTERFACES HEADER
651: WHERE
652: RETURN_HEADER.id = RETURN_STREAMS.sir_id
653: AND RETURN_HEADER.transaction_number =p_trx_number
654: AND RETURN_STREAMS.stream_type_name = STREAM_TYPE.CODE

Line 677: OKL_STREAM_INTERFACES HEADER,

673: FROM
674: OKL_STRM_TYPE_B STREAM_TYPE,
675: OKL_SIF_RET_STRMS RETURN_STREAMS,
676: OKL_SIF_RETS RETURN_HEADER,
677: OKL_STREAM_INTERFACES HEADER,
678: -- OKL_SIF_LINES LINES,
679: OKL_SIF_FEES FEES
680: WHERE
681: RETURN_HEADER.transaction_number = p_trx_number

Line 731: OKL_STREAM_INTERFACES HEADER,

727: FROM
728: OKL_STRM_TYPE_B STREAM_TYPE,
729: OKL_SIF_RET_STRMS RETURN_STREAMS,
730: OKL_SIF_RETS RETURN_HEADER,
731: OKL_STREAM_INTERFACES HEADER,
732: OKL_SIF_LINES LINES,
733: OKL_SIF_FEES FEES
734: WHERE
735: RETURN_HEADER.transaction_number = p_trx_number

Line 777: OKL_STREAM_INTERFACES HEADER,

773: FROM
774: OKL_STRM_TYPE_B STREAM_TYPE,
775: OKL_SIF_RET_STRMS RETURN_STREAMS,
776: OKL_SIF_RETS RETURN_HEADER,
777: OKL_STREAM_INTERFACES HEADER,
778: OKL_SIF_LINES LINES
779: WHERE
780: RETURN_HEADER.transaction_number = p_trx_number
781: AND

Line 822: OKL_STREAM_INTERFACES HEADER,

818: FROM
819: OKL_STRM_TYPE_B STREAM_TYPE,
820: OKL_SIF_RET_STRMS RETURN_STREAMS,
821: OKL_SIF_RETS RETURN_HEADER,
822: OKL_STREAM_INTERFACES HEADER,
823: OKL_SIF_LINES LINES,
824: OKL_SIF_FEES FEES
825: WHERE
826: RETURN_HEADER.transaction_number = p_trx_number

Line 872: OKL_STREAM_INTERFACES HEADER,

868: FROM
869: OKL_STRM_TYPE_B STREAM_TYPE,
870: OKL_SIF_RET_STRMS RETURN_STREAMS,
871: OKL_SIF_RETS RETURN_HEADER,
872: OKL_STREAM_INTERFACES HEADER,
873: OKL_SIF_LINES LINES,
874: OKL_SIF_FEES FEES
875: WHERE
876: RETURN_HEADER.transaction_number = p_trx_number

Line 938: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table

934: WHERE
935: SIRB.TRANSACTION_NUMBER = p_trx_number
936: AND
937: SIRB.ID = SRMB.SIR_ID;
938: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
939: CURSOR sif_data_csr (p_transaction_number IN NUMBER) IS
940: SELECT
941:
942: ID,

Line 946: FROM Okl_Stream_Interfaces

942: ID,
943: ORP_CODE,
944: LOG_FILE,
945: SECURITY_DEPOSIT_AMOUNT
946: FROM Okl_Stream_Interfaces
947: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
948: CURSOR sirv_data_csr (p_trnsaction_numner IN NUMBER) IS
949: SELECT
950: ID,

Line 947: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;

943: ORP_CODE,
944: LOG_FILE,
945: SECURITY_DEPOSIT_AMOUNT
946: FROM Okl_Stream_Interfaces
947: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
948: CURSOR sirv_data_csr (p_trnsaction_numner IN NUMBER) IS
949: SELECT
950: ID,
951: TRANSACTION_NUMBER,

Line 991: FROM okl_stream_interfaces

987: WHERE okl_sif_rets.transaction_number = p_trnsaction_numner;
988: -- smahapat 11/10/02 multi-gaap -- addition
989: CURSOR reporting_streams_csr(p_trx_number NUMBER) IS
990: SELECT purpose_code
991: FROM okl_stream_interfaces
992: WHERE transaction_number = p_trx_number;
993:
994: CURSOR reporting_product_csr(p_trx_number NUMBER) IS
995: SELECT c.reporting_pdt_id

Line 996: FROM okl_k_headers a, okl_stream_interfaces b, okl_products_v c

992: WHERE transaction_number = p_trx_number;
993:
994: CURSOR reporting_product_csr(p_trx_number NUMBER) IS
995: SELECT c.reporting_pdt_id
996: FROM okl_k_headers a, okl_stream_interfaces b, okl_products_v c
997: WHERE b.transaction_number = p_trx_number
998: AND a.id = b.khr_id
999: AND c.id = a.pdt_id;
1000: reporting_product_rec reporting_product_csr%ROWTYPE;

Line 1011: OKL_STREAM_INTERFACES SIFB

1007: SELECT
1008: '1'
1009: FROM
1010: OKL_SIF_FEES SFEB,
1011: OKL_STREAM_INTERFACES SIFB
1012: WHERE
1013: SIFB.ID = SFEB.SIF_ID AND
1014: transaction_number = p_trx_number AND
1015: SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;

Line 1783: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

1779: lp_sifv_rec.log_file := 'OKLSTXMLG_' || p_transaction_number || '.log ';
1780: ELSE
1781: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
1782: END IF;
1783: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1784: IF(IS_DEBUG_PROCEDURE_ON) THEN
1785: BEGIN
1786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1787: END;

Line 1786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

1782: END IF;
1783: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1784: IF(IS_DEBUG_PROCEDURE_ON) THEN
1785: BEGIN
1786: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1787: END;
1788: END IF;
1789: --Added by kthiruva for Debug Logging
1790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');

1787: END;
1788: END IF;
1789: --Added by kthiruva for Debug Logging
1790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1792: END IF;
1793: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1794: p_api_version => p_api_version
1795: ,p_init_msg_list => p_init_msg_list

Line 1793: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(

1789: --Added by kthiruva for Debug Logging
1790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1792: END IF;
1793: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1794: p_api_version => p_api_version
1795: ,p_init_msg_list => p_init_msg_list
1796: ,x_return_status => l_return_status
1797: ,x_msg_count => x_msg_count

Line 1803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces, return status is :'|| x_return_status);

1799: ,p_sifv_rec => lp_sifv_rec
1800: ,x_sifv_rec => lx_sifv_rec);
1801: --Added by kthiruva for Debug Logging
1802: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces, return status is :'|| x_return_status);
1804: END IF;
1805:
1806: IF(IS_DEBUG_PROCEDURE_ON) THEN
1807: BEGIN

Line 1808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

1804: END IF;
1805:
1806: IF(IS_DEBUG_PROCEDURE_ON) THEN
1807: BEGIN
1808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1809: END;
1810: END IF;
1811: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1812: IF l_return_status = G_RET_STS_ERROR THEN

Line 1811: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

1807: BEGIN
1808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1809: END;
1810: END IF;
1811: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1812: IF l_return_status = G_RET_STS_ERROR THEN
1813: RAISE G_EXCEPTION_ERROR;
1814: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1815: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2044: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

2040: lp_init_msg_list VARCHAR2(1) := 'F';
2041: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2042: l_exception_data_found BOOLEAN := FALSE;
2043: lx_msg_count NUMBER;
2044: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2045: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2046: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
2047: SELECT
2048: ID,

Line 2045: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

2041: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2042: l_exception_data_found BOOLEAN := FALSE;
2043: lx_msg_count NUMBER;
2044: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2045: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
2046: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
2047: SELECT
2048: ID,
2049: TRANSACTION_NUMBER,

Line 2092: FROM Okl_Stream_Interfaces

2088: SELECT
2089: ID,
2090: ORP_CODE,
2091: LOG_FILE
2092: FROM Okl_Stream_Interfaces
2093: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
2094: -- define cursor to check any Exceptions in the Inbound Interface Tables
2095: CURSOR exception_data_csr(p_trx_number NUMBER) IS
2096: SELECT

Line 2093: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;

2089: ID,
2090: ORP_CODE,
2091: LOG_FILE
2092: FROM Okl_Stream_Interfaces
2093: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
2094: -- define cursor to check any Exceptions in the Inbound Interface Tables
2095: CURSOR exception_data_csr(p_trx_number NUMBER) IS
2096: SELECT
2097: SRMB.ID

Line 2167: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

2163: lp_sifv_rec.stream_interface_attribute03 := 'OKLSTXMLG_' || p_transaction_number || '.log ';
2164: ELSE
2165: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
2166: END IF;
2167: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2168: IF(IS_DEBUG_PROCEDURE_ON) THEN
2169: BEGIN
2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2171: END;

Line 2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

2166: END IF;
2167: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2168: IF(IS_DEBUG_PROCEDURE_ON) THEN
2169: BEGIN
2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2171: END;
2172: END IF;
2173: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2174: ,p_init_msg_list => lp_init_msg_list

Line 2173: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version

2169: BEGIN
2170: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2171: END;
2172: END IF;
2173: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2174: ,p_init_msg_list => lp_init_msg_list
2175: ,x_return_status => l_return_status
2176: ,x_msg_count => lx_msg_count
2177: ,x_msg_data => lx_msg_data

Line 2183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');

2179: ,x_sifv_rec => lx_sifv_rec);
2180:
2181: IF(IS_DEBUG_PROCEDURE_ON) THEN
2182: BEGIN
2183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2184: END;
2185: END IF;
2186: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2187: IF l_return_status = G_RET_STS_ERROR THEN

Line 2186: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces

2182: BEGIN
2183: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2184: END;
2185: END IF;
2186: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2187: IF l_return_status = G_RET_STS_ERROR THEN
2188: RAISE G_EXCEPTION_ERROR;
2189: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2190: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2268: FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB

2264: SIYB.TARGET_VALUE,
2265: SIYB.INDEX_NUMBER,
2266: SIYB.NOMINAL_YN,
2267: SIYB.PRE_TAX_YN
2268: FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB
2269: WHERE SIRB.TRANSACTION_NUMBER = p_trx_number
2270: AND SIFB.TRANSACTION_NUMBER = p_trx_number
2271: AND SIYB.SIF_ID = SIFB.ID
2272: AND SIRB.INDEX_NUMBER = SIYB.INDEX_NUMBER;

Line 2278: OKL_STREAM_INTERFACES SIFB

2274: SELECT
2275: SIFB.OBJECT1_ID1,
2276: SIFB.KHR_ID
2277: FROM
2278: OKL_STREAM_INTERFACES SIFB
2279: WHERE
2280:
2281: SIFB.TRANSACTION_NUMBER = p_trx_number;
2282: BEGIN

Line 2511: FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB

2507: SIYB.TARGET_VALUE,
2508: SIYB.INDEX_NUMBER,
2509: SIYB.NOMINAL_YN,
2510: SIYB.PRE_TAX_YN
2511: FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB
2512: WHERE SIRB.TRANSACTION_NUMBER = p_trx_number
2513: AND SIFB.TRANSACTION_NUMBER = p_trx_number
2514: AND SIYB.SIF_ID = SIFB.ID
2515: AND SIRB.INDEX_NUMBER = SIYB.INDEX_NUMBER;

Line 2521: OKL_STREAM_INTERFACES SIFB

2517: SELECT
2518: SIFB.SIS_CODE,
2519: SIFB.KHR_ID
2520: FROM
2521: OKL_STREAM_INTERFACES SIFB
2522: WHERE
2523: SIFB.TRANSACTION_NUMBER = p_trx_number;
2524: BEGIN
2525: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

Line 2706: l_object1_id1 okl_stream_interfaces.OBJECT1_ID1%TYPE;

2702: p_trqv_rec trqv_rec_type;
2703: x_trqv_rec trqv_rec_type;
2704: p_payment_tbl payment_tbl_type;
2705: l_khr_id NUMBER;
2706: l_object1_id1 okl_stream_interfaces.OBJECT1_ID1%TYPE;
2707: l_sis_code okl_stream_interfaces.SIS_CODE%TYPE;
2708: l_number_months NUMBER;
2709:
2710: --Modified by kthiruva for the VR build

Line 2707: l_sis_code okl_stream_interfaces.SIS_CODE%TYPE;

2703: x_trqv_rec trqv_rec_type;
2704: p_payment_tbl payment_tbl_type;
2705: l_khr_id NUMBER;
2706: l_object1_id1 okl_stream_interfaces.OBJECT1_ID1%TYPE;
2707: l_sis_code okl_stream_interfaces.SIS_CODE%TYPE;
2708: l_number_months NUMBER;
2709:
2710: --Modified by kthiruva for the VR build
2711: CURSOR ppd_data_csr (p_trx_number NUMBER) IS

Line 2727: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,

2723: SRLB.DAYS_IN_PERIOD,
2724: SRLB.FIRST_PAYMENT_DATE,
2725: SIFB.KHR_ID,
2726: SILB.KLE_ID
2727: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
2728: OKL_SIF_LINES SILB
2729: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2730: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2731: AND SILB.SIF_ID = SIFB.ID

Line 2781: FROM OKL_STREAM_INTERFACES

2777: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
2778: SELECT
2779: OBJECT1_ID1,
2780: SIS_CODE
2781: FROM OKL_STREAM_INTERFACES
2782: WHERE TRANSACTION_NUMBER = p_trx_number;
2783:
2784: --Added by kthiruva for VR build
2785: --This cursor checks if the adjusting stub returned by the Inbound XML

Line 3246: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB

3242: SILB.KLE_ID,
3243: SIFB.ID SIF_ID,
3244: SILB.ID SIL_ID
3245: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
3246: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
3247: WHERE SRLB.SIR_ID = p_sir_id
3248: AND SIFB.TRANSACTION_NUMBER = p_trx_number
3249: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
3250: AND SILB.SIF_ID = SIFB.ID

Line 3267: FROM OKL_STREAM_INTERFACES

3263: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3264: SELECT
3265: SIS_CODE,
3266: KHR_ID
3267: FROM OKL_STREAM_INTERFACES
3268: WHERE TRANSACTION_NUMBER = p_trx_number;
3269:
3270: --Added by kthiruva for Bug 5161075
3271: --This cursor checks if the adjusting stub returned by the Inbound XML