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

APPS.EAM_WO_DEFAULT_PVT dependencies on FND_API

Line 139: IF p_eam_wo_rec.attribute_category =FND_API.G_MISS_CHAR THEN

135:
136: -- In the future call Flex APIs for defaults
137: x_eam_wo_rec := p_eam_wo_rec;
138:
139: IF p_eam_wo_rec.attribute_category =FND_API.G_MISS_CHAR THEN
140: x_eam_wo_rec.attribute_category := NULL;
141: END IF;
142:
143: IF p_eam_wo_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 143: IF p_eam_wo_rec.attribute1 = FND_API.G_MISS_CHAR THEN

139: IF p_eam_wo_rec.attribute_category =FND_API.G_MISS_CHAR THEN
140: x_eam_wo_rec.attribute_category := NULL;
141: END IF;
142:
143: IF p_eam_wo_rec.attribute1 = FND_API.G_MISS_CHAR THEN
144: x_eam_wo_rec.attribute1 := NULL;
145: END IF;
146:
147: IF p_eam_wo_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 147: IF p_eam_wo_rec.attribute2 = FND_API.G_MISS_CHAR THEN

143: IF p_eam_wo_rec.attribute1 = FND_API.G_MISS_CHAR THEN
144: x_eam_wo_rec.attribute1 := NULL;
145: END IF;
146:
147: IF p_eam_wo_rec.attribute2 = FND_API.G_MISS_CHAR THEN
148: x_eam_wo_rec.attribute2 := NULL;
149: END IF;
150:
151: IF p_eam_wo_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 151: IF p_eam_wo_rec.attribute3 = FND_API.G_MISS_CHAR THEN

147: IF p_eam_wo_rec.attribute2 = FND_API.G_MISS_CHAR THEN
148: x_eam_wo_rec.attribute2 := NULL;
149: END IF;
150:
151: IF p_eam_wo_rec.attribute3 = FND_API.G_MISS_CHAR THEN
152: x_eam_wo_rec.attribute3 := NULL;
153: END IF;
154:
155: IF p_eam_wo_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 155: IF p_eam_wo_rec.attribute4 = FND_API.G_MISS_CHAR THEN

151: IF p_eam_wo_rec.attribute3 = FND_API.G_MISS_CHAR THEN
152: x_eam_wo_rec.attribute3 := NULL;
153: END IF;
154:
155: IF p_eam_wo_rec.attribute4 = FND_API.G_MISS_CHAR THEN
156: x_eam_wo_rec.attribute4 := NULL;
157: END IF;
158:
159: IF p_eam_wo_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 159: IF p_eam_wo_rec.attribute5 = FND_API.G_MISS_CHAR THEN

155: IF p_eam_wo_rec.attribute4 = FND_API.G_MISS_CHAR THEN
156: x_eam_wo_rec.attribute4 := NULL;
157: END IF;
158:
159: IF p_eam_wo_rec.attribute5 = FND_API.G_MISS_CHAR THEN
160: x_eam_wo_rec.attribute5 := NULL;
161: END IF;
162:
163: IF p_eam_wo_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 163: IF p_eam_wo_rec.attribute6 = FND_API.G_MISS_CHAR THEN

159: IF p_eam_wo_rec.attribute5 = FND_API.G_MISS_CHAR THEN
160: x_eam_wo_rec.attribute5 := NULL;
161: END IF;
162:
163: IF p_eam_wo_rec.attribute6 = FND_API.G_MISS_CHAR THEN
164: x_eam_wo_rec.attribute6 := NULL;
165: END IF;
166:
167: IF p_eam_wo_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 167: IF p_eam_wo_rec.attribute7 = FND_API.G_MISS_CHAR THEN

163: IF p_eam_wo_rec.attribute6 = FND_API.G_MISS_CHAR THEN
164: x_eam_wo_rec.attribute6 := NULL;
165: END IF;
166:
167: IF p_eam_wo_rec.attribute7 = FND_API.G_MISS_CHAR THEN
168: x_eam_wo_rec.attribute7 := NULL;
169: END IF;
170:
171: IF p_eam_wo_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 171: IF p_eam_wo_rec.attribute8 = FND_API.G_MISS_CHAR THEN

167: IF p_eam_wo_rec.attribute7 = FND_API.G_MISS_CHAR THEN
168: x_eam_wo_rec.attribute7 := NULL;
169: END IF;
170:
171: IF p_eam_wo_rec.attribute8 = FND_API.G_MISS_CHAR THEN
172: x_eam_wo_rec.attribute8 := NULL;
173: END IF;
174:
175: IF p_eam_wo_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 175: IF p_eam_wo_rec.attribute9 = FND_API.G_MISS_CHAR THEN

171: IF p_eam_wo_rec.attribute8 = FND_API.G_MISS_CHAR THEN
172: x_eam_wo_rec.attribute8 := NULL;
173: END IF;
174:
175: IF p_eam_wo_rec.attribute9 = FND_API.G_MISS_CHAR THEN
176: x_eam_wo_rec.attribute9 := NULL;
177: END IF;
178:
179: IF p_eam_wo_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 179: IF p_eam_wo_rec.attribute10 = FND_API.G_MISS_CHAR THEN

175: IF p_eam_wo_rec.attribute9 = FND_API.G_MISS_CHAR THEN
176: x_eam_wo_rec.attribute9 := NULL;
177: END IF;
178:
179: IF p_eam_wo_rec.attribute10 = FND_API.G_MISS_CHAR THEN
180: x_eam_wo_rec.attribute10 := NULL;
181: END IF;
182:
183: IF p_eam_wo_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 183: IF p_eam_wo_rec.attribute11 = FND_API.G_MISS_CHAR THEN

179: IF p_eam_wo_rec.attribute10 = FND_API.G_MISS_CHAR THEN
180: x_eam_wo_rec.attribute10 := NULL;
181: END IF;
182:
183: IF p_eam_wo_rec.attribute11 = FND_API.G_MISS_CHAR THEN
184: x_eam_wo_rec.attribute11 := NULL;
185: END IF;
186:
187: IF p_eam_wo_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 187: IF p_eam_wo_rec.attribute12 = FND_API.G_MISS_CHAR THEN

183: IF p_eam_wo_rec.attribute11 = FND_API.G_MISS_CHAR THEN
184: x_eam_wo_rec.attribute11 := NULL;
185: END IF;
186:
187: IF p_eam_wo_rec.attribute12 = FND_API.G_MISS_CHAR THEN
188: x_eam_wo_rec.attribute12 := NULL;
189: END IF;
190:
191: IF p_eam_wo_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 191: IF p_eam_wo_rec.attribute13 = FND_API.G_MISS_CHAR THEN

187: IF p_eam_wo_rec.attribute12 = FND_API.G_MISS_CHAR THEN
188: x_eam_wo_rec.attribute12 := NULL;
189: END IF;
190:
191: IF p_eam_wo_rec.attribute13 = FND_API.G_MISS_CHAR THEN
192: x_eam_wo_rec.attribute13 := NULL;
193: END IF;
194:
195: IF p_eam_wo_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 195: IF p_eam_wo_rec.attribute14 = FND_API.G_MISS_CHAR THEN

191: IF p_eam_wo_rec.attribute13 = FND_API.G_MISS_CHAR THEN
192: x_eam_wo_rec.attribute13 := NULL;
193: END IF;
194:
195: IF p_eam_wo_rec.attribute14 = FND_API.G_MISS_CHAR THEN
196: x_eam_wo_rec.attribute14 := NULL;
197: END IF;
198:
199: IF p_eam_wo_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 199: IF p_eam_wo_rec.attribute15 = FND_API.G_MISS_CHAR THEN

195: IF p_eam_wo_rec.attribute14 = FND_API.G_MISS_CHAR THEN
196: x_eam_wo_rec.attribute14 := NULL;
197: END IF;
198:
199: IF p_eam_wo_rec.attribute15 = FND_API.G_MISS_CHAR THEN
200: x_eam_wo_rec.attribute15 := NULL;
201: END IF;
202:
203: END get_flex_eam_wo;

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: );
270:
271:
272: x_eam_wo_rec := p_eam_wo_rec;
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: IF p_eam_wo_rec.wip_entity_id IS NULL OR
276: p_eam_wo_rec.wip_entity_id = FND_API.G_MISS_NUM
277: THEN

Line 276: p_eam_wo_rec.wip_entity_id = FND_API.G_MISS_NUM

272: x_eam_wo_rec := p_eam_wo_rec;
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: IF p_eam_wo_rec.wip_entity_id IS NULL OR
276: p_eam_wo_rec.wip_entity_id = FND_API.G_MISS_NUM
277: THEN
278: x_eam_wo_rec.wip_entity_id :=get_wip_entity_id;
279:
280: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new wip_entity_id : ' || to_char(x_eam_wo_rec.wip_entity_id)); END IF;

Line 285: p_eam_wo_rec.wip_entity_name = FND_API.G_MISS_CHAR

281:
282: END IF;
283:
284: IF p_eam_wo_rec.wip_entity_name IS NULL OR
285: p_eam_wo_rec.wip_entity_name = FND_API.G_MISS_CHAR
286: THEN
287: x_eam_wo_rec.wip_entity_name := get_wip_entity_name(p_eam_wo_rec.organization_id,p_eam_wo_rec.plan_maintenance);
288:
289:

Line 326: l_class_code <> FND_API.G_MISS_CHAR

322: x_msg_data => l_err_text
323: );
324:
325: IF l_class_code IS NOT NULL AND
326: l_class_code <> FND_API.G_MISS_CHAR
327: THEN
328: -- Default the WIP ACC Class
329: x_eam_wo_rec.class_code := l_class_code;
330:

Line 368: p_init_msg_list => FND_API.G_FALSE,

