APPS.OKL_CNTR_GRP_BILLING_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 189

  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 ;

Line: 206

  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';

Line: 279

            SELECT  HDR.ID KHR_ID
            FROM    OKC_K_HEADERS_B HDR
            WHERE   CONTRACT_NUMBER = l_contract_num;

Line: 285

	    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;

Line: 294

            SELECT ID
            FROM okl_trx_types_tl
            WHERE NAME = 'Billing' and LANGUAGE = 'US';

Line: 301

	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;

Line: 310

            SELECT counter_group_id
            FROM CS_COUNTERS
            WHERE counter_id = l_cntr_num;  */

Line: 317

	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;

Line: 328

            SELECT counter_property_id, default_value
            FROM cs_counter_properties
            WHERE counter_id = l_cntr_num; */

Line: 396

        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);

Line: 428

        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);

Line: 478

        	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);

Line: 603

        l_msg_data := 'Problems with Insert into internal tables';

Line: 612

  END counter_grp_billing_insert;