APPS.FND_OAM_DSCRAM_PLSQLS_PKG SQL Statements

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

Line: 70

      SELECT plsql_id, priority, weight
         BULK COLLECT INTO l_ids, l_priorities, l_weights
         FROM fnd_oam_dscram_plsqls
         WHERE unit_id = p_unit_id
         AND finished_ret_sts IS NULL
         ORDER BY priority ASC, weight DESC;

Line: 103

   PROCEDURE UPDATE_COMP_PLS_WRITABLE_ARGS(p_plsql_id           IN NUMBER,
                                           px_arg_context       IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
                                           p_using_splitting    IN BOOLEAN,
                                           x_return_status      OUT NOCOPY VARCHAR2,
                                           x_return_msg         OUT NOCOPY VARCHAR2)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'UPDATE_COMP_PLS_WRITABLE_ARGS';

Line: 150

         FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_plsql_cache(p_plsql_id).arg_list,
                                                            px_arg_context,
                                                            TRUE,
                                                            b_plsql_cache(p_plsql_id).use_splitting,
                                                            NULL,
                                                            NULL,
                                                            NULL,
                                                            l_return_status,
                                                            l_return_msg);

Line: 182

                                          p_update_context      IN BOOLEAN,
                                          x_return_status       OUT NOCOPY VARCHAR2,
                                          x_return_msg          OUT NOCOPY VARCHAR2)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'INTERNAL_DESTROY_CACHE_ENTRY';

Line: 195

      IF p_update_context THEN
         FND_OAM_DSCRAM_ARGS_PKG.UPDATE_CONTEXT_USING_ARG_LIST(px_arg_context,
                                                               b_plsql_cache(p_plsql_id).arg_list,
                                                               b_plsql_cache(p_plsql_id).use_splitting);

Line: 217

      b_plsql_cache.DELETE(p_plsql_id);

Line: 231

                                       p_update_context IN BOOLEAN,
                                       x_return_status  OUT NOCOPY VARCHAR2,
                                       x_return_msg     OUT NOCOPY VARCHAR2)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DESTROY_PLSQL_CACHE_ENTRY';

Line: 256

                                   p_update_context,
                                   x_return_status,
                                   x_return_msg);

Line: 306

      b_plsql_cache.DELETE;

Line: 355

      SELECT finished_ret_sts
         INTO l_finished_ret_sts
         FROM fnd_oam_dscram_plsqls
         WHERE plsql_id = p_plsql_id
         FOR UPDATE;

Line: 385

      UPDATE fnd_oam_dscram_plsqls
         SET finished_ret_sts = l_finished_ret_sts,
         last_updated_by = fnd_global.user_id,
         last_update_login = fnd_global.user_id,
         last_update_date = SYSDATE
         WHERE plsql_id = p_plsql_id;

Line: 461

      SELECT plsql_text, plsql_final_text
         INTO l_plsql_text, l_final_plsql_text
         FROM fnd_oam_dscram_plsqls
         WHERE plsql_id = p_plsql_id
         FOR UPDATE;

Line: 489

      UPDATE fnd_oam_dscram_plsqls
         SET plsql_final_text = l_final_plsql_text,
         stats_finished = FND_API.G_FALSE,
         last_updated_by = fnd_global.user_id,
         last_update_login = fnd_global.user_id,
         last_update_date = SYSDATE
         WHERE plsql_id = p_plsql_id;

Line: 553

      SELECT plsql_final_text
         INTO l_final_plsql_text
         FROM fnd_oam_dscram_plsqls
         WHERE plsql_id = p_plsql_id;

Line: 715

         FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_plsql_cache(p_plsql_id).arg_list,
                                                            px_arg_context,
                                                            NOT p_use_splitting,        --we're finished if we're not splitting
                                                            p_use_splitting,
                                                            p_rowid_lbound,
                                                            p_rowid_ubound,
                                                            b_plsql_cache(p_plsql_id).cursor_id,
                                                            l_return_status,
                                                            l_return_msg);