APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_TRX_CONTRACTS

Line 3915: i_taiv_rec.tcn_id := NULL; -- OKL_TRX_CONTRACTS

3911: ----------------------------------------------------------------------------------
3912: i_taiv_rec.svf_id := NULL;
3913: i_taiv_rec.cra_id := NULL; -- OKL_CURE_REP_AMTS_V
3914: i_taiv_rec.qte_id := NULL; -- OKL_TRX_QUOTES_V
3915: i_taiv_rec.tcn_id := NULL; -- OKL_TRX_CONTRACTS
3916: i_taiv_rec.ipy_id := NULL; -- OKL_INS_POLICIES_V
3917: i_taiv_rec.tap_id := NULL; -- OKL_TRX_AP_INVOICES_V
3918:
3919: ----------------------------------------------------------------------------------

Line 4212: FROM OKL_TRX_CONTRACTS

4208:
4209: CURSOR c_get_source_trx_id (c_trx_id NUMBER)
4210: IS
4211: SELECT SOURCE_TRX_ID
4212: FROM OKL_TRX_CONTRACTS
4213: WHERE ID=c_trx_id;
4214:
4215: CURSOR c_check_if_ppd (c_trx_id NUMBER)
4216: IS

Line 4218: FROM OKL_TRX_CONTRACTS

4214:
4215: CURSOR c_check_if_ppd (c_trx_id NUMBER)
4216: IS
4217: SELECT ID
4218: FROM OKL_TRX_CONTRACTS
4219: WHERE ID=c_trx_id
4220: AND TCN_TYPE='PPD';
4221:
4222:

Line 6661: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

6657:
6658: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
6659: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
6660: i NUMBER := 1;
6661: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
6662:
6663: CURSOR c_obj_vers_csr (a_id NUMBER)
6664: IS
6665: SELECT dnz_khr_id

Line 6724: --Create the PPD Transaction in OKL_TRX_CONTRACTS

6720: ,l_trqv_rec.request_status_code;
6721:
6722: CLOSE c_obj_vers_csr;
6723:
6724: --Create the PPD Transaction in OKL_TRX_CONTRACTS
6725: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6726: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before call to okl_transaction_pvt.create_ppd_transaction');
6727: END IF;
6728: okl_transaction_pvt.create_ppd_transaction(

Line 7127: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

7123: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7124:
7125: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
7126: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
7127: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7128: l_out_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7129:
7130: CURSOR c_obj_vers_csr (a_id NUMBER)
7131: IS

Line 7128: l_out_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

7124:
7125: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
7126: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
7127: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7128: l_out_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7129:
7130: CURSOR c_obj_vers_csr (a_id NUMBER)
7131: IS
7132: SELECT id

Line 7331: --Create the LPD Transaction in OKL_TRX_CONTRACTS

7327: ,l_trqv_rec.paydown_type;
7328:
7329: CLOSE c_obj_vers_csr;
7330:
7331: --Create the LPD Transaction in OKL_TRX_CONTRACTS
7332: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before call to okl_transaction_pvt.create_ppd_transaction');
7334: END IF;
7335: l_try_id := NULL;

Line 7372: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');

7368: l_tcnv_rec.currency_code := con_header_rec.currency_code;
7369: END LOOP;
7370:
7371: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7372: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');
7373: END IF;
7374: -- Create Transaction Header only
7375: okl_trx_contracts_pub.create_trx_contracts(
7376: p_api_version => 1.0,

Line 7375: okl_trx_contracts_pub.create_trx_contracts(

7371: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7372: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');
7373: END IF;
7374: -- Create Transaction Header only
7375: okl_trx_contracts_pub.create_trx_contracts(
7376: p_api_version => 1.0,
7377: p_init_msg_list => p_init_msg_list,
7378: x_return_status => x_return_status,
7379: x_msg_count => x_msg_count,

Line 7386: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');

7382: x_tcnv_rec => l_out_tcnv_rec
7383: );
7384:
7385: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7386: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
7387: END IF;
7388:
7389: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7390: RAISE OKC_API.G_EXCEPTION_ERROR;