APPS.FND_OAM_DSCRAM_UTILS_PKG SQL Statements

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

Line: 273

         SELECT task_status
            INTO l_current_status
            FROM fnd_oam_dscram_tasks
            WHERE task_id = l_id
            FOR UPDATE;

Line: 280

            UPDATE fnd_oam_dscram_tasks
               SET task_status = G_STATUS_STOPPING,
               last_updated_by = fnd_global.user_id,
               last_update_login = fnd_global.user_id,
               last_update_date = SYSDATE
               WHERE task_id = l_id;

Line: 293

         SELECT bundle_status
            INTO l_current_status
            FROM fnd_oam_dscram_bundles
            WHERE bundle_id = l_id
            FOR UPDATE;

Line: 300

            UPDATE fnd_oam_dscram_bundles
               SET bundle_status = G_STATUS_STOPPING,
               last_updated_by = fnd_global.user_id,
               last_update_login = fnd_global.user_id,
               last_update_date = SYSDATE
               WHERE bundle_id = l_id;

Line: 313

         SELECT run_status
            INTO l_current_status
            FROM fnd_oam_dscram_runs_b
            WHERE run_id = l_id
            FOR UPDATE;

Line: 320

            UPDATE fnd_oam_dscram_runs_b
               SET run_status = G_STATUS_STOPPING,
               last_updated_by = fnd_global.user_id,
               last_update_login = fnd_global.user_id,
               last_update_date = SYSDATE
               WHERE run_id = l_id;

Line: 477

   PROCEDURE DELETE_STATS(p_object_type IN VARCHAR2,
                          p_object_id   IN VARCHAR2)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_STATS';

Line: 485

      DELETE FROM fnd_oam_dscram_stats
         WHERE source_object_type = p_object_type
         AND source_object_id = p_object_id;

Line: 497

   PROCEDURE DELETE_ARGS(p_object_type  IN VARCHAR2,
                         p_object_id    IN VARCHAR2)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_ARGS';

Line: 508

      SELECT arg_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_args_b
         WHERE parent_type = p_object_type
         AND parent_id = p_object_id;

Line: 517

         DELETE FROM fnd_oam_dscram_args_b
            WHERE arg_id = l_id;

Line: 519

         DELETE FROM fnd_oam_dscram_args_tl
            WHERE arg_id = l_id;

Line: 521

         DELETE FROM fnd_oam_dscram_arg_values
            WHERE arg_id = l_id;

Line: 534

   FUNCTION DELETE_AD_DATA(p_run_id             IN NUMBER,
                           p_unit_id            IN NUMBER,
                           p_owner              IN VARCHAR2,
                           p_table_name         IN VARCHAR2)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_AD_DATA';

Line: 550

      SELECT update_id
         BULK COLLECT INTO l_ids
         FROM ad_parallel_updates
         WHERE owner = p_owner
         AND table_name = p_table_name
         AND script_name = l_script_key;

Line: 560

         fnd_oam_debug.log(1, l_ctxt, 'AD Update ID: '||l_id);

Line: 561

         DELETE FROM ad_parallel_workers
            WHERE update_id = l_id;

Line: 563

         DELETE FROM ad_parallel_update_units
            WHERE update_id = l_id;

Line: 565

         DELETE FROM ad_parallel_updates
            WHERE update_id = l_id;

Line: 580

   FUNCTION DELETE_PLSQL(p_plsql_id     IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_PLSQL';

Line: 593

      DELETE_STATS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
                   p_plsql_id);

Line: 596

      DELETE_ARGS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
                   p_plsql_id);

Line: 601

      DELETE FROM fnd_oam_dscram_plsqls
         WHERE plsql_id = p_plsql_id;

Line: 614

   FUNCTION DELETE_DML(p_dml_id IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_DML';

Line: 627

      DELETE_STATS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
                   p_dml_id);

Line: 630

      DELETE_ARGS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
                   p_dml_id);

Line: 635

      DELETE FROM fnd_oam_dscram_dmls
         WHERE dml_id = p_dml_id;

Line: 648

   FUNCTION DELETE_UNIT(p_run_id        IN NUMBER,
                        p_unit_id       IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_UNIT';

Line: 667

      SELECT unit_type, unit_object_owner, unit_object_name
         INTO l_unit_type, l_object_owner, l_object_name
         FROM fnd_oam_dscram_units
         WHERE unit_id = p_unit_id;

Line: 673

      SELECT unit_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_units
         WHERE concurrent_group_unit_id = p_unit_id;

Line: 681

         IF NOT DELETE_UNIT(p_run_id,
                            l_ids(k)) THEN
            fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line: 691

      SELECT dml_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_dmls
         WHERE unit_id = p_unit_id;

Line: 699

         IF NOT DELETE_DML(l_ids(k)) THEN
            fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line: 708

      SELECT plsql_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_plsqls
         WHERE unit_id = p_unit_id;

Line: 716

         IF NOT DELETE_PLSQL(l_ids(k)) THEN
            fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line: 725

      IF NOT DELETE_AD_DATA(p_run_id,
                            p_unit_id,
                            l_object_owner,
                            l_object_name) THEN
         fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line: 733

      DELETE_STATS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_UNIT,
                   p_unit_id);

Line: 738

      DELETE FROM fnd_oam_dscram_units
         WHERE unit_id = p_unit_id;

Line: 751

   FUNCTION DELETE_TASK(p_run_id        IN NUMBER,
                        p_task_id       IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_TASK';

Line: 766

      SELECT unit_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_units
         WHERE task_id = p_task_id
         AND concurrent_group_unit_id IS NULL;

Line: 774

         IF NOT DELETE_UNIT(p_run_id,
                            l_ids(k)) THEN
            fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line: 783

      DELETE_STATS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_TASK,
                   p_task_id);

