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 819: OKL_STREAM_INTERFACES HEADER,

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

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

881: WHERE
882: SIRB.TRANSACTION_NUMBER = p_trx_number
883: AND
884: SIRB.ID = SRMB.SIR_ID;
885: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
886: CURSOR sif_data_csr (p_transaction_number IN NUMBER) IS
887: SELECT
888:
889: ID,

Line 893: FROM Okl_Stream_Interfaces

889: ID,
890: ORP_CODE,
891: LOG_FILE,
892: SECURITY_DEPOSIT_AMOUNT
893: FROM Okl_Stream_Interfaces
894: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
895: CURSOR sirv_data_csr (p_trnsaction_numner IN NUMBER) IS
896: SELECT
897: ID,

Line 894: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;

890: ORP_CODE,
891: LOG_FILE,
892: SECURITY_DEPOSIT_AMOUNT
893: FROM Okl_Stream_Interfaces
894: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
895: CURSOR sirv_data_csr (p_trnsaction_numner IN NUMBER) IS
896: SELECT
897: ID,
898: TRANSACTION_NUMBER,

Line 938: FROM okl_stream_interfaces

934: WHERE okl_sif_rets.transaction_number = p_trnsaction_numner;
935: -- smahapat 11/10/02 multi-gaap -- addition
936: CURSOR reporting_streams_csr(p_trx_number NUMBER) IS
937: SELECT purpose_code
938: FROM okl_stream_interfaces
939: WHERE transaction_number = p_trx_number;
940:
941: CURSOR reporting_product_csr(p_trx_number NUMBER) IS
942: SELECT c.reporting_pdt_id

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

939: WHERE transaction_number = p_trx_number;
940:
941: CURSOR reporting_product_csr(p_trx_number NUMBER) IS
942: SELECT c.reporting_pdt_id
943: FROM okl_k_headers a, okl_stream_interfaces b, okl_products_v c
944: WHERE b.transaction_number = p_trx_number
945: AND a.id = b.khr_id
946: AND c.id = a.pdt_id;
947: reporting_product_rec reporting_product_csr%ROWTYPE;

Line 958: OKL_STREAM_INTERFACES SIFB

954: SELECT
955: '1'
956: FROM
957: OKL_SIF_FEES SFEB,
958: OKL_STREAM_INTERFACES SIFB
959: WHERE
960: SIFB.ID = SFEB.SIF_ID AND
961: transaction_number = p_trx_number AND
962: SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;

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

1726: lp_sifv_rec.log_file := 'OKLSTXMLG_' || p_transaction_number || '.log ';
1727: ELSE
1728: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
1729: END IF;
1730: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1731: IF(IS_DEBUG_PROCEDURE_ON) THEN
1732: BEGIN
1733: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1734: END;

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

1729: END IF;
1730: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1731: IF(IS_DEBUG_PROCEDURE_ON) THEN
1732: BEGIN
1733: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1734: END;
1735: END IF;
1736: --Added by kthiruva for Debug Logging
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

1734: END;
1735: END IF;
1736: --Added by kthiruva for Debug Logging
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1739: END IF;
1740: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1741: p_api_version => p_api_version
1742: ,p_init_msg_list => p_init_msg_list

Line 1740: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(

1736: --Added by kthiruva for Debug Logging
1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_STREAM_INTERFACES_PUB.update_stream_interfaces');
1739: END IF;
1740: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(
1741: p_api_version => p_api_version
1742: ,p_init_msg_list => p_init_msg_list
1743: ,x_return_status => l_return_status
1744: ,x_msg_count => x_msg_count

Line 1750: 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);

1746: ,p_sifv_rec => lp_sifv_rec
1747: ,x_sifv_rec => lx_sifv_rec);
1748: --Added by kthiruva for Debug Logging
1749: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1750: 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);
1751: END IF;
1752:
1753: IF(IS_DEBUG_PROCEDURE_ON) THEN
1754: BEGIN

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

1751: END IF;
1752:
1753: IF(IS_DEBUG_PROCEDURE_ON) THEN
1754: BEGIN
1755: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1756: END;
1757: END IF;
1758: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1759: IF l_return_status = G_RET_STS_ERROR THEN

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

1754: BEGIN
1755: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
1756: END;
1757: END IF;
1758: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
1759: IF l_return_status = G_RET_STS_ERROR THEN
1760: RAISE G_EXCEPTION_ERROR;
1761: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1762: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 1991: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

1987: lp_init_msg_list VARCHAR2(1) := 'F';
1988: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1989: l_exception_data_found BOOLEAN := FALSE;
1990: lx_msg_count NUMBER;
1991: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1992: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1993: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
1994: SELECT
1995: ID,

Line 1992: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;

1988: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1989: l_exception_data_found BOOLEAN := FALSE;
1990: lx_msg_count NUMBER;
1991: lp_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1992: lx_sifv_rec OKL_STREAM_INTERFACES_PUB.SIFV_REC_TYPE;
1993: CURSOR sirv_data_csr (p_trx_number IN NUMBER) IS
1994: SELECT
1995: ID,
1996: TRANSACTION_NUMBER,

Line 2039: FROM Okl_Stream_Interfaces

2035: SELECT
2036: ID,
2037: ORP_CODE,
2038: LOG_FILE
2039: FROM Okl_Stream_Interfaces
2040: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
2041: -- define cursor to check any Exceptions in the Inbound Interface Tables
2042: CURSOR exception_data_csr(p_trx_number NUMBER) IS
2043: SELECT

Line 2040: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;

2036: ID,
2037: ORP_CODE,
2038: LOG_FILE
2039: FROM Okl_Stream_Interfaces
2040: WHERE okl_stream_interfaces.transaction_number = p_transaction_number;
2041: -- define cursor to check any Exceptions in the Inbound Interface Tables
2042: CURSOR exception_data_csr(p_trx_number NUMBER) IS
2043: SELECT
2044: SRMB.ID

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

2110: lp_sifv_rec.stream_interface_attribute03 := 'OKLSTXMLG_' || p_transaction_number || '.log ';
2111: ELSE
2112: lp_sifv_rec.sis_code := 'PROCESS_COMPLETE';
2113: END IF;
2114: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2115: IF(IS_DEBUG_PROCEDURE_ON) THEN
2116: BEGIN
2117: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2118: END;

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

2113: END IF;
2114: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2115: IF(IS_DEBUG_PROCEDURE_ON) THEN
2116: BEGIN
2117: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2118: END;
2119: END IF;
2120: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2121: ,p_init_msg_list => lp_init_msg_list

Line 2120: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version

2116: BEGIN
2117: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2118: END;
2119: END IF;
2120: OKL_STREAM_INTERFACES_PUB.update_stream_interfaces(p_api_version => lp_api_version
2121: ,p_init_msg_list => lp_init_msg_list
2122: ,x_return_status => l_return_status
2123: ,x_msg_count => lx_msg_count
2124: ,x_msg_data => lx_msg_data

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

2126: ,x_sifv_rec => lx_sifv_rec);
2127:
2128: IF(IS_DEBUG_PROCEDURE_ON) THEN
2129: BEGIN
2130: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2131: END;
2132: END IF;
2133: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2134: IF l_return_status = G_RET_STS_ERROR THEN

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

2129: BEGIN
2130: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_STREAM_INTERFACES_PUB.update_stream_interfaces ');
2131: END;
2132: END IF;
2133: -- End of wraper code generated automatically by Debug code generator for OKL_STREAM_INTERFACES_PUB.update_stream_interfaces
2134: IF l_return_status = G_RET_STS_ERROR THEN
2135: RAISE G_EXCEPTION_ERROR;
2136: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2137: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

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

2211: SIYB.TARGET_VALUE,
2212: SIYB.INDEX_NUMBER,
2213: SIYB.NOMINAL_YN,
2214: SIYB.PRE_TAX_YN
2215: FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB
2216: WHERE SIRB.TRANSACTION_NUMBER = p_trx_number
2217: AND SIFB.TRANSACTION_NUMBER = p_trx_number
2218: AND SIYB.SIF_ID = SIFB.ID
2219: AND SIRB.INDEX_NUMBER = SIYB.INDEX_NUMBER;

Line 2225: OKL_STREAM_INTERFACES SIFB

2221: SELECT
2222: SIFB.OBJECT1_ID1,
2223: SIFB.KHR_ID
2224: FROM
2225: OKL_STREAM_INTERFACES SIFB
2226: WHERE
2227:
2228: SIFB.TRANSACTION_NUMBER = p_trx_number;
2229: BEGIN

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

2454: SIYB.TARGET_VALUE,
2455: SIYB.INDEX_NUMBER,
2456: SIYB.NOMINAL_YN,
2457: SIYB.PRE_TAX_YN
2458: FROM OKL_SIF_RETS SIRB, OKL_SIF_YIELDS SIYB, OKL_STREAM_INTERFACES SIFB
2459: WHERE SIRB.TRANSACTION_NUMBER = p_trx_number
2460: AND SIFB.TRANSACTION_NUMBER = p_trx_number
2461: AND SIYB.SIF_ID = SIFB.ID
2462: AND SIRB.INDEX_NUMBER = SIYB.INDEX_NUMBER;

Line 2468: OKL_STREAM_INTERFACES SIFB

2464: SELECT
2465: SIFB.SIS_CODE,
2466: SIFB.KHR_ID
2467: FROM
2468: OKL_STREAM_INTERFACES SIFB
2469: WHERE
2470: SIFB.TRANSACTION_NUMBER = p_trx_number;
2471: BEGIN
2472: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

Line 2653: l_object1_id1 okl_stream_interfaces.OBJECT1_ID1%TYPE;

2649: p_trqv_rec trqv_rec_type;
2650: x_trqv_rec trqv_rec_type;
2651: p_payment_tbl payment_tbl_type;
2652: l_khr_id NUMBER;
2653: l_object1_id1 okl_stream_interfaces.OBJECT1_ID1%TYPE;
2654: l_sis_code okl_stream_interfaces.SIS_CODE%TYPE;
2655: l_number_months NUMBER;
2656:
2657: --Modified by kthiruva for the VR build

Line 2654: l_sis_code okl_stream_interfaces.SIS_CODE%TYPE;

2650: x_trqv_rec trqv_rec_type;
2651: p_payment_tbl payment_tbl_type;
2652: l_khr_id NUMBER;
2653: l_object1_id1 okl_stream_interfaces.OBJECT1_ID1%TYPE;
2654: l_sis_code okl_stream_interfaces.SIS_CODE%TYPE;
2655: l_number_months NUMBER;
2656:
2657: --Modified by kthiruva for the VR build
2658: CURSOR ppd_data_csr (p_trx_number NUMBER) IS

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

2670: SRLB.DAYS_IN_PERIOD,
2671: SRLB.FIRST_PAYMENT_DATE,
2672: SIFB.KHR_ID,
2673: SILB.KLE_ID
2674: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
2675: OKL_SIF_LINES SILB
2676: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2677: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2678: AND SILB.SIF_ID = SIFB.ID

Line 2728: FROM OKL_STREAM_INTERFACES

2724: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
2725: SELECT
2726: OBJECT1_ID1,
2727: SIS_CODE
2728: FROM OKL_STREAM_INTERFACES
2729: WHERE TRANSACTION_NUMBER = p_trx_number;
2730:
2731: --Added by kthiruva for VR build
2732: --This cursor checks if the adjusting stub returned by the Inbound XML

Line 3189: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB

3185: SRLB.STREAM_INTERFACE_ATTRIBUTE15,
3186: SIFB.KHR_ID,
3187: SILB.KLE_ID
3188: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
3189: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
3190: WHERE SRLB.SIR_ID = p_sir_id
3191: AND SIFB.TRANSACTION_NUMBER = p_trx_number
3192: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
3193: AND SILB.SIF_ID = SIFB.ID

Line 3209: FROM OKL_STREAM_INTERFACES

3205: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3206: SELECT
3207: SIS_CODE,
3208: KHR_ID
3209: FROM OKL_STREAM_INTERFACES
3210: WHERE TRANSACTION_NUMBER = p_trx_number;
3211:
3212: --Added by kthiruva for Bug 5161075
3213: --This cursor checks if the adjusting stub returned by the Inbound XML