PACKAGE BODY: APPS.CHV_AUTHORIZATIONS_PKG_S1

Source

1 PACKAGE BODY CHV_AUTHORIZATIONS_PKG_S1 as
2 /* $Header: CHVSAUTB.pls 115.0 99/07/17 01:30:32 porting ship $ */
3 /*===========================================================================
4 
5    PROCEDURE NAME:  delete_row()
6 
7 =============================================================================*/
8 PROCEDURE delete_row(
9                      X_Schedule_Item_ID      IN   NUMBER
10                     ) IS
11 
12 BEGIN
13 
14   DELETE FROM chv_authorizations
15    WHERE reference_id     = X_Schedule_Item_Id
16      AND reference_type   = 'SCHEDULE_ITEMS' ;
17 
18   if (SQL%NOTFOUND) then
19      null ;
20   end if ;
21 
22 END delete_row ;
23 
24 END CHV_AUTHORIZATIONS_PKG_S1;