1 PACKAGE PA_DISTRIBUTION_LISTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: PATDSLHS.pls 120.1 2005/08/19 17:03:51 mwasowic noship $ */
3 procedure INSERT_ROW (
4 P_LIST_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5 P_NAME in VARCHAR2,
6 P_DESCRIPTION in VARCHAR2,
7 P_RECORD_VERSION_NUMBER in NUMBER,
8 P_CREATED_BY in NUMBER,
9 P_CREATION_DATE in DATE,
10 P_LAST_UPDATED_BY in NUMBER,
11 P_LAST_UPDATE_DATE in DATE,
12 P_LAST_UPDATE_LOGIN in NUMBER
13 ) ;
14
15 procedure UPDATE_ROW (
16 P_LIST_ID in NUMBER,
17 P_NAME in VARCHAR2,
18 P_DESCRIPTION in VARCHAR2,
19 P_RECORD_VERSION_NUMBER in NUMBER,
20 P_LAST_UPDATED_BY in NUMBER,
21 P_LAST_UPDATE_DATE in DATE,
22 P_LAST_UPDATE_LOGIN in NUMBER
23 ) ;
24
25 procedure DELETE_ROW (
26 P_LIST_ID in NUMBER ) ;
27 END PA_DISTRIBUTION_LISTS_PKG;