[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sts_code,template_yn,end_date,application_id,scs_code ,contract_number,
contract_number_modifier
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_code;
p_msg_name => 'OKC_NO_UPDATE',
p_token1 => 'CHR',
p_token1_value => l_k);
SELECT template_yn, application_id, scs_code ,contract_number,
contract_number_modifier
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT sts_code,dnz_chr_id ,line_number,end_date
FROM okc_k_lines_b
WHERE id = p_cle_id;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_code;
p_msg_name => 'OKC_NO_UPDATE',
p_token1 => 'CHR',
p_token1_value => l_k);
SELECT
decode(pdf.pdf_type,'PPS',
pdf.package_name||'.'||pdf.procedure_name,NULL) proc_name
FROM okc_process_defs_v pdf
WHERE pdf.id = l_pdf_id;
SELECT STS_CODE,
CONTRACT_NUMBER,
CONTRACT_NUMBER_MODIFIER,
TEMPLATE_YN,
DATE_TERMINATED,
DATE_RENEWED,
END_DATE
FROM okc_k_headers_b
WHERE id = p_extend_in_parameters_rec.p_contract_id;
SELECT 'Y'
FROM okc_k_processes v
WHERE v.chr_id = p_extend_in_parameters_rec.p_contract_id
AND v.in_process_yn='Y';
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_sts_code;
SELECT meaning
FROM okc_statuses_v
WHERE code = p_sts_code;
SELECT cle.line_number,cle.item_description,cle.id,cle.lse_id,cle.sts_code,cle.dnz_chr_id,
cle.object_version_number,cle.date_terminated,cle.end_date,sts.ste_code
FROM okc_k_lines_v cle,
okc_statuses_b sts
WHERE cle.id = p_extend_in_parameters_rec.p_cle_id
AND trunc(cle.end_date) = trunc(p_extend_in_parameters_rec.p_orig_end_date)
AND cle.sts_code = sts.code;
SELECT meaning
FROM okc_statuses_v
WHERE code = p_sts_code;
SELECT end_date+1 from okc_k_headers_b
WHERE id=p_id;
PROCEDURE update_enddate( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_rec IN okc_contract_pub.chrv_rec_type,
p_new_end_date IN DATE ) is
-- bug#5757116 added trunc in the where clause of the cursor.
CURSOR cur_k_lines is
SELECT cle.id
FROM okc_k_lines_b cle,
okc_statuses_b sts
WHERE trunc(cle.end_date) = trunc(p_chr_rec.end_date)
AND cle.dnz_chr_id = p_chr_rec.id
AND Cle.chr_id is not null
AND cle.sts_code = sts.code
AND sts.ste_code in ('ACTIVE','EXPIRED','ENTERED','SIGNED');
SELECT cle.id,cle.object_version_number,cle.sts_code,cle.end_date
FROM okc_k_lines_b cle
CONNECT BY PRIOR id=cle_id
start with id=p_id;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_sts_code;
l_api_name constant varchar2(30) := 'update_enddate';
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_chr_rec,
x_chrv_rec => i_chr_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_cle_rec,
x_clev_rec => i_cle_rec );
END update_enddate;
PROCEDURE update_condition_headers ( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN NUMBER,
p_old_end_date IN VARCHAR2,
p_new_end_date IN VARCHAR2) is
CURSOR cur_condition_headers is
SELECT id,object_version_number,date_active,date_inactive
FROM okc_condition_headers_b
WHERE dnz_chr_id = p_chr_id
and date_inactive = p_old_end_date
FOR update of id nowait;
l_api_name constant varchar2(30) := 'update_conditions';
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);
END update_condition_headers;
PROCEDURE update_time_values ( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tve_id IN NUMBER,
p_tve_id_limited IN NUMBER,
p_tve_type IN VARCHAR2,
p_new_end_date IN DATE ) is
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
SELECT id,object_version_number
FROM okc_timevalues
WHERE id = p_tve_id;
SELECT 'x'
FROM okc_time_ia_startend_val_v
WHERE id = p_tve_id;
l_api_name constant varchar2(30) := 'update_time_values';
IF cur_is_ise%found THEN -- This implies that this ISE will have TAV's, so update those
l_isev_rec.id := l_id;
OKC_TIME_PUB.update_ia_startend(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_isev_ext_rec => l_isev_rec,
x_isev_ext_rec => i_isev_rec );
OKC_TIME_PUB.update_tpa_value(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_tavv_rec => l_tavv_ext_rec,
x_tavv_rec => i_tavv_ext_rec );
OKC_TIME_PUB.update_ia_startend(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_isev_ext_rec => l_isev_rec,
x_isev_ext_rec => i_isev_rec );
end update_time_values;
SELECT ID,
OBJECT_VERSION_NUMBER,
STS_CODE,
CONTRACT_NUMBER,
CONTRACT_NUMBER_MODIFIER,
END_DATE
FROM okc_k_headers_v
WHERE id = p_extend_in_parameters_rec.p_contract_id
and trunc(start_date) = trunc(p_extend_in_parameters_rec.p_orig_start_date)
and trunc(end_date) = trunc(p_extend_in_parameters_rec.p_orig_end_date)
FOR UPDATE OF start_date NOWAIT;
SELECT *
FROM okc_k_lines_v
WHERE dnz_chr_id = p_extend_in_parameters_rec.p_contract_id
FOR update of line_number nowait;
SELECT *
FROM okc_rules_v
WHERE dnz_chr_id = p_extend_in_parameters_rec.p_contract_id
FOR update of object1_id1 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_extend_in_parameters_rec.p_contract_id
AND k.scs_code = scs.code;
SELECT cle.id,cle.end_date,cle.start_date,cle.object_version_number
FROM okc_k_lines_b cle,
okc_statuses_b sts
WHERE cle.dnz_chr_id = p_chr_id
and trunc(cle.end_date) = trunc(p_end_date)
and cle.sts_code = sts.code
and sts.ste_code in ('ACTIVE','EXPIRED','ENTERED','SIGNED')
and date_terminated is null;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_sts_code;
SELECT pdf_id
FROM okc_class_operations
WHERE opn_code = 'EXTEND'
AND cls_code = p_cls_code;
update_enddate( 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_chr_rec => rec_k_header,
p_new_end_date => l_new_end_date );
update_condition_headers( 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_chr_id => p_extend_in_parameters_rec.p_contract_id,
p_old_end_date => p_extend_in_parameters_rec.p_orig_end_date,
p_new_end_date => l_new_end_date );
SELECT id,object_version_number,chr_id,date_terminated,end_date,sts_code, start_date
FROM okc_k_lines_b
WHERE date_terminated is null
START WITH id = p_extend_in_parameters_rec.p_cle_id
CONNECT BY PRIOR id = cle_id
ORDER BY LEVEL asc
FOR UPDATE OF id NOWAIT;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_sts_code;
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_extend_in_parameters_rec.p_dnz_chr_id
AND cle.chr_id = k.id
AND cle.id = p_extend_in_parameters_rec.p_cle_id
AND k.scs_code = scs.code;
SELECT pdf_id
FROM okc_class_operations
WHERE opn_code = 'EXTEND'
AND cls_code = p_cls_code;
Select id
From OKC_K_LINES_V
Where cle_id = p_cle_id
and lse_id in (2,13,15,20);
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_cle_rec,
x_clev_rec => i_cle_rec );