[Home] [Help]
566: --------------------------------------------
567: procedure get_extnd_attr_tasks (
568: p_api_version in number,
569: p_init_msg_list in varchar2 ,
570: p_sr_rec in CS_ServiceRequest_pub.service_request_rec_type,
571: p_request_id in number ,
572: p_incident_number in varchar2 ,
573: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
574: x_return_status out nocopy varchar2,
671: procedure create_extnd_attr_tasks (
672: p_api_version in number,
673: p_init_msg_list in varchar2 ,
674: p_commit in varchar2 ,
675: p_sr_rec in CS_ServiceRequest_pub.service_request_rec_type,
676: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
677: p_request_id in number ,
678: p_incident_number in varchar2 ,
679: x_return_status OUT NOCOPY varchar2,
692: l_owner_id cs_incidents_all_b.incident_owner_id % type;
693: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
694: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
695: l_group_type varchar2(50);
696: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;
697: l_task_owner_type jtf_tasks_b.owner_type_code % type;
698: l_task_owner_id jtf_tasks_b.owner_id%type;
699: l_location_id cs_incidents_all_b.incident_location_id % type;
700: l_dummy varchar2(80);
1135: l_note_id number;
1136: l_note_type jtf_notes_b.note_type % type;
1137: l_login_id jtf_notes_b.last_update_login % type;
1138: l_user_id jtf_notes_b.last_updated_by % type;
1139: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1140: l_incident_number cs_incidents_all_b.incident_number % type;
1141: cursor c_sr is
1142: select * from cs_incidents_all_b
1143: where incident_id = p_request_id;