APPS.QP_SSC_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 := 'APPLICATION_SHORT_NAME';
23: l_attr_rec.type := 'VARCHAR2';
24: l_attr_rec.length := 30;
25: l_attr_rec.name := 'application_short_name';

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

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

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

24: l_attr_rec.length := 30;
25: l_attr_rec.name := 'application_short_name';
26: l_attr_rec.code := 'application_short_name';
27: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
28: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
29:
30: I := I + 1;
31: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
32: l_attr_rec.column := 'ATTRIBUTE1';

Line 31: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

27: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
28: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
29:
30: I := I + 1;
31: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
32: l_attr_rec.column := 'ATTRIBUTE1';
33: l_attr_rec.type := 'VARCHAR2';
34: l_attr_rec.length := 240;
35: l_attr_rec.name := 'attribute1';

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

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

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

35: l_attr_rec.name := 'attribute1';
36: l_attr_rec.code := 'attribute1';
37: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
38: l_attr_rec.text1 := 'SSC';
39: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
40:
41: I := I + 1;
42: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
43: l_attr_rec.column := 'ATTRIBUTE10';

Line 42: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

38: l_attr_rec.text1 := 'SSC';
39: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
40:
41: I := I + 1;
42: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
43: l_attr_rec.column := 'ATTRIBUTE10';
44: l_attr_rec.type := 'VARCHAR2';
45: l_attr_rec.length := 240;
46: l_attr_rec.name := 'attribute10';

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

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

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

46: l_attr_rec.name := 'attribute10';
47: l_attr_rec.code := 'attribute10';
48: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
49: l_attr_rec.text1 := 'SSC';
50: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
51:
52: I := I + 1;
53: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
54: l_attr_rec.column := 'ATTRIBUTE11';

Line 53: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

49: l_attr_rec.text1 := 'SSC';
50: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
51:
52: I := I + 1;
53: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
54: l_attr_rec.column := 'ATTRIBUTE11';
55: l_attr_rec.type := 'VARCHAR2';
56: l_attr_rec.length := 240;
57: l_attr_rec.name := 'attribute11';

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

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

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

57: l_attr_rec.name := 'attribute11';
58: l_attr_rec.code := 'attribute11';
59: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
60: l_attr_rec.text1 := 'SSC';
61: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
62:
63: I := I + 1;
64: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
65: l_attr_rec.column := 'ATTRIBUTE12';

Line 64: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

60: l_attr_rec.text1 := 'SSC';
61: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
62:
63: I := I + 1;
64: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
65: l_attr_rec.column := 'ATTRIBUTE12';
66: l_attr_rec.type := 'VARCHAR2';
67: l_attr_rec.length := 240;
68: l_attr_rec.name := 'attribute12';

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

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

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

68: l_attr_rec.name := 'attribute12';
69: l_attr_rec.code := 'attribute12';
70: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
71: l_attr_rec.text1 := 'SSC';
72: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
73:
74: I := I + 1;
75: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
76: l_attr_rec.column := 'ATTRIBUTE13';

Line 75: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

71: l_attr_rec.text1 := 'SSC';
72: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
73:
74: I := I + 1;
75: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
76: l_attr_rec.column := 'ATTRIBUTE13';
77: l_attr_rec.type := 'VARCHAR2';
78: l_attr_rec.length := 240;
79: l_attr_rec.name := 'attribute13';

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

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

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

79: l_attr_rec.name := 'attribute13';
80: l_attr_rec.code := 'attribute13';
81: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
82: l_attr_rec.text1 := 'SSC';
83: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
84:
85: I := I + 1;
86: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
87: l_attr_rec.column := 'ATTRIBUTE14';

Line 86: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

82: l_attr_rec.text1 := 'SSC';
83: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
84:
85: I := I + 1;
86: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
87: l_attr_rec.column := 'ATTRIBUTE14';
88: l_attr_rec.type := 'VARCHAR2';
89: l_attr_rec.length := 240;
90: l_attr_rec.name := 'attribute14';

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

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

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

90: l_attr_rec.name := 'attribute14';
91: l_attr_rec.code := 'attribute14';
92: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
93: l_attr_rec.text1 := 'SSC';
94: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
95:
96: I := I + 1;
97: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
98: l_attr_rec.column := 'ATTRIBUTE15';

Line 97: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

