APPS.IEU_UWQ_DISTRIBUTE_ITEMS dependencies on JTF_TASK_ASSIGNMENTS

Line 118: from jtf_task_assignments

114: /* in the following query we are doing rownum < 2 because we are ignoring assignment_status_id */
115: begin
116: select task_assignment_id, object_version_number
117: into l_assignment_id, l_object_version_number
118: from jtf_task_assignments
119: where resource_id = p_resource_id
120: and resource_type_code not in ('RS_TEAM', 'RS_GROUP')
121: and task_id = p_ws_input_data(j).workitem_pk_id
122: and rownum < 2;

Line 144: jtf_task_assignments_pub.update_task_assignment(

140: END IF;
141:
142: if l_assignment_id is not null then
143:
144: jtf_task_assignments_pub.update_task_assignment(
145: p_api_version => 1.0,
146: p_object_version_number => l_object_version_number,
147: p_init_msg_list => fnd_api.g_false,
148: p_commit => fnd_api.g_true,

Line 208: jtf_task_assignments_pub.create_task_assignment (

204: x_msg_count := l_msg_count;
205: x_msg_data := l_msg_data;
206:
207: else
208: jtf_task_assignments_pub.create_task_assignment (
209: p_api_version => 1.0,
210: p_init_msg_list => fnd_api.g_false,
211: p_commit => fnd_api.g_true,
212: p_task_id => p_ws_input_data(j).workitem_pk_id,