The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE counter_grp_billing_insert(
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_cntr_bill_rec IN cntr_bill_rec_type
,x_cntr_bill_rec OUT NOCOPY cntr_bill_rec_type
) IS
---------------------------
-- DECLARE Local Variables
---------------------------
BEGIN
NULL ;
PROCEDURE counter_grp_billing_insert(
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_cntr_bill_tbl IN cntr_bill_tbl_type
,x_cntr_bill_tbl OUT NOCOPY cntr_bill_tbl_type
) IS
---------------------------
-- DECLARE Local Variables
---------------------------
l_api_name CONSTANT VARCHAR2(30) := 'OKL_CNTR_GRP_BILLING_PVT';
SELECT HDR.ID KHR_ID
FROM OKC_K_HEADERS_B HDR
WHERE CONTRACT_NUMBER = l_contract_num;
SELECT cle.id KLE_ID
FROM okc_k_lines_v cle,
okc_line_styles_b lse
WHERE lse.id =cle.lse_id
AND lse.lty_code ='FREE_FORM1'
AND cle.name =l_asset_name
AND cle.dnz_chr_id=l_chr_id;
SELECT ID
FROM okl_trx_types_tl
WHERE NAME = 'Billing' and LANGUAGE = 'US';
select DEFAULTED_GROUP_ID counter_group_id
from CSI_COUNTER_TEMPLATE_B
where counter_id=l_cntr_num
union all
select defaulted_group_id counter_group_id
from CSI_COUNTERS_B
where counter_id=l_cntr_num;
SELECT counter_group_id
FROM CS_COUNTERS
WHERE counter_id = l_cntr_num; */
SELECT COUNTER_PROPERTY_ID,
DEFAULT_VALUE
from CSI_CTR_PROPERTY_TEMPLATE_B
where counter_id=l_cntr_num
UNION ALL
SELECT COUNTER_PROPERTY_ID,
DEFAULT_VALUE
FROM CSI_COUNTER_PROPERTIES_B
where counter_id=l_cntr_num;
SELECT counter_property_id, default_value
FROM cs_counter_properties
WHERE counter_id = l_cntr_num; */
Okl_Trx_Ar_Invoices_Pub.insert_trx_ar_invoices(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,l_taiv_rec
,lx_taiv_rec);
okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,l_tilv_rec
,lx_tilv_rec);
Okl_Txd_Ar_Ln_Dtls_Pub.insert_txd_ar_ln_dtls(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,l_tldv_rec
,lx_tldv_rec);
l_msg_data := 'Problems with Insert into internal tables';
END counter_grp_billing_insert;