93: l_attr_rec.text1 := 'SSC';
94: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
95:
96: I := I + 1;
97: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
98: l_attr_rec.column := 'ATTRIBUTE15';
99: l_attr_rec.type := 'VARCHAR2';
100: l_attr_rec.length := 240;
101: l_attr_rec.name := 'attribute15';

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

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

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

101: l_attr_rec.name := 'attribute15';
102: l_attr_rec.code := 'attribute15';
103: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
104: l_attr_rec.text1 := 'SSC';
105: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
106:
107: I := I + 1;
108: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
109: l_attr_rec.column := 'ATTRIBUTE2';

Line 108: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

104: l_attr_rec.text1 := 'SSC';
105: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
106:
107: I := I + 1;
108: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
109: l_attr_rec.column := 'ATTRIBUTE2';
110: l_attr_rec.type := 'VARCHAR2';
111: l_attr_rec.length := 240;
112: l_attr_rec.name := 'attribute2';

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

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

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

112: l_attr_rec.name := 'attribute2';
113: l_attr_rec.code := 'attribute2';
114: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
115: l_attr_rec.text1 := 'SSC';
116: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
117:
118: I := I + 1;
119: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
120: l_attr_rec.column := 'ATTRIBUTE3';

Line 119: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

115: l_attr_rec.text1 := 'SSC';
116: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
117:
118: I := I + 1;
119: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
120: l_attr_rec.column := 'ATTRIBUTE3';
121: l_attr_rec.type := 'VARCHAR2';
122: l_attr_rec.length := 240;
123: l_attr_rec.name := 'attribute3';

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

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

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

123: l_attr_rec.name := 'attribute3';
124: l_attr_rec.code := 'attribute3';
125: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
126: l_attr_rec.text1 := 'SSC';
127: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
128:
129: I := I + 1;
130: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
131: l_attr_rec.column := 'ATTRIBUTE4';

Line 130: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

126: l_attr_rec.text1 := 'SSC';
127: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
128:
129: I := I + 1;
130: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
131: l_attr_rec.column := 'ATTRIBUTE4';
132: l_attr_rec.type := 'VARCHAR2';
133: l_attr_rec.length := 240;
134: l_attr_rec.name := 'attribute4';

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

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

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

134: l_attr_rec.name := 'attribute4';
135: l_attr_rec.code := 'attribute4';
136: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
137: l_attr_rec.text1 := 'SSC';
138: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
139:
140: I := I + 1;
141: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
142: l_attr_rec.column := 'ATTRIBUTE5';

Line 141: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

137: l_attr_rec.text1 := 'SSC';
138: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
139:
140: I := I + 1;
141: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
142: l_attr_rec.column := 'ATTRIBUTE5';
143: l_attr_rec.type := 'VARCHAR2';
144: l_attr_rec.length := 240;
145: l_attr_rec.name := 'attribute5';

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

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

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

145: l_attr_rec.name := 'attribute5';
146: l_attr_rec.code := 'attribute5';
147: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
148: l_attr_rec.text1 := 'SSC';
149: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
150:
151: I := I + 1;
152: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
153: l_attr_rec.column := 'ATTRIBUTE6';

Line 152: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

148: l_attr_rec.text1 := 'SSC';
149: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
150:
151: I := I + 1;
152: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
153: l_attr_rec.column := 'ATTRIBUTE6';
154: l_attr_rec.type := 'VARCHAR2';
155: l_attr_rec.length := 240;
156: l_attr_rec.name := 'attribute6';

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

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

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

156: l_attr_rec.name := 'attribute6';
157: l_attr_rec.code := 'attribute6';
158: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
159: l_attr_rec.text1 := 'SSC';
160: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
161:
162: I := I + 1;
163: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
164: l_attr_rec.column := 'ATTRIBUTE7';

Line 163: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

159: l_attr_rec.text1 := 'SSC';
160: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
161:
162: I := I + 1;
163: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
164: l_attr_rec.column := 'ATTRIBUTE7';
165: l_attr_rec.type := 'VARCHAR2';
166: l_attr_rec.length := 240;
167: l_attr_rec.name := 'attribute7';

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

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

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

167: l_attr_rec.name := 'attribute7';
168: l_attr_rec.code := 'attribute7';
169: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
170: l_attr_rec.text1 := 'SSC';
171: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
172:
173: I := I + 1;
174: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
175: l_attr_rec.column := 'ATTRIBUTE8';

Line 174: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

