APPS.JTF_TASK_WF_SUBSCRIBE_PVT SQL Statements

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

Line: 47

  FUNCTION update_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
    RETURN VARCHAR2 IS
    l_task_id                 jtf_tasks_b.task_id%TYPE;

Line: 59

      SELECT new_task_type_id
           , old_task_type_id
           , new_task_status_id
           , old_task_status_id
           , new_description
           , old_description
           , new_task_priority_id
           , old_task_priority_id
           , new_planned_start_date
           , old_planned_start_date
           , new_planned_end_date
           , old_planned_end_date
           , new_scheduled_start_date
           , old_scheduled_start_date
           , new_scheduled_end_date
           , old_scheduled_end_date
           , new_actual_start_date
           , old_actual_start_date
           , new_actual_end_date
           , old_actual_end_date
           , new_owner_id
           , old_owner_id
           , new_owner_type_code
           , old_owner_type_code
        FROM jtf_task_audits_vl
       WHERE task_audit_id = b_task_audit_id;

Line: 141

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_task_notif_subs', p_event.event_name, p_subscription_guid);

Line: 149

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_task_notif_subs', p_event.event_name, p_subscription_guid);

Line: 152

  END update_task_notif_subs;

Line: 154

  FUNCTION delete_task_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
    RETURN VARCHAR2 IS
    l_task_id                 jtf_tasks_b.task_id%TYPE;

Line: 173

            p_event                      => 'DELETE_TASK'
          , p_task_id                    => l_task_id
          , p_abort_workflow             => l_abort_workflow
          , x_return_status              => x_return_status
          , x_msg_count                  => x_msg_count
          , x_msg_data                   => x_msg_data
          );

Line: 185

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_task_notif_subs', p_event.event_name, p_subscription_guid);

Line: 193

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_task_notif_subs', p_event.event_name, p_subscription_guid);

Line: 196

  END delete_task_notif_subs;

Line: 246

  FUNCTION update_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
    RETURN VARCHAR2 IS
    l_enable_workflow         VARCHAR2(1);

Line: 311

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_assg_notif_subs', p_event.event_name, p_subscription_guid);

Line: 319

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_assg_notif_subs', p_event.event_name, p_subscription_guid);

Line: 322

  END update_assg_notif_subs;

Line: 324

  FUNCTION delete_assg_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
    RETURN VARCHAR2 IS
    l_enable_workflow    VARCHAR2(1);

Line: 348

          p_event                      => 'DELETE_ASSIGNEE'
        , p_task_id                    => l_task_id
        , p_old_assignee_id            => l_resource_id
        , p_old_assignee_code          => l_resource_type_code
        , p_abort_workflow             => l_abort_workflow
        , x_return_status              => x_return_status
        , x_msg_count                  => x_msg_count
        , x_msg_data                   => x_msg_data
        );

Line: 361

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_assg_notif_subs', p_event.event_name, p_subscription_guid);

Line: 369

      wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_assg_notif_subs', p_event.event_name, p_subscription_guid);

Line: 372

  END delete_assg_notif_subs;