PACKAGE: APPS.QPR_LOAD_DIM_DATA

Source

1 PACKAGE QPR_LOAD_DIM_DATA AS
2 /* $Header: QPRUDLDS.pls 120.0 2007/10/11 13:04:48 agbennet noship $ */
3 
4 type char240_type is table of varchar2(240) index by binary_integer;
5 type date_type is table of date index by binary_integer;
6 type QPRDIMDATA is ref cursor;
7 
8 TYPE DIM_DATA_REC_TYPE IS RECORD
9 (
10 	level1_value		char240_type,
11 	level1_desc		char240_type,
12 	level1_attribute1	char240_type,
13 	level1_attribute2	char240_type,
14 	level1_attribute3	char240_type,
15 	level1_attribute4	char240_type,
16 	level1_attribute5	char240_type,
17 	level2_value		char240_type,
18 	level2_desc		char240_type,
19 	level2_attribute1	char240_type,
20 	level2_attribute2	char240_type,
21 	level2_attribute3	char240_type,
22 	level2_attribute4	char240_type,
23 	level2_attribute5	char240_type,
24 	level3_value		char240_type,
25 	level3_desc		char240_type,
26 	level3_attribute1	char240_type,
27 	level3_attribute2	char240_type,
28 	level3_attribute3	char240_type,
29 	level3_attribute4	char240_type,
30 	level3_attribute5	char240_type,
31 	level4_value		char240_type,
32 	level4_desc		char240_type,
33 	level4_attribute1	char240_type,
34 	level4_attribute2	char240_type,
35 	level4_attribute3	char240_type,
36 	level4_attribute4	char240_type,
37 	level4_attribute5	char240_type,
38 	level5_value		char240_type,
39 	level5_desc		char240_type,
40 	level5_attribute1	char240_type,
41 	level5_attribute2	char240_type,
42 	level5_attribute3	char240_type,
43 	level5_attribute4	char240_type,
44 	level5_attribute5	char240_type,
45 	level6_value		char240_type,
46 	level6_desc		char240_type,
47 	level6_attribute1	char240_type,
48 	level6_attribute2	char240_type,
49 	level6_attribute3	char240_type,
50 	level6_attribute4	char240_type,
51 	level6_attribute5	char240_type,
52 	level7_value		char240_type,
53 	level7_desc		char240_type,
54 	level7_attribute1	char240_type,
55 	level7_attribute2	char240_type,
56 	level7_attribute3	char240_type,
57 	level7_attribute4	char240_type,
58 	level7_attribute5	char240_type,
59 	level8_value		char240_type,
60 	level8_desc		char240_type,
61 	level8_attribute1	char240_type,
62 	level8_attribute2	char240_type,
63 	level8_attribute3	char240_type,
64 	level8_attribute4	char240_type,
65 	level8_attribute5	char240_type,
66 	check_date		date_type
67 );
68 
69 
70 
71 procedure load_dim_data(
72                         errbuf OUT NOCOPY VARCHAR2,
73                         retcode OUT NOCOPY VARCHAR2,
74 			p_dim_code in varchar2,
75 			p_hier_code in varchar2,
76 			p_instance_id in number,
77 			p_start_date in varchar2,
78 			p_end_date in varchar2);
79 
80 
81 END QPR_LOAD_DIM_DATA;