364: NVL(p_eam_wo_rec.asset_activity_id,-1) <> NVL(l_old_eam_wo_rec.asset_activity_id,-1)) commented for BUG#5609642 */ ) THEN --default if new workorder or activity is changed
365:
366: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default
367: (p_api_version => 1,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
371: x_return_status => l_return_status,
372: x_msg_count => l_msg_count,

Line 369: p_commit => FND_API.G_FALSE,

365:
366: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default
367: (p_api_version => 1,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
371: x_return_status => l_return_status,
372: x_msg_count => l_msg_count,
373: x_msg_data => l_err_text,

Line 370: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

366: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default
367: (p_api_version => 1,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
371: x_return_status => l_return_status,
372: x_msg_count => l_msg_count,
373: x_msg_data => l_err_text,
374: p_primary_item_id => p_eam_wo_rec.asset_activity_id,

Line 383: l_activity_cause <> FND_API.G_MISS_CHAR AND

379: x_activity_cause_code => l_activity_cause
380: );
381:
382: IF l_activity_cause IS NOT NULL AND
383: l_activity_cause <> FND_API.G_MISS_CHAR AND
384: p_eam_wo_rec.activity_cause IS NULL /* Added for BUG#5609642 */
385: THEN
386: x_eam_wo_rec.activity_cause := l_activity_cause;
387:

Line 393: p_init_msg_list => FND_API.G_FALSE,

389: END IF;
390:
391: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Type_Default
392: (p_api_version => 1,
393: p_init_msg_list => FND_API.G_FALSE,
394: p_commit => FND_API.G_FALSE,
395: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
396: x_return_status => l_return_status,
397: x_msg_count => l_msg_count,

Line 394: p_commit => FND_API.G_FALSE,

390:
391: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Type_Default
392: (p_api_version => 1,
393: p_init_msg_list => FND_API.G_FALSE,
394: p_commit => FND_API.G_FALSE,
395: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
396: x_return_status => l_return_status,
397: x_msg_count => l_msg_count,
398: x_msg_data => l_err_text,

Line 395: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

391: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Type_Default
392: (p_api_version => 1,
393: p_init_msg_list => FND_API.G_FALSE,
394: p_commit => FND_API.G_FALSE,
395: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
396: x_return_status => l_return_status,
397: x_msg_count => l_msg_count,
398: x_msg_data => l_err_text,
399: p_primary_item_id => p_eam_wo_rec.asset_activity_id,

Line 408: l_activity_type <> FND_API.G_MISS_CHAR AND

404: x_activity_type_code => l_activity_type
405: );
406:
407: IF l_activity_type IS NOT NULL AND
408: l_activity_type <> FND_API.G_MISS_CHAR AND
409: p_eam_wo_rec.activity_source IS NULL /* Added for BUG#5609642 */
410: THEN
411: x_eam_wo_rec.activity_type := l_activity_type;
412: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_type : ' || x_eam_wo_rec.activity_type); END IF;

Line 417: p_init_msg_list => FND_API.G_FALSE,

413: END IF;
414:
415: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Source_Default
416: (p_api_version => 1,
417: p_init_msg_list => FND_API.G_FALSE,
418: p_commit => FND_API.G_FALSE,
419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
420: x_return_status => l_return_status,
421: x_msg_count => l_msg_count,

Line 418: p_commit => FND_API.G_FALSE,

414:
415: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Source_Default
416: (p_api_version => 1,
417: p_init_msg_list => FND_API.G_FALSE,
418: p_commit => FND_API.G_FALSE,
419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
420: x_return_status => l_return_status,
421: x_msg_count => l_msg_count,
422: x_msg_data => l_err_text,

Line 419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

415: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Source_Default
416: (p_api_version => 1,
417: p_init_msg_list => FND_API.G_FALSE,
418: p_commit => FND_API.G_FALSE,
419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
420: x_return_status => l_return_status,
421: x_msg_count => l_msg_count,
422: x_msg_data => l_err_text,
423: p_primary_item_id => p_eam_wo_rec.asset_activity_id,

Line 432: l_activity_source <> FND_API.G_MISS_CHAR AND

428: x_activity_source_code => l_activity_source
429: );
430:
431: IF l_activity_source IS NOT NULL AND
432: l_activity_source <> FND_API.G_MISS_CHAR AND
433: p_eam_wo_rec.activity_source IS NULL /* Added for BUG#5609642 */
434: THEN
435: x_eam_wo_rec.activity_source := l_activity_source;
436: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_source : ' || x_eam_wo_rec.activity_source); END IF;

Line 441: p_init_msg_list => FND_API.G_FALSE,

437: END IF;
438:
439: WIP_EAMWORKORDER_PVT.Get_EAM_Shutdown_Default
440: (p_api_version => 1,
441: p_init_msg_list => FND_API.G_FALSE,
442: p_commit => FND_API.G_FALSE,
443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,

Line 442: p_commit => FND_API.G_FALSE,

438:
439: WIP_EAMWORKORDER_PVT.Get_EAM_Shutdown_Default
440: (p_api_version => 1,
441: p_init_msg_list => FND_API.G_FALSE,
442: p_commit => FND_API.G_FALSE,
443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,
446: x_msg_data => l_err_text,

Line 443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

439: WIP_EAMWORKORDER_PVT.Get_EAM_Shutdown_Default
440: (p_api_version => 1,
441: p_init_msg_list => FND_API.G_FALSE,
442: p_commit => FND_API.G_FALSE,
443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,
446: x_msg_data => l_err_text,
447: p_primary_item_id => p_eam_wo_rec.asset_activity_id,

Line 456: l_shutdown_type <> FND_API.G_MISS_CHAR AND

452: x_shutdown_type_code => l_shutdown_type
453: );
454:
455: IF l_shutdown_type IS NOT NULL AND
456: l_shutdown_type <> FND_API.G_MISS_CHAR AND
457: p_eam_wo_rec.shutdown_type IS NULL /* Added for BUG#5609642 */
458: THEN
459: x_eam_wo_rec.shutdown_type := l_shutdown_type;
460: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new shutdown_type : ' || x_eam_wo_rec.shutdown_type); END IF;

Line 465: p_init_msg_list => FND_API.G_FALSE,

461: END IF;
462:
463: WIP_EAMWORKORDER_PVT.Get_EAM_Notification_Default
464: (p_api_version => 1,
465: p_init_msg_list => FND_API.G_FALSE,
466: p_commit => FND_API.G_FALSE,
467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
468: x_return_status => l_return_status,
469: x_msg_count => l_msg_count,

Line 466: p_commit => FND_API.G_FALSE,

462:
463: WIP_EAMWORKORDER_PVT.Get_EAM_Notification_Default
464: (p_api_version => 1,
465: p_init_msg_list => FND_API.G_FALSE,
466: p_commit => FND_API.G_FALSE,
467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
468: x_return_status => l_return_status,
469: x_msg_count => l_msg_count,
470: x_msg_data => l_err_text,

Line 467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

463: WIP_EAMWORKORDER_PVT.Get_EAM_Notification_Default
464: (p_api_version => 1,
465: p_init_msg_list => FND_API.G_FALSE,
466: p_commit => FND_API.G_FALSE,
467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
468: x_return_status => l_return_status,
469: x_msg_count => l_msg_count,
470: x_msg_data => l_err_text,
471: p_primary_item_id => p_eam_wo_rec.asset_activity_id,

Line 480: l_notification_required <> FND_API.G_MISS_CHAR AND

476: x_notification_flag => l_notification_required
477: );
478:
479: IF l_notification_required IS NOT NULL AND
480: l_notification_required <> FND_API.G_MISS_CHAR AND
481: p_eam_wo_rec.notification_required IS NULL /* Added for BUG#5609642 */
482: THEN
483: x_eam_wo_rec.notification_required := l_notification_required;
484: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new notification_required : ' || x_eam_wo_rec.notification_required); END IF;

Line 489: p_init_msg_list => FND_API.G_FALSE,

485: END IF;
486:
487: WIP_EAMWORKORDER_PVT.Get_EAM_Tagout_Default
488: (p_api_version => 1,
489: p_init_msg_list => FND_API.G_FALSE,
490: p_commit => FND_API.G_FALSE,
491: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
492: x_return_status => l_return_status,
493: x_msg_count => l_msg_count,

Line 490: p_commit => FND_API.G_FALSE,

486:
487: WIP_EAMWORKORDER_PVT.Get_EAM_Tagout_Default
488: (p_api_version => 1,
489: p_init_msg_list => FND_API.G_FALSE,
490: p_commit => FND_API.G_FALSE,
491: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
492: x_return_status => l_return_status,
493: x_msg_count => l_msg_count,
494: x_msg_data => l_err_text,

Line 491: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

487: WIP_EAMWORKORDER_PVT.Get_EAM_Tagout_Default
488: (p_api_version => 1,
489: p_init_msg_list => FND_API.G_FALSE,
490: p_commit => FND_API.G_FALSE,
491: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
492: x_return_status => l_return_status,
493: x_msg_count => l_msg_count,
494: x_msg_data => l_err_text,
495: p_primary_item_id => p_eam_wo_rec.asset_activity_id,

Line 504: l_tagout_required <> FND_API.G_MISS_CHAR AND

500: x_tagout_required => l_tagout_required
501: );
502:
503: IF l_tagout_required IS NOT NULL AND
504: l_tagout_required <> FND_API.G_MISS_CHAR AND
505: p_eam_wo_rec.tagout_required IS NULL /* Added for BUG#5609642 */
506: THEN
507: x_eam_wo_rec.tagout_required := l_tagout_required;
508: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new tagout_default : ' || x_eam_wo_rec.tagout_required); END IF;

Line 519: IF p_eam_wo_rec.asset_activity_id IS NOT NULL AND p_eam_wo_rec.asset_activity_id <> FND_API.G_MISS_NUM

515: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting owning department, priority, etc'); END IF;
516:
517: -- Defaulting Owning Dept, Priority.
518:
519: IF p_eam_wo_rec.asset_activity_id IS NOT NULL AND p_eam_wo_rec.asset_activity_id <> FND_API.G_MISS_NUM
520: THEN
521: -- WO with Activity
522:
523: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR

Line 554: l_owning_department <> FND_API.G_MISS_NUM AND

550: AND meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id;
551:
552:
553: IF l_owning_department IS NOT NULL AND
554: l_owning_department <> FND_API.G_MISS_NUM AND
555: p_eam_wo_rec.owning_department IS NULL /* Added for BUG#5609642 */
556: THEN
557: x_eam_wo_rec.owning_department := l_owning_department;
558: END IF;

Line 567: l_priority <> FND_API.G_MISS_NUM AND

563: where organization_id = p_eam_wo_rec.organization_id;
564: END IF;
565:
566: IF l_priority IS NOT NULL AND
567: l_priority <> FND_API.G_MISS_NUM AND
568: p_eam_wo_rec.priority IS NULL /* Added for BUG#5609642 */
569: THEN
570: x_eam_wo_rec.priority := l_priority;
571: END IF;

Line 596: l_owning_department <> FND_API.G_MISS_NUM AND

592: AND meaa.maintenance_object_type = 2
593: and meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id;
594:
595: IF l_owning_department IS NOT NULL AND
596: l_owning_department <> FND_API.G_MISS_NUM AND
597: p_eam_wo_rec.owning_department IS NULL /* Added for BUG#5609642 */
598: THEN
599: x_eam_wo_rec.owning_department := l_owning_department;
600: END IF;

Line 609: l_priority <> FND_API.G_MISS_NUM AND

605: where organization_id = p_eam_wo_rec.organization_id;
606: END IF;
607:
608: IF l_priority IS NOT NULL AND
609: l_priority <> FND_API.G_MISS_NUM AND
610: p_eam_wo_rec.priority IS NULL /* Added for BUG#5609642 */
611: THEN
612: x_eam_wo_rec.priority := l_priority;
613: END IF;

Line 630: x_return_status := FND_API.G_RET_STS_ERROR;

626: , x_mesg_token_tbl => l_out_mesg_token_tbl
627: );
628: l_mesg_token_tbl := l_out_mesg_token_tbl;
629:
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: x_mesg_token_tbl := l_mesg_token_tbl ;
632:
633: WHEN OTHERS THEN
634: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: , p_message_text => G_PKG_NAME || SQLERRM
637: , x_mesg_token_Tbl => x_mesg_token_tbl
638: );
639:
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: END;
642: END IF; --end of check for activity changed/workorder created
643:
644: ELSIF x_eam_wo_rec.owning_department IS NULL and (p_eam_wo_rec.maintenance_object_type = 3)

Line 664: l_owning_department <> FND_API.G_MISS_NUM THEN

660: and eomd.object_id (+) = cii.instance_id
661: and eomd.organization_id (+) = p_eam_wo_rec.organization_id;
662:
663: IF l_owning_department IS NOT NULL AND
664: l_owning_department <> FND_API.G_MISS_NUM THEN
665: x_eam_wo_rec.owning_department := l_owning_department;
666: END IF;
667:
668: IF l_priority IS NOT NULL AND

Line 669: l_priority <> FND_API.G_MISS_NUM AND

665: x_eam_wo_rec.owning_department := l_owning_department;
666: END IF;
667:
668: IF l_priority IS NOT NULL AND
669: l_priority <> FND_API.G_MISS_NUM AND
670: p_eam_wo_rec.priority IS NULL /* Added for BUG#5609642 */
671: THEN
672: x_eam_wo_rec.priority := l_priority;
673: END IF;

Line 738: x_return_status := FND_API.G_RET_STS_ERROR;

734: , x_mesg_token_tbl => l_out_mesg_token_tbl
735: );
736: l_mesg_token_tbl := l_out_mesg_token_tbl;
737:
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: x_mesg_token_tbl := l_mesg_token_tbl ;
740:
741: WHEN OTHERS THEN
742: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

744: , p_message_text => G_PKG_NAME || SQLERRM
745: , x_mesg_token_Tbl => x_mesg_token_tbl
746: );
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: END;
750: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;
751:
752: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;

Line 772: p_eam_wo_rec.issue_zero_cost_flag = FND_API.G_MISS_CHAR

768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting ISSUE_ZERO_COST_FLAG'); END IF;
769:
770: -- Defaulting ISSUE_ZERO_COST_FLAG
771: IF p_eam_wo_rec.issue_zero_cost_flag IS NULL OR
772: p_eam_wo_rec.issue_zero_cost_flag = FND_API.G_MISS_CHAR
773: THEN
774: SELECT
775: nvl(issue_zero_cost_flag,'N')
776: INTO x_eam_wo_rec.issue_zero_cost_flag

Line 786: p_eam_wo_rec.po_creation_time = FND_API.G_MISS_NUM

782: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('PO creation time'); END IF;
783:
784: -- Defaulting PO creation time
785: IF p_eam_wo_rec.po_creation_time IS NULL OR
786: p_eam_wo_rec.po_creation_time = FND_API.G_MISS_NUM
787: THEN
788: SELECT
789: po_creation_time
790: INTO x_eam_wo_rec.po_creation_time

Line 801: p_eam_wo_rec.firm_planned_flag = FND_API.G_MISS_NUM

797:
798: -- Defaulting Firm Planned Flag
799:
800: IF p_eam_wo_rec.firm_planned_flag IS NULL OR
801: p_eam_wo_rec.firm_planned_flag = FND_API.G_MISS_NUM
802: THEN
803: x_eam_wo_rec.firm_planned_flag := 2;
804:
805: -- Defaulting Firm Planned Flag when auto firm flag on create checked.

Line 859: p_eam_wo_rec.manual_rebuild_flag = FND_API.G_MISS_CHAR)

855: -- Defaulting Manual Rebuild Flag
856:
857: IF p_eam_wo_rec.rebuild_item_id is not null AND
858: (p_eam_wo_rec.manual_rebuild_flag IS NULL OR
859: p_eam_wo_rec.manual_rebuild_flag = FND_API.G_MISS_CHAR)
860: THEN
861: x_eam_wo_rec.manual_rebuild_flag := 'Y';
862:
863: END IF;

Line 871: p_eam_wo_rec.pm_suggested_start_date <> FND_API.G_MISS_DATE) OR

867:
868: -- Defaulting Scheduled Dates from the PM Suggested Dates
869:
870: IF (p_eam_wo_rec.pm_suggested_start_date IS NOT NULL AND
871: p_eam_wo_rec.pm_suggested_start_date <> FND_API.G_MISS_DATE) OR
872: (p_eam_wo_rec.pm_suggested_end_date IS NOT NULL AND
873: p_eam_wo_rec.pm_suggested_end_date <> FND_API.G_MISS_DATE)
874: THEN
875: x_eam_wo_rec.requested_start_date := p_eam_wo_rec.pm_suggested_start_date;

Line 873: p_eam_wo_rec.pm_suggested_end_date <> FND_API.G_MISS_DATE)

869:
870: IF (p_eam_wo_rec.pm_suggested_start_date IS NOT NULL AND
871: p_eam_wo_rec.pm_suggested_start_date <> FND_API.G_MISS_DATE) OR
872: (p_eam_wo_rec.pm_suggested_end_date IS NOT NULL AND
873: p_eam_wo_rec.pm_suggested_end_date <> FND_API.G_MISS_DATE)
874: THEN
875: x_eam_wo_rec.requested_start_date := p_eam_wo_rec.pm_suggested_start_date;
876: x_eam_wo_rec.due_date := p_eam_wo_rec.pm_suggested_end_date;
877:

Line 886: p_eam_wo_rec.scheduled_start_date <> FND_API.G_MISS_DATE AND

882:
883: -- Defaulting Requested Start Date
884:
885: IF p_eam_wo_rec.scheduled_start_date IS NOT NULL AND
886: p_eam_wo_rec.scheduled_start_date <> FND_API.G_MISS_DATE AND
887: p_eam_wo_rec.requested_start_date IS NULL AND
888: p_eam_wo_rec.due_date IS NULL and
889: x_eam_wo_rec.requested_start_date IS NULL and
890: x_eam_wo_rec.due_date IS NULL

Line 901: p_eam_wo_rec.material_issue_by_mo = FND_API.G_MISS_CHAR

897:
898: -- Defaulting the MATERIAL_ISSUE_BY_MO flag
899:
900: IF p_eam_wo_rec.material_issue_by_mo IS NULL OR
901: p_eam_wo_rec.material_issue_by_mo = FND_API.G_MISS_CHAR
902: THEN
903: select nvl(material_issue_by_mo,'N')
904: into x_eam_wo_rec.material_issue_by_mo
905: from wip_eam_parameters

Line 912: p_eam_wo_rec.job_quantity = FND_API.G_MISS_NUM

908:
909: -- Defaulting the job_quantity
910:
911: IF p_eam_wo_rec.job_quantity IS NULL OR
912: p_eam_wo_rec.job_quantity = FND_API.G_MISS_NUM
913: THEN
914: x_eam_wo_rec.job_quantity := 1;
915: END IF;
916:

Line 920: p_eam_wo_rec.wip_supply_type = FND_API.G_MISS_NUM

916:
917: -- Defaulting the wip_supply_type
918:
919: IF p_eam_wo_rec.wip_supply_type IS NULL OR
920: p_eam_wo_rec.wip_supply_type = FND_API.G_MISS_NUM
921: THEN
922: x_eam_wo_rec.wip_supply_type := 7;
923: END IF;
924:

Line 929: p_eam_wo_rec.failure_code_required = FND_API.G_MISS_CHAR

925:
926: -- Defaulting the FAILURE_CODE_REQUIRED flag .. bug # 4709084
927:
928: IF p_eam_wo_rec.failure_code_required IS NULL OR
929: p_eam_wo_rec.failure_code_required = FND_API.G_MISS_CHAR
930: THEN
931: x_eam_wo_rec.failure_code_required := 'N';
932: END IF;
933:

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

947: , p_message_text => G_PKG_NAME || SQLERRM
948: , x_mesg_token_Tbl => x_mesg_token_tbl
949: );
950:
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952:
953: END Attribute_Defaulting;
954:
955:

Line 973: x_return_status := FND_API.G_RET_STS_SUCCESS;

969:
970: BEGIN
971:
972: x_eam_wo_rec := p_eam_wo_rec;
973: x_return_status := FND_API.G_RET_STS_SUCCESS;
974:
975:
976: if (p_eam_wo_rec.maintenance_object_type = 3 and p_eam_wo_rec.maintenance_object_source = 1) then
977:

Line 1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1012: , p_message_text => G_PKG_NAME || SQLERRM
1013: , x_mesg_token_Tbl => x_mesg_token_tbl
1014: );
1015:
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017:
1018: END Conditional_Defaulting;
1019:
1020:

Line 1046: p_eam_wo_rec.wip_entity_name = FND_API.G_MISS_CHAR

1042: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;
1043:
1044:
1045: IF p_eam_wo_rec.wip_entity_name IS NULL OR
1046: p_eam_wo_rec.wip_entity_name = FND_API.G_MISS_CHAR
1047: THEN
1048: x_eam_wo_rec.wip_entity_name := p_old_eam_wo_rec.wip_entity_name;
1049: END IF;
1050:

Line 1056: IF p_eam_wo_rec.description = FND_API.G_MISS_CHAR

1052: THEN
1053: x_eam_wo_rec.description := p_old_eam_wo_rec.description;
1054: END IF;
1055:
1056: IF p_eam_wo_rec.description = FND_API.G_MISS_CHAR
1057: THEN
1058: x_eam_wo_rec.description := NULL;
1059: END IF;
1060:

Line 1077: p_eam_wo_rec.eam_linear_location_id = FND_API.G_MISS_NUM

1073: x_eam_wo_rec.rebuild_serial_number := p_old_eam_wo_rec.rebuild_serial_number;
1074: END IF;
1075:
1076: IF p_eam_wo_rec.eam_linear_location_id IS NULL OR
1077: p_eam_wo_rec.eam_linear_location_id = FND_API.G_MISS_NUM
1078: THEN
1079: x_eam_wo_rec.eam_linear_location_id := p_old_eam_wo_rec.eam_linear_location_id;
1080: END IF;
1081:

Line 1087: --if FND_API.G_MISS_xx is passed then set values to NULL

1083: THEN
1084: x_eam_wo_rec.rebuild_item_id := p_old_eam_wo_rec.rebuild_item_id;
1085: END IF;
1086:
1087: --if FND_API.G_MISS_xx is passed then set values to NULL
1088: IF p_eam_wo_rec.asset_number = FND_API.G_MISS_CHAR
1089: THEN
1090: x_eam_wo_rec.asset_number := NULL;
1091: END IF;

Line 1088: IF p_eam_wo_rec.asset_number = FND_API.G_MISS_CHAR

1084: x_eam_wo_rec.rebuild_item_id := p_old_eam_wo_rec.rebuild_item_id;
1085: END IF;
1086:
1087: --if FND_API.G_MISS_xx is passed then set values to NULL
1088: IF p_eam_wo_rec.asset_number = FND_API.G_MISS_CHAR
1089: THEN
1090: x_eam_wo_rec.asset_number := NULL;
1091: END IF;
1092:

Line 1093: IF p_eam_wo_rec.rebuild_serial_number = FND_API.G_MISS_CHAR

1089: THEN
1090: x_eam_wo_rec.asset_number := NULL;
1091: END IF;
1092:
1093: IF p_eam_wo_rec.rebuild_serial_number = FND_API.G_MISS_CHAR
1094: THEN
1095: x_eam_wo_rec.rebuild_serial_number := NULL;
1096: END IF;
1097:

Line 1098: IF p_eam_wo_rec.asset_group_id = FND_API.G_MISS_NUM

1094: THEN
1095: x_eam_wo_rec.rebuild_serial_number := NULL;
1096: END IF;
1097:
1098: IF p_eam_wo_rec.asset_group_id = FND_API.G_MISS_NUM
1099: THEN
1100: x_eam_wo_rec.asset_group_id := NULL;
1101: END IF;
1102:

Line 1103: IF p_eam_wo_rec.rebuild_item_id = FND_API.G_MISS_NUM

1099: THEN
1100: x_eam_wo_rec.asset_group_id := NULL;
1101: END IF;
1102:
1103: IF p_eam_wo_rec.rebuild_item_id = FND_API.G_MISS_NUM
1104: THEN
1105: x_eam_wo_rec.rebuild_item_id := NULL;
1106: END IF;
1107:

Line 1109: p_eam_wo_rec.class_code = FND_API.G_MISS_CHAR

1105: x_eam_wo_rec.rebuild_item_id := NULL;
1106: END IF;
1107:
1108: IF p_eam_wo_rec.class_code IS NULL OR
1109: p_eam_wo_rec.class_code = FND_API.G_MISS_CHAR
1110: THEN
1111: x_eam_wo_rec.class_code := p_old_eam_wo_rec.class_code;
1112: END IF;
1113:

Line 1114: IF p_eam_wo_rec.asset_activity_id IS NULL --OR p_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM

1110: THEN
1111: x_eam_wo_rec.class_code := p_old_eam_wo_rec.class_code;
1112: END IF;
1113:
1114: IF p_eam_wo_rec.asset_activity_id IS NULL --OR p_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM
1115: THEN
1116: x_eam_wo_rec.asset_activity_id := p_old_eam_wo_rec.asset_activity_id;
1117: END IF;
1118:

Line 1119: IF p_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM THEN

1115: THEN
1116: x_eam_wo_rec.asset_activity_id := p_old_eam_wo_rec.asset_activity_id;
1117: END IF;
1118:
1119: IF p_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM THEN
1120: x_eam_wo_rec.asset_activity_id := NULL;
1121: END IF;
1122:
1123:

Line 1129: IF p_eam_wo_rec.activity_type = FND_API.G_MISS_CHAR

1125: THEN
1126: x_eam_wo_rec.activity_type := p_old_eam_wo_rec.activity_type;
1127: END IF;
1128:
1129: IF p_eam_wo_rec.activity_type = FND_API.G_MISS_CHAR
1130: THEN
1131: x_eam_wo_rec.activity_type := NULL;
1132: END IF;
1133:

Line 1139: IF p_eam_wo_rec.activity_cause = FND_API.G_MISS_CHAR

1135: THEN
1136: x_eam_wo_rec.activity_cause := p_old_eam_wo_rec.activity_cause;
1137: END IF;
1138:
1139: IF p_eam_wo_rec.activity_cause = FND_API.G_MISS_CHAR
1140: THEN
1141: x_eam_wo_rec.activity_cause := NULL;
1142: END IF;
1143:

Line 1149: IF p_eam_wo_rec.activity_source = FND_API.G_MISS_CHAR

1145: THEN
1146: x_eam_wo_rec.activity_source := p_old_eam_wo_rec.activity_source;
1147: END IF;
1148:
1149: IF p_eam_wo_rec.activity_source = FND_API.G_MISS_CHAR
1150: THEN
1151: x_eam_wo_rec.activity_source := NULL;
1152: END IF;
1153:

Line 1155: p_eam_wo_rec.status_type = FND_API.G_MISS_NUM

1151: x_eam_wo_rec.activity_source := NULL;
1152: END IF;
1153:
1154: IF p_eam_wo_rec.status_type IS NULL OR
1155: p_eam_wo_rec.status_type = FND_API.G_MISS_NUM
1156: THEN
1157: x_eam_wo_rec.status_type := p_old_eam_wo_rec.status_type;
1158: END IF;
1159:

Line 1161: p_eam_wo_rec.user_defined_status_id = FND_API.G_MISS_NUM

1157: x_eam_wo_rec.status_type := p_old_eam_wo_rec.status_type;
1158: END IF;
1159:
1160: IF p_eam_wo_rec.user_defined_status_id IS NULL OR
1161: p_eam_wo_rec.user_defined_status_id = FND_API.G_MISS_NUM
1162: THEN
1163: x_eam_wo_rec.user_defined_status_id := p_old_eam_wo_rec.user_defined_status_id;
1164: END IF;
1165:

Line 1167: p_eam_wo_rec.job_quantity = FND_API.G_MISS_NUM

1163: x_eam_wo_rec.user_defined_status_id := p_old_eam_wo_rec.user_defined_status_id;
1164: END IF;
1165:
1166: IF p_eam_wo_rec.job_quantity IS NULL OR
1167: p_eam_wo_rec.job_quantity = FND_API.G_MISS_NUM
1168: THEN
1169: x_eam_wo_rec.job_quantity := p_old_eam_wo_rec.job_quantity;
1170: END IF;
1171:

Line 1173: p_eam_wo_rec.date_released = FND_API.G_MISS_DATE

1169: x_eam_wo_rec.job_quantity := p_old_eam_wo_rec.job_quantity;
1170: END IF;
1171:
1172: IF p_eam_wo_rec.date_released IS NULL OR
1173: p_eam_wo_rec.date_released = FND_API.G_MISS_DATE
1174: THEN
1175: x_eam_wo_rec.date_released := p_old_eam_wo_rec.date_released;
1176: END IF;
1177:

Line 1179: p_eam_wo_rec.owning_department = FND_API.G_MISS_NUM

1175: x_eam_wo_rec.date_released := p_old_eam_wo_rec.date_released;
1176: END IF;
1177:
1178: IF p_eam_wo_rec.owning_department IS NULL OR
1179: p_eam_wo_rec.owning_department = FND_API.G_MISS_NUM
1180: THEN
1181: x_eam_wo_rec.owning_department := p_old_eam_wo_rec.owning_department;
1182: END IF;
1183:

Line 1189: IF p_eam_wo_rec.priority = FND_API.G_MISS_NUM

1185: THEN
1186: x_eam_wo_rec.priority := p_old_eam_wo_rec.priority;
1187: END IF;
1188:
1189: IF p_eam_wo_rec.priority = FND_API.G_MISS_NUM
1190: THEN
1191: x_eam_wo_rec.priority := NULL;
1192: END IF;
1193:

Line 1199: IF p_eam_wo_rec.work_order_type = FND_API.G_MISS_CHAR

1195: THEN
1196: x_eam_wo_rec.work_order_type := p_old_eam_wo_rec.work_order_type;
1197: END IF;
1198:
1199: IF p_eam_wo_rec.work_order_type = FND_API.G_MISS_CHAR
1200: THEN
1201: x_eam_wo_rec.work_order_type := NULL;
1202: END IF;
1203:

Line 1207: p_eam_wo_rec.requested_start_date = FND_API.G_MISS_DATE) AND

1203:
1204: -- Requested Start Date and Due date will have to be handled
1205: -- together since only one of them can be not null
1206: IF (p_eam_wo_rec.requested_start_date IS NULL OR
1207: p_eam_wo_rec.requested_start_date = FND_API.G_MISS_DATE) AND
1208: (p_eam_wo_rec.due_date IS NULL OR
1209: p_eam_wo_rec.due_date = FND_API.G_MISS_DATE)
1210: THEN
1211: x_eam_wo_rec.requested_start_date := p_old_eam_wo_rec.requested_start_date;

Line 1209: p_eam_wo_rec.due_date = FND_API.G_MISS_DATE)

1205: -- together since only one of them can be not null
1206: IF (p_eam_wo_rec.requested_start_date IS NULL OR
1207: p_eam_wo_rec.requested_start_date = FND_API.G_MISS_DATE) AND
1208: (p_eam_wo_rec.due_date IS NULL OR
1209: p_eam_wo_rec.due_date = FND_API.G_MISS_DATE)
1210: THEN
1211: x_eam_wo_rec.requested_start_date := p_old_eam_wo_rec.requested_start_date;
1212: x_eam_wo_rec.due_date := p_old_eam_wo_rec.due_date;
1213: END IF;

Line 1220: p_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE) AND

