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 1110: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR

1106:
1107:
1108: CURSOR C_OKL_CNSLD_AR_STRMB IS
1109: SELECT SUM(STRE.AMOUNT)
1110: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR
1111: WHERE STR.KHR_ID = P_IPYV_REC.KHR_ID
1112: AND STR.KLE_ID = P_IPYV_REC.KLE_ID
1113: AND STR.ID = STRE.STM_ID
1114: AND STRE.DATE_BILLED IS NOT NULL;

Line 1138: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1134: BEGIN
1135:
1136:
1137:
1138: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1139: 'INSURANCE_RECEIVABLE',
1140: l_return_status,
1141: l_strm_type_id);
1142:

Line 1183: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1179: END if ;
1180: CLOSE C_OKL_STRM_TYPE_CRE_V;*/
1181:
1182:
1183: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1184: 'INSURANCE_REFUND',
1185: l_return_status,
1186: l_strm_type_id);
1187:

Line 1587: FROM okl_strm_elements STRE, OKL_STREAMS STR

1583:
1584:
1585: CURSOR c_total_paid(l_stm_type_id NUMBER) IS
1586: SELECT SUM(STRE.AMOUNT)
1587: FROM okl_strm_elements STRE, OKL_STREAMS STR
1588: WHERE STR.ID = STRE.STM_ID
1589: AND STR.STY_ID = l_stm_type_id
1590: AND STRE.DATE_BILLED IS NOT NULL
1591: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 1777: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1773: RAISE OKC_API.G_EXCEPTION_ERROR;
1774: END if ;
1775: CLOSE C_OKL_STRM_TYPE_V;*/
1776: -- cursor fetch replaced with the call to get the stream type id
1777: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1778: 'INSURANCE_PAYABLE',
1779: l_return_status,
1780: l_strm_type_id);
1781: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1803: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1799: IF (ln_premium < l_total_paid) THEN
1800:
1801: -- cursor fetch replaced with the call to get the stream type id
1802: -- changed for use defined streams bug 3924300
1803: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1804: 'INSURANCE_ADJUSTMENT',
1805: l_return_status,
1806: l_strm_type_id);
1807:

Line 1861: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1857: l_to_refund := ln_premium - l_total_paid ;
1858:
1859: -- cursor fetch replaced with the call to get the stream type id
1860: -- changed for user defined sreams, bug 3924300
1861: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1862: 'INSURANCE_PAYABLE',
1863: l_return_status,
1864: l_strm_type_id);
1865:

Line 1974: FROM OKL_STREAMS STM

1970:
1971: --- For Recievables
1972: CURSOR c_okl_strem_rec(l_recv_strm_id NUMBER) IS
1973: SELECT STM.ID
1974: FROM OKL_STREAMS STM
1975: WHERE STM.STY_ID = l_recv_strm_id
1976: AND STM.KLE_ID = p_contract_line
1977: AND STM.KHR_ID = p_contract_id;
1978:

Line 1984: FROM OKL_STREAMS STM

1980:
1981: ---- For accrual
1982: CURSOR c_okl_strem_rec_acc (l_recv_strm_id NUMBER) IS
1983: SELECT STM.ID
1984: FROM OKL_STREAMS STM
1985: WHERE STM.STY_ID = l_recv_strm_id
1986: AND STM.KLE_ID = p_contract_line
1987: AND STM.KHR_ID = p_contract_id
1988: AND STM.PURPOSE_CODE IS NULL;

Line 1994: FROM OKL_STREAMS STM

1990:
1991: ---- For Reporting accrual
1992: CURSOR c_okl_strem_rec_repacc (l_recv_strm_id NUMBER) IS
1993: SELECT STM.ID
1994: FROM OKL_STREAMS STM
1995: WHERE STM.STY_ID = l_recv_strm_id
1996: AND STM.KLE_ID = p_contract_line
1997: AND STM.KHR_ID = p_contract_id
1998: AND STM.PURPOSE_CODE ='REPORT';

