The following lines contain the word 'select', 'insert', 'update' or 'delete':
select alarm_start, planned_start_date
from jtf_tasks_b t
where t.task_id = p_task_id;
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
) ;
PROCEDURE update_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_change_mode IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_APPOINTMENT';
SAVEPOINT update_appointment;
update_appointment (
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_category_id => p_category_id ,
p_free_busy_type => 'BUSY' ,
p_change_mode => p_change_mode ,
x_return_status => x_return_status
);
ROLLBACK TO update_appointment;
ROLLBACK TO update_appointment;
PROCEDURE update_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;
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 => '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
);
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
);
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
);
PROCEDURE delete_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;
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'
);