1 PACKAGE OTA_ADMIN_ACCESS_UTIL AUTHID CURRENT_USER as
2 /* $Header: otadminacc.pkh 120.8 2011/05/03 09:32:24 smahanka noship $ */
3
4
5 Cursor check_is_category_secured(category_id in number) IS
6 Select user_group_id
7 from ota_category_usages
8 where category_usage_id=category_id;
9
10 Cursor get_lo_id(tst_id in number) IS
11 Select learning_object_id
12 from ota_learning_objects
13 where test_id=tst_id;
14 function admin_can_access_object(p_object_type in varchar,
15 p_object_id in number,
16 p_module_name IN VARCHAR2 default 'ADMIN') return varchar2;
17
18 function lp_has_access_to_course(p_lp_id in NUMBER,
19 p_crs_id in NUMBER) return varchar2;
20
21
22 function cert_has_access_to_course(p_cert_id in NUMBER,
23 p_crs_id in NUMBER) return varchar2;
24
25 function offering_has_access_to_lo(p_course_id in NUMBER,
26 p_lo_id in NUMBER) return varchar2 ;
27
28
29 function category_has_access_to_object(p_object_type in varchar2,
30 p_object_id in NUMBER,
31 p_category_id in NUMBER) return varchar2 ;
32
33 function folder_has_access_to_object(p_object_type in varchar2,
34 p_object_id in NUMBER,
35 p_folder_id in NUMBER) return varchar2;
36
37 function lo_has_access_to_object( p_object_type in varchar2,
38 p_object_id in NUMBER,
39 p_lo_id in NUMBER) return varchar2;
40
41 function object_has_access_to_eval(p_object_type in varchar,
42 p_object_id in NUMBER,
43 p_test_id in NUMBER) return varchar2;
44
45
46 function object_can_add_category(p_object_type in varchar,
47 p_object_id in NUMBER,
48 p_category_usage_id in NUMBER) return varchar2;
49
50 function can_add_object_as_prereq(p_object_type in varchar,
51 p_obj_id in NUMBER,
52 p_prereq_obj_id in NUMBER) return varchar2;
53
54 function get_admin_group_id(p_object_type in varchar,
55 p_object_id in number) return Number;
56 function lo_has_access_to_offering(p_course_id in NUMBER,
57 p_lo_id in NUMBER,
58 p_category_id in NUMBER default NULL)return varchar2;
59
60 function test_has_access_to_qbank(p_qbank_id in NUMBER,
61 p_lo_id in NUMBER,
62 p_folder_id in NUMBER)return varchar2 ;
63
64 function test_has_access_to_qbank(p_qbank_id in NUMBER,
65 p_test_id in NUMBER)return varchar2 ;
66
67
68
69 FUNCTION get_lo_offering_count (p_learning_object_id in number) RETURN varchar2;
70
71 function admin_can_access_chat(p_chat_id in number) return varchar2;
72
73 function admin_can_access_forum(p_forum_id in number) return varchar2;
74 function disable_select(p_object_type in varchar2,
75 p_object_id in NUMBER,
76 p_dest_object_type in varchar2,
77 p_dest_object_id in NUMBER,
78 p_action in varchar2 default 'Copy' )return varchar2;
79 function disable_content_obj_select(p_object_type in varchar2,
80 p_object_id in NUMBER,
81 p_dest_obj_type in varchar2,
82 p_dest_obj_id in NUMBER
83 ) return varchar2 ;
84 end ota_admin_access_util;
85
86