170: l_attr_rec.text1 := 'SSC';
171: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
172:
173: I := I + 1;
174: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
175: l_attr_rec.column := 'ATTRIBUTE8';
176: l_attr_rec.type := 'VARCHAR2';
177: l_attr_rec.length := 240;
178: l_attr_rec.name := 'attribute8';

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

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

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

178: l_attr_rec.name := 'attribute8';
179: l_attr_rec.code := 'attribute8';
180: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
181: l_attr_rec.text1 := 'SSC';
182: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
183:
184: I := I + 1;
185: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
186: l_attr_rec.column := 'ATTRIBUTE9';

Line 185: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

181: l_attr_rec.text1 := 'SSC';
182: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
183:
184: I := I + 1;
185: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
186: l_attr_rec.column := 'ATTRIBUTE9';
187: l_attr_rec.type := 'VARCHAR2';
188: l_attr_rec.length := 240;
189: l_attr_rec.name := 'attribute9';

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

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

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

189: l_attr_rec.name := 'attribute9';
190: l_attr_rec.code := 'attribute9';
191: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
192: l_attr_rec.text1 := 'SSC';
193: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
194:
195: I := I + 1;
196: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
197: l_attr_rec.column := 'CONTEXT';

Line 196: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

192: l_attr_rec.text1 := 'SSC';
193: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
194:
195: I := I + 1;
196: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
197: l_attr_rec.column := 'CONTEXT';
198: l_attr_rec.type := 'VARCHAR2';
199: l_attr_rec.length := 30;
200: l_attr_rec.name := 'context';

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

198: l_attr_rec.type := 'VARCHAR2';
199: l_attr_rec.length := 30;
200: l_attr_rec.name := 'context';
201: l_attr_rec.code := 'context';
202: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
203: l_attr_rec.text1 := 'SSC';
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;

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

200: l_attr_rec.name := 'context';
201: l_attr_rec.code := 'context';
202: l_attr_rec.category := OE_GENERATE.G_CAT_DESC_FLEX;
203: l_attr_rec.text1 := 'SSC';
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
208: l_attr_rec.column := 'CREATED_BY';

Line 207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

203: l_attr_rec.text1 := 'SSC';
204: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
205:
206: I := I + 1;
207: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
208: l_attr_rec.column := 'CREATED_BY';
209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'created_by';
211: l_attr_rec.code := 'created_by';

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

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

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

209: l_attr_rec.type := 'NUMBER';
210: l_attr_rec.name := 'created_by';
211: l_attr_rec.code := 'created_by';
212: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
213: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
214:
215: I := I + 1;
216: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
217: l_attr_rec.column := 'CREATION_DATE';

Line 216: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

212: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
213: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
214:
215: I := I + 1;
216: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
217: l_attr_rec.column := 'CREATION_DATE';
218: l_attr_rec.type := 'DATE';
219: l_attr_rec.name := 'creation_date';
220: l_attr_rec.code := 'creation_date';

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

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

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

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

Line 225: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

221: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
222: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
223:
224: I := I + 1;
225: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
226: l_attr_rec.column := 'ENABLED_FLAG';
227: l_attr_rec.type := 'VARCHAR2';
228: l_attr_rec.length := 1;
229: l_attr_rec.name := 'enabled';

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

227: l_attr_rec.type := 'VARCHAR2';
228: l_attr_rec.length := 1;
229: l_attr_rec.name := 'enabled';
230: l_attr_rec.code := 'enabled_flag';
231: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
232: l_attr_rec.value := TRUE;
233: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
234:
235: I := I + 1;

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

229: l_attr_rec.name := 'enabled';
230: l_attr_rec.code := 'enabled_flag';
231: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
232: l_attr_rec.value := TRUE;
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 := 'LAST_UPDATED_BY';

Line 236: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

232: l_attr_rec.value := TRUE;
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 := 'LAST_UPDATED_BY';
238: l_attr_rec.type := 'NUMBER';
239: l_attr_rec.name := 'last_updated_by';
240: l_attr_rec.code := 'last_updated_by';

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

237: l_attr_rec.column := 'LAST_UPDATED_BY';
238: l_attr_rec.type := 'NUMBER';
239: l_attr_rec.name := 'last_updated_by';
240: l_attr_rec.code := 'last_updated_by';
241: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
242: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
243:
244: I := I + 1;
245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

238: l_attr_rec.type := 'NUMBER';
239: l_attr_rec.name := 'last_updated_by';
240: l_attr_rec.code := 'last_updated_by';
241: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
242: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
243:
244: I := I + 1;
245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
246: l_attr_rec.column := 'LAST_UPDATE_DATE';

