APPS.OKL_CONTRACT_PVT dependencies on OKL_TRX_CONTRACTS

Line 541: FROM okl_trx_contracts ktrx

537:
538: --Bug# 2691029 : Cursor to find out Rebook date
539: Cursor rbk_date_csr (rbk_chr_id IN NUMBER) is
540: SELECT DATE_TRANSACTION_OCCURRED
541: FROM okl_trx_contracts ktrx
542: WHERE ktrx.KHR_ID_NEW = rbk_chr_id
543: AND ktrx.tsu_code = 'ENTERED'
544: --AND ktrx.rbr_code IS NOT NULL
545: AND ktrx.tcn_type = 'TRBK'

Line 550: l_rbk_date okl_trx_contracts.DATE_TRANSACTION_OCCURRED%TYPE;

546: --rkuttiya added for 12.1.1 Multi GAAP Project
547: AND ktrx.representation_type = 'PRIMARY';
548: --
549:
550: l_rbk_date okl_trx_contracts.DATE_TRANSACTION_OCCURRED%TYPE;
551:
552: --Bug# 2691029: Cursor to find out the original start date of contract being rebooked
553: Cursor orig_date_csr(rbk_chr_id IN NUMBER) is
554: Select orig.start_date,

Line 1355: FROM okl_trx_contracts ktrx

1351:
1352: --Cursor to find out Rebook date
1353: Cursor rbk_date_csr (rbk_chr_id IN NUMBER) is
1354: SELECT DATE_TRANSACTION_OCCURRED
1355: FROM okl_trx_contracts ktrx
1356: WHERE ktrx.KHR_ID_NEW = rbk_chr_id
1357: AND ktrx.tsu_code = 'ENTERED'
1358: AND ktrx.tcn_type = 'TRBK'
1359: --rkuttiya added for 12.1.1 Multi GAAP

Line 1363: l_rbk_date okl_trx_contracts.DATE_TRANSACTION_OCCURRED%TYPE default Null;

1359: --rkuttiya added for 12.1.1 Multi GAAP
1360: AND ktrx.representation_type = 'PRIMARY';
1361: --
1362:
1363: l_rbk_date okl_trx_contracts.DATE_TRANSACTION_OCCURRED%TYPE default Null;
1364: begin
1365: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1366: l_clev_rec := p_clev_rec;
1367:

Line 4253: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

4249: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT';
4250: l_chrv_rec2 OKC_CONTRACT_PUB.chrv_rec_type;
4251: l_chrv_rec chrv_rec_type;
4252: l_khrv_rec khrv_rec_type;
4253: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4254: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 4254: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

4250: l_chrv_rec2 OKC_CONTRACT_PUB.chrv_rec_type;
4251: l_chrv_rec chrv_rec_type;
4252: l_khrv_rec khrv_rec_type;
4253: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4254: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4258:

Line 4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

4252: l_khrv_rec khrv_rec_type;
4253: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4254: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4258:
4259: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4260: l_contract_number okc_k_headers_b.contract_number%type;

Line 4290: FROM OKL_TRX_CONTRACTS

4286: WHERE khr_id = p_khr_id;
4287:
4288: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4289: SELECT id trx_id
4290: FROM OKL_TRX_CONTRACTS
4291: WHERE khr_id = p_khr_id
4292: AND representation_type = 'PRIMARY';
4293:
4294: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

Line 4740: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(

4736: END IF;
4737: -- Deleting the transctions of the journal Entries
4738: FOR r_get_je_trans IN c_get_je_trans(p_khr_id => p_contract_id) LOOP
4739: r_tcnv_rec.id := r_get_je_trans.trx_id;
4740: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
4741: p_api_version => p_api_version,
4742: p_init_msg_list => p_init_msg_list,
4743: x_return_status => x_return_status,
4744: x_msg_count => x_msg_count,