[Home] [Help]
PACKAGE: APPS.AMW_FIN_COSO_VIEWS_PVT
Source
1 PACKAGE amw_fin_coso_views_pvt AUTHID CURRENT_USER AS
2 /* $Header: amwcfcvs.pls 120.0.12000000.1 2007/01/16 20:37:40 appldev ship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- amw_fin_coso_views_pvt
8 -- Purpose
9 -- Contains the PL/Sql Procedures that suppots the import
10 -- of Financial Statements,Financial Items and Accounts
11 -- History
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 type component_code_array is table of varchar2(30) index by pls_integer;
19
20 type total_control_array is table of number index by pls_integer;
21
22 type ineff_control_array is table of number index by pls_integer;
23
24 PROCEDURE create_fin_ctrl_Assertions
25 (P_CERTIFICATION_ID number ,
26 P_FINANCIAL_STATEMENT_ID number,
27 P_STATEMENT_GROUP_ID number,
28 P_FINANCIAL_ITEM_ID number,
29 P_ACCOUNT_GROUP_ID number ,
30 P_ACCOUNT_ID number ,
31 P_OBJECT_TYPE varchar2 ) ;
32
33 PROCEDURE create_fin_ctrl_objectives
34 (P_CERTIFICATION_ID number ,
35 P_FINANCIAL_STATEMENT_ID number,
36 P_STATEMENT_GROUP_ID number,
37 P_FINANCIAL_ITEM_ID number,
38 P_ACCOUNT_GROUP_ID number ,
39 P_ACCOUNT_ID number ,
40 P_OBJECT_TYPE varchar2 );
41
42
43 PROCEDURE create_fin_ctrl_components
44 (P_CERTIFICATION_ID number ,
45 P_FINANCIAL_STATEMENT_ID number,
46 P_STATEMENT_GROUP_ID number,
47 P_FINANCIAL_ITEM_ID number,
48 P_ACCOUNT_GROUP_ID number ,
49 P_ACCOUNT_ID number ,
50 P_OBJECT_TYPE varchar2 ) ;
51
52 procedure DELETE_ROWS ( x_fin_certification_id NUMBER ) ;
53
54 procedure INSERT_ROW (
55 x_fin_certification_id NUMBER ,
56 x_financial_statement_id NUMBER ,
57 x_financial_item_id NUMBER ,
58 x_account_group_id NUMBER,
59 x_natural_account_id NUMBER,
60 x_object_type VARCHAR2,
61 x_ctrl_attribute_type VARCHAR2,
62 x_ctrl_attr_code_1 VARCHAR2,
63 x_ineff_ctrl_attr_1 NUMBER,
64 x_total_ctrl_attr_1 NUMBER,
65 x_ctrl_attr_code_2 VARCHAR2,
66 x_ineff_ctrl_attr_2 NUMBER,
67 x_total_ctrl_attr_2 NUMBER,
68 x_ctrl_attr_code_3 VARCHAR2,
69 x_ineff_ctrl_attr_3 NUMBER,
70 x_total_ctrl_attr_3 NUMBER,
71 x_ctrl_attr_code_4 VARCHAR2,
72 x_ineff_ctrl_attr_4 NUMBER,
73 x_total_ctrl_attr_4 NUMBER,
74 x_ctrl_attr_code_5 VARCHAR2,
75 x_ineff_ctrl_attr_5 NUMBER,
76 x_total_ctrl_attr_5 NUMBER,
77 x_ctrl_attr_code_6 VARCHAR2,
78 x_ineff_ctrl_attr_6 NUMBER,
79 x_total_ctrl_attr_6 NUMBER,
80 x_ctrl_attr_code_7 VARCHAR2,
81 x_ineff_ctrl_attr_7 NUMBER,
82 x_total_ctrl_attr_7 NUMBER,
83 x_ctrl_attr_code_8 VARCHAR2,
84 x_ineff_ctrl_attr_8 NUMBER,
85 x_total_ctrl_attr_8 NUMBER,
86 x_ctrl_attr_code_9 VARCHAR2,
87 x_ineff_ctrl_attr_9 NUMBER,
88 x_total_ctrl_attr_9 NUMBER,
89 x_ctrl_attr_code_10 VARCHAR2,
90 x_ineff_ctrl_attr_10 NUMBER,
91 x_total_ctrl_attr_10 NUMBER,
92 x_ctrl_attr_code_11 VARCHAR2,
93 x_ineff_ctrl_attr_11 NUMBER,
94 x_total_ctrl_attr_11 NUMBER,
95 x_ctrl_attr_code_12 VARCHAR2,
96 x_ineff_ctrl_attr_12 NUMBER,
97 x_total_ctrl_attr_12 NUMBER,
98 x_ctrl_attr_code_13 VARCHAR2,
99 x_ineff_ctrl_attr_13 NUMBER,
100 x_total_ctrl_attr_13 NUMBER,
101 x_ctrl_attr_code_14 VARCHAR2,
102 x_ineff_ctrl_attr_14 NUMBER,
103 x_total_ctrl_attr_14 NUMBER,
104 x_ctrl_attr_code_15 VARCHAR2,
105 x_ineff_ctrl_attr_15 NUMBER,
106 x_total_ctrl_attr_15 NUMBER,
107 x_ctrl_attr_code_16 VARCHAR2,
108 x_ineff_ctrl_attr_16 NUMBER,
109 x_total_ctrl_attr_16 NUMBER,
110 x_ctrl_attr_code_17 VARCHAR2,
111 x_ineff_ctrl_attr_17 NUMBER,
112 x_total_ctrl_attr_17 NUMBER,
113 x_ctrl_attr_code_18 VARCHAR2,
114 x_ineff_ctrl_attr_18 NUMBER,
115 x_total_ctrl_attr_18 NUMBER,
116 x_ctrl_attr_code_19 VARCHAR2,
117 x_ineff_ctrl_attr_19 NUMBER,
118 x_total_ctrl_attr_19 NUMBER,
119 x_ctrl_attr_code_20 VARCHAR2,
120 x_ineff_ctrl_attr_20 NUMBER,
121 x_total_ctrl_attr_20 NUMBER,
122 x_ctrl_attr_code_21 VARCHAR2,
123 x_ineff_ctrl_attr_21 NUMBER,
124 x_total_ctrl_attr_21 NUMBER,
125 x_ctrl_attr_code_22 VARCHAR2,
126 x_ineff_ctrl_attr_22 NUMBER,
127 x_total_ctrl_attr_22 NUMBER,
128 x_ctrl_attr_code_23 VARCHAR2,
129 x_ineff_ctrl_attr_23 NUMBER,
130 x_total_ctrl_attr_23 NUMBER,
131 x_ctrl_attr_code_24 VARCHAR2,
132 x_ineff_ctrl_attr_24 NUMBER,
133 x_total_ctrl_attr_24 NUMBER,
134 x_ctrl_attr_code_25 VARCHAR2,
135 x_ineff_ctrl_attr_25 NUMBER,
136 x_total_ctrl_attr_25 NUMBER,
137 x_ctrl_attr_code_26 VARCHAR2,
138 x_ineff_ctrl_attr_26 NUMBER,
139 x_total_ctrl_attr_26 NUMBER,
140 x_ctrl_attr_code_27 VARCHAR2,
141 x_ineff_ctrl_attr_27 NUMBER,
142 x_total_ctrl_attr_27 NUMBER,
143 x_ctrl_attr_code_28 VARCHAR2,
144 x_ineff_ctrl_attr_28 NUMBER,
145 x_total_ctrl_attr_28 NUMBER,
146 x_ctrl_attr_code_29 VARCHAR2,
147 x_ineff_ctrl_attr_29 NUMBER,
148 x_total_ctrl_attr_29 NUMBER,
149 x_ctrl_attr_code_30 VARCHAR2,
150 x_ineff_ctrl_attr_30 NUMBER,
151 x_total_ctrl_attr_30 NUMBER,
152 x_created_by NUMBER ,
153 x_creation_date DATE ,
154 x_last_updated_by NUMBER,
155 x_last_update_date DATE ,
156 x_last_update_login NUMBER,
157 -- x_security_group_id NUMBER,
158 x_object_version_number NUMBER,
159 x_acc_assert_flag1 VARCHAR2,
160 x_acc_assert_flag2 VARCHAR2,
161 x_acc_assert_flag3 VARCHAR2,
162 x_acc_assert_flag4 VARCHAR2,
163 x_acc_assert_flag5 VARCHAR2,
164 x_acc_assert_flag6 VARCHAR2,
165 x_acc_assert_flag7 VARCHAR2,
166 x_acc_assert_flag8 VARCHAR2,
167 x_acc_assert_flag9 VARCHAR2,
168 x_acc_assert_flag10 VARCHAR2,
169 x_acc_assert_flag11 VARCHAR2,
170 x_acc_assert_flag12 VARCHAR2,
171 x_acc_assert_flag13 VARCHAR2,
172 x_acc_assert_flag14 VARCHAR2,
173 x_acc_assert_flag15 VARCHAR2,
174 x_acc_assert_flag16 VARCHAR2,
175 x_acc_assert_flag17 VARCHAR2,
176 x_acc_assert_flag18 VARCHAR2,
177 x_acc_assert_flag19 VARCHAR2,
178 x_acc_assert_flag20 VARCHAR2,
179 x_acc_assert_flag21 VARCHAR2,
180 x_acc_assert_flag22 VARCHAR2,
181 x_acc_assert_flag23 VARCHAR2,
182 x_acc_assert_flag24 VARCHAR2,
183 x_acc_assert_flag25 VARCHAR2,
184 x_acc_assert_flag26 VARCHAR2,
185 x_acc_assert_flag27 VARCHAR2,
186 x_acc_assert_flag28 VARCHAR2,
187 x_acc_assert_flag29 VARCHAR2,
188 x_acc_assert_flag30 VARCHAR2,
189 x_eval_ctrl_attr_1 NUMBER,
190 x_eval_ctrl_attr_2 NUMBER,
191 x_eval_ctrl_attr_3 NUMBER,
192 x_eval_ctrl_attr_4 NUMBER,
193 x_eval_ctrl_attr_5 NUMBER,
194 x_eval_ctrl_attr_6 NUMBER,
195 x_eval_ctrl_attr_7 NUMBER,
196 x_eval_ctrl_attr_8 NUMBER,
197 x_eval_ctrl_attr_9 NUMBER,
198 x_eval_ctrl_attr_10 NUMBER,
199 x_eval_ctrl_attr_11 NUMBER,
200 x_eval_ctrl_attr_12 NUMBER,
201 x_eval_ctrl_attr_13 NUMBER,
202 x_eval_ctrl_attr_14 NUMBER,
203 x_eval_ctrl_attr_15 NUMBER,
204 x_eval_ctrl_attr_16 NUMBER,
205 x_eval_ctrl_attr_17 NUMBER,
206 x_eval_ctrl_attr_18 NUMBER,
207 x_eval_ctrl_attr_19 NUMBER,
208 x_eval_ctrl_attr_20 NUMBER,
209 x_eval_ctrl_attr_21 NUMBER,
210 x_eval_ctrl_attr_22 NUMBER,
211 x_eval_ctrl_attr_23 NUMBER,
212 x_eval_ctrl_attr_24 NUMBER,
213 x_eval_ctrl_attr_25 NUMBER,
214 x_eval_ctrl_attr_26 NUMBER,
215 x_eval_ctrl_attr_27 NUMBER,
216 x_eval_ctrl_attr_28 NUMBER,
217 x_eval_ctrl_attr_29 NUMBER,
218 x_eval_ctrl_attr_30 NUMBER,
219 x_display_flag VARCHAR2
220 ) ;
221
222 -- ************ ----------------------------------------------
223
224
225 procedure UPDATE_FIN_ITEM_ROW(
226 x_fin_certification_id NUMBER ,
227 x_financial_statement_id NUMBER ,
228 x_financial_item_id NUMBER ,
229 x_account_group_id NUMBER,
230 x_natural_account_id NUMBER,
231 x_object_type VARCHAR2,
232 x_ctrl_attribute_type VARCHAR2,
233 x_ineff_ctrl_attr_1 NUMBER,
234 x_ineff_ctrl_attr_2 NUMBER,
235 x_ineff_ctrl_attr_3 NUMBER,
236 x_ineff_ctrl_attr_4 NUMBER,
237 x_ineff_ctrl_attr_5 NUMBER,
238 x_ineff_ctrl_attr_6 NUMBER,
239 x_ineff_ctrl_attr_7 NUMBER,
240 x_ineff_ctrl_attr_8 NUMBER,
241 x_ineff_ctrl_attr_9 NUMBER,
242 x_ineff_ctrl_attr_10 NUMBER,
243 x_ineff_ctrl_attr_11 NUMBER,
244 x_ineff_ctrl_attr_12 NUMBER,
245 x_ineff_ctrl_attr_13 NUMBER,
246 x_ineff_ctrl_attr_14 NUMBER,
247 x_ineff_ctrl_attr_15 NUMBER,
248 x_ineff_ctrl_attr_16 NUMBER,
249 x_ineff_ctrl_attr_17 NUMBER,
250 x_ineff_ctrl_attr_18 NUMBER,
251 x_ineff_ctrl_attr_19 NUMBER,
252 x_ineff_ctrl_attr_20 NUMBER,
253 x_ineff_ctrl_attr_21 NUMBER,
254 x_ineff_ctrl_attr_22 NUMBER,
255 x_ineff_ctrl_attr_23 NUMBER,
256 x_ineff_ctrl_attr_24 NUMBER,
257 x_ineff_ctrl_attr_25 NUMBER,
258 x_ineff_ctrl_attr_26 NUMBER,
259 x_ineff_ctrl_attr_27 NUMBER,
260 x_ineff_ctrl_attr_28 NUMBER,
261 x_ineff_ctrl_attr_29 NUMBER,
262 x_ineff_ctrl_attr_30 NUMBER,
263 x_last_updated_by NUMBER,
264 x_last_update_date DATE ,
265 x_last_update_login NUMBER,
266 x_eval_ctrl_attr_1 NUMBER,
267 x_eval_ctrl_attr_2 NUMBER,
268 x_eval_ctrl_attr_3 NUMBER,
269 x_eval_ctrl_attr_4 NUMBER,
270 x_eval_ctrl_attr_5 NUMBER,
271 x_eval_ctrl_attr_6 NUMBER,
272 x_eval_ctrl_attr_7 NUMBER,
273 x_eval_ctrl_attr_8 NUMBER,
274 x_eval_ctrl_attr_9 NUMBER,
275 x_eval_ctrl_attr_10 NUMBER,
276 x_eval_ctrl_attr_11 NUMBER,
277 x_eval_ctrl_attr_12 NUMBER,
278 x_eval_ctrl_attr_13 NUMBER,
279 x_eval_ctrl_attr_14 NUMBER,
280 x_eval_ctrl_attr_15 NUMBER,
281 x_eval_ctrl_attr_16 NUMBER,
282 x_eval_ctrl_attr_17 NUMBER,
283 x_eval_ctrl_attr_18 NUMBER,
284 x_eval_ctrl_attr_19 NUMBER,
285 x_eval_ctrl_attr_20 NUMBER,
286 x_eval_ctrl_attr_21 NUMBER,
287 x_eval_ctrl_attr_22 NUMBER,
288 x_eval_ctrl_attr_23 NUMBER,
289 x_eval_ctrl_attr_24 NUMBER,
290 x_eval_ctrl_attr_25 NUMBER,
291 x_eval_ctrl_attr_26 NUMBER,
292 x_eval_ctrl_attr_27 NUMBER,
293 x_eval_ctrl_attr_28 NUMBER,
294 x_eval_ctrl_attr_29 NUMBER,
295 x_eval_ctrl_attr_30 NUMBER
296 ) ;
297
298
299 procedure UPDATE_FIN_ACC_ROW (
300 x_fin_certification_id NUMBER ,
301 x_financial_statement_id NUMBER ,
302 x_financial_item_id NUMBER ,
303 x_account_group_id NUMBER,
304 x_natural_account_id NUMBER,
305 x_object_type VARCHAR2,
306 x_ctrl_attribute_type VARCHAR2,
307 x_ineff_ctrl_attr_1 NUMBER,
308 x_ineff_ctrl_attr_2 NUMBER,
309 x_ineff_ctrl_attr_3 NUMBER,
310 x_ineff_ctrl_attr_4 NUMBER,
311 x_ineff_ctrl_attr_5 NUMBER,
312 x_ineff_ctrl_attr_6 NUMBER,
313 x_ineff_ctrl_attr_7 NUMBER,
314 x_ineff_ctrl_attr_8 NUMBER,
315 x_ineff_ctrl_attr_9 NUMBER,
316 x_ineff_ctrl_attr_10 NUMBER,
317 x_ineff_ctrl_attr_11 NUMBER,
318 x_ineff_ctrl_attr_12 NUMBER,
319 x_ineff_ctrl_attr_13 NUMBER,
320 x_ineff_ctrl_attr_14 NUMBER,
321 x_ineff_ctrl_attr_15 NUMBER,
322 x_ineff_ctrl_attr_16 NUMBER,
323 x_ineff_ctrl_attr_17 NUMBER,
324 x_ineff_ctrl_attr_18 NUMBER,
325 x_ineff_ctrl_attr_19 NUMBER,
326 x_ineff_ctrl_attr_20 NUMBER,
327 x_ineff_ctrl_attr_21 NUMBER,
328 x_ineff_ctrl_attr_22 NUMBER,
329 x_ineff_ctrl_attr_23 NUMBER,
330 x_ineff_ctrl_attr_24 NUMBER,
331 x_ineff_ctrl_attr_25 NUMBER,
332 x_ineff_ctrl_attr_26 NUMBER,
333 x_ineff_ctrl_attr_27 NUMBER,
334 x_ineff_ctrl_attr_28 NUMBER,
335 x_ineff_ctrl_attr_29 NUMBER,
336 x_ineff_ctrl_attr_30 NUMBER,
337 x_last_updated_by NUMBER,
338 x_last_update_date DATE ,
339 x_last_update_login NUMBER,
340 x_eval_ctrl_attr_1 NUMBER,
341 x_eval_ctrl_attr_2 NUMBER,
342 x_eval_ctrl_attr_3 NUMBER,
343 x_eval_ctrl_attr_4 NUMBER,
344 x_eval_ctrl_attr_5 NUMBER,
345 x_eval_ctrl_attr_6 NUMBER,
346 x_eval_ctrl_attr_7 NUMBER,
347 x_eval_ctrl_attr_8 NUMBER,
348 x_eval_ctrl_attr_9 NUMBER,
349 x_eval_ctrl_attr_10 NUMBER,
350 x_eval_ctrl_attr_11 NUMBER,
351 x_eval_ctrl_attr_12 NUMBER,
352 x_eval_ctrl_attr_13 NUMBER,
353 x_eval_ctrl_attr_14 NUMBER,
354 x_eval_ctrl_attr_15 NUMBER,
355 x_eval_ctrl_attr_16 NUMBER,
356 x_eval_ctrl_attr_17 NUMBER,
357 x_eval_ctrl_attr_18 NUMBER,
358 x_eval_ctrl_attr_19 NUMBER,
359 x_eval_ctrl_attr_20 NUMBER,
360 x_eval_ctrl_attr_21 NUMBER,
361 x_eval_ctrl_attr_22 NUMBER,
362 x_eval_ctrl_attr_23 NUMBER,
363 x_eval_ctrl_attr_24 NUMBER,
364 x_eval_ctrl_attr_25 NUMBER,
365 x_eval_ctrl_attr_26 NUMBER,
366 x_eval_ctrl_attr_27 NUMBER,
367 x_eval_ctrl_attr_28 NUMBER,
368 x_eval_ctrl_attr_29 NUMBER,
369 x_eval_ctrl_attr_30 NUMBER
370 ) ;
371
372 PROCEDURE Update_item_ctrl_components
373 (P_CERTIFICATION_ID number ,
374 P_FINANCIAL_STATEMENT_ID number,
375 P_STATEMENT_GROUP_ID number,
376 P_FINANCIAL_ITEM_ID number,
377 P_CONTROL_ID number ,
378 P_ORG_ID number ,
379 P_CHANGE_FLAG VARCHAR2,
380 P_NEW_FLAG VARCHAR2) ;
381
382 PROCEDURE Update_acc_ctrl_components
383 (P_CERTIFICATION_ID number ,
384 P_ACCOUNT_GROUP_ID number ,
385 P_ACCOUNT_ID number ,
386 P_CONTROL_ID number ,
387 P_ORG_ID number ,
388 P_CHANGE_FLAG VARCHAR2,
389 P_NEW_FLAG VARCHAR2) ;
390
391
392
393 PROCEDURE Update_acc_ctrl_Assertions
394 (P_CERTIFICATION_ID number ,
395 P_ACCOUNT_GROUP_ID number ,
396 P_ACCOUNT_ID number ,
397 P_CONTROL_ID number ,
398 P_ORG_ID number ,
399 P_CHANGE_FLAG VARCHAR2,
400 P_NEW_FLAG VARCHAR2) ;
401
402 PROCEDURE Update_item_ctrl_Assertions
403 (P_CERTIFICATION_ID number ,
404 P_FINANCIAL_STATEMENT_ID number,
405 P_STATEMENT_GROUP_ID number,
406 P_FINANCIAL_ITEM_ID number,
407 P_CONTROL_ID number ,
408 P_ORG_ID number ,
409 P_CHANGE_FLAG VARCHAR2,
410 P_NEW_FLAG VARCHAR2) ;
411
412 PROCEDURE Update_acc_ctrl_objectives
413 (P_CERTIFICATION_ID number ,
414 P_ACCOUNT_GROUP_ID number ,
415 P_ACCOUNT_ID number ,
416 P_CONTROL_ID number ,
417 P_ORG_ID number ,
418 P_CHANGE_FLAG VARCHAR2,
419 P_NEW_FLAG VARCHAR2);
420
421 PROCEDURE Update_item_ctrl_objectives
422 (P_CERTIFICATION_ID number ,
423 P_FINANCIAL_STATEMENT_ID number,
424 P_STATEMENT_GROUP_ID number,
425 P_FINANCIAL_ITEM_ID number,
426 P_CONTROL_ID number ,
427 P_ORG_ID number ,
428 P_CHANGE_FLAG VARCHAR2,
429 P_NEW_FLAG VARCHAR2) ;
430
431 procedure UPDATE_CTRLSUM_FLAG(
432 x_fin_certification_id NUMBER ,
433 x_natural_account_id NUMBER,
434 x_ctrl_attribute_type varchar2,
435 x_created_by number ,
436 x_creation_date date ,
437 x_last_updated_by number ,
438 x_last_update_date date,
439 x_last_update_login number ,
440 x_acc_assert_flag1 VARCHAR2,
441 x_acc_assert_flag2 VARCHAR2,
442 x_acc_assert_flag3 VARCHAR2,
443 x_acc_assert_flag4 VARCHAR2,
444 x_acc_assert_flag5 VARCHAR2,
445 x_acc_assert_flag6 VARCHAR2,
446 x_acc_assert_flag7 VARCHAR2,
447 x_acc_assert_flag8 VARCHAR2,
448 x_acc_assert_flag9 VARCHAR2,
449 x_acc_assert_flag10 VARCHAR2,
450 x_acc_assert_flag11 VARCHAR2,
451 x_acc_assert_flag12 VARCHAR2,
452 x_acc_assert_flag13 VARCHAR2,
453 x_acc_assert_flag14 VARCHAR2,
454 x_acc_assert_flag15 VARCHAR2,
455 x_acc_assert_flag16 VARCHAR2,
456 x_acc_assert_flag17 VARCHAR2,
457 x_acc_assert_flag18 VARCHAR2,
458 x_acc_assert_flag19 VARCHAR2,
459 x_acc_assert_flag20 VARCHAR2,
460 x_acc_assert_flag21 VARCHAR2,
461 x_acc_assert_flag22 VARCHAR2,
462 x_acc_assert_flag23 VARCHAR2,
463 x_acc_assert_flag24 VARCHAR2,
464 x_acc_assert_flag25 VARCHAR2,
465 x_acc_assert_flag26 VARCHAR2,
466 x_acc_assert_flag27 VARCHAR2,
467 x_acc_assert_flag28 VARCHAR2,
468 x_acc_assert_flag29 VARCHAR2,
469 x_acc_assert_flag30 VARCHAR2,
470 x_display_flag VARCHAR2
471 ) ;
472
473 PROCEDURE update_acc_assert_flags
474 ( P_ACCOUNT_ID number ) ;
475
476 function set_display_flag(control_exists_array total_control_array) return boolean ;
477
478 FUNCTION take_new_acc_assertions
479 ( p_subscription_guid in raw,
480 p_event in out NOCOPY wf_event_t)
481 return varchar2;
482
483 function set_flag_for_assertions( assert_acc_reln_exist component_code_array)
484 return boolean ;
485
486 procedure UPDATE_CTRLSUM_ITEM_FLAG(
487
488 x_fin_certification_id NUMBER ,
489 x_financial_item_id NUMBER ,
490 x_ctrl_attribute_type varchar2,
491 x_created_by number ,
492 x_creation_date date ,
493 x_last_updated_by number ,
494 x_last_update_date date,
495 x_last_update_login number ,
496 x_acc_assert_flag1 VARCHAR2,
497 x_acc_assert_flag2 VARCHAR2,
498 x_acc_assert_flag3 VARCHAR2,
499 x_acc_assert_flag4 VARCHAR2,
500 x_acc_assert_flag5 VARCHAR2,
501 x_acc_assert_flag6 VARCHAR2,
502 x_acc_assert_flag7 VARCHAR2,
503 x_acc_assert_flag8 VARCHAR2,
504 x_acc_assert_flag9 VARCHAR2,
505 x_acc_assert_flag10 VARCHAR2,
506 x_acc_assert_flag11 VARCHAR2,
507 x_acc_assert_flag12 VARCHAR2,
508 x_acc_assert_flag13 VARCHAR2,
509 x_acc_assert_flag14 VARCHAR2,
510 x_acc_assert_flag15 VARCHAR2,
511 x_acc_assert_flag16 VARCHAR2,
512 x_acc_assert_flag17 VARCHAR2,
513 x_acc_assert_flag18 VARCHAR2,
514 x_acc_assert_flag19 VARCHAR2,
515 x_acc_assert_flag20 VARCHAR2,
516 x_acc_assert_flag21 VARCHAR2,
517 x_acc_assert_flag22 VARCHAR2,
518 x_acc_assert_flag23 VARCHAR2,
519 x_acc_assert_flag24 VARCHAR2,
520 x_acc_assert_flag25 VARCHAR2,
521 x_acc_assert_flag26 VARCHAR2,
522 x_acc_assert_flag27 VARCHAR2,
523 x_acc_assert_flag28 VARCHAR2,
524 x_acc_assert_flag29 VARCHAR2,
525 x_acc_assert_flag30 VARCHAR2,
526 x_display_flag VARCHAR2
527 ) ;
528
529 procedure UPDATE_FIN_ACC_ASSERT_ROW (
530 x_fin_certification_id NUMBER ,
531 x_financial_statement_id NUMBER ,
532 x_financial_item_id NUMBER ,
533 x_account_group_id NUMBER,
534 x_natural_account_id NUMBER,
535 x_object_type VARCHAR2,
536 x_ctrl_attribute_type VARCHAR2,
537 x_ineff_ctrl_attr_1 NUMBER,
538 x_ineff_ctrl_attr_2 NUMBER,
539 x_ineff_ctrl_attr_3 NUMBER,
540 x_ineff_ctrl_attr_4 NUMBER,
541 x_ineff_ctrl_attr_5 NUMBER,
542 x_ineff_ctrl_attr_6 NUMBER,
543 x_ineff_ctrl_attr_7 NUMBER,
544 x_ineff_ctrl_attr_8 NUMBER,
545 x_ineff_ctrl_attr_9 NUMBER,
546 x_ineff_ctrl_attr_10 NUMBER,
547 x_ineff_ctrl_attr_11 NUMBER,
548 x_ineff_ctrl_attr_12 NUMBER,
549 x_ineff_ctrl_attr_13 NUMBER,
550 x_ineff_ctrl_attr_14 NUMBER,
551 x_ineff_ctrl_attr_15 NUMBER,
552 x_ineff_ctrl_attr_16 NUMBER,
553 x_ineff_ctrl_attr_17 NUMBER,
554 x_ineff_ctrl_attr_18 NUMBER,
555 x_ineff_ctrl_attr_19 NUMBER,
556 x_ineff_ctrl_attr_20 NUMBER,
557 x_ineff_ctrl_attr_21 NUMBER,
558 x_ineff_ctrl_attr_22 NUMBER,
559 x_ineff_ctrl_attr_23 NUMBER,
560 x_ineff_ctrl_attr_24 NUMBER,
561 x_ineff_ctrl_attr_25 NUMBER,
562 x_ineff_ctrl_attr_26 NUMBER,
563 x_ineff_ctrl_attr_27 NUMBER,
564 x_ineff_ctrl_attr_28 NUMBER,
565 x_ineff_ctrl_attr_29 NUMBER,
566 x_ineff_ctrl_attr_30 NUMBER,
567 x_last_updated_by NUMBER,
568 x_last_update_date DATE ,
569 x_last_update_login NUMBER,
570 x_eval_ctrl_attr_1 NUMBER,
571 x_eval_ctrl_attr_2 NUMBER,
572 x_eval_ctrl_attr_3 NUMBER,
573 x_eval_ctrl_attr_4 NUMBER,
574 x_eval_ctrl_attr_5 NUMBER,
575 x_eval_ctrl_attr_6 NUMBER,
576 x_eval_ctrl_attr_7 NUMBER,
577 x_eval_ctrl_attr_8 NUMBER,
578 x_eval_ctrl_attr_9 NUMBER,
579 x_eval_ctrl_attr_10 NUMBER,
580 x_eval_ctrl_attr_11 NUMBER,
581 x_eval_ctrl_attr_12 NUMBER,
582 x_eval_ctrl_attr_13 NUMBER,
583 x_eval_ctrl_attr_14 NUMBER,
584 x_eval_ctrl_attr_15 NUMBER,
585 x_eval_ctrl_attr_16 NUMBER,
586 x_eval_ctrl_attr_17 NUMBER,
587 x_eval_ctrl_attr_18 NUMBER,
588 x_eval_ctrl_attr_19 NUMBER,
589 x_eval_ctrl_attr_20 NUMBER,
590 x_eval_ctrl_attr_21 NUMBER,
591 x_eval_ctrl_attr_22 NUMBER,
592 x_eval_ctrl_attr_23 NUMBER,
593 x_eval_ctrl_attr_24 NUMBER,
594 x_eval_ctrl_attr_25 NUMBER,
595 x_eval_ctrl_attr_26 NUMBER,
596 x_eval_ctrl_attr_27 NUMBER,
597 x_eval_ctrl_attr_28 NUMBER,
598 x_eval_ctrl_attr_29 NUMBER,
599 x_eval_ctrl_attr_30 NUMBER,
600 x_acc_assert_flag1 VARCHAR2,
601 x_acc_assert_flag2 VARCHAR2,
602 x_acc_assert_flag3 VARCHAR2,
603 x_acc_assert_flag4 VARCHAR2,
604 x_acc_assert_flag5 VARCHAR2,
605 x_acc_assert_flag6 VARCHAR2,
606 x_acc_assert_flag7 VARCHAR2,
607 x_acc_assert_flag8 VARCHAR2,
608 x_acc_assert_flag9 VARCHAR2,
609 x_acc_assert_flag10 VARCHAR2,
610 x_acc_assert_flag11 VARCHAR2,
611 x_acc_assert_flag12 VARCHAR2,
612 x_acc_assert_flag13 VARCHAR2,
613 x_acc_assert_flag14 VARCHAR2,
614 x_acc_assert_flag15 VARCHAR2,
615 x_acc_assert_flag16 VARCHAR2,
616 x_acc_assert_flag17 VARCHAR2,
617 x_acc_assert_flag18 VARCHAR2,
618 x_acc_assert_flag19 VARCHAR2,
619 x_acc_assert_flag20 VARCHAR2,
620 x_acc_assert_flag21 VARCHAR2,
621 x_acc_assert_flag22 VARCHAR2,
625 x_acc_assert_flag26 VARCHAR2,
622 x_acc_assert_flag23 VARCHAR2,
623 x_acc_assert_flag24 VARCHAR2,
624 x_acc_assert_flag25 VARCHAR2,
626 x_acc_assert_flag27 VARCHAR2,
627 x_acc_assert_flag28 VARCHAR2,
628 x_acc_assert_flag29 VARCHAR2,
629 x_acc_assert_flag30 VARCHAR2
630 ) ;
631
632
633
634 procedure UPDATE_FINITEM_ASSERT_ROW (
635 x_fin_certification_id NUMBER ,
636 x_financial_statement_id NUMBER ,
637 x_financial_item_id NUMBER ,
638 x_account_group_id NUMBER,
639 x_natural_account_id NUMBER,
640 x_object_type VARCHAR2,
641 x_ctrl_attribute_type VARCHAR2,
642 x_ineff_ctrl_attr_1 NUMBER,
643 x_ineff_ctrl_attr_2 NUMBER,
644 x_ineff_ctrl_attr_3 NUMBER,
645 x_ineff_ctrl_attr_4 NUMBER,
646 x_ineff_ctrl_attr_5 NUMBER,
647 x_ineff_ctrl_attr_6 NUMBER,
648 x_ineff_ctrl_attr_7 NUMBER,
649 x_ineff_ctrl_attr_8 NUMBER,
650 x_ineff_ctrl_attr_9 NUMBER,
651 x_ineff_ctrl_attr_10 NUMBER,
652 x_ineff_ctrl_attr_11 NUMBER,
653 x_ineff_ctrl_attr_12 NUMBER,
654 x_ineff_ctrl_attr_13 NUMBER,
655 x_ineff_ctrl_attr_14 NUMBER,
656 x_ineff_ctrl_attr_15 NUMBER,
657 x_ineff_ctrl_attr_16 NUMBER,
658 x_ineff_ctrl_attr_17 NUMBER,
659 x_ineff_ctrl_attr_18 NUMBER,
660 x_ineff_ctrl_attr_19 NUMBER,
661 x_ineff_ctrl_attr_20 NUMBER,
662 x_ineff_ctrl_attr_21 NUMBER,
663 x_ineff_ctrl_attr_22 NUMBER,
664 x_ineff_ctrl_attr_23 NUMBER,
665 x_ineff_ctrl_attr_24 NUMBER,
666 x_ineff_ctrl_attr_25 NUMBER,
667 x_ineff_ctrl_attr_26 NUMBER,
668 x_ineff_ctrl_attr_27 NUMBER,
669 x_ineff_ctrl_attr_28 NUMBER,
670 x_ineff_ctrl_attr_29 NUMBER,
671 x_ineff_ctrl_attr_30 NUMBER,
672 x_last_updated_by NUMBER,
673 x_last_update_date DATE ,
674 x_last_update_login NUMBER,
675 x_eval_ctrl_attr_1 NUMBER,
676 x_eval_ctrl_attr_2 NUMBER,
677 x_eval_ctrl_attr_3 NUMBER,
678 x_eval_ctrl_attr_4 NUMBER,
679 x_eval_ctrl_attr_5 NUMBER,
680 x_eval_ctrl_attr_6 NUMBER,
681 x_eval_ctrl_attr_7 NUMBER,
682 x_eval_ctrl_attr_8 NUMBER,
683 x_eval_ctrl_attr_9 NUMBER,
684 x_eval_ctrl_attr_10 NUMBER,
685 x_eval_ctrl_attr_11 NUMBER,
686 x_eval_ctrl_attr_12 NUMBER,
687 x_eval_ctrl_attr_13 NUMBER,
688 x_eval_ctrl_attr_14 NUMBER,
689 x_eval_ctrl_attr_15 NUMBER,
690 x_eval_ctrl_attr_16 NUMBER,
691 x_eval_ctrl_attr_17 NUMBER,
692 x_eval_ctrl_attr_18 NUMBER,
693 x_eval_ctrl_attr_19 NUMBER,
694 x_eval_ctrl_attr_20 NUMBER,
695 x_eval_ctrl_attr_21 NUMBER,
696 x_eval_ctrl_attr_22 NUMBER,
697 x_eval_ctrl_attr_23 NUMBER,
698 x_eval_ctrl_attr_24 NUMBER,
699 x_eval_ctrl_attr_25 NUMBER,
700 x_eval_ctrl_attr_26 NUMBER,
701 x_eval_ctrl_attr_27 NUMBER,
702 x_eval_ctrl_attr_28 NUMBER,
703 x_eval_ctrl_attr_29 NUMBER,
704 x_eval_ctrl_attr_30 NUMBER,
705 x_acc_assert_flag1 VARCHAR2,
706 x_acc_assert_flag2 VARCHAR2,
707 x_acc_assert_flag3 VARCHAR2,
708 x_acc_assert_flag4 VARCHAR2,
709 x_acc_assert_flag5 VARCHAR2,
710 x_acc_assert_flag6 VARCHAR2,
711 x_acc_assert_flag7 VARCHAR2,
712 x_acc_assert_flag8 VARCHAR2,
713 x_acc_assert_flag9 VARCHAR2,
714 x_acc_assert_flag10 VARCHAR2,
715 x_acc_assert_flag11 VARCHAR2,
716 x_acc_assert_flag12 VARCHAR2,
717 x_acc_assert_flag13 VARCHAR2,
718 x_acc_assert_flag14 VARCHAR2,
719 x_acc_assert_flag15 VARCHAR2,
720 x_acc_assert_flag16 VARCHAR2,
721 x_acc_assert_flag17 VARCHAR2,
722 x_acc_assert_flag18 VARCHAR2,
723 x_acc_assert_flag19 VARCHAR2,
724 x_acc_assert_flag20 VARCHAR2,
725 x_acc_assert_flag21 VARCHAR2,
726 x_acc_assert_flag22 VARCHAR2,
727 x_acc_assert_flag23 VARCHAR2,
728 x_acc_assert_flag24 VARCHAR2,
729 x_acc_assert_flag25 VARCHAR2,
730 x_acc_assert_flag26 VARCHAR2,
731 x_acc_assert_flag27 VARCHAR2,
732 x_acc_assert_flag28 VARCHAR2,
733 x_acc_assert_flag29 VARCHAR2,
734 x_acc_assert_flag30 VARCHAR2
735 );
736
737 PROCEDURE update_item_assert_flags
738 ( P_NATRL_ACCOUNT_ID number ) ;
739
740 PROCEDURE update_parentacc_assert_flags
741 ( P_ACCOUNT_ID number,
742 P_CERTFICATION_ID number,
743 P_ACCOUNT_GROUP_ID number) ;
744
745 END amw_fin_coso_views_pvt;