[Home] [Help]
PACKAGE: APPS.IGW_PROP_PROGRAM_ADDRESSES_TBH
Source
1 package IGW_PROP_PROGRAM_ADDRESSES_TBH AUTHID CURRENT_USER as
2 --$Header: igwtpads.pls 115.3 2002/11/15 00:43:54 ashkumar ship $
3 procedure INSERT_ROW (
4 X_ROWID out NOCOPY ROWID,
5 X_PROPOSAL_ID in NUMBER,
6 X_ADDRESS_ID in NUMBER,
7 X_NUMBER_OF_COPIES in NUMBER,
8 X_MAIL_DESCRIPTION in VARCHAR2,
9 X_MODE in VARCHAR2 default 'R',
10 X_RETURN_STATUS out NOCOPY VARCHAR2
11 );
12
13 procedure UPDATE_ROW (
14 X_ROWID in ROWID,
15 X_PROPOSAL_ID in NUMBER,
16 X_ADDRESS_ID in NUMBER,
17 X_NUMBER_OF_COPIES in NUMBER,
18 X_MAIL_DESCRIPTION in VARCHAR2,
19 X_RECORD_VERSION_NUMBER IN NUMBER,
20 X_MODE in VARCHAR2 default 'R',
21 X_RETURN_STATUS out NOCOPY VARCHAR2
22 );
23
24 procedure DELETE_ROW (
25 X_ROWID in ROWID,
26 X_PROPOSAL_ID in NUMBER,
27 X_ADDRESS_ID in NUMBER,
28 X_RECORD_VERSION_NUMBER IN NUMBER,
29 X_RETURN_STATUS out NOCOPY VARCHAR2
30 );
31 end IGW_PROP_PROGRAM_ADDRESSES_TBH;