DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STREAMS_PUB

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