APPS.JTA_CAL_APPOINTMENT_PVT_W SQL Statements

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

Line: 170

  procedure update_appointment(p_object_version_number in out nocopy  NUMBER
    , p_task_id  NUMBER
    , p_task_name  VARCHAR2
    , p_task_type_id  NUMBER
    , p_description  VARCHAR2
    , p_task_priority_id  NUMBER
    , p_planned_start_date  date
    , p_planned_end_date  date
    , p_timezone_id  NUMBER
    , p_private_flag  VARCHAR2
    , p_alarm_start  NUMBER
    , p_alarm_on  VARCHAR2
    , p_category_id  NUMBER
    , p_change_mode  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
  )

  as
    ddp_planned_start_date date;

Line: 212

    jta_cal_appointment_pvt.update_appointment(p_object_version_number,
      p_task_id,
      p_task_name,
      p_task_type_id,
      p_description,
      p_task_priority_id,
      ddp_planned_start_date,
      ddp_planned_end_date,
      p_timezone_id,
      p_private_flag,
      p_alarm_start,
      p_alarm_on,
      p_category_id,
      p_change_mode,
      x_return_status);

Line: 245

  procedure update_appointment(p_object_version_number in out nocopy  NUMBER
    , p_task_id  NUMBER
    , p_task_name  VARCHAR2
    , p_task_type_id  NUMBER
    , p_description  VARCHAR2
    , p_task_priority_id  NUMBER
    , p_planned_start_date  date
    , p_planned_end_date  date
    , p_timezone_id  NUMBER
    , p_private_flag  VARCHAR2
    , p_alarm_start  NUMBER
    , p_alarm_on  VARCHAR2
    , p_category_id  NUMBER
    , p_free_busy_type  VARCHAR2
    , p_change_mode  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
  )

  as
    ddp_planned_start_date date;

Line: 289

    jta_cal_appointment_pvt.update_appointment(p_object_version_number,
      p_task_id,
      p_task_name,
      p_task_type_id,
      p_description,
      p_task_priority_id,
      ddp_planned_start_date,
      ddp_planned_end_date,
      p_timezone_id,
      p_private_flag,
      p_alarm_start,
      p_alarm_on,
      p_category_id,
      p_free_busy_type,
      p_change_mode,
      x_return_status);