eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QP_PRICE_LIST_ATTR 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 := 'ATTRIBUTE1';
23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 240;
25: l_attr_rec.name := 'attribute1';

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

23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 240;
25: l_attr_rec.name := 'attribute1';
26: l_attr_rec.code := 'attribute1';
27: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
28: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute1';
26: l_attr_rec.code := 'attribute1';
27: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
28: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 32: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

28: l_attr_rec.text1 := 'PRICE_LIST';
29: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
30:
31: I := I + 1;
32: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
33: l_attr_rec.column := 'ATTRIBUTE10';
34: l_attr_rec.type := 'VARCHAR2';
35: l_attr_rec.length := 240;
36: l_attr_rec.name := 'attribute10';

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 := 'attribute10';
37: l_attr_rec.code := 'attribute10';
38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
39: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute10';
37: l_attr_rec.code := 'attribute10';
38: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
39: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 43: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

39: l_attr_rec.text1 := 'PRICE_LIST';
40: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
41:
42: I := I + 1;
43: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
44: l_attr_rec.column := 'ATTRIBUTE11';
45: l_attr_rec.type := 'VARCHAR2';
46: l_attr_rec.length := 240;
47: l_attr_rec.name := 'attribute11';

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 := 'attribute11';
48: l_attr_rec.code := 'attribute11';
49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
50: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute11';
48: l_attr_rec.code := 'attribute11';
49: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
50: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 54: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

50: l_attr_rec.text1 := 'PRICE_LIST';
51: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
52:
53: I := I + 1;
54: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
55: l_attr_rec.column := 'ATTRIBUTE12';
56: l_attr_rec.type := 'VARCHAR2';
57: l_attr_rec.length := 240;
58: l_attr_rec.name := 'attribute12';

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 := 'attribute12';
59: l_attr_rec.code := 'attribute12';
60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
61: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute12';
59: l_attr_rec.code := 'attribute12';
60: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
61: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 65: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

61: l_attr_rec.text1 := 'PRICE_LIST';
62: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
63:
64: I := I + 1;
65: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
66: l_attr_rec.column := 'ATTRIBUTE13';
67: l_attr_rec.type := 'VARCHAR2';
68: l_attr_rec.length := 240;
69: l_attr_rec.name := 'attribute13';

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 := 'attribute13';
70: l_attr_rec.code := 'attribute13';
71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
72: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute13';
70: l_attr_rec.code := 'attribute13';
71: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
72: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 76: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

72: l_attr_rec.text1 := 'PRICE_LIST';
73: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
74:
75: I := I + 1;
76: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
77: l_attr_rec.column := 'ATTRIBUTE14';
78: l_attr_rec.type := 'VARCHAR2';
79: l_attr_rec.length := 240;
80: l_attr_rec.name := 'attribute14';

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 := 'attribute14';
81: l_attr_rec.code := 'attribute14';
82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
83: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute14';
81: l_attr_rec.code := 'attribute14';
82: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
83: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 87: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

83: l_attr_rec.text1 := 'PRICE_LIST';
84: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
85:
86: I := I + 1;
87: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
88: l_attr_rec.column := 'ATTRIBUTE15';
89: l_attr_rec.type := 'VARCHAR2';
90: l_attr_rec.length := 240;
91: l_attr_rec.name := 'attribute15';

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 := 'attribute15';
92: l_attr_rec.code := 'attribute15';
93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
94: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute15';
92: l_attr_rec.code := 'attribute15';
93: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
94: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 98: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

94: l_attr_rec.text1 := 'PRICE_LIST';
95: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
96:
97: I := I + 1;
98: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
99: l_attr_rec.column := 'ATTRIBUTE2';
100: l_attr_rec.type := 'VARCHAR2';
101: l_attr_rec.length := 240;
102: l_attr_rec.name := 'attribute2';

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 := 'attribute2';
103: l_attr_rec.code := 'attribute2';
104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
105: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute2';
103: l_attr_rec.code := 'attribute2';
104: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
105: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 109: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

