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 := 150;
25: l_attr_rec.name := 'attribute1';
23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
36: l_attr_rec.name := 'attribute10';
34: l_attr_rec.type := 'VARCHAR2';
35: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
47: l_attr_rec.name := 'attribute11';
45: l_attr_rec.type := 'VARCHAR2';
46: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
58: l_attr_rec.name := 'attribute12';
56: l_attr_rec.type := 'VARCHAR2';
57: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
69: l_attr_rec.name := 'attribute13';
67: l_attr_rec.type := 'VARCHAR2';
68: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
80: l_attr_rec.name := 'attribute14';
78: l_attr_rec.type := 'VARCHAR2';
79: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
91: l_attr_rec.name := 'attribute15';
89: l_attr_rec.type := 'VARCHAR2';
90: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
102: l_attr_rec.name := 'attribute2';
100: l_attr_rec.type := 'VARCHAR2';
101: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
113: l_attr_rec.name := 'attribute3';
111: l_attr_rec.type := 'VARCHAR2';
112: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
124: l_attr_rec.name := 'attribute4';
122: l_attr_rec.type := 'VARCHAR2';
123: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
135: l_attr_rec.name := 'attribute5';
133: l_attr_rec.type := 'VARCHAR2';
134: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
146: l_attr_rec.name := 'attribute6';
144: l_attr_rec.type := 'VARCHAR2';
145: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
157: l_attr_rec.name := 'attribute7';
155: l_attr_rec.type := 'VARCHAR2';
156: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
168: l_attr_rec.name := 'attribute8';
166: l_attr_rec.type := 'VARCHAR2';
167: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 150;
179: l_attr_rec.name := 'attribute9';
177: l_attr_rec.type := 'VARCHAR2';
178: l_attr_rec.length := 150;
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 := 'HEADER_ADJ';
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 := 'HEADER_ADJ';
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 := 'AUTOMATIC_FLAG';
182: l_attr_rec.text1 := 'HEADER_ADJ';
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 := 'AUTOMATIC_FLAG';
188: l_attr_rec.type := 'VARCHAR2';
189: l_attr_rec.length := 1;
190: l_attr_rec.name := 'automatic';
188: l_attr_rec.type := 'VARCHAR2';
189: l_attr_rec.length := 1;
190: l_attr_rec.name := 'automatic';
191: l_attr_rec.code := 'automatic_flag';
192: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
193: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
194:
195: I := I + 1;
196: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
189: l_attr_rec.length := 1;
190: l_attr_rec.name := 'automatic';
191: l_attr_rec.code := 'automatic_flag';
192: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
193: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
194:
195: I := I + 1;
196: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
197: l_attr_rec.column := 'CONTEXT';
192: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
193: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
194:
195: I := I + 1;
196: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
197: l_attr_rec.column := 'CONTEXT';
198: l_attr_rec.type := 'VARCHAR2';
199: l_attr_rec.length := 30;
200: l_attr_rec.name := 'context';
198: l_attr_rec.type := 'VARCHAR2';
199: l_attr_rec.length := 30;
200: l_attr_rec.name := 'context';
201: l_attr_rec.code := 'context';
202: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
203: l_attr_rec.text1 := 'HEADER_ADJ';
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
200: l_attr_rec.name := 'context';
201: l_attr_rec.code := 'context';
202: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
203: l_attr_rec.text1 := 'HEADER_ADJ';
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 := 'CREATED_BY';
203: l_attr_rec.text1 := 'HEADER_ADJ';
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 := 'CREATED_BY';
209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'created_by';
211: l_attr_rec.code := 'created_by';
208: l_attr_rec.column := 'CREATED_BY';
209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'created_by';
211: l_attr_rec.code := 'created_by';
212: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'created_by';
211: l_attr_rec.code := 'created_by';
212: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'CREATION_DATE';
212: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'CREATION_DATE';
218: l_attr_rec.type := 'DATE';
219: l_attr_rec.name := 'creation_date';
220: l_attr_rec.code := 'creation_date';
217: l_attr_rec.column := 'CREATION_DATE';
218: l_attr_rec.type := 'DATE';
219: l_attr_rec.name := 'creation_date';
220: l_attr_rec.code := 'creation_date';
221: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
222: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
223:
224: I := I + 1;
225: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
218: l_attr_rec.type := 'DATE';
219: l_attr_rec.name := 'creation_date';
220: l_attr_rec.code := 'creation_date';
221: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
222: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
223:
224: I := I + 1;
225: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
226: l_attr_rec.column := 'DISCOUNT_ID';
221: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
222: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
223:
224: I := I + 1;
225: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
226: l_attr_rec.column := 'DISCOUNT_ID';
227: l_attr_rec.type := 'NUMBER';
228: l_attr_rec.name := 'discount';
229: l_attr_rec.code := 'discount_id';
226: l_attr_rec.column := 'DISCOUNT_ID';
227: l_attr_rec.type := 'NUMBER';
228: l_attr_rec.name := 'discount';
229: l_attr_rec.code := 'discount_id';
230: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
231: l_attr_rec.value := TRUE;
232: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
233:
234: I := I + 1;
228: l_attr_rec.name := 'discount';
229: l_attr_rec.code := 'discount_id';
230: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
231: l_attr_rec.value := TRUE;
232: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
233:
234: I := I + 1;
235: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
236: l_attr_rec.column := 'DISCOUNT_LINE_ID';
231: l_attr_rec.value := TRUE;
232: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
233:
234: I := I + 1;
235: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
236: l_attr_rec.column := 'DISCOUNT_LINE_ID';
237: l_attr_rec.type := 'NUMBER';
238: l_attr_rec.name := 'discount_line';
239: l_attr_rec.code := 'discount_line_id';
236: l_attr_rec.column := 'DISCOUNT_LINE_ID';
237: l_attr_rec.type := 'NUMBER';
238: l_attr_rec.name := 'discount_line';
239: l_attr_rec.code := 'discount_line_id';
240: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
241: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
242:
243: I := I + 1;
244: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
237: l_attr_rec.type := 'NUMBER';
238: l_attr_rec.name := 'discount_line';
239: l_attr_rec.code := 'discount_line_id';
240: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
241: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
242:
243: I := I + 1;
244: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
245: l_attr_rec.column := 'HEADER_ID';
240: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
241: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
242:
243: I := I + 1;
244: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
245: l_attr_rec.column := 'HEADER_ID';
246: l_attr_rec.type := 'NUMBER';
247: l_attr_rec.name := 'header';
248: l_attr_rec.code := 'header_id';
245: l_attr_rec.column := 'HEADER_ID';
246: l_attr_rec.type := 'NUMBER';
247: l_attr_rec.name := 'header';
248: l_attr_rec.code := 'header_id';
249: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
250: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
251:
252: I := I + 1;
253: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
246: l_attr_rec.type := 'NUMBER';
247: l_attr_rec.name := 'header';
248: l_attr_rec.code := 'header_id';
249: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
250: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
251:
252: I := I + 1;
253: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
254: l_attr_rec.column := 'LAST_UPDATED_BY';
249: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
250: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
251:
252: I := I + 1;
253: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
254: l_attr_rec.column := 'LAST_UPDATED_BY';
255: l_attr_rec.type := 'NUMBER';
256: l_attr_rec.name := 'last_updated_by';
257: l_attr_rec.code := 'last_updated_by';
254: l_attr_rec.column := 'LAST_UPDATED_BY';
255: l_attr_rec.type := 'NUMBER';
256: l_attr_rec.name := 'last_updated_by';
257: l_attr_rec.code := 'last_updated_by';
258: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
259: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
260:
261: I := I + 1;
262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
255: l_attr_rec.type := 'NUMBER';
256: l_attr_rec.name := 'last_updated_by';
257: l_attr_rec.code := 'last_updated_by';
258: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
259: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
260:
261: I := I + 1;
262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
263: l_attr_rec.column := 'LAST_UPDATE_DATE';
258: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
259: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
260:
261: I := I + 1;
262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
263: l_attr_rec.column := 'LAST_UPDATE_DATE';
264: l_attr_rec.type := 'DATE';
265: l_attr_rec.name := 'last_update_date';
266: l_attr_rec.code := 'last_update_date';
263: l_attr_rec.column := 'LAST_UPDATE_DATE';
264: l_attr_rec.type := 'DATE';
265: l_attr_rec.name := 'last_update_date';
266: l_attr_rec.code := 'last_update_date';
267: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
268: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
269:
270: I := I + 1;
271: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
264: l_attr_rec.type := 'DATE';
265: l_attr_rec.name := 'last_update_date';
266: l_attr_rec.code := 'last_update_date';
267: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
268: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
269:
270: I := I + 1;
271: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
272: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
267: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
268: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
269:
270: I := I + 1;
271: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
272: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
273: l_attr_rec.type := 'NUMBER';
274: l_attr_rec.name := 'last_update_login';
275: l_attr_rec.code := 'last_update_login';
272: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
273: l_attr_rec.type := 'NUMBER';
274: l_attr_rec.name := 'last_update_login';
275: l_attr_rec.code := 'last_update_login';
276: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
277: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
278:
279: I := I + 1;
280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
273: l_attr_rec.type := 'NUMBER';
274: l_attr_rec.name := 'last_update_login';
275: l_attr_rec.code := 'last_update_login';
276: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
277: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
278:
279: I := I + 1;
280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
281: l_attr_rec.column := 'LINE_ID';
276: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
277: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
278:
279: I := I + 1;
280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
281: l_attr_rec.column := 'LINE_ID';
282: l_attr_rec.type := 'NUMBER';
283: l_attr_rec.name := 'line';
284: l_attr_rec.code := 'line_id';
281: l_attr_rec.column := 'LINE_ID';
282: l_attr_rec.type := 'NUMBER';
283: l_attr_rec.name := 'line';
284: l_attr_rec.code := 'line_id';
285: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
286: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
287:
288: I := I + 1;
289: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
282: l_attr_rec.type := 'NUMBER';
283: l_attr_rec.name := 'line';
284: l_attr_rec.code := 'line_id';
285: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
286: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
287:
288: I := I + 1;
289: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
290: l_attr_rec.column := 'PERCENT';
285: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
286: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
287:
288: I := I + 1;
289: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
290: l_attr_rec.column := 'PERCENT';
291: l_attr_rec.type := 'NUMBER';
292: l_attr_rec.name := 'percent';
293: l_attr_rec.code := 'percent';
290: l_attr_rec.column := 'PERCENT';
291: l_attr_rec.type := 'NUMBER';
292: l_attr_rec.name := 'percent';
293: l_attr_rec.code := 'percent';
294: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
295: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
296:
297: I := I + 1;
298: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
291: l_attr_rec.type := 'NUMBER';
292: l_attr_rec.name := 'percent';
293: l_attr_rec.code := 'percent';
294: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
295: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
296:
297: I := I + 1;
298: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
299: l_attr_rec.column := 'PRICE_ADJUSTMENT_ID';
294: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
295: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
296:
297: I := I + 1;
298: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
299: l_attr_rec.column := 'PRICE_ADJUSTMENT_ID';
300: l_attr_rec.type := 'NUMBER';
301: l_attr_rec.name := 'price_adjustment';
302: l_attr_rec.code := 'price_adjustment_id';
299: l_attr_rec.column := 'PRICE_ADJUSTMENT_ID';
300: l_attr_rec.type := 'NUMBER';
301: l_attr_rec.name := 'price_adjustment';
302: l_attr_rec.code := 'price_adjustment_id';
303: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
304: l_attr_rec.pk_flag := TRUE;
305: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
306:
307: I := I + 1;
301: l_attr_rec.name := 'price_adjustment';
302: l_attr_rec.code := 'price_adjustment_id';
303: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
304: l_attr_rec.pk_flag := TRUE;
305: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
306:
307: I := I + 1;
308: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
309: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
304: l_attr_rec.pk_flag := TRUE;
305: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
306:
307: I := I + 1;
308: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
309: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
310: l_attr_rec.type := 'NUMBER';
311: l_attr_rec.name := 'program_application';
312: l_attr_rec.code := 'program_application_id';
309: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
310: l_attr_rec.type := 'NUMBER';
311: l_attr_rec.name := 'program_application';
312: l_attr_rec.code := 'program_application_id';
313: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
314: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
315:
316: I := I + 1;
317: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
310: l_attr_rec.type := 'NUMBER';
311: l_attr_rec.name := 'program_application';
312: l_attr_rec.code := 'program_application_id';
313: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
314: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
315:
316: I := I + 1;
317: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
318: l_attr_rec.column := 'PROGRAM_ID';
313: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
314: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
315:
316: I := I + 1;
317: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
318: l_attr_rec.column := 'PROGRAM_ID';
319: l_attr_rec.type := 'NUMBER';
320: l_attr_rec.name := 'program';
321: l_attr_rec.code := 'program_id';
318: l_attr_rec.column := 'PROGRAM_ID';
319: l_attr_rec.type := 'NUMBER';
320: l_attr_rec.name := 'program';
321: l_attr_rec.code := 'program_id';
322: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
323: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
324:
325: I := I + 1;
326: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
319: l_attr_rec.type := 'NUMBER';
320: l_attr_rec.name := 'program';
321: l_attr_rec.code := 'program_id';
322: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
323: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
324:
325: I := I + 1;
326: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
327: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
322: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
323: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
324:
325: I := I + 1;
326: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
327: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
328: l_attr_rec.type := 'DATE';
329: l_attr_rec.name := 'program_update_date';
330: l_attr_rec.code := 'program_update_date';
327: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
328: l_attr_rec.type := 'DATE';
329: l_attr_rec.name := 'program_update_date';
330: l_attr_rec.code := 'program_update_date';
331: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
332: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
333:
334: I := I + 1;
335: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
328: l_attr_rec.type := 'DATE';
329: l_attr_rec.name := 'program_update_date';
330: l_attr_rec.code := 'program_update_date';
331: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
332: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
333:
334: I := I + 1;
335: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
336: l_attr_rec.column := 'REQUEST_ID';
331: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
332: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
333:
334: I := I + 1;
335: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
336: l_attr_rec.column := 'REQUEST_ID';
337: l_attr_rec.type := 'NUMBER';
338: l_attr_rec.name := 'request';
339: l_attr_rec.code := 'request_id';
336: l_attr_rec.column := 'REQUEST_ID';
337: l_attr_rec.type := 'NUMBER';
338: l_attr_rec.name := 'request';
339: l_attr_rec.code := 'request_id';
340: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
341: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
342:
343: I := I + 1;
344: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
337: l_attr_rec.type := 'NUMBER';
338: l_attr_rec.name := 'request';
339: l_attr_rec.code := 'request_id';
340: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
341: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
342:
343: I := I + 1;
344: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
345: l_attr_rec.type := 'VARCHAR2';
340: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
341: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
342:
343: I := I + 1;
344: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
345: l_attr_rec.type := 'VARCHAR2';
346: l_attr_rec.length := 1;
347: l_attr_rec.name := 'return_status';
348: l_attr_rec.code := 'return_status';
346: l_attr_rec.length := 1;
347: l_attr_rec.name := 'return_status';
348: l_attr_rec.code := 'return_status';
349: l_attr_rec.db_attr := FALSE;
350: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
351: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
352:
353: I := I + 1;
354: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
347: l_attr_rec.name := 'return_status';
348: l_attr_rec.code := 'return_status';
349: l_attr_rec.db_attr := FALSE;
350: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
351: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
352:
353: I := I + 1;
354: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
355: l_attr_rec.type := 'VARCHAR2';
350: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
351: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
352:
353: I := I + 1;
354: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
355: l_attr_rec.type := 'VARCHAR2';
356: l_attr_rec.length := 1;
357: l_attr_rec.name := 'db_flag';
358: l_attr_rec.code := 'db_flag';
356: l_attr_rec.length := 1;
357: l_attr_rec.name := 'db_flag';
358: l_attr_rec.code := 'db_flag';
359: l_attr_rec.db_attr := FALSE;
360: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
361: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
362:
363: I := I + 1;
364: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
357: l_attr_rec.name := 'db_flag';
358: l_attr_rec.code := 'db_flag';
359: l_attr_rec.db_attr := FALSE;
360: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
361: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
362:
363: I := I + 1;
364: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
365: l_attr_rec.type := 'VARCHAR2';
360: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
361: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
362:
363: I := I + 1;
364: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
365: l_attr_rec.type := 'VARCHAR2';
366: l_attr_rec.length := 30;
367: l_attr_rec.name := 'operation';
368: l_attr_rec.code := 'operation';
366: l_attr_rec.length := 30;
367: l_attr_rec.name := 'operation';
368: l_attr_rec.code := 'operation';
369: l_attr_rec.db_attr := FALSE;
370: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
371: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
372:
373: END Get_Attr_Tbl;
374:
367: l_attr_rec.name := 'operation';
368: l_attr_rec.code := 'operation';
369: l_attr_rec.db_attr := FALSE;
370: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
371: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
372:
373: END Get_Attr_Tbl;
374:
375: -- Procedure : Get_Attr_Value_Tbl
375: -- Procedure : Get_Attr_Value_Tbl
376:
377: PROCEDURE Get_Attr_Value_Tbl
378: IS
379: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
380: I NUMBER := 0;
381: BEGIN
382:
383: OE_GENERATE.g_attr_value_tbl.DELETE;
379: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
380: I NUMBER := 0;
381: BEGIN
382:
383: OE_GENERATE.g_attr_value_tbl.DELETE;
384:
385: -- Load attribute values
386:
387: I := I + 1;
384:
385: -- Load attribute values
386:
387: I := I + 1;
388: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
389: l_attr_rec.name := 'discount';
390: l_attr_rec.code := 'discount_id';
391: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
392: l_attr_rec.length := 240;
387: I := I + 1;
388: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
389: l_attr_rec.name := 'discount';
390: l_attr_rec.code := 'discount_id';
391: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
392: l_attr_rec.length := 240;
393: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
394: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
395:
389: l_attr_rec.name := 'discount';
390: l_attr_rec.code := 'discount_id';
391: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
392: l_attr_rec.length := 240;
393: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
394: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
395:
396:
397: END Get_Attr_Value_Tbl;
390: l_attr_rec.code := 'discount_id';
391: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
392: l_attr_rec.length := 240;
393: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
394: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
395:
396:
397: END Get_Attr_Value_Tbl;
398: