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 821: OKL_SIF_RETS RETURN_HEADER,

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

Line 871: OKL_SIF_RETS RETURN_HEADER,

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

Line 917: OKL_SIF_RETS

913: NOMINAL_PRE_TAX_YIELD,
914: NOMINAL_AFTER_TAX_YIELD,
915: IMPLICIT_INTEREST_RATE
916: FROM
917: OKL_SIF_RETS
918: WHERE
919: transaction_number = p_trx_number;
920: -- define cursor to check any Exceptions in the Inbound Interface Tables
921: CURSOR exception_data_csr(p_trx_number NUMBER)

Line 932: OKL_SIF_RETS SIRB,

928: SRMB.TAG_ATTRIBUTE_NAME,
929: SRMB.TAG_ATTRIBUTE_VALUE,
930: SRMB.DESCRIPTION
931: FROM
932: OKL_SIF_RETS SIRB,
933: OKL_SIF_RET_ERRORS SRMB
934: WHERE
935: SIRB.TRANSACTION_NUMBER = p_trx_number
936: AND

Line 986: FROM Okl_Sif_Rets

982: REQUEST_ID,
983: PROGRAM_APPLICATION_ID,
984: PROGRAM_ID,
985: PROGRAM_UPDATE_DATE
986: FROM Okl_Sif_Rets
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

Line 987: WHERE okl_sif_rets.transaction_number = p_trnsaction_numner;

983: PROGRAM_APPLICATION_ID,
984: PROGRAM_ID,
985: PROGRAM_UPDATE_DATE
986: FROM Okl_Sif_Rets
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

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

1734: ELSE
1735: l_sirv_rec.srt_code := 'PROCESS_COMPLETE';
1736: END IF;
1737: l_sirv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');
1738: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1739: IF(IS_DEBUG_PROCEDURE_ON) THEN
1740: BEGIN
1741: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1742: END;

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

1737: l_sirv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');
1738: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1739: IF(IS_DEBUG_PROCEDURE_ON) THEN
1740: BEGIN
1741: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1742: END;
1743: END IF;
1744: --Added by kthiruva for Debug Logging
1745: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

1742: END;
1743: END IF;
1744: --Added by kthiruva for Debug Logging
1745: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1746: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_SIF_RETS_PUB.update_sif_rets');
1747: END IF;
1748: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => p_api_version,
1749: p_init_msg_list => p_init_msg_list,
1750: x_return_status => l_return_status,

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

1744: --Added by kthiruva for Debug Logging
1745: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1746: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_SIF_RETS_PUB.update_sif_rets');
1747: END IF;
1748: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => p_api_version,
1749: p_init_msg_list => p_init_msg_list,
1750: x_return_status => l_return_status,
1751: x_msg_count => x_msg_count,
1752: x_msg_data => x_msg_data,

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

1753: p_sirv_rec => l_sirv_rec,
1754: x_sirv_rec => p_sirv_rec);
1755: --Added by kthiruva for Debug Logging
1756: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1757: 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);
1758: END IF;
1759:
1760: IF(IS_DEBUG_PROCEDURE_ON) THEN
1761: BEGIN

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

1758: END IF;
1759:
1760: IF(IS_DEBUG_PROCEDURE_ON) THEN
1761: BEGIN
1762: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1763: END;
1764: END IF;
1765: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1766:

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

1761: BEGIN
1762: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
1763: END;
1764: END IF;
1765: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1766:
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1768: THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1961: OKL_SIF_RETS SIRB,

1957: SRMB.TAG_ATTRIBUTE_NAME,
1958: SRMB.TAG_ATTRIBUTE_VALUE,
1959: SRMB.DESCRIPTION
1960: FROM
1961: OKL_SIF_RETS SIRB,
1962: OKL_SIF_RET_ERRORS SRMB
1963: WHERE
1964: SIRB.TRANSACTION_NUMBER = p_trx_number
1965: AND

Line 2085: FROM Okl_Sif_Rets

2081: REQUEST_ID,
2082: PROGRAM_APPLICATION_ID,
2083: PROGRAM_ID,
2084: PROGRAM_UPDATE_DATE
2085: FROM Okl_Sif_Rets
2086: WHERE okl_sif_rets.transaction_number = p_trx_number;
2087: CURSOR sif_data_csr (p_transaction_number IN NUMBER) IS
2088: SELECT
2089: ID,

Line 2086: WHERE okl_sif_rets.transaction_number = p_trx_number;

2082: PROGRAM_APPLICATION_ID,
2083: PROGRAM_ID,
2084: PROGRAM_UPDATE_DATE
2085: FROM Okl_Sif_Rets
2086: WHERE okl_sif_rets.transaction_number = p_trx_number;
2087: CURSOR sif_data_csr (p_transaction_number IN NUMBER) IS
2088: SELECT
2089: ID,
2090: ORP_CODE,

Line 2099: OKL_SIF_RETS SIRB,

