1 PACKAGE PA_PLSQL_DATATYPES as
2 /* $Header: PAICTYPS.pls 120.0.12000000.2 2007/06/27 07:46:04 sugupta ship $ */
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 /* Modified Precision from 2 to 5 for Bug#3625063 */
77 TYPE QtyTabTyp IS TABLE OF NUMBER(22,5)
78 INDEX BY BINARY_INTEGER;
79
80 /* Modified the length from 22 to 30 for Bug#6126964 */
81 TYPE AmtTabTyp IS TABLE OF NUMBER(30,5)
82 INDEX BY BINARY_INTEGER;
83
84 TYPE RowidTabTyp IS TABLE OF ROWID
85 INDEX BY BINARY_INTEGER;
86
87 -- Define empty tab variables
88
89 EmptyNumTab NumTabTyp;
90 EmptyIdTab IdTabTyp;
91 EmptyDateTab DateTabTyp;
92 EmptyChar1Tab Char1TabTyp;
93 EmptyChar2Tab Char2TabTyp;
94 EmptyChar3Tab Char3TabTyp;
95 EmptyChar5Tab Char5TabTyp;
96 EmptyChar10Tab Char10TabTyp;
97 EmptyChar30Tab Char30TabTyp;
98 EmptyChar38Tab Char38TabTyp;
99 EmptyChar15Tab Char15TabTyp;
100 EmptyChar20Tab Char20TabTyp;
101 EmptyChar50Tab Char50TabTyp;
102 EmptyChar60Tab Char60TabTyp;
103 EmptyChar80Tab Char80TabTyp;
104 EmptyChar100Tab Char100TabTyp;
105 EmptyChar150Tab Char150TabTyp;
106 EmptyChar240Tab Char240TabTyp;
107 EmptyChar1000Tab Char1000TabTyp;
108 EmptyChar2000Tab Char2000TabTyp;
109 EmptyRowidTab RowidTabTyp;
110 EmtpyQtyTab QtyTabTyp;
111 EmptyNum15Tab Num15TabTyp;
112 EmtpyNumTab NumTabTyp;
113 EmptyAmtTab AmtTabTyp;
114 EmptyNewAmtTab NewAmtTabTyp;
115
116 END PA_PLSQL_DATATYPES;