1 PACKAGE PA_DISTRIBUTION_LISTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: PATDSLVS.pls 120.1 2005/08/19 17:03:59 mwasowic noship $ */
3 procedure CREATE_DIST_LIST (
4 p_api_version IN NUMBER := 1.0,
5 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6 p_commit IN VARCHAR2 := FND_API.g_false,
7 p_validate_only IN VARCHAR2 := FND_API.g_true,
8 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9 P_LIST_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10 P_NAME in VARCHAR2,
11 P_DESCRIPTION in VARCHAR2,
12 P_RECORD_VERSION_NUMBER in NUMBER := 1,
13 P_CREATED_BY in NUMBER default fnd_global.user_id,
14 P_CREATION_DATE in DATE default sysdate,
15 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
16 P_LAST_UPDATE_DATE in DATE default sysdate,
17 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
18 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
19 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
20 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21 ) ;
22
23 procedure UPDATE_DIST_LIST (
24 p_api_version IN NUMBER := 1.0,
25 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26 p_commit IN VARCHAR2 := FND_API.g_false,
27 p_validate_only IN VARCHAR2 := FND_API.g_true,
28 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29 P_LIST_ID in NUMBER,
30 P_NAME in VARCHAR2,
31 P_DESCRIPTION in VARCHAR2,
32 P_RECORD_VERSION_NUMBER in NUMBER,
33 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
34 P_LAST_UPDATE_DATE in DATE default sysdate,
35 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
36 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39 ) ;
40
41 procedure DELETE_DIST_LIST (
42 p_api_version IN NUMBER := 1.0,
43 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44 p_commit IN VARCHAR2 := FND_API.g_false,
45 p_validate_only IN VARCHAR2 := FND_API.g_true,
46 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47 P_LIST_ID in NUMBER,
48 P_DELETE_LIST_ITEM_FLAG in VARCHAR2 default 'N',
49 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 ) ;
53 procedure CREATE_DIST_LIST_ITEM (
54 p_api_version IN NUMBER := 1.0,
55 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
56 p_commit IN VARCHAR2 := FND_API.g_false,
57 p_validate_only IN VARCHAR2 := FND_API.g_true,
58 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
59 P_LIST_ITEM_ID in OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
60 P_LIST_ID in NUMBER:= null,
61 P_RECIPIENT_TYPE in VARCHAR2:= null,
62 P_RECIPIENT_ID in VARCHAR2:= null,
63 P_ACCESS_LEVEL in NUMBER:= null,
64 P_MENU_ID in NUMBER:= null,
65 P_EMAIL in VARCHAR2:= null,
66 P_RECORD_VERSION_NUMBER in NUMBER := 1,
67 P_CREATED_BY in NUMBER default fnd_global.user_id,
68 P_CREATION_DATE in DATE default sysdate,
69 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
70 P_LAST_UPDATE_DATE in DATE default sysdate,
71 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
72 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
74 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75 ) ;
76 procedure UPDATE_DIST_LIST_ITEM (
77 p_api_version IN NUMBER := 1.0,
78 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
79 p_commit IN VARCHAR2 := FND_API.g_false,
80 p_validate_only IN VARCHAR2 := FND_API.g_true,
81 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
82 P_LIST_ITEM_ID in NUMBER := null,
83 P_LIST_ID in NUMBER := null,
84 P_RECIPIENT_TYPE in VARCHAR2 := null,
85 P_RECIPIENT_ID in VARCHAR2 := null,
86 P_ACCESS_LEVEL in NUMBER := null,
87 P_MENU_ID in NUMBER := null,
88 P_EMAIL in VARCHAR2 := null,
89 P_RECORD_VERSION_NUMBER in NUMBER := 1,
90 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
91 P_LAST_UPDATE_DATE in DATE default sysdate,
92 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
93 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
95 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 ) ;
97 procedure DELETE_DIST_LIST_ITEM (
98 p_api_version IN NUMBER := 1.0,
99 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
100 p_commit IN VARCHAR2 := FND_API.g_false,
101 p_validate_only IN VARCHAR2 := FND_API.g_true,
102 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
103 P_LIST_ITEM_ID in NUMBER,
104 P_RECORD_VERSION_NUMBER in NUMBER := 1,
105 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
107 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108 ) ;
109
110 END PA_DISTRIBUTION_LISTS_PVT;