8: -- Procedure : Get_Attr_Tbl
9:
10: PROCEDURE Get_Attr_Tbl
11: IS
12: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
13: I NUMBER := 0;
14: BEGIN
15:
16: OE_GENERATE.g_attr_tbl.DELETE;
12: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
13: I NUMBER := 0;
14: BEGIN
15:
16: OE_GENERATE.g_attr_tbl.DELETE;
17:
18: -- Load attributes
19:
20: I := I + 1;
17:
18: -- Load attributes
19:
20: I := I + 1;
21: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
22: l_attr_rec.column := 'ATTRIBUTE1';
23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 240;
25: l_attr_rec.name := 'attribute1';
23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 240;
25: l_attr_rec.name := 'attribute1';
26: l_attr_rec.code := 'attribute1';
27: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
28: l_attr_rec.text1 := 'SOU';
29: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
30:
31: I := I + 1;
25: l_attr_rec.name := 'attribute1';
26: l_attr_rec.code := 'attribute1';
27: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
28: l_attr_rec.text1 := 'SOU';
29: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
30:
31: I := I + 1;
32: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
33: l_attr_rec.column := 'ATTRIBUTE10';
28: l_attr_rec.text1 := 'SOU';
29: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
30:
31: I := I + 1;
32: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
33: l_attr_rec.column := 'ATTRIBUTE10';
34: l_attr_rec.type := 'VARCHAR2';
35: l_attr_rec.length := 240;
36: l_attr_rec.name := 'attribute10';
34: l_attr_rec.type := 'VARCHAR2';
35: l_attr_rec.length := 240;
36: l_attr_rec.name := 'attribute10';
37: l_attr_rec.code := 'attribute10';
38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
39: l_attr_rec.text1 := 'SOU';
40: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
41:
42: I := I + 1;
36: l_attr_rec.name := 'attribute10';
37: l_attr_rec.code := 'attribute10';
38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
39: l_attr_rec.text1 := 'SOU';
40: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
41:
42: I := I + 1;
43: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
44: l_attr_rec.column := 'ATTRIBUTE11';
39: l_attr_rec.text1 := 'SOU';
40: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
41:
42: I := I + 1;
43: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
44: l_attr_rec.column := 'ATTRIBUTE11';
45: l_attr_rec.type := 'VARCHAR2';
46: l_attr_rec.length := 240;
47: l_attr_rec.name := 'attribute11';
45: l_attr_rec.type := 'VARCHAR2';
46: l_attr_rec.length := 240;
47: l_attr_rec.name := 'attribute11';
48: l_attr_rec.code := 'attribute11';
49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
50: l_attr_rec.text1 := 'SOU';
51: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
52:
53: I := I + 1;
47: l_attr_rec.name := 'attribute11';
48: l_attr_rec.code := 'attribute11';
49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
50: l_attr_rec.text1 := 'SOU';
51: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
52:
53: I := I + 1;
54: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
55: l_attr_rec.column := 'ATTRIBUTE12';
50: l_attr_rec.text1 := 'SOU';
51: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
52:
53: I := I + 1;
54: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
55: l_attr_rec.column := 'ATTRIBUTE12';
56: l_attr_rec.type := 'VARCHAR2';
57: l_attr_rec.length := 240;
58: l_attr_rec.name := 'attribute12';
56: l_attr_rec.type := 'VARCHAR2';
57: l_attr_rec.length := 240;
58: l_attr_rec.name := 'attribute12';
59: l_attr_rec.code := 'attribute12';
60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
61: l_attr_rec.text1 := 'SOU';
62: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
63:
64: I := I + 1;
58: l_attr_rec.name := 'attribute12';
59: l_attr_rec.code := 'attribute12';
60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
61: l_attr_rec.text1 := 'SOU';
62: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
63:
64: I := I + 1;
65: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
66: l_attr_rec.column := 'ATTRIBUTE13';
61: l_attr_rec.text1 := 'SOU';
62: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
63:
64: I := I + 1;
65: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
66: l_attr_rec.column := 'ATTRIBUTE13';
67: l_attr_rec.type := 'VARCHAR2';
68: l_attr_rec.length := 240;
69: l_attr_rec.name := 'attribute13';
67: l_attr_rec.type := 'VARCHAR2';
68: l_attr_rec.length := 240;
69: l_attr_rec.name := 'attribute13';
70: l_attr_rec.code := 'attribute13';
71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
72: l_attr_rec.text1 := 'SOU';
73: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
74:
75: I := I + 1;
69: l_attr_rec.name := 'attribute13';
70: l_attr_rec.code := 'attribute13';
71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
72: l_attr_rec.text1 := 'SOU';
73: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
74:
75: I := I + 1;
76: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
77: l_attr_rec.column := 'ATTRIBUTE14';
72: l_attr_rec.text1 := 'SOU';
73: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
74:
75: I := I + 1;
76: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
77: l_attr_rec.column := 'ATTRIBUTE14';
78: l_attr_rec.type := 'VARCHAR2';
79: l_attr_rec.length := 240;
80: l_attr_rec.name := 'attribute14';
78: l_attr_rec.type := 'VARCHAR2';
79: l_attr_rec.length := 240;
80: l_attr_rec.name := 'attribute14';
81: l_attr_rec.code := 'attribute14';
82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
83: l_attr_rec.text1 := 'SOU';
84: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
85:
86: I := I + 1;
80: l_attr_rec.name := 'attribute14';
81: l_attr_rec.code := 'attribute14';
82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
83: l_attr_rec.text1 := 'SOU';
84: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
85:
86: I := I + 1;
87: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
88: l_attr_rec.column := 'ATTRIBUTE15';
83: l_attr_rec.text1 := 'SOU';
84: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
85:
86: I := I + 1;
87: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
88: l_attr_rec.column := 'ATTRIBUTE15';
89: l_attr_rec.type := 'VARCHAR2';
90: l_attr_rec.length := 240;
91: l_attr_rec.name := 'attribute15';
89: l_attr_rec.type := 'VARCHAR2';
90: l_attr_rec.length := 240;
91: l_attr_rec.name := 'attribute15';
92: l_attr_rec.code := 'attribute15';
93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
94: l_attr_rec.text1 := 'SOU';
95: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
96:
97: I := I + 1;
91: l_attr_rec.name := 'attribute15';
92: l_attr_rec.code := 'attribute15';
93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
94: l_attr_rec.text1 := 'SOU';
95: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
96:
97: I := I + 1;
98: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
99: l_attr_rec.column := 'ATTRIBUTE2';
94: l_attr_rec.text1 := 'SOU';
95: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
96:
97: I := I + 1;
98: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
99: l_attr_rec.column := 'ATTRIBUTE2';
100: l_attr_rec.type := 'VARCHAR2';
101: l_attr_rec.length := 240;
102: l_attr_rec.name := 'attribute2';
100: l_attr_rec.type := 'VARCHAR2';
101: l_attr_rec.length := 240;
102: l_attr_rec.name := 'attribute2';
103: l_attr_rec.code := 'attribute2';
104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
105: l_attr_rec.text1 := 'SOU';
106: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
107:
108: I := I + 1;
102: l_attr_rec.name := 'attribute2';
103: l_attr_rec.code := 'attribute2';
104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
105: l_attr_rec.text1 := 'SOU';
106: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
107:
108: I := I + 1;
109: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
110: l_attr_rec.column := 'ATTRIBUTE3';
105: l_attr_rec.text1 := 'SOU';
106: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
107:
108: I := I + 1;
109: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
110: l_attr_rec.column := 'ATTRIBUTE3';
111: l_attr_rec.type := 'VARCHAR2';
112: l_attr_rec.length := 240;
113: l_attr_rec.name := 'attribute3';
111: l_attr_rec.type := 'VARCHAR2';
112: l_attr_rec.length := 240;
113: l_attr_rec.name := 'attribute3';
114: l_attr_rec.code := 'attribute3';
115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
116: l_attr_rec.text1 := 'SOU';
117: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
118:
119: I := I + 1;
113: l_attr_rec.name := 'attribute3';
114: l_attr_rec.code := 'attribute3';
115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
116: l_attr_rec.text1 := 'SOU';
117: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
118:
119: I := I + 1;
120: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
121: l_attr_rec.column := 'ATTRIBUTE4';
116: l_attr_rec.text1 := 'SOU';
117: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
118:
119: I := I + 1;
120: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
121: l_attr_rec.column := 'ATTRIBUTE4';
122: l_attr_rec.type := 'VARCHAR2';
123: l_attr_rec.length := 240;
124: l_attr_rec.name := 'attribute4';
122: l_attr_rec.type := 'VARCHAR2';
123: l_attr_rec.length := 240;
124: l_attr_rec.name := 'attribute4';
125: l_attr_rec.code := 'attribute4';
126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
127: l_attr_rec.text1 := 'SOU';
128: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
129:
130: I := I + 1;
124: l_attr_rec.name := 'attribute4';
125: l_attr_rec.code := 'attribute4';
126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
127: l_attr_rec.text1 := 'SOU';
128: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
129:
130: I := I + 1;
131: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
132: l_attr_rec.column := 'ATTRIBUTE5';
127: l_attr_rec.text1 := 'SOU';
128: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
129:
130: I := I + 1;
131: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
132: l_attr_rec.column := 'ATTRIBUTE5';
133: l_attr_rec.type := 'VARCHAR2';
134: l_attr_rec.length := 240;
135: l_attr_rec.name := 'attribute5';
133: l_attr_rec.type := 'VARCHAR2';
134: l_attr_rec.length := 240;
135: l_attr_rec.name := 'attribute5';
136: l_attr_rec.code := 'attribute5';
137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
138: l_attr_rec.text1 := 'SOU';
139: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
140:
141: I := I + 1;
135: l_attr_rec.name := 'attribute5';
136: l_attr_rec.code := 'attribute5';
137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
138: l_attr_rec.text1 := 'SOU';
139: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
140:
141: I := I + 1;
142: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
143: l_attr_rec.column := 'ATTRIBUTE6';
138: l_attr_rec.text1 := 'SOU';
139: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
140:
141: I := I + 1;
142: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
143: l_attr_rec.column := 'ATTRIBUTE6';
144: l_attr_rec.type := 'VARCHAR2';
145: l_attr_rec.length := 240;
146: l_attr_rec.name := 'attribute6';
144: l_attr_rec.type := 'VARCHAR2';
145: l_attr_rec.length := 240;
146: l_attr_rec.name := 'attribute6';
147: l_attr_rec.code := 'attribute6';
148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
149: l_attr_rec.text1 := 'SOU';
150: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
151:
152: I := I + 1;
146: l_attr_rec.name := 'attribute6';
147: l_attr_rec.code := 'attribute6';
148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
149: l_attr_rec.text1 := 'SOU';
150: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
151:
152: I := I + 1;
153: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
154: l_attr_rec.column := 'ATTRIBUTE7';
149: l_attr_rec.text1 := 'SOU';
150: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
151:
152: I := I + 1;
153: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
154: l_attr_rec.column := 'ATTRIBUTE7';
155: l_attr_rec.type := 'VARCHAR2';
156: l_attr_rec.length := 240;
157: l_attr_rec.name := 'attribute7';
155: l_attr_rec.type := 'VARCHAR2';
156: l_attr_rec.length := 240;
157: l_attr_rec.name := 'attribute7';
158: l_attr_rec.code := 'attribute7';
159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
160: l_attr_rec.text1 := 'SOU';
161: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
162:
163: I := I + 1;
157: l_attr_rec.name := 'attribute7';
158: l_attr_rec.code := 'attribute7';
159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
160: l_attr_rec.text1 := 'SOU';
161: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
162:
163: I := I + 1;
164: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
165: l_attr_rec.column := 'ATTRIBUTE8';
160: l_attr_rec.text1 := 'SOU';
161: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
162:
163: I := I + 1;
164: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
165: l_attr_rec.column := 'ATTRIBUTE8';
166: l_attr_rec.type := 'VARCHAR2';
167: l_attr_rec.length := 240;
168: l_attr_rec.name := 'attribute8';
166: l_attr_rec.type := 'VARCHAR2';
167: l_attr_rec.length := 240;
168: l_attr_rec.name := 'attribute8';
169: l_attr_rec.code := 'attribute8';
170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
171: l_attr_rec.text1 := 'SOU';
172: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
173:
174: I := I + 1;
168: l_attr_rec.name := 'attribute8';
169: l_attr_rec.code := 'attribute8';
170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
171: l_attr_rec.text1 := 'SOU';
172: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
173:
174: I := I + 1;
175: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
176: l_attr_rec.column := 'ATTRIBUTE9';
171: l_attr_rec.text1 := 'SOU';
172: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
173:
174: I := I + 1;
175: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
176: l_attr_rec.column := 'ATTRIBUTE9';
177: l_attr_rec.type := 'VARCHAR2';
178: l_attr_rec.length := 240;
179: l_attr_rec.name := 'attribute9';
177: l_attr_rec.type := 'VARCHAR2';
178: l_attr_rec.length := 240;
179: l_attr_rec.name := 'attribute9';
180: l_attr_rec.code := 'attribute9';
181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
182: l_attr_rec.text1 := 'SOU';
183: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
184:
185: I := I + 1;
179: l_attr_rec.name := 'attribute9';
180: l_attr_rec.code := 'attribute9';
181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
182: l_attr_rec.text1 := 'SOU';
183: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
184:
185: I := I + 1;
186: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
187: l_attr_rec.column := 'ATTRIBUTE_SOURCING_ID';
182: l_attr_rec.text1 := 'SOU';
183: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
184:
185: I := I + 1;
186: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
187: l_attr_rec.column := 'ATTRIBUTE_SOURCING_ID';
188: l_attr_rec.type := 'NUMBER';
189: l_attr_rec.name := 'attribute_sourcing';
190: l_attr_rec.code := 'attribute_sourcing_id';
187: l_attr_rec.column := 'ATTRIBUTE_SOURCING_ID';
188: l_attr_rec.type := 'NUMBER';
189: l_attr_rec.name := 'attribute_sourcing';
190: l_attr_rec.code := 'attribute_sourcing_id';
191: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
192: l_attr_rec.pk_flag := TRUE;
193: l_attr_rec.value := TRUE;
194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
195:
190: l_attr_rec.code := 'attribute_sourcing_id';
191: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
192: l_attr_rec.pk_flag := TRUE;
193: l_attr_rec.value := TRUE;
194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
195:
196: I := I + 1;
197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
198: l_attr_rec.column := 'ATTRIBUTE_SOURCING_LEVEL';
193: l_attr_rec.value := TRUE;
194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
195:
196: I := I + 1;
197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
198: l_attr_rec.column := 'ATTRIBUTE_SOURCING_LEVEL';
199: l_attr_rec.type := 'VARCHAR2';
200: l_attr_rec.length := 30;
201: l_attr_rec.name := 'attribute_sourcing_level';
199: l_attr_rec.type := 'VARCHAR2';
200: l_attr_rec.length := 30;
201: l_attr_rec.name := 'attribute_sourcing_level';
202: l_attr_rec.code := 'attribute_sourcing_level';
203: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
200: l_attr_rec.length := 30;
201: l_attr_rec.name := 'attribute_sourcing_level';
202: l_attr_rec.code := 'attribute_sourcing_level';
203: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
208: l_attr_rec.column := 'APPLICATION_ID';
203: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
208: l_attr_rec.column := 'APPLICATION_ID';
209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'application_id';
211: l_attr_rec.code := 'application_id';
208: l_attr_rec.column := 'APPLICATION_ID';
209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'application_id';
211: l_attr_rec.code := 'application_id';
212: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
213: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
214:
215: I := I + 1;
216: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'application_id';
211: l_attr_rec.code := 'application_id';
212: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
213: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
214:
215: I := I + 1;
216: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
217: l_attr_rec.column := 'CONTEXT';
212: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
213: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
214:
215: I := I + 1;
216: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
217: l_attr_rec.column := 'CONTEXT';
218: l_attr_rec.type := 'VARCHAR2';
219: l_attr_rec.length := 30;
220: l_attr_rec.name := 'context';
218: l_attr_rec.type := 'VARCHAR2';
219: l_attr_rec.length := 30;
220: l_attr_rec.name := 'context';
221: l_attr_rec.code := 'context';
222: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
223: l_attr_rec.text1 := 'SOU';
224: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
225:
226: I := I + 1;
220: l_attr_rec.name := 'context';
221: l_attr_rec.code := 'context';
222: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
223: l_attr_rec.text1 := 'SOU';
224: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
225:
226: I := I + 1;
227: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
228: l_attr_rec.column := 'CREATED_BY';
223: l_attr_rec.text1 := 'SOU';
224: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
225:
226: I := I + 1;
227: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
228: l_attr_rec.column := 'CREATED_BY';
229: l_attr_rec.type := 'NUMBER';
230: l_attr_rec.name := 'created_by';
231: l_attr_rec.code := 'created_by';
228: l_attr_rec.column := 'CREATED_BY';
229: l_attr_rec.type := 'NUMBER';
230: l_attr_rec.name := 'created_by';
231: l_attr_rec.code := 'created_by';
232: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;
236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
229: l_attr_rec.type := 'NUMBER';
230: l_attr_rec.name := 'created_by';
231: l_attr_rec.code := 'created_by';
232: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;
236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
237: l_attr_rec.column := 'CREATION_DATE';
232: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;
236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
237: l_attr_rec.column := 'CREATION_DATE';
238: l_attr_rec.type := 'DATE';
239: l_attr_rec.name := 'creation_date';
240: l_attr_rec.code := 'creation_date';
237: l_attr_rec.column := 'CREATION_DATE';
238: l_attr_rec.type := 'DATE';
239: l_attr_rec.name := 'creation_date';
240: l_attr_rec.code := 'creation_date';
241: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
242: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
243:
244: I := I + 1;
245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
238: l_attr_rec.type := 'DATE';
239: l_attr_rec.name := 'creation_date';
240: l_attr_rec.code := 'creation_date';
241: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
242: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
243:
244: I := I + 1;
245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
246: l_attr_rec.column := 'ENABLED_FLAG';
241: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
242: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
243:
244: I := I + 1;
245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
246: l_attr_rec.column := 'ENABLED_FLAG';
247: l_attr_rec.type := 'VARCHAR2';
248: l_attr_rec.length := 1;
249: l_attr_rec.name := 'enabled';
247: l_attr_rec.type := 'VARCHAR2';
248: l_attr_rec.length := 1;
249: l_attr_rec.name := 'enabled';
250: l_attr_rec.code := 'enabled_flag';
251: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
252: l_attr_rec.value := TRUE;
253: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
254:
255: I := I + 1;
249: l_attr_rec.name := 'enabled';
250: l_attr_rec.code := 'enabled_flag';
251: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
252: l_attr_rec.value := TRUE;
253: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
254:
255: I := I + 1;
256: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
257: l_attr_rec.column := 'LAST_UPDATED_BY';
252: l_attr_rec.value := TRUE;
253: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
254:
255: I := I + 1;
256: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
257: l_attr_rec.column := 'LAST_UPDATED_BY';
258: l_attr_rec.type := 'NUMBER';
259: l_attr_rec.name := 'last_updated_by';
260: l_attr_rec.code := 'last_updated_by';
257: l_attr_rec.column := 'LAST_UPDATED_BY';
258: l_attr_rec.type := 'NUMBER';
259: l_attr_rec.name := 'last_updated_by';
260: l_attr_rec.code := 'last_updated_by';
261: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
262: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
263:
264: I := I + 1;
265: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
258: l_attr_rec.type := 'NUMBER';
259: l_attr_rec.name := 'last_updated_by';
260: l_attr_rec.code := 'last_updated_by';
261: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
262: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
263:
264: I := I + 1;
265: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
266: l_attr_rec.column := 'LAST_UPDATE_DATE';
261: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
262: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
263:
264: I := I + 1;
265: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
266: l_attr_rec.column := 'LAST_UPDATE_DATE';
267: l_attr_rec.type := 'DATE';
268: l_attr_rec.name := 'last_update_date';
269: l_attr_rec.code := 'last_update_date';
266: l_attr_rec.column := 'LAST_UPDATE_DATE';
267: l_attr_rec.type := 'DATE';
268: l_attr_rec.name := 'last_update_date';
269: l_attr_rec.code := 'last_update_date';
270: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
271: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
272:
273: I := I + 1;
274: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
267: l_attr_rec.type := 'DATE';
268: l_attr_rec.name := 'last_update_date';
269: l_attr_rec.code := 'last_update_date';
270: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
271: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
272:
273: I := I + 1;
274: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
275: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
270: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
271: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
272:
273: I := I + 1;
274: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
275: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
276: l_attr_rec.type := 'NUMBER';
277: l_attr_rec.name := 'last_update_login';
278: l_attr_rec.code := 'last_update_login';
275: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
276: l_attr_rec.type := 'NUMBER';
277: l_attr_rec.name := 'last_update_login';
278: l_attr_rec.code := 'last_update_login';
279: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
280: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
281:
282: I := I + 1;
283: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
276: l_attr_rec.type := 'NUMBER';
277: l_attr_rec.name := 'last_update_login';
278: l_attr_rec.code := 'last_update_login';
279: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
280: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
281:
282: I := I + 1;
283: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
284: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
279: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
280: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
281:
282: I := I + 1;
283: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
284: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
285: l_attr_rec.type := 'NUMBER';
286: l_attr_rec.name := 'program_application';
287: l_attr_rec.code := 'program_application_id';
284: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
285: l_attr_rec.type := 'NUMBER';
286: l_attr_rec.name := 'program_application';
287: l_attr_rec.code := 'program_application_id';
288: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
289: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
290:
291: I := I + 1;
292: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
285: l_attr_rec.type := 'NUMBER';
286: l_attr_rec.name := 'program_application';
287: l_attr_rec.code := 'program_application_id';
288: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
289: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
290:
291: I := I + 1;
292: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
293: l_attr_rec.column := 'PROGRAM_ID';
288: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
289: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
290:
291: I := I + 1;
292: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
293: l_attr_rec.column := 'PROGRAM_ID';
294: l_attr_rec.type := 'NUMBER';
295: l_attr_rec.name := 'program';
296: l_attr_rec.code := 'program_id';
293: l_attr_rec.column := 'PROGRAM_ID';
294: l_attr_rec.type := 'NUMBER';
295: l_attr_rec.name := 'program';
296: l_attr_rec.code := 'program_id';
297: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
298: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
299:
300: I := I + 1;
301: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
294: l_attr_rec.type := 'NUMBER';
295: l_attr_rec.name := 'program';
296: l_attr_rec.code := 'program_id';
297: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
298: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
299:
300: I := I + 1;
301: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
302: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
297: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
298: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
299:
300: I := I + 1;
301: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
302: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
303: l_attr_rec.type := 'DATE';
304: l_attr_rec.name := 'program_update_date';
305: l_attr_rec.code := 'program_update_date';
302: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
303: l_attr_rec.type := 'DATE';
304: l_attr_rec.name := 'program_update_date';
305: l_attr_rec.code := 'program_update_date';
306: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
307: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
308:
309: I := I + 1;
310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
303: l_attr_rec.type := 'DATE';
304: l_attr_rec.name := 'program_update_date';
305: l_attr_rec.code := 'program_update_date';
306: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
307: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
308:
309: I := I + 1;
310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
311: l_attr_rec.column := 'REQUEST_TYPE_CODE';
306: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
307: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
308:
309: I := I + 1;
310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
311: l_attr_rec.column := 'REQUEST_TYPE_CODE';
312: l_attr_rec.type := 'VARCHAR2';
313: l_attr_rec.length := 30;
314: l_attr_rec.name := 'request_type';
312: l_attr_rec.type := 'VARCHAR2';
313: l_attr_rec.length := 30;
314: l_attr_rec.name := 'request_type';
315: l_attr_rec.code := 'request_type_code';
316: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
317: l_attr_rec.value := TRUE;
318: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
319:
320: I := I + 1;
314: l_attr_rec.name := 'request_type';
315: l_attr_rec.code := 'request_type_code';
316: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
317: l_attr_rec.value := TRUE;
318: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
319:
320: I := I + 1;
321: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
322: l_attr_rec.column := 'SEEDED_FLAG';
317: l_attr_rec.value := TRUE;
318: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
319:
320: I := I + 1;
321: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
322: l_attr_rec.column := 'SEEDED_FLAG';
323: l_attr_rec.type := 'VARCHAR2';
324: l_attr_rec.length := 1;
325: l_attr_rec.name := 'seeded';
323: l_attr_rec.type := 'VARCHAR2';
324: l_attr_rec.length := 1;
325: l_attr_rec.name := 'seeded';
326: l_attr_rec.code := 'seeded_flag';
327: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
328: l_attr_rec.value := TRUE;
329: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
330:
331: I := I + 1;
325: l_attr_rec.name := 'seeded';
326: l_attr_rec.code := 'seeded_flag';
327: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
328: l_attr_rec.value := TRUE;
329: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
330:
331: I := I + 1;
332: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
333: l_attr_rec.column := 'SEEDED_SOURCING_TYPE';
328: l_attr_rec.value := TRUE;
329: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
330:
331: I := I + 1;
332: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
333: l_attr_rec.column := 'SEEDED_SOURCING_TYPE';
334: l_attr_rec.type := 'VARCHAR2';
335: l_attr_rec.length := 30;
336: l_attr_rec.name := 'seeded_sourcing_type';
334: l_attr_rec.type := 'VARCHAR2';
335: l_attr_rec.length := 30;
336: l_attr_rec.name := 'seeded_sourcing_type';
337: l_attr_rec.code := 'seeded_sourcing_type';
338: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
339: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
340:
341: I := I + 1;
342: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
335: l_attr_rec.length := 30;
336: l_attr_rec.name := 'seeded_sourcing_type';
337: l_attr_rec.code := 'seeded_sourcing_type';
338: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
339: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
340:
341: I := I + 1;
342: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
343: l_attr_rec.column := 'SEEDED_VALUE_STRING';
338: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
339: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
340:
341: I := I + 1;
342: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
343: l_attr_rec.column := 'SEEDED_VALUE_STRING';
344: l_attr_rec.type := 'VARCHAR2';
345: l_attr_rec.length := 2000;
346: l_attr_rec.name := 'seeded_value_string';
344: l_attr_rec.type := 'VARCHAR2';
345: l_attr_rec.length := 2000;
346: l_attr_rec.name := 'seeded_value_string';
347: l_attr_rec.code := 'seeded_value_string';
348: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
349: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
350:
351: I := I + 1;
352: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
345: l_attr_rec.length := 2000;
346: l_attr_rec.name := 'seeded_value_string';
347: l_attr_rec.code := 'seeded_value_string';
348: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
349: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
350:
351: I := I + 1;
352: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
353: l_attr_rec.column := 'SEGMENT_ID';
348: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
349: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
350:
351: I := I + 1;
352: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
353: l_attr_rec.column := 'SEGMENT_ID';
354: l_attr_rec.type := 'NUMBER';
355: l_attr_rec.name := 'segment';
356: l_attr_rec.code := 'segment_id';
353: l_attr_rec.column := 'SEGMENT_ID';
354: l_attr_rec.type := 'NUMBER';
355: l_attr_rec.name := 'segment';
356: l_attr_rec.code := 'segment_id';
357: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
358: l_attr_rec.value := TRUE;
359: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
360:
361: I := I + 1;
355: l_attr_rec.name := 'segment';
356: l_attr_rec.code := 'segment_id';
357: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
358: l_attr_rec.value := TRUE;
359: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
360:
361: I := I + 1;
362: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
363: l_attr_rec.column := 'USER_SOURCING_TYPE';
358: l_attr_rec.value := TRUE;
359: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
360:
361: I := I + 1;
362: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
363: l_attr_rec.column := 'USER_SOURCING_TYPE';
364: l_attr_rec.type := 'VARCHAR2';
365: l_attr_rec.length := 30;
366: l_attr_rec.name := 'user_sourcing_type';
364: l_attr_rec.type := 'VARCHAR2';
365: l_attr_rec.length := 30;
366: l_attr_rec.name := 'user_sourcing_type';
367: l_attr_rec.code := 'user_sourcing_type';
368: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
369: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
370:
371: I := I + 1;
372: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
365: l_attr_rec.length := 30;
366: l_attr_rec.name := 'user_sourcing_type';
367: l_attr_rec.code := 'user_sourcing_type';
368: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
369: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
370:
371: I := I + 1;
372: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
373: l_attr_rec.column := 'USER_VALUE_STRING';
368: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
369: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
370:
371: I := I + 1;
372: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
373: l_attr_rec.column := 'USER_VALUE_STRING';
374: l_attr_rec.type := 'VARCHAR2';
375: l_attr_rec.length := 2000;
376: l_attr_rec.name := 'user_value_string';
374: l_attr_rec.type := 'VARCHAR2';
375: l_attr_rec.length := 2000;
376: l_attr_rec.name := 'user_value_string';
377: l_attr_rec.code := 'user_value_string';
378: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
379: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
380:
381: I := I + 1;
382: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
375: l_attr_rec.length := 2000;
376: l_attr_rec.name := 'user_value_string';
377: l_attr_rec.code := 'user_value_string';
378: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
379: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
380:
381: I := I + 1;
382: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
383: l_attr_rec.type := 'VARCHAR2';
378: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
379: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
380:
381: I := I + 1;
382: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
383: l_attr_rec.type := 'VARCHAR2';
384: l_attr_rec.length := 1;
385: l_attr_rec.name := 'return_status';
386: l_attr_rec.code := 'return_status';
384: l_attr_rec.length := 1;
385: l_attr_rec.name := 'return_status';
386: l_attr_rec.code := 'return_status';
387: l_attr_rec.db_attr := FALSE;
388: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
389: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
390:
391: I := I + 1;
392: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
385: l_attr_rec.name := 'return_status';
386: l_attr_rec.code := 'return_status';
387: l_attr_rec.db_attr := FALSE;
388: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
389: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
390:
391: I := I + 1;
392: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
393: l_attr_rec.type := 'VARCHAR2';
388: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
389: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
390:
391: I := I + 1;
392: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
393: l_attr_rec.type := 'VARCHAR2';
394: l_attr_rec.length := 1;
395: l_attr_rec.name := 'db_flag';
396: l_attr_rec.code := 'db_flag';
394: l_attr_rec.length := 1;
395: l_attr_rec.name := 'db_flag';
396: l_attr_rec.code := 'db_flag';
397: l_attr_rec.db_attr := FALSE;
398: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
399: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
400:
401: I := I + 1;
402: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
395: l_attr_rec.name := 'db_flag';
396: l_attr_rec.code := 'db_flag';
397: l_attr_rec.db_attr := FALSE;
398: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
399: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
400:
401: I := I + 1;
402: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
403: l_attr_rec.type := 'VARCHAR2';
398: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
399: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
400:
401: I := I + 1;
402: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
403: l_attr_rec.type := 'VARCHAR2';
404: l_attr_rec.length := 30;
405: l_attr_rec.name := 'operation';
406: l_attr_rec.code := 'operation';
404: l_attr_rec.length := 30;
405: l_attr_rec.name := 'operation';
406: l_attr_rec.code := 'operation';
407: l_attr_rec.db_attr := FALSE;
408: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
409: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
410:
411: I := I + 1;
412: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
405: l_attr_rec.name := 'operation';
406: l_attr_rec.code := 'operation';
407: l_attr_rec.db_attr := FALSE;
408: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
409: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
410:
411: I := I + 1;
412: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
413: l_attr_rec.type := 'NUMBER';
408: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
409: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
410:
411: I := I + 1;
412: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
413: l_attr_rec.type := 'NUMBER';
414: l_attr_rec.name := 'PSG_index';
415: l_attr_rec.code := 'PSG_index';
416: l_attr_rec.db_attr := FALSE;
413: l_attr_rec.type := 'NUMBER';
414: l_attr_rec.name := 'PSG_index';
415: l_attr_rec.code := 'PSG_index';
416: l_attr_rec.db_attr := FALSE;
417: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
418: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
419:
420: END Get_Attr_Tbl;
421:
414: l_attr_rec.name := 'PSG_index';
415: l_attr_rec.code := 'PSG_index';
416: l_attr_rec.db_attr := FALSE;
417: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
418: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
419:
420: END Get_Attr_Tbl;
421:
422: -- Procedure : Get_Attr_Value_Tbl
422: -- Procedure : Get_Attr_Value_Tbl
423:
424: PROCEDURE Get_Attr_Value_Tbl
425: IS
426: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
427: I NUMBER := 0;
428: BEGIN
429:
430: OE_GENERATE.g_attr_value_tbl.DELETE;
426: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
427: I NUMBER := 0;
428: BEGIN
429:
430: OE_GENERATE.g_attr_value_tbl.DELETE;
431:
432: -- Load attribute values
433:
434: I := I + 1;
431:
432: -- Load attribute values
433:
434: I := I + 1;
435: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
436: l_attr_rec.name := 'attribute_sourcing';
437: l_attr_rec.code := 'attribute_sourcing_id';
438: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
439: l_attr_rec.length := 240;
434: I := I + 1;
435: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
436: l_attr_rec.name := 'attribute_sourcing';
437: l_attr_rec.code := 'attribute_sourcing_id';
438: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
439: l_attr_rec.length := 240;
440: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
441: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
442:
436: l_attr_rec.name := 'attribute_sourcing';
437: l_attr_rec.code := 'attribute_sourcing_id';
438: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
439: l_attr_rec.length := 240;
440: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
441: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
442:
443: I := I + 1;
444: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
437: l_attr_rec.code := 'attribute_sourcing_id';
438: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
439: l_attr_rec.length := 240;
440: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
441: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
442:
443: I := I + 1;
444: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
445: l_attr_rec.name := 'enabled';
440: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
441: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
442:
443: I := I + 1;
444: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
445: l_attr_rec.name := 'enabled';
446: l_attr_rec.code := 'enabled_flag';
447: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
448: l_attr_rec.length := 240;
443: I := I + 1;
444: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
445: l_attr_rec.name := 'enabled';
446: l_attr_rec.code := 'enabled_flag';
447: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
448: l_attr_rec.length := 240;
449: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
450: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
451:
445: l_attr_rec.name := 'enabled';
446: l_attr_rec.code := 'enabled_flag';
447: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
448: l_attr_rec.length := 240;
449: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
450: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
451:
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
446: l_attr_rec.code := 'enabled_flag';
447: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
448: l_attr_rec.length := 240;
449: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
450: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
451:
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
454: l_attr_rec.name := 'request_type';
449: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
450: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
451:
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
454: l_attr_rec.name := 'request_type';
455: l_attr_rec.code := 'request_type_code';
456: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
457: l_attr_rec.length := 240;
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
454: l_attr_rec.name := 'request_type';
455: l_attr_rec.code := 'request_type_code';
456: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
457: l_attr_rec.length := 240;
458: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
459: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
460:
454: l_attr_rec.name := 'request_type';
455: l_attr_rec.code := 'request_type_code';
456: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
457: l_attr_rec.length := 240;
458: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
459: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
460:
461: I := I + 1;
462: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
455: l_attr_rec.code := 'request_type_code';
456: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
457: l_attr_rec.length := 240;
458: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
459: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
460:
461: I := I + 1;
462: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
463: l_attr_rec.name := 'seeded';
458: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
459: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
460:
461: I := I + 1;
462: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
463: l_attr_rec.name := 'seeded';
464: l_attr_rec.code := 'seeded_flag';
465: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
466: l_attr_rec.length := 240;
461: I := I + 1;
462: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
463: l_attr_rec.name := 'seeded';
464: l_attr_rec.code := 'seeded_flag';
465: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
466: l_attr_rec.length := 240;
467: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
468: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
469:
463: l_attr_rec.name := 'seeded';
464: l_attr_rec.code := 'seeded_flag';
465: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
466: l_attr_rec.length := 240;
467: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
468: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
469:
470: I := I + 1;
471: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
464: l_attr_rec.code := 'seeded_flag';
465: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
466: l_attr_rec.length := 240;
467: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
468: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
469:
470: I := I + 1;
471: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
472: l_attr_rec.name := 'segment';
467: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
468: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
469:
470: I := I + 1;
471: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
472: l_attr_rec.name := 'segment';
473: l_attr_rec.code := 'segment_id';
474: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
475: l_attr_rec.length := 240;
470: I := I + 1;
471: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
472: l_attr_rec.name := 'segment';
473: l_attr_rec.code := 'segment_id';
474: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
475: l_attr_rec.length := 240;
476: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
477: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
478:
472: l_attr_rec.name := 'segment';
473: l_attr_rec.code := 'segment_id';
474: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
475: l_attr_rec.length := 240;
476: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
477: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
478:
479: I := I + 1;
480: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
473: l_attr_rec.code := 'segment_id';
474: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
475: l_attr_rec.length := 240;
476: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
477: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
478:
479: I := I + 1;
480: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
481: l_attr_rec.type := 'NUMBER';
476: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
477: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
478:
479: I := I + 1;
480: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
481: l_attr_rec.type := 'NUMBER';
482: l_attr_rec.name := 'PSG_index';
483: l_attr_rec.code := 'PSG_index';
484: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
480: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
481: l_attr_rec.type := 'NUMBER';
482: l_attr_rec.name := 'PSG_index';
483: l_attr_rec.code := 'PSG_index';
484: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
485: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
486:
487: END Get_Attr_Value_Tbl;
488:
481: l_attr_rec.type := 'NUMBER';
482: l_attr_rec.name := 'PSG_index';
483: l_attr_rec.code := 'PSG_index';
484: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
485: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
486:
487: END Get_Attr_Value_Tbl;
488:
489: END QP_SOU_ATTR;