APPS.FND_OAM_DSCFG_API_PKG SQL Statements

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

Line: 99

      l_ctxt                    VARCHAR2(60) := PKG_NAME||'ADD_DML_UPDATE_SEGMENT';

Line: 113

      SELECT DISTINCT p1.canonical_value, p2.canonical_value
         BULK COLLECT INTO x_table_owners, x_table_names
         FROM (SELECT object_id
               FROM fnd_oam_dscfg_objects
               WHERE config_instance_id = FND_OAM_DSCFG_INSTANCES_PKG.GET_CURRENT_ID
               AND object_type in (G_OTYPE_DML_UPDATE_SEGMENT,
                                   G_OTYPE_DML_DELETE_STMT,
                                   G_OTYPE_DML_TRUNCATE_STMT,
                                   G_OTYPE_PLSQL_TEXT)) o,
         fnd_oam_dscfg_properties p1,
         fnd_oam_dscfg_properties p2
         WHERE p1.parent_type = G_TYPE_OBJECT
         AND p1.parent_id = o.object_id
         AND p1.property_name = G_PROP_TABLE_OWNER
         AND p2.parent_type = G_TYPE_OBJECT
         AND p2.parent_id = o.object_id
         AND p2.property_name = G_PROP_TABLE_NAME;

Line: 143

   PROCEDURE ADD_DML_UPDATE_SEGMENT(p_table_owner               IN VARCHAR2,
                                    p_table_name                IN VARCHAR2,
                                    p_column_name               IN VARCHAR2,
                                    p_new_column_value          IN VARCHAR2,
                                    p_where_clause              IN VARCHAR2,
                                    p_weight_modifier           IN NUMBER,
                                    p_source_type               IN VARCHAR2,
                                    p_source_id                 IN NUMBER,
                                    x_object_id                 OUT NOCOPY NUMBER)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'ADD_DML_UPDATE_SEGMENT';

Line: 163

      FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type        => G_OTYPE_DML_UPDATE_SEGMENT,
                                           p_source_type        => p_source_type,
                                           p_source_id          => p_source_id,
                                           x_object_id          => l_object_id);

Line: 226

   PROCEDURE ADD_DML_DELETE_STMT(p_table_owner          IN VARCHAR2,
                                 p_table_name           IN VARCHAR2,
                                 p_where_clause         IN VARCHAR2,
                                 p_weight               IN NUMBER,
                                 p_source_type          IN VARCHAR2,
                                 p_source_id            IN NUMBER,
                                 x_object_id            OUT NOCOPY NUMBER)
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'ADD_DML_DELETE_STMT';

Line: 243

      FND_OAM_DSCFG_OBJECTS_PKG.ADD_OBJECT(p_object_type        => G_OTYPE_DML_DELETE_STMT,
                                           p_source_type        => p_source_type,
                                           p_source_id          => p_source_id,
                                           x_object_id          => l_object_id);