DBA Data[Home] [Help]

PACKAGE: APPS.QPR_TRANSFORMATION

Source


1 PACKAGE QPR_TRANSFORMATION AUTHID CURRENT_USER 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 ;