1 PACKAGE FND_OAM_DSCRAM AUTHID CURRENT_USER AS
2 /* $Header: AFOAMDSS.pls 120.6.12000000.3 2007/04/21 02:56:17 ssuprasa ship $ */
3
4 ---------------
5 -- Constants --
6 ---------------
7
8 ---------------------------------
9 -- Public Procedures/Functions --
10 ---------------------------------
11
12 -- This procedure is used to insert a policy into fnd_oam_ds_policies_b and
13 -- fnd_oam_ds_policies_tl
14
15 procedure insert_policy
16 (
17 policyid OUT NOCOPY NUMBER,
18 pname in varchar2,
19 l_description IN VARCHAR2 DEFAULT NULL,
20 l_created_by IN NUMBER,
21 l_last_updated_by IN NUMBER,
22 l_last_update_login IN NUMBER
23 );
24
25 -- This procedure is used to update a policy
26
27 procedure update_policy
28 (
29 policyid in number,
30 pname in varchar2,
31 l_description IN VARCHAR2 DEFAULT NULL,
32 l_last_updated_by IN NUMBER,
33 l_last_update_login IN NUMBER
34 );
35
36 -- This procedure is used to insert an attribute as an element of a policy with policyid
37
38 procedure add_policy_attri_element
39 (
40 policyid in number,
41 attribute_code IN VARCHAR2,
42 l_created_by IN NUMBER,
43 l_last_updated_by IN NUMBER,
44 l_last_update_login IN NUMBER
45 );
46
47 -- add a new delete element for a policy with policyid
48
49 procedure add_policy_del_element
50 (
51 policyid in number,
52 deleteid IN NUMBER,
53 l_created_by IN NUMBER,
54 l_last_updated_by IN NUMBER,
55 l_last_update_login IN NUMBER
56 );
57
58 -- remove all policy elements for a policy with policyid
59
60 procedure remove_policy_elements
61 (
62 policyid in number
63 );
64
65 -- insert a new policy set
66
67 procedure insert_policyset
68 (
69 psetid OUT NOCOPY NUMBER,
70 psetname in varchar2,
71 l_description IN VARCHAR2 DEFAULT NULL,
72 l_created_by IN NUMBER,
73 l_last_updated_by IN NUMBER,
74 l_last_update_login IN NUMBER
75 );
76
77 -- update a new policy set
78
79 procedure update_policyset
80 (
81 psetid in number,
82 psetname in varchar2,
83 l_description IN VARCHAR2 DEFAULT NULL,
84 l_last_updated_by IN NUMBER,
85 l_last_update_login IN NUMBER
86 );
87
88 -- add a new policy as an element of a policy set with psetid
89
90 procedure add_pset_element
91 (
92 psetid in number,
93 policyid in number,
94 l_created_by IN NUMBER,
95 l_last_updated_by IN NUMBER,
96 l_last_update_login IN NUMBER
97 );
98
99 -- remove all elements for a policy set with psetid
100
101 procedure remove_pset_elements
102 (
103 psetid in number
104 );
105
106 -- syschange
107 -- delete the pii attribute
108 procedure delete_pii_attribute
109 (
110 attribute_code IN VARCHAR2
111 );
112
113
114 -- delete the policy
115 procedure delete_policy
116 (
117 p_policy_id IN NUMBER
118 );
119
120 -- delete the policy
121 procedure delete_pset
122 (
123 pset_id IN NUMBER
124 );
125
126 -- delete table for purge
127 procedure delete_tbl_to_purge
128 (
129 deleteid IN NUMBER
130 );
131 -- add a new delete entry into FND_OAM_DS_DELETES
132
133 procedure add_delete
134 (
135 l_table_name IN VARCHAR2,
136 l_owner IN VARCHAR2 DEFAULT NULL,
137 l_where_clause IN VARCHAR2 DEFAULT NULL,
138 l_use_truncate_flag IN VARCHAR2 DEFAULT NULL,
139 l_created_by IN NUMBER,
140 l_last_updated_by IN NUMBER,
141 l_last_update_login IN NUMBER
142 );
143
144
145 procedure update_delete
146 (
147 l_delete_id IN VARCHAR2,
148 l_where_clause IN VARCHAR2 DEFAULT NULL,
149 l_use_truncate_flag IN VARCHAR2 DEFAULT NULL,
150 l_last_updated_by IN NUMBER
151 ) ;
152
153 -- remove a delete entry with deleteid from FND_OAM_DS_DELETES
154
155 procedure remove_delete
156 (
157 deleteid in number
158 );
159
160 -- insert a new PII privacy attribute
161
162 procedure insert_pii_attribute
163 (
164 attribute_code OUT NOCOPY VARCHAR2,
165 attribute_name IN VARCHAR2,
166 l_algorithm IN VARCHAR2 DEFAULT NULL,
167 l_description IN VARCHAR2 DEFAULT NULL,
168 l_created_by IN NUMBER,
169 l_last_updated_by IN NUMBER,
170 l_last_update_login IN NUMBER
171 );
172
173
174 procedure update_pii_attribute
175 (
176 attribute_code IN VARCHAR2,
177 attribute_name IN VARCHAR2,
178 l_algorithm IN VARCHAR2 DEFAULT NULL,
179 l_description IN VARCHAR2 DEFAULT NULL,
180 l_created_by IN NUMBER,
181 l_last_updated_by IN NUMBER,
182 l_last_update_login IN NUMBER
183 );
184
185 -- update a PII privacy attribute
186 procedure pre_update_pii_attribute
187 (
188 attribute_code IN VARCHAR2
189
190 );
191
192 -- add a new PII privacy attribute column for a privacy attribute with attribute_code
193
194 procedure add_attribute_col
195 (
196 attribute_code IN VARCHAR2,
197 l_table_name IN VARCHAR2,
198 l_column_name IN VARCHAR2,
199 l_where_clause IN VARCHAR2 DEFAULT NULL,
200 l_algorithm IN VARCHAR2 DEFAULT NULL,
201 l_created_by IN NUMBER,
202 l_last_updated_by IN NUMBER,
203 l_last_update_login IN NUMBER
204 );
205
206 /*
207 -Unused-
208 -- remove a PII privacy attribute column for a privacy attribute with attribute_code
209
210 procedure remove_attribute_col
211 (
212 attribute_code IN VARCHAR2,
213 l_table_name IN VARCHAR2,
214 l_column_name IN VARCHAR2
215 );
216 */
217
218 -- DSCFG_PROCS-compliant procedure for the IMPORT phase. Traverses a Policy Set
219 -- and uses DSCFG_API_PKG calls to create entities for each PII attribute and
220 -- OAM delete entity found. This procedure tracks already inserted attributes to
221 -- keep from inserting dups but does not track previous columns to detect conflicts
222 -- since this is not required of import procedures.
223 -- Invariants:
224 -- Should only be invoked as part of the Intermediate Configuration Import phase,
225 -- API's require state that is only set at that time.
226 -- Parameters:
227 -- None
228 PROCEDURE IMPORT_POLICY_SET_TO_DSCFG;
229
230 end fnd_oam_dscram;