[Home] [Help]
PACKAGE: APPS.IGW_PROP_PROGRAM_ADDRESS_PKG
Source
1 package IGW_PROP_PROGRAM_ADDRESS_PKG AUTHID CURRENT_USER as
2 /* $Header: igwpr20s.pls 115.6 2002/03/28 19:13:26 pkm ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out VARCHAR2,
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 );
11 procedure LOCK_ROW (
12 X_ROWID in VARCHAR2,
13 X_PROPOSAL_ID in NUMBER,
14 X_ADDRESS_ID in NUMBER,
15 X_NUMBER_OF_COPIES in NUMBER,
16 X_MAIL_DESCRIPTION in VARCHAR2
17 );
18 procedure UPDATE_ROW (
19 X_ROWID in VARCHAR2,
20 X_PROPOSAL_ID in NUMBER,
21 X_ADDRESS_ID in NUMBER,
22 X_NUMBER_OF_COPIES in NUMBER,
23 X_MAIL_DESCRIPTION in VARCHAR2,
24 X_MODE in VARCHAR2 default 'R'
25 );
26 procedure ADD_ROW (
27 X_ROWID in out VARCHAR2,
28 X_PROPOSAL_ID in NUMBER,
29 X_ADDRESS_ID in NUMBER,
30 X_NUMBER_OF_COPIES in NUMBER,
31 X_MAIL_DESCRIPTION in VARCHAR2,
32 X_MODE in VARCHAR2 default 'R'
33 );
34 procedure DELETE_ROW (
35 X_ROWID in VARCHAR2
36 );
37 end IGW_PROP_PROGRAM_ADDRESS_PKG;