Line 245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

241: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
242: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
243:
244: I := I + 1;
245: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
246: l_attr_rec.column := 'LAST_UPDATE_DATE';
247: l_attr_rec.type := 'DATE';
248: l_attr_rec.name := 'last_update_date';
249: l_attr_rec.code := 'last_update_date';

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

246: l_attr_rec.column := 'LAST_UPDATE_DATE';
247: l_attr_rec.type := 'DATE';
248: l_attr_rec.name := 'last_update_date';
249: l_attr_rec.code := 'last_update_date';
250: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
251: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
252:
253: I := I + 1;
254: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

Line 254: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

250: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
251: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
252:
253: I := I + 1;
254: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
255: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
256: l_attr_rec.type := 'NUMBER';
257: l_attr_rec.name := 'last_update_login';
258: l_attr_rec.code := 'last_update_login';

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

255: l_attr_rec.column := 'LAST_UPDATE_LOGIN';
256: l_attr_rec.type := 'NUMBER';
257: l_attr_rec.name := 'last_update_login';
258: l_attr_rec.code := 'last_update_login';
259: l_attr_rec.category := OE_GENERATE.G_CAT_WHO;
260: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
261:
262: I := I + 1;
263: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

Line 263: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 272: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 281: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 290: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

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

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

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

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

Line 301: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

297: l_attr_rec.value := TRUE;
298: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
299:
300: I := I + 1;
301: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
302: l_attr_rec.column := 'PTE_SOURCE_SYSTEM_ID';
303: l_attr_rec.type := 'NUMBER';
304: l_attr_rec.name := 'pte_source_system';
305: l_attr_rec.code := 'pte_source_system_id';

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

302: l_attr_rec.column := 'PTE_SOURCE_SYSTEM_ID';
303: l_attr_rec.type := 'NUMBER';
304: l_attr_rec.name := 'pte_source_system';
305: l_attr_rec.code := 'pte_source_system_id';
306: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
307: l_attr_rec.pk_flag := TRUE;
308: l_attr_rec.value := TRUE;
309: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
310:

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

305: l_attr_rec.code := 'pte_source_system_id';
306: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
307: l_attr_rec.pk_flag := TRUE;
308: l_attr_rec.value := TRUE;
309: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
310:
311: I := I + 1;
312: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
313: l_attr_rec.type := 'VARCHAR2';

Line 312: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

308: l_attr_rec.value := TRUE;
309: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
310:
311: I := I + 1;
312: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
313: l_attr_rec.type := 'VARCHAR2';
314: l_attr_rec.length := 1;
315: l_attr_rec.name := 'return_status';
316: l_attr_rec.code := 'return_status';

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

314: l_attr_rec.length := 1;
315: l_attr_rec.name := 'return_status';
316: l_attr_rec.code := 'return_status';
317: l_attr_rec.db_attr := FALSE;
318: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
319: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
320:
321: I := I + 1;
322: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

315: l_attr_rec.name := 'return_status';
316: l_attr_rec.code := 'return_status';
317: l_attr_rec.db_attr := FALSE;
318: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
319: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
320:
321: I := I + 1;
322: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
323: l_attr_rec.type := 'VARCHAR2';

Line 322: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

318: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
319: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
320:
321: I := I + 1;
322: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
323: l_attr_rec.type := 'VARCHAR2';
324: l_attr_rec.length := 1;
325: l_attr_rec.name := 'db_flag';
326: l_attr_rec.code := 'db_flag';

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

324: l_attr_rec.length := 1;
325: l_attr_rec.name := 'db_flag';
326: l_attr_rec.code := 'db_flag';
327: l_attr_rec.db_attr := FALSE;
328: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
329: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
330:
331: I := I + 1;
332: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

325: l_attr_rec.name := 'db_flag';
326: l_attr_rec.code := 'db_flag';
327: l_attr_rec.db_attr := FALSE;
328: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
329: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
330:
331: I := I + 1;
332: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
333: l_attr_rec.type := 'VARCHAR2';

Line 332: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

328: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
329: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
330:
331: I := I + 1;
332: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
333: l_attr_rec.type := 'VARCHAR2';
334: l_attr_rec.length := 30;
335: l_attr_rec.name := 'operation';
336: l_attr_rec.code := 'operation';

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

