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_INSURANCE_POLICIES_PVT dependencies on OKL_STREAMS

Line 1129: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR

1125:
1126:
1127: CURSOR C_OKL_CNSLD_AR_STRMB IS
1128: SELECT SUM(STRE.AMOUNT)
1129: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR
1130: WHERE STR.KHR_ID = P_IPYV_REC.KHR_ID
1131: AND STR.KLE_ID = P_IPYV_REC.KLE_ID
1132: AND STR.ID = STRE.STM_ID
1133: AND STRE.DATE_BILLED IS NOT NULL;

Line 1157: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1153: BEGIN
1154:
1155:
1156:
1157: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1158: 'INSURANCE_RECEIVABLE',
1159: l_return_status,
1160: l_strm_type_id);
1161:

Line 1202: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1198: END if ;
1199: CLOSE C_OKL_STRM_TYPE_CRE_V;*/
1200:
1201:
1202: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1203: 'INSURANCE_REFUND',
1204: l_return_status,
1205: l_strm_type_id);
1206:

Line 1606: FROM okl_strm_elements STRE, OKL_STREAMS STR

1602:
1603:
1604: CURSOR c_total_paid(l_stm_type_id NUMBER) IS
1605: SELECT SUM(STRE.AMOUNT)
1606: FROM okl_strm_elements STRE, OKL_STREAMS STR
1607: WHERE STR.ID = STRE.STM_ID
1608: AND STR.STY_ID = l_stm_type_id
1609: AND STRE.DATE_BILLED IS NOT NULL
1610: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 1796: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END if ;
1794: CLOSE C_OKL_STRM_TYPE_V;*/
1795: -- cursor fetch replaced with the call to get the stream type id
1796: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1797: 'INSURANCE_PAYABLE',
1798: l_return_status,
1799: l_strm_type_id);
1800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1822: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1818: IF (ln_premium < l_total_paid) THEN
1819:
1820: -- cursor fetch replaced with the call to get the stream type id
1821: -- changed for use defined streams bug 3924300
1822: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1823: 'INSURANCE_ADJUSTMENT',
1824: l_return_status,
1825: l_strm_type_id);
1826:

Line 1880: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1876: l_to_refund := ln_premium - l_total_paid ;
1877:
1878: -- cursor fetch replaced with the call to get the stream type id
1879: -- changed for user defined sreams, bug 3924300
1880: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1881: 'INSURANCE_PAYABLE',
1882: l_return_status,
1883: l_strm_type_id);
1884:

Line 1993: FROM OKL_STREAMS STM

1989:
1990: --- For Recievables
1991: CURSOR c_okl_strem_rec(l_recv_strm_id NUMBER) IS
1992: SELECT STM.ID
1993: FROM OKL_STREAMS STM
1994: WHERE STM.STY_ID = l_recv_strm_id
1995: AND STM.KLE_ID = p_contract_line
1996: AND STM.KHR_ID = p_contract_id;
1997:

Line 2003: FROM OKL_STREAMS STM

1999:
2000: ---- For accrual
2001: CURSOR c_okl_strem_rec_acc (l_recv_strm_id NUMBER) IS
2002: SELECT STM.ID
2003: FROM OKL_STREAMS STM
2004: WHERE STM.STY_ID = l_recv_strm_id
2005: AND STM.KLE_ID = p_contract_line
2006: AND STM.KHR_ID = p_contract_id
2007: AND STM.PURPOSE_CODE IS NULL;

Line 2013: FROM OKL_STREAMS STM

2009:
2010: ---- For Reporting accrual
2011: CURSOR c_okl_strem_rec_repacc (l_recv_strm_id NUMBER) IS
2012: SELECT STM.ID
2013: FROM OKL_STREAMS STM
2014: WHERE STM.STY_ID = l_recv_strm_id
2015: AND STM.KLE_ID = p_contract_line
2016: AND STM.KHR_ID = p_contract_id
2017: AND STM.PURPOSE_CODE ='REPORT';

Line 2026: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2022: from OKL_STRM_TYPE_TL
2023: where NAME = ls_strm_type
2024: AND LANGUAGE = 'US';
2025:
2026: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2027: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2028:
2029: BEGIN
2030: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2027: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2023: where NAME = ls_strm_type
2024: AND LANGUAGE = 'US';
2025:
2026: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2027: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2028:
2029: BEGIN
2030: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2031: G_PKG_NAME,

