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 1387: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

1383: p_init_msg_list IN VARCHAR2,
1384: x_return_status OUT NOCOPY VARCHAR2,
1385: x_msg_count OUT NOCOPY NUMBER,
1386: x_msg_data OUT NOCOPY VARCHAR2,
1387: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
1388: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
1389: p_accrual_rec IN accrual_rec_type,
1390: p_stream_tbl IN stream_tbl_type,
1391: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041

Line 1388: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

1384: x_return_status OUT NOCOPY VARCHAR2,
1385: x_msg_count OUT NOCOPY NUMBER,
1386: x_msg_data OUT NOCOPY VARCHAR2,
1387: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
1388: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
1389: p_accrual_rec IN accrual_rec_type,
1390: p_stream_tbl IN stream_tbl_type,
1391: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
1392:

Line 1483: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1479: WHERE kle.id = p_kle_id;
1480:
1481:
1482: --local variables
1483: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1484: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1485: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 1484: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1480:
1481:
1482: --local variables
1483: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1484: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1485: l_api_name VARCHAR2(20) := 'CREATE_ACCRUALS';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1488: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

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

1677: l_tclv_tbl(i).attribute15 := get_line_dff_rec.attribute15;
1678: END LOOP;
1679: END LOOP;
1680:
1681: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
1682: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
1683: WRITE_TO_LOG('===========================================================');
1684: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
1685: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);

Line 1726: Okl_Trx_Contracts_Pub.create_trx_contracts

1722: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
1723: END LOOP;
1724:
1725: -- Call Transaction Public API to insert transaction header and line records
1726: Okl_Trx_Contracts_Pub.create_trx_contracts
1727: (p_api_version => p_api_version
1728: ,p_init_msg_list => p_init_msg_list
1729: ,x_return_status => x_return_status
1730: ,x_msg_count => x_msg_count

Line 2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

Line 2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

Line 2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;
2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2796: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2797: acceleration_streams_csr accelerate_ref_cursor;
2798: l_stream_rec stream_rec;
2799: l_counter NUMBER := 1;

Line 2796: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;
2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2796: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2797: acceleration_streams_csr accelerate_ref_cursor;
2798: l_stream_rec stream_rec;
2799: l_counter NUMBER := 1;
2800:

Line 3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

3316: p_reverse_rec IN accrual_rec_type,
3317: x_return_status OUT NOCOPY VARCHAR2,
3318: x_msg_count OUT NOCOPY NUMBER,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041

Line 3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

3317: x_return_status OUT NOCOPY VARCHAR2,
3318: x_msg_count OUT NOCOPY NUMBER,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS

Line 3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

3318: x_msg_count OUT NOCOPY NUMBER,
3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3326:

Line 3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

3319: x_msg_data OUT NOCOPY VARCHAR2,
3320: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3321: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3322: x_memo_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3323: x_memo_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3326:
3327: -- local variables

Line 3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

3324: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' -- MGAAP 7263041
3325: ) IS
3326:
3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';

Line 3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3325: ) IS
3326:
3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3333: l_api_version CONSTANT NUMBER := 1.0;

Line 3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

3326:
3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3333: l_api_version CONSTANT NUMBER := 1.0;
3334: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';

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

3469: RAISE OKL_API.G_EXCEPTION_ERROR;
3470: END IF;
3471: END IF;
3472:
3473: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
3474: --Call the transaction public api for update
3475: Okl_Trx_Contracts_Pub.update_trx_contracts
3476: (p_api_version => p_api_version,
3477: p_init_msg_list => p_init_msg_list,

Line 3475: Okl_Trx_Contracts_Pub.update_trx_contracts

3471: END IF;
3472:
3473: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
3474: --Call the transaction public api for update
3475: Okl_Trx_Contracts_Pub.update_trx_contracts
3476: (p_api_version => p_api_version,
3477: p_init_msg_list => p_init_msg_list,
3478: x_return_status => x_return_status,
3479: x_msg_count => x_msg_count,

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

3479: x_msg_count => x_msg_count,
3480: x_msg_data => x_msg_data,
3481: p_tcnv_tbl => l_tcnv_tbl,
3482: x_tcnv_tbl => x_rev_tcnv_tbl);
3483: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);
3484:
3485: -- store the highest degree of error
3486: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
3487: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 3646: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

