APPS.JTA_SYNC_TASK_UTL SQL Statements

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

Line: 15

| UPDATE NOTES
| Date          Developer                Change
|------------   ---------------     -------------------------------------
| 28-May-2002   Chanik Jang         Created.
| 10-Feb-2006   Swapan Barat        Added NOCOPY hint for OUT parameter. Bug# 5029957
|                                   (Using dual check-in option to check-in file so that the
|                                   code can be propagated in both ver 11 and 12 line, since
|                                   NOCOPY is a mandatory mandate for all pl/sql packages.)
*=======================================================================*/

    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);

Line: 58

        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;

Line: 85

        SELECT task_sync_id
          FROM jta_sync_task_mapping
         WHERE task_id = b_task_id;

Line: 106

    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;

Line: 140

                    jta_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
                    );

Line: 149

    END update_mapping;