105: l_attr_rec.text1 := 'PRICE_LIST';
106: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
107:
108: I := I + 1;
109: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
110: l_attr_rec.column := 'ATTRIBUTE3';
111: l_attr_rec.type := 'VARCHAR2';
112: l_attr_rec.length := 240;
113: l_attr_rec.name := 'attribute3';

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 := 'attribute3';
114: l_attr_rec.code := 'attribute3';
115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
116: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute3';
114: l_attr_rec.code := 'attribute3';
115: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
116: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 120: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

116: l_attr_rec.text1 := 'PRICE_LIST';
117: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
118:
119: I := I + 1;
120: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
121: l_attr_rec.column := 'ATTRIBUTE4';
122: l_attr_rec.type := 'VARCHAR2';
123: l_attr_rec.length := 240;
124: l_attr_rec.name := 'attribute4';

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 := 'attribute4';
125: l_attr_rec.code := 'attribute4';
126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
127: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute4';
125: l_attr_rec.code := 'attribute4';
126: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
127: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 131: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

127: l_attr_rec.text1 := 'PRICE_LIST';
128: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
129:
130: I := I + 1;
131: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
132: l_attr_rec.column := 'ATTRIBUTE5';
133: l_attr_rec.type := 'VARCHAR2';
134: l_attr_rec.length := 240;
135: l_attr_rec.name := 'attribute5';

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 := 'attribute5';
136: l_attr_rec.code := 'attribute5';
137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
138: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute5';
136: l_attr_rec.code := 'attribute5';
137: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
138: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 142: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

138: l_attr_rec.text1 := 'PRICE_LIST';
139: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
140:
141: I := I + 1;
142: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
143: l_attr_rec.column := 'ATTRIBUTE6';
144: l_attr_rec.type := 'VARCHAR2';
145: l_attr_rec.length := 240;
146: l_attr_rec.name := 'attribute6';

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 := 'attribute6';
147: l_attr_rec.code := 'attribute6';
148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
149: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute6';
147: l_attr_rec.code := 'attribute6';
148: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
149: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 153: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

149: l_attr_rec.text1 := 'PRICE_LIST';
150: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
151:
152: I := I + 1;
153: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
154: l_attr_rec.column := 'ATTRIBUTE7';
155: l_attr_rec.type := 'VARCHAR2';
156: l_attr_rec.length := 240;
157: l_attr_rec.name := 'attribute7';

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 := 'attribute7';
158: l_attr_rec.code := 'attribute7';
159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
160: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute7';
158: l_attr_rec.code := 'attribute7';
159: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
160: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 164: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

160: l_attr_rec.text1 := 'PRICE_LIST';
161: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
162:
163: I := I + 1;
164: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
165: l_attr_rec.column := 'ATTRIBUTE8';
166: l_attr_rec.type := 'VARCHAR2';
167: l_attr_rec.length := 240;
168: l_attr_rec.name := 'attribute8';

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 := 'attribute8';
169: l_attr_rec.code := 'attribute8';
170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
171: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute8';
169: l_attr_rec.code := 'attribute8';
170: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
171: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 175: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

171: l_attr_rec.text1 := 'PRICE_LIST';
172: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
173:
174: I := I + 1;
175: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
176: l_attr_rec.column := 'ATTRIBUTE9';
177: l_attr_rec.type := 'VARCHAR2';
178: l_attr_rec.length := 240;
179: l_attr_rec.name := 'attribute9';

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 := 'attribute9';
180: l_attr_rec.code := 'attribute9';
181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
182: l_attr_rec.text1 := 'PRICE_LIST';
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 := 'attribute9';
180: l_attr_rec.code := 'attribute9';
181: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
182: l_attr_rec.text1 := 'PRICE_LIST';
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';

Line 186: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

182: l_attr_rec.text1 := 'PRICE_LIST';
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';

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

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: l_attr_rec.value := TRUE;
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 := 'automatic';
191: l_attr_rec.code := 'automatic_flag';
192: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
193: l_attr_rec.value := TRUE;
194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
195:
196: I := I + 1;
197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
198: l_attr_rec.column := 'COMMENTS';

Line 197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

193: l_attr_rec.value := TRUE;
194: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
195:
196: I := I + 1;
197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
198: l_attr_rec.column := 'COMMENTS';
199: l_attr_rec.type := 'VARCHAR2';
200: l_attr_rec.length := 2000;
201: l_attr_rec.name := 'comments';

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