1216: /*
1217: -- PM Suggested Start Date and PM Suggested End date will have to be handled
1218: -- together since only one of them can be not null
1219: IF (p_eam_wo_rec.pm_suggested_start_date IS NULL OR
1220: p_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE) AND
1221: (p_eam_wo_rec.pm_suggested_end_date IS NULL OR
1222: p_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)
1223: THEN
1224: x_eam_wo_rec.pm_suggested_start_date := p_old_eam_wo_rec.pm_suggested_start_date;

Line 1222: p_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)

1218: -- together since only one of them can be not null
1219: IF (p_eam_wo_rec.pm_suggested_start_date IS NULL OR
1220: p_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE) AND
1221: (p_eam_wo_rec.pm_suggested_end_date IS NULL OR
1222: p_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)
1223: THEN
1224: x_eam_wo_rec.pm_suggested_start_date := p_old_eam_wo_rec.pm_suggested_start_date;
1225: x_eam_wo_rec.pm_suggested_end_date := p_old_eam_wo_rec.pm_suggested_end_date;
1226: END IF;

Line 1231: p_eam_wo_rec.pm_base_meter_reading = FND_API.G_MISS_NUM

1227: */
1228:
1229:
1230: IF p_eam_wo_rec.pm_base_meter_reading IS NULL OR
1231: p_eam_wo_rec.pm_base_meter_reading = FND_API.G_MISS_NUM
1232: THEN
1233: x_eam_wo_rec.pm_base_meter_reading := p_old_eam_wo_rec.pm_base_meter_reading;
1234: END IF;
1235:

