[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sts_code, template_yn, application_id, scs_code ,contract_number,
contract_number_modifier, date_terminated
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_code;
SELECT allowed_yn
FROM OKC_ASSENTS_V
WHERE opn_code = 'INVOICE'
AND scs_code = p_code
AND sts_code = p_sts_code;
p_msg_name => 'OKC_NO_UPDATE',
p_token1 => 'CHR',
p_token1_value => l_k);
SELECT template_yn ,sts_code, application_id, scs_code ,contract_number, contract_number_modifier, date_terminated
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT sts_code,dnz_chr_id,line_number , date_terminated
FROM okc_k_lines_b
WHERE id = p_cle_id;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_code;
SELECT allowed_yn
FROM OKC_ASSENTS_V
WHERE opn_code = 'INVOICE'
AND scs_code = p_code
AND sts_code = p_sts_code;
p_msg_name => 'OKC_NO_UPDATE',
p_token1 => 'CHR',
p_token1_value => l_k);
SELECT
STS_CODE,
CONTRACT_NUMBER,
CONTRACT_NUMBER_MODIFIER,
TEMPLATE_YN,
DATE_TERMINATED,
DATE_RENEWED,
APPLICATION_ID,
SCS_CODE
FROM okc_k_headers_b
WHERE id = p_terminate_in_parameters_rec.p_contract_id;
SELECT 'Y'
FROM okc_k_processes v
WHERE v.chr_id = p_terminate_in_parameters_rec.p_contract_id
and v.in_process_yn='Y';
SELECT sts.ste_code,sts.meaning
FROM okc_statuses_v sts
WHERE sts.code = l_code;
SELECT 'x'
FROM okx_incident_statuses_v xis,
okc_k_lines_b cle
WHERE cle.id = xis.contract_service_id
and cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
and xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests
select k.contract_number,k.contract_number_modifier
from okc_k_headers_b k,okc_operation_lines a,
okc_operation_instances b,okc_class_operations c
where k.id=a.subject_chr_id
and a.object_chr_id=p_chr_id and
c.id=b.cop_id and c.opn_code='RENEWAL'
and b.id=a.oie_id and a.active_yn='Y' and
a.subject_cle_id is null and a.object_cle_id is null;
SELECT ID,
OBJECT_VERSION_NUMBER,
sts_code
FROM okc_k_headers_v
WHERE id = p_terminate_in_parameters_rec.p_contract_id
for update of object_version_number nowait;
SELECT STE_CODE
FROM OKC_STATUSES_V
WHERE CODE = p_sts_code;
SELECT cle.id,
cle.lse_id, --added so that we can tell if the line is price hold line
cle.object_version_number,
sts.ste_code,
cle.start_date,
cle.end_date
FROM okc_k_lines_v cle,
okc_statuses_b sts
WHERE cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
AND cle.sts_code = sts.code
AND cle.date_terminated is null
FOR update of line_number nowait;
SELECT cle.id,
cle.object_version_number,
cle.start_date,
cle.end_date
FROM okc_k_lines_b cle,
okc_line_styles_b lse,
okc_statuses_b sts,
okc_k_headers_b k,
okc_assents a,
okc_operations_b opn,
okc_val_line_operations lopn
WHERE cle.chr_id = p_terminate_in_parameters_rec.p_contract_id
and lse.id = cle.lse_id
and lopn.lse_id = cle.lse_id
and lse.lty_code in ('SERVICE','EXT_WARRANTY','USAGE')
and cle.sts_code = sts.code
and sts.ste_code <> 'TERMINATED'
and a.scs_code = k.scs_code
and a.sts_code = cle.sts_code
and a.allowed_yn = 'Y'
and a.opn_code = opn.code
and opn.opn_type = 'LON'
and opn.code = 'INVOICE'
and opn.code = lopn.opn_code
and cle.chr_id = k.id;
SELECT id,object_version_number,date_active,date_inactive
FROM okc_condition_headers_b
WHERE dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
and ( date_inactive > p_terminate_in_parameters_rec.p_termination_date
or date_inactive is null )
FOR update of date_inactive nowait;
SELECT id,object_version_number
FROM okc_change_requests_b crt
WHERE crt.chr_id = p_terminate_in_parameters_rec.p_contract_id
and crt.crs_code = 'ENT' ---Impact on change request status
FOR update of datetime_ineffective nowait;
SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
FROM OKC_K_HEADERS_B K,
OKC_SUBCLASSES_B SCS
WHERE k.id = p_terminate_in_parameters_rec.p_contract_id
AND k.scs_code = scs.code;
SELECT greatest(nvl(co.datetime, cnh.date_active),
p_terminate_in_parameters_rec.p_termination_date )
FROM okc_condition_headers_b cnh,
okc_condition_occurs co
WHERE dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
AND cnh.id = b_cnh_id
AND cnh.id = co.cnh_id (+);
okc_contract_pub.update_contract_header ( p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => okc_api.g_true,
p_chrv_rec => l_chrv_rec,
x_chrv_rec => i_chrv_rec );
OKC_CONTRACT_PUB.update_contract_line ( p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => okc_api.g_true,
p_clev_rec => l_clev_rec,
x_clev_rec => i_clev_rec );
OKC_CONDITIONS_PUB.update_cond_hdrs( p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cnhv_rec => l_cnh_rec,
x_cnhv_rec => i_cnh_rec);
OKC_CHANGE_REQUEST_PUB.update_change_request( p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_crtv_rec => l_crtv_rec,
x_crtv_rec => i_crtv_rec);
SELECT 'x'
FROM okc_k_lines_b
WHERE id = p_terminate_in_parameters_rec.p_cle_id
and chr_id is not null;
SELECT 'x'
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.id = p_terminate_in_parameters_rec.p_cle_id
and cle.lse_id = lse.id
and lse.lty_code in ('SERVICE','EXT_WARRANTY','USAGE');
SELECT k.template_Yn, k.date_renewed, k.contract_number,
k.contract_number_modifier, k.sts_code, k.application_id,
k.scs_code
FROM okc_k_headers_b k
WHERE k.id = p_terminate_in_parameters_rec.p_dnz_chr_id;
SELECT 'x'
FROM okc_k_processes v
WHERE v.chr_id = p_terminate_in_parameters_rec.p_dnz_chr_id
and v.in_process_yn = 'Y';
SELECT sts.ste_code,sts.meaning
FROM okc_statuses_v sts
WHERE sts.code = p_code;
SELECT 'x'
FROM okx_incident_statuses_v xis,
okc_k_lines_b cle
WHERE cle.id = xis.contract_service_id
--san below cle.id condition added as we just want to check SRs againt this line only.
and cle.id=p_terminate_in_parameters_rec.p_cle_id --bug 1325866
and xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests
select k.contract_number,k.contract_number_modifier
from okc_k_headers_b k,okc_operation_lines a,
okc_operation_instances b,okc_class_operations c
where k.id=a.subject_chr_id
and a.object_chr_id=p_chr_id and
c.id=b.cop_id and c.opn_code='RENEWAL'
and b.id=a.oie_id and a.active_yn='Y' and
a.subject_cle_id is null and a.object_cle_id is null;
SELECT k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
cle.price_negotiated,cle.sts_code
FROM okc_k_headers_b k,
okc_subclasses_b scs,
okc_k_lines_b cle
WHERE k.id = p_terminate_in_parameters_rec.p_dnz_chr_id
AND cle.chr_id = k.id
AND cle.id = p_terminate_in_parameters_rec.p_cle_id
AND k.scs_code = scs.code;
SELECT id,object_version_number,sts_code,lse_id,start_date,end_date
FROM okc_k_lines_b
WHERE date_terminated is null
START WITH id = p_terminate_in_parameters_rec.p_cle_id
CONNECT BY PRIOR id = cle_id
ORDER BY LEVEL DESC
FOR UPDATE OF id NOWAIT;
SELECT 'x'
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.id = p_terminate_in_parameters_rec.p_cle_id
and cle.lse_id = lse.id
and lse.lty_code in ('SERVICE','EXT_WARRANTY','USAGE');
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_code;
OKC_CONTRACT_PUB.update_contract_line( p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => okc_api.g_true,
p_clev_rec => l_clev_rec,
x_clev_rec => i_clev_rec );
OKC_CONTRACT_PUB.update_contract_line( p_api_version => 1,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => OKC_API.g_true,
p_clev_tbl => l_clev_tbl,
x_clev_tbl => i_clev_tbl );