APPS.FND_OAM_DSCFG_OBJECTS_PKG SQL Statements

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

Line: 42

      INSERT INTO fnd_oam_dscfg_objects (OBJECT_ID,
                                         CONFIG_INSTANCE_ID,
                                         OBJECT_TYPE,
                                         PARENT_OBJECT_ID,
                                         SOURCE_PROC_ID,
                                         SOURCE_TYPE,
                                         SOURCE_ID,
                                         ERRORS_FOUND_FLAG,
                                         MESSAGE,
                                         CREATED_BY,
                                         CREATION_DATE,
                                         LAST_UPDATED_BY,
                                         LAST_UPDATE_DATE,
                                         LAST_UPDATE_LOGIN)
         VALUES (FND_OAM_DSCFG_OBJECTS_S.NEXTVAL,
                 l_config_instance_id,
                 p_object_type,
                 p_parent_object_id,
                 l_proc_id,
                 p_source_type,
                 p_source_id,
                 p_errors_found_flag,
                 p_message,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID)
         RETURNING OBJECT_ID INTO l_object_id;

Line: 96

      SELECT object_id
         BULK COLLECT INTO l_object_ids
         FROM fnd_oam_dscfg_objects
         WHERE object_type = p_object_type
         ORDER BY object_id asc;

Line: 125

         SELECT object_id
            BULK COLLECT INTO l_object_ids
            FROM fnd_oam_dscfg_objects
            WHERE object_type = p_object_type
            AND errors_found_flag IS NULL
            ORDER BY object_id asc;

Line: 132

         SELECT object_id
            BULK COLLECT INTO l_object_ids
            FROM fnd_oam_dscfg_objects
            WHERE object_type = p_object_type
            AND errors_found_flag = p_errors_found_flag
            ORDER BY object_id asc;

Line: 151

   FUNCTION DELETE_OBJECT(p_object_id   IN NUMBER,
                          p_recurse     IN VARCHAR2)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_OBJECT';

Line: 167

         IF NOT FND_OAM_DSCFG_PROPERTIES_PKG.DELETE_PROPERTIES(FND_OAM_DSCFG_API_PKG.G_TYPE_OBJECT,
                                                               p_object_id) THEN
            RETURN FALSE;

Line: 174

      DELETE FROM fnd_oam_dscfg_objects
         WHERE object_id = p_object_id;