36: l_return_status varchar2(240);
37: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
38: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
39: l_customer_id cs_incidents_all_b.customer_id%type;
40: l_service_rec cs_servicerequest_pub.service_request_rec_type;
41: l_sr_user_id number;
42: l_sr_resp_id number;
43: l_sr_resp_appl_id number;
44: l_notes_rec cs_servicerequest_pub.notes_table;
40: l_service_rec cs_servicerequest_pub.service_request_rec_type;
41: l_sr_user_id number;
42: l_sr_resp_id number;
43: l_sr_resp_appl_id number;
44: l_notes_rec cs_servicerequest_pub.notes_table;
45: l_contacts_rec cs_servicerequest_pub.contacts_table;
46: l_sr_api_version number;
47: l_object_version_number number;
48: l_sr_return_status varchar2(1);
41: l_sr_user_id number;
42: l_sr_resp_id number;
43: l_sr_resp_appl_id number;
44: l_notes_rec cs_servicerequest_pub.notes_table;
45: l_contacts_rec cs_servicerequest_pub.contacts_table;
46: l_sr_api_version number;
47: l_object_version_number number;
48: l_sr_return_status varchar2(1);
49: l_sr_msg_count number;
146: user_id => l_sr_user_id,
147: resp_id => l_sr_resp_id,
148: resp_appl_id => l_sr_resp_appl_id
149: );
150: cs_servicerequest_pub.initialize_rec(l_service_rec);
151: l_service_rec.owning_department_id := l_owning_department_id;
152: cs_servicerequest_pub.update_serviceRequest(
153: p_api_version => l_sr_api_version
154: ,p_request_id => l_incident_id
148: resp_appl_id => l_sr_resp_appl_id
149: );
150: cs_servicerequest_pub.initialize_rec(l_service_rec);
151: l_service_rec.owning_department_id := l_owning_department_id;
152: cs_servicerequest_pub.update_serviceRequest(
153: p_api_version => l_sr_api_version
154: ,p_request_id => l_incident_id
155: ,p_service_request_rec => l_service_rec
156: ,p_object_version_number => l_object_version_number
309: l_return_status varchar2(240);
310: l_incident_status_id cs_incidents_all_b.incident_status_id%type;
311: l_incident_severity_id cs_incidents_all_b.incident_severity_id%type;
312: l_customer_id cs_incidents_all_b.customer_id%type;
313: l_service_rec cs_servicerequest_pub.service_request_rec_type;
314: l_sr_user_id number;
315: l_sr_resp_id number;
316: l_sr_resp_appl_id number;
317: l_notes_rec cs_servicerequest_pub.notes_table;
313: l_service_rec cs_servicerequest_pub.service_request_rec_type;
314: l_sr_user_id number;
315: l_sr_resp_id number;
316: l_sr_resp_appl_id number;
317: l_notes_rec cs_servicerequest_pub.notes_table;
318: l_contacts_rec cs_servicerequest_pub.contacts_table;
319: l_sr_api_version number;
320: l_object_version_number number;
321: l_sr_return_status varchar2(1);
314: l_sr_user_id number;
315: l_sr_resp_id number;
316: l_sr_resp_appl_id number;
317: l_notes_rec cs_servicerequest_pub.notes_table;
318: l_contacts_rec cs_servicerequest_pub.contacts_table;
319: l_sr_api_version number;
320: l_object_version_number number;
321: l_sr_return_status varchar2(1);
322: l_sr_msg_count number;
393: user_id => l_sr_user_id,
394: resp_id => l_sr_resp_id,
395: resp_appl_id => l_sr_resp_appl_id
396: );
397: cs_servicerequest_pub.initialize_rec(l_service_rec);
398: l_service_rec.owning_department_id := l_owning_department_id;
399: cs_servicerequest_pub.update_serviceRequest(
400: p_api_version => l_sr_api_version
401: ,p_request_id => l_incident_id
395: resp_appl_id => l_sr_resp_appl_id
396: );
397: cs_servicerequest_pub.initialize_rec(l_service_rec);
398: l_service_rec.owning_department_id := l_owning_department_id;
399: cs_servicerequest_pub.update_serviceRequest(
400: p_api_version => l_sr_api_version
401: ,p_request_id => l_incident_id
402: ,p_service_request_rec => l_service_rec
403: ,p_object_version_number => l_object_version_number