The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_own_flag VARCHAR2(1) := 'N';
l_update_grp_flag VARCHAR2(1) := 'N';
SELECT incident_id,
incident_number,
incident_status_id,
incident_type_id,
incident_urgency_id,
incident_severity_id,
incident_owner_id,
resource_type,
inventory_item_id,
customer_id,
account_id,
bill_to_site_use_id,
purchase_order_num,
ship_to_site_use_id,
problem_code,
expected_resolution_date,
actual_resolution_date,
customer_product_id,
install_site_use_id,
bill_to_contact_id,
ship_to_contact_id,
current_serial_number,
product_revision,
component_version,
subcomponent_version,
resolution_code,
org_id,
original_order_number,
workflow_process_id,
close_date,
contract_service_id,
contract_id,
contract_number,
project_number,
owner_group_id,
obligation_date,
caller_type,
platform_id,
platform_version,
db_version,
cp_revision_id,
inv_component_version,
language_id,
territory_id,
inv_organization_id,
cust_pref_lang_code,
comm_pref_code,
incident_address,
incident_city,
incident_state,
incident_country,
incident_province,
incident_postal_code,
incident_county,
sr_creation_channel,
coverage_type,
customer_site_id,
site_id,
incident_date,
category_id,
inv_platform_org_id,
incident_location_id,
incident_location_type,
-- Added for 11.5.10+
cp_component_id,
cp_subcomponent_id,
inv_component_id,
inv_subcomponent_id
FROM cs_incidents_all_b
WHERE incident_id = p_incident_id;
SELECT country,province,state,city,postal_code,county
FROM hz_locations
WHERE location_id = p_incident_location_id;
SELECT location_id FROM hz_party_sites
WHERE party_site_id = p_party_site_id;
SELECT inventory_item_id
FROM csi_item_instances
WHERE instance_id = p_component_id;
SELECT inventory_item_id
FROM csi_item_instances
WHERE instance_id = p_subcomponent_id;
SELECT employees_total, party_name
FROM hz_parties
WHERE party_id = p_customer_id;
SELECT to_number(object1_id1), to_number(object1_id2)
FROM okc_k_items
WHERE cle_id = l_contract_service_id;
SELECT hzp.phone_area_code
FROM hz_contact_points hzp
WHERE hzp.contact_point_id = c_customer_phone_id;*/
SELECT hzp.phone_area_code
FROM hz_contact_points hzp,
cs_incidents_all_b csi
WHERE csi.incident_id = c_incident_id
AND csi.customer_phone_id = hzp.contact_point_id
AND csi.customer_phone_id IS NOT NULL;
SELECT business_process_id INTO l_business_process_id
FROM cs_incident_types
WHERE incident_type_id = p_service_request_rec.type_id;
SELECT to_char(sysdate, 'd'), to_char(sysdate, 'hh24:mi')
INTO l_day_week, l_time_day
FROM cs_incidents_all_b
WHERE incident_id = l_incident_id ;
p_auto_select_flag => 'N',
p_contracts_preferred_engineer => nvl(l_contract_res_flag,'N'),
p_ib_preferred_engineer => nvl(l_ib_res_flag,'N'),
p_contract_id => l_contract_service_id,
p_customer_product_id => l_cust_prod_id,
p_effort_duration => NULL,
p_effort_uom => NULL,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_territory_flag => nvl(l_territory_flag,'N'),
p_calendar_flag => nvl(l_cs_sr_tsk_chk_res_cal_avl, 'N') ,
p_calendar_check => nvl(l_cs_sr_tsk_chk_res_cal_avl, 'N') ,
p_web_availability_flag => 'Y',
p_filter_excluded_resource => 'Y',
p_category_id => NULL,
p_inventory_item_id => NULL,
p_inventory_org_id => NULL,
p_column_list => NULL,
p_calling_doc_id => NULL,
p_calling_doc_type => 'SR',
p_sr_rec => NULL,
p_sr_task_rec => l_task_am_rec,
p_defect_rec => NULL,
p_business_process_id => l_business_process_id,
p_business_process_date => p_service_request_rec.request_date,
x_Assign_Resources_tbl => l_Assign_Groups_tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
FROM okc_k_items
WHERE cle_id = l_contract_service_id;
SELECT hzp.phone_area_code
FROM hz_contact_points hzp,
cs_incidents_all_b csi
WHERE csi.incident_id = c_incident_id
AND csi.customer_phone_id = hzp.contact_point_id
AND csi.customer_phone_id IS NOT NULL;
select address_id
FROM jtf_tasks_b
where task_id=c_task_id;
SELECT business_process_id INTO l_business_process_id
FROM cs_incident_types
WHERE incident_type_id = p_service_request_rec.type_id;
SELECT to_char(sysdate, 'd'), to_char(sysdate, 'hh24:mi')
INTO l_day_week, l_time_day
FROM cs_incidents_all_b
WHERE incident_id = l_incident_id ;
p_auto_select_flag => 'N',
p_ib_preferred_engineer => nvl(l_ib_res_flag,'N'),
p_contracts_preferred_engineer => nvl(l_contract_res_flag,'N'),
p_contract_id => l_contract_service_id,
p_customer_product_id => l_cust_prod_id,
p_effort_duration => NULL,
p_effort_uom => NULL,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_territory_flag => nvl(l_territory_flag,'N'),
p_calendar_flag => nvl(l_cs_sr_tsk_chk_res_cal_avl, 'N') ,
p_calendar_check => nvl(l_cs_sr_tsk_chk_res_cal_avl, 'N') ,
--p_web_availability_flag => 'Y',
p_filter_excluded_resource => 'Y',
p_category_id => NULL,
p_inventory_item_id => NULL,
p_inventory_org_id => NULL,
p_column_list => NULL,
p_calling_doc_id => NULL,
p_calling_doc_type => 'SR',
p_sr_rec => NULL,
p_sr_task_rec => l_task_am_rec,
p_defect_rec => NULL,
p_business_process_id => l_business_process_id,
p_business_process_date => p_service_request_rec.request_date,
x_Assign_Resources_tbl => l_Assign_Owner_tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);