1 PACKAGE BEN_TCS_STMT_VALID_HRCHY
2 /* $Header: bentcshg.pkh 120.1 2006/04/12 04:44 srangasa noship $ */
3 AUTHID CURRENT_USER AS
4 TYPE item_hrchy IS
5 RECORD( item_id NUMBER,
6 stmt_id NUMBER ,
7 subcat_id NUMBER,
8 cntr_cd VARCHAR2(2));
9
10 TYPE item_hrchy_table IS TABLE OF item_hrchy
11 INDEX BY BINARY_INTEGER;
12
13 TYPE cat_item_hrchy_rec IS
14 RECORD( cat_id NUMBER ,
15 item_id NUMBER,
16 stmt_id NUMBER ,
17 lvl_num NUMBER,
18 cntr_cd VARCHAR2(10),
19 perd_id NUMBER,
20 row_cat_id NUMBER,
21 all_objects_id NUMBER);
22
23 TYPE cat_item_hrchy_table IS TABLE OF cat_item_hrchy_rec
24 INDEX BY BINARY_INTEGER;
25
26 TYPE cat_subcat_hrchy_rec IS
27 RECORD( cat_id NUMBER ,
28 subcat_id NUMBER,
29 stmt_id NUMBER ,
30 lvl_num NUMBER,
31 perd_id NUMBER,
32 row_cat_id NUMBER);
33
34 TYPE cat_subcat_hrchy_table IS TABLE OF cat_subcat_hrchy_rec
35 INDEX BY BINARY_INTEGER;
36
37
38 PROCEDURE stmt_gen_valid_process (p_stmt_id IN NUMBER, p_bg_id IN NUMBER , p_period_id IN NUMBER ,
39 p_item_hrchy_values IN OUT NOCOPY cat_item_hrchy_table ,p_subcat_hrchy_values IN OUT NOCOPY cat_subcat_hrchy_table ,
40 p_status OUT NOCOPY Boolean );
41
42 END BEN_TCS_STMT_VALID_HRCHY;
43