APPS.CAC_VIEW_APPT_PVT SQL Statements

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

Line: 23

   select alarm_start, planned_start_date
     from jtf_tasks_b t
   where t.task_id = p_task_id;

Line: 90

       p_date_selected           => 'P',
       p_category_id             => p_category_id,
       p_show_on_calendar        => 'Y',
       p_owner_status_id         => 3,--Accepted
       p_enable_workflow         => 'N',
       p_abort_workflow          => 'N',
       p_entity                  => 'APPOINTMENT',
       p_free_busy_type          => p_free_busy_type
        ) ;

Line: 114

PROCEDURE update_external_appointment (
        p_object_version_number   IN   OUT NOCOPY NUMBER ,
        p_task_id                 IN       NUMBER,
        p_task_name               IN       VARCHAR2,
        p_task_type_id            IN       NUMBER,
        p_description             IN       VARCHAR2,
        p_task_priority_id        IN       NUMBER,
        p_planned_start_date      IN       DATE,
        p_planned_end_date        IN       DATE,
        p_timezone_id             IN       NUMBER,
        p_private_flag            IN       VARCHAR2,
        p_alarm_start             IN       NUMBER,
        p_alarm_on                IN       VARCHAR2,
        p_category_id             IN       NUMBER,
        p_free_busy_type          IN       VARCHAR2,
        p_change_mode             IN       VARCHAR2,
        x_return_status           OUT  NOCOPY VARCHAR2

   )
   IS
    l_msg_count   NUMBER;

Line: 142

   jtf_tasks_pvt.update_task(
       p_api_version                   => 1.0,
       p_object_version_number         => p_object_version_number,
       p_task_id                       => p_task_id,
       p_task_name                     => p_task_name,
       p_task_type_id                  => p_task_type_id,
       p_description                   => p_description,
       p_task_priority_id              => p_task_priority_id,
       p_planned_start_date            => p_planned_start_date,
       p_planned_end_date              => p_planned_end_date,
       p_timezone_id                   => p_timezone_id,
       p_private_flag                  => p_private_flag,
       p_alarm_start                   => p_alarm_start,
       p_alarm_on                      => p_alarm_on,
       p_source_object_type_code       => 'EXTERNAL APPOINTMENT',
       x_return_status                 => x_return_status,
       x_msg_count                     => l_msg_count,
       x_msg_data                      => l_msg_data,
       p_category_id                   => p_category_id ,
       p_enable_workflow               => 'N',
       p_abort_workflow                => 'N',
       p_change_mode                   => p_change_mode,
       p_free_busy_type                => p_free_busy_type
       );

Line: 170

      jtf_cal_wf_pvt.updatereminders(
            p_api_version   => 1.0,
            p_commit        => 'T',
            x_return_status => x_return_status,
            x_msg_count     => l_msg_count,
            x_msg_data      => l_msg_data,
            p_taskid        => p_task_id,
            p_reminddate    => NULL
          );

Line: 183

            jtf_cal_wf_pvt.updatereminders(
            p_api_version   => 1.0,
            p_commit        => 'T',
            x_return_status => x_return_status,
            x_msg_count     => l_msg_count,
            x_msg_data      => l_msg_data,
            p_taskid        => p_task_id,
            p_reminddate    => p_planned_start_date - p_alarm_start/1440
          );

Line: 196

  PROCEDURE delete_external_appointment (
      p_object_version_number       IN       NUMBER,
      p_task_id                     IN       NUMBER,
      p_delete_future_recurrences   IN       VARCHAR2,
      x_return_status               OUT  NOCOPY  VARCHAR2
   )
   IS
   l_msg_count   NUMBER;

Line: 207

     jtf_tasks_pvt.delete_task (
      p_api_version               => 1.0,
      p_object_version_number     => p_object_version_number,
      p_task_id                   => p_task_id,
      p_delete_future_recurrences =>  p_delete_future_recurrences,
      x_return_status             => x_return_status,
      x_msg_count                 => l_msg_count,
      x_msg_data                  => l_msg_data,
      p_enable_workflow           => 'N',
      p_abort_workflow            => 'N'
   );