Line 2007: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2003: from OKL_STRM_TYPE_TL
2004: where NAME = ls_strm_type
2005: AND LANGUAGE = 'US';
2006:
2007: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2008: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2009:
2010: BEGIN
2011: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2008: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2004: where NAME = ls_strm_type
2005: AND LANGUAGE = 'US';
2006:
2007: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2008: x_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2009:
2010: BEGIN
2011: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2012: G_PKG_NAME,

Line 2037: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2033:
2034: -- cursor fetch replaced with the call to get the stream type id
2035: -- changed for user defined streams, bug 3924300
2036:
2037: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2038: ls_strm_purpose,
2039: l_return_status,
2040: l_recv_strm_id);
2041:

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

2052: OPEN c_okl_strem_rec(l_recv_strm_id);
2053: FETCH c_okl_strem_rec INTO p_stmv_rec.id;
2054: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2055:
2056: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2057: IF(L_DEBUG_ENABLED='Y') THEN
2058: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2059: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2060: END IF;

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

2059: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2060: END IF;
2061: IF(IS_DEBUG_PROCEDURE_ON) THEN
2062: BEGIN
2063: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2064: END;
2065: END IF;
2066: OKL_STREAMS_PUB.update_streams(
2067: p_api_version

Line 2066: OKL_STREAMS_PUB.update_streams(

2062: BEGIN
2063: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2064: END;
2065: END IF;
2066: OKL_STREAMS_PUB.update_streams(
2067: p_api_version
2068: ,p_init_msg_list
2069: ,x_return_status
2070: ,x_msg_count

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

2073: ,x_stmv_rec
2074: );
2075: IF(IS_DEBUG_PROCEDURE_ON) THEN
2076: BEGIN
2077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2078: END;
2079: END IF;
2080: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2081:

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

2076: BEGIN
2077: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2078: END;
2079: END IF;
2080: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2081:
2082: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2083: CLOSE c_okl_strem_rec ;
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2106: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2102:
2103:
2104: -- cursor fetch replaced with the call to get the stream type id
2105: -- changed for user defined streams, bug 3924300
2106: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2107: ls_strm_purpose,
2108: l_return_status,
2109: l_recv_strm_id);
2110:

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

2121: --- For Accrual
2122: OPEN c_okl_strem_rec_acc(l_recv_strm_id);
2123: FETCH c_okl_strem_rec_acc INTO p_stmv_rec.id;
2124: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2125: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2126: IF(IS_DEBUG_PROCEDURE_ON) THEN
2127: BEGIN
2128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2129: END;

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

2124: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2125: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2126: IF(IS_DEBUG_PROCEDURE_ON) THEN
2127: BEGIN
2128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2129: END;
2130: END IF;
2131: OKL_STREAMS_PUB.update_streams(
2132: p_api_version

Line 2131: OKL_STREAMS_PUB.update_streams(

2127: BEGIN
2128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2129: END;
2130: END IF;
2131: OKL_STREAMS_PUB.update_streams(
2132: p_api_version
2133: ,p_init_msg_list
2134: ,x_return_status
2135: ,x_msg_count

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

2138: ,x_stmv_rec
2139: );
2140: IF(IS_DEBUG_PROCEDURE_ON) THEN
2141: BEGIN
2142: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2143: END;
2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2146:

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

2141: BEGIN
2142: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2143: END;
2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2146:
2147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2148: CLOSE c_okl_strem_rec_acc ;
2149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2158: --- For Reporing Accrual
2159: OPEN c_okl_strem_rec_repacc(l_recv_strm_id);
2160: FETCH c_okl_strem_rec_repacc INTO p_stmv_rec.id;
2161: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2162: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2163: IF(IS_DEBUG_PROCEDURE_ON) THEN
2164: BEGIN
2165: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2166: END;

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

2161: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2162: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2163: IF(IS_DEBUG_PROCEDURE_ON) THEN
2164: BEGIN
2165: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2166: END;
2167: END IF;
2168: OKL_STREAMS_PUB.update_streams(
2169: p_api_version

Line 2168: OKL_STREAMS_PUB.update_streams(

2164: BEGIN
2165: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2166: END;
2167: END IF;
2168: OKL_STREAMS_PUB.update_streams(
2169: p_api_version
2170: ,p_init_msg_list
2171: ,x_return_status
2172: ,x_msg_count

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

2175: ,x_stmv_rec
2176: );
2177: IF(IS_DEBUG_PROCEDURE_ON) THEN
2178: BEGIN
2179: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2180: END;
2181: END IF;
2182: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2183:

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

2178: BEGIN
2179: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2180: END;
2181: END IF;
2182: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2183:
2184: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2185: CLOSE c_okl_strem_rec_repacc ;
2186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2208: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2204:
2205: -- cursor fetch replaced with the call to get the stream type id,
2206: -- changed for user defined streams, Bug 3924300
2207:
2208: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2209: ls_strm_purpose,
2210: l_return_status,
2211: l_recv_strm_id);
2212:

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

2221:
2222: OPEN c_okl_strem_rec(l_recv_strm_id);
2223: FETCH c_okl_strem_rec INTO p_stmv_rec.id;
2224: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2225: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2226: IF(IS_DEBUG_PROCEDURE_ON) THEN
2227: BEGIN
2228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2229: END;

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

2224: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2225: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2226: IF(IS_DEBUG_PROCEDURE_ON) THEN
2227: BEGIN
2228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2229: END;
2230: END IF;
2231: OKL_STREAMS_PUB.update_streams(
2232: p_api_version

Line 2231: OKL_STREAMS_PUB.update_streams(

2227: BEGIN
2228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2229: END;
2230: END IF;
2231: OKL_STREAMS_PUB.update_streams(
2232: p_api_version
2233: ,p_init_msg_list
2234: ,x_return_status
2235: ,x_msg_count

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

2238: ,x_stmv_rec
2239: );
2240: IF(IS_DEBUG_PROCEDURE_ON) THEN
2241: BEGIN
2242: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2243: END;
2244: END IF;
2245: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2246:

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

2241: BEGIN
2242: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2243: END;
2244: END IF;
2245: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2246:
2247: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2248: CLOSE c_okl_strem_rec ;
2249: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2272: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2268:
2269: -- cursor fetch replaced with the call to get the stream type id,
2270: -- changed for user defined streams, bug 3924300
2271:
2272: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2273: ls_strm_purpose,
2274: l_return_status,
2275: l_recv_strm_id);
2276:

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

2287: --- For Accrual
2288: OPEN c_okl_strem_rec_acc(l_recv_strm_id);
2289: FETCH c_okl_strem_rec_acc INTO p_stmv_rec.id;
2290: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2291: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2292: IF(IS_DEBUG_PROCEDURE_ON) THEN
2293: BEGIN
2294: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2295: END;

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

2290: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2291: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2292: IF(IS_DEBUG_PROCEDURE_ON) THEN
2293: BEGIN
2294: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2295: END;
2296: END IF;
2297: OKL_STREAMS_PUB.update_streams(
2298: p_api_version

Line 2297: OKL_STREAMS_PUB.update_streams(

2293: BEGIN
2294: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2295: END;
2296: END IF;
2297: OKL_STREAMS_PUB.update_streams(
2298: p_api_version
2299: ,p_init_msg_list
2300: ,x_return_status
2301: ,x_msg_count

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

2304: ,x_stmv_rec
2305: );
2306: IF(IS_DEBUG_PROCEDURE_ON) THEN
2307: BEGIN
2308: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2309: END;
2310: END IF;
2311: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2312:

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

2307: BEGIN
2308: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2309: END;
2310: END IF;
2311: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2312:
2313: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2314: CLOSE c_okl_strem_rec_acc ;
2315: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2325: --- For Reporting Accrual
2326: OPEN c_okl_strem_rec_repacc(l_recv_strm_id);
2327: FETCH c_okl_strem_rec_repacc INTO p_stmv_rec.id;
2328: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2329: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2330: IF(IS_DEBUG_PROCEDURE_ON) THEN
2331: BEGIN
2332: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2333: END;

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

2328: IF(p_stmv_rec.id IS NOT NULL AND p_stmv_rec.id <> OKC_API.G_MISS_NUM) THEN
2329: -- Start of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2330: IF(IS_DEBUG_PROCEDURE_ON) THEN
2331: BEGIN
2332: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2333: END;
2334: END IF;
2335: OKL_STREAMS_PUB.update_streams(
2336: p_api_version

Line 2335: OKL_STREAMS_PUB.update_streams(

2331: BEGIN
2332: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2333: END;
2334: END IF;
2335: OKL_STREAMS_PUB.update_streams(
2336: p_api_version
2337: ,p_init_msg_list
2338: ,x_return_status
2339: ,x_msg_count

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

2342: ,x_stmv_rec
2343: );
2344: IF(IS_DEBUG_PROCEDURE_ON) THEN
2345: BEGIN
2346: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2347: END;
2348: END IF;
2349: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2350:

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

2345: BEGIN
2346: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_STREAMS_PUB.update_streams ');
2347: END;
2348: END IF;
2349: -- End of wraper code generated automatically by Debug code generator for OKL_STREAMS_PUB.update_streams
2350:
2351: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2352: CLOSE c_okl_strem_rec_repacc ;
2353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2782: FROM okl_strm_elements STRE, OKL_STREAMS STR

2778:
2779: --Get total amount paid by the customer
2780: CURSOR c_total_amount_paid (c_sty_id NUMBER,c_contract_id NUMBER,c_contract_line_id NUMBER)IS
2781: SELECT COUNT(*)
2782: FROM okl_strm_elements STRE, OKL_STREAMS STR
2783: WHERE STR.ID = STRE.STM_ID
2784: AND STR.STY_ID = c_sty_id
2785: AND STRE.DATE_BILLED IS NOT NULL
2786: AND STR.KHR_ID = c_contract_id

Line 2919: FROM okl_strm_elements STRE, OKL_STREAMS STR

2915: GROUP BY OINB.IPY_ID;
2916: -- calculate total amount paid to vendor
2917: CURSOR c_total_paid(p_stm_type_id NUMBER) IS
2918: SELECT SUM(STRE.AMOUNT)
2919: FROM okl_strm_elements STRE, OKL_STREAMS STR
2920: WHERE STR.ID = STRE.STM_ID
2921: AND STR.STY_ID = p_stm_type_id
2922: AND STRE.DATE_BILLED IS NOT NULL
2923: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 3059: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3055: ln_premium := li_months * l_total_lessor_premium ;
3056:
3057: -- How much have we paid him
3058: -- cursor fetch replaced with the call to get the stream type id
3059: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3060: 'INSURANCE_PAYABLE',
3061: l_return_status,
3062: l_pay_strm_type_id);
3063: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3082: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3078: END IF ;
3079: ln_refund := l_total_paid - ln_premium ;
3080: pn_refund:= ln_refund;
3081: IF (ln_premium < l_total_paid) THEN -- clawback
3082: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3083: 'INSURANCE_ADJUSTMENT',
3084: l_return_status,
3085: l_Adj_strm_type_id);
3086: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3131: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3127:
3128: ELSIF (ln_premium > l_total_paid) THEN
3129: l_tra_id := OKC_API.G_MISS_NUM ;
3130: l_to_refund := ln_premium - l_total_paid ;
3131: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3132: 'INSURANCE_PAYABLE',
3133: l_return_status,
3134: l_PAY_strm_type_id);
3135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3248: --FROM OKL_STREAMS STM,

3244: l_ins_try_id NUMBER;
3245: l_ipyv_rec ipyv_rec_type;
3246: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3247: SELECT SUM(amount)
3248: --FROM OKL_STREAMS STM,
3249: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041
3250: OKL_STRM_ELEMENTS STEM
3251: where STM.STY_ID = l_stream_type_id
3252: AND STM.KLE_ID = l_kle_id

Line 3249: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041

3245: l_ipyv_rec ipyv_rec_type;
3246: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3247: SELECT SUM(amount)
3248: --FROM OKL_STREAMS STM,
3249: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041
3250: OKL_STRM_ELEMENTS STEM
3251: where STM.STY_ID = l_stream_type_id
3252: AND STM.KLE_ID = l_kle_id
3253: AND STM.KHR_ID = l_khr_id

Line 3259: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3255: AND STEM.DATE_BILLED IS NOT NULL ;
3256: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
3257: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3258: SELECT SUM(amount)
3259: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3260: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041
3261: WHERE STM.STY_ID = l_stream_type_id
3262: AND STM.KLE_ID = l_kle_id
3263: AND STM.KHR_ID = l_khr_id

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

3256: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
3257: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3258: SELECT SUM(amount)
3259: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3260: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041
3261: WHERE STM.STY_ID = l_stream_type_id
3262: AND STM.KLE_ID = l_kle_id
3263: AND STM.KHR_ID = l_khr_id
3264: AND STM.ID = STEM.STM_ID

Line 3391: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3389: RAISE OKC_API.G_EXCEPTION_ERROR;
3390: END IF;
3391: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3392: 'INSURANCE_RECEIVABLE',
3393: l_return_status,
3394: l_strm_type_id);
3395: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3429: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3425: l_multi_gaap_yn, l_reporting_pdt_id;
3426: CLOSE check_csr;
3427: -- MGAAP end 7263041
3428:
3429: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3430: 'INSURANCE_INCOME_ACCRUAL',
3431: l_return_status,
3432: l_strm_type_id);
3433: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3467: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3463:
3464: -- MGAAP start 7263041
3465:
3466: IF (l_multi_gaap_yn = 'Y') THEN
3467: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3468: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3469: 'INSURANCE_INCOME_ACCRUAL',
3470: l_return_status,
3471: l_strm_type_id_rep);

Line 3468: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3464: -- MGAAP start 7263041
3465:
3466: IF (l_multi_gaap_yn = 'Y') THEN
3467: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3468: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3469: 'INSURANCE_INCOME_ACCRUAL',
3470: l_return_status,
3471: l_strm_type_id_rep);
3472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3483: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3479: OPEN c_total_bill_accrued(l_ipyv_rec.KHR_ID , l_ipyv_rec.KLE_ID,l_strm_type_id_rep);
3480: FETCH c_total_bill_accrued INTO l_total_bill_accrued_rep;
3481: CLOSE c_total_bill_accrued ;
3482:
3483: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3484: IF ((l_total_bill_accrued_rep IS NULL ) OR (l_total_bill_accrued_rep = OKC_API.G_MISS_NUM )) THEN
3485: l_total_bill_accrued_rep := 0;
3486: END IF ;
3487:

Line 3703: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3699:
3700: --Start Bug#5955320
3701: IF (l_adjustment_amount <> 0 ) THEN
3702:
3703: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3704: 'INSURANCE_INCOME_ACCRUAL',
3705: l_return_status,
3706: l_inc_sty_id);
3707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3770: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3766:
3767: -- MGAAP start 7263041
3768: IF (l_multi_gaap_yn = 'Y') THEN
3769: IF (l_adjustment_amount_rep <> 0) THEN
3770: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3771: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3772: 'INSURANCE_INCOME_ACCRUAL',
3773: l_return_status,
3774: l_inc_sty_id_rep);

