[Home] [Help]
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()
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
20: end if ;
21:
22: END delete_row ;
23:
24: END CHV_AUTHORIZATIONS_PKG_S1;