APPS.IEU_UWQ_DISTRIBUTE_ITEMS dependencies on JTF_TASK_ASSIGNMENTS

Line 116: from jtf_task_assignments

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

Line 127: jtf_task_assignments_pub.update_task_assignment(

123: end;
124:
125: if l_assignment_id is not null then
126:
127: jtf_task_assignments_pub.update_task_assignment(
128: p_api_version => 1.0,
129: p_object_version_number => l_object_version_number,
130: p_init_msg_list => fnd_api.g_false,
131: p_commit => fnd_api.g_true,

Line 191: jtf_task_assignments_pub.create_task_assignment (

187: x_msg_count := l_msg_count;
188: x_msg_data := l_msg_data;
189:
190: else
191: jtf_task_assignments_pub.create_task_assignment (
192: p_api_version => 1.0,
193: p_init_msg_list => fnd_api.g_false,
194: p_commit => fnd_api.g_true,
195: p_task_id => p_ws_input_data(j).workitem_pk_id,