[Home] [Help]
2185: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2186: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2187: ) IS
2188:
2189: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,
2190: p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
2191: SELECT rbk.id,
2192: rbk.object1_id1,
2193: rbk.object1_id2,
2186: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2187: ) IS
2188:
2189: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,
2190: p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
2191: SELECT rbk.id,
2192: rbk.object1_id1,
2193: rbk.object1_id2,
2194: rbk.jtot_object1_code,
3375:
3376: -- changed the cursor to also include fee lines whose fee purpose code is null
3377: -- so that the same logic is applied to other fee lines while synchronization.
3378: -- changes introduced as part of Rebook Change Control Enhancement (RBCCE) START
3379: CURSOR c_fee_rbk_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS
3380: SELECT okc.id
3381: ,okc.dnz_chr_id
3382: ,item.id item_id
3383: ,item.object1_id1
3435: --AND partyb.cle_id (+) = okc.id; -- change added for Rebook Change Control Enhancement
3436:
3437: -- get fee top line info and optional supplier info from the original contract
3438: -- cursor added as part of rebook change control enhancement
3439: CURSOR c_fee_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS
3440: SELECT okc.id,
3441: item.id item_id,
3442: item.object1_id1,
3443: item.object1_id2,
4342: x_klev_rec klev_rec_type;
4343: x_cimv_rec cimv_rec_type;
4344: x_cplv_rec cplv_rec_type;
4345:
4346: l_orig_service_top_line_id okc_k_headers_b.id%TYPE;
4347:
4348: sync_service_failed EXCEPTION;
4349:
4350: CURSOR c_service_rbk_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS
4346: l_orig_service_top_line_id okc_k_headers_b.id%TYPE;
4347:
4348: sync_service_failed EXCEPTION;
4349:
4350: CURSOR c_service_rbk_csr (cp_chr_id okc_k_headers_b.id%TYPE) IS
4351: SELECT okc.id
4352: ,okc.dnz_chr_id
4353: ,okc.item_description
4354: ,okc.orig_system_id1
4390: AND style.lty_code = 'SOLD_SERVICE'
4391: AND okc.orig_system_id1 IS NOT NULL
4392: AND okc.sts_code <> 'TERMINATED';
4393:
4394: CURSOR c_service_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS
4395: SELECT okc.id,
4396: okc.dnz_chr_id,
4397: okc.line_number,
4398: okc.exception_yn,
4486: AND okc.lse_id = style.id
4487: AND style.lty_code = 'LINK_SERV_ASSET';
4488:
4489: -- Bug#9689536 - Start
4490: CURSOR chk_expense_info (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4491: p_cle_id IN OKC_K_LINES_B.ID%TYPE) IS
4492: SELECT 'Y'
4493: FROM OKC_RULE_GROUPS_B rgp,
4494: OKC_RULES_B rule
5663: --Bug# 5207066
5664: l_temp_klev_tbl klev_tbl_type;
5665:
5666: --Bug# 8652738
5667: CURSOR rebook_new_addon_line_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5668: SELECT line.*,
5669: parent_cle.orig_system_id1 parent_orig_system_id1,
5670: parent_cle.start_date parent_orig_start_date
5671: FROM okl_k_lines_full_v line,
6390:
6391: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6392: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6393:
6394: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6395: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6396:
6397: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
6398: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
6391: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6392: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6393:
6394: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6395: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6396:
6397: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
6398: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
6399: l_new_term OKL_K_HEADERS.TERM_DURATION%TYPE;
7783: -- Bug# 4775555: Start
7784: cursor l_rbk_trx_csr(p_chr_id IN NUMBER) is
7785: SELECT ktrx.date_transaction_occurred,ktrx.id,
7786: khr.multi_gaap_yn, pdt.reporting_pdt_id -- MGAAP 7263041
7787: FROM okc_k_headers_b CHR,
7788: okl_trx_contracts ktrx,
7789: okl_k_headers khr,
7790: okl_products pdt
7791: WHERE ktrx.khr_id_new = chr.id
8402: l_api_version CONSTANT NUMBER := 1;
8403:
8404: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
8405: SELECT '!',chr.orig_system_id1, ktrx.id
8406: FROM okc_k_headers_b chr,
8407: okl_trx_contracts ktrx
8408: WHERE ktrx.khr_id_new = chr.id
8409: AND ktrx.tsu_code = 'ENTERED'
8410: AND ktrx.rbr_code is NOT NULL
8414: AND ktrx.representation_type = 'PRIMARY'; -- MGAAP 7263041
8415:
8416: CURSOR chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
8417: SELECT '!', ktrx.id
8418: FROM okc_k_headers_b chr,
8419: okl_trx_contracts ktrx
8420: WHERE chr.id = p_chr_id
8421: AND ktrx.khr_id = chr.id
8422: AND ktrx.tsu_code = 'ENTERED'
10343:
10344: l_undisb_adj_exists VARCHAR2(30);
10345:
10346: l_disb_adj_sty_id OKL_STRM_TYPE_B.id%TYPE;
10347: l_inv_agreement_id OKC_K_HEADERS_B.id%TYPE;
10348:
10349: BEGIN
10350: IF (G_DEBUG_ENABLED = 'Y') THEN
10351: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
10704:
10705: --get the Online Rebook transaction in ENTERED status for Primary representation
10706: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
10707: SELECT '!', ktrx.id
10708: FROM okc_k_headers_b chr,
10709: okl_trx_contracts ktrx,
10710: okc_k_headers_b cpy_chr
10711: WHERE ktrx.khr_id = chr.id
10712: AND ktrx.khr_id_new = cpy_chr.id
10706: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
10707: SELECT '!', ktrx.id
10708: FROM okc_k_headers_b chr,
10709: okl_trx_contracts ktrx,
10710: okc_k_headers_b cpy_chr
10711: WHERE ktrx.khr_id = chr.id
10712: AND ktrx.khr_id_new = cpy_chr.id
10713: AND ktrx.tsu_code = 'ENTERED'
10714: AND ktrx.rbr_code is NOT NULL --sechawla - added comment: identifies the actual online rebook process transaction.
10724: --sechawla 12-mar-09 MG Impact on Rebook
10725: --get the Online Rebook transaction in Entered status for secondary representation
10726: CURSOR chk_rbk_secondary_csr(p_chr_id IN NUMBER) is
10727: SELECT '!', ktrx.id
10728: FROM okc_k_headers_b chr,
10729: okl_trx_contracts ktrx,
10730: okc_k_headers_b cpy_chr
10731: WHERE ktrx.khr_id = chr.id
10732: AND ktrx.khr_id_new = cpy_chr.id
10726: CURSOR chk_rbk_secondary_csr(p_chr_id IN NUMBER) is
10727: SELECT '!', ktrx.id
10728: FROM okc_k_headers_b chr,
10729: okl_trx_contracts ktrx,
10730: okc_k_headers_b cpy_chr
10731: WHERE ktrx.khr_id = chr.id
10732: AND ktrx.khr_id_new = cpy_chr.id
10733: AND ktrx.tsu_code = 'ENTERED'
10734: AND ktrx.rbr_code is NOT NULL
10740: */
10741: --Get the mass rebook transaction in Entered status for primary representation
10742: CURSOR chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
10743: SELECT '!', ktrx.id
10744: FROM okc_k_headers_b chr,
10745: okl_trx_contracts ktrx
10746: WHERE chr.id = p_chr_id
10747: AND ktrx.khr_id = chr.id
10748: AND ktrx.tsu_code = 'ENTERED'
10760: --sechawla 12-mar-09 MG Impact on Rebook
10761: --get the Mass Rebook transaction in Entered status for secondary representation
10762: CURSOR chk_mass_rbk_secondary_csr (p_chr_id IN NUMBER) IS
10763: SELECT '!', ktrx.id
10764: FROM okc_k_headers_b chr,
10765: okl_trx_contracts ktrx
10766: WHERE chr.id = p_chr_id
10767: AND ktrx.khr_id = chr.id
10768: AND ktrx.tsu_code = 'ENTERED'