PACKAGE: APPS.PA_DISTRIBUTION_LIST_UTILS

Source

1 PACKAGE PA_DISTRIBUTION_LIST_UTILS AUTHID CURRENT_USER AS
2  /* $Header: PATDLUTS.pls 120.1.12010000.4 2009/02/23 22:46:21 asahoo ship $ */
3  Function Check_valid_dist_list_id (
4                         p_list_id in Number )
5  return boolean;
6 
7  Function Check_valid_dist_list_item_id (
8                         p_list_item_id in Number )
9  return varchar2;
10 
11  Function Check_dist_list_name_exists (
12                         p_list_id   in number default null,
13                         p_list_name in varchar2 )
14  return boolean;
15 
16  --Fix for #Bug 8247832
17  Function Check_dist_list_items_exists (
18                         p_list_id   in number,
19                         p_recipient_type in varchar2,
20                         p_recipient_id  in varchar2)
21  return boolean;
22 
23  Function get_dist_list_id (
24                         p_list_name in varchar2 )
25  return number;
26 
27  Function Check_valid_recipient_type (
28                         p_recipient_type in varchar2 )
29  return boolean;
30 
31  Function Check_valid_recipient_id (
32                         p_recipient_type in varchar2,
33                         p_recipient_id   in varchar2 )
34  return boolean;
35 
36  Function Check_valid_access_level (
37                         p_access_level in number)
38  return boolean;
39 
40  Function Check_valid_menu_id (
41                         p_menu_id in Number )
42  return boolean;
43 
44   TYPE PA_VC_1000_150 IS VARRAY(1000) OF VARCHAR2(150);
45 
46 FUNCTION get_access_level (
47   p_object_type        IN   VARCHAR2,
48   p_object_id          IN   VARCHAR2,
49   p_user_id            IN   NUMBER  DEFAULT FND_GLOBAL.USER_ID,
50   x_return_status      OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
51   x_msg_count          OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
52   x_msg_data           OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53   p_context_object_type IN  VARCHAR2 DEFAULT NULL,
54   p_context_object_id   IN  VARCHAR2 DEFAULT NULL
55 ) RETURN NUMBER;
56 
57 PROCEDURE get_dist_list (
58   p_object_type        IN   VARCHAR2,
59   p_object_id          IN   VARCHAR2,
60   p_access_level       IN   NUMBER,
61   x_user_names         OUT  NOCOPY PA_VC_1000_150, --File.Sql.39 bug 4440895
62   x_full_names         OUT  NOCOPY PA_VC_1000_150, --File.Sql.39 bug 4440895
63   x_email_addresses    OUT  NOCOPY PA_VC_1000_150, --File.Sql.39 bug 4440895
64   x_return_status      OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
65   x_msg_count          OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
66   x_msg_data           OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 );
68 
69 /* Added for Bug 6843694 */
70 PROCEDURE get_dist_list_email (
71   p_object_type        IN   VARCHAR2,
72   p_object_id          IN   VARCHAR2,
73   p_access_level       IN   NUMBER,
74   x_user_names         OUT  NOCOPY PA_VC_1000_150,
75   x_full_names         OUT  NOCOPY PA_VC_1000_150,
76   x_email_addresses    OUT  NOCOPY PA_VC_1000_150,
77   x_return_status      OUT  NOCOPY VARCHAR2,
78   x_msg_count          OUT  NOCOPY NUMBER,
79   x_msg_data           OUT  NOCOPY VARCHAR2
80 );
81 
82 PROCEDURE copy_dist_list
83  ( p_object_type_from IN VARCHAR2,
84    p_object_id_from IN NUMBER,
85    p_object_type_to IN VARCHAR2,
86    p_object_id_to IN  NUMBER,
87    P_CREATED_BY 		in NUMBER default fnd_global.user_id,
88    P_CREATION_DATE 	in DATE default sysdate,
89    P_LAST_UPDATED_BY 	in NUMBER default fnd_global.user_id,
90    P_LAST_UPDATE_DATE 	in DATE default sysdate,
91    P_LAST_UPDATE_LOGIN 	in NUMBER default fnd_global.user_id,
92    x_return_status      OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93    x_msg_count          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
94    x_msg_data           OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95   );
96 
97 
98 
99 
100 END  PA_DISTRIBUTION_LIST_UTILS;