The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_resource(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_resource_id NUMBER
, p_resource_number VARCHAR2
, p_resource_name VARCHAR2
, p_source_name VARCHAR2
, p_address_id VARCHAR2
, p_source_office VARCHAR2
, p_source_mailstop VARCHAR2
, p_source_location VARCHAR2
, p_source_phone VARCHAR2
, p_source_email VARCHAR2
, p_object_version_number NUMBER
, p_approved VARCHAR2
, p_source_job_id NUMBER
, p_source_job_title VARCHAR2
, p_salesrep_number VARCHAR2
, p_sales_credit_type_id NUMBER
, p_end_date_active date
, p_user_id NUMBER
, p_user_name VARCHAR2
, p_mgr_resource_id NUMBER
, p_org_id NUMBER
, x_return_status out NOCOPY VARCHAR2
, x_msg_count out NOCOPY NUMBER
, x_msg_data out NOCOPY VARCHAR2
, p_time_zone NUMBER
, p_cost_per_hr NUMBER
, p_primary_language VARCHAR2
, p_secondary_language VARCHAR2
, p_support_site_id NUMBER
, p_source_mobile_phone VARCHAR2
, p_source_pager VARCHAR2
)
as
ddp_end_date_active date;
jtf_rs_res_sswa_pub.update_resource(p_api_version,
p_init_msg_list,
p_commit,
p_resource_id,
p_resource_number,
p_resource_name,
p_source_name,
p_address_id,
p_source_office,
p_source_mailstop,
p_source_location,
p_source_phone,
p_source_email,
p_object_version_number,
p_approved,
p_source_job_id,
p_source_job_title,
p_salesrep_number,
p_sales_credit_type_id,
ddp_end_date_active,
p_user_id,
p_user_name,
p_mgr_resource_id,
p_org_id,
x_return_status,
x_msg_count,
x_msg_data,
p_time_zone,
p_cost_per_hr,
p_primary_language,
p_secondary_language,
p_support_site_id,
p_source_mobile_phone,
p_source_pager);