3642: p_reverse_rec IN accrual_rec_type,
3643: x_return_status OUT NOCOPY VARCHAR2,
3644: x_msg_count OUT NOCOPY NUMBER,
3645: x_msg_data OUT NOCOPY VARCHAR2,
3646: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:

Line 3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

3643: x_return_status OUT NOCOPY VARCHAR2,
3644: x_msg_count OUT NOCOPY NUMBER,
3645: x_msg_data OUT NOCOPY VARCHAR2,
3646: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

Line 3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3647: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3652: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3653:
3654: BEGIN
3655:

Line 3652: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

3648: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'
3649: ) IS
3650:
3651: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3652: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
3653:
3654: BEGIN
3655:
3656: REVERSE_ACCRUALS (

Line 3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3690: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3696: l_contract_number VARCHAR2(2000);
3697: l_tcn_type VARCHAR2(2000) := p_tcn_type;
3698: l_count1 NUMBER := 1;

Line 3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3696: l_contract_number VARCHAR2(2000);
3697: l_tcn_type VARCHAR2(2000) := p_tcn_type;
3698: l_count1 NUMBER := 1;
3699: l_count2 NUMBER := 1;

Line 3830: Okl_Trx_Contracts_Pub.update_trx_contracts

3826: END IF;
3827: END IF;
3828:
3829: --Call the transaction public api for update
3830: Okl_Trx_Contracts_Pub.update_trx_contracts
3831: (p_api_version => p_api_version,
3832: p_init_msg_list => p_init_msg_list,
3833: x_return_status => x_return_status,
3834: x_msg_count => x_msg_count,

Line 3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3933: l_count NUMBER := 1;
3934: l_count2 NUMBER := 1;
3935: l_contract_number VARCHAR2(2000);

Line 3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3933: l_count NUMBER := 1;
3934: l_count2 NUMBER := 1;
3935: l_contract_number VARCHAR2(2000);
3936:

Line 4046: Okl_Trx_Contracts_Pub.update_trx_contracts

4042: END IF;
4043: END IF;
4044:
4045: --Call the transaction public api for update
4046: Okl_Trx_Contracts_Pub.update_trx_contracts
4047: (p_api_version => p_api_version,
4048: p_init_msg_list => p_init_msg_list,
4049: x_return_status => x_return_status,
4050: x_msg_count => x_msg_count,

Line 4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

4128: p_catchup_rec IN accrual_rec_type,
4129: x_return_status OUT NOCOPY VARCHAR2,
4130: x_msg_count OUT NOCOPY NUMBER,
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041

Line 4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4129: x_return_status OUT NOCOPY VARCHAR2,
4130: x_msg_count OUT NOCOPY NUMBER,
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS

Line 4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

4130: x_msg_count OUT NOCOPY NUMBER,
4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4138:

Line 4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4131: x_msg_data OUT NOCOPY VARCHAR2,
4132: x_rev_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4133: x_rev_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4134: x_catch_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4135: x_catch_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4138:
4139: -- local variables

Line 4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

4136: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4137: ) IS
4138:
4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

Line 4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

4137: ) IS
4138:
4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

Line 4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

4138:
4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

Line 4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

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

4276: RAISE OKL_API.G_EXCEPTION_ERROR;
4277: END IF;
4278: END IF;
4279:
4280: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4281: --Call the transaction public api for update
4282: Okl_Trx_Contracts_Pub.update_trx_contracts
4283: (p_api_version => p_api_version,
4284: p_init_msg_list => p_init_msg_list,

Line 4282: Okl_Trx_Contracts_Pub.update_trx_contracts

4278: END IF;
4279:
4280: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4281: --Call the transaction public api for update
4282: Okl_Trx_Contracts_Pub.update_trx_contracts
4283: (p_api_version => p_api_version,
4284: p_init_msg_list => p_init_msg_list,
4285: x_return_status => x_return_status,
4286: x_msg_count => x_msg_count,

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

4286: x_msg_count => x_msg_count,
4287: x_msg_data => x_msg_data,
4288: p_tcnv_tbl => l_tcnv_tbl,
4289: x_tcnv_tbl => x_rev_tcnv_tbl);
4290: WRITE_TO_LOG('Return status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||x_return_status);
4291:
4292: -- store the highest degree of error
4293: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4294: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 4454: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,

4450: p_catchup_rec IN accrual_rec_type,
4451: x_return_status OUT NOCOPY VARCHAR2,
4452: x_msg_count OUT NOCOPY NUMBER,
4453: x_msg_data OUT NOCOPY VARCHAR2,
4454: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:

Line 4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4451: x_return_status OUT NOCOPY VARCHAR2,
4452: x_msg_count OUT NOCOPY NUMBER,
4453: x_msg_data OUT NOCOPY VARCHAR2,
4454: x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

Line 4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

4455: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4460: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4461:
4462: BEGIN
4463:

Line 4460: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

4456: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY' --MGAAP 7263041
4457: ) IS
4458:
4459: x_rev_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4460: x_rev_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4461:
4462: BEGIN
4463:
4464: CATCHUP_ACCRUALS (

Line 4485: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

4481: p_init_msg_list IN VARCHAR2,
4482: x_return_status OUT NOCOPY VARCHAR2,
4483: x_msg_count OUT NOCOPY NUMBER,
4484: x_msg_data OUT NOCOPY VARCHAR2,
4485: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4486: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4487: p_accrual_rec IN accrual_rec_type,
4488: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4489: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041

Line 4486: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

4482: x_return_status OUT NOCOPY VARCHAR2,
4483: x_msg_count OUT NOCOPY NUMBER,
4484: x_msg_data OUT NOCOPY VARCHAR2,
4485: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4486: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4487: p_accrual_rec IN accrual_rec_type,
4488: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4489: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
4490:

Line 4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

4512: FROM okl_k_headers khr
4513: WHERE khr.id = p_khr_id;
4514:
4515: --local variables
4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4518: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;

Line 4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

4513: WHERE khr.id = p_khr_id;
4514:
4515: --local variables
4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4518: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

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

4730: l_tclv_tbl(i).currency_code := p_accrual_rec.currency_code;
4731: l_tclv_tbl(i).accrual_rule_yn := p_accrual_rec.accrual_rule_yn;
4732: END LOOP;
4733:
4734: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.create_trx_contracts');
4735: WRITE_TO_LOG('The contents of l_tcnv_rec being passed to the create call ');
4736: WRITE_TO_LOG('===========================================================');
4737: WRITE_TO_LOG('l_tcnv_rec.khr_id :'||l_tcnv_rec.khr_id);
4738: WRITE_TO_LOG('l_tcnv_rec.pdt_id :'||l_tcnv_rec.pdt_id);

Line 4779: Okl_Trx_Contracts_Pub.create_trx_contracts

4775: WRITE_TO_LOG('l_tclv_tbl(i).accrual_rule_yn :'||l_tclv_tbl(i).accrual_rule_yn);
4776: END LOOP;
4777:
4778: -- Call Transaction Public API to insert transaction header and line records
4779: Okl_Trx_Contracts_Pub.create_trx_contracts
4780: (p_api_version => p_api_version
4781: ,p_init_msg_list => p_init_msg_list
4782: ,x_return_status => x_return_status
4783: ,x_msg_count => x_msg_count

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

4951: l_tcnv_rec.amount := l_trx_header_amt;
4952:
4953:
4954: -- update the transaction header and line records with amounts
4955: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4956: Okl_Trx_Contracts_Pub.update_trx_contracts
4957: (p_api_version => p_api_version
4958: ,p_init_msg_list => p_init_msg_list
4959: ,x_return_status => x_return_status

Line 4956: Okl_Trx_Contracts_Pub.update_trx_contracts

4952:
4953:
4954: -- update the transaction header and line records with amounts
4955: WRITE_TO_LOG('Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
4956: Okl_Trx_Contracts_Pub.update_trx_contracts
4957: (p_api_version => p_api_version
4958: ,p_init_msg_list => p_init_msg_list
4959: ,x_return_status => x_return_status
4960: ,x_msg_count => x_msg_count

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

4962: ,p_tcnv_rec => l_tcnv_rec
4963: ,p_tclv_tbl => l_tclv_tbl
4964: ,x_tcnv_rec => x_tcnv_rec
4965: ,x_tclv_tbl => x_tclv_tbl );
4966: WRITE_TO_LOG('Return Status after the call to Okl_Trx_Contracts_Pub.update_trx_contracts is '||x_return_status);
4967: -- store the highest degree of error
4968: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4970: -- need to leave

Line 5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;

5257: l_rule_result VARCHAR2(1);
5258: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

Line 5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

5258: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

Line 5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;

Line 5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;
5268: l_reverse_rec accrual_rec_type;

Line 5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;
5268: l_reverse_rec accrual_rec_type;
5269: l_catchup_rec accrual_rec_type;