APPS.PO_MASSCANCEL_SV SQL Statements

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

Line: 18

        SELECT *
        FROM   PO_MASSCANCEL_INTERIM
        WHERE  rowid = x_rowid
        FOR UPDATE of default_cancel_flag NOWAIT;

Line: 29

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

Line: 39

       * using multiselect and that highlights/de-highlights the rec
       * irrespective of lock failure, even though the cancel flag is
       * not updated if the lock fails.
       */
      --FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line: 52

 *	Procedure:	update_row
 *
 *	Description:	UPDATE table handler for the PO_MASSCANCEL_INTERIM
 * 			table.
 *
 **************************************************************************/

  PROCEDURE update_row(x_rowid                 VARCHAR2,
                       x_last_update_date      DATE,
                       x_last_updated_by       NUMBER,
		       x_last_update_login     NUMBER,
		       x_default_cancel_flag   VARCHAR2)

   IS
 BEGIN
   UPDATE PO_MASSCANCEL_INTERIM
   SET		default_cancel_flag	=	x_default_cancel_flag,
		last_update_date 	=      	x_last_update_date,
              	last_updated_by		=	x_last_updated_by,
		last_update_login	=	x_last_update_login
   WHERE rowid = x_rowid;

Line: 78

  END update_row;