The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_bpev_rec.last_updated_by := p_bpev_rec1.last_updated_by;
l_bpev_rec.last_update_date := p_bpev_rec1.last_update_date;
l_bpev_rec.last_update_login := p_bpev_rec1.last_update_login;
SELECT contract.currency_code
FROM okc_k_headers_b contract, okc_k_lines_b line
WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
SELECT contract.currency_code
FROM okc_k_headers_b contract
WHERE contract.id = p_chr_id;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_bpev_tbl IN bpev_tbl_type,
x_bpev_tbl OUT NOCOPY bpev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
insert_row(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_bpev_tbl(i)
,x_bpev_tbl(i));
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_bpev_rec IN bpev_rec_type,
x_bpev_rec OUT NOCOPY bpev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
oks_billing_profiles_pvt.insert_row(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_bpev_rec
,x_bpev_rec);
END insert_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_bpev_tbl IN bpev_tbl_type,
x_bpev_tbl OUT NOCOPY bpev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_row(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_bpev_tbl(i)
,x_bpev_tbl(i));
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_bpev_rec IN bpev_rec_type,
x_bpev_rec OUT NOCOPY bpev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_row';
oks_billing_profiles_pvt.update_row(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_bpev_rec
,x_bpev_rec);
END update_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_bpev_tbl IN bpev_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
delete_row(
p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,p_bpev_tbl(i));
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_bpev_rec IN bpev_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
oks_billing_profiles_pvt.delete_row(p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,l_bpev_rec);
END delete_row;
SELECT (f_target_qty - f_target_qty) INTO l_round_quantity FROM DUAL ;
l_p_tavv_tbl(1).last_updated_by := NULL;
l_p_tavv_tbl(1).last_update_date := TO_DATE(NULL);
l_p_tavv_tbl(1).last_update_login := NULL;
SELECT BILLING_LEVEL,
BILLING_TYPE,
INTERVAL,
INTERFACE_OFFSET,
INVOICE_OFFSET,
INVOICE_OBJECT1_ID1,
--sum, jul,01
ACCOUNT_OBJECT1_ID1
--sum, jul,01
FROM OKS_BILLING_PROFILES_V
WHERE ID = l_billing_profile_Id;
select uom_code
from okc_time_code_units_v
where tce_code='DAY'
and quantity=1;
SELECT (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0)) line_amt
FROM okc_k_lines_b line, oks_k_lines_b dtl
WHERE line.id = dtl.cle_id AND line.Id = p_cle_id ;
select lse_id
from okc_k_lines_b
where id = p_cle_id
and dnz_chr_id = p_chr_id;
l_sll_prorate_tbl.DELETE;