DBA Data[Home] [Help]

PACKAGE: APPS.IGW_PROP_NARRATIVES_TBH

Source


1 PACKAGE IGW_PROP_NARRATIVES_TBH AUTHID CURRENT_USER as
2 --$Header: igwtprns.pls 115.2 2002/11/15 00:39:25 ashkumar ship $
3 
4 PROCEDURE INSERT_ROW (
5  X_ROWID 		     out NOCOPY 	VARCHAR2,
6  P_PROPOSAL_ID               in	 	NUMBER,
7  P_MODULE_TITLE              in		VARCHAR2,
8  P_MODULE_STATUS             in		VARCHAR2,
9  P_CONTACT_NAME              in         VARCHAR2,
10  P_PHONE_NUMBER              In         VARCHAR2,
11  P_EMAIL_ADDRESS             in         VARCHAR2,
12  P_COMMENTS                  in         VARCHAR2,
13  P_MODE		             in 	VARCHAR2 default 'R',
14  X_RETURN_STATUS             out NOCOPY  	VARCHAR2);
15 
16 
17 PROCEDURE UPDATE_ROW (
18  X_ROWID 		     in 	VARCHAR2,
19  P_PROPOSAL_ID               in	 	NUMBER,
20  P_MODULE_ID                 in		NUMBER,
21  P_MODULE_TITLE              in		VARCHAR2,
22  P_MODULE_STATUS             in		VARCHAR2,
23  P_CONTACT_NAME              in         VARCHAR2,
24  P_PHONE_NUMBER              in         VARCHAR2,
25  P_EMAIL_ADDRESS             in         VARCHAR2,
26  P_COMMENTS                  in         VARCHAR2,
27  P_MODE 		     in 	VARCHAR2 default 'R',
28  P_RECORD_VERSION_NUMBER     in         NUMBER,
29  X_RETURN_STATUS             out NOCOPY  	VARCHAR2);
30 
31 
32 PROCEDURE DELETE_ROW (
33   x_rowid 		  	in 		VARCHAR2,
34   p_record_version_number 	in 		NUMBER,
35   x_return_status         	out NOCOPY  		VARCHAR2);
36 
37 
38  END IGW_PROP_NARRATIVES_TBH;