1 PACKAGE IGS_PE_HZ_CONT_PREF_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSNIB2S.pls 115.0 2003/06/16 06:21:39 ssawhney noship $ */
3 procedure INSERT_ROW (
4 X_MSG_COUNT OUT NOCOPY NUMBER,
5 X_MSG_DATA OUT NOCOPY VARCHAR2,
6 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7 X_ROWID in out NOCOPY VARCHAR2,
8 x_CONTACT_PREFERENCE_ID IN OUT NOCOPY NUMBER,
9 x_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
10 X_CONTACT_LEVEL_TABLE IN VARCHAR2,
11 X_CONTACT_LEVEL_TABLE_ID IN NUMBER,
12 X_CONTACT_TYPE IN VARCHAR2,
13 X_PREFERENCE_CODE IN VARCHAR2,
14 X_PREFERENCE_START_DATE IN DATE,
15 X_PREFERENCE_END_DATE IN DATE,
16 X_REQUESTED_BY IN VARCHAR2,
17 X_REASON_CODE IN VARCHAR2,
18 X_STATUS IN VARCHAR2,
19 X_MODE in VARCHAR2 default 'R'
20 );
21
22
23 procedure UPDATE_ROW (
24 X_MSG_COUNT OUT NOCOPY NUMBER,
25 X_MSG_DATA OUT NOCOPY VARCHAR2,
26 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
27 X_ROWID in out NOCOPY VARCHAR2,
28 x_CONTACT_PREFERENCE_ID IN OUT NOCOPY NUMBER,
29 x_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
30 X_CONTACT_LEVEL_TABLE IN VARCHAR2,
31 X_CONTACT_LEVEL_TABLE_ID IN NUMBER,
32 X_CONTACT_TYPE IN VARCHAR2,
33 X_PREFERENCE_CODE IN VARCHAR2,
34 X_PREFERENCE_START_DATE IN DATE,
35 X_PREFERENCE_END_DATE IN DATE,
36 X_REQUESTED_BY IN VARCHAR2,
37 X_REASON_CODE IN VARCHAR2,
38 X_STATUS IN VARCHAR2,
39 X_MODE in VARCHAR2 default 'R'
40 );
41
42
43 END IGS_PE_HZ_CONT_PREF_PKG;