APPS.QP_PRICING_ATTR_ATTR_REN dependencies on OE_GENERATE

Line 12: l_attr_rec OE_GENERATE.Attribute_Rec_Type;

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;

Line 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;

Line 21: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

17:
18: -- Load attributes
19:
20: I := I + 1;
21: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
22: l_attr_rec.column := 'ACCUMULATE_FLAG';
23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 1;
25: l_attr_rec.name := 'accumulate';

Line 27: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 1;
25: l_attr_rec.name := 'accumulate';
26: l_attr_rec.code := 'accumulate_flag';
27: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
28: l_attr_rec.value := TRUE;
29: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
30:
31: I := I + 1;

Line 29: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

25: l_attr_rec.name := 'accumulate';
26: l_attr_rec.code := 'accumulate_flag';
27: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
28: l_attr_rec.value := TRUE;
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 := 'ATTRIBUTE1';

Line 32: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

28: l_attr_rec.value := TRUE;
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 := 'ATTRIBUTE1';
34: l_attr_rec.type := 'VARCHAR2';
35: l_attr_rec.length := 240;
36: l_attr_rec.name := 'attribute1';

Line 38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

34: l_attr_rec.type := 'VARCHAR2';
35: l_attr_rec.length := 240;
36: l_attr_rec.name := 'attribute1';
37: l_attr_rec.code := 'attribute1';
38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
39: l_attr_rec.text1 := 'PRICING_ATTR';
40: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
41:
42: I := I + 1;

Line 40: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

36: l_attr_rec.name := 'attribute1';
37: l_attr_rec.code := 'attribute1';
38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
39: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE10';

Line 43: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

39: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE10';
45: l_attr_rec.type := 'VARCHAR2';
46: l_attr_rec.length := 240;
47: l_attr_rec.name := 'attribute10';

Line 49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

45: l_attr_rec.type := 'VARCHAR2';
46: l_attr_rec.length := 240;
47: l_attr_rec.name := 'attribute10';
48: l_attr_rec.code := 'attribute10';
49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
50: l_attr_rec.text1 := 'PRICING_ATTR';
51: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
52:
53: I := I + 1;

Line 51: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

47: l_attr_rec.name := 'attribute10';
48: l_attr_rec.code := 'attribute10';
49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
50: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE11';

Line 54: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

50: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE11';
56: l_attr_rec.type := 'VARCHAR2';
57: l_attr_rec.length := 240;
58: l_attr_rec.name := 'attribute11';

Line 60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

56: l_attr_rec.type := 'VARCHAR2';
57: l_attr_rec.length := 240;
58: l_attr_rec.name := 'attribute11';
59: l_attr_rec.code := 'attribute11';
60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
61: l_attr_rec.text1 := 'PRICING_ATTR';
62: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
63:
64: I := I + 1;

Line 62: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

58: l_attr_rec.name := 'attribute11';
59: l_attr_rec.code := 'attribute11';
60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
61: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE12';

Line 65: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

61: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE12';
67: l_attr_rec.type := 'VARCHAR2';
68: l_attr_rec.length := 240;
69: l_attr_rec.name := 'attribute12';

Line 71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

67: l_attr_rec.type := 'VARCHAR2';
68: l_attr_rec.length := 240;
69: l_attr_rec.name := 'attribute12';
70: l_attr_rec.code := 'attribute12';
71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
72: l_attr_rec.text1 := 'PRICING_ATTR';
73: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
74:
75: I := I + 1;

Line 73: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

69: l_attr_rec.name := 'attribute12';
70: l_attr_rec.code := 'attribute12';
71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
72: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE13';

Line 76: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

72: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE13';
78: l_attr_rec.type := 'VARCHAR2';
79: l_attr_rec.length := 240;
80: l_attr_rec.name := 'attribute13';

Line 82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

78: l_attr_rec.type := 'VARCHAR2';
79: l_attr_rec.length := 240;
80: l_attr_rec.name := 'attribute13';
81: l_attr_rec.code := 'attribute13';
82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
83: l_attr_rec.text1 := 'PRICING_ATTR';
84: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
85:
86: I := I + 1;

Line 84: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

80: l_attr_rec.name := 'attribute13';
81: l_attr_rec.code := 'attribute13';
82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
83: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE14';

Line 87: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

83: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE14';
89: l_attr_rec.type := 'VARCHAR2';
90: l_attr_rec.length := 240;
91: l_attr_rec.name := 'attribute14';

Line 93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

89: l_attr_rec.type := 'VARCHAR2';
90: l_attr_rec.length := 240;
91: l_attr_rec.name := 'attribute14';
92: l_attr_rec.code := 'attribute14';
93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
94: l_attr_rec.text1 := 'PRICING_ATTR';
95: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
96:
97: I := I + 1;

Line 95: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

91: l_attr_rec.name := 'attribute14';
92: l_attr_rec.code := 'attribute14';
93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
94: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE15';

Line 98: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

