DBA Data[Home] [Help]

APPS.CHV_AUTHORIZATIONS_PKG_S1 SQL Statements

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

Line: 5

   PROCEDURE NAME:  delete_row()

=============================================================================*/
PROCEDURE delete_row(
                     X_Schedule_Item_ID      IN   NUMBER
                    ) IS

BEGIN

  DELETE FROM chv_authorizations
   WHERE reference_id     = X_Schedule_Item_Id
     AND reference_type   = 'SCHEDULE_ITEMS' ;
Line: 22

END delete_row ;