PACKAGE BODY: APPS.CHV_ITEM_ORDERS_PKG_S1

Source

1 PACKAGE BODY CHV_ITEM_ORDERS_PKG_S1 as
2 /* $Header: CHVSORDB.pls 115.0 99/07/17 01:31:46 porting ship $ */
3 /*===========================================================================
4 
5    PROCEDURE NAME:  delete_row()
6 
7 =============================================================================*/
8 PROCEDURE delete_row(X_Schedule_Id           IN   NUMBER,
9                      X_Schedule_Item_ID      IN   NUMBER
10                     ) IS
11 
12 BEGIN
13 
14   DELETE FROM chv_item_orders
15    WHERE schedule_id      = X_Schedule_Id
16      AND schedule_item_id = X_Schedule_Item_Id ;
17 
18   if (SQL%NOTFOUND) then
19      null ;
20   end if ;
21 
22 END delete_row ;
23 
24 END CHV_ITEM_ORDERS_PKG_S1;