94: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE15';
100: l_attr_rec.type := 'VARCHAR2';
101: l_attr_rec.length := 240;
102: l_attr_rec.name := 'attribute15';

Line 104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

100: l_attr_rec.type := 'VARCHAR2';
101: l_attr_rec.length := 240;
102: l_attr_rec.name := 'attribute15';
103: l_attr_rec.code := 'attribute15';
104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
105: l_attr_rec.text1 := 'PRICING_ATTR';
106: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
107:
108: I := I + 1;

Line 106: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

102: l_attr_rec.name := 'attribute15';
103: l_attr_rec.code := 'attribute15';
104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
105: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE2';

Line 109: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

105: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE2';
111: l_attr_rec.type := 'VARCHAR2';
112: l_attr_rec.length := 240;
113: l_attr_rec.name := 'attribute2';

Line 115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

111: l_attr_rec.type := 'VARCHAR2';
112: l_attr_rec.length := 240;
113: l_attr_rec.name := 'attribute2';
114: l_attr_rec.code := 'attribute2';
115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
116: l_attr_rec.text1 := 'PRICING_ATTR';
117: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
118:
119: I := I + 1;

Line 117: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

113: l_attr_rec.name := 'attribute2';
114: l_attr_rec.code := 'attribute2';
115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
116: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE3';

Line 120: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

116: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE3';
122: l_attr_rec.type := 'VARCHAR2';
123: l_attr_rec.length := 240;
124: l_attr_rec.name := 'attribute3';

Line 126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

122: l_attr_rec.type := 'VARCHAR2';
123: l_attr_rec.length := 240;
124: l_attr_rec.name := 'attribute3';
125: l_attr_rec.code := 'attribute3';
126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
127: l_attr_rec.text1 := 'PRICING_ATTR';
128: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
129:
130: I := I + 1;

Line 128: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

124: l_attr_rec.name := 'attribute3';
125: l_attr_rec.code := 'attribute3';
126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
127: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE4';

Line 131: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

127: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE4';
133: l_attr_rec.type := 'VARCHAR2';
134: l_attr_rec.length := 240;
135: l_attr_rec.name := 'attribute4';

Line 137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

133: l_attr_rec.type := 'VARCHAR2';
134: l_attr_rec.length := 240;
135: l_attr_rec.name := 'attribute4';
136: l_attr_rec.code := 'attribute4';
137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
138: l_attr_rec.text1 := 'PRICING_ATTR';
139: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
140:
141: I := I + 1;

Line 139: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

135: l_attr_rec.name := 'attribute4';
136: l_attr_rec.code := 'attribute4';
137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
138: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE5';

Line 142: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

138: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE5';
144: l_attr_rec.type := 'VARCHAR2';
145: l_attr_rec.length := 240;
146: l_attr_rec.name := 'attribute5';

Line 148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

144: l_attr_rec.type := 'VARCHAR2';
145: l_attr_rec.length := 240;
146: l_attr_rec.name := 'attribute5';
147: l_attr_rec.code := 'attribute5';
148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
149: l_attr_rec.text1 := 'PRICING_ATTR';
150: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
151:
152: I := I + 1;

Line 150: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

146: l_attr_rec.name := 'attribute5';
147: l_attr_rec.code := 'attribute5';
148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
149: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE6';

Line 153: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

149: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE6';
155: l_attr_rec.type := 'VARCHAR2';
156: l_attr_rec.length := 240;
157: l_attr_rec.name := 'attribute6';

Line 159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

155: l_attr_rec.type := 'VARCHAR2';
156: l_attr_rec.length := 240;
157: l_attr_rec.name := 'attribute6';
158: l_attr_rec.code := 'attribute6';
159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
160: l_attr_rec.text1 := 'PRICING_ATTR';
161: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
162:
163: I := I + 1;

Line 161: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

157: l_attr_rec.name := 'attribute6';
158: l_attr_rec.code := 'attribute6';
159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
160: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE7';

Line 164: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

160: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE7';
166: l_attr_rec.type := 'VARCHAR2';
167: l_attr_rec.length := 240;
168: l_attr_rec.name := 'attribute7';

Line 170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

166: l_attr_rec.type := 'VARCHAR2';
167: l_attr_rec.length := 240;
168: l_attr_rec.name := 'attribute7';
169: l_attr_rec.code := 'attribute7';
170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
171: l_attr_rec.text1 := 'PRICING_ATTR';
172: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
173:
174: I := I + 1;

Line 172: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

168: l_attr_rec.name := 'attribute7';
169: l_attr_rec.code := 'attribute7';
170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
171: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE8';

Line 175: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

171: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE8';
177: l_attr_rec.type := 'VARCHAR2';
178: l_attr_rec.length := 240;
179: l_attr_rec.name := 'attribute8';

Line 181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

177: l_attr_rec.type := 'VARCHAR2';
178: l_attr_rec.length := 240;
179: l_attr_rec.name := 'attribute8';
180: l_attr_rec.code := 'attribute8';
181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
182: l_attr_rec.text1 := 'PRICING_ATTR';
183: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
184:
185: I := I + 1;

