APPS.IGS_EN_GS_ATTRIB_VAL SQL Statements

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

Line: 20

   SELECT 'exist'
     FROM igs_en_object_types
    WHERE obj_type_id = p_obj_type_id;

Line: 26

   SELECT 'exist'
     FROM igs_en_attributes
    WHERE attrib_id = p_attrib_id;

Line: 32

   SELECT rowid
     FROM igs_en_attrib_values
    WHERE obj_type_id = p_obj_type_id
      AND obj_id = p_obj_id
      AND attrib_id = p_attrib_id
      AND version = p_version;

Line: 41

   SELECT 'Y'
     FROM igs_en_attrib_values
     WHERE obj_type_id = p_obj_type_id
      AND obj_id = p_obj_id
      AND attrib_id = p_attrib_id
      AND version = p_version;

Line: 101

   	 IGS_EN_ATTRIB_VALUES_PKG.UPDATE_ROW(
		X_ROWID           =>  l_rowid	    ,
		X_OBJ_TYPE_ID	  =>  p_obj_type_id ,
		X_OBJ_ID	  =>  p_obj_id      ,
		X_ATTRIB_ID       =>  p_attrib_id   ,
		X_VERSION         =>  p_version     ,
		X_VALUE           =>  p_value
		);

Line: 112

	  IGS_EN_ATTRIB_VALUES_PKG.INSERT_ROW(
		X_ROWID           =>  l_rowid	    ,
		X_OBJ_TYPE_ID	  =>  p_obj_type_id ,
		X_OBJ_ID	  =>  p_obj_id      ,
		X_ATTRIB_ID       =>  p_attrib_id   ,
		X_VERSION         =>  p_version     ,
		X_VALUE           =>  p_value
		);

Line: 144

    SELECT value
      FROM igs_en_attrib_values
     WHERE obj_type_id = p_obj_type_id
       AND obj_id = p_obj_id
       AND attrib_id = p_attrib_id
       AND version = p_version;