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_VARIABLE_INTEREST_PVT dependencies on OKL_TRX_CONTRACTS

Line 6633: l_trxH_in_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;

6629:
6630: l_msg_index_out NUMBER;
6631: l_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
6632: l_set_of_books_id Hr_operating_units.set_of_books_id%TYPE;
6633: l_trxH_in_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6634: l_trxH_out_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6635: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6636: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6637: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;

Line 6634: l_trxH_out_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;

6630: l_msg_index_out NUMBER;
6631: l_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
6632: l_set_of_books_id Hr_operating_units.set_of_books_id%TYPE;
6633: l_trxH_in_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6634: l_trxH_out_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6635: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6636: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6637: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
6638: l_meaning FND_LOOKUPS.meaning%TYPE;

Line 6635: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

6631: l_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
6632: l_set_of_books_id Hr_operating_units.set_of_books_id%TYPE;
6633: l_trxH_in_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6634: l_trxH_out_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6635: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6636: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6637: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
6638: l_meaning FND_LOOKUPS.meaning%TYPE;
6639: l_description FND_LOOKUPS.description%TYPE;

Line 6636: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;

6632: l_set_of_books_id Hr_operating_units.set_of_books_id%TYPE;
6633: l_trxH_in_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6634: l_trxH_out_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6635: l_trxL_in_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6636: l_trxL_out_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6637: l_acc_gen_primary_key_tbl Okl_Account_Generator_Pvt.primary_key_tbl;
6638: l_meaning FND_LOOKUPS.meaning%TYPE;
6639: l_description FND_LOOKUPS.description%TYPE;
6640:

Line 7296: Okl_Trx_Contracts_Pub.create_trx_contracts(

7292: l_trxL_in_tbl(1).amount := p_amount;
7293: l_trxL_in_tbl(1).currency_code := G_CURRENCY_CODE;
7294:
7295: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Contract Transaction.');
7296: Okl_Trx_Contracts_Pub.create_trx_contracts(
7297: p_api_version => l_api_version,
7298: p_init_msg_list => p_init_msg_list,
7299: x_return_status => x_return_status,
7300: x_msg_count => x_msg_count,

Line 7308: print_error_message('Unexpected error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');

7304: x_tcnv_rec => l_trxH_out_rec,
7305: x_tclv_tbl => l_trxL_out_tbl);
7306:
7307: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
7308: print_error_message('Unexpected error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
7309: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
7310: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
7311: print_error_message('Error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
7312: RAISE create_stream_invoice_failed;

Line 7311: print_error_message('Error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');

7307: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
7308: print_error_message('Unexpected error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
7309: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
7310: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
7311: print_error_message('Error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
7312: RAISE create_stream_invoice_failed;
7313: END IF;
7314:
7315: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR

Line 7476: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(

7472: p_stmv_rec => lx_stmv_rec);
7473: END IF;
7474:
7475: IF (l_okl_trx_created = OKL_API.G_TRUE) THEN
7476: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
7477: p_api_version => 1.0,
7478: p_init_msg_list => OKC_API.G_FALSE,
7479: x_return_status => x_return_status,
7480: x_msg_count => x_msg_count,

Line 7523: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(

7519: p_stmv_rec => lx_stmv_rec);
7520: END IF;
7521:
7522: IF (l_okl_trx_created = OKL_API.G_TRUE) THEN
7523: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
7524: p_api_version => 1.0,
7525: p_init_msg_list => OKC_API.G_FALSE,
7526: x_return_status => x_return_status,
7527: x_msg_count => x_msg_count,

Line 7777: okl_trx_contracts ktrx

7773: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
7774: SELECT 'Y' return_value
7775: FROM okc_k_headers_b chrb,
7776: okc_k_headers_b chrb2,
7777: okl_trx_contracts ktrx
7778: WHERE ktrx.khr_id_old = chrb.id
7779: AND ktrx.tsu_code = 'PROCESSED'
7780: AND ktrx.rbr_code IS NOT NULL
7781: AND ktrx.tcn_type = 'TRBK'

Line 7790: AND vpb.source_table = 'OKL_TRX_CONTRACTS'

7786: AND chrb2.orig_system_source_code = 'OKL_REBOOK'
7787: AND chrb2.id = ktrx.khr_id_new
7788: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7789: WHERE vpb.khr_id = chrb.id
7790: AND vpb.source_table = 'OKL_TRX_CONTRACTS'
7791: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7792: AND vpb.source_id = ktrx.id);
7793:
7794: --checks if newly created Daily Interest - Principal stream elements exist

Line 8063: ,'OKL_TRX_CONTRACTS' source_table

8059:
8060: --get the id's of Rebook Transactions
8061: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
8062: SELECT ktrx.id source_id
8063: ,'OKL_TRX_CONTRACTS' source_table
8064: FROM okc_k_headers_b chrb,
8065: okc_k_headers_b chrb2,
8066: okl_trx_contracts ktrx
8067: WHERE ktrx.khr_id_old = chrb.id

Line 8066: okl_trx_contracts ktrx

8062: SELECT ktrx.id source_id
8063: ,'OKL_TRX_CONTRACTS' source_table
8064: FROM okc_k_headers_b chrb,
8065: okc_k_headers_b chrb2,
8066: okl_trx_contracts ktrx
8067: WHERE ktrx.khr_id_old = chrb.id
8068: AND ktrx.tsu_code = 'PROCESSED'
8069: AND ktrx.rbr_code IS NOT NULL
8070: AND ktrx.tcn_type = 'TRBK'

Line 8079: AND vpb.source_table = 'OKL_TRX_CONTRACTS'

8075: AND chrb2.orig_system_source_code = 'OKL_REBOOK'
8076: AND chrb2.id = ktrx.khr_id_new
8077: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8078: WHERE vpb.khr_id = chrb.id
8079: AND vpb.source_table = 'OKL_TRX_CONTRACTS'
8080: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8081: AND vpb.source_id = ktrx.id);
8082:
8083: --get the id's of Daily Interest - Principal stream elements