Line 1237: p_eam_wo_rec.pm_base_meter = FND_API.G_MISS_NUM

1233: x_eam_wo_rec.pm_base_meter_reading := p_old_eam_wo_rec.pm_base_meter_reading;
1234: END IF;
1235:
1236: IF p_eam_wo_rec.pm_base_meter IS NULL OR
1237: p_eam_wo_rec.pm_base_meter = FND_API.G_MISS_NUM
1238: THEN
1239: x_eam_wo_rec.pm_base_meter := p_old_eam_wo_rec.pm_base_meter;
1240: END IF;
1241:

Line 1248: IF p_eam_wo_rec.shutdown_type = FND_API.G_MISS_CHAR

1244: THEN
1245: x_eam_wo_rec.shutdown_type := p_old_eam_wo_rec.shutdown_type;
1246: END IF;
1247:
1248: IF p_eam_wo_rec.shutdown_type = FND_API.G_MISS_CHAR
1249: THEN
1250: x_eam_wo_rec.shutdown_type := NULL;
1251: END IF;
1252:

Line 1254: p_eam_wo_rec.firm_planned_flag = FND_API.G_MISS_NUM

1250: x_eam_wo_rec.shutdown_type := NULL;
1251: END IF;
1252:
1253: IF p_eam_wo_rec.firm_planned_flag IS NULL OR
1254: p_eam_wo_rec.firm_planned_flag = FND_API.G_MISS_NUM
1255: THEN
1256: x_eam_wo_rec.firm_planned_flag := p_old_eam_wo_rec.firm_planned_flag;
1257: END IF;
1258:

Line 1260: p_eam_wo_rec.issue_zero_cost_flag = FND_API.G_MISS_CHAR

1256: x_eam_wo_rec.firm_planned_flag := p_old_eam_wo_rec.firm_planned_flag;
1257: END IF;
1258:
1259: IF p_eam_wo_rec.issue_zero_cost_flag IS NULL OR
1260: p_eam_wo_rec.issue_zero_cost_flag = FND_API.G_MISS_CHAR
1261: THEN
1262: x_eam_wo_rec.issue_zero_cost_flag := p_old_eam_wo_rec.issue_zero_cost_flag;
1263: END IF;
1264:

Line 1266: p_eam_wo_rec.notification_required = FND_API.G_MISS_CHAR

1262: x_eam_wo_rec.issue_zero_cost_flag := p_old_eam_wo_rec.issue_zero_cost_flag;
1263: END IF;
1264:
1265: IF p_eam_wo_rec.notification_required IS NULL OR
1266: p_eam_wo_rec.notification_required = FND_API.G_MISS_CHAR
1267: THEN
1268: x_eam_wo_rec.notification_required := p_old_eam_wo_rec.notification_required;
1269: END IF;
1270:

Line 1272: p_eam_wo_rec.tagout_required = FND_API.G_MISS_CHAR

1268: x_eam_wo_rec.notification_required := p_old_eam_wo_rec.notification_required;
1269: END IF;
1270:
1271: IF p_eam_wo_rec.tagout_required IS NULL OR
1272: p_eam_wo_rec.tagout_required = FND_API.G_MISS_CHAR
1273: THEN
1274: x_eam_wo_rec.tagout_required := p_old_eam_wo_rec.tagout_required;
1275: END IF;
1276:

Line 1278: p_eam_wo_rec.plan_maintenance = FND_API.G_MISS_CHAR

1274: x_eam_wo_rec.tagout_required := p_old_eam_wo_rec.tagout_required;
1275: END IF;
1276:
1277: IF p_eam_wo_rec.plan_maintenance IS NULL OR
1278: p_eam_wo_rec.plan_maintenance = FND_API.G_MISS_CHAR
1279: THEN
1280: x_eam_wo_rec.plan_maintenance := p_old_eam_wo_rec.plan_maintenance;
1281: END IF;
1282:

Line 1285: p_eam_wo_rec.project_id = FND_API.G_MISS_NUM

1281: END IF;
1282:
1283: /* commented for bug 5346446
1284: IF p_eam_wo_rec.project_id IS NULL OR
1285: p_eam_wo_rec.project_id = FND_API.G_MISS_NUM
1286: THEN
1287: x_eam_wo_rec.project_id := p_old_eam_wo_rec.project_id;
1288: END IF;
1289:

Line 1291: p_eam_wo_rec.task_id = FND_API.G_MISS_NUM

1287: x_eam_wo_rec.project_id := p_old_eam_wo_rec.project_id;
1288: END IF;
1289:
1290: IF p_eam_wo_rec.task_id IS NULL OR
1291: p_eam_wo_rec.task_id = FND_API.G_MISS_NUM
1292: THEN
1293: x_eam_wo_rec.task_id := p_old_eam_wo_rec.task_id;
1294: END IF;*/
1295:

Line 1299: ELSIF p_eam_wo_rec.project_id = FND_API.G_MISS_NUM THEN

1295:
1296: /* Added for bug#5346446 Start */
1297: IF p_eam_wo_rec.project_id IS NULL THEN
1298: x_eam_wo_rec.project_id := p_old_eam_wo_rec.project_id;
1299: ELSIF p_eam_wo_rec.project_id = FND_API.G_MISS_NUM THEN
1300: x_eam_wo_rec.project_id := NULL;
1301: END IF;
1302:
1303: IF p_eam_wo_rec.task_id IS NULL THEN

Line 1305: ELSIF p_eam_wo_rec.task_id = FND_API.G_MISS_NUM THEN

1301: END IF;
1302:
1303: IF p_eam_wo_rec.task_id IS NULL THEN
1304: x_eam_wo_rec.task_id := p_old_eam_wo_rec.task_id;
1305: ELSIF p_eam_wo_rec.task_id = FND_API.G_MISS_NUM THEN
1306: x_eam_wo_rec.task_id := NULL;
1307: END IF;
1308: /* Added for bug#5346446 End */
1309:

Line 1311: p_eam_wo_rec.end_item_unit_number = FND_API.G_MISS_NUM

1307: END IF;
1308: /* Added for bug#5346446 End */
1309:
1310: IF p_eam_wo_rec.end_item_unit_number IS NULL OR
1311: p_eam_wo_rec.end_item_unit_number = FND_API.G_MISS_NUM
1312: THEN
1313: x_eam_wo_rec.end_item_unit_number := p_old_eam_wo_rec.end_item_unit_number;
1314: END IF;
1315:

Line 1317: p_eam_wo_rec.schedule_group_id = FND_API.G_MISS_NUM

1313: x_eam_wo_rec.end_item_unit_number := p_old_eam_wo_rec.end_item_unit_number;
1314: END IF;
1315:
1316: IF p_eam_wo_rec.schedule_group_id IS NULL OR
1317: p_eam_wo_rec.schedule_group_id = FND_API.G_MISS_NUM
1318: THEN
1319:
1320: x_eam_wo_rec.schedule_group_id := p_old_eam_wo_rec.schedule_group_id;
1321: END IF;

Line 1324: p_eam_wo_rec.bom_revision_date = FND_API.G_MISS_DATE

1320: x_eam_wo_rec.schedule_group_id := p_old_eam_wo_rec.schedule_group_id;
1321: END IF;
1322:
1323: IF p_eam_wo_rec.bom_revision_date IS NULL OR
1324: p_eam_wo_rec.bom_revision_date = FND_API.G_MISS_DATE
1325: THEN
1326: x_eam_wo_rec.bom_revision_date := p_old_eam_wo_rec.bom_revision_date;
1327: END IF;
1328:

Line 1330: p_eam_wo_rec.routing_revision_date = FND_API.G_MISS_DATE

1326: x_eam_wo_rec.bom_revision_date := p_old_eam_wo_rec.bom_revision_date;
1327: END IF;
1328:
1329: IF p_eam_wo_rec.routing_revision_date IS NULL OR
1330: p_eam_wo_rec.routing_revision_date = FND_API.G_MISS_DATE
1331: THEN
1332: x_eam_wo_rec.routing_revision_date := p_old_eam_wo_rec.routing_revision_date;
1333: END IF;
1334:

Line 1337: p_eam_wo_rec.alternate_routing_designator = FND_API.G_MISS_NUM

1333: END IF;
1334:
1335:
1336: IF p_eam_wo_rec.alternate_routing_designator IS NULL OR
1337: p_eam_wo_rec.alternate_routing_designator = FND_API.G_MISS_NUM
1338: THEN
1339: x_eam_wo_rec.alternate_routing_designator := p_old_eam_wo_rec.alternate_routing_designator;
1340: END IF;
1341:

Line 1343: p_eam_wo_rec.alternate_bom_designator = FND_API.G_MISS_NUM

1339: x_eam_wo_rec.alternate_routing_designator := p_old_eam_wo_rec.alternate_routing_designator;
1340: END IF;
1341:
1342: IF p_eam_wo_rec.alternate_bom_designator IS NULL OR
1343: p_eam_wo_rec.alternate_bom_designator = FND_API.G_MISS_NUM
1344: THEN
1345: x_eam_wo_rec.alternate_bom_designator := p_old_eam_wo_rec.alternate_bom_designator;
1346: END IF;
1347:

Line 1349: p_eam_wo_rec.routing_revision = FND_API.G_MISS_CHAR

1345: x_eam_wo_rec.alternate_bom_designator := p_old_eam_wo_rec.alternate_bom_designator;
1346: END IF;
1347:
1348: IF p_eam_wo_rec.routing_revision IS NULL OR
1349: p_eam_wo_rec.routing_revision = FND_API.G_MISS_CHAR
1350: THEN
1351: x_eam_wo_rec.routing_revision := p_old_eam_wo_rec.routing_revision;
1352: END IF;
1353:

Line 1355: p_eam_wo_rec.bom_revision = FND_API.G_MISS_CHAR

1351: x_eam_wo_rec.routing_revision := p_old_eam_wo_rec.routing_revision;
1352: END IF;
1353:
1354: IF p_eam_wo_rec.bom_revision IS NULL OR
1355: p_eam_wo_rec.bom_revision = FND_API.G_MISS_CHAR
1356: THEN
1357: x_eam_wo_rec.bom_revision := p_old_eam_wo_rec.bom_revision;
1358: END IF;
1359:

Line 1361: p_eam_wo_rec.manual_rebuild_flag = FND_API.G_MISS_CHAR

1357: x_eam_wo_rec.bom_revision := p_old_eam_wo_rec.bom_revision;
1358: END IF;
1359:
1360: IF p_eam_wo_rec.manual_rebuild_flag IS NULL OR
1361: p_eam_wo_rec.manual_rebuild_flag = FND_API.G_MISS_CHAR
1362: THEN
1363: x_eam_wo_rec.manual_rebuild_flag := p_old_eam_wo_rec.manual_rebuild_flag;
1364: END IF;
1365:

Line 1367: p_eam_wo_rec.material_account = FND_API.G_MISS_NUM

1363: x_eam_wo_rec.manual_rebuild_flag := p_old_eam_wo_rec.manual_rebuild_flag;
1364: END IF;
1365:
1366: IF p_eam_wo_rec.material_account IS NULL OR
1367: p_eam_wo_rec.material_account = FND_API.G_MISS_NUM
1368: THEN
1369: x_eam_wo_rec.material_account := p_old_eam_wo_rec.material_account;
1370: END IF;
1371:

Line 1373: p_eam_wo_rec.material_overhead_account = FND_API.G_MISS_NUM

1369: x_eam_wo_rec.material_account := p_old_eam_wo_rec.material_account;
1370: END IF;
1371:
1372: IF p_eam_wo_rec.material_overhead_account IS NULL OR
1373: p_eam_wo_rec.material_overhead_account = FND_API.G_MISS_NUM
1374: THEN
1375: x_eam_wo_rec.material_overhead_account := p_old_eam_wo_rec.material_overhead_account;
1376: END IF;
1377:

Line 1379: p_eam_wo_rec.resource_account = FND_API.G_MISS_NUM

1375: x_eam_wo_rec.material_overhead_account := p_old_eam_wo_rec.material_overhead_account;
1376: END IF;
1377:
1378: IF p_eam_wo_rec.resource_account IS NULL OR
1379: p_eam_wo_rec.resource_account = FND_API.G_MISS_NUM
1380: THEN
1381: x_eam_wo_rec.resource_account := p_old_eam_wo_rec.resource_account;
1382: END IF;
1383:

Line 1385: p_eam_wo_rec.outside_processing_account = FND_API.G_MISS_NUM

1381: x_eam_wo_rec.resource_account := p_old_eam_wo_rec.resource_account;
1382: END IF;
1383:
1384: IF p_eam_wo_rec.outside_processing_account IS NULL OR
1385: p_eam_wo_rec.outside_processing_account = FND_API.G_MISS_NUM
1386: THEN
1387: x_eam_wo_rec.outside_processing_account := p_old_eam_wo_rec.outside_processing_account;
1388: END IF;
1389:

Line 1391: p_eam_wo_rec.material_variance_account = FND_API.G_MISS_NUM

1387: x_eam_wo_rec.outside_processing_account := p_old_eam_wo_rec.outside_processing_account;
1388: END IF;
1389:
1390: IF p_eam_wo_rec.material_variance_account IS NULL OR
1391: p_eam_wo_rec.material_variance_account = FND_API.G_MISS_NUM
1392: THEN
1393: x_eam_wo_rec.material_variance_account := p_old_eam_wo_rec.material_variance_account;
1394: END IF;
1395:

Line 1397: p_eam_wo_rec.resource_variance_account = FND_API.G_MISS_NUM

1393: x_eam_wo_rec.material_variance_account := p_old_eam_wo_rec.material_variance_account;
1394: END IF;
1395:
1396: IF p_eam_wo_rec.resource_variance_account IS NULL OR
1397: p_eam_wo_rec.resource_variance_account = FND_API.G_MISS_NUM
1398: THEN
1399: x_eam_wo_rec.resource_variance_account := p_old_eam_wo_rec.resource_variance_account;
1400: END IF;
1401:

Line 1403: p_eam_wo_rec.outside_proc_variance_account = FND_API.G_MISS_NUM

1399: x_eam_wo_rec.resource_variance_account := p_old_eam_wo_rec.resource_variance_account;
1400: END IF;
1401:
1402: IF p_eam_wo_rec.outside_proc_variance_account IS NULL OR
1403: p_eam_wo_rec.outside_proc_variance_account = FND_API.G_MISS_NUM
1404: THEN
1405: x_eam_wo_rec.outside_proc_variance_account := p_old_eam_wo_rec.outside_proc_variance_account;
1406: END IF;
1407:

Line 1409: p_eam_wo_rec.std_cost_adjustment_account = FND_API.G_MISS_NUM

1405: x_eam_wo_rec.outside_proc_variance_account := p_old_eam_wo_rec.outside_proc_variance_account;
1406: END IF;
1407:
1408: IF p_eam_wo_rec.std_cost_adjustment_account IS NULL OR
1409: p_eam_wo_rec.std_cost_adjustment_account = FND_API.G_MISS_NUM
1410: THEN
1411: x_eam_wo_rec.std_cost_adjustment_account := p_old_eam_wo_rec.std_cost_adjustment_account;
1412: END IF;
1413:

Line 1415: p_eam_wo_rec.overhead_account = FND_API.G_MISS_NUM

1411: x_eam_wo_rec.std_cost_adjustment_account := p_old_eam_wo_rec.std_cost_adjustment_account;
1412: END IF;
1413:
1414: IF p_eam_wo_rec.overhead_account IS NULL OR
1415: p_eam_wo_rec.overhead_account = FND_API.G_MISS_NUM
1416: THEN
1417: x_eam_wo_rec.overhead_account := p_old_eam_wo_rec.overhead_account;
1418: END IF;
1419:

Line 1421: p_eam_wo_rec.overhead_variance_account = FND_API.G_MISS_NUM

1417: x_eam_wo_rec.overhead_account := p_old_eam_wo_rec.overhead_account;
1418: END IF;
1419:
1420: IF p_eam_wo_rec.overhead_variance_account IS NULL OR
1421: p_eam_wo_rec.overhead_variance_account = FND_API.G_MISS_NUM
1422: THEN
1423: x_eam_wo_rec.overhead_variance_account := p_old_eam_wo_rec.overhead_variance_account;
1424: END IF;
1425:

Line 1427: p_eam_wo_rec.scheduled_start_date = FND_API.G_MISS_DATE

1423: x_eam_wo_rec.overhead_variance_account := p_old_eam_wo_rec.overhead_variance_account;
1424: END IF;
1425:
1426: IF p_eam_wo_rec.scheduled_start_date IS NULL OR
1427: p_eam_wo_rec.scheduled_start_date = FND_API.G_MISS_DATE
1428: THEN
1429: x_eam_wo_rec.scheduled_start_date := p_old_eam_wo_rec.scheduled_start_date;
1430: END IF;
1431:

Line 1433: p_eam_wo_rec.scheduled_completion_date = FND_API.G_MISS_DATE

1429: x_eam_wo_rec.scheduled_start_date := p_old_eam_wo_rec.scheduled_start_date;
1430: END IF;
1431:
1432: IF p_eam_wo_rec.scheduled_completion_date IS NULL OR
1433: p_eam_wo_rec.scheduled_completion_date = FND_API.G_MISS_DATE
1434: THEN
1435: x_eam_wo_rec.scheduled_completion_date := p_old_eam_wo_rec.scheduled_completion_date;
1436: END IF;
1437:

Line 1439: p_eam_wo_rec.common_bom_sequence_id = FND_API.G_MISS_NUM

1435: x_eam_wo_rec.scheduled_completion_date := p_old_eam_wo_rec.scheduled_completion_date;
1436: END IF;
1437:
1438: IF p_eam_wo_rec.common_bom_sequence_id IS NULL OR
1439: p_eam_wo_rec.common_bom_sequence_id = FND_API.G_MISS_NUM
1440: THEN
1441: x_eam_wo_rec.common_bom_sequence_id := p_old_eam_wo_rec.common_bom_sequence_id;
1442: END IF;
1443:

Line 1445: p_eam_wo_rec.common_routing_sequence_id = FND_API.G_MISS_NUM

1441: x_eam_wo_rec.common_bom_sequence_id := p_old_eam_wo_rec.common_bom_sequence_id;
1442: END IF;
1443:
1444: IF p_eam_wo_rec.common_routing_sequence_id IS NULL OR
1445: p_eam_wo_rec.common_routing_sequence_id = FND_API.G_MISS_NUM
1446: THEN
1447: x_eam_wo_rec.common_routing_sequence_id := p_old_eam_wo_rec.common_routing_sequence_id;
1448: END IF;
1449:

Line 1451: p_eam_wo_rec.source_line_id = FND_API.G_MISS_NUM

1447: x_eam_wo_rec.common_routing_sequence_id := p_old_eam_wo_rec.common_routing_sequence_id;
1448: END IF;
1449:
1450: IF p_eam_wo_rec.source_line_id IS NULL OR
1451: p_eam_wo_rec.source_line_id = FND_API.G_MISS_NUM
1452: THEN
1453: x_eam_wo_rec.source_line_id := p_old_eam_wo_rec.source_line_id;
1454: END IF;
1455:

Line 1457: p_eam_wo_rec.source_code = FND_API.G_MISS_CHAR

1453: x_eam_wo_rec.source_line_id := p_old_eam_wo_rec.source_line_id;
1454: END IF;
1455:
1456: IF p_eam_wo_rec.source_code IS NULL OR
1457: p_eam_wo_rec.source_code = FND_API.G_MISS_CHAR
1458: THEN
1459: x_eam_wo_rec.source_code := p_old_eam_wo_rec.source_code;
1460: END IF;
1461:

Line 1463: p_eam_wo_rec.gen_object_id = FND_API.G_MISS_NUM

1459: x_eam_wo_rec.source_code := p_old_eam_wo_rec.source_code;
1460: END IF;
1461:
1462: IF p_eam_wo_rec.gen_object_id IS NULL OR
1463: p_eam_wo_rec.gen_object_id = FND_API.G_MISS_NUM
1464: THEN
1465: x_eam_wo_rec.gen_object_id := p_old_eam_wo_rec.gen_object_id;
1466: END IF;
1467:

Line 1469: p_eam_wo_rec.maintenance_object_id = FND_API.G_MISS_NUM

1465: x_eam_wo_rec.gen_object_id := p_old_eam_wo_rec.gen_object_id;
1466: END IF;
1467:
1468: IF p_eam_wo_rec.maintenance_object_id IS NULL OR
1469: p_eam_wo_rec.maintenance_object_id = FND_API.G_MISS_NUM
1470: THEN
1471: x_eam_wo_rec.maintenance_object_id := p_old_eam_wo_rec.maintenance_object_id;
1472: END IF;
1473:

Line 1475: p_eam_wo_rec.maintenance_object_type = FND_API.G_MISS_NUM

1471: x_eam_wo_rec.maintenance_object_id := p_old_eam_wo_rec.maintenance_object_id;
1472: END IF;
1473:
1474: IF p_eam_wo_rec.maintenance_object_type IS NULL OR
1475: p_eam_wo_rec.maintenance_object_type = FND_API.G_MISS_NUM
1476: THEN
1477: x_eam_wo_rec.maintenance_object_type := p_old_eam_wo_rec.maintenance_object_type;
1478: END IF;
1479:

Line 1481: p_eam_wo_rec.maintenance_object_source = FND_API.G_MISS_NUM

1477: x_eam_wo_rec.maintenance_object_type := p_old_eam_wo_rec.maintenance_object_type;
1478: END IF;
1479:
1480: IF p_eam_wo_rec.maintenance_object_source IS NULL OR
1481: p_eam_wo_rec.maintenance_object_source = FND_API.G_MISS_NUM
1482: THEN
1483: x_eam_wo_rec.maintenance_object_source := p_old_eam_wo_rec.maintenance_object_source;
1484: END IF;
1485:

Line 1495: IF p_eam_wo_rec.attribute_category = FND_API.G_MISS_CHAR

1491: x_eam_wo_rec.attribute_category := p_old_eam_wo_rec.attribute_category;
1492:
1493: END IF;
1494:
1495: IF p_eam_wo_rec.attribute_category = FND_API.G_MISS_CHAR
1496: THEN
1497: x_eam_wo_rec.attribute_category := NULL;
1498: END IF;
1499:

Line 1505: IF p_eam_wo_rec.attribute1 = FND_API.G_MISS_CHAR

1501: THEN
1502: x_eam_wo_rec.attribute1 := p_old_eam_wo_rec.attribute1;
1503: END IF;
1504:
1505: IF p_eam_wo_rec.attribute1 = FND_API.G_MISS_CHAR
1506: THEN
1507: x_eam_wo_rec.attribute1 := NULL;
1508: END IF;
1509:

Line 1515: IF p_eam_wo_rec.attribute2 = FND_API.G_MISS_CHAR

1511: THEN
1512: x_eam_wo_rec.attribute2 := p_old_eam_wo_rec.attribute2;
1513: END IF;
1514:
1515: IF p_eam_wo_rec.attribute2 = FND_API.G_MISS_CHAR
1516: THEN
1517: x_eam_wo_rec.attribute2 := NULL;
1518: END IF;
1519:

Line 1525: IF p_eam_wo_rec.attribute3 = FND_API.G_MISS_CHAR

1521: THEN
1522: x_eam_wo_rec.attribute3 := p_old_eam_wo_rec.attribute3;
1523: END IF;
1524:
1525: IF p_eam_wo_rec.attribute3 = FND_API.G_MISS_CHAR
1526: THEN
1527: x_eam_wo_rec.attribute3 := NULL;
1528: END IF;
1529:

Line 1535: IF p_eam_wo_rec.attribute4 = FND_API.G_MISS_CHAR

1531: THEN
1532: x_eam_wo_rec.attribute4 := p_old_eam_wo_rec.attribute4;
1533: END IF;
1534:
1535: IF p_eam_wo_rec.attribute4 = FND_API.G_MISS_CHAR
1536: THEN
1537: x_eam_wo_rec.attribute4 := NULL;
1538: END IF;
1539:

Line 1545: IF p_eam_wo_rec.attribute5 = FND_API.G_MISS_CHAR

1541: THEN
1542: x_eam_wo_rec.attribute5 := p_old_eam_wo_rec.attribute5;
1543: END IF;
1544:
1545: IF p_eam_wo_rec.attribute5 = FND_API.G_MISS_CHAR
1546: THEN
1547: x_eam_wo_rec.attribute5 := NULL;
1548: END IF;
1549:

Line 1555: IF p_eam_wo_rec.attribute6 = FND_API.G_MISS_CHAR

1551: THEN
1552: x_eam_wo_rec.attribute6 := p_old_eam_wo_rec.attribute6;
1553: END IF;
1554:
1555: IF p_eam_wo_rec.attribute6 = FND_API.G_MISS_CHAR
1556: THEN
1557: x_eam_wo_rec.attribute6 := NULL;
1558: END IF;
1559:

Line 1565: IF p_eam_wo_rec.attribute7 = FND_API.G_MISS_CHAR

1561: THEN
1562: x_eam_wo_rec.attribute7 := p_old_eam_wo_rec.attribute7;
1563: END IF;
1564:
1565: IF p_eam_wo_rec.attribute7 = FND_API.G_MISS_CHAR
1566: THEN
1567: x_eam_wo_rec.attribute7 := NULL;
1568: END IF;
1569:

Line 1575: IF p_eam_wo_rec.attribute8 = FND_API.G_MISS_CHAR

1571: THEN
1572: x_eam_wo_rec.attribute8 := p_old_eam_wo_rec.attribute8;
1573: END IF;
1574:
1575: IF p_eam_wo_rec.attribute8 = FND_API.G_MISS_CHAR
1576: THEN
1577: x_eam_wo_rec.attribute8 := NULL;
1578: END IF;
1579:

