DBA Data[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;