APPS.FND_OAM_DSCFG_PROC_LIBRARY_PKG SQL Statements

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

Line: 29

   PROCEDURE UPDATE_OBJECT_WITH_ERROR(p_ctxt            IN VARCHAR2,
                                      p_object_id       IN NUMBER,
                                      p_message         IN VARCHAR2)
   IS
      l_msg     VARCHAR2(4000);

Line: 37

      UPDATE fnd_oam_dscfg_objects
         SET errors_found_flag = FND_API.G_TRUE,
             message = l_msg
         WHERE object_id = p_object_id;

Line: 44

   PROCEDURE UPDATE_OBJECT_WITH_ERROR(p_ctxt            IN VARCHAR2,
                                      p_object_id       IN NUMBER,
                                      p_error_code      IN NUMBER,
                                      p_error_msg       IN VARCHAR2)
   IS
      l_msg     VARCHAR2(4000);

Line: 52

      UPDATE_OBJECT_WITH_ERROR(p_ctxt,
                               p_object_id,
                               l_msg);

Line: 58

   PROCEDURE UPDATE_OBJECT_WITH_WARNING(p_ctxt          IN VARCHAR2,
                                        p_object_id     IN NUMBER,
                                        p_message       IN VARCHAR2)
   IS
      l_msg     VARCHAR2(4000);

Line: 66

      UPDATE fnd_oam_dscfg_objects
         SET errors_found_flag = NULL,
             message = l_msg
         WHERE object_id = p_object_id;

Line: 73

   PROCEDURE UPDATE_OBJECT_WITH_SUCCESS(p_ctxt          IN VARCHAR2,
                                        p_object_id     IN NUMBER)
   IS
   BEGIN
      UPDATE fnd_oam_dscfg_objects
         SET errors_found_flag = FND_API.G_FALSE,
             message = NULL
         WHERE object_id = p_object_id;

Line: 102

         SELECT owner as trigger_owner, trigger_name
         FROM   dba_triggers
         WHERE  table_owner = p_table_owner
         AND    table_name = p_table_name
         AND    status = 'ENABLED';

Line: 154

                     UPDATE_OBJECT_WITH_ERROR(l_ctxt,
                                              l_object_id,
                                              SQLCODE,
                                              SQLERRM);

Line: 232

            UPDATE_OBJECT_WITH_SUCCESS(l_ctxt,
                                       l_object_ids(k));

Line: 238

               UPDATE_OBJECT_WITH_ERROR(l_ctxt,
                                        l_object_ids(k),
                                        SQLCODE,
                                        SQLERRM);

Line: 329

                  UPDATE_OBJECT_WITH_ERROR(l_ctxt,
                                           l_object_id,
                                           SQLCODE,
                                           SQLERRM);

Line: 428

            UPDATE_OBJECT_WITH_SUCCESS(l_ctxt,
                                       l_object_ids(k));

Line: 434

               UPDATE_OBJECT_WITH_ERROR(l_ctxt,
                                        l_object_ids(k),
                                        SQLCODE,
                                        SQLERRM);