Line 1585: IF p_eam_wo_rec.attribute9 = FND_API.G_MISS_CHAR

1581: THEN
1582: x_eam_wo_rec.attribute9 := p_old_eam_wo_rec.attribute9;
1583: END IF;
1584:
1585: IF p_eam_wo_rec.attribute9 = FND_API.G_MISS_CHAR
1586: THEN
1587: x_eam_wo_rec.attribute9 := NULL;
1588: END IF;
1589:

Line 1595: IF p_eam_wo_rec.attribute10 = FND_API.G_MISS_CHAR

1591: THEN
1592: x_eam_wo_rec.attribute10 := p_old_eam_wo_rec.attribute10;
1593: END IF;
1594:
1595: IF p_eam_wo_rec.attribute10 = FND_API.G_MISS_CHAR
1596: THEN
1597: x_eam_wo_rec.attribute10 := NULL;
1598: END IF;
1599:

Line 1605: IF p_eam_wo_rec.attribute11 = FND_API.G_MISS_CHAR

1601: THEN
1602: x_eam_wo_rec.attribute11 := p_old_eam_wo_rec.attribute11;
1603: END IF;
1604:
1605: IF p_eam_wo_rec.attribute11 = FND_API.G_MISS_CHAR
1606: THEN
1607: x_eam_wo_rec.attribute11 := NULL;
1608: END IF;
1609:

Line 1615: IF p_eam_wo_rec.attribute12 = FND_API.G_MISS_CHAR

1611: THEN
1612: x_eam_wo_rec.attribute12 := p_old_eam_wo_rec.attribute12;
1613: END IF;
1614:
1615: IF p_eam_wo_rec.attribute12 = FND_API.G_MISS_CHAR
1616: THEN
1617: x_eam_wo_rec.attribute12 := NULL;
1618: END IF;
1619:

Line 1625: IF p_eam_wo_rec.attribute13 = FND_API.G_MISS_CHAR

1621: THEN
1622: x_eam_wo_rec.attribute13 := p_old_eam_wo_rec.attribute13;
1623: END IF;
1624:
1625: IF p_eam_wo_rec.attribute13 = FND_API.G_MISS_CHAR
1626: THEN
1627: x_eam_wo_rec.attribute13 := NULL;
1628: END IF;
1629:

Line 1635: IF p_eam_wo_rec.attribute14 = FND_API.G_MISS_CHAR

1631: THEN
1632: x_eam_wo_rec.attribute14 := p_old_eam_wo_rec.attribute14;
1633: END IF;
1634:
1635: IF p_eam_wo_rec.attribute14 = FND_API.G_MISS_CHAR
1636: THEN
1637: x_eam_wo_rec.attribute14 := NULL;
1638: END IF;
1639:

Line 1645: IF p_eam_wo_rec.attribute15 = FND_API.G_MISS_CHAR

1641: THEN
1642: x_eam_wo_rec.attribute15 := p_old_eam_wo_rec.attribute15;
1643: END IF;
1644:
1645: IF p_eam_wo_rec.attribute15 = FND_API.G_MISS_CHAR
1646: THEN
1647: x_eam_wo_rec.attribute15 := NULL;
1648: END IF;
1649:

Line 1651: IF p_eam_wo_rec.material_issue_by_mo = FND_API.G_MISS_CHAR OR

1647: x_eam_wo_rec.attribute15 := NULL;
1648: END IF;
1649:
1650: -- MATERIAL_ISSUE_BY_MO flag
1651: IF p_eam_wo_rec.material_issue_by_mo = FND_API.G_MISS_CHAR OR
1652: p_eam_wo_rec.material_issue_by_mo IS NULL
1653: THEN
1654: x_eam_wo_rec.material_issue_by_mo := p_old_eam_wo_rec.material_issue_by_mo;
1655: END IF;

Line 1657: IF p_eam_wo_rec.pending_flag = FND_API.G_MISS_CHAR OR

1653: THEN
1654: x_eam_wo_rec.material_issue_by_mo := p_old_eam_wo_rec.material_issue_by_mo;
1655: END IF;
1656:
1657: IF p_eam_wo_rec.pending_flag = FND_API.G_MISS_CHAR OR
1658: p_eam_wo_rec.pending_flag IS NULL
1659: THEN
1660: x_eam_wo_rec.pending_flag := p_old_eam_wo_rec.pending_flag;
1661: END IF;

Line 1663: IF p_eam_wo_rec.material_shortage_check_date = FND_API.G_MISS_DATE OR

1659: THEN
1660: x_eam_wo_rec.pending_flag := p_old_eam_wo_rec.pending_flag;
1661: END IF;
1662:
1663: IF p_eam_wo_rec.material_shortage_check_date = FND_API.G_MISS_DATE OR
1664: p_eam_wo_rec.material_shortage_check_date IS NULL
1665: THEN
1666: x_eam_wo_rec.material_shortage_check_date := p_old_eam_wo_rec.material_shortage_check_date;
1667: END IF;

Line 1669: IF p_eam_wo_rec.material_shortage_flag = FND_API.G_MISS_NUM OR

1665: THEN
1666: x_eam_wo_rec.material_shortage_check_date := p_old_eam_wo_rec.material_shortage_check_date;
1667: END IF;
1668:
1669: IF p_eam_wo_rec.material_shortage_flag = FND_API.G_MISS_NUM OR
1670: p_eam_wo_rec.material_shortage_flag IS NULL
1671: THEN
1672: x_eam_wo_rec.material_shortage_flag := p_old_eam_wo_rec.material_shortage_flag;
1673: END IF;

Line 1675: IF p_eam_wo_rec.workflow_type = FND_API.G_MISS_NUM OR

1671: THEN
1672: x_eam_wo_rec.material_shortage_flag := p_old_eam_wo_rec.material_shortage_flag;
1673: END IF;
1674:
1675: IF p_eam_wo_rec.workflow_type = FND_API.G_MISS_NUM OR
1676: p_eam_wo_rec.workflow_type IS NULL
1677: THEN
1678: x_eam_wo_rec.workflow_type := p_old_eam_wo_rec.workflow_type;
1679: END IF;

Line 1681: IF p_eam_wo_rec.warranty_claim_status = FND_API.G_MISS_NUM OR

1677: THEN
1678: x_eam_wo_rec.workflow_type := p_old_eam_wo_rec.workflow_type;
1679: END IF;
1680:
1681: IF p_eam_wo_rec.warranty_claim_status = FND_API.G_MISS_NUM OR
1682: p_eam_wo_rec.warranty_claim_status IS NULL
1683: THEN
1684: x_eam_wo_rec.warranty_claim_status := p_old_eam_wo_rec.warranty_claim_status;
1685: END IF;

Line 1687: IF p_eam_wo_rec.cycle_id = FND_API.G_MISS_NUM OR

1683: THEN
1684: x_eam_wo_rec.warranty_claim_status := p_old_eam_wo_rec.warranty_claim_status;
1685: END IF;
1686:
1687: IF p_eam_wo_rec.cycle_id = FND_API.G_MISS_NUM OR
1688: p_eam_wo_rec.cycle_id IS NULL
1689: THEN
1690: x_eam_wo_rec.cycle_id := p_old_eam_wo_rec.cycle_id;
1691: END IF;

Line 1693: IF p_eam_wo_rec.seq_id = FND_API.G_MISS_NUM OR

1689: THEN
1690: x_eam_wo_rec.cycle_id := p_old_eam_wo_rec.cycle_id;
1691: END IF;
1692:
1693: IF p_eam_wo_rec.seq_id = FND_API.G_MISS_NUM OR
1694: p_eam_wo_rec.seq_id IS NULL
1695: THEN
1696: x_eam_wo_rec.seq_id := p_old_eam_wo_rec.seq_id;
1697: END IF;

Line 1699: IF p_eam_wo_rec.ds_scheduled_flag = FND_API.G_MISS_CHAR OR

1695: THEN
1696: x_eam_wo_rec.seq_id := p_old_eam_wo_rec.seq_id;
1697: END IF;
1698:
1699: IF p_eam_wo_rec.ds_scheduled_flag = FND_API.G_MISS_CHAR OR
1700: p_eam_wo_rec.ds_scheduled_flag IS NULL
1701: THEN
1702: x_eam_wo_rec.ds_scheduled_flag := p_old_eam_wo_rec.ds_scheduled_flag;
1703: END IF;

Line 1705: IF p_eam_wo_rec.assignment_complete = FND_API.G_MISS_CHAR OR

1701: THEN
1702: x_eam_wo_rec.ds_scheduled_flag := p_old_eam_wo_rec.ds_scheduled_flag;
1703: END IF;
1704:
1705: IF p_eam_wo_rec.assignment_complete = FND_API.G_MISS_CHAR OR
1706: p_eam_wo_rec.assignment_complete IS NULL
1707: THEN
1708: x_eam_wo_rec.assignment_complete := p_old_eam_wo_rec.assignment_complete;
1709: END IF;

Line 1711: IF p_eam_wo_rec.warranty_active = FND_API.G_MISS_NUM OR

1707: THEN
1708: x_eam_wo_rec.assignment_complete := p_old_eam_wo_rec.assignment_complete;
1709: END IF;
1710:
1711: IF p_eam_wo_rec.warranty_active = FND_API.G_MISS_NUM OR
1712: p_eam_wo_rec.warranty_active IS NULL
1713: THEN
1714: x_eam_wo_rec.warranty_active := p_old_eam_wo_rec.warranty_active;
1715: END IF;

Line 1724: IF p_eam_wo_rec.failure_code_required = FND_API.G_MISS_CHAR

1720: THEN
1721: x_eam_wo_rec.failure_code_required := p_old_eam_wo_rec.failure_code_required;
1722: END IF;
1723:
1724: IF p_eam_wo_rec.failure_code_required = FND_API.G_MISS_CHAR
1725: THEN
1726: x_eam_wo_rec.failure_code_required := 'N'; -- As NULL Is same as 'N'
1727: END IF;
1728: