The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_date_selected => 'S',
p_show_on_calendar => 'Y',
p_entity => 'BOOKING',
p_free_busy_type => l_booking_type_rec.freebusytype,
p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
p_reference_flag => 'N',
p_task_confirmation_status => NULL,
p_task_confirmation_counter => NULL,
p_task_split_flag => NULL,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_task_id => x_booking_id
);
PROCEDURE update_booking (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_booking_rec IN cac_bookings_pub.booking_type,
p_object_version_number IN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_version CONSTANT NUMBER
:= 1.0;
:= 'UPDATE_BOOKING';
SAVEPOINT update_bookings_pub;
jtf_tasks_pvt.update_task (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => l_ovn,
p_task_id => l_booking_type_rec.booking_id,
p_task_name => l_booking_type_rec.booking_subject,
p_task_type_id => l_booking_type_rec.booking_type_id,
p_description => l_booking_type_rec.description,
p_owner_type_code => l_booking_type_rec.resource_type_code,
p_owner_id => l_booking_type_rec.resource_id,
p_source_object_type_code => l_booking_type_rec.source_object_type_code,
p_source_object_id => l_booking_type_rec.source_object_id,
p_scheduled_start_date => l_booking_type_rec.start_date,
p_scheduled_end_date => l_booking_type_rec.end_date,
p_show_on_calendar => 'Y',
p_date_selected => 'S',
p_free_busy_type => l_booking_type_rec.freebusytype,
p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
p_change_mode => JTF_TASK_REPEAT_APPT_PVT.G_ONE,
p_task_confirmation_status => NULL,
p_task_confirmation_counter => NULL,
p_task_split_flag => NULL,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
ROLLBACK TO update_bookings_pub;
ROLLBACK TO update_bookings_pub;
PROCEDURE delete_booking (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_booking_id IN NUMBER,
p_object_version_number IN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_version CONSTANT NUMBER
:= 1.0;
:= 'DELETE_BOOKING';
SAVEPOINT delete_bookings_pub;
jtf_tasks_pvt.delete_task (
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_object_version_number => l_ovn,
p_task_id => l_task_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
ROLLBACK TO delete_bookings_pub;
ROLLBACK TO delete_bookings_pub;