[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 09-DEC-2003 cjang Added p_free_busy_type on create/update|
+======================================================================*/
PROCEDURE create_cal_assignment (
p_task_id IN NUMBER,
p_resources IN Resource_tbl,
p_add_option IN VARCHAR2,
p_invitor_res_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_task_assignment_ids OUT NOCOPY Task_Assign_tbl
) IS
l_return_status VARCHAR2(1);
PROCEDURE delete_cal_assignment
(p_object_version_number IN NUMBER,
p_task_assignments IN Task_Assign_tbl,
p_delete_option IN VARCHAR2,
p_no_of_attendies IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2
)
IS
l_return_status VARCHAR2(1);
JTF_TASK_ASSIGNMENTS_PVT.Delete_Task_Assignment
( p_api_version => 1.0,
p_object_version_number => p_object_version_number,
p_task_assignment_id => p_task_assignments(i).task_assignment_id,
p_enable_workflow => 'N',
p_abort_workflow => 'N',
p_delete_option => p_delete_option,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data );
fnd_message.set_name ('JTA', 'JTA_CAL_DELETE_TASK_ASSIGN_ERROR');
fnd_message.set_token ('Delete Task Assignment failed for task_assignment_id:',
p_task_assignments(i).task_assignment_id);
PROCEDURE update_cal_assignment (
p_object_version_number IN OUT NOCOPY NUMBER,
p_task_assignment_id IN NUMBER,
p_resource_id IN NUMBER,
p_resource_type IN VARCHAR2,
p_assignment_status_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2
) IS
l_return_status VARCHAR2(1);
JTF_TASK_ASSIGNMENTS_PVT.update_task_assignment (
p_api_version => 1.0,
p_object_version_number => p_object_version_number,
p_init_msg_list => 'T', --?
p_task_assignment_id => p_task_assignment_id,
p_resource_type_code => p_resource_type,
p_resource_id => p_resource_id,
p_schedule_flag => fnd_api.g_miss_char, --Y Or N??
p_actual_start_date => null, --?
p_actual_end_date => null, --?
p_assignment_status_id => p_assignment_status_id,
p_show_on_calendar => 'Y',
p_enable_workflow => 'N',
p_abort_workflow => 'N',
p_free_busy_type => l_free_busy_type,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
) ;