APPS.QP_PSG_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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'PSG';
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 := 'CONTEXT';

Line 186: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

182: l_attr_rec.text1 := 'PSG';
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 := 'CONTEXT';
188: l_attr_rec.type := 'VARCHAR2';
189: l_attr_rec.length := 30;
190: l_attr_rec.name := 'context';

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

188: l_attr_rec.type := 'VARCHAR2';
189: l_attr_rec.length := 30;
190: l_attr_rec.name := 'context';
191: l_attr_rec.code := 'context';
192: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
193: l_attr_rec.text1 := 'PSG';
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 := 'context';
191: l_attr_rec.code := 'context';
192: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
193: l_attr_rec.text1 := 'PSG';
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 := 'CREATED_BY';

Line 197: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

193: l_attr_rec.text1 := 'PSG';
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 := 'CREATED_BY';
199: l_attr_rec.type := 'NUMBER';
200: l_attr_rec.name := 'created_by';
201: l_attr_rec.code := 'created_by';

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

198: l_attr_rec.column := 'CREATED_BY';
199: l_attr_rec.type := 'NUMBER';
200: l_attr_rec.name := 'created_by';
201: l_attr_rec.code := 'created_by';
202: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'created_by';
201: l_attr_rec.code := 'created_by';
202: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'CREATION_DATE';

Line 206: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

202: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
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 := 'CREATION_DATE';
208: l_attr_rec.type := 'DATE';
209: l_attr_rec.name := 'creation_date';
210: l_attr_rec.code := 'creation_date';

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

207: l_attr_rec.column := 'CREATION_DATE';
208: l_attr_rec.type := 'DATE';
209: l_attr_rec.name := 'creation_date';
210: l_attr_rec.code := 'creation_date';
211: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
212: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
213:
214: I := I + 1;
215: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

208: l_attr_rec.type := 'DATE';
209: l_attr_rec.name := 'creation_date';
210: l_attr_rec.code := 'creation_date';
211: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
212: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
213:
214: I := I + 1;
215: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
216: l_attr_rec.column := 'LAST_UPDATED_BY';

Line 215: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

211: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
212: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
213:
214: I := I + 1;
215: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
216: l_attr_rec.column := 'LAST_UPDATED_BY';
217: l_attr_rec.type := 'NUMBER';
218: l_attr_rec.name := 'last_updated_by';
219: l_attr_rec.code := 'last_updated_by';

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

216: l_attr_rec.column := 'LAST_UPDATED_BY';
217: l_attr_rec.type := 'NUMBER';
218: l_attr_rec.name := 'last_updated_by';
219: l_attr_rec.code := 'last_updated_by';
220: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
221: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
222:
223: I := I + 1;
224: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

Line 224: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

225: l_attr_rec.column := 'LAST_UPDATE_DATE';
226: l_attr_rec.type := 'DATE';
227: l_attr_rec.name := 'last_update_date';
228: l_attr_rec.code := 'last_update_date';
229: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
230: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
231:
232: I := I + 1;
233: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

226: l_attr_rec.type := 'DATE';
227: l_attr_rec.name := 'last_update_date';
228: l_attr_rec.code := 'last_update_date';
229: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
230: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
231:
232: I := I + 1;
233: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
234: l_attr_rec.column := 'LAST_UPDATE_LOGIN';

Line 233: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

234: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
235: l_attr_rec.type := 'NUMBER';
236: l_attr_rec.name := 'last_update_login';
237: l_attr_rec.code := 'last_update_login';
238: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
239: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
240:
241: I := I + 1;
242: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

235: l_attr_rec.type := 'NUMBER';
236: l_attr_rec.name := 'last_update_login';
237: l_attr_rec.code := 'last_update_login';
238: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
239: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
240:
241: I := I + 1;
242: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
243: l_attr_rec.column := 'LIMITS_ENABLED';

Line 242: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

238: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
239: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
240:
241: I := I + 1;
242: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
243: l_attr_rec.column := 'LIMITS_ENABLED';
244: l_attr_rec.type := 'VARCHAR2';
245: l_attr_rec.length := 1;
246: l_attr_rec.name := 'limits_enabled';

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

