[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM okc_k_headers_b
WHERE contract_number = contract_no
AND contract_number_modifier = contract_no_modifier;
SELECT jtot_object_code
FROM okc_role_sources rs, okc_subclass_roles sr
WHERE rs.rle_code = sr.rle_code AND SYSDATE BETWEEN rs.start_date AND NVL(rs.end_date,SYSDATE)
AND SYSDATE BETWEEN sr.start_date AND NVL(sr.end_date,SYSDATE)
AND rs.rle_code = p_rle_code
AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;
SELECT id FROM okc_k_party_roles_b
WHERE chr_id = contract_id AND rle_code = g_vendor_rle_code;
SELECT object1_id1,object1_id2 FROM okc_k_party_roles_b
WHERE chr_id = contract_id AND rle_code = g_vendor_rle_code;
SELECT v.id
FROM okc_k_headers_v v
WHERE v.contract_number = parent_agreement_number;
l_update_rec OKL_VENDOR_PROGRAM_PUB.program_header_rec_type;
SELECT jtot_object_code
FROM okc_role_sources rs, okc_subclass_roles sr
WHERE rs.rle_code = sr.rle_code AND SYSDATE BETWEEN rs.start_date AND NVL(rs.end_date,SYSDATE)
AND SYSDATE BETWEEN sr.start_date AND NVL(sr.end_date,SYSDATE)
AND rs.rle_code = p_rle_code
AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;
SELECT jtot_object1_code, object1_id1, object1_id2
FROM okc_k_party_roles_b
WHERE dnz_chr_id = khr_id
AND rle_code = g_vendor_rle_code;
Select access_level
from OKC_ROLE_SOURCES
where rle_code = p_rle_code
and buy_or_sell = 'S';
SELECT id FROM OKC_QA_CHECK_LISTS_V WHERE name = p_qa_name;
l_header_rec.deleted_yn := 'N';
SELECT v.id
FROM okc_k_headers_v v
WHERE v.contract_number = parent_agreement_number;
SELECT jtot_object1_code, object1_id1, object1_id2
FROM okc_k_party_roles_b
WHERE dnz_chr_id = khr_id
AND rle_code = g_vendor_rle_code;
SELECT pov.vendor_name vendor_name
FROM okc_k_headers_b chrb,
okc_k_party_roles_b kpr,
po_vendors pov
WHERE chrb.id = kpr.dnz_chr_id
AND kpr.rle_code = 'OKL_VENDOR'
AND kpr.object1_id1 = pov.vendor_id
AND chrb.id = chr_id;
Select access_level
from OKC_ROLE_SOURCES
where rle_code = p_rle_code
and buy_or_sell = 'S';
OKL_KPL_PVT.Insert_Row(
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_kplv_rec => l_kplv_rec,
x_kplv_rec => x_kplv_rec);
PROCEDURE update_program(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_hdr_rec IN program_header_rec_type,
p_program_id IN okl_k_headers_full_v.id%TYPE,
p_parent_agreement_id IN okc_k_headers_v.ID%TYPE DEFAULT NULL)
IS
-- check for whether update is allowed for this contract
-- check for whether workflow process is active for this contract
-- depending on these,call the update_contract_header
-- not clear on p_restrict_update parameter in the update_contract_header api ?????????
-- templates are not updateable
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'update_program';
SELECT 'x'
FROM okc_k_headers_b
WHERE contract_number = contract_no
AND contract_number_modifier = contract_no_modifier
AND id <> NVL(contract_id,-99999);
SELECT v.contract_number FROM okc_k_headers_b v
WHERE v.id =program_id;
SELECT p.id
FROM okc_k_processes_v p
WHERE p.chr_id=program_id;
Select access_level
from OKC_ROLE_SOURCES
where rle_code = p_rle_code
and buy_or_sell = 'S';
SELECT ID FROM OKC_GOVERNANCES WHERE DNZ_CHR_ID = p_program_id;
IF (OKC_CONTRACT_PUB.Update_Allowed(p_program_id) <> 'Y') THEN
l_return_status :=OKL_API.G_RET_STS_ERROR;
p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
);
OKL_CONTRACT_PUB.update_contract_header(
p_api_version => l_api_version,
x_return_status => l_return_status,
p_init_msg_list => OKL_API.G_TRUE,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_restricted_update => OKL_API.G_FALSE,
p_chrv_rec => l1_header_rec,
p_khrv_rec => l_k_header_rec,
x_chrv_rec => l2_header_rec,
x_khrv_rec => x_k_header_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 => l_incomplete_status_code
,p_chr_id => p_program_id
);
OKC_CONTRACT_PUB.update_governance( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_gvev_rec => l_gvev_rec,
x_gvev_rec => x_gvev_rec );
OKC_CONTRACT_PUB.delete_governance( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_gvev_rec => l_gvev_rec);
okc_contract_pub.update_contract_process(
p_api_version => l_api_version,
x_return_status => l_return_status,
p_init_msg_list => OKL_API.G_FALSE,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_cpsv_rec => cpsv_rec_type3,
x_cpsv_rec => cpsv_rec_type4);
OKC_CONTRACT_PARTY_PUB.update_k_party_role(p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cplv_rec => l1_cplv_rec,
x_cplv_rec => l2_cplv_rec
);
OKL_KPL_PVT.update_row(
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_kplv_rec => l_kplv_rec,
x_kplv_rec => x_kplv_rec);
SELECT pdfv.wf_name, cpsv.process_id
FROM okc_process_defs_b pdfv,
okc_k_processes cpsv
WHERE pdfv.id = cpsv.pdf_id
AND cpsv.chr_id = p_chr_id;
SELECT end_date
FROM wf_items
WHERE item_type = l_wf_name
AND item_key = l_item_key;
SELECT sts_code
FROM okc_k_headers_v
WHERE id = p_chr_id;
SELECT id, status_code, change_type_code
FROM OKL_VP_CHANGE_REQUESTS
WHERE id = (SELECT crs_id FROM okl_k_headers WHERE id = p_chr_id);
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 => l_incomplete_status_code
,p_chr_id => p_program_id
);