Line 3771: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3767: -- MGAAP start 7263041
3768: IF (l_multi_gaap_yn = 'Y') THEN
3769: IF (l_adjustment_amount_rep <> 0) THEN
3770: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3771: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3772: 'INSURANCE_INCOME_ACCRUAL',
3773: l_return_status,
3774: l_inc_sty_id_rep);
3775: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 3818: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3814: ,p_accrual_rec => l_accrual_rec
3815: ,p_stream_tbl => l_stream_tbl,
3816: p_representation_type => 'SECONDARY');
3817:
3818: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3819: IF(IS_DEBUG_PROCEDURE_ON) THEN
3820: BEGIN
3821: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS ');
3822: END;

Line 3882: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3878: l_ins_try_id NUMBER;
3879: l_ipyv_rec ipyv_rec_type;
3880: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3881: SELECT SUM(amount)
3882: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3883: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3884: WHERE STM.STY_ID = l_stream_type_id
3885: AND STM.KLE_ID = l_kle_id
3886: AND STM.KHR_ID = l_khr_id

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

3879: l_ipyv_rec ipyv_rec_type;
3880: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3881: SELECT SUM(amount)
3882: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3883: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3884: WHERE STM.STY_ID = l_stream_type_id
3885: AND STM.KLE_ID = l_kle_id
3886: AND STM.KHR_ID = l_khr_id
3887: AND STM.ID = STEM.STM_ID

