1 PACKAGE QPR_TRANSFORMATION AS
2 /* $Header: QPRUTRNS.pls 120.0 2007/10/11 13:07:19 agbennet noship $ */
3
4 TYPE num_type IS TABLE OF Number INDEX BY BINARY_INTEGER;
5 TYPE QPRTRANS IS REF CURSOR;
6
7 TYPE DIM_REC is RECORD
8 (dim_value_id num_type);
9
10 /* Public Procedures */
11 procedure transform_process(
12 errbuf OUT nocopy VARCHAR2,
13 retcode OUT nocopy VARCHAR2,
14 p_transf_group_id IN NUMBER,
15 p_instance_id IN NUMBER,
16 p_from_date in varchar2 default null,
17 p_to_date in varchar2 default null);
18
19 function get_null return varchar2;
20 function get_y return varchar2;
21 function get_n return varchar2;
22 function get_num(p_char varchar2) return number;
23 END QPR_TRANSFORMATION ;