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_CONTRACT_REBOOK_PVT dependencies on OKC_K_HEADERS_B

Line 2461: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,

2457: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2458: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2459: ) IS
2460:
2461: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,
2462: p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
2463: SELECT rbk.id,
2464: rbk.object1_id1,
2465: rbk.object1_id2,

Line 2462: p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

2458: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2459: ) IS
2460:
2461: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,
2462: p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
2463: SELECT rbk.id,
2464: rbk.object1_id1,
2465: rbk.object1_id2,
2466: rbk.jtot_object1_code,

Line 3624: CURSOR c_fee_rbk_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS

3620:
3621: -- changed the cursor to also include fee lines whose fee purpose code is null
3622: -- so that the same logic is applied to other fee lines while synchronization.
3623: -- changes introduced as part of Rebook Change Control Enhancement (RBCCE) START
3624: CURSOR c_fee_rbk_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS
3625: SELECT okc.id
3626: ,okc.dnz_chr_id
3627: ,item.id item_id
3628: ,item.object1_id1

Line 3682: CURSOR c_fee_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS

3678: --AND partyb.cle_id (+) = okc.id; -- change added for Rebook Change Control Enhancement
3679:
3680: -- get fee top line info and optional supplier info from the original contract
3681: -- cursor added as part of rebook change control enhancement
3682: CURSOR c_fee_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS
3683: SELECT okc.id,
3684: item.id item_id,
3685: item.object1_id1,
3686: item.object1_id2,

Line 5240: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

5236:
5237: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;
5238: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;
5239:
5240: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5241: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5242:
5243: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
5244: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;

Line 5241: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

5237: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;
5238: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;
5239:
5240: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5241: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5242:
5243: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
5244: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
5245: l_new_term OKL_K_HEADERS.TERM_DURATION%TYPE;

Line 6126: FROM okc_k_headers_b CHR,

6122: -- Bug# 4775555: Start
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

Line 6737: FROM okc_k_headers_b chr,

6733: l_api_version CONSTANT NUMBER := 1;
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

Line 6749: FROM okc_k_headers_b chr,

6745: AND ktrx.representation_type = 'PRIMARY'; -- MGAAP 7263041
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'

Line 8673: l_inv_agreement_id OKC_K_HEADERS_B.id%TYPE;

8669:
8670: l_undisb_adj_exists VARCHAR2(30);
8671:
8672: l_disb_adj_sty_id OKL_STRM_TYPE_B.id%TYPE;
8673: l_inv_agreement_id OKC_K_HEADERS_B.id%TYPE;
8674:
8675: BEGIN
8676: IF (G_DEBUG_ENABLED = 'Y') THEN
8677: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 9031: FROM okc_k_headers_b chr,

9027: l_api_version CONSTANT NUMBER := 1;
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

Line 9033: okc_k_headers_b cpy_chr

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'
9037: AND ktrx.rbr_code is NOT NULL

Line 9046: FROM okc_k_headers_b chr,

9042: AND ktrx.representation_type = 'PRIMARY'; -- MGAAP 7263041
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'