APPS.FND_OAM_DSCRAM_TASKS_PKG SQL Statements

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

Line: 19

      SELECT /*+ FIRST_ROWS(1) */ T.task_id, T.task_status
      FROM fnd_oam_dscram_tasks T
      WHERE T.bundle_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID
      AND T.task_status in (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
                            FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
                            FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_RESTARTABLE)
      AND (EXISTS (SELECT unit_id
                   FROM fnd_oam_dscram_units U
                   WHERE U.task_id = T.task_id
                   AND U.unit_status IN (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
                                         FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
                                         FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_RESTARTABLE)
                   AND U.concurrent_group_unit_id IS NULL
                   AND (U.actual_workers_allowed IS NULL OR U.actual_workers_allowed > U.workers_assigned)) OR
           T.workers_assigned = 0)
      ORDER BY priority ASC, weight DESC;

Line: 146

         SELECT task_status
         FROM fnd_oam_dscram_tasks
         WHERE task_id = p_task_id;

Line: 216

         SELECT task_status
         FROM fnd_oam_dscram_tasks
         WHERE task_id = b_task_info.task_id;

Line: 321

      SELECT task_status, workers_assigned
         INTO l_status, l_workers_assigned
         FROM fnd_oam_dscram_tasks
         WHERE task_id = p_task_id
         FOR UPDATE;

Line: 350

            UPDATE fnd_oam_dscram_tasks
               SET task_status = FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
               STATS_FINISHED = FND_API.G_FALSE
               WHERE task_id = p_task_id;

Line: 365

      UPDATE fnd_oam_dscram_tasks
         SET workers_assigned = workers_assigned + 1,
         last_updated_by = fnd_global.user_id,
         last_update_login = fnd_global.user_id,
         last_update_date = SYSDATE
         WHERE task_id = p_task_id;

Line: 416

      SELECT task_status, workers_assigned
         INTO l_status, l_workers_assigned
         FROM fnd_oam_dscram_tasks
         WHERE task_id = b_task_info.task_id
         FOR UPDATE;

Line: 434

         UPDATE fnd_oam_dscram_tasks
            SET workers_assigned = workers_assigned - 1,
            last_updated_by = fnd_global.user_id,
            last_update_login = fnd_global.user_id,
            last_update_date = SYSDATE
            WHERE task_id = b_task_info.task_id;

Line: 442

         UPDATE fnd_oam_dscram_tasks
            SET task_status = l_final_status,
            workers_assigned = workers_assigned - 1,
            last_updated_by = fnd_global.user_id,
            last_update_login = fnd_global.user_id,
            last_update_date = SYSDATE
            WHERE task_id = b_task_info.task_id;