Line 2056: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2052:
2053: -- cursor fetch replaced with the call to get the stream type id
2054: -- changed for user defined streams, bug 3924300
2055:
2056: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2057: ls_strm_purpose,
2058: l_return_status,
2059: l_recv_strm_id);
2060:

Line 2075: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2071: OPEN c_okl_strem_rec(l_recv_strm_id);
2072: FETCH c_okl_strem_rec INTO p_stmv_rec.id;
2073: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2074:
2075: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2076: IF(L_DEBUG_ENABLED='Y') THEN
2077: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2078: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2079: END IF;

Line 2082: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2078: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2079: END IF;
2080: IF(IS_DEBUG_PROCEDURE_ON) THEN
2081: BEGIN
2082: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2083: END;
2084: END IF;
2085: OKL_STREAMS_PUB.update_streams(
2086: p_api_version

Line 2085: OKL_STREAMS_PUB.update_streams(

2081: BEGIN
2082: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2083: END;
2084: END IF;
2085: OKL_STREAMS_PUB.update_streams(
2086: p_api_version
2087: ,p_init_msg_list
2088: ,x_return_status
2089: ,x_msg_count

Line 2096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2092: ,x_stmv_rec
2093: );
2094: IF(IS_DEBUG_PROCEDURE_ON) THEN
2095: BEGIN
2096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2097: END;
2098: END IF;
2099: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2100:

Line 2099: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2095: BEGIN
2096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2097: END;
2098: END IF;
2099: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2100:
2101: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2102: CLOSE c_okl_strem_rec ;
2103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2125: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2121:
2122:
2123: -- cursor fetch replaced with the call to get the stream type id
2124: -- changed for user defined streams, bug 3924300
2125: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2126: ls_strm_purpose,
2127: l_return_status,
2128: l_recv_strm_id);
2129:

Line 2144: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2140: --- For Accrual
2141: OPEN c_okl_strem_rec_acc(l_recv_strm_id);
2142: FETCH c_okl_strem_rec_acc INTO p_stmv_rec.id;
2143: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2144: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2145: IF(IS_DEBUG_PROCEDURE_ON) THEN
2146: BEGIN
2147: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2148: END;

Line 2147: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2143: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2144: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2145: IF(IS_DEBUG_PROCEDURE_ON) THEN
2146: BEGIN
2147: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2148: END;
2149: END IF;
2150: OKL_STREAMS_PUB.update_streams(
2151: p_api_version

Line 2150: OKL_STREAMS_PUB.update_streams(

2146: BEGIN
2147: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2148: END;
2149: END IF;
2150: OKL_STREAMS_PUB.update_streams(
2151: p_api_version
2152: ,p_init_msg_list
2153: ,x_return_status
2154: ,x_msg_count

Line 2161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2157: ,x_stmv_rec
2158: );
2159: IF(IS_DEBUG_PROCEDURE_ON) THEN
2160: BEGIN
2161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2162: END;
2163: END IF;
2164: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2165:

Line 2164: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2160: BEGIN
2161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2162: END;
2163: END IF;
2164: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2165:
2166: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2167: CLOSE c_okl_strem_rec_acc ;
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2181: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2177: --- For Reporing Accrual
2178: OPEN c_okl_strem_rec_repacc(l_recv_strm_id);
2179: FETCH c_okl_strem_rec_repacc INTO p_stmv_rec.id;
2180: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2181: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2182: IF(IS_DEBUG_PROCEDURE_ON) THEN
2183: BEGIN
2184: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2185: END;

Line 2184: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2180: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2181: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2182: IF(IS_DEBUG_PROCEDURE_ON) THEN
2183: BEGIN
2184: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2185: END;
2186: END IF;
2187: OKL_STREAMS_PUB.update_streams(
2188: p_api_version

Line 2187: OKL_STREAMS_PUB.update_streams(

2183: BEGIN
2184: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2185: END;
2186: END IF;
2187: OKL_STREAMS_PUB.update_streams(
2188: p_api_version
2189: ,p_init_msg_list
2190: ,x_return_status
2191: ,x_msg_count

Line 2198: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2194: ,x_stmv_rec
2195: );
2196: IF(IS_DEBUG_PROCEDURE_ON) THEN
2197: BEGIN
2198: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2199: END;
2200: END IF;
2201: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2202:

Line 2201: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2197: BEGIN
2198: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2199: END;
2200: END IF;
2201: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2202:
2203: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2204: CLOSE c_okl_strem_rec_repacc ;
2205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2227: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2223:
2224: -- cursor fetch replaced with the call to get the stream type id,
2225: -- changed for user defined streams, Bug 3924300
2226:
2227: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2228: ls_strm_purpose,
2229: l_return_status,
2230: l_recv_strm_id);
2231:

Line 2244: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2240:
2241: OPEN c_okl_strem_rec(l_recv_strm_id);
2242: FETCH c_okl_strem_rec INTO p_stmv_rec.id;
2243: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2244: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2245: IF(IS_DEBUG_PROCEDURE_ON) THEN
2246: BEGIN
2247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2248: END;

Line 2247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2243: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2244: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2245: IF(IS_DEBUG_PROCEDURE_ON) THEN
2246: BEGIN
2247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2248: END;
2249: END IF;
2250: OKL_STREAMS_PUB.update_streams(
2251: p_api_version

Line 2250: OKL_STREAMS_PUB.update_streams(

2246: BEGIN
2247: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2248: END;
2249: END IF;
2250: OKL_STREAMS_PUB.update_streams(
2251: p_api_version
2252: ,p_init_msg_list
2253: ,x_return_status
2254: ,x_msg_count

Line 2261: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2257: ,x_stmv_rec
2258: );
2259: IF(IS_DEBUG_PROCEDURE_ON) THEN
2260: BEGIN
2261: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2262: END;
2263: END IF;
2264: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2265:

Line 2264: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2260: BEGIN
2261: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2262: END;
2263: END IF;
2264: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2265:
2266: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2267: CLOSE c_okl_strem_rec ;
2268: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2291: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2287:
2288: -- cursor fetch replaced with the call to get the stream type id,
2289: -- changed for user defined streams, bug 3924300
2290:
2291: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2292: ls_strm_purpose,
2293: l_return_status,
2294: l_recv_strm_id);
2295:

Line 2310: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2306: --- For Accrual
2307: OPEN c_okl_strem_rec_acc(l_recv_strm_id);
2308: FETCH c_okl_strem_rec_acc INTO p_stmv_rec.id;
2309: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2310: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2311: IF(IS_DEBUG_PROCEDURE_ON) THEN
2312: BEGIN
2313: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2314: END;

Line 2313: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2309: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2310: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2311: IF(IS_DEBUG_PROCEDURE_ON) THEN
2312: BEGIN
2313: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2314: END;
2315: END IF;
2316: OKL_STREAMS_PUB.update_streams(
2317: p_api_version

Line 2316: OKL_STREAMS_PUB.update_streams(

2312: BEGIN
2313: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2314: END;
2315: END IF;
2316: OKL_STREAMS_PUB.update_streams(
2317: p_api_version
2318: ,p_init_msg_list
2319: ,x_return_status
2320: ,x_msg_count

Line 2327: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2323: ,x_stmv_rec
2324: );
2325: IF(IS_DEBUG_PROCEDURE_ON) THEN
2326: BEGIN
2327: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2328: END;
2329: END IF;
2330: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2331:

Line 2330: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2326: BEGIN
2327: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2328: END;
2329: END IF;
2330: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2331:
2332: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2333: CLOSE c_okl_strem_rec_acc ;
2334: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2348: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2344: --- For Reporting Accrual
2345: OPEN c_okl_strem_rec_repacc(l_recv_strm_id);
2346: FETCH c_okl_strem_rec_repacc INTO p_stmv_rec.id;
2347: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2348: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2349: IF(IS_DEBUG_PROCEDURE_ON) THEN
2350: BEGIN
2351: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2352: END;

Line 2351: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2347: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2348: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2349: IF(IS_DEBUG_PROCEDURE_ON) THEN
2350: BEGIN
2351: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2352: END;
2353: END IF;
2354: OKL_STREAMS_PUB.update_streams(
2355: p_api_version

Line 2354: OKL_STREAMS_PUB.update_streams(

2350: BEGIN
2351: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2352: END;
2353: END IF;
2354: OKL_STREAMS_PUB.update_streams(
2355: p_api_version
2356: ,p_init_msg_list
2357: ,x_return_status
2358: ,x_msg_count

Line 2365: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');

2361: ,x_stmv_rec
2362: );
2363: IF(IS_DEBUG_PROCEDURE_ON) THEN
2364: BEGIN
2365: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2366: END;
2367: END IF;
2368: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2369:

Line 2368: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams

2364: BEGIN
2365: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2366: END;
2367: END IF;
2368: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2369:
2370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2371: CLOSE c_okl_strem_rec_repacc ;
2372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2801: FROM okl_strm_elements STRE, OKL_STREAMS STR

2797:
2798: --Get total amount paid by the customer
2799: CURSOR c_total_amount_paid (c_sty_id NUMBER,c_contract_id NUMBER,c_contract_line_id NUMBER)IS
2800: SELECT COUNT(*)
2801: FROM okl_strm_elements STRE, OKL_STREAMS STR
2802: WHERE STR.ID = STRE.STM_ID
2803: AND STR.STY_ID = c_sty_id
2804: AND STRE.DATE_BILLED IS NOT NULL
2805: AND STR.KHR_ID = c_contract_id

Line 2938: FROM okl_strm_elements STRE, OKL_STREAMS STR

2934: GROUP BY OINB.IPY_ID;
2935: -- calculate total amount paid to vendor
2936: CURSOR c_total_paid(p_stm_type_id NUMBER) IS
2937: SELECT SUM(STRE.AMOUNT)
2938: FROM okl_strm_elements STRE, OKL_STREAMS STR
2939: WHERE STR.ID = STRE.STM_ID
2940: AND STR.STY_ID = p_stm_type_id
2941: AND STRE.DATE_BILLED IS NOT NULL
2942: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 3078: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3074: ln_premium := li_months * l_total_lessor_premium ;
3075:
3076: -- How much have we paid him
3077: -- cursor fetch replaced with the call to get the stream type id
3078: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3079: 'INSURANCE_PAYABLE',
3080: l_return_status,
3081: l_pay_strm_type_id);
3082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3101: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3097: END IF ;
3098: ln_refund := l_total_paid - ln_premium ;
3099: pn_refund:= ln_refund;
3100: IF (ln_premium < l_total_paid) THEN -- clawback
3101: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3102: 'INSURANCE_ADJUSTMENT',
3103: l_return_status,
3104: l_Adj_strm_type_id);
3105: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3150: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3146:
3147: ELSIF (ln_premium > l_total_paid) THEN
3148: l_tra_id := OKC_API.G_MISS_NUM ;
3149: l_to_refund := ln_premium - l_total_paid ;
3150: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3151: 'INSURANCE_PAYABLE',
3152: l_return_status,
3153: l_PAY_strm_type_id);
3154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3267: --FROM OKL_STREAMS STM,

3263: l_ins_try_id NUMBER;
3264: l_ipyv_rec ipyv_rec_type;
3265: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3266: SELECT SUM(amount)
3267: --FROM OKL_STREAMS STM,
3268: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041
3269: OKL_STRM_ELEMENTS STEM
3270: where STM.STY_ID = l_stream_type_id
3271: AND STM.KLE_ID = l_kle_id

Line 3268: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041

3264: l_ipyv_rec ipyv_rec_type;
3265: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3266: SELECT SUM(amount)
3267: --FROM OKL_STREAMS STM,
3268: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041
3269: OKL_STRM_ELEMENTS STEM
3270: where STM.STY_ID = l_stream_type_id
3271: AND STM.KLE_ID = l_kle_id
3272: AND STM.KHR_ID = l_khr_id

Line 3278: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3274: AND STEM.DATE_BILLED IS NOT NULL ;
3275: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
3276: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3277: SELECT SUM(amount)
3278: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3279: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041
3280: WHERE STM.STY_ID = l_stream_type_id
3281: AND STM.KLE_ID = l_kle_id
3282: AND STM.KHR_ID = l_khr_id

Line 3279: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041

3275: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
3276: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3277: SELECT SUM(amount)
3278: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3279: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041
3280: WHERE STM.STY_ID = l_stream_type_id
3281: AND STM.KLE_ID = l_kle_id
3282: AND STM.KHR_ID = l_khr_id
3283: AND STM.ID = STEM.STM_ID

Line 3413: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3411: RAISE OKC_API.G_EXCEPTION_ERROR;
3412: END IF;
3413: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3414: 'INSURANCE_RECEIVABLE',
3415: l_return_status,
3416: l_strm_type_id);
3417: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3451: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3447: l_multi_gaap_yn, l_reporting_pdt_id;
3448: CLOSE check_csr;
3449: -- MGAAP end 7263041
3450:
3451: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3452: 'INSURANCE_INCOME_ACCRUAL',
3453: l_return_status,
3454: l_strm_type_id);
3455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3489: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3485:
3486: -- MGAAP start 7263041
3487:
3488: IF (l_multi_gaap_yn = 'Y') THEN
3489: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3490: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3491: 'INSURANCE_INCOME_ACCRUAL',
3492: l_return_status,
3493: l_strm_type_id_rep);

Line 3490: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3486: -- MGAAP start 7263041
3487:
3488: IF (l_multi_gaap_yn = 'Y') THEN
3489: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3490: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3491: 'INSURANCE_INCOME_ACCRUAL',
3492: l_return_status,
3493: l_strm_type_id_rep);
3494: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3505: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3501: OPEN c_total_bill_accrued(l_ipyv_rec.KHR_ID , l_ipyv_rec.KLE_ID,l_strm_type_id_rep);
3502: FETCH c_total_bill_accrued INTO l_total_bill_accrued_rep;
3503: CLOSE c_total_bill_accrued ;
3504:
3505: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3506: IF ((l_total_bill_accrued_rep IS NULL ) OR (l_total_bill_accrued_rep = OKC_API.G_MISS_NUM )) THEN
3507: l_total_bill_accrued_rep := 0;
3508: END IF ;
3509:

Line 3725: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3721:
3722: --Start Bug#5955320
3723: IF (l_adjustment_amount <> 0 ) THEN
3724:
3725: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3726: 'INSURANCE_INCOME_ACCRUAL',
3727: l_return_status,
3728: l_inc_sty_id);
3729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3793: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3789:
3790: -- MGAAP start 7263041
3791: IF (l_multi_gaap_yn = 'Y') THEN
3792: IF (l_adjustment_amount_rep <> 0) THEN
3793: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3794: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3795: 'INSURANCE_INCOME_ACCRUAL',
3796: l_return_status,
3797: l_inc_sty_id_rep);

