APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_TRX_CONTRACTS

Line 17: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

13:
14: --Bug# 4212626
15: G_INSURANCE_LSE_ID CONSTANT NUMBER := 47;
16:
17: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
18: SUBTYPE stmv_rec_type IS OKL_STREAMS_PUB.stmv_rec_type;
19: SUBTYPE stmv_tbl_type IS OKL_STREAMS_PUB.stmv_tbl_type;
20: SUBTYPE selv_rec_type IS OKL_STREAMS_PUB.selv_rec_type;
21: SUBTYPE selv_tbl_type IS OKL_STREAMS_PUB.selv_tbl_type;

Line 3569: FROM okl_trx_contracts

3565: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3566: SELECT trx_number,
3567: rbr_code,
3568: date_transaction_occurred
3569: FROM okl_trx_contracts
3570: WHERE khr_id = p_chr_id
3571: AND tcn_type = 'TRBK'
3572: AND tsu_code = 'ENTERED'
3573: AND representation_type = 'PRIMARY'; -- MGAAP 7263041

Line 3605: l_trx_date okl_trx_contracts.date_transaction_occurred%TYPE;

3601: l_cplv_rec cplv_rec_type;
3602: x_cplv_rec cplv_rec_type;
3603:
3604: l_cle_id OKC_K_LINES_B.ID%TYPE;
3605: l_trx_date okl_trx_contracts.date_transaction_occurred%TYPE;
3606:
3607: l_rgpv_rec rgpv_rec_type;
3608: x_rgpv_rec rgpv_rec_type;
3609: l_rulv_rec rulv_rec_type;

Line 5365: FROM OKL_TRX_CONTRACTS

5361: x_update_klev_tbl klev_tbl_type;
5362:
5363: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
5364: SELECT id
5365: FROM OKL_TRX_CONTRACTS
5366: WHERE khr_id_new = p_chr_id_new
5367: AND representation_type = 'PRIMARY'; -- MGAAP 7263041
5368:
5369: BEGIN

Line 5840: FROM okl_trx_contracts

5836: l_api_version CONSTANT NUMBER := 1;
5837:
5838: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5839: SELECT date_transaction_occurred
5840: FROM okl_trx_contracts
5841: WHERE khr_id = p_chr_id
5842: AND tcn_type = 'TRBK'
5843: AND tsu_code = 'ENTERED'
5844: AND representation_type = 'PRIMARY'; -- MGAAP 7263041

Line 6127: okl_trx_contracts ktrx,

6123: cursor l_rbk_trx_csr(p_chr_id IN NUMBER) is
6124: SELECT ktrx.date_transaction_occurred,ktrx.id,
6125: khr.multi_gaap_yn, pdt.reporting_pdt_id -- MGAAP 7263041
6126: FROM okc_k_headers_b CHR,
6127: okl_trx_contracts ktrx,
6128: okl_k_headers khr,
6129: okl_products pdt
6130: WHERE ktrx.khr_id_new = chr.id
6131: AND ktrx.tsu_code = 'ENTERED'

Line 6145: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041

6141:
6142: l_rbk_trx_rec l_rbk_trx_csr%ROWTYPE;
6143: l_inv_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
6144: l_inv_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
6145: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041
6146: -- Bug# 4775555: End
6147:
6148: BEGIN
6149: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 6738: okl_trx_contracts ktrx

6734:
6735: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
6736: SELECT '!',chr.orig_system_id1, ktrx.id
6737: FROM okc_k_headers_b chr,
6738: okl_trx_contracts ktrx
6739: WHERE ktrx.khr_id_new = chr.id
6740: AND ktrx.tsu_code = 'ENTERED'
6741: AND ktrx.rbr_code is NOT NULL
6742: AND ktrx.tcn_type = 'TRBK'

Line 6750: okl_trx_contracts ktrx

6746:
6747: CURSOR chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
6748: SELECT '!', ktrx.id
6749: FROM okc_k_headers_b chr,
6750: okl_trx_contracts ktrx
6751: WHERE chr.id = p_chr_id
6752: AND ktrx.khr_id = chr.id
6753: AND ktrx.tsu_code = 'ENTERED'
6754: AND ktrx.rbr_code IS NOT NULL

Line 7880: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;

7876:
7877: l_selv_count NUMBER;
7878:
7879: i NUMBER;
7880: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;
7881: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
7882: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
7883: l_gl_date DATE;
7884:

Line 8250: --lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;

8246:
8247: l_selv_count NUMBER;
8248:
8249: i NUMBER;
8250: --lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;
8251: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
8252: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
8253: l_gl_date DATE;
8254:

Line 9032: okl_trx_contracts ktrx,

9028:
9029: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
9030: SELECT '!', ktrx.id
9031: FROM okc_k_headers_b chr,
9032: okl_trx_contracts ktrx,
9033: okc_k_headers_b cpy_chr
9034: WHERE ktrx.khr_id = chr.id
9035: AND ktrx.khr_id_new = cpy_chr.id
9036: AND ktrx.tsu_code = 'ENTERED'

Line 9047: okl_trx_contracts ktrx

9043:
9044: CURSOR chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
9045: SELECT '!', ktrx.id
9046: FROM okc_k_headers_b chr,
9047: okl_trx_contracts ktrx
9048: WHERE chr.id = p_chr_id
9049: AND ktrx.khr_id = chr.id
9050: AND ktrx.tsu_code = 'ENTERED'
9051: AND ktrx.rbr_code IS NOT NULL