2095: CURSOR exception_data_csr(p_trx_number NUMBER) IS
2096: SELECT
2097: SRMB.ID
2098: FROM
2099: OKL_SIF_RETS SIRB,
2100: OKL_SIF_RET_ERRORS SRMB
2101: WHERE
2102: SIRB.TRANSACTION_NUMBER = p_trx_number
2103: AND

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

2119: ELSE
2120: lp_sirv_rec.srt_code := 'PROCESS_COMPLETE';
2121: END IF;
2122: lp_sirv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');
2123: -- Start of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2124: IF(L_DEBUG_ENABLED='Y') THEN
2125: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2126: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2127: END IF;

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

2126: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2127: END IF;
2128: IF(IS_DEBUG_PROCEDURE_ON) THEN
2129: BEGIN
2130: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2131: END;
2132: END IF;
2133: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => lp_api_version,
2134: p_init_msg_list => lp_init_msg_list,

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

2129: BEGIN
2130: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2131: END;
2132: END IF;
2133: OKL_SIF_RETS_PUB.update_sif_rets(p_api_version => lp_api_version,
2134: p_init_msg_list => lp_init_msg_list,
2135: x_return_status => l_return_status,
2136: x_msg_count => lx_msg_count,
2137: x_msg_data => lx_msg_data,

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

2138: p_sirv_rec => lp_sirv_rec,
2139: x_sirv_rec => lx_sirv_rec);
2140: IF(IS_DEBUG_PROCEDURE_ON) THEN
2141: BEGIN
2142: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2143: END;
2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2146: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2141: BEGIN
2142: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2143: END;
2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2146: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2216: FROM okl_sif_rets

2212: l_object1_id1 VARCHAR2(40);
2213: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2214: SELECT
2215: ID
2216: FROM okl_sif_rets
2217: WHERE okl_sif_rets.transaction_number = p_trx_number
2218: AND
2219: INDEX_NUMBER = 0;
2220: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS

Line 2217: WHERE okl_sif_rets.transaction_number = p_trx_number

2213: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2214: SELECT
2215: ID
2216: FROM okl_sif_rets
2217: WHERE okl_sif_rets.transaction_number = p_trx_number
2218: AND
2219: INDEX_NUMBER = 0;
2220: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS
2221: SELECT

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

2455: l_amount NUMBER;
2456: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2457: SELECT
2458: ID
2459: FROM okl_sif_rets
2460: WHERE okl_sif_rets.transaction_number = p_trx_number
2461: AND INDEX_NUMBER = 0;
2462: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS
2463: SELECT

Line 2460: WHERE okl_sif_rets.transaction_number = p_trx_number

2456: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2457: SELECT
2458: ID
2459: FROM okl_sif_rets
2460: WHERE okl_sif_rets.transaction_number = p_trx_number
2461: AND INDEX_NUMBER = 0;
2462: CURSOR srlv_data_csr (p_sir_id IN NUMBER) IS
2463: SELECT
2464: ID,

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

2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'

Line 2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number

2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';

Line 2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0

2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS

Line 2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID

2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2773: SELECT

Line 2775: FROM okl_sif_rets

2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2773: SELECT
2774: ID
2775: FROM okl_sif_rets
2776: WHERE okl_sif_rets.transaction_number = p_trx_number;
2777: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
2778: SELECT
2779: OBJECT1_ID1,

Line 2776: WHERE okl_sif_rets.transaction_number = p_trx_number;

2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2773: SELECT
2774: ID
2775: FROM okl_sif_rets
2776: WHERE okl_sif_rets.transaction_number = p_trx_number;
2777: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
2778: SELECT
2779: OBJECT1_ID1,
2780: SIS_CODE

Line 3245: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,

3241: SIFB.KHR_ID,
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

Line 3260: FROM okl_sif_rets

3256:
3257: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
3258: SELECT
3259: ID
3260: FROM okl_sif_rets
3261: WHERE okl_sif_rets.transaction_number = p_trx_number
3262: AND OKL_SIF_RETS.INDEX_NUMBER = 0;
3263: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3264: SELECT

Line 3261: WHERE okl_sif_rets.transaction_number = p_trx_number

3257: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
3258: SELECT
3259: ID
3260: FROM okl_sif_rets
3261: WHERE okl_sif_rets.transaction_number = p_trx_number
3262: AND OKL_SIF_RETS.INDEX_NUMBER = 0;
3263: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3264: SELECT
3265: SIS_CODE,

Line 3262: AND OKL_SIF_RETS.INDEX_NUMBER = 0;

3258: SELECT
3259: ID
3260: FROM okl_sif_rets
3261: WHERE okl_sif_rets.transaction_number = p_trx_number
3262: AND OKL_SIF_RETS.INDEX_NUMBER = 0;
3263: CURSOR sifv_data_csr (p_trx_number IN NUMBER) IS
3264: SELECT
3265: SIS_CODE,
3266: KHR_ID