[Home] [Help]
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;
70: -- Added code by HKPATEL ends here
71:
72: -- Added by Santonyr on 27-Nov-2002 for Multi-Currency Changes
73: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
74: l_currency_code okl_trx_contracts.currency_code%TYPE;
75: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
76: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
77: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
78:
71:
72: -- Added by Santonyr on 27-Nov-2002 for Multi-Currency Changes
73: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
74: l_currency_code okl_trx_contracts.currency_code%TYPE;
75: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
76: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
77: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
78:
79: --Bug 4622198
72: -- Added by Santonyr on 27-Nov-2002 for Multi-Currency Changes
73: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
74: l_currency_code okl_trx_contracts.currency_code%TYPE;
75: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
76: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
77: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
78:
79: --Bug 4622198
80: l_fact_sync_code VARCHAR2(2000);
73: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
74: l_currency_code okl_trx_contracts.currency_code%TYPE;
75: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
76: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
77: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
78:
79: --Bug 4622198
80: l_fact_sync_code VARCHAR2(2000);
81: l_inv_acct_code VARCHAR2(2000);
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:
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:
711:
970: i NUMBER := 0;
971:
972: l_last_calc_date DATE;
973:
974: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
975: l_khrv_rec_in OKL_CONTRACT_PUB.khrv_rec_type;
976: l_khrv_rec_out OKL_CONTRACT_PUB.khrv_rec_type;
977: l_chrv_rec_in okl_okc_migration_pvt.chrv_rec_type;
978: l_chrv_rec_out okl_okc_migration_pvt.chrv_rec_type;
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