334: l_attr_rec.length := 30;
335: l_attr_rec.name := 'operation';
336: l_attr_rec.code := 'operation';
337: l_attr_rec.db_attr := FALSE;
338: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
339: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
340:
341: END Get_Attr_Tbl;
342:

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

335: l_attr_rec.name := 'operation';
336: l_attr_rec.code := 'operation';
337: l_attr_rec.db_attr := FALSE;
338: l_attr_rec.category := OE_GENERATE.G_CAT_TEMP;
339: OE_GENERATE.g_attr_tbl(I) := l_attr_rec;
340:
341: END Get_Attr_Tbl;
342:
343: -- Procedure : Get_Attr_Value_Tbl

Line 347: l_attr_rec OE_GENERATE.Attribute_Rec_Type;

343: -- Procedure : Get_Attr_Value_Tbl
344:
345: PROCEDURE Get_Attr_Value_Tbl
346: IS
347: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
348: I NUMBER := 0;
349: BEGIN
350:
351: OE_GENERATE.g_attr_value_tbl.DELETE;

Line 351: OE_GENERATE.g_attr_value_tbl.DELETE;

347: l_attr_rec OE_GENERATE.Attribute_Rec_Type;
348: I NUMBER := 0;
349: BEGIN
350:
351: OE_GENERATE.g_attr_value_tbl.DELETE;
352:
353: -- Load attribute values
354:
355: I := I + 1;

Line 356: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

352:
353: -- Load attribute values
354:
355: I := I + 1;
356: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
357: l_attr_rec.name := 'enabled';
358: l_attr_rec.code := 'enabled_flag';
359: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
360: l_attr_rec.length := 240;

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

355: I := I + 1;
356: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
357: l_attr_rec.name := 'enabled';
358: l_attr_rec.code := 'enabled_flag';
359: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
360: l_attr_rec.length := 240;
361: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
362: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
363:

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

357: l_attr_rec.name := 'enabled';
358: l_attr_rec.code := 'enabled_flag';
359: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
360: l_attr_rec.length := 240;
361: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
362: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
363:
364: I := I + 1;
365: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

358: l_attr_rec.code := 'enabled_flag';
359: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
360: l_attr_rec.length := 240;
361: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
362: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
363:
364: I := I + 1;
365: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
366: l_attr_rec.name := 'pte';

Line 365: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

361: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
362: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
363:
364: I := I + 1;
365: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
366: l_attr_rec.name := 'pte';
367: l_attr_rec.code := 'pte_code';
368: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
369: l_attr_rec.length := 240;

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

364: I := I + 1;
365: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
366: l_attr_rec.name := 'pte';
367: l_attr_rec.code := 'pte_code';
368: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
369: l_attr_rec.length := 240;
370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
371: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
372:

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

366: l_attr_rec.name := 'pte';
367: l_attr_rec.code := 'pte_code';
368: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
369: l_attr_rec.length := 240;
370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
371: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
372:
373: I := I + 1;
374: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

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

367: l_attr_rec.code := 'pte_code';
368: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
369: l_attr_rec.length := 240;
370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
371: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
372:
373: I := I + 1;
374: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
375: l_attr_rec.name := 'pte_source_system';

Line 374: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;

370: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
371: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
372:
373: I := I + 1;
374: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
375: l_attr_rec.name := 'pte_source_system';
376: l_attr_rec.code := 'pte_source_system_id';
377: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
378: l_attr_rec.length := 240;

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

373: I := I + 1;
374: l_attr_rec := OE_GENERATE.G_MISS_ATTR_REC;
375: l_attr_rec.name := 'pte_source_system';
376: l_attr_rec.code := 'pte_source_system_id';
377: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
378: l_attr_rec.length := 240;
379: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
380: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
381:

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

375: l_attr_rec.name := 'pte_source_system';
376: l_attr_rec.code := 'pte_source_system_id';
377: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
378: l_attr_rec.length := 240;
379: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
380: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
381:
382: END Get_Attr_Value_Tbl;
383:

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

376: l_attr_rec.code := 'pte_source_system_id';
377: l_attr_rec.type := OE_GENERATE.G_TYPE_CHAR;
378: l_attr_rec.length := 240;
379: l_attr_rec.category := OE_GENERATE.G_CAT_REGULAR;
380: OE_GENERATE.g_attr_value_tbl(I) := l_attr_rec;
381:
382: END Get_Attr_Value_Tbl;
383:
384: END QP_SSC_ATTR;