DBA Data[Home] [Help]

APPS.ZPB_TRANSFORM_IO_TABLES dependencies on ZPB_TRANSFORM_IO_TABLES

Line 1: PACKAGE BODY ZPB_TRANSFORM_IO_TABLES AS

1: PACKAGE BODY ZPB_TRANSFORM_IO_TABLES AS
2: /* $Header: zpblevels.plb 115.22 2004/07/01 23:46:54 memayer ship $ */
3: PROCEDURE AddRow(p_dimensions curr_dims_table,
4: p_dimtable IN DimTabTyp,
5: p_temp_table IN VARCHAR2,

Line 59: labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,

55: p_userid IN NUMBER,
56: p_view_dim_name IN VARCHAR2,
57: p_view_member_column IN VARCHAR2,
58: p_view_long_lbl_column IN VARCHAR2,
59: labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,
60: dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor)
61:
62: IS
63:

Line 60: dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor)

56: p_view_dim_name IN VARCHAR2,
57: p_view_member_column IN VARCHAR2,
58: p_view_long_lbl_column IN VARCHAR2,
59: labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,
60: dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor)
61:
62: IS
63:
64: Dimtable DimTabTyp;

Line 72: c4 ZPB_TRANSFORM_IO_TABLES.ref_cursor;

68: memberorder zpb_solve_input_levels.MEMBER_ORDER%TYPE;
69: rowcount BINARY_INTEGER;
70: bStart BOOLEAN;
71: tableSelect VARCHAR2(5000);
72: c4 ZPB_TRANSFORM_IO_TABLES.ref_cursor;
73: dimensions curr_dims_table;
74: TYPE level_rec IS RECORD (
75: member zpb_solve_input_levels.member%TYPE,
76: memberorder zpb_solve_input_levels.MEMBER_ORDER%TYPE,

Line 199: labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,

195: p_userid IN NUMBER,
196: p_view_dim_name IN VARCHAR2,
197: p_view_member_column IN VARCHAR2,
198: p_view_long_lbl_column IN VARCHAR2,
199: labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,
200: dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor)
201:
202: IS
203:

Line 200: dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor)

196: p_view_dim_name IN VARCHAR2,
197: p_view_member_column IN VARCHAR2,
198: p_view_long_lbl_column IN VARCHAR2,
199: labelCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor,
200: dataCursor OUT NOCOPY ZPB_TRANSFORM_IO_TABLES.ref_cursor)
201:
202: IS
203:
204: Dimtable DimTabTyp;

Line 212: c4 ZPB_TRANSFORM_IO_TABLES.ref_cursor;

208: memberorder zpb_solve_output_levels.MEMBER_ORDER%TYPE;
209: rowcount BINARY_INTEGER;
210: bStart BOOLEAN;
211: tableSelect VARCHAR2(5000);
212: c4 ZPB_TRANSFORM_IO_TABLES.ref_cursor;
213: dimensions curr_dims_table;
214: TYPE level_rec IS RECORD (
215: member zpb_solve_output_levels.member%TYPE,
216: memberorder zpb_solve_output_levels.MEMBER_ORDER%TYPE,

Line 323: END ZPB_TRANSFORM_IO_TABLES;

319: OPEN dataCursor FOR tableSelect;
320:
321: END ZPB_TRANSFORM_OUTPUT_TABLE;
322:
323: END ZPB_TRANSFORM_IO_TABLES;