[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,
672: procedure create_extnd_attr_tasks (
673: p_api_version in number,
674: p_init_msg_list in varchar2 ,
675: p_commit in varchar2 ,
676: p_sr_rec in CS_ServiceRequest_pub.service_request_rec_type,
677: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
678: p_request_id in number ,
679: p_incident_number in varchar2 ,
680: x_return_status OUT NOCOPY varchar2,
693: l_owner_id cs_incidents_all_b.incident_owner_id % type;
694: l_owner_group_id cs_incidents_all_b.owner_group_id % type;
695: l_last_updated_by cs_incidents_all_b.last_updated_by % type;
696: l_group_type varchar2(50);
697: l_sr_rec cs_servicerequest_pub.service_request_rec_type ;
698: l_task_owner_type jtf_tasks_b.owner_type_code % type;
699: l_task_owner_id jtf_tasks_b.owner_id%type;
700: l_location_id cs_incidents_all_b.incident_location_id % type;
701: l_dummy varchar2(80);
1167: l_note_id number;
1168: l_note_type jtf_notes_b.note_type % type;
1169: l_login_id jtf_notes_b.last_update_login % type;
1170: l_user_id jtf_notes_b.last_updated_by % type;
1171: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1172: l_incident_number cs_incidents_all_b.incident_number % type;
1173: cursor c_sr is
1174: select * from cs_incidents_all_b
1175: where incident_id = p_request_id;