PACKAGE: APPS.PA_DIST_LIST_ITEMS_PKG

Source

1 PACKAGE PA_DIST_LIST_ITEMS_PKG AUTHID CURRENT_USER 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;