199: l_attr_rec.type := 'VARCHAR2';
200: l_attr_rec.length := 2000;
201: l_attr_rec.name := 'comments';
202: l_attr_rec.code := 'comments';
203: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

200: l_attr_rec.length := 2000;
201: l_attr_rec.name := 'comments';
202: l_attr_rec.code := 'comments';
203: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
208: l_attr_rec.column := 'CONTEXT';

Line 207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 218: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 227: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

228: l_attr_rec.column := 'CREATION_DATE';
229: l_attr_rec.type := 'DATE';
230: l_attr_rec.name := 'creation_date';
231: l_attr_rec.code := 'creation_date';
232: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;
236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

229: l_attr_rec.type := 'DATE';
230: l_attr_rec.name := 'creation_date';
231: l_attr_rec.code := 'creation_date';
232: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;
236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
237: l_attr_rec.column := 'CURRENCY_CODE';

Line 236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

232: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;
236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
237: l_attr_rec.column := 'CURRENCY_CODE';
238: l_attr_rec.type := 'VARCHAR2';
239: l_attr_rec.length := 30;
240: l_attr_rec.name := 'currency';

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

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

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

240: l_attr_rec.name := 'currency';
241: l_attr_rec.code := 'currency_code';
242: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
243: l_attr_rec.value := TRUE;
244: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
245:
246: I := I + 1;
247: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
248: l_attr_rec.column := 'DISCOUNT_LINES_FLAG';

Line 247: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

243: l_attr_rec.value := TRUE;
244: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
245:
246: I := I + 1;
247: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
248: l_attr_rec.column := 'DISCOUNT_LINES_FLAG';
249: l_attr_rec.type := 'VARCHAR2';
250: l_attr_rec.length := 1;
251: l_attr_rec.name := 'discount_lines';

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

249: l_attr_rec.type := 'VARCHAR2';
250: l_attr_rec.length := 1;
251: l_attr_rec.name := 'discount_lines';
252: l_attr_rec.code := 'discount_lines_flag';
253: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
254: l_attr_rec.value := TRUE;
255: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
256:
257: I := I + 1;

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

251: l_attr_rec.name := 'discount_lines';
252: l_attr_rec.code := 'discount_lines_flag';
253: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
254: l_attr_rec.value := TRUE;
255: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
256:
257: I := I + 1;
258: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
259: l_attr_rec.column := 'END_DATE_ACTIVE';

Line 258: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

254: l_attr_rec.value := TRUE;
255: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
256:
257: I := I + 1;
258: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
259: l_attr_rec.column := 'END_DATE_ACTIVE';
260: l_attr_rec.type := 'DATE';
261: l_attr_rec.name := 'end_date_active';
262: l_attr_rec.code := 'end_date_active';

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

259: l_attr_rec.column := 'END_DATE_ACTIVE';
260: l_attr_rec.type := 'DATE';
261: l_attr_rec.name := 'end_date_active';
262: l_attr_rec.code := 'end_date_active';
263: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
264: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
265:
266: I := I + 1;
267: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

260: l_attr_rec.type := 'DATE';
261: l_attr_rec.name := 'end_date_active';
262: l_attr_rec.code := 'end_date_active';
263: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
264: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
265:
266: I := I + 1;
267: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
268: l_attr_rec.column := 'FREIGHT_TERMS_CODE';

Line 267: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

263: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
264: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
265:
266: I := I + 1;
267: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
268: l_attr_rec.column := 'FREIGHT_TERMS_CODE';
269: l_attr_rec.type := 'VARCHAR2';
270: l_attr_rec.length := 30;
271: l_attr_rec.name := 'freight_terms';

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

269: l_attr_rec.type := 'VARCHAR2';
270: l_attr_rec.length := 30;
271: l_attr_rec.name := 'freight_terms';
272: l_attr_rec.code := 'freight_terms_code';
273: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
274: l_attr_rec.value := TRUE;
275: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
276:
277: I := I + 1;

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

271: l_attr_rec.name := 'freight_terms';
272: l_attr_rec.code := 'freight_terms_code';
273: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
274: l_attr_rec.value := TRUE;
275: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
276:
277: I := I + 1;
278: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
279: l_attr_rec.column := 'GSA_INDICATOR';

