DBA Data[Home] [Help]

APPS.OE_AK_OBJ_ATTR_EXT_PKG SQL Statements

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

Line: 4

   PROCEDURE Update_Row(
      p_rowid                                   in      varchar2
     , p_database_object_name           in   VARCHAR2
     , p_attribute_code                 in     VARCHAR2
     , p_defaulting_sequence            in      NUMBER
     , p_defaulting_condn_ref_flag              in      VARCHAR2
     , p_last_updated_by                in      number
     , p_last_update_date               in      date
     , p_last_update_login              in      number
   )
   IS
   BEGIN

      UPDATE OE_AK_OBJ_ATTR_EXT
      SET
	  defaulting_sequence = p_defaulting_sequence
	 ,defaulting_condn_ref_flag = p_defaulting_condn_ref_flag
         ,last_updated_by    	 = p_last_updated_by
         ,last_update_date     = p_last_update_date
         ,last_update_login     = p_last_update_login
      WHERE rowid = p_rowid;
Line: 30

    END Update_Row;
Line: 39

      , p_last_updated_by               in      number
      , p_last_update_date              in      date
      , p_last_update_login             in      number
      )
    IS
    	CURSOR C IS
    	SELECT * FROM OE_AK_OBJ_ATTR_EXT
	WHERE rowid = p_Rowid
	FOR UPDATE OF database_object_name NOWAIT;
Line: 57

	FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');