eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_TRX_CONTRACTS_PUB

Line 1497: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

1493: p_init_msg_list IN VARCHAR2,
1494: x_return_status OUT NOCOPY VARCHAR2,
1495: x_msg_count OUT NOCOPY NUMBER,
1496: x_msg_data OUT NOCOPY VARCHAR2,
1497: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
1498: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
1499: p_accrual_rec IN accrual_rec_type,
1500: p_stream_tbl IN stream_tbl_type,
1501: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041

Line 1498: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

1494: x_return_status OUT NOCOPY VARCHAR2,
1495: x_msg_count OUT NOCOPY NUMBER,
1496: x_msg_data OUT NOCOPY VARCHAR2,
1497: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
1498: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
1499: p_accrual_rec IN accrual_rec_type,
1500: p_stream_tbl IN stream_tbl_type,
1501: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
1502:

Line 1593: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1589: WHERE kle.id = p_kle_id;
1590:
1591:
1592: --local variables
1593: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1594: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1595: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1596: l_api_version CONSTANT NUMBER := 1.0;
1597: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 1594: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1590:
1591:
1592: --local variables
1593: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1594: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1595: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1596: l_api_version CONSTANT NUMBER := 1.0;
1597: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1598: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

Line 1794: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');

1790: l_tclv_tbl(i).attribute15 := get_line_dff_rec.attribute15;
1791: END LOOP;
1792: END LOOP;
1793:
1794: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
1795: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
1796: WRITE_TO_LOG('===========================================================');
1797: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
1798: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);

Line 1839: Okl_Trx_Contracts_Pub.create_trx_contracts

1835: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
1836: END LOOP;
1837:
1838: -- Call Transaction Public API to insert transaction header and line records
1839: Okl_Trx_Contracts_Pub.create_trx_contracts
1840: (p_api_version => p_api_version
1841: ,p_init_msg_list => p_init_msg_list
1842: ,x_return_status => x_return_status
1843: ,x_msg_count => x_msg_count

Line 2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

2338: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2339: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2340: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2341: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

Line 2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

2339: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2340: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2341: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

Line 2971: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2968: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2969: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2970: l_billing_type VARCHAR2(2000) := NULL;
2971: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2972: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2973: acceleration_streams_csr accelerate_ref_cursor;
2974: l_stream_rec stream_rec;
2975: l_counter NUMBER := 1;

Line 2972: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

2968: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2969: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2970: l_billing_type VARCHAR2(2000) := NULL;
2971: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2972: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2973: acceleration_streams_csr accelerate_ref_cursor;
2974: l_stream_rec stream_rec;
2975: l_counter NUMBER := 1;
2976:

Line 3566: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

3562: p_reverse_rec IN accrual_rec_type,
3563: x_return_status OUT NOCOPY VARCHAR2,
3564: x_msg_count OUT NOCOPY NUMBER,
3565: x_msg_data OUT NOCOPY VARCHAR2,
3566: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3567: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3568: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3569: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3570: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041

Line 3567: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

3563: x_return_status OUT NOCOPY VARCHAR2,
3564: x_msg_count OUT NOCOPY NUMBER,
3565: x_msg_data OUT NOCOPY VARCHAR2,
3566: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3567: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3568: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3569: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3570: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3571: ) IS

Line 3568: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

3564: x_msg_count OUT NOCOPY NUMBER,
3565: x_msg_data OUT NOCOPY VARCHAR2,
3566: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3567: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3568: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3569: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3570: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3571: ) IS
3572:

Line 3569: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

3565: x_msg_data OUT NOCOPY VARCHAR2,
3566: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3567: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3568: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3569: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3570: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3571: ) IS
3572:
3573: -- local variables

Line 3574: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

3570: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3571: ) IS
3572:
3573: -- local variables
3574: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3575: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3576: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3577: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3578: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';

Line 3575: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3571: ) IS
3572:
3573: -- local variables
3574: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3575: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3576: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3577: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3578: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3579: l_api_version CONSTANT NUMBER := 1.0;

Line 3576: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

3572:
3573: -- local variables
3574: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3575: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3576: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3577: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3578: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3579: l_api_version CONSTANT NUMBER := 1.0;
3580: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';

Line 3719: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');