Line 278: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

274: l_attr_rec.value := TRUE;
275: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
276:
277: I := I + 1;
278: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
279: l_attr_rec.column := 'GSA_INDICATOR';
280: l_attr_rec.type := 'VARCHAR2';
281: l_attr_rec.length := 1;
282: l_attr_rec.name := 'gsa_indicator';

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

280: l_attr_rec.type := 'VARCHAR2';
281: l_attr_rec.length := 1;
282: l_attr_rec.name := 'gsa_indicator';
283: l_attr_rec.code := 'gsa_indicator';
284: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
285: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
286:
287: I := I + 1;
288: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

281: l_attr_rec.length := 1;
282: l_attr_rec.name := 'gsa_indicator';
283: l_attr_rec.code := 'gsa_indicator';
284: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
285: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
286:
287: I := I + 1;
288: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
289: l_attr_rec.column := 'LAST_UPDATED_BY';

Line 288: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

284: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
285: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
286:
287: I := I + 1;
288: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
289: l_attr_rec.column := 'LAST_UPDATED_BY';
290: l_attr_rec.type := 'NUMBER';
291: l_attr_rec.name := 'last_updated_by';
292: l_attr_rec.code := 'last_updated_by';

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

289: l_attr_rec.column := 'LAST_UPDATED_BY';
290: l_attr_rec.type := 'NUMBER';
291: l_attr_rec.name := 'last_updated_by';
292: l_attr_rec.code := 'last_updated_by';
293: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
294: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
295:
296: I := I + 1;
297: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

290: l_attr_rec.type := 'NUMBER';
291: l_attr_rec.name := 'last_updated_by';
292: l_attr_rec.code := 'last_updated_by';
293: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
294: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
295:
296: I := I + 1;
297: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
298: l_attr_rec.column := 'LAST_UPDATE_DATE';

Line 297: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

293: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
294: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
295:
296: I := I + 1;
297: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
298: l_attr_rec.column := 'LAST_UPDATE_DATE';
299: l_attr_rec.type := 'DATE';
300: l_attr_rec.name := 'last_update_date';
301: l_attr_rec.code := 'last_update_date';

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

298: l_attr_rec.column := 'LAST_UPDATE_DATE';
299: l_attr_rec.type := 'DATE';
300: l_attr_rec.name := 'last_update_date';
301: l_attr_rec.code := 'last_update_date';
302: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
303: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
304:
305: I := I + 1;
306: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

299: l_attr_rec.type := 'DATE';
300: l_attr_rec.name := 'last_update_date';
301: l_attr_rec.code := 'last_update_date';
302: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
303: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
304:
305: I := I + 1;
306: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
307: l_attr_rec.column := 'LAST_UPDATE_LOGIN';

Line 306: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

302: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
303: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
304:
305: I := I + 1;
306: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
307: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
308: l_attr_rec.type := 'NUMBER';
309: l_attr_rec.name := 'last_update_login';
310: l_attr_rec.code := 'last_update_login';

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

307: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
308: l_attr_rec.type := 'NUMBER';
309: l_attr_rec.name := 'last_update_login';
310: l_attr_rec.code := 'last_update_login';
311: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
312: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
313:
314: I := I + 1;
315: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

308: l_attr_rec.type := 'NUMBER';
309: l_attr_rec.name := 'last_update_login';
310: l_attr_rec.code := 'last_update_login';
311: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
312: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
313:
314: I := I + 1;
315: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
316: l_attr_rec.column := 'LIST_HEADER_ID';

Line 315: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

311: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
312: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
313:
314: I := I + 1;
315: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
316: l_attr_rec.column := 'LIST_HEADER_ID';
317: l_attr_rec.type := 'NUMBER';
318: l_attr_rec.name := 'list_header';
319: l_attr_rec.code := 'list_header_id';

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

316: l_attr_rec.column := 'LIST_HEADER_ID';
317: l_attr_rec.type := 'NUMBER';
318: l_attr_rec.name := 'list_header';
319: l_attr_rec.code := 'list_header_id';
320: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
321: l_attr_rec.pk_flag := TRUE;
322: l_attr_rec.value := TRUE;
323: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
324:

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