244: l_attr_rec.type := 'VARCHAR2';
245: l_attr_rec.length := 1;
246: l_attr_rec.name := 'limits_enabled';
247: l_attr_rec.code := 'limits_enabled';
248: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
249: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
250:
251: I := I + 1;
252: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

245: l_attr_rec.length := 1;
246: l_attr_rec.name := 'limits_enabled';
247: l_attr_rec.code := 'limits_enabled';
248: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
249: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
250:
251: I := I + 1;
252: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
253: l_attr_rec.column := 'LOV_ENABLED';

Line 252: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

248: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
249: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
250:
251: I := I + 1;
252: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
253: l_attr_rec.column := 'LOV_ENABLED';
254: l_attr_rec.type := 'VARCHAR2';
255: l_attr_rec.length := 1;
256: l_attr_rec.name := 'lov_enabled';

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

254: l_attr_rec.type := 'VARCHAR2';
255: l_attr_rec.length := 1;
256: l_attr_rec.name := 'lov_enabled';
257: l_attr_rec.code := 'lov_enabled';
258: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
259: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
260:
261: I := I + 1;
262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

255: l_attr_rec.length := 1;
256: l_attr_rec.name := 'lov_enabled';
257: l_attr_rec.code := 'lov_enabled';
258: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
259: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
260:
261: I := I + 1;
262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
263: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';

Line 262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

258: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
259: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
260:
261: I := I + 1;
262: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
263: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
264: l_attr_rec.type := 'NUMBER';
265: l_attr_rec.name := 'program_application';
266: l_attr_rec.code := 'program_application_id';

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

263: l_attr_rec.column := 'PROGRAM_APPLICATION_ID';
264: l_attr_rec.type := 'NUMBER';
265: l_attr_rec.name := 'program_application';
266: l_attr_rec.code := 'program_application_id';
267: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
268: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
269:
270: I := I + 1;
271: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

Line 271: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

272: l_attr_rec.column := 'PROGRAM_ID';
273: l_attr_rec.type := 'NUMBER';
274: l_attr_rec.name := 'program';
275: l_attr_rec.code := 'program_id';
276: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
277: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
278:
279: I := I + 1;
280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

273: l_attr_rec.type := 'NUMBER';
274: l_attr_rec.name := 'program';
275: l_attr_rec.code := 'program_id';
276: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
277: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
278:
279: I := I + 1;
280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
281: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';

Line 280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

276: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
277: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
278:
279: I := I + 1;
280: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
281: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
282: l_attr_rec.type := 'DATE';
283: l_attr_rec.name := 'program_update_date';
284: l_attr_rec.code := 'program_update_date';

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

281: l_attr_rec.column := 'PROGRAM_UPDATE_DATE';
282: l_attr_rec.type := 'DATE';
283: l_attr_rec.name := 'program_update_date';
284: l_attr_rec.code := 'program_update_date';
285: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
286: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
287:
288: I := I + 1;
289: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

282: l_attr_rec.type := 'DATE';
283: l_attr_rec.name := 'program_update_date';
284: l_attr_rec.code := 'program_update_date';
285: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
286: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
287:
288: I := I + 1;
289: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
290: l_attr_rec.column := 'PTE_CODE';

Line 289: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

291: l_attr_rec.type := 'VARCHAR2';
292: l_attr_rec.length := 30;
293: l_attr_rec.name := 'pte';
294: l_attr_rec.code := 'pte_code';
295: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
296: l_attr_rec.value := TRUE;
297: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
298:
299: I := I + 1;

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

293: l_attr_rec.name := 'pte';
294: l_attr_rec.code := 'pte_code';
295: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
296: l_attr_rec.value := TRUE;
297: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
298:
299: I := I + 1;
300: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
301: l_attr_rec.column := 'SEEDED_SOURCING_METHOD';

Line 300: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

