DBA Data[Home] [Help]

APPS.OKL_INTEREST_CALC_PVT dependencies on OKL_TRX_CONTRACTS

Line 22: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;

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: */

Line 23: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.TCNV_REC_TYPE;

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

Line 24: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;

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:

Line 25: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.TCLV_TBL_TYPE;

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;

Line 74: l_currency_code okl_trx_contracts.currency_code%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:

Line 75: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;

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

Line 76: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;

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

Line 77: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;

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

Line 703: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_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;

Line 704: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_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;

Line 705: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_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;

Line 706: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_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:

Line 707: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;

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:

Line 974: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;

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;

Line 986: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_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:

Line 987: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

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

Line 988: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_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
992:

Line 989: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_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:
993: CURSOR cont_head_csr IS