DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_KLE_PVT

Line 274: lp_klev_rec okl_kle_pvt.klev_rec_type;

270: AND lse.lty_code ='LINK_USAGE_ASSET'
271: AND okcsts.code = line.sts_code
272: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED');
273:
274: lp_klev_rec okl_kle_pvt.klev_rec_type;
275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
278: lx_klev_rec okl_kle_pvt.klev_rec_type;

Line 277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

273:
274: lp_klev_rec okl_kle_pvt.klev_rec_type;
275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
278: lx_klev_rec okl_kle_pvt.klev_rec_type;
279: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
280:
281: begin

Line 278: lx_klev_rec okl_kle_pvt.klev_rec_type;

274: lp_klev_rec okl_kle_pvt.klev_rec_type;
275: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
276: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
277: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
278: lx_klev_rec okl_kle_pvt.klev_rec_type;
279: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
280:
281: begin
282:

Line 4266: lp_klev_rec okl_kle_pvt.klev_rec_type;

4262: l_new_no_of_periods NUMBER;
4263: l_new_fee_amount NUMBER;
4264: l_new_idc_amount NUMBER;
4265:
4266: lp_klev_rec okl_kle_pvt.klev_rec_type;
4267: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4268:
4269: lx_klev_rec okl_kle_pvt.klev_rec_type;
4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4269: lx_klev_rec okl_kle_pvt.klev_rec_type;

4265:
4266: lp_klev_rec okl_kle_pvt.klev_rec_type;
4267: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4268:
4269: lx_klev_rec okl_kle_pvt.klev_rec_type;
4270: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4271:
4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

Line 4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

4272: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4275:
4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4279:
4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

Line 4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

4273: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4275:
4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4279:
4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

Line 4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;

4274: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4275:
4276: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4277: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4278: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4279:
4280: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4282:

Line 4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

4281: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4282:
4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4288: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4289:

Line 4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

4282:
4283: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4288: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4289:
4290: l_subline_present VARCHAR2(1);

Line 5761: lp_klev_rec okl_kle_pvt.klev_rec_type;

5757: l_new_no_of_periods NUMBER;
5758: l_new_service_amount NUMBER;
5759: l_per_period_amount NUMBER;
5760:
5761: lp_klev_rec okl_kle_pvt.klev_rec_type;
5762: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5763:
5764: lx_klev_rec okl_kle_pvt.klev_rec_type;
5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 5764: lx_klev_rec okl_kle_pvt.klev_rec_type;

5760:
5761: lp_klev_rec okl_kle_pvt.klev_rec_type;
5762: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5763:
5764: lx_klev_rec okl_kle_pvt.klev_rec_type;
5765: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5766:
5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

Line 5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

5767: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5770:
5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;

Line 5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

5768: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5770:
5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

Line 5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;

5769: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5770:
5771: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5772: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

Line 5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

5773: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5780: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5781:

Line 5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

5774:
5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5780: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5781:
5782: l_subline_present VARCHAR2(1);

Line 6999: lp_klev_rec okl_kle_pvt.klev_rec_type;

6995:
6996: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6997: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6998:
6999: lp_klev_rec okl_kle_pvt.klev_rec_type;
7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7001:
7002: lx_klev_rec okl_kle_pvt.klev_rec_type;
7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 7002: lx_klev_rec okl_kle_pvt.klev_rec_type;

6998:
6999: lp_klev_rec okl_kle_pvt.klev_rec_type;
7000: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7001:
7002: lx_klev_rec okl_kle_pvt.klev_rec_type;
7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7004:
7005: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

Line 7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

7002: lx_klev_rec okl_kle_pvt.klev_rec_type;
7003: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7004:
7005: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
7006: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
7007: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
7008:
7009: --Bug# 3950089
7010: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

Line 7583: lp_klev_rec okl_kle_pvt.klev_rec_type;

7579: AND tcl.tcn_id = p_taa_trx_id
7580: AND tcl.kle_id = cle.orig_system_id1
7581: AND tcl.before_transfer_yn = 'N';
7582:
7583: lp_klev_rec okl_kle_pvt.klev_rec_type;
7584: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7585:
7586: lx_klev_rec okl_kle_pvt.klev_rec_type;
7587: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 7586: lx_klev_rec okl_kle_pvt.klev_rec_type;

7582:
7583: lp_klev_rec okl_kle_pvt.klev_rec_type;
7584: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7585:
7586: lx_klev_rec okl_kle_pvt.klev_rec_type;
7587: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7588:
7589: CURSOR txl_asset_csr(p_chr_id IN NUMBER,
7590: p_cle_id IN NUMBER) IS