APPS.FND_OAM_DSCFG_PROPERTIES_PKG SQL Statements

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

Line: 36

      INSERT INTO fnd_oam_dscfg_properties (PROPERTY_ID,
                                            PARENT_TYPE,
                                            PARENT_ID,
                                            PROPERTY_NAME,
                                            DATATYPE,
                                            CANONICAL_VALUE,
                                            CREATED_BY,
                                            CREATION_DATE,
                                            LAST_UPDATED_BY,
                                            LAST_UPDATE_DATE,
                                            LAST_UPDATE_LOGIN)
         VALUES (FND_OAM_DSCFG_PROPERTIES_S.NEXTVAL,
                 p_parent_type,
                 p_parent_id,
                 p_property_name,
                 p_datatype,
                 p_canonical_value,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID)
         RETURNING PROPERTY_ID INTO l_property_id;

Line: 181

      SELECT    canonical_value
         INTO   x_canonical_value
         FROM   fnd_oam_dscfg_properties
         WHERE  parent_type = p_parent_type
         AND    parent_id = p_parent_id
         AND    property_name = p_property_name;

Line: 268

         SELECT property_id
            INTO l_property_id
            FROM fnd_oam_dscfg_properties
            WHERE parent_type = p_parent_type
            AND parent_id = p_parent_id
            AND property_name = p_property_name;

Line: 277

         UPDATE fnd_oam_dscfg_properties
            SET canonical_value = p_canonical_value,
            last_updated_by = FND_GLOBAL.USER_ID,
            last_update_date = SYSDATE,
            last_update_login = FND_GLOBAL.USER_ID
            WHERE property_id = l_property_id;

Line: 359

   FUNCTION DELETE_PROPERTIES(p_parent_type     IN VARCHAR2,
                              p_parent_id       IN NUMBER)
      RETURN BOOLEAN
   IS
      l_ctxt            VARCHAR2(60) := PKG_NAME||'DELETE_PROPERTIES';

Line: 369

      DELETE FROM fnd_oam_dscfg_properties
         WHERE parent_type = p_parent_type
         AND parent_id = p_parent_id;

Line: 372

      fnd_oam_debug.log(1, l_ctxt, 'Deleted '||SQL%ROWCOUNT||' properties.');

Line: 386

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

Line: 395

      DELETE FROM fnd_oam_dscfg_properties
         WHERE property_id = p_property_id;