1 PACKAGE ZPB_TRANSFORM_IO_TABLES AUTHID CURRENT_USER AS
2 /* $Header: zpblevels.pls 115.10 2004/05/13 18:28:03 memayer ship $ */
3 TYPE DimRecTyp IS RECORD (
4 dimension zpb_solve_input_levels.dimension%TYPE,
5 io_level VARCHAR2(2000),
6 loaded zpb_solve_member_defs.SOURCE_TYPE%TYPE);
7 TYPE DimTabTyp IS TABLE OF DimRecTyp
8 INDEX BY BINARY_INTEGER;
9 TYPE ref_cursor IS REF CURSOR;
10 TYPE curr_dims_table IS TABLE OF zpb_solve_output_levels.DIMENSION%TYPE;
11 dimname CONSTANT CHAR(10) := 'Dim';
12 INPUT_TYPE CONSTANT VARCHAR2(10) := 'INPUT';
13 OUTPUT_TYPE CONSTANT VARCHAR2(10) := 'OUTPUT';
14
15 PROCEDURE ZPB_TRANSFORM_INPUT_TABLE (p_ac_id IN NUMBER,
16 p_line_dim IN VARCHAR2,
17 p_temp_table IN VARCHAR2,
18 p_userid IN NUMBER,
19 p_view_dim_name IN VARCHAR2,
20 p_view_member_column IN VARCHAR2,
21 p_view_long_lbl_column IN VARCHAR2,
22 labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,
23 dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor);
24
25 PROCEDURE ZPB_TRANSFORM_OUTPUT_TABLE (p_ac_id IN NUMBER,
26 p_line_dim IN VARCHAR2,
27 p_temp_table IN VARCHAR2,
28 p_userid IN NUMBER,
29 p_view_dim_name IN VARCHAR2,
30 p_view_member_column IN VARCHAR2,
31 p_view_long_lbl_column IN VARCHAR2,
32 labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,
33 dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor);
34
35 END ZPB_TRANSFORM_IO_TABLES;
36