[Home] [Help]
PACKAGE: APPS.AK_KEY_PUB
Source
1 package AK_KEY_PUB AUTHID CURRENT_USER as
2 /* $Header: akdpkeys.pls 115.7 2002/09/27 17:57:16 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_KEY_PUB';
8
9 -- Type definitions
10
11 -- Foreign Key Record
12
13 TYPE Foreign_Key_Rec_Type IS RECORD (
14 foreign_key_name VARCHAR2(30) := NULL,
15 database_object_name VARCHAR2(30) := NULL,
16 unique_key_name VARCHAR2(30) := NULL,
17 application_id NUMBER := 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 from_to_name VARCHAR2(45) := NULL,
35 from_to_description VARCHAR2(1500) := NULL,
36 to_from_name VARCHAR2(45) := NULL,
37 to_from_description VARCHAR2(1500) := 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 -- Foreign Key Column Record
46
47 TYPE Foreign_Key_Column_Rec_Type IS RECORD (
48 foreign_key_name VARCHAR2(30) := NULL,
49 attribute_application_id NUMBER := NULL,
50 attribute_code VARCHAR2(30) := NULL,
51 foreign_key_sequence NUMBER := 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 created_by NUMBER := NULL,
69 creation_date DATE := NULL,
70 last_updated_by NUMBER := NULL,
71 last_update_date DATE := NULL,
72 last_update_login NUMBER := NULL
73 );
74
75 -- Unique Key Record
76
77 TYPE Unique_Key_Rec_Type IS RECORD (
78 unique_key_name VARCHAR2(30) := NULL,
79 database_object_name VARCHAR2(30) := NULL,
80 application_id NUMBER := NULL,
81 attribute_category VARCHAR2(30) := NULL,
82 attribute1 VARCHAR2(150) := NULL,
83 attribute2 VARCHAR2(150) := NULL,
84 attribute3 VARCHAR2(150) := NULL,
85 attribute4 VARCHAR2(150) := NULL,
86 attribute5 VARCHAR2(150) := NULL,
87 attribute6 VARCHAR2(150) := NULL,
88 attribute7 VARCHAR2(150) := NULL,
89 attribute8 VARCHAR2(150) := NULL,
90 attribute9 VARCHAR2(150) := NULL,
91 attribute10 VARCHAR2(150) := NULL,
92 attribute11 VARCHAR2(150) := NULL,
93 attribute12 VARCHAR2(150) := NULL,
94 attribute13 VARCHAR2(150) := NULL,
95 attribute14 VARCHAR2(150) := NULL,
96 attribute15 VARCHAR2(150) := NULL,
97 created_by NUMBER := NULL,
98 creation_date DATE := NULL,
99 last_updated_by NUMBER := NULL,
100 last_update_date DATE := NULL,
101 last_update_login NUMBER := NULL
102 );
103
104 -- Unique Key Column Record
105
106 TYPE Unique_Key_Column_Rec_Type IS RECORD (
107 unique_key_name VARCHAR2(30) := NULL,
108 attribute_application_id NUMBER := NULL,
109 attribute_code VARCHAR2(30) := NULL,
110 unique_key_sequence NUMBER := NULL,
111 attribute_category VARCHAR2(30) := NULL,
112 attribute1 VARCHAR2(150) := NULL,
113 attribute2 VARCHAR2(150) := NULL,
114 attribute3 VARCHAR2(150) := NULL,
115 attribute4 VARCHAR2(150) := NULL,
116 attribute5 VARCHAR2(150) := NULL,
117 attribute6 VARCHAR2(150) := NULL,
118 attribute7 VARCHAR2(150) := NULL,
119 attribute8 VARCHAR2(150) := NULL,
120 attribute9 VARCHAR2(150) := NULL,
121 attribute10 VARCHAR2(150) := NULL,
122 attribute11 VARCHAR2(150) := NULL,
123 attribute12 VARCHAR2(150) := NULL,
124 attribute13 VARCHAR2(150) := NULL,
125 attribute14 VARCHAR2(150) := NULL,
126 attribute15 VARCHAR2(150) := NULL,
127 created_by NUMBER := NULL,
128 creation_date DATE := NULL,
129 last_updated_by NUMBER := NULL,
130 last_update_date DATE := NULL,
131 last_update_login NUMBER := NULL
132 );
133
134 -- Data Types
135
136 TYPE Foreign_Key_Tbl_Type IS TABLE OF Foreign_Key_Rec_Type
137 INDEX BY BINARY_INTEGER;
138
139 TYPE Foreign_Key_Column_Tbl_Type IS TABLE OF Foreign_Key_Column_Rec_Type
140 INDEX BY BINARY_INTEGER;
141
142 TYPE Unique_Key_Tbl_Type IS TABLE OF Unique_Key_Rec_Type
143 INDEX BY BINARY_INTEGER;
144
145 TYPE Unique_Key_Column_Tbl_Type IS TABLE OF Unique_Key_Column_Rec_Type
146 INDEX BY BINARY_INTEGER;
147
148 /* Constants for missing data types */
149 G_MISS_FOREIGN_KEY_REC Foreign_Key_Rec_Type;
150 G_MISS_FOREIGN_KEY_COLUMN_REC Foreign_Key_Column_Rec_Type;
151 G_MISS_UNIQUE_KEY_REC Unique_Key_Rec_Type;
152 G_MISS_UNIQUE_KEY_COLUMN_REC Unique_Key_Column_Rec_Type;
153
154 G_MISS_FOREIGN_KEY_TBL Foreign_Key_Tbl_Type;
155 G_MISS_FOREIGN_KEY_COLUMN_TBL Foreign_Key_Column_Tbl_Type;
156 G_MISS_UNIQUE_KEY_TBL Unique_Key_Tbl_Type;
157 G_MISS_UNIQUE_KEY_COLUMN_TBL Unique_Key_Column_Tbl_Type;
158
159 end AK_KEY_PUB;