202: x_return_status VARCHAR2(200);
203: x_msg_count NUMBER;
204: x_msg_data VARCHAR2(1000);
205: l_task_id jtf_tasks_b.task_id%TYPE;
206: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
203: x_msg_count NUMBER;
204: x_msg_data VARCHAR2(1000);
205: l_task_id jtf_tasks_b.task_id%TYPE;
206: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
204: x_msg_data VARCHAR2(1000);
205: l_task_id jtf_tasks_b.task_id%TYPE;
206: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
207: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
208: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
209: BEGIN
210: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
211: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);
212: l_resource_id := wf_event.getvalueforparameter('RESOURCE_ID', p_event.parameter_list);
246: FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
247: RETURN VARCHAR2 IS
248: l_enable_workflow VARCHAR2(1);
249: l_abort_workflow VARCHAR2(1);
250: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
251: x_return_status VARCHAR2(200);
252: x_msg_count NUMBER;
253: x_msg_data VARCHAR2(1000);
254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
250: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
251: x_return_status VARCHAR2(200);
252: x_msg_count NUMBER;
253: x_msg_data VARCHAR2(1000);
254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
255: l_task_id jtf_tasks_b.task_id%TYPE;
256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
252: x_msg_count NUMBER;
253: x_msg_data VARCHAR2(1000);
254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
255: l_task_id jtf_tasks_b.task_id%TYPE;
256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
253: x_msg_data VARCHAR2(1000);
254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
255: l_task_id jtf_tasks_b.task_id%TYPE;
256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
254: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
255: l_task_id jtf_tasks_b.task_id%TYPE;
256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
255: l_task_id jtf_tasks_b.task_id%TYPE;
256: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
257: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
258: l_orig_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
259: l_orig_resource_id jtf_task_all_assignments.resource_id%TYPE;
260: BEGIN
261: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
262: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
263: l_resource_type_code := wf_event.getvalueforparameter('NEW_RESOURCE_TYPE_CODE', p_event.parameter_list);
327: l_abort_workflow VARCHAR2(1);
328: x_return_status VARCHAR2(200);
329: x_msg_count NUMBER;
330: x_msg_data VARCHAR2(1000);
331: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
332: l_task_id jtf_tasks_b.task_id%TYPE;
333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
329: x_msg_count NUMBER;
330: x_msg_data VARCHAR2(1000);
331: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
332: l_task_id jtf_tasks_b.task_id%TYPE;
333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
330: x_msg_data VARCHAR2(1000);
331: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
332: l_task_id jtf_tasks_b.task_id%TYPE;
333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
331: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
332: l_task_id jtf_tasks_b.task_id%TYPE;
333: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
334: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
335: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
336: BEGIN
337: l_task_assignment_id := wf_event.getvalueforparameter('TASK_ASSIGNMENT_ID', p_event.parameter_list);
338: l_task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
339: l_resource_type_code := wf_event.getvalueforparameter('RESOURCE_TYPE_CODE', p_event.parameter_list);