Line 3891: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3887: AND STM.ID = STEM.STM_ID
3888: AND STEM.DATE_BILLED IS NOT NULL;
3889: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3890: SELECT SUM(amount)
3891: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3892: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3893: WHERE STM.STY_ID = l_stream_type_id
3894: AND STM.KLE_ID = l_kle_id
3895: AND STM.KHR_ID = l_khr_id

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

3888: AND STEM.DATE_BILLED IS NOT NULL;
3889: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3890: SELECT SUM(amount)
3891: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3892: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3893: WHERE STM.STY_ID = l_stream_type_id
3894: AND STM.KLE_ID = l_kle_id
3895: AND STM.KHR_ID = l_khr_id
3896: AND STM.ID = STEM.STM_ID

Line 4038: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4034: -- MGAAP end 7263041
4035:
4036: -- Expense Adjustment
4037: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
4038: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4039: 'INSURANCE_PAYABLE',
4040: l_return_status,
4041: l_strm_type_id);
4042: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4069: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4065:
4066: IF ((l_total_paid IS NULL ) OR (l_total_paid = OKC_API.G_MISS_NUM )) THEN
4067: l_total_paid := 0;
4068: END IF ;
4069: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4070: 'INSURANCE_EXPENSE_ACCRUAL',
4071: l_return_status,
4072: l_strm_type_id);
4073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4108: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4104: l_adjustment_amount := l_total_paid - l_total_pay_accrued - l_vendor_refund_amount;
4105:
4106: -- MGAAP start 7263041
4107: IF (l_multi_gaap_yn = 'Y') THEN
4108: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4109: 'INSURANCE_EXPENSE_ACCRUAL',
4110: l_return_status,
4111: l_strm_type_id_rep);
4112: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4113: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4109: 'INSURANCE_EXPENSE_ACCRUAL',
4110: l_return_status,
4111: l_strm_type_id_rep);
4112: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4113: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4114: OPEN c_total_payment_accrued(l_ipyv_rec.KHR_ID , l_ipyv_rec.KLE_ID,l_strm_type_id_rep);
4115: FETCH c_total_payment_accrued INTO l_total_pay_accrued_rep;
4116: CLOSE c_total_payment_accrued ;
4117:

