1 PACKAGE AMW_LOAD_RC_DATA AUTHID CURRENT_USER AS
2 /* $Header: amwrclds.pls 120.0.12000000.1 2007/01/16 20:40:59 appldev ship $ */
3
4 PROCEDURE create_risks_and_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
13 PROCEDURE update_interface_with_error (
14 p_err_msg IN VARCHAR2
15 ,p_table_name IN VARCHAR2
16 ,p_interface_id IN NUMBER
17 );
18
19 PROCEDURE risk_types (
20 p_risk_type_flag IN VARCHAR2,
21 p_lookup_tag IN VARCHAR2,
22 p_is_last_call in varchar2
23 );
24
25 PROCEDURE control_objectives (
26 p_ctrl_obj_flag IN VARCHAR2,
27 p_lookup_tag IN VARCHAR2
28 );
29 PROCEDURE control_assertions (
30 p_ctrl_assert_flag IN VARCHAR2,
31 p_lookup_tag IN VARCHAR2
32 );
33
34 --KOSRINIV control_components
35
36 PROCEDURE control_components (
37 p_ctrl_comp_flag IN VARCHAR2,
38 p_lookup_tag IN VARCHAR2
39 );
40
41
42 PROCEDURE create_process_objectives (
43 p_process_objective_name IN VARCHAR2,
44 p_process_obj_description IN Varchar2,
45 p_requestor_id IN number,
46 x_return_status out nocopy varchar2);
47
48 PROCEDURE CREATE_AMW_CTRL_ASSOC(
49 P_CONTROL_ID IN NUMBER
50 ,P_PROCESS_ID IN NUMBER
51 ,P_RISK_ID IN NUMBER
52 );
53
54 PROCEDURE CREATE_AMW_AP_ASSOC(
55 P_CONTROL_ID IN NUMBER
56 ,P_AUDIT_PROCEDURE_ID IN NUMBER
57 ,P_DESIGN_EFFECTIVENESS IN VARCHAR2
58 ,P_OP_EFFECTIVENESS IN VARCHAR2
59 --NPANANDI 12.09.2004: ADDED RETURN STATUS BECAUSE
60 --CALLING REVISE_AP BELOW
61 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
62 ,X_MSG_COUNT OUT NOCOPY NUMBER
63 ,X_MSG_DATA OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE CREATE_AMW_OBJ_ASSOC(
67 P_PROCESS_OBJECTIVE_ID IN NUMBER
68 ,P_PK1 IN NUMBER
69 ---01.13.2005 npanandi: added pk2,pk3,pk4,pk5 for Ctrl to Obj association
70 ,P_PK2 IN NUMBER DEFAULT NULL
71 ,P_PK3 IN NUMBER DEFAULT NULL
72 ,P_PK4 IN NUMBER DEFAULT NULL
73 ,P_PK5 IN NUMBER DEFAULT NULL
74 ,P_OBJECT_TYPE IN VARCHAR2
75 );
76
77 PROCEDURE CREATE_AMW_RISK_ASSOC(
78 P_RISK_ID IN NUMBER
79 ,P_PROCESS_ID IN NUMBER
80 ,P_RISK_LIKELIHOOD_CODE IN VARCHAR2
81 ,P_RISK_IMPACT_CODE IN VARCHAR2
82 ,P_MATERIAL IN VARCHAR2
83 ,P_MATERIAL_VALUE IN NUMBER
84 );
85
86 ---
87 ---03.01.2005 npanandi: add Audit Procedure Owner privilege here for data security
88 ---
89 procedure add_owner_privilege(
90 p_role_name in varchar2
91 ,p_object_name in varchar2
92 ,p_grantee_type in varchar2
93 ,p_instance_set_id in number default null
94 ,p_instance_pk1_value in varchar2
95 ,p_instance_pk2_value in varchar2 default null
96 ,p_instance_pk3_value in varchar2 default null
97 ,p_instance_pk4_value in varchar2 default null
98 ,p_instance_pk5_value in varchar2 default null
99 ,p_user_id in number
100 ,p_start_date in date default sysdate
101 ,p_end_date in date default null);
102
103 ---
104 ---03.01.2005 npanandi: function to check access privilege for this Audit Procedure
105 ---
106 function check_function(
107 p_function in varchar2
108 ,p_object_name in varchar2
109 ,p_instance_pk1_value in number
110 ,p_instance_pk2_value in number default null
111 ,p_instance_pk3_value in number default null
112 ,p_instance_pk4_value in number default null
113 ,p_instance_pk5_value in number default null
114 ,p_user_id in number) return varchar2;
115 END amw_load_rc_data;