DBA Data[Home] [Help]

APPS.CHV_ITEM_ORDERS_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_Id           IN   NUMBER,
                     X_Schedule_Item_ID      IN   NUMBER
                    ) IS

BEGIN

  DELETE FROM chv_item_orders
   WHERE schedule_id      = X_Schedule_Id
     AND schedule_item_id = X_Schedule_Item_Id ;
Line: 22

END delete_row ;