[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT (*)
FROM (SELECT COUNT(*)
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE kle.id = cleb.id
AND cleb.chr_id = chrid
--ndani - 27-Mar-2013 - Bug# 16552978 - Start
AND cleb.dnz_chr_id = chrid
AND cleb.lse_id = 33
AND cleb.sts_code <> 'ABANDONED'
--ndani - 27-Mar-2013 - Bug# 16552978 - End
GROUP BY NVL(kle.re_lease_yn,'N')
);
SELECT DISTINCT NVL(kle.re_lease_yn,'N')
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE kle.id = cleb.id
AND cleb.chr_id = chrid
--ndani - 27-Mar-2013 - Bug# 16552978 - Start
AND cleb.dnz_chr_id = chrid
AND cleb.lse_id = 33
AND cleb.sts_code <> 'ABANDONED';
SELECT 'Y'
FROM okc_k_headers_b CHR
WHERE CHR.ID = p_chr_id
AND NVL (CHR.orig_system_source_code, 'XXXX') = 'OKL_RELEASE';
SELECT 'Y'
FROM okc_k_headers_b CHR
WHERE NVL (CHR.orig_system_source_code, 'XXXX') <> 'OKL_RELEASE'
AND CHR.ID = p_chr_id
AND EXISTS (
SELECT '1'
FROM okc_rules_b rul
WHERE rul.dnz_chr_id = CHR.ID
AND rul.rule_information_category = 'LARLES'
AND NVL (rule_information1, 'N') = 'Y');
SELECT 'Y'
FROM okc_k_headers_b chrb
WHERE chrb.ID = p_chr_id AND chrb.scs_code = 'LEASE';
SELECT khr.deal_type
FROM okc_k_headers_v CHR, okl_k_headers khr
WHERE CHR.ID = khr.ID AND CHR.ID = chrid;
SELECT chrb.template_yn,
khr.template_type_code
FROM okc_k_headers_b chrb, okl_k_headers khr
WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
SELECT chrb.qcl_id
FROM okc_k_headers_b chrb
WHERE chrb.ID = p_chr_id;
okl_contract_status_pub.update_contract_status (l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_passstatus,
p_chr_id
);
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_validate_contract,
p_progress_status => okl_book_controller_pvt.g_prog_sts_complete
);
okl_contract_status_pub.update_contract_status (l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_failstatus,
p_chr_id
);
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_validate_contract,
p_progress_status => okl_book_controller_pvt.g_prog_sts_error
);
okl_checklist_pvt.update_checklist_function
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_checklist_obj_id => p_chr_id
);
SELECT date_transaction_occurred
FROM okl_trx_contracts trx, okl_trx_types_tl trx_type
WHERE trx.khr_id_old = chrid
AND trx.khr_id_new IS NOT NULL
AND trx.tsu_code = 'ENTERED'
AND trx.tcn_type = 'TRBK'
AND trx.rbr_code IS NOT NULL
AND trx_type.NAME = 'Rebook'
--rkuttiya added for 12.1.1 Multi GAAP
AND trx.representation_type = 'PRIMARY'
--
AND trx_type.LANGUAGE = 'US'
AND trx.try_id = trx_type.ID;
SELECT COUNT (*)
FROM (SELECT COUNT(*)
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE kle.id = cleb.id
AND cleb.chr_id = chrid
--ndani - 27-Mar-2013 - Bug# 16552978 - Start
AND cleb.dnz_chr_id = chrid
AND cleb.lse_id = 33
AND cleb.sts_code <> 'ABANDONED'
--ndani - 27-Mar-2013 - Bug# 16552978 - End
GROUP BY NVL(kle.re_lease_yn,'N')
);
SELECT DISTINCT NVL(kle.re_lease_yn,'N')
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE kle.id = cleb.id
AND cleb.chr_id = chrid
--ndani - 27-Mar-2013 - Bug# 16552978 - Start
AND cleb.dnz_chr_id = chrid
AND cleb.lse_id = 33
AND cleb.sts_code <> 'ABANDONED';
SELECT NVL (b.template_yn, 'N') template_yn,
b.orig_system_source_code,
b.orig_system_id1
FROM okc_k_headers_b b
WHERE b.ID = chrid;
SELECT sts_code,
NVL (orig_system_source_code, 'XXX') src_code
FROM okc_k_headers_v
WHERE ID = chrid;
okl_contract_status_pub.update_contract_status (l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
'APPROVED',
p_chr_id
);
okl_contract_status_pub.update_contract_status (l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_failstatus,
p_chr_id
);
SELECT sts_code,
NVL (orig_system_source_code, 'XXX') src_code
FROM okc_k_headers_v
WHERE ID = chrid;
SELECT CHR.template_yn,
khr.template_type_code
FROM okc_k_headers_b CHR, okl_k_headers khr
WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
okl_checklist_pvt.update_checklist_function
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_checklist_obj_id => p_chr_id
);
okl_contract_status_pub.update_contract_status (l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
'APPROVED',
p_chr_id
);
okl_contract_status_pub.update_contract_status (l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_failstatus,
p_chr_id
);
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_submit_contract,
p_progress_status => okl_book_controller_pvt.g_prog_sts_running
);
SELECT sts_code,
NVL (orig_system_source_code, 'XXX') src_code
FROM okc_k_headers_v
WHERE ID = chrid;
SELECT cle.ID,
cle.price_negotiated amount
FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
WHERE cle.lse_id = ls.ID
AND ls.lty_code = ltycode
AND cle.dnz_chr_id = chrid
AND sts.code = cle.sts_code
AND sts.ste_code NOT IN
('HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
SELECT crl.ID slh_id,
crl.object1_id1,
crl.rule_information1,
crl.rule_information2,
crl.rule_information3,
crl.rule_information5,
crl.rule_information6,
crl.rule_information7,
crl.rule_information10
FROM okc_rule_groups_b crg, okc_rules_b crl
WHERE crl.rgp_id = crg.ID
AND crg.rgd_code = rgcode
AND crl.rule_information_category = rlcat
AND crg.dnz_chr_id = chrid
AND NVL (crg.cle_id, -1) = cleid
ORDER BY crl.rule_information1;
SELECT uom_code,
sequence_no,
start_date,
level_periods,
advance_periods,
amount,
invoice_offset_days,
due_arr_yn
FROM oks_stream_levels_b
WHERE dnz_chr_id = chrid AND NVL (cle_id, -1) = cleid
ORDER BY sequence_no;
SELECT schd.date_to_interface
FROM okc_rules_v rule,
okc_rule_groups_v rg,
okc_k_lines_v line,
oks_level_elements_v schd
WHERE rg.ID = rule.rgp_id
AND rg.cle_id = line.ID
AND schd.rul_id = rule.ID
AND line.ID = cleid
--Bug# 3124577:11.5.10 Rule Migration
AND rule.rule_information_category = 'LASLL'
--AND rule.rule_information_category = 'SLL'
AND schd.date_to_interface >= dt
ORDER BY schd.date_to_interface;
SELECT schd.date_to_interface
FROM oks_level_elements_v schd, oks_stream_levels_b strm
WHERE schd.rul_id = strm.ID
AND strm.cle_id = cleid
AND schd.date_to_interface >= dt
ORDER BY schd.date_to_interface;
SELECT object1_id1
FROM okc_k_items
WHERE cle_id = cleid;
SELECT 'Y' y
FROM DUAL
WHERE EXISTS (
SELECT 'Y' y
FROM okl_strm_elements_v ele,
okl_streams_v strm,
okl_strm_type_v strm_type
WHERE strm.kle_id =
p_okl_free_form
--288266273543735169864512904074336514176
AND strm.ID = ele.stm_id
AND strm.sty_id = strm_type.ID
AND strm_type.NAME = 'RENT'
AND strm.say_code = 'CURR'
AND strm.active_yn = 'Y'
AND EXISTS (
SELECT schd.date_to_interface
FROM okc_rules_v rule,
okc_rule_groups_v rg,
okc_k_lines_v line,
oks_level_elements_v schd
WHERE rg.ID = rule.rgp_id
AND rg.cle_id = line.ID
AND schd.rul_id = rule.ID
AND line.ID =
p_oks_cov_prod
-- 288176626842234160596172204397403418752
AND rule.rule_information_category = 'SLL'
AND schd.date_to_interface =
ele.stream_element_date));
SELECT 'Y' y
FROM DUAL
WHERE EXISTS (
SELECT 'Y' y
FROM okl_strm_elements_v ele,
okl_streams_v strm,
okl_strm_type_v strm_type
WHERE strm.kle_id =
p_okl_free_form
--288266273543735169864512904074336514176
AND strm.ID = ele.stm_id
AND strm.sty_id = strm_type.ID
--udhenuko bug 5665097 start Using Stream Type purpose instead of Name
AND strm_type.stream_type_purpose = 'RENT'
--udhenuko bug 5665097 end
AND strm.say_code = 'CURR'
AND strm.active_yn = 'Y'
AND EXISTS (
SELECT schd.date_to_interface
FROM oks_level_elements_v schd,
oks_stream_levels_b strm
WHERE schd.rul_id = strm.ID
AND strm.cle_id = p_oks_cov_prod
AND schd.date_to_interface =
ele.stream_element_date));
SELECT NAME
FROM okl_time_units_v
WHERE id1 = n;
SELECT 'Y'
FROM okc_class_operations
WHERE cls_code = 'SERVICE' AND opn_code = 'CHECK_RULE';
SELECT 'Y'
FROM okl_book_controller_trx
WHERE khr_id = p_khr_id
AND progress_status = 'PENDING'
AND NVL (active_flag, 'N') = 'N';
okl_contract_status_pub.update_contract_status(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
'APPROVED',
p_chr_id );
okl_contract_status_pub.update_contract_status(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_failStatus,
p_chr_id );
SELECT chr_new.orig_system_source_code,
chr_new.orig_system_id1,
chr_old.contract_number
FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
SELECT tcn.ID,
tcn.source_trx_id,
tcn.date_transaction_occurred,
tcn.qte_id
FROM okl_trx_contracts tcn, okl_trx_types_tl try
WHERE tcn.khr_id_old = p_orig_chr_id
AND tcn.khr_id_new = p_new_chr_id
AND tcn_type = 'MAE'
AND tcn.tsu_code <> 'PROCESSED'
AND tcn.try_id = try.ID
--rkuttiya added for 12.1.1 Multi GAAP Project
AND tcn.representation_type = 'PRIMARY'
--
AND try.NAME = 'Release'
AND try.LANGUAGE = 'US';
SELECT fin_ast_cle.ID asset_id,
fab.asset_number asset_number,
fab.current_units current_units
FROM okl_txl_cntrct_lns tcl,
okc_k_lines_b fin_ast_cle,
okc_k_lines_b fa_cle,
okc_line_styles_b fa_lse,
okc_k_items cim,
fa_additions_b fab
WHERE tcl.tcn_id = p_source_trx_id
AND tcl.before_transfer_yn = 'N'
AND fin_ast_cle.chr_id = p_orig_chr_id
AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
AND fin_ast_cle.ID = tcl.kle_id
AND fa_cle.dnz_chr_id = fin_ast_cle.chr_id
AND fa_cle.cle_id = fin_ast_cle.ID
AND fa_cle.lse_id = fa_lse.ID
AND fa_lse.lty_code = 'FIXED_ASSET'
AND cim.cle_id = fa_cle.ID
AND cim.dnz_chr_id = fa_cle.dnz_chr_id
AND fab.asset_id = cim.object1_id1;
SELECT fin_ast_cle.ID asset_id,
fab.asset_number asset_number,
fab.current_units current_units
FROM okc_k_lines_b fin_ast_cle,
okc_k_lines_b fa_cle,
okc_k_headers_b CHR,
okc_line_styles_b fin_ast_lse,
okc_line_styles_b fa_lse,
okc_k_items cim,
fa_additions_b fab
WHERE CHR.ID = p_orig_chr_id
AND fin_ast_cle.chr_id = CHR.ID
AND fin_ast_cle.dnz_chr_id = CHR.ID
AND fin_ast_cle.sts_code = CHR.sts_code
AND fin_ast_cle.lse_id = fin_ast_lse.ID
AND fin_ast_lse.lty_code = 'FREE_FORM1'
AND fa_cle.dnz_chr_id = fin_ast_cle.chr_id
AND fa_cle.cle_id = fin_ast_cle.ID
AND fa_cle.lse_id = fa_lse.ID
AND fa_lse.lty_code = 'FIXED_ASSET'
AND cim.cle_id = fa_cle.ID
AND cim.dnz_chr_id = fa_cle.dnz_chr_id
AND fab.asset_id = cim.object1_id1;
SELECT fin_ast_cle.ID,
fin_ast_cle.sts_code
FROM okl_txl_cntrct_lns tcl, okc_k_lines_b fin_ast_cle
WHERE tcl.tcn_id = p_source_trx_id
AND tcl.before_transfer_yn = 'N'
AND fin_ast_cle.chr_id = p_orig_chr_id
AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
AND fin_ast_cle.ID = tcl.kle_id
AND fin_ast_cle.sts_code <> 'TERMINATED';
SELECT CHR.sts_code
FROM okc_k_headers_b CHR
WHERE ID = p_orig_chr_id;
SELECT quote_number
FROM okl_trx_quotes_b
WHERE ID = p_qte_id;
SELECT complete_transfer_yn
FROM okl_trx_contracts
WHERE ID = p_source_trx_id;
SELECT tmt_status_code
FROM okl_trx_contracts
WHERE qte_id = p_qte_id
AND khr_id = p_khr_id
AND tcn_type IN ('ALT', 'TMT')
--rkuttiya added for 12.1.1 Multi GAAP Project
AND representation_type = 'PRIMARY';
SELECT fin_ast_cle.ID
FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse
WHERE fin_ast_cle.chr_id = p_orig_chr_id
AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
AND fin_ast_cle.lse_id = fin_ast_lse.ID
AND fin_ast_lse.lty_code = 'FREE_FORM1'
AND fin_ast_cle.sts_code = 'TERMINATED';
SELECT tas.ID,
tas.tsu_code,
txl.hold_period_days
FROM okc_k_lines_b fin_ast_cle,
okc_line_styles_b fin_ast_lse,
okl_trx_assets tas,
okl_txl_assets_b txl
WHERE fin_ast_cle.chr_id = p_orig_chr_id
AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
AND fin_ast_cle.lse_id = fin_ast_lse.ID
AND fin_ast_lse.lty_code = 'FREE_FORM1'
AND fin_ast_cle.sts_code = 'TERMINATED'
AND txl.kle_id = fin_ast_cle.ID
AND tas.ID = txl.tas_id
AND tas.tas_type IN ('AMT', 'AUD', 'AUS');
'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'
);
'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'
);
okl_trx_contracts_pub.update_trx_contracts
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
x_tcnv_rec => l_out_tcnv_rec
);
'before okl_trx_assets_pub.update_trx_Ass_h_Def CALL'
);
okl_trx_assets_pub.update_trx_ass_h_def
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thpv_rec => l_tasv_rec,
x_thpv_rec => lx_tasv_rec
);
'AFTER okl_trx_assets_pub.update_trx_Ass_h_Def CALL'
);
SELECT 'Y' what
FROM okc_k_headers_b CHR
WHERE CHR.ID = p_chr_id
AND EXISTS (
SELECT '1'
FROM okl_trx_contracts ktrx
WHERE ktrx.khr_id = CHR.ID
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
--rkuttiya added for 12.1.1 Multi GAAP Project
AND ktrx.representation_type = 'PRIMARY')
--
AND EXISTS (
SELECT '1'
FROM okl_rbk_selected_contract rbk_khr
WHERE rbk_khr.khr_id = CHR.ID
AND rbk_khr.status <> 'PROCESSED');
SELECT CHR.orig_system_source_code,
CHR.start_date,
CHR.template_yn,
CHR.authoring_org_id,
CHR.inv_organization_id,
khr.deal_type,
pdt.ID pid,
NVL (pdt.reporting_pdt_id, -1) report_pdt_id,
CHR.currency_code currency_code,
khr.term_duration term
FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt
WHERE khr.ID = CHR.ID AND CHR.ID = chrid AND khr.pdt_id = pdt.ID(+);
update the creditline contract with total rollover amount
*/
/* Manu 18-Aug-2004 Start
Cursor to get the rollover fee lines for a contract
that is booked for the first time. */
-- nikshah -- Bug # 5484903 Fixed,
-- Changed l_rq_fee_lns_bkg_csr SQL definition
CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
SELECT kle.qte_id
FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
WHERE khr.ID = chrid
AND cleb.dnz_chr_id = khr.ID
AND kle.ID = cleb.ID
AND kle.fee_type = 'ROLLOVER'
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_b okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN
('EXPIRED',
'HOLD',
'CANCELLED',
'TERMINATED',
'ABANDONED'
));
SELECT kle.qte_id
FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
WHERE khr.ID = chrid
AND cleb.dnz_chr_id = khr.ID
AND kle.ID = cleb.ID
AND kle.fee_type = 'ROLLOVER'
AND cleb.orig_system_id1 IS NULL
--This means new Fee Line (top line)
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_b okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN
('EXPIRED',
'HOLD',
'CANCELLED',
'TERMINATED',
'ABANDONED'
));
SELECT '!'
FROM okc_k_headers_b CHR
WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
SELECT 1
FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
WHERE khr.ID = chrid
AND cleb.dnz_chr_id = khr.ID
AND kle.ID = cleb.ID
AND kle.fee_type = 'ROLLOVER'
AND TRUNC (khr.start_date) > SYSDATE
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_b okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN
('EXPIRED',
'HOLD',
'CANCELLED',
'TERMINATED',
'ABANDONED'
));
SELECT 1
FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
WHERE khr.ID = chrid
AND cleb.dnz_chr_id = khr.ID
AND kle.ID = cleb.ID
AND kle.fee_type = 'ROLLOVER'
AND TRUNC (khr.start_date) > SYSDATE
AND cleb.orig_system_id1 IS NULL
--This means new Fee Line (top line)
AND NOT EXISTS (
SELECT 'Y'
FROM okc_statuses_b okcsts
WHERE okcsts.code = cleb.sts_code
AND okcsts.ste_code IN
('EXPIRED',
'HOLD',
'CANCELLED',
'TERMINATED',
'ABANDONED'
));
SELECT '!'
FROM okc_k_headers_b CHR
WHERE CHR.ID = p_chr_id
AND NVL (CHR.orig_system_source_code, 'XXXX') = 'OKL_RELEASE';
SELECT CHR.template_yn,
khr.template_type_code
FROM okc_k_headers_b CHR, okl_k_headers khr
WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
SELECT ktrx.khr_id,
ktrx.date_transaction_occurred
FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
WHERE ktrx.khr_id_new = CHR.ID
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
--rkuttiya added for 12.1.1 Multi GAAP Project
AND ktrx.representation_type = 'PRIMARY'
--
AND CHR.ID = p_chr_id
AND CHR.orig_system_source_code = 'OKL_REBOOK';
SELECT pdt.NAME,
pdt.product_status_code
FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR
WHERE 1 = 1
AND khr.ID = p_chr_id
AND pdt_id = pdt.ID
AND khr.ID = CHR.ID;
update the creditline contract with total rollover amount
*/
l_qte_id := NULL;
update the creditline contract with total rollover amount
*/
l_qte_id := NULL;
okl_contract_status_pub.update_contract_status
(l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_passstatus,
l_chr_for_sts_change
);
okl_contract_status_pub.update_contract_status
(l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_failstatus,
l_chr_for_sts_change
);
okl_contract_status_pub.update_contract_status(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
'CANCELED',
old_rec.ORIG_SYSTEM_ID1 );
SELECT chrb.qcl_id,
stsv.ste_code,
stsv.meaning
FROM okc_k_headers_b chrb, okc_statuses_v stsv
WHERE chrb.ID = p_chr_id
AND chrb.sts_code = stsv.code
AND chrb.scs_code = 'LEASE';
SELECT ID
FROM okc_qa_check_lists_v
WHERE ID = p_qclid;
SELECT '!',
CHR.orig_system_id1,
ktrx.date_transaction_occurred,
ktrx.ID
FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
WHERE ktrx.khr_id_new = CHR.ID
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
--rkuttiya added for 12.1.1 Multi GAAP Project
AND ktrx.representation_type = 'PRIMARY'
--
AND CHR.ID = p_chr_id
AND CHR.orig_system_source_code = 'OKL_REBOOK';
SELECT '!'
FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
WHERE CHR.ID = p_chr_id
AND ktrx.khr_id = CHR.ID
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
-- rkuttiya added for 12.1.1 Multi GAAP Project
AND ktrx.representation_type = 'PRIMARY'
--
AND EXISTS (
SELECT '1'
FROM okl_rbk_selected_contract rbk_khr
WHERE rbk_khr.khr_id = CHR.ID
AND rbk_khr.status <> 'PROCESSED');
SELECT NVL (tax_upfront_yn, 'N')
FROM okl_system_params;
SELECT cle.ID
FROM okc_k_lines_b cle, okl_k_lines kle
WHERE cle.ID = kle.ID
AND cle.dnz_chr_id = p_chr_id
AND cle.chr_id = p_chr_id
AND kle.fee_purpose_code = 'SALESTAX'
AND cle.sts_code <> 'ABANDONED';
okl_maintain_fee_pvt.delete_fee_type
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_fee_types_rec => l_del_fee_types_rec
);
okl_contract_status_pub.update_contract_status
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => 'PASSED',
p_chr_id => p_chr_id
);
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_validate_contract,
p_progress_status => okl_book_controller_pvt.g_prog_sts_complete
);
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_calc_upfront_tax,
p_progress_status => l_upfront_tax_prog_sts
);
SELECT sts_code
FROM okc_k_headers_b
WHERE ID = p_khr_id;
SELECT qte.quote_number
FROM okl_trx_contracts tcn,
okl_trx_types_tl try,
okl_trx_quotes_b qte,
okc_k_headers_b CHR
WHERE tcn.khr_id_old = CHR.orig_system_id1
AND tcn.khr_id_new = CHR.ID
AND tcn_type = 'MAE'
AND tcn.tsu_code <> 'PROCESSED'
AND tcn.try_id = try.ID
--rkuttiya added for 12.1.1 Multi GAAP Project
AND tcn.representation_type = 'PRIMARY'
--
AND try.NAME = 'Release'
AND try.LANGUAGE = 'US'
AND tcn.qte_id = qte.ID
AND CHR.ID = p_khr_id;
SELECT 'Y' mass_rbk_yn
FROM okc_k_headers_b CHR
WHERE CHR.ID = p_chr_id
AND EXISTS (
SELECT '1'
FROM okl_trx_contracts ktrx
WHERE ktrx.khr_id = CHR.ID
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
--rkuttiya added for 12.1.1 Multi GAAP Project
AND ktrx.representation_type = 'PRIMARY')
--
AND EXISTS (
SELECT '1'
FROM okl_rbk_selected_contract rbk_khr
WHERE rbk_khr.khr_id = CHR.ID
AND rbk_khr.status <> 'PROCESSED');
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => okl_api.g_false,
--To retain message stack
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_submit_contract,
p_progress_status => okl_book_controller_pvt.g_prog_sts_complete
);
okl_book_controller_pvt.update_book_controller_trx
(p_api_version => p_api_version,
p_init_msg_list => okl_api.g_false,
--To retain message stack
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_id => p_chr_id,
p_prog_short_name => okl_book_controller_pvt.g_submit_contract,
p_progress_status => okl_book_controller_pvt.g_prog_sts_error
);