[Home] [Help]
PACKAGE: APPS.PA_DISTRIBUTION_LIST_UTILS
Source
1 PACKAGE PA_DISTRIBUTION_LIST_UTILS AS
2 /* $Header: PATDLUTS.pls 120.1.12010000.3 2008/09/16 11:30:16 rthumma 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 Function get_dist_list_id (
17 p_list_name in varchar2 )
18 return number;
19
20 Function Check_valid_recipient_type (
21 p_recipient_type in varchar2 )
22 return boolean;
23
24 Function Check_valid_recipient_id (
25 p_recipient_type in varchar2,
26 p_recipient_id in varchar2 )
27 return boolean;
28
29 Function Check_valid_access_level (
30 p_access_level in number)
31 return boolean;
32
33 Function Check_valid_menu_id (
34 p_menu_id in Number )
35 return boolean;
36
37 TYPE PA_VC_1000_150 IS VARRAY(1000) OF VARCHAR2(150);
38
39 FUNCTION get_access_level (
40 p_object_type IN VARCHAR2,
41 p_object_id IN VARCHAR2,
42 p_user_id IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
43 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
45 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46 p_context_object_type IN VARCHAR2 DEFAULT NULL,
47 p_context_object_id IN VARCHAR2 DEFAULT NULL
48 ) RETURN NUMBER;
49
50 PROCEDURE get_dist_list (
51 p_object_type IN VARCHAR2,
52 p_object_id IN VARCHAR2,
53 p_access_level IN NUMBER,
54 x_user_names OUT NOCOPY PA_VC_1000_150, --File.Sql.39 bug 4440895
55 x_full_names OUT NOCOPY PA_VC_1000_150, --File.Sql.39 bug 4440895
56 x_email_addresses OUT NOCOPY PA_VC_1000_150, --File.Sql.39 bug 4440895
57 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60 );
61
62 /* Added for Bug 6843694 */
63 PROCEDURE get_dist_list_email (
64 p_object_type IN VARCHAR2,
65 p_object_id IN VARCHAR2,
66 p_access_level IN NUMBER,
67 x_user_names OUT NOCOPY PA_VC_1000_150,
68 x_full_names OUT NOCOPY PA_VC_1000_150,
69 x_email_addresses OUT NOCOPY PA_VC_1000_150,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE copy_dist_list
76 ( p_object_type_from IN VARCHAR2,
77 p_object_id_from IN NUMBER,
78 p_object_type_to IN VARCHAR2,
79 p_object_id_to IN NUMBER,
80 P_CREATED_BY in NUMBER default fnd_global.user_id,
81 P_CREATION_DATE in DATE default sysdate,
82 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
83 P_LAST_UPDATE_DATE in DATE default sysdate,
84 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
85 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
86 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
87 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
88 );
89
90
91
92
93 END PA_DISTRIBUTION_LIST_UTILS;