The following lines contain the word 'select', 'insert', 'update' or 'delete':
| UPDATE NOTES
| Date Developer Change
|------------ --------------- -------------------------------------
| 28-May-2002 Chanik Jang Created.
*=======================================================================*/
FUNCTION is_this_first_task(p_task_id IN NUMBER)
RETURN BOOLEAN
IS
CURSOR c_first_taskid (b_task_id NUMBER) IS
SELECT min(task_id) task_id
FROM jtf_tasks_b
WHERE NVL(deleted_flag,'N') = 'N'
AND recurrence_rule_id = (SELECT recurrence_rule_id
FROM jtf_tasks_b
WHERE task_id = b_task_id);
SELECT task_id
FROM jtf_tasks_b
WHERE calendar_start_date > b_start_date
AND recurrence_rule_id = b_recurrence_rule_id
AND NVL(deleted_flag,'N') = 'N'
HAVING ROWNUM = 1
GROUP BY ROWNUM, task_id, calendar_start_date
ORDER BY calendar_start_date;
SELECT task_sync_id, principal_id
FROM jta_sync_task_mapping
WHERE task_id = b_task_id;
PROCEDURE update_mapping(p_task_id IN NUMBER)
IS
CURSOR c_assignee (b_task_id NUMBER) IS
SELECT jtaa.resource_id
, jtb.calendar_start_date
, jtb.recurrence_rule_id
FROM jtf_task_all_assignments jtaa
, jtf_tasks_b jtb
WHERE jtaa.task_id = b_task_id
AND jtb.task_id = jtaa.task_id;
cac_sync_task_map_pkg.update_row (
p_task_sync_id => l_sync_id,
p_task_id => l_new_minimum_task_id,
p_resource_id => rec_assignee.resource_id,
p_principal_id => l_principal_id
);
END update_mapping;