1 PACKAGE AMW_LOAD_RCM_ORG_DATA AUTHID CURRENT_USER AS
2 /* $Header: amwrcmos.pls 120.0 2005/05/31 20:57:14 appldev noship $ */
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 PROCEDURE update_interface_with_error (
12 p_err_msg IN VARCHAR2
13 ,p_table_name IN VARCHAR2
14 ,p_interface_id IN NUMBER
15 );
16
17 PROCEDURE risk_types (
18 p_risk_type_flag IN VARCHAR2,
19 p_lookup_tag IN VARCHAR2,
20 p_is_last_call in varchar2
21 );
22
23 PROCEDURE control_objectives (
24 p_ctrl_obj_flag IN VARCHAR2,
25 p_lookup_tag IN VARCHAR2
26 );
27
28 PROCEDURE control_assertions (
29 p_ctrl_assert_flag IN VARCHAR2,
30 p_lookup_tag IN VARCHAR2
31 );
32
33 PROCEDURE control_components (
34 p_ctrl_comp_flag IN VARCHAR2,
35 p_lookup_tag IN VARCHAR2
36 );
37
38 PROCEDURE create_process_objectives (
39 p_process_objective_name IN VARCHAR2,
40 p_process_obj_description IN Varchar2,
41 p_requestor_id IN number,
42 x_return_status out nocopy varchar2);
43
44 PROCEDURE CREATE_AMW_CTRL_ASSOC(
45 P_ORGANIZATION_ID IN NUMBER
46 ,P_PROCESS_ID IN NUMBER
47 ,P_RISK_ID IN NUMBER
48 ,P_CONTROL_ID IN NUMBER
49 );
50
51 PROCEDURE PROCESS_AP_CTRL_ASSOC_RCM(
52 P_CONTROL_ID IN NUMBER
53 ,P_AUDIT_PROCEDURE_ID IN NUMBER
54 ,P_OP_EFFECTIVENESS IN VARCHAR2
55 ,P_DESIGN_EFFECTIVENESS IN VARCHAR2
56 --NPANANDI 12.09.2004: ADDED RETURN STATUS BECAUSE
57 --CALLING REVISE_AP BELOW
58 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
59 ,X_MSG_COUNT OUT NOCOPY NUMBER
60 ,X_MSG_DATA OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE PROCESS_AP_CTRL_ASSOC_ORG(
64 P_ORGANIZATION_ID IN NUMBER
65 ,P_PROCESS_ID IN NUMBER
66 ,P_CONTROL_ID IN NUMBER
67 ,P_AUDIT_PROCEDURE_ID IN NUMBER
68 ,P_OP_EFFECTIVENESS IN VARCHAR2
69 ,P_DESIGN_EFFECTIVENESS IN VARCHAR2
70 ---03.03.2005 npanandi: added below param for access privilege
71 ---check for Updates
72 ,p_has_assn_access in varchar2
73 );
74
75 PROCEDURE CREATE_AMW_AP_ASSOC(
76 P_PK1 IN NUMBER
77 ,P_PK2 IN NUMBER
78 ,P_PK3 IN NUMBER
79 ,P_OBJECT_TYPE IN VARCHAR2
80 ,P_AUDIT_PROCEDURE_ID IN NUMBER
81 ,P_DESIGN_EFFECTIVENESS IN VARCHAR2
82 ,P_OP_EFFECTIVENESS IN VARCHAR2
83 );
84
85 PROCEDURE CREATE_AMW_OBJ_ASSOC(
86 P_PROCESS_OBJECTIVE_ID IN NUMBER
87 ,P_PK1 IN NUMBER
88 --01.13.2005 npanandi: added pk2,pk3,pk4,pk5 for Ctrl to Objective association
89 ,P_PK2 IN NUMBER DEFAULT NULL
90 ,P_PK3 IN NUMBER DEFAULT NULL
91 ,P_PK4 IN NUMBER DEFAULT NULL
92 ,P_PK5 IN NUMBER DEFAULT NULL
93 ,P_OBJECT_TYPE IN VARCHAR2
94 );
95
96 PROCEDURE CREATE_AMW_RISK_ASSOC(
97 P_ORGANIZATION_ID IN NUMBER
98 ,P_PROCESS_ID IN NUMBER
99 ,P_RISK_ID IN NUMBER
100 ,P_RISK_LIKELIHOOD_CODE IN VARCHAR2
101 ,P_RISK_IMPACT_CODE IN VARCHAR2
102 ,P_MATERIAL IN VARCHAR2
103 ,P_MATERIAL_VALUE IN NUMBER
104 );
105
106 ---
107 ---03.03.2005 npanandi: add Owner privilege here for data security
108 ---
109 procedure add_owner_privilege(
110 p_role_name in varchar2
111 ,p_object_name in varchar2
112 ,p_grantee_type in varchar2
113 ,p_instance_set_id in number default null
114 ,p_instance_pk1_value in varchar2
115 ,p_instance_pk2_value in varchar2 default null
116 ,p_instance_pk3_value in varchar2 default null
117 ,p_instance_pk4_value in varchar2 default null
118 ,p_instance_pk5_value in varchar2 default null
119 ,p_user_id in number
120 ,p_start_date in date default sysdate
121 ,p_end_date in date default null);
122
123 ---
124 ---03.03.2005 npanandi: function to check access privilege before any updates
125 ---
126 function check_function(
127 p_function in varchar2
128 ,p_object_name in varchar2
129 ,p_instance_pk1_value in number
130 ,p_instance_pk2_value in number default null
131 ,p_instance_pk3_value in number default null
132 ,p_instance_pk4_value in number default null
133 ,p_instance_pk5_value in number default null
134 ,p_user_id in number) return varchar2;
135
136 ---
137 ---03.28.2005 npanandi: bug 4262532 fix
138 ---
139 procedure create_entity_risk(
140 p_organization_id in number
141 ,p_risk_id in number
142 ,p_risk_likelihood_code in varchar2
143 ,p_risk_impact_code in varchar2
144 ,p_material in varchar2
145 ,p_material_value in number);
146
147 ---
148 ---03.28.2005 npanandi: bug 4262532 fix
149 ---
150 procedure create_entity_control(
151 p_organization_id in number
152 ,p_risk_id in number
153 ,p_control_id in number);
154
155 END amw_load_rcm_org_data;