319: l_attr_rec.code := 'list_header_id';
320: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
321: l_attr_rec.pk_flag := TRUE;
322: l_attr_rec.value := TRUE;
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 := 'LIST_TYPE_CODE';

Line 326: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

322: l_attr_rec.value := TRUE;
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 := 'LIST_TYPE_CODE';
328: l_attr_rec.type := 'VARCHAR2';
329: l_attr_rec.length := 30;
330: l_attr_rec.name := 'list_type';

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

328: l_attr_rec.type := 'VARCHAR2';
329: l_attr_rec.length := 30;
330: l_attr_rec.name := 'list_type';
331: l_attr_rec.code := 'list_type_code';
332: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
333: l_attr_rec.value := TRUE;
334: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
335:
336: I := I + 1;

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

330: l_attr_rec.name := 'list_type';
331: l_attr_rec.code := 'list_type_code';
332: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
333: l_attr_rec.value := TRUE;
334: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
335:
336: I := I + 1;
337: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
338: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';

Line 337: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

333: l_attr_rec.value := TRUE;
334: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
335:
336: I := I + 1;
337: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
338: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
339: l_attr_rec.type := 'NUMBER';
340: l_attr_rec.name := 'program_application';
341: l_attr_rec.code := 'program_application_id';

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

338: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
339: l_attr_rec.type := 'NUMBER';
340: l_attr_rec.name := 'program_application';
341: l_attr_rec.code := 'program_application_id';
342: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
343: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
344:
345: I := I + 1;
346: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

339: l_attr_rec.type := 'NUMBER';
340: l_attr_rec.name := 'program_application';
341: l_attr_rec.code := 'program_application_id';
342: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
343: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
344:
345: I := I + 1;
346: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
347: l_attr_rec.column := 'PROGRAM_ID';

Line 346: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

342: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
343: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
344:
345: I := I + 1;
346: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
347: l_attr_rec.column := 'PROGRAM_ID';
348: l_attr_rec.type := 'NUMBER';
349: l_attr_rec.name := 'program';
350: l_attr_rec.code := 'program_id';

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

347: l_attr_rec.column := 'PROGRAM_ID';
348: l_attr_rec.type := 'NUMBER';
349: l_attr_rec.name := 'program';
350: l_attr_rec.code := 'program_id';
351: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
352: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
353:
354: I := I + 1;
355: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

348: l_attr_rec.type := 'NUMBER';
349: l_attr_rec.name := 'program';
350: l_attr_rec.code := 'program_id';
351: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
352: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
353:
354: I := I + 1;
355: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
356: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';

Line 355: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

351: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
352: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
353:
354: I := I + 1;
355: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
356: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
357: l_attr_rec.type := 'DATE';
358: l_attr_rec.name := 'program_update_date';
359: l_attr_rec.code := 'program_update_date';

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

356: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
357: l_attr_rec.type := 'DATE';
358: l_attr_rec.name := 'program_update_date';
359: l_attr_rec.code := 'program_update_date';
360: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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.type := 'DATE';
358: l_attr_rec.name := 'program_update_date';
359: l_attr_rec.code := 'program_update_date';
360: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'PRORATE_FLAG';

Line 364: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

360: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'PRORATE_FLAG';
366: l_attr_rec.type := 'VARCHAR2';
367: l_attr_rec.length := 30;
368: l_attr_rec.name := 'prorate';

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

366: l_attr_rec.type := 'VARCHAR2';
367: l_attr_rec.length := 30;
368: l_attr_rec.name := 'prorate';
369: l_attr_rec.code := 'prorate_flag';
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 := 'prorate';
369: l_attr_rec.code := 'prorate_flag';
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 := 'REQUEST_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 := 'REQUEST_ID';
377: l_attr_rec.type := 'NUMBER';
378: l_attr_rec.name := 'request';
379: l_attr_rec.code := 'request_id';

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

376: l_attr_rec.column := 'REQUEST_ID';
377: l_attr_rec.type := 'NUMBER';
378: l_attr_rec.name := 'request';
379: l_attr_rec.code := 'request_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 := 'request';
379: l_attr_rec.code := 'request_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 := 'ROUNDING_FACTOR';

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 := 'ROUNDING_FACTOR';
386: l_attr_rec.type := 'NUMBER';
387: l_attr_rec.name := 'rounding_factor';
388: l_attr_rec.code := 'rounding_factor';

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

