APPS.OKS_INTEGRATION_UTIL_PUB SQL Statements

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

Line: 20

       select instance_number from v$instance;

Line: 43

                             Select Order_Line_Id1
                             From Oks_K_Order_Details
                             Where  Order_Line_Id1 = to_char(P_Order_Line_id);

Line: 82

            Select Id1, Id2, Service_End_Date
            From  okx_order_lines_v   ol
            Where ol.Header_id     = P_header_id
            And   ol.Service_reference_Type_Code IN ('CUSTOMER_PRODUCT','ORDER');

Line: 91

             select order_line_id1, order_line_id2, line_renewal_type, renewal_type,
                    po_required_yn, renewal_pricing_type,markup_percent,billing_profile_id,
                    chr_id, cle_id, cod_type, cod_id, end_date,contact_id, email_id, phone_id, fax_id, site_id
                   ,renewal_approval_flag   --Bug# 5173373
             from   Oks_K_Order_Details
             where Link_Order_Header_ID = P_header_id
             And   APPLY_ALL_YN = 'Y';

Line: 103

             select order_line_id1, order_line_id2, line_renewal_type, renewal_type,
                    po_required_yn, renewal_pricing_type,markup_percent,
                    chr_id, cle_id, cod_type, cod_id, end_date,contact_id, email_id, phone_id, fax_id, site_id
             from   Oks_K_Order_Details
             where Link_Order_Header_ID = P_header_id
             And   Cod_Type = 'NCT'
             And   trunc(end_date) = trunc(l_ser_end_date);

Line: 114

		 select Cro_Code, Jtot_Object_Code, Object1_Id1, Object1_Id2
		 from  oks_k_order_contacts_v
		 where  cod_id in (select id from Oks_K_Order_Details
				    where Order_Line_Id1 = order_line_id);

Line: 150

    l_covd_tbl_in.delete;

Line: 151

    l_covd_tbl_out.delete;

Line: 244

            oks_order_details_pub.Insert_order_Detail
            (
    	           p_api_version	=> l_api_version,
    	           p_init_msg_list	=> l_init_msg_list,
    	           x_return_status	=> l_return_status,
    	           x_msg_count		=> x_msg_count,
    	           x_msg_data		=> x_msg_data,
    	           p_codv_tbl		=> l_covd_tbl_in,
    	           x_codv_tbl		=> l_covd_tbl_out
             );

Line: 265

                l_cocv_tbl_in.delete;

Line: 273

                oks_order_contacts_pub.Insert_order_contact
                (
    	                   p_api_version	=> l_api_version,
    	                   p_init_msg_list	=> l_init_msg_list,
    	                   x_return_status	=> l_return_status,
    	                   x_msg_count          => x_msg_count,
    	                   x_msg_data		=> x_msg_data,
    	                   p_cocv_tbl		=> l_cocv_tbl_in,
    	                   x_cocv_tbl		=> l_cocv_tbl_out
                );

Line: 315

 * update the oks_rules_b table with the correct date format. rule_informationX has to be
 * updated. X is the value of p_rule_num.
*/

PROCEDURE Convert_Dates(p_category_code IN VARCHAR2,
                        p_format        IN VARCHAR2,
                        p_date          IN VARCHAR2,
                        p_rule_num      IN NUMBER,
                        p_rule_id       IN NUMBER,
                        x_return_status OUT NOCOPY VARCHAR2,
                        x_msg_data      OUT NOCOPY VARCHAR2,
                        x_msg_count     OUT NOCOPY NUMBER
                        ) IS
    l_day   VARCHAR2(30);

Line: 341

        update okc_rules_b set
        rule_information2 = l_date
        ---where rule_information_category = p_category_code and rule_information2 = p_date;

Line: 346

        update okc_rules_b set
        rule_information3 = l_date
        ---where rule_information_category = p_category_code and rule_information3 = p_date;

Line: 351

        update okc_rules_b set
        rule_information4 = l_date
        ---where rule_information_category = p_category_code and rule_information4 = p_date;

Line: 395

select id rul_id, rule_information2 rul2
from okc_rules_b
where rgp_id between p_from_id and p_to_id
and   rule_information_category  = category;

Line: 405

select id rul_id, rule_information3 rul3, rule_information4 rul4
from okc_rules_b
where rgp_id between p_from_id and p_to_id
and   rule_information_category  = category;

Line: 510

    select value
    from v$parameter
    where name = 'utl_file_dir';

Line: 697

  select min(id) minid, max(id) maxid,
         count(id) total,
	 avg(id) avgid, stddev(id) stdid
  from   okc_rule_groups_b
  where  rgd_code = 'SVC_K';

Line: 704

  select count(*)
  from   user_jobs
  where  job = l_job;