18:
19: IS
20: -- Code can be commented for billing transaction- HKPATEL
21: /*
22: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
23: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
24: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
25: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
26: */
19: IS
20: -- Code can be commented for billing transaction- HKPATEL
21: /*
22: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
23: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
24: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
25: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
26: */
27: -- Commented code for billing transaction ends here- HKPATEL
20: -- Code can be commented for billing transaction- HKPATEL
21: /*
22: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
23: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
24: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
25: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
26: */
27: -- Commented code for billing transaction ends here- HKPATEL
28:
21: /*
22: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
23: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;
24: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
25: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;
26: */
27: -- Commented code for billing transaction ends here- HKPATEL
28:
29: l_khrv_rec_in OKL_CONTRACT_PUB.khrv_rec_type;
699: l_int_calc_upto DATE;
700: l_contract_start_date DATE;
701: l_period_name VARCHAR2(10);
702:
703: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
704: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
705: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
706: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
707: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
700: l_contract_start_date DATE;
701: l_period_name VARCHAR2(10);
702:
703: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
704: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
705: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
706: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
707: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
708: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
701: l_period_name VARCHAR2(10);
702:
703: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
704: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
705: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
706: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
707: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
708: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
709: l_khrv_tbl_out OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
702:
703: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
704: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
705: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
706: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
707: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
708: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
709: l_khrv_tbl_out OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
710:
982:
983: l_clev_tbl_in OKL_OKC_MIGRATION_PVT.clev_tbl_type;
984: l_clev_tbl_out OKL_OKC_MIGRATION_PVT.clev_tbl_type;
985:
986: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
987: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
988: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
989: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
990:
983: l_clev_tbl_in OKL_OKC_MIGRATION_PVT.clev_tbl_type;
984: l_clev_tbl_out OKL_OKC_MIGRATION_PVT.clev_tbl_type;
985:
986: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
987: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
988: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
989: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
990:
991: -- Cursor for getting the last calculation date
984: l_clev_tbl_out OKL_OKC_MIGRATION_PVT.clev_tbl_type;
985:
986: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
987: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
988: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
989: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
990:
991: -- Cursor for getting the last calculation date
992:
985:
986: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
987: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
988: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
989: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
990:
991: -- Cursor for getting the last calculation date
992:
993: CURSOR cont_head_csr IS