APPS.AMS_OBJECTATTRIBUTE_PVT SQL Statements

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

Line: 25

   SELECT AMS_OBJECT_ATTRIBUTES_S.NEXTVAL
     FROM DUAL;

Line: 39

   insert into ams_object_attributes(
       object_attribute_id,
       last_update_date,
       last_updated_by,
       creation_date,
       created_by,
       last_update_login,
       object_version_number,
       object_type,
       object_id,
       custom_setup_id,
       display_sequence_no,
       object_attribute,
       attribute_defined_flag
    )
    values(
      l_attribute_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.conc_login_id,
      1,  -- object_version_number,
      x_object_type,
      x_object_id,
      x_custom_setup_id,
      x_display_sequence_no,
      x_object_attribute,
      x_attribute_defined_flag
   );

Line: 108

   SELECT display_sequence_no, object_attribute
     FROM ams_custom_setup_attr
    WHERE custom_setup_id = p_setup_id
      AND attr_available_flag = 'Y';

Line: 114

   SELECT count(object_attribute)
     FROM ams_custom_setup_attr
    WHERE custom_setup_id = p_setup_id;

Line: 200

   AMS_Utility_PVT.debug_message(l_full_name ||': insert general attribute');

Line: 295

   SELECT attribute_defined_flag
     FROM ams_object_attributes
    WHERE object_type = p_object_type
      AND object_id = p_object_id
      AND object_attribute = p_attr;

Line: 349

      UPDATE ams_object_attributes
         SET attribute_defined_flag = p_attr_defined_flag,
             object_version_number = object_version_number + 1
       WHERE object_type = p_object_type
         AND object_id = p_object_id
         AND object_attribute = p_attr;

Line: 426

   SELECT 1
     FROM DUAL
    WHERE EXISTS (
          SELECT 1
            FROM ams_object_attributes
           WHERE object_type = p_obj_type
             AND object_id = p_obj_id
             AND object_attribute = p_attribute);