385: l_attr_rec.column := 'ROUNDING_FACTOR';
386: l_attr_rec.type := 'NUMBER';
387: l_attr_rec.name := 'rounding_factor';
388: l_attr_rec.code := 'rounding_factor';
389: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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 := 'rounding_factor';
388: l_attr_rec.code := 'rounding_factor';
389: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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 := 'SHIP_METHOD_CODE';

Line 393: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

389: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
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 := 'SHIP_METHOD_CODE';
395: l_attr_rec.type := 'VARCHAR2';
396: l_attr_rec.length := 30;
397: l_attr_rec.name := 'ship_method';

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

395: l_attr_rec.type := 'VARCHAR2';
396: l_attr_rec.length := 30;
397: l_attr_rec.name := 'ship_method';
398: l_attr_rec.code := 'ship_method_code';
399: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
400: l_attr_rec.value := TRUE;
401: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
402:
403: I := I + 1;

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

397: l_attr_rec.name := 'ship_method';
398: l_attr_rec.code := 'ship_method_code';
399: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
400: l_attr_rec.value := TRUE;
401: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
402:
403: I := I + 1;
404: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
405: l_attr_rec.column := 'START_DATE_ACTIVE';

Line 404: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

400: l_attr_rec.value := TRUE;
401: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
402:
403: I := I + 1;
404: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
405: l_attr_rec.column := 'START_DATE_ACTIVE';
406: l_attr_rec.type := 'DATE';
407: l_attr_rec.name := 'start_date_active';
408: l_attr_rec.code := 'start_date_active';

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

405: l_attr_rec.column := 'START_DATE_ACTIVE';
406: l_attr_rec.type := 'DATE';
407: l_attr_rec.name := 'start_date_active';
408: l_attr_rec.code := 'start_date_active';
409: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
410: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
411:
412: I := I + 1;
413: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

406: l_attr_rec.type := 'DATE';
407: l_attr_rec.name := 'start_date_active';
408: l_attr_rec.code := 'start_date_active';
409: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
410: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
411:
412: I := I + 1;
413: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
414: l_attr_rec.column := 'TERMS_ID';

Line 413: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

409: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
410: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
411:
412: I := I + 1;
413: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
414: l_attr_rec.column := 'TERMS_ID';
415: l_attr_rec.type := 'NUMBER';
416: l_attr_rec.name := 'terms';
417: l_attr_rec.code := 'terms_id';

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

414: l_attr_rec.column := 'TERMS_ID';
415: l_attr_rec.type := 'NUMBER';
416: l_attr_rec.name := 'terms';
417: l_attr_rec.code := 'terms_id';
418: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
419: l_attr_rec.value := TRUE;
420: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
421:
422: I := I + 1;

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

416: l_attr_rec.name := 'terms';
417: l_attr_rec.code := 'terms_id';
418: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
419: l_attr_rec.value := TRUE;
420: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
421:
422: I := I + 1;
423: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
424: l_attr_rec.type := 'VARCHAR2';

Line 423: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

419: l_attr_rec.value := TRUE;
420: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
421:
422: I := I + 1;
423: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
424: l_attr_rec.type := 'VARCHAR2';
425: l_attr_rec.length := 1;
426: l_attr_rec.name := 'return_status';
427: l_attr_rec.code := 'return_status';

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

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

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

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

Line 433: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 443: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

439: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
440: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
441:
442: I := I + 1;
443: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
444: l_attr_rec.type := 'VARCHAR2';
445: l_attr_rec.length := 30;
446: l_attr_rec.name := 'operation';
447: l_attr_rec.code := 'operation';

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

445: l_attr_rec.length := 30;
446: l_attr_rec.name := 'operation';
447: l_attr_rec.code := 'operation';
448: l_attr_rec.db_attr := FALSE;
449: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
450: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
451:
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

446: l_attr_rec.name := 'operation';
447: l_attr_rec.code := 'operation';
448: l_attr_rec.db_attr := FALSE;
449: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
450: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
451:
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
454: l_attr_rec.type := 'VARCHAR2';

Line 453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