3715: RAISE OKL_API.G_EXCEPTION_ERROR;
3716: END IF;
3717: END IF;
3718:
3719: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
3720: --Call the transaction public api for update
3721: Okl_Trx_Contracts_Pub.update_trx_contracts
3722: (p_api_version => p_api_version,
3723: p_init_msg_list => p_init_msg_list,

Line 3721: Okl_Trx_Contracts_Pub.update_trx_contracts

3717: END IF;
3718:
3719: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
3720: --Call the transaction public api for update
3721: Okl_Trx_Contracts_Pub.update_trx_contracts
3722: (p_api_version => p_api_version,
3723: p_init_msg_list => p_init_msg_list,
3724: x_return_status => x_return_status,
3725: x_msg_count => x_msg_count,

Line 3729: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);

3725: x_msg_count => x_msg_count,
3726: x_msg_data => x_msg_data,
3727: p_tcnv_tbl => l_tcnv_tbl,
3728: x_tcnv_tbl => x_rev_tcnv_tbl);
3729: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);
3730:
3731: -- store the highest degree of error
3732: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
3733: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 3892: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

3888: p_reverse_rec IN accrual_rec_type,
3889: x_return_status OUT NOCOPY VARCHAR2,
3890: x_msg_count OUT NOCOPY NUMBER,
3891: x_msg_data OUT NOCOPY VARCHAR2,
3892: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3893: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3894: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3895: ) IS
3896:

Line 3893: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

3889: x_return_status OUT NOCOPY VARCHAR2,
3890: x_msg_count OUT NOCOPY NUMBER,
3891: x_msg_data OUT NOCOPY VARCHAR2,
3892: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3893: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3894: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3895: ) IS
3896:
3897: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

Line 3897: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3893: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3894: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3895: ) IS
3896:
3897: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3898: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3899:
3900: BEGIN
3901:

Line 3898: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

3894: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3895: ) IS
3896:
3897: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3898: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3899:
3900: BEGIN
3901:
3902: REVERSE_ACCRUALS (

Line 3940: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3936: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3937: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3938: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3939: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3940: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3941: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3942: l_contract_number VARCHAR2(2000);
3943: l_tcn_type VARCHAR2(2000) := p_tcn_type;
3944: l_count1 NUMBER := 1;

Line 3941: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3937: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3938: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3939: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3940: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3941: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3942: l_contract_number VARCHAR2(2000);
3943: l_tcn_type VARCHAR2(2000) := p_tcn_type;
3944: l_count1 NUMBER := 1;
3945: l_count2 NUMBER := 1;

Line 4076: Okl_Trx_Contracts_Pub.update_trx_contracts

4072: END IF;
4073: END IF;
4074:
4075: --Call the transaction public api for update
4076: Okl_Trx_Contracts_Pub.update_trx_contracts
4077: (p_api_version => p_api_version,
4078: p_init_msg_list => p_init_msg_list,
4079: x_return_status => x_return_status,
4080: x_msg_count => x_msg_count,

Line 4177: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

4173: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4174: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4175: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4176: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4177: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4178: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4179: l_count NUMBER := 1;
4180: l_count2 NUMBER := 1;
4181: l_contract_number VARCHAR2(2000);

Line 4178: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

4174: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4175: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4176: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4177: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4178: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4179: l_count NUMBER := 1;
4180: l_count2 NUMBER := 1;
4181: l_contract_number VARCHAR2(2000);
4182:

Line 4292: Okl_Trx_Contracts_Pub.update_trx_contracts

4288: END IF;
4289: END IF;
4290:
4291: --Call the transaction public api for update
4292: Okl_Trx_Contracts_Pub.update_trx_contracts
4293: (p_api_version => p_api_version,
4294: p_init_msg_list => p_init_msg_list,
4295: x_return_status => x_return_status,
4296: x_msg_count => x_msg_count,

Line 4378: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

4374: p_catchup_rec IN accrual_rec_type,
4375: x_return_status OUT NOCOPY VARCHAR2,
4376: x_msg_count OUT NOCOPY NUMBER,
4377: x_msg_data OUT NOCOPY VARCHAR2,
4378: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4379: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4380: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4381: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4382: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041

Line 4379: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4375: x_return_status OUT NOCOPY VARCHAR2,
4376: x_msg_count OUT NOCOPY NUMBER,
4377: x_msg_data OUT NOCOPY VARCHAR2,
4378: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4379: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4380: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4381: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4382: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4383: ) IS

Line 4380: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

4376: x_msg_count OUT NOCOPY NUMBER,
4377: x_msg_data OUT NOCOPY VARCHAR2,
4378: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4379: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4380: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4381: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4382: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4383: ) IS
4384:

Line 4381: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4377: x_msg_data OUT NOCOPY VARCHAR2,
4378: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4379: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4380: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4381: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4382: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4383: ) IS
4384:
4385: -- local variables

Line 4386: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

4382: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4383: ) IS
4384:
4385: -- local variables
4386: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

Line 4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

4383: ) IS
4384:
4385: -- local variables
4386: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

Line 4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

4384:
4385: -- local variables
4386: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

Line 4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4397: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4398: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4399: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4400: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

Line 4526: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');

4522: RAISE OKL_API.G_EXCEPTION_ERROR;
4523: END IF;
4524: END IF;
4525:
4526: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4527: --Call the transaction public api for update
4528: Okl_Trx_Contracts_Pub.update_trx_contracts
4529: (p_api_version => p_api_version,
4530: p_init_msg_list => p_init_msg_list,

Line 4528: Okl_Trx_Contracts_Pub.update_trx_contracts

4524: END IF;
4525:
4526: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4527: --Call the transaction public api for update
4528: Okl_Trx_Contracts_Pub.update_trx_contracts
4529: (p_api_version => p_api_version,
4530: p_init_msg_list => p_init_msg_list,
4531: x_return_status => x_return_status,
4532: x_msg_count => x_msg_count,

Line 4536: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);

4532: x_msg_count => x_msg_count,
4533: x_msg_data => x_msg_data,
4534: p_tcnv_tbl => l_tcnv_tbl,
4535: x_tcnv_tbl => x_rev_tcnv_tbl);
4536: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);
4537:
4538: -- store the highest degree of error
4539: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4540: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 4700: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

4696: p_catchup_rec IN accrual_rec_type,
4697: x_return_status OUT NOCOPY VARCHAR2,
4698: x_msg_count OUT NOCOPY NUMBER,
4699: x_msg_data OUT NOCOPY VARCHAR2,
4700: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4701: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4702: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4703: ) IS
4704:

Line 4701: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4697: x_return_status OUT NOCOPY VARCHAR2,
4698: x_msg_count OUT NOCOPY NUMBER,
4699: x_msg_data OUT NOCOPY VARCHAR2,
4700: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4701: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4702: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4703: ) IS
4704:
4705: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

Line 4705: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

4701: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4702: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4703: ) IS
4704:
4705: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4706: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4707:
4708: BEGIN
4709:

Line 4706: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

4702: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4703: ) IS
4704:
4705: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4706: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4707:
4708: BEGIN
4709:
4710: CATCHUP_ACCRUALS (

Line 4733: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

4729: p_init_msg_list IN VARCHAR2,
4730: x_return_status OUT NOCOPY VARCHAR2,
4731: x_msg_count OUT NOCOPY NUMBER,
4732: x_msg_data OUT NOCOPY VARCHAR2,
4733: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4734: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4735: p_accrual_rec IN accrual_rec_type,
4736: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4737: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041

Line 4734: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4730: x_return_status OUT NOCOPY VARCHAR2,
4731: x_msg_count OUT NOCOPY NUMBER,
4732: x_msg_data OUT NOCOPY VARCHAR2,
4733: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4734: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4735: p_accrual_rec IN accrual_rec_type,
4736: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4737: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
4738:

Line 4763: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

4759: FROM okl_k_headers khr
4760: WHERE khr.id = p_khr_id;
4761:
4762: --local variables
4763: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4764: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4765: l_api_name VARCHAR2(30) := 'CREATE_ACCR_LINE_FORMULA';
4766: l_api_version CONSTANT NUMBER := 1.0;
4767: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;

Line 4764: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

4760: WHERE khr.id = p_khr_id;
4761:
4762: --local variables
4763: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4764: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4765: l_api_name VARCHAR2(30) := 'CREATE_ACCR_LINE_FORMULA';
4766: l_api_version CONSTANT NUMBER := 1.0;
4767: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4768: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

Line 5014: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');

5010: l_tclv_tbl(l_line_number).kle_id := l_asset_rec.id;
5011: END LOOP; --Added by bkatraga for bug 13447258
5012: END LOOP;
5013:
5014: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
5015: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
5016: WRITE_TO_LOG('===========================================================');
5017: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
5018: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);

Line 5059: Okl_Trx_Contracts_Pub.create_trx_contracts