296: l_attr_rec.value := TRUE;
297: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
298:
299: I := I + 1;
300: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
301: l_attr_rec.column := 'SEEDED_SOURCING_METHOD';
302: l_attr_rec.type := 'VARCHAR2';
303: l_attr_rec.length := 30;
304: l_attr_rec.name := 'seeded_sourcing_method';

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

302: l_attr_rec.type := 'VARCHAR2';
303: l_attr_rec.length := 30;
304: l_attr_rec.name := 'seeded_sourcing_method';
305: l_attr_rec.code := 'seeded_sourcing_method';
306: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
307: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
308:
309: I := I + 1;
310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

303: l_attr_rec.length := 30;
304: l_attr_rec.name := 'seeded_sourcing_method';
305: l_attr_rec.code := 'seeded_sourcing_method';
306: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
307: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
308:
309: I := I + 1;
310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
311: l_attr_rec.column := 'SEGMENT_ID';

Line 310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

306: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
307: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
308:
309: I := I + 1;
310: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
311: l_attr_rec.column := 'SEGMENT_ID';
312: l_attr_rec.type := 'NUMBER';
313: l_attr_rec.name := 'segment';
314: l_attr_rec.code := 'segment_id';

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

311: l_attr_rec.column := 'SEGMENT_ID';
312: l_attr_rec.type := 'NUMBER';
313: l_attr_rec.name := 'segment';
314: l_attr_rec.code := 'segment_id';
315: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
316: l_attr_rec.value := TRUE;
317: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
318:
319: I := I + 1;

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

313: l_attr_rec.name := 'segment';
314: l_attr_rec.code := 'segment_id';
315: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
316: l_attr_rec.value := TRUE;
317: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
318:
319: I := I + 1;
320: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
321: l_attr_rec.column := 'SEGMENT_LEVEL';

Line 320: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

316: l_attr_rec.value := TRUE;
317: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
318:
319: I := I + 1;
320: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
321: l_attr_rec.column := 'SEGMENT_LEVEL';
322: l_attr_rec.type := 'VARCHAR2';
323: l_attr_rec.length := 10;
324: l_attr_rec.name := 'segment_level';

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

322: l_attr_rec.type := 'VARCHAR2';
323: l_attr_rec.length := 10;
324: l_attr_rec.name := 'segment_level';
325: l_attr_rec.code := 'segment_level';
326: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
327: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
328:
329: I := I + 1;
330: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

323: l_attr_rec.length := 10;
324: l_attr_rec.name := 'segment_level';
325: l_attr_rec.code := 'segment_level';
326: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
327: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
328:
329: I := I + 1;
330: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
331: l_attr_rec.column := 'SEGMENT_PTE_ID';

Line 330: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

326: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
327: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
328:
329: I := I + 1;
330: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
331: l_attr_rec.column := 'SEGMENT_PTE_ID';
332: l_attr_rec.type := 'NUMBER';
333: l_attr_rec.name := 'segment_pte';
334: l_attr_rec.code := 'segment_pte_id';

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

331: l_attr_rec.column := 'SEGMENT_PTE_ID';
332: l_attr_rec.type := 'NUMBER';
333: l_attr_rec.name := 'segment_pte';
334: l_attr_rec.code := 'segment_pte_id';
335: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
336: l_attr_rec.pk_flag := TRUE;
337: l_attr_rec.value := TRUE;
338: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
339:

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

334: l_attr_rec.code := 'segment_pte_id';
335: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
336: l_attr_rec.pk_flag := TRUE;
337: l_attr_rec.value := TRUE;
338: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
339:
340: I := I + 1;
341: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
342: l_attr_rec.column := 'SOURCING_ENABLED';

Line 341: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

337: l_attr_rec.value := TRUE;
338: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
339:
340: I := I + 1;
341: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
342: l_attr_rec.column := 'SOURCING_ENABLED';
343: l_attr_rec.type := 'VARCHAR2';
344: l_attr_rec.length := 1;
345: l_attr_rec.name := 'sourcing_enabled';

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

343: l_attr_rec.type := 'VARCHAR2';
344: l_attr_rec.length := 1;
345: l_attr_rec.name := 'sourcing_enabled';
346: l_attr_rec.code := 'sourcing_enabled';
347: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
348: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
349:
350: I := I + 1;
351: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

344: l_attr_rec.length := 1;
345: l_attr_rec.name := 'sourcing_enabled';
346: l_attr_rec.code := 'sourcing_enabled';
347: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
348: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
349:
350: I := I + 1;
351: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
352: l_attr_rec.column := 'SOURCING_STATUS';

Line 351: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

347: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
348: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
349:
350: I := I + 1;
351: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
352: l_attr_rec.column := 'SOURCING_STATUS';
353: l_attr_rec.type := 'VARCHAR2';
354: l_attr_rec.length := 1;
355: l_attr_rec.name := 'sourcing_status';

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

353: l_attr_rec.type := 'VARCHAR2';
354: l_attr_rec.length := 1;
355: l_attr_rec.name := 'sourcing_status';
356: l_attr_rec.code := 'sourcing_status';
357: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
358: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
359:
360: I := I + 1;
361: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

354: l_attr_rec.length := 1;
355: l_attr_rec.name := 'sourcing_status';
356: l_attr_rec.code := 'sourcing_status';
357: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
358: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
359:
360: I := I + 1;
361: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
362: l_attr_rec.column := 'USER_SOURCING_METHOD';

Line 361: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

357: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
358: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
359:
360: I := I + 1;
361: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
362: l_attr_rec.column := 'USER_SOURCING_METHOD';
363: l_attr_rec.type := 'VARCHAR2';
364: l_attr_rec.length := 30;
365: l_attr_rec.name := 'user_sourcing_method';

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

363: l_attr_rec.type := 'VARCHAR2';
364: l_attr_rec.length := 30;
365: l_attr_rec.name := 'user_sourcing_method';
366: l_attr_rec.code := 'user_sourcing_method';
367: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
368: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
369:
370: I := I + 1;
371: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

364: l_attr_rec.length := 30;
365: l_attr_rec.name := 'user_sourcing_method';
366: l_attr_rec.code := 'user_sourcing_method';
367: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
368: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
369:
370: I := I + 1;
371: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
372: l_attr_rec.type := 'VARCHAR2';

Line 371: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

367: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
368: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
369:
370: I := I + 1;
371: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
372: l_attr_rec.type := 'VARCHAR2';
373: l_attr_rec.length := 1;
374: l_attr_rec.name := 'return_status';
375: l_attr_rec.code := 'return_status';

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

373: l_attr_rec.length := 1;
374: l_attr_rec.name := 'return_status';
375: l_attr_rec.code := 'return_status';
376: l_attr_rec.db_attr := FALSE;
377: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
378: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
379:
380: I := I + 1;
381: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

374: l_attr_rec.name := 'return_status';
375: l_attr_rec.code := 'return_status';
376: l_attr_rec.db_attr := FALSE;
377: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
378: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
379:
380: I := I + 1;
381: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
382: l_attr_rec.type := 'VARCHAR2';

Line 381: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

377: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
378: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
379:
380: I := I + 1;
381: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
382: l_attr_rec.type := 'VARCHAR2';
383: l_attr_rec.length := 1;
384: l_attr_rec.name := 'db_flag';
385: l_attr_rec.code := 'db_flag';

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

383: l_attr_rec.length := 1;
384: l_attr_rec.name := 'db_flag';
385: l_attr_rec.code := 'db_flag';
386: l_attr_rec.db_attr := FALSE;
387: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
388: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
389:
390: I := I + 1;
391: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

384: l_attr_rec.name := 'db_flag';
385: l_attr_rec.code := 'db_flag';
386: l_attr_rec.db_attr := FALSE;
387: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
388: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
389:
390: I := I + 1;
391: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
392: l_attr_rec.type := 'VARCHAR2';

Line 391: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

387: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
388: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
389:
390: I := I + 1;
391: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
392: l_attr_rec.type := 'VARCHAR2';
393: l_attr_rec.length := 30;
394: l_attr_rec.name := 'operation';
395: l_attr_rec.code := 'operation';

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