Line 183: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

179: l_attr_rec.name := 'attribute8';
180: l_attr_rec.code := 'attribute8';
181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
182: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE9';

Line 186: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

182: l_attr_rec.text1 := 'PRICING_ATTR';
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 := 'ATTRIBUTE9';
188: l_attr_rec.type := 'VARCHAR2';
189: l_attr_rec.length := 240;
190: l_attr_rec.name := 'attribute9';

Line 192: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

188: l_attr_rec.type := 'VARCHAR2';
189: l_attr_rec.length := 240;
190: l_attr_rec.name := 'attribute9';
191: l_attr_rec.code := 'attribute9';
192: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
193: l_attr_rec.text1 := 'PRICING_ATTR';
194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
195:
196: I := I + 1;

Line 194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

190: l_attr_rec.name := 'attribute9';
191: l_attr_rec.code := 'attribute9';
192: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
193: l_attr_rec.text1 := 'PRICING_ATTR';
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_GROUPING_NO';

Line 197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

193: l_attr_rec.text1 := 'PRICING_ATTR';
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_GROUPING_NO';
199: l_attr_rec.type := 'NUMBER';
200: l_attr_rec.name := 'attribute_grouping_no';
201: l_attr_rec.code := 'attribute_grouping_no';

Line 202: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

198: l_attr_rec.column := 'ATTRIBUTE_GROUPING_NO';
199: l_attr_rec.type := 'NUMBER';
200: l_attr_rec.name := 'attribute_grouping_no';
201: l_attr_rec.code := 'attribute_grouping_no';
202: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
203: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
204:
205: I := I + 1;
206: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 203: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

199: l_attr_rec.type := 'NUMBER';
200: l_attr_rec.name := 'attribute_grouping_no';
201: l_attr_rec.code := 'attribute_grouping_no';
202: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
203: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
204:
205: I := I + 1;
206: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
207: l_attr_rec.column := 'CONTEXT';

Line 206: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

202: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
203: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
204:
205: I := I + 1;
206: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
207: l_attr_rec.column := 'CONTEXT';
208: l_attr_rec.type := 'VARCHAR2';
209: l_attr_rec.length := 30;
210: l_attr_rec.name := 'context';

Line 212: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;

208: l_attr_rec.type := 'VARCHAR2';
209: l_attr_rec.length := 30;
210: l_attr_rec.name := 'context';
211: l_attr_rec.code := 'context';
212: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
213: l_attr_rec.text1 := 'PRICING_ATTR';
214: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
215:
216: I := I + 1;

Line 214: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

210: l_attr_rec.name := 'context';
211: l_attr_rec.code := 'context';
212: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
213: l_attr_rec.text1 := 'PRICING_ATTR';
214: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
215:
216: I := I + 1;
217: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
218: l_attr_rec.column := 'CREATED_BY';

Line 217: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

213: l_attr_rec.text1 := 'PRICING_ATTR';
214: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
215:
216: I := I + 1;
217: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
218: l_attr_rec.column := 'CREATED_BY';
219: l_attr_rec.type := 'NUMBER';
220: l_attr_rec.name := 'created_by';
221: l_attr_rec.code := 'created_by';

Line 222: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

218: l_attr_rec.column := 'CREATED_BY';
219: l_attr_rec.type := 'NUMBER';
220: l_attr_rec.name := 'created_by';
221: l_attr_rec.code := 'created_by';
222: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
223: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
224:
225: I := I + 1;
226: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 223: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

219: l_attr_rec.type := 'NUMBER';
220: l_attr_rec.name := 'created_by';
221: l_attr_rec.code := 'created_by';
222: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
223: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
224:
225: I := I + 1;
226: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
227: l_attr_rec.column := 'CREATION_DATE';

Line 226: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

222: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
223: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
224:
225: I := I + 1;
226: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
227: l_attr_rec.column := 'CREATION_DATE';
228: l_attr_rec.type := 'DATE';
229: l_attr_rec.name := 'creation_date';
230: l_attr_rec.code := 'creation_date';

Line 231: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

227: l_attr_rec.column := 'CREATION_DATE';
228: l_attr_rec.type := 'DATE';
229: l_attr_rec.name := 'creation_date';
230: l_attr_rec.code := 'creation_date';
231: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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;

Line 232: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

228: l_attr_rec.type := 'DATE';
229: l_attr_rec.name := 'creation_date';
230: l_attr_rec.code := 'creation_date';
231: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'EXCLUDER_FLAG';

Line 235: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

231: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'EXCLUDER_FLAG';
237: l_attr_rec.type := 'VARCHAR2';
238: l_attr_rec.length := 1;
239: l_attr_rec.name := 'excluder';

Line 241: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

