1913: x_msg_count OUT NOCOPY NUMBER,
1914: x_msg_data OUT NOCOPY VARCHAR2,
1915: p_fee_types_rec IN fee_types_rec_type,
1916: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
1917: x_klev_rec OUT NOCOPY okl_kle_pvt.klev_rec_type,
1918: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,
1919: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
1920:
1921: l_api_name CONSTANT VARCHAR2(30) := 'fill_fee_type_info';
2170: x_return_status OUT NOCOPY VARCHAR2,
2171: x_msg_count OUT NOCOPY NUMBER,
2172: x_msg_data OUT NOCOPY VARCHAR2,
2173: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
2174: p_klev_rec IN okl_kle_pvt.klev_rec_type,
2175: p_cimv_rec IN okl_okc_migration_pvt.cimv_rec_type,
2176: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
2177: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
2178: x_klev_rec OUT NOCOPY okl_kle_pvt.klev_rec_type,
2174: p_klev_rec IN okl_kle_pvt.klev_rec_type,
2175: p_cimv_rec IN okl_okc_migration_pvt.cimv_rec_type,
2176: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
2177: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
2178: x_klev_rec OUT NOCOPY okl_kle_pvt.klev_rec_type,
2179: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,
2180: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
2181:
2182: l_clev_rec okl_okc_migration_pvt.clev_rec_type := p_clev_rec;
2179: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,
2180: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
2181:
2182: l_clev_rec okl_okc_migration_pvt.clev_rec_type := p_clev_rec;
2183: l_klev_rec okl_kle_pvt.klev_rec_type := p_klev_rec;
2184: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type := p_cimv_rec;
2185: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type := p_cplv_rec;
2186:
2187: l_chr_id l_clev_rec.dnz_chr_id%type;
2344:
2345: lp_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type := p_fee_types_rec;
2346: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2347:
2348: lp_klev_rec okl_kle_pvt.klev_rec_type;
2349: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
2350: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2351: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2352:
2349: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
2350: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2351: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2352:
2353: lx_klev_rec okl_kle_pvt.klev_rec_type;
2354: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2355: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2356: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2357:
2489: x_return_status OUT NOCOPY VARCHAR2,
2490: x_msg_count OUT NOCOPY NUMBER,
2491: x_msg_data OUT NOCOPY VARCHAR2,
2492: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
2493: p_klev_rec IN okl_kle_pvt.klev_rec_type,
2494: p_cimv_rec IN okl_okc_migration_pvt.cimv_rec_type,
2495: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
2496: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
2497: x_klev_rec OUT NOCOPY okl_kle_pvt.klev_rec_type,
2493: p_klev_rec IN okl_kle_pvt.klev_rec_type,
2494: p_cimv_rec IN okl_okc_migration_pvt.cimv_rec_type,
2495: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
2496: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
2497: x_klev_rec OUT NOCOPY okl_kle_pvt.klev_rec_type,
2498: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,
2499: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
2500:
2501: l_clev_rec okl_okc_migration_pvt.clev_rec_type := p_clev_rec;
2498: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,
2499: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
2500:
2501: l_clev_rec okl_okc_migration_pvt.clev_rec_type := p_clev_rec;
2502: l_klev_rec okl_kle_pvt.klev_rec_type := p_klev_rec;
2503: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type := p_cimv_rec;
2504: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type := p_cplv_rec;
2505:
2506: l_chr_id l_clev_rec.dnz_chr_id%type;
2522: WHERE cle.cle_id = p_cle_id
2523: AND cle.dnz_chr_id = p_chr_id;
2524:
2525: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
2526: l_sub_klev_rec okl_kle_pvt.klev_rec_type;
2527:
2528: x_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
2529: x_sub_klev_rec okl_kle_pvt.klev_rec_type;
2530:
2525: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
2526: l_sub_klev_rec okl_kle_pvt.klev_rec_type;
2527:
2528: x_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
2529: x_sub_klev_rec okl_kle_pvt.klev_rec_type;
2530:
2531: BEGIN
2532:
2533: l_chr_id := l_clev_rec.dnz_chr_id;
2780:
2781: lp_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type := p_fee_types_rec;
2782: lx_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
2783:
2784: lp_klev_rec okl_kle_pvt.klev_rec_type;
2785: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
2786: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2787: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2788:
2785: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
2786: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2787: lp_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2788:
2789: lx_klev_rec okl_kle_pvt.klev_rec_type;
2790: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2791: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2792: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2793:
3065: p_fee_types_rec IN fee_types_rec_type
3066: ) IS
3067:
3068: l_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3069: l_klev_rec okl_kle_pvt.klev_rec_type ;
3070: x_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3071: x_klev_rec okl_kle_pvt.klev_rec_type ;
3072:
3073: l_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3067:
3068: l_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3069: l_klev_rec okl_kle_pvt.klev_rec_type ;
3070: x_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3071: x_klev_rec okl_kle_pvt.klev_rec_type ;
3072:
3073: l_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3074: l_sl_klev_rec okl_kle_pvt.klev_rec_type ;
3075: x_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3070: x_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3071: x_klev_rec okl_kle_pvt.klev_rec_type ;
3072:
3073: l_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3074: l_sl_klev_rec okl_kle_pvt.klev_rec_type ;
3075: x_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3076: x_sl_klev_rec okl_kle_pvt.klev_rec_type ;
3077:
3078: l_chr_id l_clev_rec.dnz_chr_id%type;
3072:
3073: l_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3074: l_sl_klev_rec okl_kle_pvt.klev_rec_type ;
3075: x_sl_clev_rec okl_okc_migration_pvt.clev_rec_type ;
3076: x_sl_klev_rec okl_kle_pvt.klev_rec_type ;
3077:
3078: l_chr_id l_clev_rec.dnz_chr_id%type;
3079: l_line_id l_clev_rec.dnz_chr_id%type;
3080: