APPS.FND_OAM_DSCRAM_BUNDLES_PKG SQL Statements

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

Line: 111

         SELECT bundle_status, workers_allowed, workers_assigned
         FROM fnd_oam_dscram_bundles
         WHERE run_id = p_run_id
         AND bundle_id = p_bundle_id;

Line: 194

         SELECT bundle_status
         FROM fnd_oam_dscram_bundles
         WHERE bundle_id = b_bundle_info.bundle_id;

Line: 319

      SELECT bundle_status, workers_allowed, workers_assigned, batch_size, min_parallel_unit_weight
         INTO l_status, l_workers_allowed, l_workers_assigned, l_batch_size, l_min_parallel_unit_weight
         FROM fnd_oam_dscram_bundles
         WHERE bundle_id = p_bundle_id
         FOR UPDATE;

Line: 362

            UPDATE fnd_oam_dscram_bundles
               SET bundle_status = FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
               STATS_FINISHED = FND_API.G_FALSE
               WHERE bundle_id = p_bundle_id;

Line: 386

      UPDATE fnd_oam_dscram_bundles
         SET workers_assigned = l_workers_assigned + 1,
         last_updated_by = fnd_global.user_id,
         last_update_login = fnd_global.user_id,
         last_update_date = SYSDATE
         WHERE bundle_id = p_bundle_id;

Line: 455

      SELECT bundle_status, workers_assigned
         INTO l_status, l_workers_assigned
         FROM fnd_oam_dscram_bundles
         WHERE bundle_id = b_bundle_info.bundle_id
         FOR UPDATE;

Line: 472

      UPDATE fnd_oam_dscram_bundles
         SET bundle_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 bundle_id = b_bundle_info.bundle_id;

Line: 768

      SELECT UPPER(host_name)
         INTO l_host_name
         FROM v$instance;

Line: 773

      SELECT bundle_id
         BULK COLLECT INTO l_bundle_ids
         FROM fnd_oam_dscram_bundles
         WHERE run_id = p_run_id
         AND (target_hostname = l_host_name OR target_hostname IS NULL)
         ORDER BY target_hostname DESC, weight DESC;