Line 4128: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

4124: END IF ;
4125: l_adjustment_amount_rep := l_total_paid - l_total_pay_accrued_rep - l_vendor_refund_amount;
4126: END IF;
4127: END IF;
4128: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
4129: -- MGAAP start 7263041
4130:
4131: /* Start Bug#5955320
4132: --gboomina Bug 4885759 - Start - Changing the transaction type from Insurance to Accrual

Line 4246: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4242: END IF ;
4243: CLOSE salesP_csr;
4244: --smoduga..Bug 4493213 fix..01-aug-2005..end
4245:
4246: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4247: 'INSURANCE_EXPENSE_ACCRUAL',
4248: l_return_status,
4249: l_strm_type_id);
4250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4332: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4328:
4329: --Start Bug#5955320
4330: IF (l_adjustment_amount <> 0 ) THEN
4331:
4332: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4333: 'INSURANCE_EXPENSE_ACCRUAL',
4334: l_return_status,
4335: l_inc_sty_id);
4336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4402: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

4398:
4399: IF (l_multi_gaap_yn = 'Y') THEN
4400: IF (l_adjustment_amount_rep <> 0 ) THEN
4401:
4402: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
4403: 'INSURANCE_EXPENSE_ACCRUAL',
4404: l_return_status,
4405: l_inc_sty_id_rep);
4406: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4803: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4799: CLOSE okl_trx_types;
4800:
4801: --Added by kthiruva on 17-Oct-2005
4802: --Bug 4667686 - Start of Changes
4803: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4804: 'INSURANCE_RECEIVABLE',
4805: l_return_status,
4806: l_strm_rcvbl_id);
4807: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4820: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4816:
4817: IF l_cust_refund_amount > 0 THEN -- [a]
4818: --negate refund amount
4819: l_pro_refund_amount := -(l_cust_refund_amount);
4820: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4821: 'INSURANCE_REFUND',
4822: l_return_status,
4823: l_strm_refund_id);
4824: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5933: FROM OKL_STREAMS STM,

5929:
5930: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5931: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
5932: SELECT SUM(amount)
5933: FROM OKL_STREAMS STM,
5934: OKL_STRM_ELEMENTS STEM
5935: where STM.STY_ID = l_stream_type_id
5936: AND STM.KLE_ID = l_kle_id
5937: AND STM.KHR_ID = l_khr_id

Line 5944: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

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

Line 5954: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

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

Line 5966: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5962: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5963:
5964: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
5965: SELECT SUM(amount)
5966: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5967: WHERE STM.STY_ID = l_stream_type_id
5968: AND STM.KLE_ID = l_kle_id
5969: AND STM.KHR_ID = l_khr_id
5970: AND STM.ID = STEM.STM_ID

Line 6042: OKL_STREAMS STR

6038: -- Cursor to get the maximum billed date for insurance recievables
6039: Cursor rcvbl_max_billed_date (c_sty_id NUMBER, c_khr_id NUMBER, c_kle_id NUMBER) IS
6040: SELECT max (stre.date_billed)
6041: FROM okl_strm_elements STRE,
6042: OKL_STREAMS STR
6043: WHERE STR.ID = STRE.STM_ID
6044: AND STR.STY_ID = c_sty_id
6045: AND STRE.DATE_BILLED IS NOT NULL
6046: AND STR.KHR_ID = c_khr_id

Line 6117: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6113: -- Start Fix for 3845998
6114: -- Checking for profile OKL:Maximum number of months allowed after payment for refund
6115:
6116: -- procedure call added for insurance user defined streams, bug 3924300
6117: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6118: 'INSURANCE_RECEIVABLE',
6119: l_return_status,
6120: l_strm_type_id);
6121:

Line 6290: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6286:
6287: -- procedure call added to get the stream type id, user defined streams
6288: -- bug 3924300
6289:
6290: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6291: 'INSURANCE_INCOME_ACCRUAL',
6292: l_return_status,
6293: l_strm_type_id);
6294:

Line 6473: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6469:
6470: /* Bug#5955320
6471: -- cursor fetch replaced with the call to get the stream type id
6472: -- changes done for user defined streams, bug 3924300
6473: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6474: 'INSURANCE_INCOME_ACCRUAL',
6475: l_return_status,
6476: l_inc_sty_id);
6477:

Line 6578: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6574: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
6575:
6576: -- call added to get the stream type id, changes done for user defined streams
6577: -- bug 3924300
6578: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6579: 'INSURANCE_PAYABLE',
6580: l_return_status,
6581: l_strm_type_id);
6582:

Line 6607: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6603:
6604: /* Bug#5955320
6605: -- call added to get the stream type id, changes done for user defined streams
6606: -- bug 3924300
6607: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6608: 'INSURANCE_EXPENSE_ACCRUAL',
6609: l_return_status,
6610: l_strm_type_id);
6611:

Line 6705: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6701: /* Bug#5955320
6702: -- cursor fetch to get the stream type id replaced with the call,
6703: -- changed for insurance user defined streams, bug 3924300
6704:
6705: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6706: 'INSURANCE_EXPENSE_ACCRUAL',
6707: l_return_status,
6708: l_inc_sty_id);
6709:

Line 7127: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

7123: CLOSE C_OKL_STRM_TYPE_V;*/
7124: -- cursor fetch replaced with the procedure call to get the stream type id,
7125: -- changes done for user defined streams, bug 3924300
7126:
7127: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
7128: 'INSURANCE_RECEIVABLE',
7129: l_return_status,
7130: l_strm_type_id);
7131:

Line 7159: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

7155:
7156: -- call added to get the stream type id,
7157: -- changes done for user defined streams, bug 3924300
7158:
7159: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
7160: 'INSURANCE_REFUND',
7161: l_return_status,
7162: l_strm_refund_id);
7163: