1 PACKAGE PA_DIST_LIST_ITEMS_PKG AS
2 /* $Header: PATDLIHS.pls 120.1 2005/08/19 17:03:35 mwasowic noship $ */
3
4 procedure INSERT_ROW (
5 P_LIST_ITEM_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6 P_LIST_ID in NUMBER,
7 P_RECIPIENT_TYPE in VARCHAR2,
8 P_RECIPIENT_ID in VARCHAR2,
9 P_ACCESS_LEVEL in NUMBER,
10 P_MENU_ID in NUMBER,
11 P_EMAIL in VARCHAR2,
12 P_RECORD_VERSION_NUMBER in NUMBER,
13 P_CREATED_BY in NUMBER,
14 P_CREATION_DATE in DATE,
15 P_LAST_UPDATED_BY in NUMBER,
16 P_LAST_UPDATE_DATE in DATE,
17 P_LAST_UPDATE_LOGIN in NUMBER
18 ) ;
19
20 procedure UPDATE_ROW (
21 P_LIST_ITEM_ID in NUMBER,
22 P_LIST_ID in NUMBER,
23 P_RECIPIENT_TYPE in VARCHAR2,
24 P_RECIPIENT_ID in VARCHAR2,
25 P_ACCESS_LEVEL in NUMBER,
26 P_MENU_ID in NUMBER,
27 P_EMAIL in VARCHAR2,
28 P_RECORD_VERSION_NUMBER in NUMBER,
29 P_LAST_UPDATED_BY in NUMBER,
30 P_LAST_UPDATE_DATE in DATE,
31 P_LAST_UPDATE_LOGIN in NUMBER
32 ) ;
33
34 procedure DELETE_ROW (
35 P_LIST_ITEM_ID in NUMBER ) ;
36 END PA_DIST_LIST_ITEMS_PKG;