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 4206: lp_klev_rec okl_kle_pvt.klev_rec_type;

4202: l_new_no_of_periods NUMBER;
4203: l_new_fee_amount NUMBER;
4204: l_new_idc_amount NUMBER;
4205:
4206: lp_klev_rec okl_kle_pvt.klev_rec_type;
4207: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4208:
4209: lx_klev_rec okl_kle_pvt.klev_rec_type;
4210: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4209: lx_klev_rec okl_kle_pvt.klev_rec_type;

4205:
4206: lp_klev_rec okl_kle_pvt.klev_rec_type;
4207: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
4208:
4209: lx_klev_rec okl_kle_pvt.klev_rec_type;
4210: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4211:
4212: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4213: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

Line 4216: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

4212: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4213: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4214: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4215:
4216: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4217: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4218: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4219:
4220: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

Line 4217: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

4213: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
4214: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4215:
4216: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4217: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4218: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4219:
4220: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4221: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;

Line 4218: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;

4214: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
4215:
4216: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4217: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
4218: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
4219:
4220: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4221: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4222:

Line 4225: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

4221: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
4222:
4223: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4224: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4225: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4226: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4227: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4228: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4229:

Line 4226: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

4222:
4223: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
4224: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4225: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4226: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4227: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4228: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4229:
4230: l_subline_present VARCHAR2(1);

Line 5452: lp_klev_rec okl_kle_pvt.klev_rec_type;

5448: l_new_no_of_periods NUMBER;
5449: l_new_service_amount NUMBER;
5450: l_per_period_amount NUMBER;
5451:
5452: lp_klev_rec okl_kle_pvt.klev_rec_type;
5453: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5454:
5455: lx_klev_rec okl_kle_pvt.klev_rec_type;
5456: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 5455: lx_klev_rec okl_kle_pvt.klev_rec_type;

5451:
5452: lp_klev_rec okl_kle_pvt.klev_rec_type;
5453: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
5454:
5455: lx_klev_rec okl_kle_pvt.klev_rec_type;
5456: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5457:
5458: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5459: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;

Line 5462: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

5458: lp_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5459: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5460: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5461:
5462: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5463: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5464: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5465:
5466: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;

Line 5463: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;

5459: lx_sub_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
5460: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5461:
5462: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5463: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5464: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5465:
5466: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5467: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;

Line 5464: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;

5460: lp_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
5461:
5462: lp_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5463: lx_sub_klev_tbl okl_kle_pvt.klev_tbl_type;
5464: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5465:
5466: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5467: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5468: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

Line 5468: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;

5464: lp_sub_klev_rec okl_kle_pvt.klev_rec_type;
5465:
5466: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5467: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5468: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5469: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5470: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5471: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5472:

Line 5469: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

5465:
5466: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5467: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5468: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5469: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5470: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5471: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5472:
5473: l_subline_present VARCHAR2(1);

Line 6690: lp_klev_rec okl_kle_pvt.klev_rec_type;

6686:
6687: lp_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6688: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
6689:
6690: lp_klev_rec okl_kle_pvt.klev_rec_type;
6691: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6692:
6693: lx_klev_rec okl_kle_pvt.klev_rec_type;
6694: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6693: lx_klev_rec okl_kle_pvt.klev_rec_type;

6689:
6690: lp_klev_rec okl_kle_pvt.klev_rec_type;
6691: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
6692:
6693: lx_klev_rec okl_kle_pvt.klev_rec_type;
6694: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6695:
6696: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
6697: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

Line 6697: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;

6693: lx_klev_rec okl_kle_pvt.klev_rec_type;
6694: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
6695:
6696: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
6697: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
6698: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
6699:
6700: --Bug# 3950089
6701: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

Line 7263: lp_klev_rec okl_kle_pvt.klev_rec_type;

7259: AND tcl.tcn_id = p_taa_trx_id
7260: AND tcl.kle_id = cle.orig_system_id1
7261: AND tcl.before_transfer_yn = 'N';
7262:
7263: lp_klev_rec okl_kle_pvt.klev_rec_type;
7264: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7265:
7266: lx_klev_rec okl_kle_pvt.klev_rec_type;
7267: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 7266: lx_klev_rec okl_kle_pvt.klev_rec_type;

7262:
7263: lp_klev_rec okl_kle_pvt.klev_rec_type;
7264: lp_clev_rec okl_okc_migration_pvt.clev_rec_type;
7265:
7266: lx_klev_rec okl_kle_pvt.klev_rec_type;
7267: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
7268:
7269: CURSOR txl_asset_csr(p_chr_id IN NUMBER,
7270: p_cle_id IN NUMBER) IS