[Home] [Help]
PACKAGE: APPS.AK_REGION_PUB
Source
1 package AK_REGION_PUB AUTHID CURRENT_USER as
2 /* $Header: akdpregs.pls 115.32 2003/10/15 20:39:53 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_REGION_PUB';
8
9 -- Type definitions
10
11 -- Region primary key record
12
13 TYPE Region_PK_Rec_Type IS RECORD (
14 region_appl_id NUMBER := FND_API.G_MISS_NUM,
15 region_code VARCHAR2(30) := FND_API.G_MISS_CHAR
16 );
17
18 -- Region Record
19
20 TYPE Region_Rec_Type IS RECORD (
21 region_application_id NUMBER := NULL,
22 region_code VARCHAR2(30) := NULL,
23 database_object_name VARCHAR2(30) := NULL,
24 region_style VARCHAR2(30) := NULL,
25 icx_custom_call VARCHAR2(80) := NULL,
26 num_columns NUMBER := NULL,
27 region_defaulting_api_pkg VARCHAR2(30) := NULL,
28 region_defaulting_api_proc VARCHAR2(30) := NULL,
29 region_validation_api_pkg VARCHAR2(30) := NULL,
30 region_validation_api_proc VARCHAR2(30) := NULL,
31 applicationmodule_object_type VARCHAR2(240) := NULL,
32 num_rows_display NUMBER := NULL,
33 region_object_type VARCHAR2(240) := NULL,
34 image_file_name VARCHAR2(80) := NULL,
35 isform_flag VARCHAR2(1) := NULL,
36 help_target VARCHAR2(240) := NULL,
37 style_sheet_filename VARCHAR2(240) := NULL,
38 version VARCHAR2(30) := NULL,
39 applicationmodule_usage_name VARCHAR2(80) := NULL,
40 add_indexed_children VARCHAR2(1) := NULL,
41 stateful_flag VARCHAR2(1) := NULL,
42 function_name VARCHAR2(30) := NULL,
43 children_view_usage_name VARCHAR2(80) := NULL,
44 search_panel VARCHAR2(1) := NULL,
45 advanced_search_panel VARCHAR2(1) := NULL,
46 customize_panel VARCHAR2(1) := NULL,
47 default_search_panel VARCHAR2(30) := NULL,
48 results_based_search VARCHAR2(1) := NULL,
49 display_graph_table VARCHAR2(1) := NULL,
50 disable_header VARCHAR2(1) := NULL,
51 standalone VARCHAR2(1) := NULL,
52 auto_customization_criteria VARCHAR2(1) := NULL,
53 attribute_category VARCHAR2(30) := NULL,
54 attribute1 VARCHAR2(150) := NULL,
55 attribute2 VARCHAR2(150) := NULL,
56 attribute3 VARCHAR2(150) := NULL,
57 attribute4 VARCHAR2(150) := NULL,
58 attribute5 VARCHAR2(150) := NULL,
59 attribute6 VARCHAR2(150) := NULL,
60 attribute7 VARCHAR2(150) := NULL,
61 attribute8 VARCHAR2(150) := NULL,
62 attribute9 VARCHAR2(150) := NULL,
63 attribute10 VARCHAR2(150) := NULL,
64 attribute11 VARCHAR2(150) := NULL,
65 attribute12 VARCHAR2(150) := NULL,
66 attribute13 VARCHAR2(150) := NULL,
67 attribute14 VARCHAR2(150) := NULL,
68 attribute15 VARCHAR2(150) := NULL,
69 name VARCHAR2(80) := NULL,
70 description VARCHAR2(2000) := NULL,
71 created_by NUMBER := NULL,
72 creation_date DATE := NULL,
73 last_updated_by NUMBER := NULL,
74 last_update_date DATE := NULL,
75 last_update_login NUMBER := NULL
76 );
77
78 /* AK_REGION_GRAPHS has been obsoleted
79 -- Region Graph Record
80
81 TYPE Graph_Rec_Type is RECORD (
82 region_application_id NUMBER :=NULL,
83 region_code VARCHAR2(30) :=NULL,
84 graph_number NUMBER :=NULL,
85 graph_style NUMBER :=NULL,
86 display_flag VARCHAR2(1) :=NULL,
87 depth_radius NUMBER :=NULL,
88 graph_title VARCHAR2(240) :=NULL,
89 y_axis_label VARCHAR2(80) :=NULL,
90 created_by NUMBER := NULL,
91 creation_date DATE := NULL,
92 last_updated_by NUMBER := NULL,
93 last_update_date DATE := NULL,
94 last_update_login NUMBER := NULL
95 );
96 */
97 -- Region Item Record
98
99 TYPE Item_Rec_Type IS RECORD (
100 region_application_id NUMBER := NULL,
101 region_code VARCHAR2(30) := NULL,
102 attribute_application_id NUMBER := NULL,
103 attribute_code VARCHAR2(30) := NULL,
104 display_sequence NUMBER := NULL,
105 node_display_flag VARCHAR2(1) := NULL,
106 node_query_flag VARCHAR2(1) := NULL,
107 attribute_label_length NUMBER := NULL,
108 display_value_length NUMBER := NULL,
109 bold VARCHAR2(1) := NULL,
110 italic VARCHAR2(1) := NULL,
111 vertical_alignment VARCHAR2(30) := NULL,
112 horizontal_alignment VARCHAR2(30) := NULL,
113 item_style VARCHAR2(30) := NULL,
114 object_attribute_flag VARCHAR2(1) := NULL,
115 icx_custom_call VARCHAR2(80) := NULL,
116 update_flag VARCHAR2(1) := NULL,
117 required_flag VARCHAR2(1) := NULL,
118 security_code VARCHAR2(30) := NULL,
119 default_value_varchar2 VARCHAR2(240) := NULL,
120 default_value_number NUMBER := NULL,
121 default_value_date DATE := NULL,
122 lov_region_application_id NUMBER := NULL,
123 lov_region_code VARCHAR2(30) := NULL,
124 lov_foreign_key_name VARCHAR2(30) := NULL,
125 lov_attribute_application_id NUMBER := NULL,
126 lov_attribute_code VARCHAR2(30) := NULL,
127 lov_default_flag VARCHAR2(1) := NULL,
128 region_defaulting_api_pkg VARCHAR2(30) := NULL,
129 region_defaulting_api_proc VARCHAR2(30) := NULL,
130 region_validation_api_pkg VARCHAR2(30) := NULL,
131 region_validation_api_proc VARCHAR2(30) := NULL,
132 order_sequence NUMBER := NULL,
133 order_direction VARCHAR2(30) := NULL,
134 display_height NUMBER := NULL,
135 submit VARCHAR2(1) := NULL,
136 encrypt VARCHAR2(1) := NULL,
137 css_class_name VARCHAR2(80) := NULL,
138 view_usage_name VARCHAR2(80) := NULL,
139 view_attribute_name VARCHAR2(80) := NULL,
140 nested_region_application_id NUMBER := NULL,
141 nested_region_code VARCHAR2(30) := NULL,
142 url VARCHAR2(2000) := NULL,
143 poplist_viewobject VARCHAR2(240) := NULL,
144 poplist_display_attr VARCHAR2(80) := NULL,
145 poplist_value_attr VARCHAR2(80) := NULL,
146 image_file_name VARCHAR2(80) := NULL,
147 item_name VARCHAR2(30) := NULL,
148 css_label_class_name VARCHAR2(80) := NULL,
149 menu_name VARCHAR2(30) :=NULL,
150 flexfield_name VARCHAR2(40) :=NULL,
151 flexfield_application_id NUMBER :=NULL,
152 tabular_function_code VARCHAR2(30) :=NULL,
153 tip_type VARCHAR2(30) :=NULL,
154 tip_message_name VARCHAR2(30) :=NULL,
155 tip_message_application_id NUMBER :=NULL,
156 flex_segment_list VARCHAR2(4000) :=NULL,
157 entity_id VARCHAR2(30) :=NULL,
158 anchor VARCHAR2(1) := NULL,
159 poplist_view_usage_name VARCHAR2(80) := NULL,
160 user_customizable VARCHAR2(1) := NULL,
161 sortby_view_attribute_name VARCHAR2(80) := NULL,
162 admin_customizable VARCHAR2(1) := NULL,
163 invoke_function_name VARCHAR2(30) := NULL,
164 expansion NUMBER := NULL,
165 als_max_length NUMBER := NULL,
166 initial_sort_sequence VARCHAR(30) := NULL,
167 customization_application_id NUMBER := NULL,
168 customization_code VARCHAR2(30) := NULL,
169 attribute_category VARCHAR2(30) := NULL,
170 attribute1 VARCHAR2(150) := NULL,
171 attribute2 VARCHAR2(150) := NULL,
172 attribute3 VARCHAR2(150) := NULL,
173 attribute4 VARCHAR2(150) := NULL,
174 attribute5 VARCHAR2(150) := NULL,
175 attribute6 VARCHAR2(150) := NULL,
176 attribute7 VARCHAR2(150) := NULL,
177 attribute8 VARCHAR2(150) := NULL,
178 attribute9 VARCHAR2(150) := NULL,
179 attribute10 VARCHAR2(150) := NULL,
180 attribute11 VARCHAR2(150) := NULL,
181 attribute12 VARCHAR2(150) := NULL,
182 attribute13 VARCHAR2(150) := NULL,
183 attribute14 VARCHAR2(150) := NULL,
184 attribute15 VARCHAR2(150) := NULL,
185 attribute_label_long VARCHAR2(80) := NULL,
186 attribute_label_short VARCHAR2(40) := NULL,
187 description VARCHAR2(2000) := NULL,
188 created_by NUMBER := NULL,
189 creation_date DATE := NULL,
190 last_updated_by NUMBER := NULL,
191 last_update_date DATE := NULL,
192 last_update_login NUMBER := NULL
193 );
194
195 -- Region primary key table
196
197 TYPE Item_Tbl_Type IS TABLE OF Item_Rec_Type
198 INDEX BY BINARY_INTEGER;
199
200 TYPE Region_PK_Tbl_Type IS TABLE OF Region_PK_Rec_Type
201 INDEX BY BINARY_INTEGER;
202
203 TYPE Region_Tbl_Type IS TABLE OF Region_Rec_Type
204 INDEX BY BINARY_INTEGER;
205
206 TYPE Lov_Relation_Tbl_Type IS TABLE OF AK_REGION_LOV_RELATIONS%ROWTYPE
207 INDEX BY BINARY_INTEGER;
208
209 TYPE Category_Usages_Tbl_Type IS TABLE OF AK_CATEGORY_USAGES%ROWTYPE
210 INDEX BY BINARY_INTEGER;
211 /*
212 TYPE Graph_Tbl_Type is TABLE OF Graph_Rec_Type
213 INDEX BY BINARY_INTEGER;
214
215 TYPE Graph_Column_Tbl_Type is TABLE OF AK_REGION_GRAPH_COLUMNS%ROWTYPE
216 INDEX BY BINARY_INTEGER;
217 */
218 /* Constants for missing data types */
219 G_MISS_ITEM_REC Item_Rec_Type;
220 G_MISS_ITEM_TBL Item_Tbl_Type;
221 G_MISS_REGION_PK_REC Region_PK_Rec_Type;
222 G_MISS_REGION_PK_TBL Region_PK_Tbl_Type;
223 G_MISS_REGION_REC Region_Rec_Type;
224 G_MISS_REGION_TBL Region_Tbl_Type;
225 G_MISS_LOV_RELATION_REC Lov_Relation_Tbl_Type;
226 G_MISS_CATEGORY_USAGES_REC Category_Usages_Tbl_Type;
227 --G_MISS_GRAPH_REC Graph_Tbl_Type;
228 --G_MISS_GRAPH_COLUMN_REC Graph_Column_Tbl_Type;
229
230 end AK_REGION_PUB;