37:
38: -- In the future call Flex APIs for defaults
39: x_eam_op_rec := p_eam_op_rec;
40:
41: IF p_eam_op_rec.attribute_category =FND_API.G_MISS_CHAR THEN
42: x_eam_op_rec.attribute_category := NULL;
43: END IF;
44:
45: IF p_eam_op_rec.attribute1 = FND_API.G_MISS_CHAR THEN
41: IF p_eam_op_rec.attribute_category =FND_API.G_MISS_CHAR THEN
42: x_eam_op_rec.attribute_category := NULL;
43: END IF;
44:
45: IF p_eam_op_rec.attribute1 = FND_API.G_MISS_CHAR THEN
46: x_eam_op_rec.attribute1 := NULL;
47: END IF;
48:
49: IF p_eam_op_rec.attribute2 = FND_API.G_MISS_CHAR THEN
45: IF p_eam_op_rec.attribute1 = FND_API.G_MISS_CHAR THEN
46: x_eam_op_rec.attribute1 := NULL;
47: END IF;
48:
49: IF p_eam_op_rec.attribute2 = FND_API.G_MISS_CHAR THEN
50: x_eam_op_rec.attribute2 := NULL;
51: END IF;
52:
53: IF p_eam_op_rec.attribute3 = FND_API.G_MISS_CHAR THEN
49: IF p_eam_op_rec.attribute2 = FND_API.G_MISS_CHAR THEN
50: x_eam_op_rec.attribute2 := NULL;
51: END IF;
52:
53: IF p_eam_op_rec.attribute3 = FND_API.G_MISS_CHAR THEN
54: x_eam_op_rec.attribute3 := NULL;
55: END IF;
56:
57: IF p_eam_op_rec.attribute4 = FND_API.G_MISS_CHAR THEN
53: IF p_eam_op_rec.attribute3 = FND_API.G_MISS_CHAR THEN
54: x_eam_op_rec.attribute3 := NULL;
55: END IF;
56:
57: IF p_eam_op_rec.attribute4 = FND_API.G_MISS_CHAR THEN
58: x_eam_op_rec.attribute4 := NULL;
59: END IF;
60:
61: IF p_eam_op_rec.attribute5 = FND_API.G_MISS_CHAR THEN
57: IF p_eam_op_rec.attribute4 = FND_API.G_MISS_CHAR THEN
58: x_eam_op_rec.attribute4 := NULL;
59: END IF;
60:
61: IF p_eam_op_rec.attribute5 = FND_API.G_MISS_CHAR THEN
62: x_eam_op_rec.attribute5 := NULL;
63: END IF;
64:
65: IF p_eam_op_rec.attribute6 = FND_API.G_MISS_CHAR THEN
61: IF p_eam_op_rec.attribute5 = FND_API.G_MISS_CHAR THEN
62: x_eam_op_rec.attribute5 := NULL;
63: END IF;
64:
65: IF p_eam_op_rec.attribute6 = FND_API.G_MISS_CHAR THEN
66: x_eam_op_rec.attribute6 := NULL;
67: END IF;
68:
69: IF p_eam_op_rec.attribute7 = FND_API.G_MISS_CHAR THEN
65: IF p_eam_op_rec.attribute6 = FND_API.G_MISS_CHAR THEN
66: x_eam_op_rec.attribute6 := NULL;
67: END IF;
68:
69: IF p_eam_op_rec.attribute7 = FND_API.G_MISS_CHAR THEN
70: x_eam_op_rec.attribute7 := NULL;
71: END IF;
72:
73: IF p_eam_op_rec.attribute8 = FND_API.G_MISS_CHAR THEN
69: IF p_eam_op_rec.attribute7 = FND_API.G_MISS_CHAR THEN
70: x_eam_op_rec.attribute7 := NULL;
71: END IF;
72:
73: IF p_eam_op_rec.attribute8 = FND_API.G_MISS_CHAR THEN
74: x_eam_op_rec.attribute8 := NULL;
75: END IF;
76:
77: IF p_eam_op_rec.attribute9 = FND_API.G_MISS_CHAR THEN
73: IF p_eam_op_rec.attribute8 = FND_API.G_MISS_CHAR THEN
74: x_eam_op_rec.attribute8 := NULL;
75: END IF;
76:
77: IF p_eam_op_rec.attribute9 = FND_API.G_MISS_CHAR THEN
78: x_eam_op_rec.attribute9 := NULL;
79: END IF;
80:
81: IF p_eam_op_rec.attribute10 = FND_API.G_MISS_CHAR THEN
77: IF p_eam_op_rec.attribute9 = FND_API.G_MISS_CHAR THEN
78: x_eam_op_rec.attribute9 := NULL;
79: END IF;
80:
81: IF p_eam_op_rec.attribute10 = FND_API.G_MISS_CHAR THEN
82: x_eam_op_rec.attribute10 := NULL;
83: END IF;
84:
85: IF p_eam_op_rec.attribute11 = FND_API.G_MISS_CHAR THEN
81: IF p_eam_op_rec.attribute10 = FND_API.G_MISS_CHAR THEN
82: x_eam_op_rec.attribute10 := NULL;
83: END IF;
84:
85: IF p_eam_op_rec.attribute11 = FND_API.G_MISS_CHAR THEN
86: x_eam_op_rec.attribute11 := NULL;
87: END IF;
88:
89: IF p_eam_op_rec.attribute12 = FND_API.G_MISS_CHAR THEN
85: IF p_eam_op_rec.attribute11 = FND_API.G_MISS_CHAR THEN
86: x_eam_op_rec.attribute11 := NULL;
87: END IF;
88:
89: IF p_eam_op_rec.attribute12 = FND_API.G_MISS_CHAR THEN
90: x_eam_op_rec.attribute12 := NULL;
91: END IF;
92:
93: IF p_eam_op_rec.attribute13 = FND_API.G_MISS_CHAR THEN
89: IF p_eam_op_rec.attribute12 = FND_API.G_MISS_CHAR THEN
90: x_eam_op_rec.attribute12 := NULL;
91: END IF;
92:
93: IF p_eam_op_rec.attribute13 = FND_API.G_MISS_CHAR THEN
94: x_eam_op_rec.attribute13 := NULL;
95: END IF;
96:
97: IF p_eam_op_rec.attribute14 = FND_API.G_MISS_CHAR THEN
93: IF p_eam_op_rec.attribute13 = FND_API.G_MISS_CHAR THEN
94: x_eam_op_rec.attribute13 := NULL;
95: END IF;
96:
97: IF p_eam_op_rec.attribute14 = FND_API.G_MISS_CHAR THEN
98: x_eam_op_rec.attribute14 := NULL;
99: END IF;
100:
101: IF p_eam_op_rec.attribute15 = FND_API.G_MISS_CHAR THEN
97: IF p_eam_op_rec.attribute14 = FND_API.G_MISS_CHAR THEN
98: x_eam_op_rec.attribute14 := NULL;
99: END IF;
100:
101: IF p_eam_op_rec.attribute15 = FND_API.G_MISS_CHAR THEN
102: x_eam_op_rec.attribute15 := NULL;
103: END IF;
104:
105: END get_flex_eam_op;
126: BEGIN
127:
128: x_eam_op_rec := p_eam_op_rec;
129: -- x_eam_op_rec := p_eam_op_rec;
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: IF p_eam_op_rec.count_point_type IS NULL OR
133: p_eam_op_rec.count_point_type = FND_API.G_MISS_NUM THEN
134: x_eam_op_rec.count_point_type := 1;
129: -- x_eam_op_rec := p_eam_op_rec;
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: IF p_eam_op_rec.count_point_type IS NULL OR
133: p_eam_op_rec.count_point_type = FND_API.G_MISS_NUM THEN
134: x_eam_op_rec.count_point_type := 1;
135: END IF;
136:
137: IF p_eam_op_rec.backflush_flag IS NULL OR
134: x_eam_op_rec.count_point_type := 1;
135: END IF;
136:
137: IF p_eam_op_rec.backflush_flag IS NULL OR
138: p_eam_op_rec.backflush_flag = FND_API.G_MISS_NUM THEN
139: x_eam_op_rec.backflush_flag := 2;
140: END IF;
141:
142: IF p_eam_op_rec.minimum_transfer_quantity IS NULL OR
139: x_eam_op_rec.backflush_flag := 2;
140: END IF;
141:
142: IF p_eam_op_rec.minimum_transfer_quantity IS NULL OR
143: p_eam_op_rec.minimum_transfer_quantity = FND_API.G_MISS_NUM THEN
144: x_eam_op_rec.minimum_transfer_quantity := 0;
145: END IF;
146:
147: l_eam_op_rec := x_eam_op_rec;
158: , p_message_text => G_PKG_NAME || SQLERRM
159: , x_mesg_token_Tbl => x_mesg_token_tbl
160: );
161:
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
163:
164: END Attribute_Defaulting;
165:
166:
187: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;
188:
189:
190: IF p_eam_op_rec.operation_sequence_id IS NULL OR
191: p_eam_op_rec.operation_sequence_id = FND_API.G_MISS_NUM
192: THEN
193: x_eam_op_rec.operation_sequence_id := p_old_eam_op_rec.operation_sequence_id;
194: END IF;
195:
193: x_eam_op_rec.operation_sequence_id := p_old_eam_op_rec.operation_sequence_id;
194: END IF;
195:
196: IF p_eam_op_rec.standard_operation_id IS NULL OR
197: p_eam_op_rec.standard_operation_id = FND_API.G_MISS_NUM
198: THEN
199: x_eam_op_rec.standard_operation_id := p_old_eam_op_rec.standard_operation_id;
200: END IF;
201:
199: x_eam_op_rec.standard_operation_id := p_old_eam_op_rec.standard_operation_id;
200: END IF;
201:
202: IF p_eam_op_rec.department_id IS NULL OR
203: p_eam_op_rec.department_id = FND_API.G_MISS_NUM
204: THEN
205: x_eam_op_rec.department_id := p_old_eam_op_rec.department_id;
206: END IF;
207:
206: END IF;
207:
208: /* commented for BUG#5997830
209: IF p_eam_op_rec.description IS NULL OR
210: p_eam_op_rec.description = FND_API.G_MISS_CHAR
211: THEN
212: x_eam_op_rec.description := p_old_eam_op_rec.description;
213: END IF;
214: */
213: END IF;
214: */
215:
216: IF p_eam_op_rec.start_date IS NULL OR
217: p_eam_op_rec.start_date = FND_API.G_MISS_DATE
218: THEN
219: x_eam_op_rec.start_date := p_old_eam_op_rec.start_date;
220: END IF;
221:
219: x_eam_op_rec.start_date := p_old_eam_op_rec.start_date;
220: END IF;
221:
222: IF p_eam_op_rec.completion_date IS NULL OR
223: p_eam_op_rec.completion_date = FND_API.G_MISS_DATE
224: THEN
225: x_eam_op_rec.completion_date := p_old_eam_op_rec.completion_date;
226: END IF;
227:
225: x_eam_op_rec.completion_date := p_old_eam_op_rec.completion_date;
226: END IF;
227:
228: IF p_eam_op_rec.count_point_type IS NULL OR
229: p_eam_op_rec.count_point_type = FND_API.G_MISS_NUM
230: THEN
231: x_eam_op_rec.count_point_type := p_old_eam_op_rec.count_point_type;
232: END IF;
233:
231: x_eam_op_rec.count_point_type := p_old_eam_op_rec.count_point_type;
232: END IF;
233:
234: IF p_eam_op_rec.backflush_flag IS NULL OR
235: p_eam_op_rec.backflush_flag = FND_API.G_MISS_NUM
236: THEN
237: x_eam_op_rec.backflush_flag := p_old_eam_op_rec.backflush_flag;
238: END IF;
239:
237: x_eam_op_rec.backflush_flag := p_old_eam_op_rec.backflush_flag;
238: END IF;
239:
240: IF p_eam_op_rec.minimum_transfer_quantity IS NULL OR
241: p_eam_op_rec.minimum_transfer_quantity = FND_API.G_MISS_NUM
242: THEN
243: x_eam_op_rec.minimum_transfer_quantity := p_old_eam_op_rec.minimum_transfer_quantity;
244: END IF;
245:
244: END IF;
245:
246: /* commented for BUG#5997830
247: IF p_eam_op_rec.shutdown_type IS NULL OR
248: p_eam_op_rec.shutdown_type = FND_API.G_MISS_CHAR
249: THEN
250: x_eam_op_rec.shutdown_type := p_old_eam_op_rec.shutdown_type;
251: END IF;
252: */
254: -- Populate Null or missng flex field columns
255: --
256: /* commented for BUG#5997830 --- start ---
257: IF p_eam_op_rec.attribute_category IS NULL OR
258: p_eam_op_rec.attribute_category = FND_API.G_MISS_CHAR
259: THEN
260: x_eam_op_rec.attribute_category := p_old_eam_op_rec.attribute_category;
261:
262: END IF;
260: x_eam_op_rec.attribute_category := p_old_eam_op_rec.attribute_category;
261:
262: END IF;
263:
264: IF p_eam_op_rec.attribute1 = FND_API.G_MISS_CHAR OR
265: p_eam_op_rec.attribute1 IS NULL
266: THEN
267: x_eam_op_rec.attribute1 := p_old_eam_op_rec.attribute1;
268: END IF;
266: THEN
267: x_eam_op_rec.attribute1 := p_old_eam_op_rec.attribute1;
268: END IF;
269:
270: IF p_eam_op_rec.attribute2 = FND_API.G_MISS_CHAR OR
271: p_eam_op_rec.attribute2 IS NULL
272: THEN
273: x_eam_op_rec.attribute2 := p_old_eam_op_rec.attribute2;
274: END IF;
272: THEN
273: x_eam_op_rec.attribute2 := p_old_eam_op_rec.attribute2;
274: END IF;
275:
276: IF p_eam_op_rec.attribute3 = FND_API.G_MISS_CHAR OR
277: p_eam_op_rec.attribute3 IS NULL
278: THEN
279: x_eam_op_rec.attribute3 := p_old_eam_op_rec.attribute3;
280: END IF;
278: THEN
279: x_eam_op_rec.attribute3 := p_old_eam_op_rec.attribute3;
280: END IF;
281:
282: IF p_eam_op_rec.attribute4 = FND_API.G_MISS_CHAR OR
283: p_eam_op_rec.attribute4 IS NULL
284: THEN
285: x_eam_op_rec.attribute4 := p_old_eam_op_rec.attribute4;
286: END IF;
284: THEN
285: x_eam_op_rec.attribute4 := p_old_eam_op_rec.attribute4;
286: END IF;
287:
288: IF p_eam_op_rec.attribute5 = FND_API.G_MISS_CHAR OR
289: p_eam_op_rec.attribute5 IS NULL
290: THEN
291: x_eam_op_rec.attribute5 := p_old_eam_op_rec.attribute5;
292: END IF;
290: THEN
291: x_eam_op_rec.attribute5 := p_old_eam_op_rec.attribute5;
292: END IF;
293:
294: IF p_eam_op_rec.attribute6 = FND_API.G_MISS_CHAR OR
295: p_eam_op_rec.attribute6 IS NULL
296: THEN
297: x_eam_op_rec.attribute6 := p_old_eam_op_rec.attribute6;
298: END IF;
296: THEN
297: x_eam_op_rec.attribute6 := p_old_eam_op_rec.attribute6;
298: END IF;
299:
300: IF p_eam_op_rec.attribute7 = FND_API.G_MISS_CHAR OR
301: p_eam_op_rec.attribute7 IS NULL
302: THEN
303: x_eam_op_rec.attribute7 := p_old_eam_op_rec.attribute7;
304: END IF;
302: THEN
303: x_eam_op_rec.attribute7 := p_old_eam_op_rec.attribute7;
304: END IF;
305:
306: IF p_eam_op_rec.attribute8 = FND_API.G_MISS_CHAR OR
307: p_eam_op_rec.attribute8 IS NULL
308: THEN
309: x_eam_op_rec.attribute8 := p_old_eam_op_rec.attribute8;
310: END IF;
308: THEN
309: x_eam_op_rec.attribute8 := p_old_eam_op_rec.attribute8;
310: END IF;
311:
312: IF p_eam_op_rec.attribute9 = FND_API.G_MISS_CHAR OR
313: p_eam_op_rec.attribute9 IS NULL
314: THEN
315: x_eam_op_rec.attribute9 := p_old_eam_op_rec.attribute9;
316: END IF;
314: THEN
315: x_eam_op_rec.attribute9 := p_old_eam_op_rec.attribute9;
316: END IF;
317:
318: IF p_eam_op_rec.attribute10 = FND_API.G_MISS_CHAR OR
319: p_eam_op_rec.attribute10 IS NULL
320: THEN
321: x_eam_op_rec.attribute10 := p_old_eam_op_rec.attribute10;
322: END IF;
320: THEN
321: x_eam_op_rec.attribute10 := p_old_eam_op_rec.attribute10;
322: END IF;
323:
324: IF p_eam_op_rec.attribute11 = FND_API.G_MISS_CHAR OR
325: p_eam_op_rec.attribute11 IS NULL
326: THEN
327: x_eam_op_rec.attribute11 := p_old_eam_op_rec.attribute11;
328: END IF;
326: THEN
327: x_eam_op_rec.attribute11 := p_old_eam_op_rec.attribute11;
328: END IF;
329:
330: IF p_eam_op_rec.attribute12 = FND_API.G_MISS_CHAR OR
331: p_eam_op_rec.attribute12 IS NULL
332: THEN
333: x_eam_op_rec.attribute12 := p_old_eam_op_rec.attribute12;
334: END IF;
332: THEN
333: x_eam_op_rec.attribute12 := p_old_eam_op_rec.attribute12;
334: END IF;
335:
336: IF p_eam_op_rec.attribute13 = FND_API.G_MISS_CHAR OR
337: p_eam_op_rec.attribute13 IS NULL
338: THEN
339: x_eam_op_rec.attribute13 := p_old_eam_op_rec.attribute13;
340: END IF;
338: THEN
339: x_eam_op_rec.attribute13 := p_old_eam_op_rec.attribute13;
340: END IF;
341:
342: IF p_eam_op_rec.attribute14 = FND_API.G_MISS_CHAR OR
343: p_eam_op_rec.attribute14 IS NULL
344: THEN
345: x_eam_op_rec.attribute14 := p_old_eam_op_rec.attribute14;
346: END IF;
344: THEN
345: x_eam_op_rec.attribute14 := p_old_eam_op_rec.attribute14;
346: END IF;
347:
348: IF p_eam_op_rec.attribute15 = FND_API.G_MISS_CHAR OR
349: p_eam_op_rec.attribute15 IS NULL
350: THEN
351: x_eam_op_rec.attribute15 := p_old_eam_op_rec.attribute15;
352: END IF;
350: THEN
351: x_eam_op_rec.attribute15 := p_old_eam_op_rec.attribute15;
352: END IF;
353:
354: IF p_eam_op_rec.long_description = FND_API.G_MISS_CHAR OR
355: p_eam_op_rec.long_description IS NULL
356: THEN
357: x_eam_op_rec.long_description := p_old_eam_op_rec.long_description;
358: END IF;