1 PACKAGE amv_utility_pvt2 AUTHID CURRENT_USER AS
2 /* $Header: amvvutcs.pls 115.3 2000/02/02 17:25:06 pkm ship $ */
3 --
4 -- NAME
5 -- AMV_UTILITY_PVT2
6 --
7 -- HISTORY
8 -- 08/30/1999 SLKRISHN CREATED
9 --
10 --
11 G_AMV_APP_ID CONSTANT NUMBER := 520;
12 G_CONTENT CONSTANT VARCHAR2(30) := 'CONTENT';
13 G_GROUP CONSTANT VARCHAR2(30) := 'GROUP';
14 G_USER CONSTANT VARCHAR2(30) := 'USER';
15 G_PUBLIC CONSTANT VARCHAR2(30) := 'PUBLIC';
16 G_PRIVATE CONSTANT VARCHAR2(30) := 'PRIVATE';
17 G_PROTECTED CONSTANT VARCHAR2(30) := 'PROTECTED';
18 G_CATEGORY CONSTANT VARCHAR2(30) := 'CATEGORY';
19 G_CHANNEL CONSTANT VARCHAR2(30) := 'CHANNEL';
20 G_ITEM CONSTANT VARCHAR2(30) := 'ITEM';
21 G_APPLICATION CONSTANT VARCHAR2(30) := 'APPLICATION';
22 G_SUBSCRIBED CONSTANT VARCHAR2(30) := 'SUBSCRIBED';
23 G_ENFORCED CONSTANT VARCHAR2(30) := 'ENFORCED';
24 G_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
25 G_INACTIVE CONSTANT VARCHAR2(30) := 'INACTIVE';
26 G_NEED_APPROVAL CONSTANT VARCHAR2(30) := 'NEED_APPROVAL';
27 G_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED';
28 G_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED';
29 G_MORE_INFO CONSTANT VARCHAR2(30) := 'MORE_INFO';
30 G_PUB_APPROVAL CONSTANT VARCHAR2(30) := 'AMV_CONTENT_APPROVAL';
31 G_SUB_APPROVAL CONSTANT VARCHAR2(30) := 'AMV_SUBSCRIPTION_APPROVAL';
32 G_DEFAULT CONSTANT VARCHAR2(30) := 'DEFAULT';
33 G_OWNER CONSTANT VARCHAR2(30) := 'OWNER';
34 G_SECONDARY CONSTANT VARCHAR2(30) := 'SECONDARY';
35 G_DONE CONSTANT VARCHAR2(30) := 'DONE';
36 --
37 --------------------------------------------------------------------------------
38 --
39 -- Start of comments
40 -- API name : Is_CategoryIdValid
41 -- Type : Private
42 -- Pre-reqs : None
43 -- Function : check if category id is valid and return a boolean value.
44 -- Parameters :
45 -- IN : p_category_id IN NUMBER Required
46 -- (sub)category id
47 -- OUT : None
48 -- Version : Current version 1.0
49 -- Previous version 1.0
50 -- Initial version 1.0
51 -- Notes :
52 -- End of comments
53 --
54 FUNCTION Is_CategoryIdValid (
55 p_category_id IN NUMBER
56 )
57 RETURN Boolean;
58 --------------------------------------------------------------------------------
59 --
60 -- Start of comments
61 -- API name : Is_UserIdValid
62 -- Type : Private
63 -- Pre-reqs : None
64 -- Function : check if user id is valid and return a boolean value.
65 -- Parameters :
66 -- IN : p_user_id IN NUMBER Required
67 -- user id
68 -- OUT : None
69 -- Version : Current version 1.0
70 -- Previous version 1.0
71 -- Initial version 1.0
72 -- Notes :
73 -- End of comments
74 --
75 FUNCTION Is_UserIdValid (
76 p_user_id IN NUMBER
77 )
78 RETURN Boolean;
79 --------------------------------------------------------------------------------
80 --
81 -- Start of comments
82 -- API name : Is_MyChannelIdValid
83 -- Type : Private
84 -- Pre-reqs : None
85 -- Function : check if my channel id is valid and return boolean.
86 -- Parameters :
87 -- IN : p_mychannel_id IN NUMBER Required
88 -- OUT : None
89 -- Version : Current version 1.0
90 -- Previous version 1.0
91 -- Initial version 1.0
92 -- Notes :
93 -- End of comments
94 --
95 FUNCTION Is_MyChannelIdValid (
96 p_mychannel_id IN NUMBER
97 )
98 RETURN Boolean;
99 --------------------------------------------------------------------------------
100 --
101 -- Start of comments
102 -- API name : Get_DeleteChannelStatus
103 -- Type : Private
104 -- Pre-reqs : None
105 -- Function : check if user or group has privilege to delete a channel
106 -- return boolean.
107 -- Parameters :
108 -- IN : p_channel_id IN NUMBER Required
109 -- IN : p_user_or_group_id IN NUMBER Required
110 -- IN : p_user_or_group_type IN VARCHAR2 Required
111 -- OUT : None
112 -- Version : Current version 1.0
113 -- Previous version 1.0
114 -- Initial version 1.0
115 -- Notes :
116 -- End of comments
117 --
118 --
119 --
120 FUNCTION Get_DeleteChannelStatus
121 ( p_channel_id IN NUMBER,
122 p_user_or_group_id IN NUMBER,
123 p_user_or_group_type IN VARCHAR2) return boolean;
124 --------------------------------------------------------------------------------
125 --
126 -- Start of comments
127 -- API name : Get_UpdateChannelStatus
128 -- Type : Private
129 -- Pre-reqs : None
130 -- Function : check if user or group has privilege to update a channel
131 -- return boolean.
132 -- Parameters :
133 -- IN : p_channel_id IN NUMBER Required
134 -- IN : p_user_or_group_id IN NUMBER Required
135 -- IN : p_user_or_group_type IN VARCHAR2 Required
136 -- OUT : None
137 -- Version : Current version 1.0
138 -- Previous version 1.0
139 -- Initial version 1.0
140 -- Notes :
141 -- End of comments
142 --
143 --
144 FUNCTION Get_UpdateChannelStatus
145 ( p_channel_id IN NUMBER,
146 p_user_or_group_id IN NUMBER,
147 p_user_or_group_type IN VARCHAR2) return boolean;
148 --
149 --------------------------------------------------------------------------------
150 --
151 -- Start of comments
152 -- API name : Get_DeleteCategoryStatus
153 -- Type : Private
154 -- Pre-reqs : None
155 -- Function : check if user or group has privilege to delete a category
156 -- return boolean.
157 -- Parameters :
158 -- IN : p_category_id IN NUMBER Required
159 -- IN : p_user_or_group_id IN NUMBER Required
160 -- IN : p_user_or_group_type IN VARCHAR2 Required
161 -- OUT : None
162 -- Version : Current version 1.0
163 -- Previous version 1.0
164 -- Initial version 1.0
165 -- Notes :
166 -- End of comments
167 --
168 FUNCTION Get_DeleteCategoryStatus
169 ( p_category_id IN NUMBER,
170 p_user_or_group_id IN NUMBER,
171 p_user_or_group_type IN VARCHAR2) return boolean;
172 --------------------------------------------------------------------------------
173 --
174 -- Start of comments
175 -- API name : Get_UpdateCategoryStatus
176 -- Type : Private
177 -- Pre-reqs : None
178 -- Function : check if user or group has privilege to update a category
179 -- return boolean.
180 -- Parameters :
181 -- IN : p_category_id IN NUMBER Required
182 -- IN : p_user_or_group_id IN NUMBER Required
183 -- IN : p_user_or_group_type IN VARCHAR2 Required
184 -- OUT : None
185 -- Version : Current version 1.0
186 -- Previous version 1.0
187 -- Initial version 1.0
188 -- Notes :
189 -- End of comments
190 --
191 --
192 FUNCTION Get_UpdateCategoryStatus
193 ( p_category_id IN NUMBER,
194 p_user_or_group_id IN NUMBER,
195 p_user_or_group_type IN VARCHAR2) return boolean;
196 --
197 --------------------------------------------------------------------------------
198 END amv_utility_pvt2;