1 PACKAGE AMW_LOAD_CTRL_DATA AUTHID CURRENT_USER AS
2 /* $Header: amwctrds.pls 120.0 2005/06/15 18:03:19 appldev noship $ */
3
4 PROCEDURE create_controls (
5 ERRBUF OUT NOCOPY VARCHAR2
6 ,RETCODE OUT NOCOPY VARCHAR2
7 ,p_batch_id IN NUMBER
8 ,p_user_id IN NUMBER
9
10 );
11
12 PROCEDURE update_interface_with_error (
13 p_err_msg IN VARCHAR2
14 ,p_table_name IN VARCHAR2
15 ,p_interface_id IN NUMBER
16 );
17
18 PROCEDURE control_objectives (
19 p_ctrl_obj_flag IN VARCHAR2,
20 p_lookup_tag IN VARCHAR2
21 );
22 PROCEDURE control_assertions (
23 p_ctrl_assert_flag IN VARCHAR2,
24 p_lookup_tag IN VARCHAR2
25 );
26 PROCEDURE control_components (
27 p_ctrl_comp_flag IN VARCHAR2,
28 p_lookup_tag IN VARCHAR2
29 );
30
31 PROCEDURE control_PURPOSES (
32 p_ctrl_PURPOSE_flag IN VARCHAR2
33 ,p_lookup_tag IN VARCHAR2);
34
35 ---
36 ---02.28.2005 npanandi: add Control Owner privilege here for data security
37 ---
38 procedure add_owner_privilege(
39 p_role_name in varchar2
40 ,p_object_name in varchar2
41 ,p_grantee_type in varchar2
42 ,p_instance_set_id in number default null
43 ,p_instance_pk1_value in varchar2
44 ,p_instance_pk2_value in varchar2 default null
45 ,p_instance_pk3_value in varchar2 default null
46 ,p_instance_pk4_value in varchar2 default null
47 ,p_instance_pk5_value in varchar2 default null
48 ,p_user_id in number
49 ,p_start_date in date default sysdate
50 ,p_end_date in date default null);
51
52 ---
53 ---02.28.2005 npanandi: function to check access privilege for this Control
54 ---
55 function check_function(
56 p_function in varchar2
57 ,p_object_name in varchar2
58 ,p_instance_pk1_value in number
59 ,p_instance_pk2_value in number default null
60 ,p_instance_pk3_value in number default null
61 ,p_instance_pk4_value in number default null
62 ,p_instance_pk5_value in number default null
63 ,p_user_id in number) return varchar2;
64
65 END amw_load_ctrl_data;