449: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
450: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
451:
452: I := I + 1;
453: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
454: l_attr_rec.type := 'VARCHAR2';
455: l_attr_rec.length := 240;
456: l_attr_rec.name := 'name';
457: l_attr_rec.code := 'name';

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

455: l_attr_rec.length := 240;
456: l_attr_rec.name := 'name';
457: l_attr_rec.code := 'name';
458: l_attr_rec.db_attr := FALSE;
459: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
460: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
461:
462: I := I + 1;
463: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

456: l_attr_rec.name := 'name';
457: l_attr_rec.code := 'name';
458: l_attr_rec.db_attr := FALSE;
459: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
460: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
461:
462: I := I + 1;
463: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
464: l_attr_rec.type := 'VARCHAR2';

Line 463: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

459: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
460: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
461:
462: I := I + 1;
463: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
464: l_attr_rec.type := 'VARCHAR2';
465: l_attr_rec.length := 2000;
466: l_attr_rec.name := 'description';
467: l_attr_rec.code := 'description';

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

465: l_attr_rec.length := 2000;
466: l_attr_rec.name := 'description';
467: l_attr_rec.code := 'description';
468: l_attr_rec.db_attr := FALSE;
469: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
470: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
471:
472:
473: END Get_Attr_Tbl;

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

466: l_attr_rec.name := 'description';
467: l_attr_rec.code := 'description';
468: l_attr_rec.db_attr := FALSE;
469: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
470: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
471:
472:
473: END Get_Attr_Tbl;
474:

Line 479: l_attr_rec OE_GENERATE.Attribute_Rec_Type;

475: -- Procedure : Get_Attr_Value_Tbl
476:
477: PROCEDURE Get_Attr_Value_Tbl
478: IS
479: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
480: I NUMBER := 0;
481: BEGIN
482:
483: OE_GENERATE.g_attr_value_tbl.DELETE;

Line 483: OE_GENERATE.g_attr_value_tbl.DELETE;

479: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
480: I NUMBER := 0;
481: BEGIN
482:
483: OE_GENERATE.g_attr_value_tbl.DELETE;
484:
485: -- Load attribute values
486:
487: I := I + 1;

Line 488: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

484:
485: -- Load attribute values
486:
487: I := I + 1;
488: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
489: l_attr_rec.name := 'automatic';
490: l_attr_rec.code := 'automatic_flag';
491: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
492: l_attr_rec.length := 240;

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

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

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

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

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

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

Line 497: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

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

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

Line 506: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

505: I := I + 1;
506: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
507: l_attr_rec.name := 'discount_lines';
508: l_attr_rec.code := 'discount_lines_flag';
509: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
510: l_attr_rec.length := 240;
511: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
512: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
513:

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

507: l_attr_rec.name := 'discount_lines';
508: l_attr_rec.code := 'discount_lines_flag';
509: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
510: l_attr_rec.length := 240;
511: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
512: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
513:
514: I := I + 1;
515: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

508: l_attr_rec.code := 'discount_lines_flag';
509: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
510: l_attr_rec.length := 240;
511: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
512: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
513:
514: I := I + 1;
515: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
516: l_attr_rec.name := 'freight_terms';

Line 515: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

511: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
512: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
513:
514: I := I + 1;
515: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
516: l_attr_rec.name := 'freight_terms';
517: l_attr_rec.code := 'freight_terms_code';
518: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
519: l_attr_rec.length := 240;

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

514: I := I + 1;
515: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
516: l_attr_rec.name := 'freight_terms';
517: l_attr_rec.code := 'freight_terms_code';
518: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
519: l_attr_rec.length := 240;
520: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
521: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
522:

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

516: l_attr_rec.name := 'freight_terms';
517: l_attr_rec.code := 'freight_terms_code';
518: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
519: l_attr_rec.length := 240;
520: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
521: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
522:
523: I := I + 1;
524: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

517: l_attr_rec.code := 'freight_terms_code';
518: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
519: l_attr_rec.length := 240;
520: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
521: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
522:
523: I := I + 1;
524: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
525: l_attr_rec.name := 'list_header';

Line 524: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

520: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
521: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
522:
523: I := I + 1;
524: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
525: l_attr_rec.name := 'list_header';
526: l_attr_rec.code := 'list_header_id';
527: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
528: l_attr_rec.length := 240;

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