237: l_attr_rec.type := 'VARCHAR2';
238: l_attr_rec.length := 1;
239: l_attr_rec.name := 'excluder';
240: l_attr_rec.code := 'excluder_flag';
241: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
242: l_attr_rec.value := TRUE;
243: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
244:
245: I := I + 1;

Line 243: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

239: l_attr_rec.name := 'excluder';
240: l_attr_rec.code := 'excluder_flag';
241: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
242: l_attr_rec.value := TRUE;
243: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
244:
245: I := I + 1;
246: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
247: l_attr_rec.column := 'LAST_UPDATED_BY';

Line 246: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

242: l_attr_rec.value := TRUE;
243: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
244:
245: I := I + 1;
246: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
247: l_attr_rec.column := 'LAST_UPDATED_BY';
248: l_attr_rec.type := 'NUMBER';
249: l_attr_rec.name := 'last_updated_by';
250: l_attr_rec.code := 'last_updated_by';

Line 251: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

247: l_attr_rec.column := 'LAST_UPDATED_BY';
248: l_attr_rec.type := 'NUMBER';
249: l_attr_rec.name := 'last_updated_by';
250: l_attr_rec.code := 'last_updated_by';
251: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
252: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
253:
254: I := I + 1;
255: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 252: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

248: l_attr_rec.type := 'NUMBER';
249: l_attr_rec.name := 'last_updated_by';
250: l_attr_rec.code := 'last_updated_by';
251: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
252: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
253:
254: I := I + 1;
255: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
256: l_attr_rec.column := 'LAST_UPDATE_DATE';

Line 255: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

251: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
252: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
253:
254: I := I + 1;
255: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
256: l_attr_rec.column := 'LAST_UPDATE_DATE';
257: l_attr_rec.type := 'DATE';
258: l_attr_rec.name := 'last_update_date';
259: l_attr_rec.code := 'last_update_date';

Line 260: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

256: l_attr_rec.column := 'LAST_UPDATE_DATE';
257: l_attr_rec.type := 'DATE';
258: l_attr_rec.name := 'last_update_date';
259: l_attr_rec.code := 'last_update_date';
260: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
261: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
262:
263: I := I + 1;
264: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 261: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

257: l_attr_rec.type := 'DATE';
258: l_attr_rec.name := 'last_update_date';
259: l_attr_rec.code := 'last_update_date';
260: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
261: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
262:
263: I := I + 1;
264: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
265: l_attr_rec.column := 'LAST_UPDATE_LOGIN';

Line 264: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

260: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
261: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
262:
263: I := I + 1;
264: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
265: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
266: l_attr_rec.type := 'NUMBER';
267: l_attr_rec.name := 'last_update_login';
268: l_attr_rec.code := 'last_update_login';

Line 269: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

265: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
266: l_attr_rec.type := 'NUMBER';
267: l_attr_rec.name := 'last_update_login';
268: l_attr_rec.code := 'last_update_login';
269: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
270: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
271:
272: I := I + 1;
273: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 270: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

266: l_attr_rec.type := 'NUMBER';
267: l_attr_rec.name := 'last_update_login';
268: l_attr_rec.code := 'last_update_login';
269: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
270: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
271:
272: I := I + 1;
273: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
274: l_attr_rec.column := 'LIST_LINE_ID';

Line 273: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

269: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
270: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
271:
272: I := I + 1;
273: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
274: l_attr_rec.column := 'LIST_LINE_ID';
275: l_attr_rec.type := 'NUMBER';
276: l_attr_rec.name := 'list_line';
277: l_attr_rec.code := 'list_line_id';

Line 278: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

274: l_attr_rec.column := 'LIST_LINE_ID';
275: l_attr_rec.type := 'NUMBER';
276: l_attr_rec.name := 'list_line';
277: l_attr_rec.code := 'list_line_id';
278: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
279: l_attr_rec.value := TRUE;
280: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
281:
282: I := I + 1;

Line 280: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

276: l_attr_rec.name := 'list_line';
277: l_attr_rec.code := 'list_line_id';
278: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
279: l_attr_rec.value := TRUE;
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 := 'PRICING_ATTRIBUTE';

Line 283: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

279: l_attr_rec.value := TRUE;
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 := 'PRICING_ATTRIBUTE';
285: l_attr_rec.type := 'VARCHAR2';
286: l_attr_rec.length := 30;
287: l_attr_rec.name := 'pricing_attribute';

Line 289: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

285: l_attr_rec.type := 'VARCHAR2';
286: l_attr_rec.length := 30;
287: l_attr_rec.name := 'pricing_attribute';
288: l_attr_rec.code := 'pricing_attribute';
289: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
290: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
291:
292: I := I + 1;
293: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 290: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

286: l_attr_rec.length := 30;
287: l_attr_rec.name := 'pricing_attribute';
288: l_attr_rec.code := 'pricing_attribute';
289: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
290: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
291:
292: I := I + 1;
293: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
294: l_attr_rec.column := 'PRICING_ATTRIBUTE_CONTEXT';

Line 293: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

