1 PACKAGE PN_PLSQL_DATATYPES AUTHID CURRENT_USER as
2 /* $Header: PNICTYPS.pls 120.1 2010/12/15 12:51:27 rmaringa noship $ */
3
4 TYPE Char1TabTyp IS TABLE OF VARCHAR2(1)
5 INDEX BY BINARY_INTEGER;
6
7 TYPE Char2TabTyp IS TABLE OF VARCHAR2(2)
8 INDEX BY BINARY_INTEGER;
9
10 TYPE Char3TabTyp IS TABLE OF VARCHAR2(3)
11 INDEX BY BINARY_INTEGER;
12
13 TYPE Char5TabTyp IS TABLE OF VARCHAR2(5)
14 INDEX BY BINARY_INTEGER;
15
16 TYPE Char10TabTyp IS TABLE OF VARCHAR2(10)
17 INDEX BY BINARY_INTEGER;
18
19 TYPE Char15TabTyp IS TABLE OF VARCHAR2(15)
20 INDEX BY BINARY_INTEGER;
21
22 TYPE Char20TabTyp IS TABLE OF VARCHAR2(20)
23 INDEX BY BINARY_INTEGER;
24
25 TYPE Char25TabTyp IS TABLE OF VARCHAR2(25)
26 INDEX BY BINARY_INTEGER;
27
28 TYPE Char30TabTyp IS TABLE OF VARCHAR2(30)
29 INDEX BY BINARY_INTEGER;
30
31 TYPE Char38TabTyp IS TABLE OF VARCHAR2(38)
32 INDEX BY BINARY_INTEGER;
33
34 TYPE Char50TabTyp IS TABLE OF VARCHAR2(50)
35 INDEX BY BINARY_INTEGER;
36
37 TYPE Char60TabTyp IS TABLE OF VARCHAR2(60)
38 INDEX BY BINARY_INTEGER;
39
40 TYPE Char80TabTyp IS TABLE OF VARCHAR2(80)
41 INDEX BY BINARY_INTEGER;
42
43 TYPE Char100TabTyp IS TABLE OF VARCHAR2(100)
44 INDEX BY BINARY_INTEGER;
45
46 TYPE Char150TabTyp IS TABLE OF VARCHAR2(150)
47 INDEX BY BINARY_INTEGER;
48
49 TYPE Char240TabTyp IS TABLE OF VARCHAR2(240)
50 INDEX BY BINARY_INTEGER;
51
52 TYPE Char1000TabTyp IS TABLE OF VARCHAR2(1000)
53 INDEX BY BINARY_INTEGER;
54
55 TYPE Char2000TabTyp IS TABLE OF VARCHAR2(2000)
56 INDEX BY BINARY_INTEGER;
57
58 TYPE DateTabTyp IS TABLE OF DATE
59 INDEX BY BINARY_INTEGER;
60
61 TYPE Char250TabTyp IS TABLE OF VARCHAR2(250)
62 INDEX BY BINARY_INTEGER;
63
64 TYPE IdTabTyp IS TABLE OF NUMBER
65 INDEX BY BINARY_INTEGER;
66
67 TYPE NumTabTyp IS TABLE OF NUMBER
68 INDEX BY BINARY_INTEGER;
69
70 TYPE Num15TabTyp IS TABLE OF NUMBER(15)
71 INDEX BY BINARY_INTEGER;
72
73 TYPE NewAmtTabTyp IS TABLE OF NUMBER
74 INDEX BY BINARY_INTEGER;
75
76 TYPE QtyTabTyp IS TABLE OF NUMBER(22,8)
77 INDEX BY BINARY_INTEGER;
78
79 TYPE AmtTabTyp IS TABLE OF NUMBER(30,5)
80 INDEX BY BINARY_INTEGER;
81
82 TYPE RowidTabTyp IS TABLE OF ROWID
83 INDEX BY BINARY_INTEGER;
84
85 -- Define empty tab variables
86
87 EmptyNumTab NumTabTyp;
88 EmptyIdTab IdTabTyp;
89 EmptyDateTab DateTabTyp;
90 EmptyChar1Tab Char1TabTyp;
91 EmptyChar2Tab Char2TabTyp;
92 EmptyChar3Tab Char3TabTyp;
93 EmptyChar5Tab Char5TabTyp;
94 EmptyChar10Tab Char10TabTyp;
95 EmptyChar30Tab Char30TabTyp;
96 EmptyChar38Tab Char38TabTyp;
97 EmptyChar15Tab Char15TabTyp;
98 EmptyChar20Tab Char20TabTyp;
99 EmptyChar50Tab Char50TabTyp;
100 EmptyChar60Tab Char60TabTyp;
101 EmptyChar80Tab Char80TabTyp;
102 EmptyChar100Tab Char100TabTyp;
103 EmptyChar150Tab Char150TabTyp;
104 EmptyChar240Tab Char240TabTyp;
105 EmptyChar1000Tab Char1000TabTyp;
106 EmptyChar2000Tab Char2000TabTyp;
107 EmptyRowidTab RowidTabTyp;
108 EmtpyQtyTab QtyTabTyp;
109 EmptyNum15Tab Num15TabTyp;
110 EmtpyNumTab NumTabTyp;
111 EmptyAmtTab AmtTabTyp;
112 EmptyNewAmtTab NewAmtTabTyp;
113
114 END PN_PLSQL_DATATYPES;