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_MAINTAIN_FEE_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 127: l_cplv_rec OKL_OKC_MIGRATION_PVT.CPLV_REC_TYPE;

123: WHERE cpl_id = p_cpl_id;
124:
125: i NUMBER;
126: j NUMBER;
127: l_cplv_rec OKL_OKC_MIGRATION_PVT.CPLV_REC_TYPE;
128: l_ppydv_tbl ppydv_tbl_type;
129:
130: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PASSTHRU_PARTY';
131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 186: okl_okc_migration_pvt.delete_k_party_role(

182: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
183: -- to delete records in tables
184: -- okc_k_party_roles_b and okl_k_party_roles
185: /*
186: okl_okc_migration_pvt.delete_k_party_role(
187: p_api_version => p_api_version,
188: p_init_msg_list => p_init_msg_list,
189: x_return_status => x_return_status,
190: x_msg_count => x_msg_count,

Line 1916: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

1912: x_return_status OUT NOCOPY VARCHAR2,
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:

Line 1918: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,

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';
1922: l_api_version CONSTANT NUMBER := 1.0;

Line 1919: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS

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';
1922: l_api_version CONSTANT NUMBER := 1.0;
1923: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 2173: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

2169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
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,

Line 2175: p_cimv_rec IN okl_okc_migration_pvt.cimv_rec_type,

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,
2179: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,

Line 2176: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,

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

Line 2177: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

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,
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:

Line 2179: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_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;
2183: l_klev_rec okl_kle_pvt.klev_rec_type := p_klev_rec;

Line 2180: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS

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

Line 2182: l_clev_rec okl_okc_migration_pvt.clev_rec_type := p_clev_rec;

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

Line 2184: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type := p_cimv_rec;

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

Line 2185: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type := p_cplv_rec;

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;
2188:
2189: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_top_line';

Line 2240: okl_okc_migration_pvt.create_contract_item(

2236: END IF;
2237:
2238: l_cimv_rec.cle_id := x_clev_rec.id;
2239:
2240: okl_okc_migration_pvt.create_contract_item(
2241: p_api_version => p_api_version,
2242: p_init_msg_list => p_init_msg_list,
2243: x_return_status => x_return_status,
2244: x_msg_count => x_msg_count,

Line 2264: okl_okc_migration_pvt.create_k_party_role(

2260: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2261: -- to create records in tables
2262: -- okc_k_party_roles_b and okl_k_party_roles
2263: /*
2264: okl_okc_migration_pvt.create_k_party_role(
2265: p_api_version => p_api_version,
2266: p_init_msg_list => p_init_msg_list,
2267: x_return_status => x_return_status,
2268: x_msg_count => x_msg_count,

Line 2349: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

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:
2353: lx_klev_rec okl_kle_pvt.klev_rec_type;

Line 2350: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

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:
2353: lx_klev_rec okl_kle_pvt.klev_rec_type;
2354: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 2351: lp_cplv_rec okl_okc_migration_pvt.cplv_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:
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;

Line 2354: lx_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:
2358: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;

Line 2355: lx_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:
2358: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2359:

Line 2356: lx_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:
2358: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2359:
2360: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_type';

Line 2492: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,

2488: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
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,

Line 2494: p_cimv_rec IN okl_okc_migration_pvt.cimv_rec_type,

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,
2498: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_rec_type,

Line 2495: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,

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

Line 2496: x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,

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,
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:

Line 2498: x_cimv_rec OUT NOCOPY okl_okc_migration_pvt.cimv_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;
2502: l_klev_rec okl_kle_pvt.klev_rec_type := p_klev_rec;

Line 2499: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS

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

Line 2501: l_clev_rec okl_okc_migration_pvt.clev_rec_type := p_clev_rec;

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

Line 2503: l_cimv_rec okl_okc_migration_pvt.cimv_rec_type := p_cimv_rec;

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

Line 2504: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type := p_cplv_rec;

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;
2507:
2508: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_top_line';

Line 2525: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

2521: FROM okc_k_lines_b cle
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;

Line 2528: x_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

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:
2531: BEGIN
2532:

Line 2610: okl_okc_migration_pvt.update_contract_item(

2606: --Bug# 4721428
2607:
2608: l_cimv_rec.cle_id := x_clev_rec.id;
2609:
2610: okl_okc_migration_pvt.update_contract_item(
2611: p_api_version => p_api_version,
2612: p_init_msg_list => p_init_msg_list,
2613: x_return_status => x_return_status,
2614: x_msg_count => x_msg_count,

Line 2635: okl_okc_migration_pvt.create_k_party_role(

2631: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2632: -- to create records in tables
2633: -- okc_k_party_roles_b and okl_k_party_roles
2634: /*
2635: okl_okc_migration_pvt.create_k_party_role(
2636: p_api_version => p_api_version,
2637: p_init_msg_list => p_init_msg_list,
2638: x_return_status => x_return_status,
2639: x_msg_count => x_msg_count,

Line 2668: okl_okc_migration_pvt.update_k_party_role(

2664: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2665: -- to update records in tables
2666: -- okc_k_party_roles_b and okl_k_party_roles
2667: /*
2668: okl_okc_migration_pvt.update_k_party_role(
2669: p_api_version => p_api_version,
2670: p_init_msg_list => p_init_msg_list,
2671: x_return_status => x_return_status,
2672: x_msg_count => x_msg_count,

Line 2703: okl_okc_migration_pvt.delete_k_party_role(

2699: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2700: -- to delete records in tables
2701: -- okc_k_party_roles_b and okl_k_party_roles
2702: /*
2703: okl_okc_migration_pvt.delete_k_party_role(
2704: p_api_version => p_api_version,
2705: p_init_msg_list => p_init_msg_list,
2706: x_return_status => x_return_status,
2707: x_msg_count => x_msg_count,

Line 2785: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;

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:
2789: lx_klev_rec okl_kle_pvt.klev_rec_type;

Line 2786: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

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:
2789: lx_klev_rec okl_kle_pvt.klev_rec_type;
2790: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 2787: lp_cplv_rec okl_okc_migration_pvt.cplv_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:
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;

Line 2790: lx_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:
2794: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;

Line 2791: lx_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:
2794: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2795: l_rgp_id okc_rules_v.id%type := null;

Line 2792: lx_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:
2794: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2795: l_rgp_id okc_rules_v.id%type := null;
2796: l_rul_id okc_rules_v.id%type := null;

Line 3068: l_clev_rec okl_okc_migration_pvt.clev_rec_type ;

3064: x_msg_data OUT NOCOPY VARCHAR2,
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:

Line 3070: x_clev_rec okl_okc_migration_pvt.clev_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 ;
3074: l_sl_klev_rec okl_kle_pvt.klev_rec_type ;

Line 3073: l_sl_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 ;
3076: x_sl_klev_rec okl_kle_pvt.klev_rec_type ;
3077:

Line 3075: x_sl_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;
3079: l_line_id l_clev_rec.dnz_chr_id%type;

Line 3139: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

3135: and cleb.sts_code <> 'ABANDONED';
3136:
3137: l_cov_ast_rec l_cov_ast_csr%ROWTYPE;
3138:
3139: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
3140: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;
3141: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
3142: lx_fin_klev_tbl okl_contract_pub.klev_tbl_type;
3143: i number;

Line 3141: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

3137: l_cov_ast_rec l_cov_ast_csr%ROWTYPE;
3138:
3139: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
3140: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;
3141: lx_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
3142: lx_fin_klev_tbl okl_contract_pub.klev_tbl_type;
3143: i number;
3144: --End Bug# 3877032
3145:

Line 3427: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

3423: p_cle_id IN NUMBER,
3424: p_object1_id1 IN VARCHAR2
3425: ) IS
3426:
3427: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3428: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3429: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3430: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3431:

Line 3428: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

3424: p_object1_id1 IN VARCHAR2
3425: ) IS
3426:
3427: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3428: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3429: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3430: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3431:
3432: l_chr_id okc_k_headers_b.id%type;

Line 3689: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

3685: p_chr_id IN NUMBER,
3686: p_cle_id IN NUMBER
3687: ) IS
3688:
3689: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3690: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3691: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3692: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3693:

Line 3690: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

3686: p_cle_id IN NUMBER
3687: ) IS
3688:
3689: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3690: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3691: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3692: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3693:
3694: l_chr_id okc_k_headers_b.id%type;

Line 3865: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

3861: p_rul_id IN NUMBER
3862:
3863: ) IS
3864:
3865: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3866: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3867: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3868: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3869:

Line 3866: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

3862:
3863: ) IS
3864:
3865: lp_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3866: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3867: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3868: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3869:
3870: l_chr_id okc_k_headers_b.id%type;

Line 4598: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4594:
4595: l_api_name CONSTANT VARCHAR2(30) := 'rollover_fee';
4596: l_api_version CONSTANT NUMBER := 1.0;
4597:
4598: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4599: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4600:
4601: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4602: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 4599: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4595: l_api_name CONSTANT VARCHAR2(30) := 'rollover_fee';
4596: l_api_version CONSTANT NUMBER := 1.0;
4597:
4598: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4599: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4600:
4601: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4602: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4603:

Line 4758: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4754:
4755: l_api_name CONSTANT VARCHAR2(30) := 'rollover_fee';
4756: l_api_version CONSTANT NUMBER := 1.0;
4757:
4758: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4759: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4760:
4761: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4762: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 4759: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

4755: l_api_name CONSTANT VARCHAR2(30) := 'rollover_fee';
4756: l_api_version CONSTANT NUMBER := 1.0;
4757:
4758: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4759: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4760:
4761: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4762: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
4763:

Line 5802: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5798: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5799: l_api_name CONSTANT varchar2(30) := 'create_party';
5800: l_api_version CONSTANT NUMBER := 1.0;
5801:
5802: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5803: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5804: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5805: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5806:

Line 5803: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5799: l_api_name CONSTANT varchar2(30) := 'create_party';
5800: l_api_version CONSTANT NUMBER := 1.0;
5801:
5802: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5803: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5804: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5805: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5806:
5807: Begin

Line 5915: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5911: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5912: l_api_name CONSTANT varchar2(30) := 'update_party';
5913: l_api_version CONSTANT NUMBER := 1.0;
5914:
5915: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5916: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5917: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5918: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5919:

Line 5916: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

5912: l_api_name CONSTANT varchar2(30) := 'update_party';
5913: l_api_version CONSTANT NUMBER := 1.0;
5914:
5915: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5916: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5917: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5918: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5919:
5920: Begin