[Home] [Help]
PACKAGE: APPS.AK_OBJECT_PUB
Source
1 package AK_OBJECT_PUB AUTHID CURRENT_USER as
2 /* $Header: akdpobjs.pls 115.7 2002/09/27 17:58:03 tshort ship $ */
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_OBJECTS_PUB';
8
9 -- Type definitions
10
11 -- Attribute Navigation Record
12
13 TYPE Attribute_Nav_Rec_Type IS RECORD (
14 database_object_name VARCHAR2(30) := NULL,
15 attribute_appl_id NUMBER := NULL,
16 attribute_code VARCHAR2(30) := NULL,
17 value_varchar2 VARCHAR2(240) := NULL,
18 value_date DATE := NULL,
19 value_number NUMBER := NULL,
20 to_region_appl_id NUMBER := NULL,
21 to_region_code VARCHAR2(30) := NULL,
22 attribute_category VARCHAR2(30) := NULL,
23 attribute1 VARCHAR2(150) := NULL,
24 attribute2 VARCHAR2(150) := NULL,
25 attribute3 VARCHAR2(150) := NULL,
26 attribute4 VARCHAR2(150) := NULL,
27 attribute5 VARCHAR2(150) := NULL,
28 attribute6 VARCHAR2(150) := NULL,
29 attribute7 VARCHAR2(150) := NULL,
30 attribute8 VARCHAR2(150) := NULL,
31 attribute9 VARCHAR2(150) := NULL,
32 attribute10 VARCHAR2(150) := NULL,
33 attribute11 VARCHAR2(150) := NULL,
34 attribute12 VARCHAR2(150) := NULL,
35 attribute13 VARCHAR2(150) := NULL,
36 attribute14 VARCHAR2(150) := NULL,
37 attribute15 VARCHAR2(150) := NULL,
38 created_by NUMBER := NULL,
39 creation_date DATE := NULL,
40 last_updated_by NUMBER := NULL,
41 last_update_date DATE := NULL,
42 last_update_login NUMBER := NULL
43 );
44
45 -- Attribute Value Record
46
47 TYPE Attribute_Value_Rec_Type IS RECORD (
48 database_object_name VARCHAR2(30) := NULL,
49 attribute_appl_id NUMBER := NULL,
50 attribute_code VARCHAR2(30) := NULL,
51 key_value1 VARCHAR2(100) := NULL,
52 key_value2 VARCHAR2(100) := NULL,
53 key_value3 VARCHAR2(100) := NULL,
54 key_value4 VARCHAR2(100) := NULL,
55 key_value5 VARCHAR2(100) := NULL,
56 key_value6 VARCHAR2(100) := NULL,
57 key_value7 VARCHAR2(100) := NULL,
58 key_value8 VARCHAR2(100) := NULL,
59 key_value9 VARCHAR2(100) := NULL,
60 key_value10 VARCHAR2(100) := NULL,
61 value_varchar2 VARCHAR2(240) := NULL,
62 value_date DATE := NULL,
63 value_number NUMBER := NULL,
64 created_by NUMBER := NULL,
65 creation_date DATE := NULL,
66 last_updated_by NUMBER := NULL,
67 last_update_date DATE := NULL,
68 last_update_login NUMBER := NULL
69 );
70
71 -- Object Record
72
73 TYPE Object_Rec_Type IS RECORD (
74 database_object_name VARCHAR2(30) := NULL,
75 name VARCHAR2(30) := NULL,
76 description VARCHAR2(2000) := NULL,
77 application_id NUMBER := NULL,
78 primary_key_name VARCHAR2(30) := NULL,
79 defaulting_api_pkg VARCHAR2(30) := NULL,
80 defaulting_api_proc VARCHAR2(30) := NULL,
81 validation_api_pkg VARCHAR2(30) := NULL,
82 validation_api_proc VARCHAR2(30) := NULL,
83 attribute_category VARCHAR2(30) := NULL,
84 attribute1 VARCHAR2(150) := NULL,
85 attribute2 VARCHAR2(150) := NULL,
86 attribute3 VARCHAR2(150) := NULL,
87 attribute4 VARCHAR2(150) := NULL,
88 attribute5 VARCHAR2(150) := NULL,
89 attribute6 VARCHAR2(150) := NULL,
90 attribute7 VARCHAR2(150) := NULL,
91 attribute8 VARCHAR2(150) := NULL,
92 attribute9 VARCHAR2(150) := NULL,
93 attribute10 VARCHAR2(150) := NULL,
94 attribute11 VARCHAR2(150) := NULL,
95 attribute12 VARCHAR2(150) := NULL,
96 attribute13 VARCHAR2(150) := NULL,
97 attribute14 VARCHAR2(150) := NULL,
98 attribute15 VARCHAR2(150) := NULL,
99 created_by NUMBER := NULL,
100 creation_date DATE := NULL,
101 last_updated_by NUMBER := NULL,
102 last_update_date DATE := NULL,
103 last_update_login NUMBER := NULL
104 );
105
106 -- Object Attribute Record
107
108 TYPE Object_Attribute_Rec_Type IS RECORD (
109 database_object_name VARCHAR2(30) := NULL,
110 attribute_appl_id NUMBER := NULL,
111 attribute_code VARCHAR2(30) := NULL,
112 column_name VARCHAR2(30) := NULL,
113 attribute_label_length NUMBER := NULL,
114 display_value_length NUMBER := NULL,
115 bold VARCHAR2(1) := NULL,
116 italic VARCHAR2(1) := NULL,
117 vertical_alignment VARCHAR2(30) := NULL,
118 horizontal_alignment VARCHAR2(30) := NULL,
119 data_source_type VARCHAR2(30) := NULL,
120 data_storage_type VARCHAR2(30) := NULL,
121 table_name VARCHAR2(30) := NULL,
122 base_table_column_name VARCHAR2(30) := NULL,
123 required_flag VARCHAR2(1) := NULL,
124 default_value_varchar2 VARCHAR2(240) := NULL,
125 default_value_number NUMBER := NULL,
126 default_value_date DATE := NULL,
127 lov_region_application_id NUMBER := NULL,
128 lov_region_code VARCHAR2(30) := NULL,
129 lov_foreign_key_name VARCHAR2(30) := NULL,
130 lov_attribute_application_id NUMBER := NULL,
131 lov_attribute_code VARCHAR2(30) := NULL,
132 defaulting_api_pkg VARCHAR2(30) := NULL,
133 defaulting_api_proc VARCHAR2(30) := NULL,
134 validation_api_pkg VARCHAR2(30) := NULL,
135 validation_api_proc VARCHAR2(30) := NULL,
136 attribute_category VARCHAR2(30) := NULL,
137 attribute1 VARCHAR2(150) := NULL,
138 attribute2 VARCHAR2(150) := NULL,
139 attribute3 VARCHAR2(150) := NULL,
140 attribute4 VARCHAR2(150) := NULL,
141 attribute5 VARCHAR2(150) := NULL,
142 attribute6 VARCHAR2(150) := NULL,
143 attribute7 VARCHAR2(150) := NULL,
144 attribute8 VARCHAR2(150) := NULL,
145 attribute9 VARCHAR2(150) := NULL,
146 attribute10 VARCHAR2(150) := NULL,
147 attribute11 VARCHAR2(150) := NULL,
148 attribute12 VARCHAR2(150) := NULL,
149 attribute13 VARCHAR2(150) := NULL,
150 attribute14 VARCHAR2(150) := NULL,
151 attribute15 VARCHAR2(150) := NULL,
152 attribute_label_long VARCHAR2(80) := NULL,
153 attribute_label_short VARCHAR2(40) := NULL,
154 created_by NUMBER := NULL,
155 creation_date DATE := NULL,
156 last_updated_by NUMBER := NULL,
157 last_update_date DATE := NULL,
158 last_update_login NUMBER := NULL
159 );
160
161 -- Data Types
162
163 TYPE Attribute_Nav_Tbl_Type IS TABLE OF Attribute_Nav_Rec_Type
164 INDEX BY BINARY_INTEGER;
165
166 TYPE Attribute_Value_Tbl_Type IS TABLE OF Attribute_Value_Rec_Type
167 INDEX BY BINARY_INTEGER;
168
169 TYPE Object_PK_Tbl_Type IS TABLE OF VARCHAR2(30)
170 INDEX BY BINARY_INTEGER;
171
172 TYPE Object_Attribute_Tbl_Type IS TABLE OF Object_Attribute_Rec_Type
173 INDEX BY BINARY_INTEGER;
174
175 TYPE Object_Tbl_Type IS TABLE OF Object_Rec_Type
176 INDEX BY BINARY_INTEGER;
177
178 /* Constants for missing data types */
179 G_MISS_ATTRIBUTE_NAV_REC Attribute_Nav_Rec_Type;
180 G_MISS_ATTRIBUTE_VALUE_REC Attribute_Value_Rec_Type;
181 G_MISS_OBJECT_ATTRIBUTE_REC Object_Attribute_Rec_Type;
182 G_MISS_OBJECT_REC Object_Rec_Type;
183
184 G_MISS_ATTRIBUTE_NAV_TBL Attribute_Nav_Tbl_Type;
185 G_MISS_ATTRIBUTE_VALUE_TBL Attribute_Value_Tbl_Type;
186 G_MISS_OBJECT_ATTRIBUTE_TBL Object_Attribute_Tbl_Type;
187 G_MISS_OBJECT_PK_TBL Object_PK_Tbl_Type;
188 G_MISS_OBJECT_TBL Object_Tbl_Type;
189
190 end AK_OBJECT_PUB;