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_PUB

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 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 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 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 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;