Line 3794: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3790: -- MGAAP start 7263041
3791: IF (l_multi_gaap_yn = 'Y') THEN
3792: IF (l_adjustment_amount_rep <> 0) THEN
3793: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3794: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3795: 'INSURANCE_INCOME_ACCRUAL',
3796: l_return_status,
3797: l_inc_sty_id_rep);
3798: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 3842: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3838: ,p_accrual_rec => l_accrual_rec
3839: ,p_stream_tbl => l_stream_tbl,
3840: p_representation_type => 'SECONDARY');
3841:
3842: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3843: IF(IS_DEBUG_PROCEDURE_ON) THEN
3844: BEGIN
3845: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS ');
3846: END;

Line 3906: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3902: l_ins_try_id NUMBER;
3903: l_ipyv_rec ipyv_rec_type;
3904: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3905: SELECT SUM(amount)
3906: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3907: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3908: WHERE STM.STY_ID = l_stream_type_id
3909: AND STM.KLE_ID = l_kle_id
3910: AND STM.KHR_ID = l_khr_id

Line 3907: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP

3903: l_ipyv_rec ipyv_rec_type;
3904: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3905: SELECT SUM(amount)
3906: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3907: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3908: WHERE STM.STY_ID = l_stream_type_id
3909: AND STM.KLE_ID = l_kle_id
3910: AND STM.KHR_ID = l_khr_id
3911: AND STM.ID = STEM.STM_ID

Line 3915: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3911: AND STM.ID = STEM.STM_ID
3912: AND STEM.DATE_BILLED IS NOT NULL;
3913: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3914: SELECT SUM(amount)
3915: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3916: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3917: WHERE STM.STY_ID = l_stream_type_id
3918: AND STM.KLE_ID = l_kle_id
3919: AND STM.KHR_ID = l_khr_id

Line 3916: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP

3912: AND STEM.DATE_BILLED IS NOT NULL;
3913: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3914: SELECT SUM(amount)
3915: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3916: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3917: WHERE STM.STY_ID = l_stream_type_id
3918: AND STM.KLE_ID = l_kle_id
3919: AND STM.KHR_ID = l_khr_id
3920: AND STM.ID = STEM.STM_ID

Line 4066: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4062: -- MGAAP end 7263041
4063:
4064: -- Expense Adjustment
4065: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
4066: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4067: 'INSURANCE_PAYABLE',
4068: l_return_status,
4069: l_strm_type_id);
4070: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4097: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4093:
4094: IF ((l_total_paid IS NULL ) OR (l_total_paid = OKC_API.G_MISS_NUM )) THEN
4095: l_total_paid := 0;
4096: END IF ;
4097: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4098: 'INSURANCE_EXPENSE_ACCRUAL',
4099: l_return_status,
4100: l_strm_type_id);
4101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4136: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4132: l_adjustment_amount := l_total_paid - l_total_pay_accrued - l_vendor_refund_amount;
4133:
4134: -- MGAAP start 7263041
4135: IF (l_multi_gaap_yn = 'Y') THEN
4136: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4137: 'INSURANCE_EXPENSE_ACCRUAL',
4138: l_return_status,
4139: l_strm_type_id_rep);
4140: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4141: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4137: 'INSURANCE_EXPENSE_ACCRUAL',
4138: l_return_status,
4139: l_strm_type_id_rep);
4140: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4141: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4142: OPEN c_total_payment_accrued(l_ipyv_rec.KHR_ID , l_ipyv_rec.KLE_ID,l_strm_type_id_rep);
4143: FETCH c_total_payment_accrued INTO l_total_pay_accrued_rep;
4144: CLOSE c_total_payment_accrued ;
4145:

Line 4156: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

4152: END IF ;
4153: l_adjustment_amount_rep := l_total_paid - l_total_pay_accrued_rep - l_vendor_refund_amount;
4154: END IF;
4155: END IF;
4156: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
4157: -- MGAAP start 7263041
4158:
4159: /* Start Bug#5955320
4160: --gboomina Bug 4885759 - Start - Changing the transaction type from Insurance to Accrual

Line 4274: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4270: END IF ;
4271: CLOSE salesP_csr;
4272: --smoduga..Bug 4493213 fix..01-aug-2005..end
4273:
4274: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4275: 'INSURANCE_EXPENSE_ACCRUAL',
4276: l_return_status,
4277: l_strm_type_id);
4278: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4360: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4356:
4357: --Start Bug#5955320
4358: IF (l_adjustment_amount <> 0 ) THEN
4359:
4360: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4361: 'INSURANCE_EXPENSE_ACCRUAL',
4362: l_return_status,
4363: l_inc_sty_id);
4364: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4431: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

4427:
4428: IF (l_multi_gaap_yn = 'Y') THEN
4429: IF (l_adjustment_amount_rep <> 0 ) THEN
4430:
4431: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
4432: 'INSURANCE_EXPENSE_ACCRUAL',
4433: l_return_status,
4434: l_inc_sty_id_rep);
4435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4794: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4790: CLOSE okl_trx_types;
4791:
4792: --Added by kthiruva on 17-Oct-2005
4793: --Bug 4667686 - Start of Changes
4794: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4795: 'INSURANCE_RECEIVABLE',
4796: l_return_status,
4797: l_strm_rcvbl_id);
4798: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4811: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4807:
4808: IF l_cust_refund_amount > 0 THEN -- [a]
4809: --negate refund amount
4810: l_pro_refund_amount := -(l_cust_refund_amount);
4811: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4812: 'INSURANCE_REFUND',
4813: l_return_status,
4814: l_strm_refund_id);
4815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5926: FROM OKL_STREAMS STM,

5922:
5923: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5924: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
5925: SELECT SUM(amount)
5926: FROM OKL_STREAMS STM,
5927: OKL_STRM_ELEMENTS STEM
5928: where STM.STY_ID = l_stream_type_id
5929: AND STM.KLE_ID = l_kle_id
5930: AND STM.KHR_ID = l_khr_id

Line 5937: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5933:
5934: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5935: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
5936: SELECT SUM(amount)
5937: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5938: WHERE STM.STY_ID = l_stream_type_id
5939: AND STM.KLE_ID = l_kle_id
5940: AND STM.KHR_ID = l_khr_id
5941: AND STM.ID = STEM.STM_ID

Line 5947: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5943:
5944: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5945: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
5946: SELECT SUM(amount)
5947: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5948: WHERE STM.STY_ID = l_stream_type_id
5949: AND STM.KLE_ID = l_kle_id
5950: AND STM.KHR_ID = l_khr_id
5951: AND STM.ID = STEM.STM_ID

Line 5959: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5955: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5956:
5957: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
5958: SELECT SUM(amount)
5959: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5960: WHERE STM.STY_ID = l_stream_type_id
5961: AND STM.KLE_ID = l_kle_id
5962: AND STM.KHR_ID = l_khr_id
5963: AND STM.ID = STEM.STM_ID

Line 6035: OKL_STREAMS STR

6031: -- Cursor to get the maximum billed date for insurance recievables
6032: Cursor rcvbl_max_billed_date (c_sty_id NUMBER, c_khr_id NUMBER, c_kle_id NUMBER) IS
6033: SELECT max (stre.date_billed)
6034: FROM okl_strm_elements STRE,
6035: OKL_STREAMS STR
6036: WHERE STR.ID = STRE.STM_ID
6037: AND STR.STY_ID = c_sty_id
6038: AND STRE.DATE_BILLED IS NOT NULL
6039: AND STR.KHR_ID = c_khr_id

Line 6110: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6106: -- Start Fix for 3845998
6107: -- Checking for profile OKL:Maximum number of months allowed after payment for refund
6108:
6109: -- procedure call added for insurance user defined streams, bug 3924300
6110: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6111: 'INSURANCE_RECEIVABLE',
6112: l_return_status,
6113: l_strm_type_id);
6114:

Line 6283: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6279:
6280: -- procedure call added to get the stream type id, user defined streams
6281: -- bug 3924300
6282:
6283: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6284: 'INSURANCE_INCOME_ACCRUAL',
6285: l_return_status,
6286: l_strm_type_id);
6287:

Line 6466: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6462:
6463: /* Bug#5955320
6464: -- cursor fetch replaced with the call to get the stream type id
6465: -- changes done for user defined streams, bug 3924300
6466: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6467: 'INSURANCE_INCOME_ACCRUAL',
6468: l_return_status,
6469: l_inc_sty_id);
6470:

Line 6571: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6567: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
6568:
6569: -- call added to get the stream type id, changes done for user defined streams
6570: -- bug 3924300
6571: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6572: 'INSURANCE_PAYABLE',
6573: l_return_status,
6574: l_strm_type_id);
6575:

Line 6600: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6596:
6597: /* Bug#5955320
6598: -- call added to get the stream type id, changes done for user defined streams
6599: -- bug 3924300
6600: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6601: 'INSURANCE_EXPENSE_ACCRUAL',
6602: l_return_status,
6603: l_strm_type_id);
6604:

Line 6698: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6694: /* Bug#5955320
6695: -- cursor fetch to get the stream type id replaced with the call,
6696: -- changed for insurance user defined streams, bug 3924300
6697:
6698: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6699: 'INSURANCE_EXPENSE_ACCRUAL',
6700: l_return_status,
6701: l_inc_sty_id);
6702:

Line 7120: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

7116: CLOSE C_OKL_STRM_TYPE_V;*/
7117: -- cursor fetch replaced with the procedure call to get the stream type id,
7118: -- changes done for user defined streams, bug 3924300
7119:
7120: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
7121: 'INSURANCE_RECEIVABLE',
7122: l_return_status,
7123: l_strm_type_id);
7124:

Line 7152: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

7148:
7149: -- call added to get the stream type id,
7150: -- changes done for user defined streams, bug 3924300
7151:
7152: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
7153: 'INSURANCE_REFUND',
7154: l_return_status,
7155: l_strm_refund_id);
7156: