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_SIF_RETS

Line 648: OKL_SIF_RETS RETURN_HEADER,

644: HEADER.KHR_ID,
645: TO_NUMBER(NULL) KLE_ID
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

Line 676: OKL_SIF_RETS RETURN_HEADER,

672: -- TO_NUMBER(NULL)
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

Line 730: OKL_SIF_RETS RETURN_HEADER,

726: LINES.KLE_ID KLE_ID
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

Line 776: OKL_SIF_RETS RETURN_HEADER,

772: LINES.KLE_ID KLE_ID
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

Line 818: OKL_SIF_RETS RETURN_HEADER,

814: LINES.KLE_ID KLE_ID
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

Line 864: OKL_SIF_RETS

860: NOMINAL_PRE_TAX_YIELD,
861: NOMINAL_AFTER_TAX_YIELD,
862: IMPLICIT_INTEREST_RATE
863: FROM
864: OKL_SIF_RETS
865: WHERE
866: transaction_number = p_trx_number;
867: -- define cursor to check any Exceptions in the Inbound Interface Tables
868: CURSOR exception_data_csr(p_trx_number NUMBER)

Line 879: OKL_SIF_RETS SIRB,

875: SRMB.TAG_ATTRIBUTE_NAME,
876: SRMB.TAG_ATTRIBUTE_VALUE,
877: SRMB.DESCRIPTION
878: FROM
879: OKL_SIF_RETS SIRB,
880: OKL_SIF_RET_ERRORS SRMB
881: WHERE
882: SIRB.TRANSACTION_NUMBER = p_trx_number
883: AND

Line 933: FROM Okl_Sif_Rets

929: REQUEST_ID,
930: PROGRAM_APPLICATION_ID,
931: PROGRAM_ID,
932: PROGRAM_UPDATE_DATE
933: FROM Okl_Sif_Rets
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

Line 934: WHERE okl_sif_rets.transaction_number = p_trnsaction_numner;

930: PROGRAM_APPLICATION_ID,
931: PROGRAM_ID,
932: PROGRAM_UPDATE_DATE
933: FROM Okl_Sif_Rets
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

Line 1685: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets

1681: ELSE
1682: l_sirv_rec.srt_code := 'PROCESS_COMPLETE';
1683: END IF;
1684: l_sirv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');
1685: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1686: IF(IS_DEBUG_PROCEDURE_ON) THEN
1687: BEGIN
1688: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1689: END;

Line 1688: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

1684: l_sirv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');
1685: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1686: IF(IS_DEBUG_PROCEDURE_ON) THEN
1687: BEGIN
1688: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1689: END;
1690: END IF;
1691: --Added by kthiruva for Debug Logging
1692: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1693: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_SIF_RETS_PUB.update_sif_rets');

1689: END;
1690: END IF;
1691: --Added by kthiruva for Debug Logging
1692: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1693: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_SIF_RETS_PUB.update_sif_rets');
1694: END IF;
1695: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => p_api_version,
1696: p_init_msg_list => p_init_msg_list,
1697: x_return_status => l_return_status,

Line 1695: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => p_api_version,

1691: --Added by kthiruva for Debug Logging
1692: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1693: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_SIF_RETS_PUB.update_sif_rets');
1694: END IF;
1695: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => p_api_version,
1696: p_init_msg_list => p_init_msg_list,
1697: x_return_status => l_return_status,
1698: x_msg_count => x_msg_count,
1699: x_msg_data => x_msg_data,

Line 1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_SIF_RETS_PUB.update_sif_rets, return status is :'|| x_return_status);

1700: p_sirv_rec => l_sirv_rec,
1701: x_sirv_rec => p_sirv_rec);
1702: --Added by kthiruva for Debug Logging
1703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_SIF_RETS_PUB.update_sif_rets, return status is :'|| x_return_status);
1705: END IF;
1706:
1707: IF(IS_DEBUG_PROCEDURE_ON) THEN
1708: BEGIN

Line 1709: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

1705: END IF;
1706:
1707: IF(IS_DEBUG_PROCEDURE_ON) THEN
1708: BEGIN
1709: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1710: END;
1711: END IF;
1712: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1713:

Line 1712: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets

1708: BEGIN
1709: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1710: END;
1711: END IF;
1712: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1713:
1714: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1715: THEN
1716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1908: OKL_SIF_RETS SIRB,

1904: SRMB.TAG_ATTRIBUTE_NAME,
1905: SRMB.TAG_ATTRIBUTE_VALUE,
1906: SRMB.DESCRIPTION
1907: FROM
1908: OKL_SIF_RETS SIRB,
1909: OKL_SIF_RET_ERRORS SRMB
1910: WHERE
1911: SIRB.TRANSACTION_NUMBER = p_trx_number
1912: AND

Line 2032: FROM Okl_Sif_Rets

2028: REQUEST_ID,
2029: PROGRAM_APPLICATION_ID,
2030: PROGRAM_ID,
2031: PROGRAM_UPDATE_DATE
2032: FROM Okl_Sif_Rets
2033: WHERE okl_sif_rets.transaction_number = p_trx_number;
2034: CURSOR sif_data_csr (p_transaction_number IN NUMBER) IS
2035: SELECT
2036: ID,

Line 2033: WHERE okl_sif_rets.transaction_number = p_trx_number;

2029: PROGRAM_APPLICATION_ID,
2030: PROGRAM_ID,
2031: PROGRAM_UPDATE_DATE
2032: FROM Okl_Sif_Rets
2033: WHERE okl_sif_rets.transaction_number = p_trx_number;
2034: CURSOR sif_data_csr (p_transaction_number IN NUMBER) IS
2035: SELECT
2036: ID,
2037: ORP_CODE,

Line 2046: OKL_SIF_RETS SIRB,

2042: CURSOR exception_data_csr(p_trx_number NUMBER) IS
2043: SELECT
2044: SRMB.ID
2045: FROM
2046: OKL_SIF_RETS SIRB,
2047: OKL_SIF_RET_ERRORS SRMB
2048: WHERE
2049: SIRB.TRANSACTION_NUMBER = p_trx_number
2050: AND

Line 2070: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets

2066: ELSE
2067: lp_sirv_rec.srt_code := 'PROCESS_COMPLETE';
2068: END IF;
2069: lp_sirv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');
2070: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2071: IF(L_DEBUG_ENABLED='Y') THEN
2072: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2073: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2074: END IF;

Line 2077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

2073: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2074: END IF;
2075: IF(IS_DEBUG_PROCEDURE_ON) THEN
2076: BEGIN
2077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2078: END;
2079: END IF;
2080: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => lp_api_version,
2081: p_init_msg_list => lp_init_msg_list,

Line 2080: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => lp_api_version,

2076: BEGIN
2077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2078: END;
2079: END IF;
2080: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => lp_api_version,
2081: p_init_msg_list => lp_init_msg_list,
2082: x_return_status => l_return_status,
2083: x_msg_count => lx_msg_count,
2084: x_msg_data => lx_msg_data,

Line 2089: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');

2085: p_sirv_rec => lp_sirv_rec,
2086: x_sirv_rec => lx_sirv_rec);
2087: IF(IS_DEBUG_PROCEDURE_ON) THEN
2088: BEGIN
2089: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2090: END;
2091: END IF;
2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets

2088: BEGIN
2089: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2090: END;
2091: END IF;
2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2163: FROM okl_sif_rets

2159: l_object1_id1 VARCHAR2(40);
2160: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2161: SELECT
2162: ID
2163: FROM okl_sif_rets
2164: WHERE okl_sif_rets.transaction_number = p_trx_number
2165: AND
2166: INDEX_NUMBER = 0;
2167: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS

Line 2164: WHERE okl_sif_rets.transaction_number = p_trx_number

2160: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2161: SELECT
2162: ID
2163: FROM okl_sif_rets
2164: WHERE okl_sif_rets.transaction_number = p_trx_number
2165: AND
2166: INDEX_NUMBER = 0;
2167: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS
2168: SELECT

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 2406: FROM okl_sif_rets

2402: l_amount NUMBER;
2403: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2404: SELECT
2405: ID
2406: FROM okl_sif_rets
2407: WHERE okl_sif_rets.transaction_number = p_trx_number
2408: AND INDEX_NUMBER = 0;
2409: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS
2410: SELECT

Line 2407: WHERE okl_sif_rets.transaction_number = p_trx_number

2403: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2404: SELECT
2405: ID
2406: FROM okl_sif_rets
2407: WHERE okl_sif_rets.transaction_number = p_trx_number
2408: AND INDEX_NUMBER = 0;
2409: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS
2410: SELECT
2411: ID,

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 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 2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS

2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'

Line 2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number

2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';

Line 2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0

2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS

Line 2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID

2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2720: SELECT

Line 2722: FROM okl_sif_rets

2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2720: SELECT
2721: ID
2722: FROM okl_sif_rets
2723: WHERE okl_sif_rets.transaction_number = p_trx_number;
2724: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
2725: SELECT
2726: OBJECT1_ID1,

Line 2723: WHERE okl_sif_rets.transaction_number = p_trx_number;

2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2720: SELECT
2721: ID
2722: FROM okl_sif_rets
2723: WHERE okl_sif_rets.transaction_number = p_trx_number;
2724: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
2725: SELECT
2726: OBJECT1_ID1,
2727: SIS_CODE

Line 3188: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,

3184: SRLB.STREAM_INTERFACE_ATTRIBUTE14,
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

Line 3202: FROM okl_sif_rets

3198:
3199: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
3200: SELECT
3201: ID
3202: FROM okl_sif_rets
3203: WHERE okl_sif_rets.transaction_number = p_trx_number
3204: AND OKL_SIF_RETS.INDEX_NUMBER = 0;
3205: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3206: SELECT

Line 3203: WHERE okl_sif_rets.transaction_number = p_trx_number

3199: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
3200: SELECT
3201: ID
3202: FROM okl_sif_rets
3203: WHERE okl_sif_rets.transaction_number = p_trx_number
3204: AND OKL_SIF_RETS.INDEX_NUMBER = 0;
3205: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3206: SELECT
3207: SIS_CODE,

Line 3204: AND OKL_SIF_RETS.INDEX_NUMBER = 0;

3200: SELECT
3201: ID
3202: FROM okl_sif_rets
3203: WHERE okl_sif_rets.transaction_number = p_trx_number
3204: AND OKL_SIF_RETS.INDEX_NUMBER = 0;
3205: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3206: SELECT
3207: SIS_CODE,
3208: KHR_ID