5055: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
5056: END LOOP;
5057:
5058: -- Call Transaction Public API to insert transaction header and line records
5059: Okl_Trx_Contracts_Pub.create_trx_contracts
5060: (p_api_version => p_api_version
5061: ,p_init_msg_list => p_init_msg_list
5062: ,x_return_status => x_return_status
5063: ,x_msg_count => x_msg_count

Line 5237: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');

5233: l_tcnv_rec.amount := l_trx_header_amt;
5234:
5235:
5236: -- update the transaction header and line records with amounts
5237: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
5238: Okl_Trx_Contracts_Pub.update_trx_contracts
5239: (p_api_version => p_api_version
5240: ,p_init_msg_list => p_init_msg_list
5241: ,x_return_status => x_return_status

Line 5238: Okl_Trx_Contracts_Pub.update_trx_contracts

5234:
5235:
5236: -- update the transaction header and line records with amounts
5237: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
5238: Okl_Trx_Contracts_Pub.update_trx_contracts
5239: (p_api_version => p_api_version
5240: ,p_init_msg_list => p_init_msg_list
5241: ,x_return_status => x_return_status
5242: ,x_msg_count => x_msg_count

Line 5248: WRITE_TO_LOG('Return Status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts is '||x_return_status);

5244: ,p_tcnv_rec => l_tcnv_rec
5245: ,p_tclv_tbl => l_tclv_tbl
5246: ,x_tcnv_rec => x_tcnv_rec
5247: ,x_tclv_tbl => x_tclv_tbl );
5248: WRITE_TO_LOG('Return Status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts is '||x_return_status);
5249: -- store the highest degree of error
5250: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
5251: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
5252: -- need to leave

Line 5350: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

5346: p_init_msg_list IN VARCHAR2,
5347: x_return_status OUT NOCOPY VARCHAR2,
5348: x_msg_count OUT NOCOPY NUMBER,
5349: x_msg_data OUT NOCOPY VARCHAR2,
5350: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
5351: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
5352: p_accrual_rec IN accrual_rec_type,
5353: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
5354: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041

Line 5351: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

5347: x_return_status OUT NOCOPY VARCHAR2,
5348: x_msg_count OUT NOCOPY NUMBER,
5349: x_msg_data OUT NOCOPY VARCHAR2,
5350: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
5351: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
5352: p_accrual_rec IN accrual_rec_type,
5353: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
5354: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
5355:

Line 5381: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

5377: FROM okl_k_headers khr
5378: WHERE khr.id = p_khr_id;
5379:
5380: --local variables
5381: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
5382: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
5383: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
5384: l_api_version CONSTANT NUMBER := 1.0;
5385: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;

Line 5382: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

5378: WHERE khr.id = p_khr_id;
5379:
5380: --local variables
5381: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
5382: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
5383: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
5384: l_api_version CONSTANT NUMBER := 1.0;
5385: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
5386: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

Line 5611: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');

5607: l_tclv_tbl(i).currency_code := p_accrual_rec.currency_code;
5608: l_tclv_tbl(i).accrual_rule_yn := p_accrual_rec.accrual_rule_yn;
5609: END LOOP;
5610:
5611: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
5612: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
5613: WRITE_TO_LOG('===========================================================');
5614: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
5615: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);

Line 5656: Okl_Trx_Contracts_Pub.create_trx_contracts

5652: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
5653: END LOOP;
5654:
5655: -- Call Transaction Public API to insert transaction header and line records
5656: Okl_Trx_Contracts_Pub.create_trx_contracts
5657: (p_api_version => p_api_version
5658: ,p_init_msg_list => p_init_msg_list
5659: ,x_return_status => x_return_status
5660: ,x_msg_count => x_msg_count

Line 5832: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');

5828: l_tcnv_rec.amount := l_trx_header_amt;
5829:
5830:
5831: -- update the transaction header and line records with amounts
5832: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
5833: Okl_Trx_Contracts_Pub.update_trx_contracts
5834: (p_api_version => p_api_version
5835: ,p_init_msg_list => p_init_msg_list
5836: ,x_return_status => x_return_status

Line 5833: Okl_Trx_Contracts_Pub.update_trx_contracts

5829:
5830:
5831: -- update the transaction header and line records with amounts
5832: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
5833: Okl_Trx_Contracts_Pub.update_trx_contracts
5834: (p_api_version => p_api_version
5835: ,p_init_msg_list => p_init_msg_list
5836: ,x_return_status => x_return_status
5837: ,x_msg_count => x_msg_count

Line 5843: WRITE_TO_LOG('Return Status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts is '||x_return_status);

5839: ,p_tcnv_rec => l_tcnv_rec
5840: ,p_tclv_tbl => l_tclv_tbl
5841: ,x_tcnv_rec => x_tcnv_rec
5842: ,x_tclv_tbl => x_tclv_tbl );
5843: WRITE_TO_LOG('Return Status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts is '||x_return_status);
5844: -- store the highest degree of error
5845: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
5846: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
5847: -- need to leave

Line 6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;

6136: l_rule_result VARCHAR2(1);
6137: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6138: l_stream_tbl stream_tbl_type;
6139: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

Line 6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

6137: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6138: l_stream_tbl stream_tbl_type;
6139: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6145: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

Line 6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

6138: l_stream_tbl stream_tbl_type;
6139: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6145: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
6146: l_accrual_rec accrual_rec_type;

Line 6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

6139: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6145: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
6146: l_accrual_rec accrual_rec_type;
6147: l_reverse_rec accrual_rec_type;

Line 6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6145: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
6146: l_accrual_rec accrual_rec_type;
6147: l_reverse_rec accrual_rec_type;
6148: l_catchup_rec accrual_rec_type;