Line: 788

      DELETE FROM fnd_oam_dscram_tasks
         WHERE task_id = p_task_id;

Line: 801

   FUNCTION DELETE_BUNDLE(p_run_id      IN NUMBER,
                          p_bundle_id   IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_BUNDLE';

Line: 816

      SELECT task_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_tasks
         WHERE bundle_id = p_bundle_id;

Line: 823

         IF NOT DELETE_TASK(p_run_id,
                            l_ids(k)) THEN
            fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line: 832

      DELETE_STATS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_BUNDLE,
                   p_bundle_id);

Line: 837

      DELETE FROM fnd_oam_dscram_bundles
         WHERE bundle_id = p_bundle_id;

Line: 850

   FUNCTION DELETE_RUN(p_run_id         IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_RUN';

Line: 874

      SELECT bundle_id
         BULK COLLECT INTO l_ids
         FROM fnd_oam_dscram_bundles
         WHERE RUN_ID = p_run_id;

Line: 883

         IF NOT DELETE_BUNDLE(p_run_id,
                              l_ids(k)) THEN
            l_retbool := FALSE;

Line: 893

      DELETE_STATS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RUN,
                   p_run_id);

Line: 896

      DELETE_ARGS(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RUN,
                  p_run_id);

Line: 901

      DELETE FROM fnd_oam_dscram_runs_b
         WHERE run_id = p_run_id;

Line: 903

      DELETE FROM fnd_oam_dscram_runs_tl
         WHERE run_id = p_run_id;

Line: 914

      SELECT count(*)
         INTO k
         FROM fnd_oam_dscram_runs_b;

Line: 918

      SELECT count(*)
         INTO k
         FROM fnd_oam_dscram_runs_tl;

Line: 1178

            SELECT unit_id
               INTO l_parent_id
               FROM fnd_oam_dscram_plsqls
               WHERE plsql_id = p_plsql_ids(k);

Line: 1203

         UPDATE fnd_oam_dscram_plsqls
           SET finished_ret_sts = NULL
           WHERE plsql_id = p_plsql_ids(k)
           AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;

Line: 1242

            SELECT unit_id
               INTO l_parent_id
               FROM fnd_oam_dscram_dmls
               WHERE dml_id = p_dml_ids(k);

Line: 1267

         UPDATE fnd_oam_dscram_dmls
           SET finished_ret_sts = NULL
           WHERE dml_id = p_dml_ids(k)
           AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;

Line: 1310

            SELECT unit_id
               BULK COLLECT INTO l_ids
               FROM fnd_oam_dscram_units
               WHERE concurrent_group_unit_id = p_unit_ids(k);

Line: 1322

            l_ids.DELETE;

Line: 1323

            SELECT dml_id
               BULK COLLECT INTO l_ids
               FROM fnd_oam_dscram_dmls
               WHERE unit_id = p_unit_ids(k)
               AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;

Line: 1336

            l_ids.DELETE;

Line: 1337

            SELECT plsql_id
               BULK COLLECT INTO l_ids
               FROM fnd_oam_dscram_plsqls
               WHERE unit_id = p_unit_ids(k)
               AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;

Line: 1353

            SELECT task_id
               INTO l_parent_id
               FROM fnd_oam_dscram_units
               WHERE unit_id = p_unit_ids(k);

Line: 1379

         UPDATE fnd_oam_dscram_units
           SET unit_status = G_STATUS_RESTARTABLE,
               workers_assigned = 0
           WHERE unit_id = p_unit_ids(k)
           AND unit_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_NO_STATUS, G_STATUS_UNPROCESSED);

Line: 1424

            SELECT unit_id
               BULK COLLECT INTO l_ids
               FROM fnd_oam_dscram_units
               WHERE task_id = p_task_ids(k)
               AND unit_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_NO_STATUS, G_STATUS_UNPROCESSED);

Line: 1440

            SELECT bundle_id
               INTO l_parent_id
               FROM fnd_oam_dscram_tasks
               WHERE task_id = p_task_ids(k);

Line: 1465

         UPDATE fnd_oam_dscram_tasks
           SET task_status = G_STATUS_RESTARTABLE,
               workers_assigned = 0
           WHERE task_id = p_task_ids(k)
           AND task_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line: 1510

            SELECT task_id
               BULK COLLECT INTO l_ids
               FROM fnd_oam_dscram_tasks
               WHERE bundle_id = p_bundle_ids(k)
               AND task_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line: 1526

            SELECT run_id
               INTO l_parent_id
               FROM fnd_oam_dscram_bundles
               WHERE bundle_id = p_bundle_ids(k);

Line: 1550

         UPDATE fnd_oam_dscram_bundles
           SET bundle_status = G_STATUS_RESTARTABLE,
               workers_assigned = 0
           WHERE bundle_id = p_bundle_ids(k)
           AND bundle_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line: 1589

            SELECT bundle_id
               BULK COLLECT INTO l_ids
               FROM fnd_oam_dscram_bundles
               WHERE run_id = p_run_ids(k)
               AND bundle_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line: 1604

         UPDATE fnd_oam_dscram_runs_b
           SET run_status = G_STATUS_RESTARTABLE
           WHERE run_id = p_run_ids(k)
           AND run_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line: 1642

      SELECT run_status
         INTO l_status
         FROM fnd_oam_dscram_runs_b
         WHERE run_id = p_run_id;

Line: 1653

         SELECT bundle_id
            BULK COLLECT INTO l_ids
            FROM fnd_oam_dscram_bundles
            WHERE RUN_ID = p_run_id;

Line: 1665

      UPDATE fnd_oam_dscram_runs_b
         SET run_status = G_STATUS_RESTARTABLE
         WHERE run_id = p_run_id;