DBA Data[Home] [Help]

PACKAGE BODY: APPS.CHV_SCHEDULE_ORGS_PKG_S1

Source


1 PACKAGE BODY CHV_SCHEDULE_ORGS_PKG_S1 as
2 /* $Header: CHVSORGB.pls 115.0 99/07/17 01:31:54 porting ship $ */
3 /*===========================================================================
4 
5    PROCEDURE NAME:  Insert_Row()
6 
7 =============================================================================*/
8 PROCEDURE Insert_Row(
9                      X_Batch_Id      IN   NUMBER,
10 		     X_Organization_Id        IN   NUMBER
11                     ) IS
12 
13 BEGIN
14 
15   INSERT INTO chv_schedule_organizations(Batch_Id,
16 				         Organization_Id)
17 			          values(
18 					 X_Batch_Id,
19 					 X_Organization_Id) ;
20 
21   if (SQL%NOTFOUND) then
22      Raise NO_DATA_FOUND ;
23   end if ;
24 
25 END Insert_Row ;
26 
27 END CHV_SCHEDULE_ORGS_PKG_S1;