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 68: l_currency_code okl_trx_contracts.currency_code%TYPE;

64: -- Added code by HKPATEL ends here
65:
66: -- Added by Santonyr on 27-Nov-2002 for Multi-Currency Changes
67: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
68: l_currency_code okl_trx_contracts.currency_code%TYPE;
69: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
70: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
71: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
72:

Line 69: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;

65:
66: -- Added by Santonyr on 27-Nov-2002 for Multi-Currency Changes
67: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
68: l_currency_code okl_trx_contracts.currency_code%TYPE;
69: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
70: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
71: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
72:
73: --Bug 4622198

Line 70: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;

66: -- Added by Santonyr on 27-Nov-2002 for Multi-Currency Changes
67: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
68: l_currency_code okl_trx_contracts.currency_code%TYPE;
69: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
70: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
71: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
72:
73: --Bug 4622198
74: l_fact_sync_code VARCHAR2(2000);

Line 71: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;

67: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
68: l_currency_code okl_trx_contracts.currency_code%TYPE;
69: l_currency_conversion_type okl_trx_contracts.currency_conversion_type%TYPE;
70: l_currency_conversion_rate okl_trx_contracts.currency_conversion_rate%TYPE;
71: l_currency_conversion_date okl_trx_contracts.currency_conversion_date%TYPE;
72:
73: --Bug 4622198
74: l_fact_sync_code VARCHAR2(2000);
75: l_inv_acct_code VARCHAR2(2000);

Line 322: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRITUB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_contracts ');

318: --Code commeneted by HKPATEL for billing
319: /*
320: IF(IS_DEBUG_PROCEDURE_ON) THEN
321: BEGIN
322: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRITUB.pls call OKL_TRX_CONTRACTS_PUB.create_trx_contracts ');
323: END;
324: END IF;
325: */
326: -- Commented code ends here - HKPATEL

Line 328: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_contracts

324: END IF;
325: */
326: -- Commented code ends here - HKPATEL
327:
328: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_contracts
329:
330: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
331:
332: l_khrv_rec_in.ID := p_khr_id;

Line 853: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

849: l_int_calc_upto DATE;
850: l_contract_start_date DATE;
851: l_period_name VARCHAR2(10);
852:
853: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
854: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
855: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
856: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
857: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;

Line 854: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

850: l_contract_start_date DATE;
851: l_period_name VARCHAR2(10);
852:
853: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
854: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
855: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
856: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
857: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
858: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;

Line 855: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

851: l_period_name VARCHAR2(10);
852:
853: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
854: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
855: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
856: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
857: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
858: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
859: l_khrv_tbl_out OKL_CONTRACT_PUB.KHRV_TBL_TYPE;

Line 856: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

852:
853: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
854: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
855: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
856: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
857: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
858: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
859: l_khrv_tbl_out OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
860:

Line 857: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;

853: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
854: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
855: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
856: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
857: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
858: l_khrv_tbl_in OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
859: l_khrv_tbl_out OKL_CONTRACT_PUB.KHRV_TBL_TYPE;
860:
861:

Line 1123: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;

1119: i NUMBER := 0;
1120:
1121: l_last_calc_date DATE;
1122:
1123: l_description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE;
1124: l_khrv_rec_in OKL_CONTRACT_PUB.khrv_rec_type;
1125: l_khrv_rec_out OKL_CONTRACT_PUB.khrv_rec_type;
1126: l_chrv_rec_in okl_okc_migration_pvt.chrv_rec_type;
1127: l_chrv_rec_out okl_okc_migration_pvt.chrv_rec_type;

Line 1135: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1131:
1132: l_clev_tbl_in OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1133: l_clev_tbl_out OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1134:
1135: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1136: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1137: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1138: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1139:

Line 1136: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1132: l_clev_tbl_in OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1133: l_clev_tbl_out OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1134:
1135: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1136: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1137: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1138: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1139:
1140: -- Cursor for getting the last calculation date

Line 1137: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1133: l_clev_tbl_out OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1134:
1135: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1136: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1137: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1138: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1139:
1140: -- Cursor for getting the last calculation date
1141:

Line 1138: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1134:
1135: l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1136: l_tclv_tbl_in OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1137: l_tcnv_rec_out OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1138: l_tclv_tbl_out OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1139:
1140: -- Cursor for getting the last calculation date
1141:
1142: CURSOR cont_head_csr IS