289: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
290: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
291:
292: I := I + 1;
293: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
294: l_attr_rec.column := 'PRICING_ATTRIBUTE_CONTEXT';
295: l_attr_rec.type := 'VARCHAR2';
296: l_attr_rec.length := 30;
297: l_attr_rec.name := 'pricing_attribute_context';

Line 299: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

295: l_attr_rec.type := 'VARCHAR2';
296: l_attr_rec.length := 30;
297: l_attr_rec.name := 'pricing_attribute_context';
298: l_attr_rec.code := 'pricing_attribute_context';
299: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
300: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
301:
302: I := I + 1;
303: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 300: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

296: l_attr_rec.length := 30;
297: l_attr_rec.name := 'pricing_attribute_context';
298: l_attr_rec.code := 'pricing_attribute_context';
299: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
300: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
301:
302: I := I + 1;
303: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
304: l_attr_rec.column := 'PRICING_ATTRIBUTE_ID';

Line 303: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

299: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
300: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
301:
302: I := I + 1;
303: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
304: l_attr_rec.column := 'PRICING_ATTRIBUTE_ID';
305: l_attr_rec.type := 'NUMBER';
306: l_attr_rec.name := 'pricing_attribute';
307: l_attr_rec.code := 'pricing_attribute_id';

Line 308: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

304: l_attr_rec.column := 'PRICING_ATTRIBUTE_ID';
305: l_attr_rec.type := 'NUMBER';
306: l_attr_rec.name := 'pricing_attribute';
307: l_attr_rec.code := 'pricing_attribute_id';
308: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
309: l_attr_rec.pk_flag := TRUE;
310: l_attr_rec.value := TRUE;
311: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
312:

Line 311: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

307: l_attr_rec.code := 'pricing_attribute_id';
308: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
309: l_attr_rec.pk_flag := TRUE;
310: l_attr_rec.value := TRUE;
311: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
312:
313: I := I + 1;
314: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
315: l_attr_rec.column := 'PRICING_ATTR_VALUE_FROM';

Line 314: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

310: l_attr_rec.value := TRUE;
311: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
312:
313: I := I + 1;
314: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
315: l_attr_rec.column := 'PRICING_ATTR_VALUE_FROM';
316: l_attr_rec.type := 'VARCHAR2';
317: l_attr_rec.length := 240;
318: l_attr_rec.name := 'pricing_attr_value_from';

Line 320: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

316: l_attr_rec.type := 'VARCHAR2';
317: l_attr_rec.length := 240;
318: l_attr_rec.name := 'pricing_attr_value_from';
319: l_attr_rec.code := 'pricing_attr_value_from';
320: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
321: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
322:
323: I := I + 1;
324: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 321: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

317: l_attr_rec.length := 240;
318: l_attr_rec.name := 'pricing_attr_value_from';
319: l_attr_rec.code := 'pricing_attr_value_from';
320: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
321: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
322:
323: I := I + 1;
324: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
325: l_attr_rec.column := 'PRICING_ATTR_VALUE_TO';

Line 324: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

320: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
321: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
322:
323: I := I + 1;
324: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
325: l_attr_rec.column := 'PRICING_ATTR_VALUE_TO';
326: l_attr_rec.type := 'VARCHAR2';
327: l_attr_rec.length := 240;
328: l_attr_rec.name := 'pricing_attr_value_to';

Line 330: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

326: l_attr_rec.type := 'VARCHAR2';
327: l_attr_rec.length := 240;
328: l_attr_rec.name := 'pricing_attr_value_to';
329: l_attr_rec.code := 'pricing_attr_value_to';
330: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
331: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
332:
333: I := I + 1;
334: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 331: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

327: l_attr_rec.length := 240;
328: l_attr_rec.name := 'pricing_attr_value_to';
329: l_attr_rec.code := 'pricing_attr_value_to';
330: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
331: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
332:
333: I := I + 1;
334: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
335: l_attr_rec.column := 'PRODUCT_ATTRIBUTE';

Line 334: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

330: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
331: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
332:
333: I := I + 1;
334: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
335: l_attr_rec.column := 'PRODUCT_ATTRIBUTE';
336: l_attr_rec.type := 'VARCHAR2';
337: l_attr_rec.length := 30;
338: l_attr_rec.name := 'product_attribute';

Line 340: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

336: l_attr_rec.type := 'VARCHAR2';
337: l_attr_rec.length := 30;
338: l_attr_rec.name := 'product_attribute';
339: l_attr_rec.code := 'product_attribute';
340: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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;

Line 341: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

337: l_attr_rec.length := 30;
338: l_attr_rec.name := 'product_attribute';
339: l_attr_rec.code := 'product_attribute';
340: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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.column := 'PRODUCT_ATTRIBUTE_CONTEXT';

Line 344: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

340: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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.column := 'PRODUCT_ATTRIBUTE_CONTEXT';
346: l_attr_rec.type := 'VARCHAR2';
347: l_attr_rec.length := 30;
348: l_attr_rec.name := 'product_attribute_context';

Line 350: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

346: l_attr_rec.type := 'VARCHAR2';
347: l_attr_rec.length := 30;
348: l_attr_rec.name := 'product_attribute_context';
349: l_attr_rec.code := 'product_attribute_context';
350: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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;

Line 351: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

347: l_attr_rec.length := 30;
348: l_attr_rec.name := 'product_attribute_context';
349: l_attr_rec.code := 'product_attribute_context';
350: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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.column := 'PRODUCT_ATTR_VALUE';

Line 354: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

350: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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.column := 'PRODUCT_ATTR_VALUE';
356: l_attr_rec.type := 'VARCHAR2';
357: l_attr_rec.length := 240;
358: l_attr_rec.name := 'product_attr_value';

Line 360: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

356: l_attr_rec.type := 'VARCHAR2';
357: l_attr_rec.length := 240;
358: l_attr_rec.name := 'product_attr_value';
359: l_attr_rec.code := 'product_attr_value';
360: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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;

Line 361: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

357: l_attr_rec.length := 240;
358: l_attr_rec.name := 'product_attr_value';
359: l_attr_rec.code := 'product_attr_value';
360: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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.column := 'PRODUCT_UOM_CODE';

Line 364: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

360: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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.column := 'PRODUCT_UOM_CODE';
366: l_attr_rec.type := 'VARCHAR2';
367: l_attr_rec.length := 3;
368: l_attr_rec.name := 'product_uom';

Line 370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

366: l_attr_rec.type := 'VARCHAR2';
367: l_attr_rec.length := 3;
368: l_attr_rec.name := 'product_uom';
369: l_attr_rec.code := 'product_uom_code';
370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
371: l_attr_rec.value := TRUE;
372: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
373:
374: I := I + 1;

Line 372: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

368: l_attr_rec.name := 'product_uom';
369: l_attr_rec.code := 'product_uom_code';
370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
371: l_attr_rec.value := TRUE;
372: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
373:
374: I := I + 1;
375: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
376: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';

Line 375: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

371: l_attr_rec.value := TRUE;
372: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
373:
374: I := I + 1;
375: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
376: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
377: l_attr_rec.type := 'NUMBER';
378: l_attr_rec.name := 'program_application';
379: l_attr_rec.code := 'program_application_id';

Line 380: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

376: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
377: l_attr_rec.type := 'NUMBER';
378: l_attr_rec.name := 'program_application';
379: l_attr_rec.code := 'program_application_id';
380: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
381: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
382:
383: I := I + 1;
384: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 381: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

377: l_attr_rec.type := 'NUMBER';
378: l_attr_rec.name := 'program_application';
379: l_attr_rec.code := 'program_application_id';
380: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
381: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
382:
383: I := I + 1;
384: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
385: l_attr_rec.column := 'PROGRAM_ID';

Line 384: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

380: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
381: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
382:
383: I := I + 1;
384: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
385: l_attr_rec.column := 'PROGRAM_ID';
386: l_attr_rec.type := 'NUMBER';
387: l_attr_rec.name := 'program';
388: l_attr_rec.code := 'program_id';

Line 389: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

385: l_attr_rec.column := 'PROGRAM_ID';
386: l_attr_rec.type := 'NUMBER';
387: l_attr_rec.name := 'program';
388: l_attr_rec.code := 'program_id';
389: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
390: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
391:
392: I := I + 1;
393: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 390: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

386: l_attr_rec.type := 'NUMBER';
387: l_attr_rec.name := 'program';
388: l_attr_rec.code := 'program_id';
389: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
390: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
391:
392: I := I + 1;
393: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
394: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';

Line 393: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

389: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
390: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
391:
392: I := I + 1;
393: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
394: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
395: l_attr_rec.type := 'DATE';
396: l_attr_rec.name := 'program_update_date';
397: l_attr_rec.code := 'program_update_date';

Line 398: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

394: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
395: l_attr_rec.type := 'DATE';
396: l_attr_rec.name := 'program_update_date';
397: l_attr_rec.code := 'program_update_date';
398: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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;

Line 399: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

395: l_attr_rec.type := 'DATE';
396: l_attr_rec.name := 'program_update_date';
397: l_attr_rec.code := 'program_update_date';
398: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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.column := 'REQUEST_ID';

Line 402: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

398: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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.column := 'REQUEST_ID';
404: l_attr_rec.type := 'NUMBER';
405: l_attr_rec.name := 'request';
406: l_attr_rec.code := 'request_id';

Line 407: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;

403: l_attr_rec.column := 'REQUEST_ID';
404: l_attr_rec.type := 'NUMBER';
405: l_attr_rec.name := 'request';
406: l_attr_rec.code := 'request_id';
407: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
408: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
409:
410: I := I + 1;
411: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 408: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

404: l_attr_rec.type := 'NUMBER';
405: l_attr_rec.name := 'request';
406: l_attr_rec.code := 'request_id';
407: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
408: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
409:
410: I := I + 1;
411: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
412: l_attr_rec.type := 'VARCHAR2';

