APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG SQL Statements

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

Line: 26

    SELECT source_object_type_code,
           source_object_id ,
           open_flag ,
           last_updated_by,
           last_update_login
      FROM jtf_tasks_b
     WHERE task_id = l_task_id;

Line: 39

    SELECT old_task_status_id ,
           new_task_status_id,
           last_updated_by
      FROM jtf_task_audits_b
     WHERE task_id = l_task_id
       AND task_audit_id = l_task_audit_id ;

Line: 84

             l_user_id          := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);

Line: 86

             l_login_id         := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;

Line: 93

    IF (l_event_name = 'oracle.apps.jtf.cac.task.updateTask') THEN

       l_task_id       := p_event.GetValueForParameter('TASK_ID');

Line: 116

             l_user_id          := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);

Line: 118

             l_login_id         := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;

Line: 171

    1) The event that triggered this subscription should be "updateTask" event
    2) The state restrictions profile option "CS_SR_TASK_STATE_ENABLED" should be set to value "Yes"
    3) The task that got cancelled/rejected should be non-field service task
    4) The non-field service task was in assigned state when it was cancelled/rejected
*/
FUNCTION CS_SR_SendNtf_To_NonFS_Task(p_subscription_guid in raw,
                                     p_event in out nocopy WF_EVENT_T) RETURN varchar2 is

-- Generic Event Parameters and Cursors
    l_event_name 	VARCHAR2(240) := p_event.getEventName( );

Line: 202

      SELECT old_task_status_id, new_task_status_id
      FROM JTF_TASK_AUDITS_VL
      WHERE task_audit_id = l_task_audit_id;

Line: 210

      SELECT assigned_flag, cancelled_flag, rejected_flag, start_date_type, end_date_type, name
        FROM JTF_TASK_STATUSES_VL
        WHERE task_status_id = l_task_status_id;

Line: 217

	  SELECT b.rule, a.task_name, a.description, a.task_number
	    FROM JTF_TASKS_VL a,
	         JTF_TASK_TYPES_B b
	    WHERE a.task_type_id = b.task_type_id
	      AND a.task_id = l_task_id;

Line: 227

    SELECT b.source_id
	FROM jtf_task_assignments a, jtf_rs_resource_extns b
	WHERE a.resource_id = b.resource_id(+) AND
   	      a.task_id = l_task_id;

Line: 233

    SELECT b.source_id
	FROM jtf_tasks_b a, jtf_rs_resource_extns b
	WHERE a.owner_id = b.resource_id(+) AND
   	      a.task_id = l_task_id;

Line: 251

    1) Task update has occurred
    2) An assigned non-field service task is cancelled/rejected
    3) State restrictions are enforced

    */
    IF (l_state_restrictions_on = 'Y' AND
	l_event_name = 'oracle.apps.jtf.cac.task.updateTask') THEN


      l_task_id := p_event.GetValueForParameter('TASK_ID');

Line: 400

    END IF;   -- End of IF (l_state_restrictions_on = 'Y' AND l_event_name = 'oracle.apps.jtf.cac.task.updateTask')