393: l_attr_rec.length := 30;
394: l_attr_rec.name := 'operation';
395: l_attr_rec.code := 'operation';
396: l_attr_rec.db_attr := FALSE;
397: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
398: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
399:
400: END Get_Attr_Tbl;
401:

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

394: l_attr_rec.name := 'operation';
395: l_attr_rec.code := 'operation';
396: l_attr_rec.db_attr := FALSE;
397: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
398: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
399:
400: END Get_Attr_Tbl;
401:
402: -- Procedure : Get_Attr_Value_Tbl

Line 406: l_attr_rec OE_GENERATE.Attribute_Rec_Type;

402: -- Procedure : Get_Attr_Value_Tbl
403:
404: PROCEDURE Get_Attr_Value_Tbl
405: IS
406: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
407: I NUMBER := 0;
408: BEGIN
409:
410: OE_GENERATE.g_attr_value_tbl.DELETE;

Line 410: OE_GENERATE.g_attr_value_tbl.DELETE;

406: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
407: I NUMBER := 0;
408: BEGIN
409:
410: OE_GENERATE.g_attr_value_tbl.DELETE;
411:
412: -- Load attribute values
413:
414: I := I + 1;

Line 415: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

411:
412: -- Load attribute values
413:
414: I := I + 1;
415: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
416: l_attr_rec.name := 'pte';
417: l_attr_rec.code := 'pte_code';
418: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
419: l_attr_rec.length := 240;

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

414: I := I + 1;
415: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
416: l_attr_rec.name := 'pte';
417: l_attr_rec.code := 'pte_code';
418: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
419: l_attr_rec.length := 240;
420: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
421: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
422:

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

416: l_attr_rec.name := 'pte';
417: l_attr_rec.code := 'pte_code';
418: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
419: l_attr_rec.length := 240;
420: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
421: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
422:
423: I := I + 1;
424: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

417: l_attr_rec.code := 'pte_code';
418: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
419: l_attr_rec.length := 240;
420: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
421: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
422:
423: I := I + 1;
424: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
425: l_attr_rec.name := 'segment';

Line 424: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

420: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
421: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
422:
423: I := I + 1;
424: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
425: l_attr_rec.name := 'segment';
426: l_attr_rec.code := 'segment_id';
427: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
428: l_attr_rec.length := 240;

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

423: I := I + 1;
424: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
425: l_attr_rec.name := 'segment';
426: l_attr_rec.code := 'segment_id';
427: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
428: l_attr_rec.length := 240;
429: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
430: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
431:

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

425: l_attr_rec.name := 'segment';
426: l_attr_rec.code := 'segment_id';
427: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
428: l_attr_rec.length := 240;
429: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
430: OE_GENERATE.g_attr_value_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_value_tbl(I) := l_attr_rec;

426: l_attr_rec.code := 'segment_id';
427: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
428: l_attr_rec.length := 240;
429: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
430: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
431:
432: I := I + 1;
433: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
434: l_attr_rec.name := 'segment_pte';

Line 433: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

429: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
430: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
431:
432: I := I + 1;
433: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
434: l_attr_rec.name := 'segment_pte';
435: l_attr_rec.code := 'segment_pte_id';
436: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
437: l_attr_rec.length := 240;

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

432: I := I + 1;
433: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
434: l_attr_rec.name := 'segment_pte';
435: l_attr_rec.code := 'segment_pte_id';
436: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
437: l_attr_rec.length := 240;
438: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
439: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
440:

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

434: l_attr_rec.name := 'segment_pte';
435: l_attr_rec.code := 'segment_pte_id';
436: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
437: l_attr_rec.length := 240;
438: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
439: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
440:
441: END Get_Attr_Value_Tbl;
442:

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

435: l_attr_rec.code := 'segment_pte_id';
436: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
437: l_attr_rec.length := 240;
438: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
439: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
440:
441: END Get_Attr_Value_Tbl;
442:
443: END QP_PSG_ATTR;