Line 411: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

407: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
408: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
409:
410: I := I + 1;
411: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
412: l_attr_rec.type := 'VARCHAR2';
413: l_attr_rec.length := 1;
414: l_attr_rec.name := 'return_status';
415: l_attr_rec.code := 'return_status';

Line 417: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;

413: l_attr_rec.length := 1;
414: l_attr_rec.name := 'return_status';
415: l_attr_rec.code := 'return_status';
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: I := I + 1;
421: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 418: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

414: l_attr_rec.name := 'return_status';
415: l_attr_rec.code := 'return_status';
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: I := I + 1;
421: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
422: l_attr_rec.type := 'VARCHAR2';

Line 421: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

417: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
418: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
419:
420: I := I + 1;
421: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
422: l_attr_rec.type := 'VARCHAR2';
423: l_attr_rec.length := 1;
424: l_attr_rec.name := 'db_flag';
425: l_attr_rec.code := 'db_flag';

Line 427: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;

423: l_attr_rec.length := 1;
424: l_attr_rec.name := 'db_flag';
425: l_attr_rec.code := 'db_flag';
426: l_attr_rec.db_attr := FALSE;
427: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
428: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
429:
430: I := I + 1;
431: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 428: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

424: l_attr_rec.name := 'db_flag';
425: l_attr_rec.code := 'db_flag';
426: l_attr_rec.db_attr := FALSE;
427: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
428: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
429:
430: I := I + 1;
431: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
432: l_attr_rec.type := 'VARCHAR2';

Line 431: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

427: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
428: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
429:
430: I := I + 1;
431: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
432: l_attr_rec.type := 'VARCHAR2';
433: l_attr_rec.length := 30;
434: l_attr_rec.name := 'operation';
435: l_attr_rec.code := 'operation';

Line 437: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;

433: l_attr_rec.length := 30;
434: l_attr_rec.name := 'operation';
435: l_attr_rec.code := 'operation';
436: l_attr_rec.db_attr := FALSE;
437: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
438: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
439:
440: I := I + 1;
441: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 438: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

434: l_attr_rec.name := 'operation';
435: l_attr_rec.code := 'operation';
436: l_attr_rec.db_attr := FALSE;
437: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
438: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
439:
440: I := I + 1;
441: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
442: l_attr_rec.type := 'NUMBER';

Line 441: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

437: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
438: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
439:
440: I := I + 1;
441: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
442: l_attr_rec.type := 'NUMBER';
443: l_attr_rec.name := 'PRICE_LIST_LINE_index';
444: l_attr_rec.code := 'PRICE_LIST_LINE_index';
445: l_attr_rec.db_attr := FALSE;

Line 446: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;

442: l_attr_rec.type := 'NUMBER';
443: l_attr_rec.name := 'PRICE_LIST_LINE_index';
444: l_attr_rec.code := 'PRICE_LIST_LINE_index';
445: l_attr_rec.db_attr := FALSE;
446: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
447: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
448:
449: END Get_Attr_Tbl;
450:

Line 447: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

443: l_attr_rec.name := 'PRICE_LIST_LINE_index';
444: l_attr_rec.code := 'PRICE_LIST_LINE_index';
445: l_attr_rec.db_attr := FALSE;
446: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
447: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
448:
449: END Get_Attr_Tbl;
450:
451: -- Procedure : Get_Attr_Value_Tbl

Line 455: l_attr_rec OE_GENERATE.Attribute_Rec_Type;

451: -- Procedure : Get_Attr_Value_Tbl
452:
453: PROCEDURE Get_Attr_Value_Tbl
454: IS
455: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
456: I NUMBER := 0;
457: BEGIN
458:
459: OE_GENERATE.g_attr_value_tbl.DELETE;

Line 459: OE_GENERATE.g_attr_value_tbl.DELETE;

455: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
456: I NUMBER := 0;
457: BEGIN
458:
459: OE_GENERATE.g_attr_value_tbl.DELETE;
460:
461: -- Load attribute values
462:
463: I := I + 1;

Line 464: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

460:
461: -- Load attribute values
462:
463: I := I + 1;
464: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
465: l_attr_rec.name := 'accumulate';
466: l_attr_rec.code := 'accumulate_flag';
467: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
468: l_attr_rec.length := 240;

Line 467: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;

463: I := I + 1;
464: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
465: l_attr_rec.name := 'accumulate';
466: l_attr_rec.code := 'accumulate_flag';
467: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
468: l_attr_rec.length := 240;
469: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
470: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
471:

Line 469: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

465: l_attr_rec.name := 'accumulate';
466: l_attr_rec.code := 'accumulate_flag';
467: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
468: l_attr_rec.length := 240;
469: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
470: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
471:
472: I := I + 1;
473: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 470: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;

466: l_attr_rec.code := 'accumulate_flag';
467: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
468: l_attr_rec.length := 240;
469: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
470: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
471:
472: I := I + 1;
473: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
474: l_attr_rec.name := 'excluder';

Line 473: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

469: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
470: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
471:
472: I := I + 1;
473: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
474: l_attr_rec.name := 'excluder';
475: l_attr_rec.code := 'excluder_flag';
476: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
477: l_attr_rec.length := 240;

Line 476: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;

472: I := I + 1;
473: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
474: l_attr_rec.name := 'excluder';
475: l_attr_rec.code := 'excluder_flag';
476: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
477: l_attr_rec.length := 240;
478: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
479: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
480:

Line 478: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

474: l_attr_rec.name := 'excluder';
475: l_attr_rec.code := 'excluder_flag';
476: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
477: l_attr_rec.length := 240;
478: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
479: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
480:
481: I := I + 1;
482: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 479: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;

475: l_attr_rec.code := 'excluder_flag';
476: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
477: l_attr_rec.length := 240;
478: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
479: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
480:
481: I := I + 1;
482: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
483: l_attr_rec.name := 'list_line';

Line 482: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

478: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
479: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
480:
481: I := I + 1;
482: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
483: l_attr_rec.name := 'list_line';
484: l_attr_rec.code := 'list_line_id';
485: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
486: l_attr_rec.length := 240;

Line 485: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;

481: I := I + 1;
482: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
483: l_attr_rec.name := 'list_line';
484: l_attr_rec.code := 'list_line_id';
485: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
486: l_attr_rec.length := 240;
487: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
488: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
489:

Line 487: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

483: l_attr_rec.name := 'list_line';
484: l_attr_rec.code := 'list_line_id';
485: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
486: l_attr_rec.length := 240;
487: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
488: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
489:
490: I := I + 1;
491: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 488: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;

484: l_attr_rec.code := 'list_line_id';
485: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
486: l_attr_rec.length := 240;
487: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
488: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
489:
490: I := I + 1;
491: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
492: l_attr_rec.name := 'pricing_attribute';

Line 491: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

487: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
488: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
489:
490: I := I + 1;
491: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
492: l_attr_rec.name := 'pricing_attribute';
493: l_attr_rec.code := 'pricing_attribute_id';
494: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
495: l_attr_rec.length := 240;

Line 494: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;

490: I := I + 1;
491: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
492: l_attr_rec.name := 'pricing_attribute';
493: l_attr_rec.code := 'pricing_attribute_id';
494: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
495: l_attr_rec.length := 240;
496: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
497: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
498:

Line 496: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

492: l_attr_rec.name := 'pricing_attribute';
493: l_attr_rec.code := 'pricing_attribute_id';
494: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
495: l_attr_rec.length := 240;
496: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
497: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
498:
499: I := I + 1;
500: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 497: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;

493: l_attr_rec.code := 'pricing_attribute_id';
494: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
495: l_attr_rec.length := 240;
496: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
497: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
498:
499: I := I + 1;
500: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
501: l_attr_rec.name := 'product_uom';

Line 500: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

496: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
497: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
498:
499: I := I + 1;
500: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
501: l_attr_rec.name := 'product_uom';
502: l_attr_rec.code := 'product_uom_code';
503: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
504: l_attr_rec.length := 240;

Line 503: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;

499: I := I + 1;
500: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
501: l_attr_rec.name := 'product_uom';
502: l_attr_rec.code := 'product_uom_code';
503: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
504: l_attr_rec.length := 240;
505: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
506: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
507:

Line 505: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;

501: l_attr_rec.name := 'product_uom';
502: l_attr_rec.code := 'product_uom_code';
503: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
504: l_attr_rec.length := 240;
505: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
506: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
507:
508: I := I + 1;
509: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

Line 506: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;

502: l_attr_rec.code := 'product_uom_code';
503: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
504: l_attr_rec.length := 240;
505: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
506: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
507:
508: I := I + 1;
509: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
510: l_attr_rec.type := 'NUMBER';

Line 509: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

505: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
506: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
507:
508: I := I + 1;
509: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
510: l_attr_rec.type := 'NUMBER';
511: l_attr_rec.name := 'PRICE_LIST_LINE_index';
512: l_attr_rec.code := 'PRICE_LIST_LINE_index';
513: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;

Line 513: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;

509: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
510: l_attr_rec.type := 'NUMBER';
511: l_attr_rec.name := 'PRICE_LIST_LINE_index';
512: l_attr_rec.code := 'PRICE_LIST_LINE_index';
513: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
514: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
515:
516: END Get_Attr_Value_Tbl;
517:

Line 514: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;

510: l_attr_rec.type := 'NUMBER';
511: l_attr_rec.name := 'PRICE_LIST_LINE_index';
512: l_attr_rec.code := 'PRICE_LIST_LINE_index';
513: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
514: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
515:
516: END Get_Attr_Value_Tbl;
517:
518: END QP_PRICING_ATTR_ATTR_ren;