The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
select 'x'
from hr_all_organization_units hr , mtl_parameters mp
where mp.organization_id = hr.organization_id
and mp.master_organization_id = mp.organization_id
and hr.organization_id = p_chr_rec.inv_organization_id;
select 'x'
from hr_operating_units
where organization_id = p_chr_rec.authoring_org_id;
select 'x'
FROM Okc_Statuses_B
WHERE okc_statuses_b.code = p_cle_rec.sts_code;
l_oke_chr_rec.last_updated_by := p_chr_rec.last_updated_by;
l_oke_chr_rec.last_update_login := p_chr_rec.last_update_login;
l_oke_chr_rec.last_update_date := p_chr_rec.last_update_date;
l_okc_chrv_rec.deleted_yn := p_chr_rec.deleted_yn;
l_okc_chrv_rec.last_updated_by := p_chr_rec.last_updated_by;
l_okc_chrv_rec.last_update_date := p_chr_rec.last_update_date;
l_okc_chrv_rec.last_update_login := p_chr_rec.last_update_login;
l_okc_chrv_rec.deleted_yn := 'N';
UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
WHERE K_HEADER_ID = l_out_chr.k_header_id;
UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
WHERE K_HEADER_ID = l_out_chr.k_header_id;
IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
WHERE K_HEADER_ID = l_out_chr.k_header_id;
IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
WHERE K_HEADER_ID = l_out_chr.k_header_id;
IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date
WHERE K_HEADER_ID = l_out_chr.k_header_id;
x_chr_rec.last_updated_by := l_out_chr.last_updated_by;
x_chr_rec.last_update_login := l_out_chr.last_update_login;
x_chr_rec.last_update_date := l_out_chr.last_update_date;
x_chr_rec.deleted_yn := l_out_chrv.deleted_yn;
x_chr_rec.last_updated_by := l_out_chrv.last_updated_by;
x_chr_rec.last_update_date := l_out_chrv.last_update_date;
x_chr_rec.last_update_login := l_out_chrv.last_update_login;
SELECT inv_organization_id
FROM OKC_K_HEADERS_B
WHERE ID = p_chr;
l_oke_cle_rec.last_updated_by := p_cle_rec.last_updated_by;
l_oke_cle_rec.last_update_login := p_cle_rec.last_update_login;
l_oke_cle_rec.last_update_date := p_cle_rec.last_update_date;
l_okc_clev_rec.last_updated_by := p_cle_rec.last_updated_by;
l_okc_clev_rec.last_update_date := p_cle_rec.last_update_date;
l_okc_clev_rec.last_update_login := p_cle_rec.last_update_login;
x_cle_rec.last_updated_by := l_out_cle.last_updated_by;
x_cle_rec.last_update_login := l_out_cle.last_update_login;
x_cle_rec.last_update_date := l_out_cle.last_update_date;
x_cle_rec.last_updated_by := l_out_clev.last_updated_by;
x_cle_rec.last_update_date := l_out_clev.last_update_date;
x_cle_rec.last_update_login := l_out_clev.last_update_login;
l_cimv_rec.LAST_UPDATED_BY := x_cle_rec.LAST_UPDATED_BY;
l_cimv_rec.LAST_UPDATE_DATE := x_cle_rec.LAST_UPDATE_DATE;
l_cimv_rec.LAST_UPDATE_LOGIN := x_cle_rec.LAST_UPDATE_LOGIN;
SELECT INV_ORGANIZATION_ID
FROM OKC_K_HEADERS_B
WHERE ID = p_del_rec.k_header_id;
SELECT BUY_OR_SELL
FROM OKC_K_HEADERS_B
WHERE ID = p_del_rec.k_header_id;
IF l_del_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
l_del_rec.LAST_UPDATED_BY := NULL;
IF l_del_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
l_del_rec.LAST_UPDATE_LOGIN := NULL;
IF l_del_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
l_del_rec.LAST_UPDATE_DATE := NULL;
select 'x'
from oke_k_headers
where k_header_id = p_bill_rec.k_header_id;
select 'x'
from oke_billing_methods_vl
where billing_method_code = p_bill_rec.billing_method_code;
insert into oke_k_billing_methods
(
k_header_id,
billing_method_code,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
default_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
)
values
(
p_bill_tbl(i).k_header_id,
p_bill_tbl(i).billing_method_code,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,
p_bill_tbl(i).default_flag,
p_bill_tbl(i).attribute_category,
p_bill_tbl(i).attribute1,
p_bill_tbl(i).attribute2,
p_bill_tbl(i).attribute3,
p_bill_tbl(i).attribute4,
p_bill_tbl(i).attribute5,
p_bill_tbl(i).attribute6,
p_bill_tbl(i).attribute7,
p_bill_tbl(i).attribute8,
p_bill_tbl(i).attribute9,
p_bill_tbl(i).attribute10,
p_bill_tbl(i).attribute11,
p_bill_tbl(i).attribute12,
p_bill_tbl(i).attribute13,
p_bill_tbl(i).attribute14,
p_bill_tbl(i).attribute15
);
select 'x' from oke_k_lines_v
where billing_method_code = p_code
and header_id = p_header_id;
delete from oke_k_billing_methods
where k_header_id = p_bill_tbl(i).k_header_id
and billing_method_code = p_bill_tbl(i).billing_method_code;
l_cimv_tbl_in(1).LAST_UPDATED_BY := p_cimv_rec.LAST_UPDATED_BY;
l_cimv_tbl_in(1).LAST_UPDATE_DATE := p_cimv_rec.LAST_UPDATE_DATE;
l_cimv_tbl_in(1).LAST_UPDATE_LOGIN := p_cimv_rec.LAST_UPDATE_LOGIN;
x_cimv_rec.LAST_UPDATED_BY := l_cimv_tbl_out(1).LAST_UPDATED_BY;
x_cimv_rec.LAST_UPDATE_DATE := l_cimv_tbl_out(1).LAST_UPDATE_DATE;
x_cimv_rec.LAST_UPDATE_LOGIN := l_cimv_tbl_out(1).LAST_UPDATE_LOGIN;