1 PACKAGE amv_utility_pvt AS
2 /* $Header: amvvutls.pls 120.1 2005/06/30 13:34:10 appldev ship $ */
3 -- Start of Comments
4 --
5 -- NAME
6 -- AMV_UTILITY_PVT
7 --
8 -- PURPOSE
9 -- This package is a private utility API in AMV. It contains helper
10 -- procedures which are used by several packages in MES to achiev code
11 -- re-usability. It contains specification for pl/sql records, array,
12 -- and procedures.
13 --
14 -- Procedures:
15 --
16 -- NOTES
17 --
18 --
19 -- HISTORY
20 -- 06/01/1999 PWU created
21 -- End of Comments
22 --
23 ------------------------------
24 -- Global Package Variables --
25 ------------------------------
26 --G_MES_APPLICATION_ID CONSTANT NUMBER := 520;
27 G_MAX_VARRAY_SIZE CONSTANT NUMBER := 5000;
28 G_USER_NOT_EXIST CONSTANT VARCHAR2(30) := 'NOTEXIST';
29 G_USER_NOT_LOGIN CONSTANT VARCHAR2(30) := 'NOTLOGIN';
30 G_NO_RESOURCE CONSTANT VARCHAR2(30) := 'NORESOURCE';
31 --G_ENABLE CONSTANT VARCHAR2(30) := 'ACTIVE';
32 --G_DISABLE CONSTANT VARCHAR2(30) := 'INACTIVE';
33 --G_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED';
34 --G_DISAPPROVED CONSTANT VARCHAR2(30) := 'REJECTED';
35 --G_WAITFORAPPROVAL CONSTANT VARCHAR2(30) := 'NEED_APPROVAL';
36 --G_NEEDREWORK CONSTANT VARCHAR2(30) := 'MORE_INFO';
37 G_USER_ENABLE CONSTANT NUMBER := 0;
38 G_USER_DISABLE CONSTANT NUMBER := 1;
39 G_NOT_EXIST CONSTANT NUMBER := 2;
40 G_NOT_LOGIN CONSTANT NUMBER := 3;
41 G_VALID_LEVEL_LOGIN CONSTANT NUMBER := 50;
42 G_VALID_LEVEL_VALID_ID CONSTANT NUMBER := 10;
43 --
44 G_AMV_APP_ID CONSTANT NUMBER := 520;
45 G_CONTENT CONSTANT VARCHAR2(30) := 'CONTENT';
46 G_GROUP CONSTANT VARCHAR2(30) := 'GROUP';
47 G_USER CONSTANT VARCHAR2(30) := 'USER';
48 G_PUBLIC CONSTANT VARCHAR2(30) := 'PUBLIC';
49 G_PRIVATE CONSTANT VARCHAR2(30) := 'PRIVATE';
50 G_PROTECTED CONSTANT VARCHAR2(30) := 'PROTECTED';
51 G_CATEGORY CONSTANT VARCHAR2(30) := 'CATEGORY';
52 G_CHANNEL CONSTANT VARCHAR2(30) := 'CHANNEL';
53 G_ITEM CONSTANT VARCHAR2(30) := 'ITEM';
54 G_APPLICATION CONSTANT VARCHAR2(30) := 'APPLICATION';
55 G_SUBSCRIBED CONSTANT VARCHAR2(30) := 'SUBSCRIBED';
56 G_ENFORCED CONSTANT VARCHAR2(30) := 'ENFORCED';
57 G_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
58 G_INACTIVE CONSTANT VARCHAR2(30) := 'INACTIVE';
59 G_NEED_APPROVAL CONSTANT VARCHAR2(30) := 'NEED_APPROVAL';
60 G_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED';
61 G_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED';
62 G_MORE_INFO CONSTANT VARCHAR2(30) := 'MORE_INFO';
63 G_PUB_APPROVAL CONSTANT VARCHAR2(30) := 'AMV_CONTENT_APPROVAL';
64 G_SUB_APPROVAL CONSTANT VARCHAR2(30) := 'AMV_SUBSCRIPTION_APPROVAL';
65 G_DEFAULT CONSTANT VARCHAR2(30) := 'DEFAULT';
66 G_OWNER CONSTANT VARCHAR2(30) := 'OWNER';
67 G_SECONDARY CONSTANT VARCHAR2(30) := 'SECONDARY';
68 G_DONE CONSTANT VARCHAR2(30) := 'DONE';
69 G_PUSH CONSTANT VARCHAR2(30) := 'PUSH';
70 G_MATCH CONSTANT VARCHAR2(30) := 'MATCH';
71 G_TABLE_NAME_CODE CONSTANT VARCHAR2(30) := 'ITEM';
72
73 -----------------------------------
74 -- System-wide record structures --
75 -----------------------------------
76 /*
77 TYPE AMV_NUMBER_ARRAY_TYPE is varray(5000) of number;
78 TYPE AMV_CHAR_ARRAY_TYPE is varray(5000) of varchar2(2000);
79 --
80 TYPE record_subset_request_rec_type IS RECORD (
81 records_requested NUMBER := G_MAX_VARRAY_SIZE,
82 start_record_position NUMBER := 1,
83 return_total_count_flag VARCHAR2(1) := FND_API.G_FALSE
84 );
85 --
86 TYPE record_subset_return_rec_type IS RECORD
87 (
88 returned_record_count NUMBER,
89 next_record_position NUMBER,
90 total_record_count NUMBER
91 );
92 --
93 TYPE amv_perspective_rec_type IS RECORD
94 (
95 perspective_id NUMBER,
96 object_version_number NUMBER,
97 perspective_name VARCHAR2(80),
98 description VARCHAR2(2000),
99 language VARCHAR2(4),
100 source_lang VARCHAR2(4),
101 creation_date DATE,
102 created_by NUMBER,
103 last_update_date DATE,
104 last_updated_by NUMBER,
105 last_update_login NUMBER
106 );
107 TYPE amv_perspective_rec_varray is varray(5000) of amv_perspective_rec_type;
108 --
109 TYPE amv_content_type_rec_type IS RECORD
110 (
111 content_type_id NUMBER,
112 object_version_number NUMBER,
113 content_type_name VARCHAR2(80),
114 description VARCHAR2(2000),
115 language VARCHAR2(4),
116 source_lang VARCHAR2(4),
117 creation_date DATE,
118 created_by NUMBER,
119 last_update_date DATE,
120 last_updated_by NUMBER,
121 last_update_login NUMBER
122 );
123 TYPE amv_content_type_rec_varray is varray(5000) of amv_content_type_rec_type;
124 --
125 TYPE amv_item_rec_type IS RECORD
126 (
127 item_id NUMBER,
128 object_version_number NUMBER,
129 creation_date DATE,
130 created_by NUMBER,
131 last_update_date DATE,
132 last_updated_by NUMBER,
133 last_update_login NUMBER,
134 application_id NUMBER,
135 title VARCHAR2(240),
136 description VARCHAR2(2000),
137 text_string VARCHAR2(2000),
138 language_code VARCHAR2(4),
139 status_code VARCHAR2(30),
140 owner_user_id NUMBER,
141 effective_start_date DATE,
142 expiration_date DATE,
143 item_type VARCHAR2(240),
144 content_type_id NUMBER,
145 publication_date DATE,
146 priority VARCHAR2(30),
147 default_approver_id NUMBER,
148 url_string VARCHAR2(2000),
149 item_destination_type VARCHAR2(240),
150 file_id_varray AMV_NUMBER_VARRAY_TYPE,
151 persp_id_varray AMV_NUMBER_VARRAY_TYPE,
152 persp_name_varray AMV_CHAR_VARRAY_TYPE, --Provide it for convenience.
153 author_varray AMV_CHAR_VARRAY_TYPE,
154 keyword_varray AMV_CHAR_VARRAY_TYPE
155 );
156 --
157 TYPE amv_simple_item_rec_type IS RECORD
158 (
159 item_id NUMBER,
160 object_version_number NUMBER,
161 creation_date DATE,
162 created_by NUMBER,
163 last_update_date DATE,
164 last_updated_by NUMBER,
165 last_update_login NUMBER,
166 application_id NUMBER,
167 title VARCHAR2(240),
168 description VARCHAR2(4000),
169 text_string VARCHAR2(4000),
170 language_code VARCHAR2(4),
171 status_code VARCHAR2(30),
172 owner_user_id NUMBER,
173 effective_start_date DATE,
174 expiration_date DATE,
175 item_type VARCHAR2(240),
176 content_type_id NUMBER,
177 publication_date DATE,
178 priority VARCHAR2(30),
179 default_approver_id NUMBER,
180 url_string VARCHAR2(2000),
181 item_destination_type VARCHAR2(240),
182 file_id_list VARCHAR2(4000),
183 persp_id_list VARCHAR2(4000),
184 persp_name_list VARCHAR2(4000), --Provide it for convenience.
185 author_list VARCHAR2(4000),
186 keyword_list VARCHAR2(4000)
187 );
188 TYPE amv_simple_item_rec_varray IS VARRAY(5000) of amv_simple_item_rec_type;
189 --
190 TYPE amv_group_rec_type IS RECORD
191 (
192 group_id NUMBER,
193 group_name VARCHAR2(80),
194 description VARCHAR2(2000),
195 owner_user_id NUMBER,
196 effective_start_date DATE,
197 expiration_date DATE
198 );
199 TYPE amv_group_rec_varray IS VARRAY(5000) of amv_group_rec_type;
200 --
201 TYPE amv_resource_rec_type IS RECORD
202 (
203 resource_id NUMBER,
204 person_id NUMBER,
205 user_name VARCHAR2(100),
206 first_name VARCHAR2(40),
207 last_name VARCHAR2(40)
208 );
209 TYPE amv_resource_rec_varray IS VARRAY(5000) of amv_resource_rec_type;
210 --
211 TYPE amv_access_flag_rec_type IS RECORD
212 (
213 CAN_VIEW_FLAG VARCHAR2(1),
214 CAN_CREATE_FLAG VARCHAR2(1),
215 CAN_DELETE_FLAG VARCHAR2(1),
216 CAN_UPDATE_FLAG VARCHAR2(1),
217 CAN_CREATE_DIST_RULE_FLAG VARCHAR2(1),
218 CHL_APPROVER_FLAG VARCHAR2(1),
219 CHL_REQUIRED_FLAG VARCHAR2(1),
220 CHL_REQUIRED_NEED_NOTIF_FLAG VARCHAR2(1)
221 );
222 --
223 TYPE amv_access_rec_type IS RECORD
224 (
225 ACCESS_ID NUMBER,
226 OBJECT_VERSION_NUMBER NUMBER(9),
227 ACCESS_TO_TABLE_CODE VARCHAR2(30),
228 ACCESS_TO_TABLE_RECORD_ID NUMBER,
229 USER_OR_GROUP_ID NUMBER,
230 USER_OR_GROUP_TYPE VARCHAR2(30),
231 EFFECTIVE_START_DATE DATE,
232 EXPIRATION_DATE DATE,
233 CAN_VIEW_FLAG VARCHAR2(1),
234 CAN_CREATE_FLAG VARCHAR2(1),
235 CAN_DELETE_FLAG VARCHAR2(1),
236 CAN_UPDATE_FLAG VARCHAR2(1),
237 CAN_CREATE_DIST_RULE_FLAG VARCHAR2(1),
238 CHL_APPROVER_FLAG VARCHAR2(1),
239 CHL_REQUIRED_FLAG VARCHAR2(1),
240 CHL_REQUIRED_NEED_NOTIF_FLAG VARCHAR2(1)
241 );
242 TYPE amv_access_rec_varray IS VARRAY(5000) of amv_access_rec_type;
243 */
244 --
245 -------------------------------------
246 -- System-wide Initialized Records --
247 -------------------------------------
248 --init_record_subset_request_rec record_subset_request_rec_type;
249 --init_record_subset_return_rec record_subset_return_rec_type;
250 -----------------------------
251 -- System-wide collections --
252 -----------------------------
253 --
254 ------------------------------------
255 -- Group Functions and Procedures --
256 ------------------------------------
257 --
258 --------------------------------------------------------------------------------
259 -- Start of comments
260 -- API name : Print_debug_message
261 -- Type : Private
262 -- Pre-reqs : None
263 -- Function : This procedure use dbms_output.put_line
264 -- to print out the passed message
265 -- Reformat: each line is at most 70 characters long.
266 -- Parameters :
267 -- IN : p_message VARCHAR2 REQUIRED
268 -- Version : Current version 1.0
269 -- Previous version 1.0
270 -- Initial version 1.0
271 -- Note : This procedure will change to do nothing in production.
272 -- End of comments
273 --
274 PROCEDURE Print_debug_message
275 (
276 p_message IN VARCHAR2
277 );
278 --
279 --------------------------------------------------------------------------------
280 --------------------------------------------------------------------------------
281 -- Start of comments
282 -- API name : Get_UserInfo
283 -- Type : Private
284 -- Pre-reqs : None
285 -- Function : Check and return (login) user status.
286 -- Parameters :
287 -- IN : p_user_id NUMBER Optional
288 -- user id. Default = FND_API.G_MISS_NUM
289 -- If user id is missing, use the current (login) user id.
290 -- OUT : x_resource_id NUMBER
291 -- resource id of the user if the user exist.
292 -- : x_user_id NUMBER
293 -- user id which is valid if user is exist.
294 -- : x_login_id NUMBER
295 -- the current login id (unique per section) if logined.
296 -- : x_user_status VARCHAR2
297 -- Version : Current version 1.0
298 -- Previous version 1.0
299 -- Initial version 1.0
300 -- Note :
301 -- End of comments
302 --
303 PROCEDURE Get_UserInfo
304 (
305 p_user_id IN NUMBER := FND_API.G_MISS_NUM,
306 x_resource_id OUT NOCOPY NUMBER,
307 x_user_id OUT NOCOPY NUMBER,
308 x_login_id OUT NOCOPY NUMBER,
309 x_user_status OUT NOCOPY VARCHAR2
310 );
311 --
312 --------------------------------------------------------------------------------
313 -- Start of comments
314 -- API name : Get_ResourceId
315 -- Type : Private
316 -- Pre-reqs : None
317 -- Function : return the resource id associated with the user id.
318 -- basically, it translates the user id into resource id.
319 -- Parameters :
320 -- IN : p_user_id NUMBER required
321 -- OUT : x_resource_id NUMBER
322 -- Version : Current version 1.0
323 -- Previous version 1.0
324 -- Initial version 1.0
325 -- Note :
326 -- End of comments
327 --
328 PROCEDURE Get_ResourceId
329 (
330 p_user_id IN NUMBER,
331 x_resource_id OUT NOCOPY NUMBER
332 );
333 --------------------------------------------------------------------------------
334 -- Start of comments
335 -- API name : Get_LoginUserId
336 -- Type : Private
337 -- Pre-reqs : None
338 -- Function : Call Standard API to check if user is login.
339 -- If so, it returns the login user id.
340 -- Otherwise, it returns FND_API.G_MISS_NUM.
341 -- Parameters :
342 -- IN : None
343 -- OUT : x_current_user_id NUMBER
344 -- the current (login) user id.
345 -- : x_current_login_id NUMBER
346 -- the current login id (unique per section).
347 -- Version : Current version 1.0
348 -- Previous version 1.0
349 -- Initial version 1.0
350 -- Note : This procedure return the global variable for currnet
351 -- user id and login id.
352 -- End of comments
353 --
354 PROCEDURE Get_LoginUserId
355 (
356 x_current_user_id OUT NOCOPY NUMBER,
357 x_current_login_id OUT NOCOPY NUMBER
358 );
359 --
360 --------------------------------------------------------------------------------
361 -- Start of comments
362 -- API name : Get_UserStatus
363 -- Type : Private
364 -- Pre-reqs : None
365 -- Function : Check and return (login) user status.
366 -- Parameters :
367 -- IN : p_user_id NUMBER Optional
368 -- user id. Default = FND_API.G_MISS_NUM
369 -- If user id is missing, use the current (login) user id.
370 -- OUT : x_user_id NUMBER
371 -- user id which is valid if user is exist.
372 -- : x_login_id NUMBER
373 -- the current login id (unique per section) if logined.
374 -- : x_user_status NUMBER
375 -- values: G_ACTIVE, G_INACTIVE, G_NOT_EXIST.
376 -- Version : Current version 1.0
377 -- Previous version 1.0
378 -- Initial version 1.0
379 -- Note :
380 -- End of comments
381 --
382 PROCEDURE Get_UserStatus
383 (
384 p_user_id IN NUMBER := FND_API.G_MISS_NUM,
385 x_user_id OUT NOCOPY NUMBER,
386 x_login_id OUT NOCOPY NUMBER,
387 x_user_status OUT NOCOPY NUMBER
388 );
389 --
390 --------------------------------------------------------------------------------
391 -- Start of comments
392 -- API name : Is_ItemIdValid
393 -- Type : Private
394 -- Pre-reqs : None
395 -- Function : Check if the passed item id is valid.
396 -- Parameters :
397 -- IN : p_item_id NUMBER Requried
398 -- OUT : None
399 -- Version : Current version 1.0
400 -- Previous version 1.0
401 -- Initial version 1.0
402 -- Note : This is a function returning a boolean. Not a procedure.
403 -- End of comments
404 --
405 FUNCTION Is_ItemIdValid(p_item_id IN NUMBER) RETURN Boolean;
406 --
407 --------------------------------------------------------------------------------
408 -- Start of comments
409 -- API name : Is_ChannelIdValid
410 -- Type : Private
411 -- Pre-reqs : None
412 -- Function : Check if the passed channel id is valid.
413 -- Parameters :
414 -- IN : p_channel_id NUMBER Requried
415 -- OUT : None
416 -- Version : Current version 1.0
417 -- Previous version 1.0
418 -- Initial version 1.0
419 -- Note : This is a function returning a boolean. Not a procedure.
420 -- End of comments
421 --
425 -- Start of comments
422 FUNCTION Is_ChannelIdValid(p_channel_id IN NUMBER) RETURN Boolean;
423 --
424 --------------------------------------------------------------------------------
426 -- API name : Is_CategoryIdValid
427 -- Type : Private
428 -- Pre-reqs : None
429 -- Function : Check if the passed category id is valid.
430 -- Parameters :
431 -- IN : p_category_id NUMBER Requried
432 -- OUT : None
433 -- Version : Current version 1.0
434 -- Previous version 1.0
435 -- Initial version 1.0
436 -- Note : This is a function returning a boolean. Not a procedure.
437 -- End of comments
438 --
439 FUNCTION Is_CategoryIdValid(p_category_id IN NUMBER) RETURN Boolean;
440 --------------------------------------------------------------------------------
441 -- Start of comments
442 -- API name : Is_ApplIdValid
443 -- Type : Private
444 -- Pre-reqs : None
445 -- Function : Check if the passed application id is valid.
446 -- Parameters :
447 -- IN : p_application_id NUMBER Requried
448 -- OUT : None
449 -- Version : Current version 1.0
450 -- Previous version 1.0
451 -- Initial version 1.0
452 -- Note : This is a function returning a boolean. Not a procedure.
453 -- End of comments
454 --
455 FUNCTION Is_ApplIdValid(p_application_id IN NUMBER) RETURN Boolean;
456 --
457 --------------------------------------------------------------------------------
458 -- Start of comments
459 -- API name : Is_PerspectiveIdValid
460 -- Type : Private
461 -- Pre-reqs : None
462 -- Function : Check if the passed perspective id is valid.
463 -- Parameters :
464 -- IN : p_perspective_id NUMBER Requried
465 -- OUT : None
466 -- Version : Current version 1.0
467 -- Previous version 1.0
468 -- Initial version 1.0
469 -- Note : This is a function returning a boolean. Not a procedure.
470 -- End of comments
471 --
472 FUNCTION Is_PerspectiveIdValid(p_perspective_id IN NUMBER) RETURN Boolean;
473 --
474 --------------------------------------------------------------------------------
475 -- Start of comments
476 -- API name : Is_ContentTypeIdValid
477 -- Type : Private
478 -- Pre-reqs : None
479 -- Function : Check if the passed content type id is valid.
480 -- Parameters :
481 -- IN : p_content_type_id NUMBER Requried
482 -- OUT : None
483 -- Version : Current version 1.0
484 -- Previous version 1.0
485 -- Initial version 1.0
486 -- Note : This is a function returning a boolean. Not a procedure.
487 -- End of comments
488 --
489 FUNCTION Is_ContentTypeIdValid(p_Content_Type_Id IN NUMBER) RETURN Boolean;
490 --
491 --------------------------------------------------------------------------------
492 -- Start of comments
493 -- API name : Is_RoleIdValid
494 -- Type : Private
495 -- Pre-reqs : None
496 -- Function : Check if the passed role id is valid.
497 -- Parameters :
498 -- IN : p_role_id NUMBER Requried
499 -- OUT : None
500 -- Version : Current version 1.0
501 -- Previous version 1.0
502 -- Initial version 1.0
503 -- Note : This is a function returning a boolean. Not a procedure.
504 -- End of comments
505 --
506 FUNCTION Is_RoleIdValid(p_role_id IN NUMBER) RETURN Boolean;
507 --
508 --------------------------------------------------------------------------------
509 -- Start of comments
510 -- API name : Is_ResourceIdValid
511 -- Type : Private
512 -- Pre-reqs : None
513 -- Function : Check if the passed resource id is valid.
514 -- Parameters :
515 -- IN : p_resource_id NUMBER Requried
516 -- OUT : None
517 -- Version : Current version 1.0
518 -- Previous version 1.0
519 -- Initial version 1.0
520 -- Note : This is a function returning a boolean. Not a procedure.
521 -- End of comments
522 --
523 FUNCTION Is_ResourceIdValid(p_resource_id IN NUMBER) RETURN Boolean;
524 --
525 --------------------------------------------------------------------------------
526 --------------------------------------------------------------------------------
527 -- Start of comments
528 -- API name : Is_NotificationIdValid
529 -- Type : Private
530 -- Pre-reqs : None
531 -- Function : Check if the passed notification id is valid.
532 -- Parameters :
533 -- IN : p_notification_id NUMBER Requried
534 -- OUT : None
535 -- Version : Current version 1.0
536 -- Previous version 1.0
537 -- Initial version 1.0
538 -- Note : This is a function returning a boolean. Not a procedure.
539 -- End of comments
540 --
541 FUNCTION Is_NotificationIdValid(p_notification_id IN NUMBER) RETURN Boolean;
542 --
543 --------------------------------------------------------------------------------
547 -- Pre-reqs : None
544 -- Start of comments
545 -- API name : Is_GroupIdValid
546 -- Type : Private
548 -- Function : Check if the passed group id is valid.
549 -- Parameters :
550 -- IN : p_group_id NUMBER Requried
551 -- OUT : None
552 -- Version : Current version 1.0
553 -- Previous version 1.0
554 -- Initial version 1.0
555 -- Note : This is a function returning a boolean. Not a procedure.
556 -- End of comments
557 --
558 FUNCTION Is_GroupIdValid(p_group_id IN NUMBER) RETURN Boolean;
559 --
560 --------------------------------------------------------------------------------
561 --
562 -- Start of comments
563 -- API name : Is_UserIdValid
564 -- Type : Private
565 -- Pre-reqs : None
566 -- Function : check if user id is valid and return a boolean value.
567 -- Parameters :
568 -- IN : p_user_id IN NUMBER Required
569 -- user id
570 -- OUT : None
571 -- Version : Current version 1.0
572 -- Previous version 1.0
573 -- Initial version 1.0
574 -- Notes :
575 -- End of comments
576 --
577 FUNCTION Is_UserIdValid (
578 p_user_id IN NUMBER
579 )
580 RETURN Boolean;
581 --------------------------------------------------------------------------------
582 --
583 -- Start of comments
584 -- API name : Is_MyChannelIdValid
585 -- Type : Private
586 -- Pre-reqs : None
587 -- Function : check if my channel id is valid and return boolean.
588 -- Parameters :
589 -- IN : p_mychannel_id IN NUMBER Required
590 -- OUT : None
591 -- Version : Current version 1.0
592 -- Previous version 1.0
593 -- Initial version 1.0
594 -- Notes :
595 -- End of comments
596 --
597 FUNCTION Is_MyChannelIdValid (
598 p_mychannel_id IN NUMBER
599 )
600 RETURN Boolean;
601 --------------------------------------------------------------------------------
602 --
603 -- Start of comments
604 -- API name : Get_DeleteChannelStatus
605 -- Type : Private
606 -- Pre-reqs : None
607 -- Function : check if user or group has privilege to delete a channel
608 -- return boolean.
609 -- Parameters :
610 -- IN : p_channel_id IN NUMBER Required
611 -- IN : p_user_or_group_id IN NUMBER Required
612 -- IN : p_user_or_group_type IN VARCHAR2 Required
613 -- OUT : None
614 -- Version : Current version 1.0
615 -- Previous version 1.0
616 -- Initial version 1.0
617 -- Notes :
618 -- End of comments
619 --
620 --
621 --
622 FUNCTION Get_DeleteChannelStatus
623 ( p_channel_id IN NUMBER,
624 p_user_or_group_id IN NUMBER,
625 p_user_or_group_type IN VARCHAR2) return boolean;
626 --------------------------------------------------------------------------------
627 --
628 -- Start of comments
629 -- API name : Get_UpdateChannelStatus
630 -- Type : Private
631 -- Pre-reqs : None
632 -- Function : check if user or group has privilege to update a channel
633 -- return boolean.
634 -- Parameters :
635 -- IN : p_channel_id IN NUMBER Required
636 -- IN : p_user_or_group_id IN NUMBER Required
637 -- IN : p_user_or_group_type IN VARCHAR2 Required
638 -- OUT : None
639 -- Version : Current version 1.0
640 -- Previous version 1.0
641 -- Initial version 1.0
642 -- Notes :
643 -- End of comments
644 --
645 --
646 FUNCTION Get_UpdateChannelStatus
647 ( p_channel_id IN NUMBER,
648 p_user_or_group_id IN NUMBER,
649 p_user_or_group_type IN VARCHAR2) return boolean;
650 --
651 --------------------------------------------------------------------------------
652 --
653 -- Start of comments
654 -- API name : Get_DeleteCategoryStatus
655 -- Type : Private
656 -- Pre-reqs : None
657 -- Function : check if user or group has privilege to delete a category
658 -- return boolean.
659 -- Parameters :
660 -- IN : p_category_id IN NUMBER Required
661 -- IN : p_user_or_group_id IN NUMBER Required
662 -- IN : p_user_or_group_type IN VARCHAR2 Required
663 -- OUT : None
664 -- Version : Current version 1.0
665 -- Previous version 1.0
666 -- Initial version 1.0
667 -- Notes :
668 -- End of comments
669 --
670 FUNCTION Get_DeleteCategoryStatus
671 ( p_category_id IN NUMBER,
672 p_user_or_group_id IN NUMBER,
673 p_user_or_group_type IN VARCHAR2) return boolean;
674 --------------------------------------------------------------------------------
675 --
676 -- Start of comments
677 -- API name : Get_UpdateCategoryStatus
678 -- Type : Private
679 -- Pre-reqs : None
680 -- Function : check if user or group has privilege to update a category
681 -- return boolean.
682 -- Parameters :
683 -- IN : p_category_id IN NUMBER Required
684 -- IN : p_user_or_group_id IN NUMBER Required
685 -- IN : p_user_or_group_type IN VARCHAR2 Required
686 -- OUT : None
687 -- Version : Current version 1.0
688 -- Previous version 1.0
689 -- Initial version 1.0
690 -- Notes :
691 -- End of comments
692 --
693 --
694 FUNCTION Get_UpdateCategoryStatus
695 ( p_category_id IN NUMBER,
696 p_user_or_group_id IN NUMBER,
697 p_user_or_group_type IN VARCHAR2) return boolean;
698 --
699 END amv_utility_pvt;