523: I := I + 1;
524: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
525: l_attr_rec.name := 'list_header';
526: l_attr_rec.code := 'list_header_id';
527: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
528: l_attr_rec.length := 240;
529: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
530: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
531:

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

525: l_attr_rec.name := 'list_header';
526: l_attr_rec.code := 'list_header_id';
527: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
528: l_attr_rec.length := 240;
529: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
530: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
531:
532: I := I + 1;
533: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

526: l_attr_rec.code := 'list_header_id';
527: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
528: l_attr_rec.length := 240;
529: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
530: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
531:
532: I := I + 1;
533: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
534: l_attr_rec.name := 'list_type';

Line 533: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

529: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
530: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
531:
532: I := I + 1;
533: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
534: l_attr_rec.name := 'list_type';
535: l_attr_rec.code := 'list_type_code';
536: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
537: l_attr_rec.length := 240;

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

532: I := I + 1;
533: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
534: l_attr_rec.name := 'list_type';
535: l_attr_rec.code := 'list_type_code';
536: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
537: l_attr_rec.length := 240;
538: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
539: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
540:

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

534: l_attr_rec.name := 'list_type';
535: l_attr_rec.code := 'list_type_code';
536: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
537: l_attr_rec.length := 240;
538: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
539: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
540:
541: I := I + 1;
542: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

535: l_attr_rec.code := 'list_type_code';
536: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
537: l_attr_rec.length := 240;
538: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
539: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
540:
541: I := I + 1;
542: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
543: l_attr_rec.name := 'prorate';

Line 542: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

538: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
539: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
540:
541: I := I + 1;
542: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
543: l_attr_rec.name := 'prorate';
544: l_attr_rec.code := 'prorate_flag';
545: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
546: l_attr_rec.length := 240;

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

541: I := I + 1;
542: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
543: l_attr_rec.name := 'prorate';
544: l_attr_rec.code := 'prorate_flag';
545: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
546: l_attr_rec.length := 240;
547: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
548: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
549:

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

543: l_attr_rec.name := 'prorate';
544: l_attr_rec.code := 'prorate_flag';
545: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
546: l_attr_rec.length := 240;
547: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
548: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
549:
550: I := I + 1;
551: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

544: l_attr_rec.code := 'prorate_flag';
545: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
546: l_attr_rec.length := 240;
547: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
548: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
549:
550: I := I + 1;
551: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
552: l_attr_rec.name := 'ship_method';

Line 551: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

547: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
548: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
549:
550: I := I + 1;
551: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
552: l_attr_rec.name := 'ship_method';
553: l_attr_rec.code := 'ship_method_code';
554: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
555: l_attr_rec.length := 240;

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

550: I := I + 1;
551: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
552: l_attr_rec.name := 'ship_method';
553: l_attr_rec.code := 'ship_method_code';
554: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
555: l_attr_rec.length := 240;
556: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
557: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
558:

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

552: l_attr_rec.name := 'ship_method';
553: l_attr_rec.code := 'ship_method_code';
554: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
555: l_attr_rec.length := 240;
556: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
557: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
558:
559: I := I + 1;
560: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

553: l_attr_rec.code := 'ship_method_code';
554: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
555: l_attr_rec.length := 240;
556: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
557: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
558:
559: I := I + 1;
560: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
561: l_attr_rec.name := 'terms';

Line 560: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

556: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
557: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
558:
559: I := I + 1;
560: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
561: l_attr_rec.name := 'terms';
562: l_attr_rec.code := 'terms_id';
563: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
564: l_attr_rec.length := 240;

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

559: I := I + 1;
560: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
561: l_attr_rec.name := 'terms';
562: l_attr_rec.code := 'terms_id';
563: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
564: l_attr_rec.length := 240;
565: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
566: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
567:

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

561: l_attr_rec.name := 'terms';
562: l_attr_rec.code := 'terms_id';
563: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
564: l_attr_rec.length := 240;
565: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
566: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
567:
568: END Get_Attr_Value_Tbl;
569:

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

562: l_attr_rec.code := 'terms_id';
563: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
564: l_attr_rec.length := 240;
565: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
566: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
567:
568: END Get_Attr_Value_Tbl;
569:
570: END QP_PRICE_LIST_ATTR;