[Home] [Help]
PACKAGE: APPS.AK_FLOW_PUB
Source
1 package AK_FLOW_PUB AUTHID CURRENT_USER as
2 /* $Header: akdpflos.pls 115.7 2002/09/27 17:56:33 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_FLOW_PUB';
8
9 -- Type definitions
10
11 -- Flow Record
12
13 TYPE Flow_Rec_Type IS RECORD (
14 flow_application_id NUMBER := NULL,
15 flow_code VARCHAR2(30) := NULL,
16 primary_page_appl_id NUMBER := NULL,
17 primary_page_code VARCHAR2(30) := NULL,
18 attribute_category VARCHAR2(30) := NULL,
19 attribute1 VARCHAR2(150) := NULL,
20 attribute2 VARCHAR2(150) := NULL,
21 attribute3 VARCHAR2(150) := NULL,
22 attribute4 VARCHAR2(150) := NULL,
23 attribute5 VARCHAR2(150) := NULL,
24 attribute6 VARCHAR2(150) := NULL,
25 attribute7 VARCHAR2(150) := NULL,
26 attribute8 VARCHAR2(150) := NULL,
27 attribute9 VARCHAR2(150) := NULL,
28 attribute10 VARCHAR2(150) := NULL,
29 attribute11 VARCHAR2(150) := NULL,
30 attribute12 VARCHAR2(150) := NULL,
31 attribute13 VARCHAR2(150) := NULL,
32 attribute14 VARCHAR2(150) := NULL,
33 attribute15 VARCHAR2(150) := NULL,
34 name VARCHAR2(30) := NULL,
35 description VARCHAR2(2000) := NULL,
36 created_by NUMBER := NULL,
37 creation_date DATE := NULL,
38 last_updated_by NUMBER := NULL,
39 lasT_update_date DATE := NULL,
40 last_update_login NUMBER := NULL
41 );
42
43 -- Flow Page Record
44
45 TYPE Page_Rec_Type IS RECORD (
46 flow_application_id NUMBER := NULL,
47 flow_code VARCHAR2(30) := NULL,
48 page_application_id NUMBER := NULL,
49 page_code VARCHAR2(30) := NULL,
50 primary_region_appl_id NUMBER := NULL,
51 primary_region_code VARCHAR2(30) := NULL,
52 attribute_category VARCHAR2(30) := NULL,
53 attribute1 VARCHAR2(150) := NULL,
54 attribute2 VARCHAR2(150) := NULL,
55 attribute3 VARCHAR2(150) := NULL,
56 attribute4 VARCHAR2(150) := NULL,
57 attribute5 VARCHAR2(150) := NULL,
58 attribute6 VARCHAR2(150) := NULL,
59 attribute7 VARCHAR2(150) := NULL,
60 attribute8 VARCHAR2(150) := NULL,
61 attribute9 VARCHAR2(150) := NULL,
62 attribute10 VARCHAR2(150) := NULL,
63 attribute11 VARCHAR2(150) := NULL,
64 attribute12 VARCHAR2(150) := NULL,
65 attribute13 VARCHAR2(150) := NULL,
66 attribute14 VARCHAR2(150) := NULL,
67 attribute15 VARCHAR2(150) := NULL,
68 name VARCHAR2(80) := NULL,
69 description VARCHAR2(2000) := NULL,
70 created_by NUMBER := NULL,
71 creation_date DATE := NULL,
72 last_updated_by NUMBER := NULL,
73 lasT_update_date DATE := NULL,
74 last_update_login NUMBER := NULL
75 );
76
77 -- Flow Page Region Record
78 -- (plus foreign_key_name for creating a flow_region_relation record)
79
80 TYPE Page_Region_Rec_Type IS RECORD (
81 flow_application_id NUMBER := NULL,
82 flow_code VARCHAR2(30) := NULL,
83 page_application_id NUMBER := NULL,
84 page_code VARCHAR2(30) := NULL,
85 region_application_id NUMBER := NULL,
86 region_code VARCHAR2(30) := NULL,
87 display_sequence NUMBER := NULL,
88 region_style VARCHAR2(30) := NULL,
89 num_columns NUMBER := NULL,
90 icx_custom_call VARCHAR2(240) := NULL,
91 parent_region_appl_id NUMBER := NULL,
92 parent_region_code VARCHAR2(30) := NULL,
93 foreign_key_name VARCHAR2(30) := NULL,
94 attribute_category VARCHAR2(30) := NULL,
95 attribute1 VARCHAR2(150) := NULL,
96 attribute2 VARCHAR2(150) := NULL,
97 attribute3 VARCHAR2(150) := NULL,
98 attribute4 VARCHAR2(150) := NULL,
99 attribute5 VARCHAR2(150) := NULL,
100 attribute6 VARCHAR2(150) := NULL,
101 attribute7 VARCHAR2(150) := NULL,
102 attribute8 VARCHAR2(150) := NULL,
103 attribute9 VARCHAR2(150) := NULL,
104 attribute10 VARCHAR2(150) := NULL,
105 attribute11 VARCHAR2(150) := NULL,
106 attribute12 VARCHAR2(150) := NULL,
107 attribute13 VARCHAR2(150) := NULL,
108 attribute14 VARCHAR2(150) := NULL,
109 attribute15 VARCHAR2(150) := NULL,
110 created_by NUMBER := NULL,
111 creation_date DATE := NULL,
112 last_updated_by NUMBER := NULL,
113 lasT_update_date DATE := NULL,
114 last_update_login NUMBER := NULL
115 );
116
117 -- Flow Page Region Item Record
118
119 TYPE Page_Region_Item_Rec_Type IS RECORD (
120 flow_application_id NUMBER := NULL,
121 flow_code VARCHAR2(30) := NULL,
122 page_application_id NUMBER := NULL,
123 page_code VARCHAR2(30) := NULL,
124 region_application_id NUMBER := NULL,
125 region_code VARCHAR2(30) := NULL,
126 attribute_application_id NUMBER := NULL,
127 attribute_code VARCHAR2(30) := NULL,
128 to_page_appl_id NUMBER := NULL,
129 to_page_code VARCHAR2(30) := NULL,
130 to_url_attribute_appl_id NUMBER := NULL,
131 to_url_attribute_code VARCHAR2(30) := NULL,
132 attribute_category VARCHAR2(30) := NULL,
133 attribute1 VARCHAR2(150) := NULL,
134 attribute2 VARCHAR2(150) := NULL,
135 attribute3 VARCHAR2(150) := NULL,
136 attribute4 VARCHAR2(150) := NULL,
137 attribute5 VARCHAR2(150) := NULL,
138 attribute6 VARCHAR2(150) := NULL,
139 attribute7 VARCHAR2(150) := NULL,
140 attribute8 VARCHAR2(150) := NULL,
141 attribute9 VARCHAR2(150) := NULL,
142 attribute10 VARCHAR2(150) := NULL,
143 attribute11 VARCHAR2(150) := NULL,
144 attribute12 VARCHAR2(150) := NULL,
145 attribute13 VARCHAR2(150) := NULL,
146 attribute14 VARCHAR2(150) := NULL,
147 attribute15 VARCHAR2(150) := NULL,
148 created_by NUMBER := NULL,
149 creation_date DATE := NULL,
150 last_updated_by NUMBER := NULL,
151 lasT_update_date DATE := NULL,
152 last_update_login NUMBER := NULL
153 );
154
155 -- Flow Region Relation Record
156
157 TYPE Region_Relation_Rec_Type IS RECORD (
158 flow_application_id NUMBER := NULL,
159 flow_code VARCHAR2(30) := NULL,
160 foreign_key_name VARCHAR2(30) := NULL,
161 from_page_appl_id NUMBER := NULL,
162 from_page_code VARCHAR2(30) := NULL,
163 from_region_appl_id NUMBER := NULL,
164 from_region_code VARCHAR2(30) := NULL,
165 to_page_appl_id NUMBER := NULL,
166 to_page_code VARCHAR2(30) := NULL,
167 to_region_appl_id NUMBER := NULL,
168 to_region_code VARCHAR2(30) := NULL,
169 application_id NUMBER := NULL,
170 attribute_category VARCHAR2(30) := NULL,
171 attribute1 VARCHAR2(150) := NULL,
172 attribute2 VARCHAR2(150) := NULL,
173 attribute3 VARCHAR2(150) := NULL,
174 attribute4 VARCHAR2(150) := NULL,
175 attribute5 VARCHAR2(150) := NULL,
176 attribute6 VARCHAR2(150) := NULL,
177 attribute7 VARCHAR2(150) := NULL,
178 attribute8 VARCHAR2(150) := NULL,
179 attribute9 VARCHAR2(150) := NULL,
180 attribute10 VARCHAR2(150) := NULL,
181 attribute11 VARCHAR2(150) := NULL,
182 attribute12 VARCHAR2(150) := NULL,
183 attribute13 VARCHAR2(150) := NULL,
184 attribute14 VARCHAR2(150) := NULL,
185 attribute15 VARCHAR2(150) := NULL,
186 created_by NUMBER := NULL,
187 creation_date DATE := NULL,
188 last_updated_by NUMBER := NULL,
189 lasT_update_date DATE := NULL,
190 last_update_login NUMBER := NULL
191 );
192
193 -- Flow key record
194
195 TYPE Flow_PK_Rec_Type IS RECORD (
196 flow_appl_id NUMBER := NULL,
197 flow_code VARCHAR2(30) := NULL
198 );
199
200 -- Tables
201
202 TYPE Flow_Tbl_Type IS TABLE OF Flow_Rec_Type
203 INDEX BY BINARY_INTEGER;
204
205 TYPE Flow_PK_Tbl_Type IS TABLE OF Flow_PK_Rec_Type
206 INDEX BY BINARY_INTEGER;
207
208 TYPE Page_Tbl_Type IS TABLE OF Page_Rec_Type
209 INDEX BY BINARY_INTEGER;
210
211 TYPE Page_Region_Tbl_Type IS TABLE OF Page_Region_Rec_Type
212 INDEX BY BINARY_INTEGER;
213
214 TYPE Page_Region_Item_Tbl_Type IS TABLE OF Page_Region_Item_Rec_Type
215 INDEX BY BINARY_INTEGER;
216
217 TYPE Region_Relation_Tbl_Type IS TABLE OF Region_Relation_Rec_Type
218 INDEX BY BINARY_INTEGER;
219
220
221 /* Constants for missing data types */
222 G_MISS_FLOW_REC Flow_Rec_Type;
223 G_MISS_FLOW_TBL Flow_Tbl_Type;
224 G_MISS_FLOW_PK_REC Flow_PK_Rec_Type;
225 G_MISS_FLOW_PK_TBL Flow_PK_Tbl_Type;
226 G_MISS_PAGE_REC Page_Rec_Type;
227 G_MISS_PAGE_TBL Page_Tbl_Type;
228 G_MISS_PAGE_REGION_REC Page_Region_Rec_Type;
229 G_MISS_PAGE_REGION_TBL Page_Region_Tbl_Type;
230 G_MISS_PAGE_REGION_ITEM_REC Page_Region_Item_Rec_Type;
231 G_MISS_PAGE_REGION_ITEM_TBL Page_Region_Item_Tbl_Type;
232 G_MISS_REGION_RELATION_REC Region_Relation_Rec_Type;
233 G_MISS_REGION_RELATION_TBL Region_Relation_Tbl_Type;
234
235 end AK_FLOW_PUB;