APPS.JTF_TASK_WF_EVENTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 37

    l_list.DELETE;

Line: 42

  PROCEDURE publish_update_task
  (
       P_TASK_REC_OLD		IN	jtf_tasks_pvt.Task_Rec_type,
       P_TASK_REC_NEW		IN	jtf_tasks_pvt.Task_Rec_type,
       x_return_status  OUT NOCOPY       VARCHAR2
  ) IS
   l_list                       WF_PARAMETER_LIST_T;

Line: 56

    l_event_name := 'oracle.apps.jtf.cac.task.updateTask';

Line: 67

	-- Raise the update task Event
    wf_event.raise3(
			       p_event_name        => l_event_name,
			       p_event_key         => l_key,
			       p_parameter_list    => l_list,
			       p_send_date         => sysdate
				  );

Line: 80

    l_list.DELETE;

Line: 83

 END publish_update_task;

Line: 85

  PROCEDURE publish_delete_task (
       P_TASK_REC		IN	jtf_tasks_pvt.Task_Rec_type,
       x_return_status  OUT NOCOPY       VARCHAR2
  )
  IS
   l_list		WF_PARAMETER_LIST_T;

Line: 92

   l_event_name		varchar2(240) := 'oracle.apps.jtf.cac.task.deleteTask';

Line: 116

    l_list.DELETE;

Line: 119

 END publish_delete_task;

Line: 160

	l_list.DELETE;

Line: 165

  PROCEDURE publish_update_assignment (
      P_ASSIGNMENT_REC_NEW	IN	jtf_task_assignments_pvt.task_assignments_rec,
	  P_ASSIGNMENT_REC_OLD	IN	jtf_task_assignments_pvt.task_assignments_rec,
      x_return_status  OUT NOCOPY       VARCHAR2
  )
  IS
    l_list   WF_PARAMETER_LIST_T;

Line: 173

	l_event_name   VARCHAR2(240) := 'oracle.apps.jtf.cac.task.updateTaskAssignment';

Line: 202

	l_list.DELETE;

Line: 206

  PROCEDURE publish_delete_assignment (
      P_ASSIGNMENT_REC	IN	jtf_task_assignments_pvt.task_assignments_rec,
      x_return_status  OUT NOCOPY       VARCHAR2
  )
  IS
   l_list		    WF_PARAMETER_LIST_T;

Line: 213

   l_event_name		varchar2(240) := 'oracle.apps.jtf.cac.task.deleteTaskAssignment';

Line: 237

    l_list.DELETE;

Line: 246

  	SELECT p_event_name ||'-'|| jtf_task_wf_events_s.nextval INTO l_key FROM DUAL;