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_CREATEUPDATE_WO_PVT dependencies on FND_API

Line 55: , p_commit => FND_API.G_FALSE

51: EAM_PROCESS_WO_PUB.COPY_WORKORDER
52: ( p_bo_identifier =>'EAM'
53: , p_api_version_number =>1.0
54: , p_init_msg_list => p_init_msg_list
55: , p_commit => FND_API.G_FALSE
56: , p_wip_entity_id =>p_wip_entity_id
57: , p_organization_id => p_organization_id
58: , x_eam_wo_rec => l_eam_wo_rec
59: , x_eam_op_tbl => l_eam_op_tbl

Line 78: IF(p_commit = FND_API.G_TRUE) THEN

74:
75: IF(x_return_status = 'S' ) THEN
76: x_wip_entity_name := l_eam_wo_rec.wip_entity_name;
77: x_wip_entity_id := l_eam_wo_rec.wip_entity_id;
78: IF(p_commit = FND_API.G_TRUE) THEN
79: COMMIT;
80: END IF;
81: END IF;
82:

Line 95: p_commit IN VARCHAR2 := FND_API.G_FALSE,

91: Wrapper procedure on top of WO API.This is used to create/update workorder and its related entities
92: ************************************************/
93: PROCEDURE CREATE_UPDATE_WO
94: (
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
97: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
98: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
99: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

Line 386: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

382:
383: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
384:
385: IF (l_eam_failure_entry_record.failure_date IS NULL) THEN
386: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
387: END IF;
388:
389: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
390: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

Line 390: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

386: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
387: END IF;
388:
389: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
390: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
391: END IF;
392:
393: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
394: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

Line 394: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

390: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
391: END IF;
392:
393: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
394: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
395: END IF;
396:
397: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
398: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

Line 398: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

394: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
395: END IF;
396:
397: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
398: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
399: END IF;
400:
401: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
402: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

Line 402: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

398: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
399: END IF;
400:
401: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
402: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
403: END IF;
404:
405: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
406: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

Line 408: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN

404:
405: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
406: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
407: ELSE
408: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
409: l_eam_failure_entry_record.transaction_type :=null;
410: l_eam_failure_entry_record.failure_date :=null;
411: ELSE
412: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 421: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

417: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
418: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
419:
420: ELSE
421: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
422: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
423: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
424: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
425: )

Line 422: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

418: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
419:
420: ELSE
421: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
422: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
423: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
424: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
425: )
426: ) THEN

Line 423: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

419:
420: ELSE
421: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
422: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
423: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
424: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
425: )
426: ) THEN
427: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 424: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

420: ELSE
421: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
422: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
423: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
424: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
425: )
426: ) THEN
427: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
428:

Line 429: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN

425: )
426: ) THEN
427: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
428:
429: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
430: l_eam_failure_codes_tbl(1).failure_code := null;
431: END IF;
432:
433: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

Line 433: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

429: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
430: l_eam_failure_codes_tbl(1).failure_code := null;
431: END IF;
432:
433: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
434: l_eam_failure_codes_tbl(1).cause_code := NULL;
435: END IF;
436:
437: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

Line 437: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

433: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
434: l_eam_failure_codes_tbl(1).cause_code := NULL;
435: END IF;
436:
437: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
438: l_eam_failure_codes_tbl(1).resolution_code := null;
439: END IF;
440:
441: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

Line 441: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

437: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
438: l_eam_failure_codes_tbl(1).resolution_code := null;
439: END IF;
440:
441: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
442: l_eam_failure_codes_tbl(1).comments := null;
443: END IF;
444: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
445:

Line 460: --Set the activity_id to Fnd_Api.G_Miss_Num if we want to delete the activity

456: END IF;
457:
458: /* Failure Analysis Project End */
459:
460: --Set the activity_id to Fnd_Api.G_Miss_Num if we want to delete the activity
461: l_eam_wo_tbl := p_eam_wo_tbl;
462: IF(l_eam_wo_tbl IS NOT NULL AND l_eam_wo_tbl.COUNT>0) THEN
463:
464: l_eam_wo_rec := l_eam_wo_tbl(l_eam_wo_tbl.FIRST);

Line 466: --set FND_API.G_MISS_xx if any columns are nulled out

462: IF(l_eam_wo_tbl IS NOT NULL AND l_eam_wo_tbl.COUNT>0) THEN
463:
464: l_eam_wo_rec := l_eam_wo_tbl(l_eam_wo_tbl.FIRST);
465:
466: --set FND_API.G_MISS_xx if any columns are nulled out
467: l_wo_exists := TRUE; --work order already exists...if no data found exception is thrown then l_wo_exists will be set to FALSE
468:
469: BEGIN
470: l_wip_entity_id :=l_eam_wo_rec.wip_entity_id;

Line 540: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;

536: FROM WIP_DISCRETE_JOBS
537: where wip_entity_id = l_wip_entity_id;
538:
539: IF(l_asset_number is NOT NULL and l_eam_wo_rec.asset_number IS NULL) THEN
540: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;
541: END IF;
542:
543: IF(l_rebuild_serial_number is NOT NULL and l_eam_wo_rec.rebuild_serial_number IS NULL) THEN
544: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;

Line 544: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;

540: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;
541: END IF;
542:
543: IF(l_rebuild_serial_number is NOT NULL and l_eam_wo_rec.rebuild_serial_number IS NULL) THEN
544: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;
545: END IF;
546:
547: IF(l_asset_group_id is NOT NULL and l_eam_wo_rec.asset_group_id IS NULL) THEN
548: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;

Line 548: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;

544: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;
545: END IF;
546:
547: IF(l_asset_group_id is NOT NULL and l_eam_wo_rec.asset_group_id IS NULL) THEN
548: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;
549: END IF;
550:
551: IF(l_rebuild_item_id is NOT NULL and l_eam_wo_rec.rebuild_item_id IS NULL) THEN
552: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;

Line 552: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;

548: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;
549: END IF;
550:
551: IF(l_rebuild_item_id is NOT NULL and l_eam_wo_rec.rebuild_item_id IS NULL) THEN
552: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;
553: END IF;
554:
555: IF l_prev_activity_id is not null and l_eam_wo_rec.asset_activity_id is null THEN
556: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

Line 556: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

552: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;
553: END IF;
554:
555: IF l_prev_activity_id is not null and l_eam_wo_rec.asset_activity_id is null THEN
556: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
557: END IF;
558:
559: IF l_prev_description is not null and l_eam_wo_rec.description is null THEN
560: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;

Line 560: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;

556: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
557: END IF;
558:
559: IF l_prev_description is not null and l_eam_wo_rec.description is null THEN
560: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;
561: END IF;
562:
563: IF l_prev_activity_type is not null and l_eam_wo_rec.activity_type is null THEN
564: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;

Line 564: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;

560: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;
561: END IF;
562:
563: IF l_prev_activity_type is not null and l_eam_wo_rec.activity_type is null THEN
564: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;
565: END IF;
566:
567: IF l_prev_activity_cause is not null and l_eam_wo_rec.activity_cause is null THEN
568: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;

Line 568: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;

564: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;
565: END IF;
566:
567: IF l_prev_activity_cause is not null and l_eam_wo_rec.activity_cause is null THEN
568: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;
569: END IF;
570:
571: IF l_prev_activity_source is not null and l_eam_wo_rec.activity_source is null THEN
572: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;

Line 572: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;

568: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;
569: END IF;
570:
571: IF l_prev_activity_source is not null and l_eam_wo_rec.activity_source is null THEN
572: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;
573: END IF;
574:
575: IF l_prev_shutdown_type is not null and l_eam_wo_rec.shutdown_type is null THEN
576: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;

Line 576: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;

572: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;
573: END IF;
574:
575: IF l_prev_shutdown_type is not null and l_eam_wo_rec.shutdown_type is null THEN
576: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;
577: END IF;
578:
579: IF l_prev_priority is not null and l_eam_wo_rec.priority is null THEN
580: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;

Line 580: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;

576: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;
577: END IF;
578:
579: IF l_prev_priority is not null and l_eam_wo_rec.priority is null THEN
580: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;
581: END IF;
582:
583: IF l_prev_work_order_type is not null and l_eam_wo_rec.work_order_type is null THEN
584: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;

Line 584: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;

580: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;
581: END IF;
582:
583: IF l_prev_work_order_type is not null and l_eam_wo_rec.work_order_type is null THEN
584: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;
585: END IF;
586:
587: IF l_prev_attribute_category is not null and l_eam_wo_rec.attribute_category is null THEN
588: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;

Line 588: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;

584: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;
585: END IF;
586:
587: IF l_prev_attribute_category is not null and l_eam_wo_rec.attribute_category is null THEN
588: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;
589: END IF;
590:
591: IF l_prev_attribute1 is not null and l_eam_wo_rec.attribute1 is null THEN
592: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 592: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;

588: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;
589: END IF;
590:
591: IF l_prev_attribute1 is not null and l_eam_wo_rec.attribute1 is null THEN
592: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;
593: END IF;
594:
595: IF l_prev_attribute2 is not null and l_eam_wo_rec.attribute2 is null THEN
596: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 596: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;

592: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;
593: END IF;
594:
595: IF l_prev_attribute2 is not null and l_eam_wo_rec.attribute2 is null THEN
596: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;
597: END IF;
598:
599: IF l_prev_attribute3 is not null and l_eam_wo_rec.attribute3 is null THEN
600: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 600: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;

596: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;
597: END IF;
598:
599: IF l_prev_attribute3 is not null and l_eam_wo_rec.attribute3 is null THEN
600: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;
601: END IF;
602:
603: IF l_prev_attribute4 is not null and l_eam_wo_rec.attribute4 is null THEN
604: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 604: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;

600: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;
601: END IF;
602:
603: IF l_prev_attribute4 is not null and l_eam_wo_rec.attribute4 is null THEN
604: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;
605: END IF;
606:
607: IF l_prev_attribute5 is not null and l_eam_wo_rec.attribute5 is null THEN
608: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 608: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;

604: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;
605: END IF;
606:
607: IF l_prev_attribute5 is not null and l_eam_wo_rec.attribute5 is null THEN
608: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;
609: END IF;
610:
611: IF l_prev_attribute6 is not null and l_eam_wo_rec.attribute6 is null THEN
612: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 612: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;

608: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;
609: END IF;
610:
611: IF l_prev_attribute6 is not null and l_eam_wo_rec.attribute6 is null THEN
612: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;
613: END IF;
614:
615: IF l_prev_attribute7 is not null and l_eam_wo_rec.attribute7 is null THEN
616: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 616: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;

612: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;
613: END IF;
614:
615: IF l_prev_attribute7 is not null and l_eam_wo_rec.attribute7 is null THEN
616: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;
617: END IF;
618:
619: IF l_prev_attribute8 is not null and l_eam_wo_rec.attribute8 is null THEN
620: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 620: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;

616: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;
617: END IF;
618:
619: IF l_prev_attribute8 is not null and l_eam_wo_rec.attribute8 is null THEN
620: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;
621: END IF;
622:
623: IF l_prev_attribute9 is not null and l_eam_wo_rec.attribute9 is null THEN
624: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 624: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;

620: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;
621: END IF;
622:
623: IF l_prev_attribute9 is not null and l_eam_wo_rec.attribute9 is null THEN
624: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;
625: END IF;
626:
627: IF l_prev_attribute10 is not null and l_eam_wo_rec.attribute10 is null THEN
628: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 628: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;

624: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;
625: END IF;
626:
627: IF l_prev_attribute10 is not null and l_eam_wo_rec.attribute10 is null THEN
628: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;
629: END IF;
630:
631: IF l_prev_attribute11 is not null and l_eam_wo_rec.attribute11 is null THEN
632: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 632: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;

628: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;
629: END IF;
630:
631: IF l_prev_attribute11 is not null and l_eam_wo_rec.attribute11 is null THEN
632: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;
633: END IF;
634:
635: IF l_prev_attribute12 is not null and l_eam_wo_rec.attribute12 is null THEN
636: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 636: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;

632: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;
633: END IF;
634:
635: IF l_prev_attribute12 is not null and l_eam_wo_rec.attribute12 is null THEN
636: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;
637: END IF;
638:
639: IF l_prev_attribute13 is not null and l_eam_wo_rec.attribute13 is null THEN
640: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 640: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;

636: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;
637: END IF;
638:
639: IF l_prev_attribute13 is not null and l_eam_wo_rec.attribute13 is null THEN
640: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;
641: END IF;
642:
643: IF l_prev_attribute14 is not null and l_eam_wo_rec.attribute14 is null THEN
644: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 644: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;

640: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;
641: END IF;
642:
643: IF l_prev_attribute14 is not null and l_eam_wo_rec.attribute14 is null THEN
644: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;
645: END IF;
646:
647: IF l_prev_attribute15 is not null and l_eam_wo_rec.attribute15 is null THEN
648: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 648: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;

644: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;
645: END IF;
646:
647: IF l_prev_attribute15 is not null and l_eam_wo_rec.attribute15 is null THEN
648: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;
649: END IF;
650:
651: /* Added for bug#6053425 Start */
652:

Line 654: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;

650:
651: /* Added for bug#6053425 Start */
652:
653: IF l_prev_project_id is not null AND l_eam_wo_rec.project_id is null THEN
654: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;
655: END IF;
656:
657: IF l_prev_task_id is not null AND l_eam_wo_rec.task_id is null THEN
658: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;

Line 658: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;

654: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;
655: END IF;
656:
657: IF l_prev_task_id is not null AND l_eam_wo_rec.task_id is null THEN
658: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;
659: END IF;
660:
661: /* Added for bug#6053425 End */
662:

Line 775: l_eam_op_rec.description := FND_API.G_MISS_CHAR;

771: AND wo.operation_seq_num = l_eam_op_rec.operation_seq_num;
772:
773:
774: IF l_prev_op_description is not null and l_eam_op_rec.description is null THEN
775: l_eam_op_rec.description := FND_API.G_MISS_CHAR;
776: END IF;
777:
778: IF l_prev_op_shutdown_type is not null and l_eam_op_rec.shutdown_type is null THEN
779: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;

Line 779: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;

775: l_eam_op_rec.description := FND_API.G_MISS_CHAR;
776: END IF;
777:
778: IF l_prev_op_shutdown_type is not null and l_eam_op_rec.shutdown_type is null THEN
779: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;
780: END IF;
781:
782: IF l_prev_op_long_description is not null and l_eam_op_rec.long_description is null THEN
783: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;

Line 783: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;

779: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;
780: END IF;
781:
782: IF l_prev_op_long_description is not null and l_eam_op_rec.long_description is null THEN
783: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;
784: END IF;
785:
786: IF l_prev_op_attribute_category is not null and l_eam_op_rec.attribute_category is null THEN
787: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;

Line 787: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;

783: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;
784: END IF;
785:
786: IF l_prev_op_attribute_category is not null and l_eam_op_rec.attribute_category is null THEN
787: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;
788: END IF;
789:
790: IF l_prev_op_attribute1 is not null and l_eam_op_rec.attribute1 is null THEN
791: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 791: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;

787: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;
788: END IF;
789:
790: IF l_prev_op_attribute1 is not null and l_eam_op_rec.attribute1 is null THEN
791: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;
792: END IF;
793:
794: IF l_prev_op_attribute2 is not null and l_eam_op_rec.attribute2 is null THEN
795: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 795: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;

791: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;
792: END IF;
793:
794: IF l_prev_op_attribute2 is not null and l_eam_op_rec.attribute2 is null THEN
795: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;
796: END IF;
797:
798: IF l_prev_op_attribute3 is not null and l_eam_op_rec.attribute3 is null THEN
799: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 799: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;

795: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;
796: END IF;
797:
798: IF l_prev_op_attribute3 is not null and l_eam_op_rec.attribute3 is null THEN
799: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;
800: END IF;
801:
802: IF l_prev_op_attribute4 is not null and l_eam_op_rec.attribute4 is null THEN
803: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 803: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;

799: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;
800: END IF;
801:
802: IF l_prev_op_attribute4 is not null and l_eam_op_rec.attribute4 is null THEN
803: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;
804: END IF;
805:
806: IF l_prev_op_attribute5 is not null and l_eam_op_rec.attribute5 is null THEN
807: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 807: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;

803: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;
804: END IF;
805:
806: IF l_prev_op_attribute5 is not null and l_eam_op_rec.attribute5 is null THEN
807: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;
808: END IF;
809:
810: IF l_prev_op_attribute6 is not null and l_eam_op_rec.attribute6 is null THEN
811: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 811: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;

807: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;
808: END IF;
809:
810: IF l_prev_op_attribute6 is not null and l_eam_op_rec.attribute6 is null THEN
811: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;
812: END IF;
813:
814: IF l_prev_op_attribute7 is not null and l_eam_op_rec.attribute7 is null THEN
815: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 815: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;

811: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;
812: END IF;
813:
814: IF l_prev_op_attribute7 is not null and l_eam_op_rec.attribute7 is null THEN
815: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;
816: END IF;
817:
818: IF l_prev_op_attribute8 is not null and l_eam_op_rec.attribute8 is null THEN
819: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 819: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;

815: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;
816: END IF;
817:
818: IF l_prev_op_attribute8 is not null and l_eam_op_rec.attribute8 is null THEN
819: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;
820: END IF;
821:
822: IF l_prev_op_attribute9 is not null and l_eam_op_rec.attribute9 is null THEN
823: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 823: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;

819: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;
820: END IF;
821:
822: IF l_prev_op_attribute9 is not null and l_eam_op_rec.attribute9 is null THEN
823: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;
824: END IF;
825:
826: IF l_prev_op_attribute10 is not null and l_eam_op_rec.attribute10 is null THEN
827: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 827: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;

823: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;
824: END IF;
825:
826: IF l_prev_op_attribute10 is not null and l_eam_op_rec.attribute10 is null THEN
827: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;
828: END IF;
829:
830: IF l_prev_op_attribute11 is not null and l_eam_op_rec.attribute11 is null THEN
831: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 831: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;

827: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;
828: END IF;
829:
830: IF l_prev_op_attribute11 is not null and l_eam_op_rec.attribute11 is null THEN
831: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;
832: END IF;
833:
834: IF l_prev_op_attribute12 is not null and l_eam_op_rec.attribute12 is null THEN
835: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 835: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;

831: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;
832: END IF;
833:
834: IF l_prev_op_attribute12 is not null and l_eam_op_rec.attribute12 is null THEN
835: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;
836: END IF;
837:
838: IF l_prev_op_attribute13 is not null and l_eam_op_rec.attribute13 is null THEN
839: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 839: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;

835: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;
836: END IF;
837:
838: IF l_prev_op_attribute13 is not null and l_eam_op_rec.attribute13 is null THEN
839: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;
840: END IF;
841:
842: IF l_prev_op_attribute14 is not null and l_eam_op_rec.attribute14 is null THEN
843: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 843: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;

839: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;
840: END IF;
841:
842: IF l_prev_op_attribute14 is not null and l_eam_op_rec.attribute14 is null THEN
843: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;
844: END IF;
845:
846: IF l_prev_op_attribute15 is not null and l_eam_op_rec.attribute15 is null THEN
847: l_eam_op_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 847: l_eam_op_rec.attribute15 := FND_API.G_MISS_CHAR;

843: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;
844: END IF;
845:
846: IF l_prev_op_attribute15 is not null and l_eam_op_rec.attribute15 is null THEN
847: l_eam_op_rec.attribute15 := FND_API.G_MISS_CHAR;
848: END IF;
849:
850:
851: EXCEPTION

Line 963: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;

959: null;
960: END;
961:
962: IF l_prev_mat_attribute_category is not null and l_eam_mat_req_rec.attribute_category is null THEN
963: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;
964: END IF;
965:
966: IF l_prev_mat_attribute1 is not null and l_eam_mat_req_rec.attribute1 is null THEN
967: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 967: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;

963: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;
964: END IF;
965:
966: IF l_prev_mat_attribute1 is not null and l_eam_mat_req_rec.attribute1 is null THEN
967: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;
968: END IF;
969:
970: IF l_prev_mat_attribute2 is not null and l_eam_mat_req_rec.attribute2 is null THEN
971: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 971: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;

967: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;
968: END IF;
969:
970: IF l_prev_mat_attribute2 is not null and l_eam_mat_req_rec.attribute2 is null THEN
971: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;
972: END IF;
973:
974: IF l_prev_mat_attribute3 is not null and l_eam_mat_req_rec.attribute3 is null THEN
975: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 975: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;

971: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;
972: END IF;
973:
974: IF l_prev_mat_attribute3 is not null and l_eam_mat_req_rec.attribute3 is null THEN
975: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;
976: END IF;
977:
978: IF l_prev_mat_attribute4 is not null and l_eam_mat_req_rec.attribute4 is null THEN
979: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 979: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;

975: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;
976: END IF;
977:
978: IF l_prev_mat_attribute4 is not null and l_eam_mat_req_rec.attribute4 is null THEN
979: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;
980: END IF;
981:
982: IF l_prev_mat_attribute5 is not null and l_eam_mat_req_rec.attribute5 is null THEN
983: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 983: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;

979: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;
980: END IF;
981:
982: IF l_prev_mat_attribute5 is not null and l_eam_mat_req_rec.attribute5 is null THEN
983: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;
984: END IF;
985:
986: IF l_prev_mat_attribute6 is not null and l_eam_mat_req_rec.attribute6 is null THEN
987: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 987: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;

983: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;
984: END IF;
985:
986: IF l_prev_mat_attribute6 is not null and l_eam_mat_req_rec.attribute6 is null THEN
987: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;
988: END IF;
989:
990: IF l_prev_mat_attribute7 is not null and l_eam_mat_req_rec.attribute7 is null THEN
991: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 991: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;

987: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;
988: END IF;
989:
990: IF l_prev_mat_attribute7 is not null and l_eam_mat_req_rec.attribute7 is null THEN
991: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;
992: END IF;
993:
994: IF l_prev_mat_attribute8 is not null and l_eam_mat_req_rec.attribute8 is null THEN
995: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 995: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;

991: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;
992: END IF;
993:
994: IF l_prev_mat_attribute8 is not null and l_eam_mat_req_rec.attribute8 is null THEN
995: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;
996: END IF;
997:
998: IF l_prev_mat_attribute9 is not null and l_eam_mat_req_rec.attribute9 is null THEN
999: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 999: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;

995: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;
996: END IF;
997:
998: IF l_prev_mat_attribute9 is not null and l_eam_mat_req_rec.attribute9 is null THEN
999: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;
1000: END IF;
1001:
1002: IF l_prev_mat_attribute10 is not null and l_eam_mat_req_rec.attribute10 is null THEN
1003: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 1003: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;

999: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;
1000: END IF;
1001:
1002: IF l_prev_mat_attribute10 is not null and l_eam_mat_req_rec.attribute10 is null THEN
1003: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;
1004: END IF;
1005:
1006: IF l_prev_mat_attribute11 is not null and l_eam_mat_req_rec.attribute11 is null THEN
1007: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 1007: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;

1003: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;
1004: END IF;
1005:
1006: IF l_prev_mat_attribute11 is not null and l_eam_mat_req_rec.attribute11 is null THEN
1007: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;
1008: END IF;
1009:
1010: IF l_prev_mat_attribute12 is not null and l_eam_mat_req_rec.attribute12 is null THEN
1011: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 1011: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;

1007: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;
1008: END IF;
1009:
1010: IF l_prev_mat_attribute12 is not null and l_eam_mat_req_rec.attribute12 is null THEN
1011: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;
1012: END IF;
1013:
1014: IF l_prev_mat_attribute13 is not null and l_eam_mat_req_rec.attribute13 is null THEN
1015: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 1015: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;

1011: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;
1012: END IF;
1013:
1014: IF l_prev_mat_attribute13 is not null and l_eam_mat_req_rec.attribute13 is null THEN
1015: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;
1016: END IF;
1017:
1018: IF l_prev_mat_attribute14 is not null and l_eam_mat_req_rec.attribute14 is null THEN
1019: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 1019: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;

1015: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;
1016: END IF;
1017:
1018: IF l_prev_mat_attribute14 is not null and l_eam_mat_req_rec.attribute14 is null THEN
1019: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;
1020: END IF;
1021:
1022: IF l_prev_mat_attribute15 is not null and l_eam_mat_req_rec.attribute15 is null THEN
1023: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 1023: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;

1019: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;
1020: END IF;
1021:
1022: IF l_prev_mat_attribute15 is not null and l_eam_mat_req_rec.attribute15 is null THEN
1023: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;
1024: END IF;
1025:
1026: --Validate descriptive flexfield for materials - "Component Information"
1027: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field(

Line 1110: l_eam_direct_items_rec.attribute_category := FND_API.G_MISS_CHAR;

1106: null;
1107: END;
1108:
1109: IF l_prev_dir_attribute_category is not null and l_eam_direct_items_rec.attribute_category is null THEN
1110: l_eam_direct_items_rec.attribute_category := FND_API.G_MISS_CHAR;
1111: END IF;
1112:
1113: IF l_prev_dir_attribute1 is not null and l_eam_direct_items_rec.attribute1 is null THEN
1114: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 1114: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;

1110: l_eam_direct_items_rec.attribute_category := FND_API.G_MISS_CHAR;
1111: END IF;
1112:
1113: IF l_prev_dir_attribute1 is not null and l_eam_direct_items_rec.attribute1 is null THEN
1114: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;
1115: END IF;
1116:
1117: IF l_prev_dir_attribute2 is not null and l_eam_direct_items_rec.attribute2 is null THEN
1118: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 1118: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;

1114: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;
1115: END IF;
1116:
1117: IF l_prev_dir_attribute2 is not null and l_eam_direct_items_rec.attribute2 is null THEN
1118: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;
1119: END IF;
1120:
1121: IF l_prev_dir_attribute3 is not null and l_eam_direct_items_rec.attribute3 is null THEN
1122: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 1122: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;

1118: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;
1119: END IF;
1120:
1121: IF l_prev_dir_attribute3 is not null and l_eam_direct_items_rec.attribute3 is null THEN
1122: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;
1123: END IF;
1124:
1125: IF l_prev_dir_attribute4 is not null and l_eam_direct_items_rec.attribute4 is null THEN
1126: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 1126: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;

1122: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;
1123: END IF;
1124:
1125: IF l_prev_dir_attribute4 is not null and l_eam_direct_items_rec.attribute4 is null THEN
1126: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;
1127: END IF;
1128:
1129: IF l_prev_dir_attribute5 is not null and l_eam_direct_items_rec.attribute5 is null THEN
1130: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 1130: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;

1126: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;
1127: END IF;
1128:
1129: IF l_prev_dir_attribute5 is not null and l_eam_direct_items_rec.attribute5 is null THEN
1130: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;
1131: END IF;
1132:
1133: IF l_prev_dir_attribute6 is not null and l_eam_direct_items_rec.attribute6 is null THEN
1134: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 1134: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;

1130: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;
1131: END IF;
1132:
1133: IF l_prev_dir_attribute6 is not null and l_eam_direct_items_rec.attribute6 is null THEN
1134: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;
1135: END IF;
1136:
1137: IF l_prev_dir_attribute7 is not null and l_eam_direct_items_rec.attribute7 is null THEN
1138: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 1138: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;

1134: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;
1135: END IF;
1136:
1137: IF l_prev_dir_attribute7 is not null and l_eam_direct_items_rec.attribute7 is null THEN
1138: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;
1139: END IF;
1140:
1141: IF l_prev_dir_attribute8 is not null and l_eam_direct_items_rec.attribute8 is null THEN
1142: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 1142: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;

1138: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;
1139: END IF;
1140:
1141: IF l_prev_dir_attribute8 is not null and l_eam_direct_items_rec.attribute8 is null THEN
1142: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;
1143: END IF;
1144:
1145: IF l_prev_dir_attribute9 is not null and l_eam_direct_items_rec.attribute9 is null THEN
1146: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 1146: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;

1142: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;
1143: END IF;
1144:
1145: IF l_prev_dir_attribute9 is not null and l_eam_direct_items_rec.attribute9 is null THEN
1146: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;
1147: END IF;
1148:
1149: IF l_prev_dir_attribute10 is not null and l_eam_direct_items_rec.attribute10 is null THEN
1150: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 1150: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;

1146: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;
1147: END IF;
1148:
1149: IF l_prev_dir_attribute10 is not null and l_eam_direct_items_rec.attribute10 is null THEN
1150: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;
1151: END IF;
1152:
1153: IF l_prev_dir_attribute11 is not null and l_eam_direct_items_rec.attribute11 is null THEN
1154: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 1154: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;

1150: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;
1151: END IF;
1152:
1153: IF l_prev_dir_attribute11 is not null and l_eam_direct_items_rec.attribute11 is null THEN
1154: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;
1155: END IF;
1156:
1157: IF l_prev_dir_attribute12 is not null and l_eam_direct_items_rec.attribute12 is null THEN
1158: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 1158: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;

1154: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;
1155: END IF;
1156:
1157: IF l_prev_dir_attribute12 is not null and l_eam_direct_items_rec.attribute12 is null THEN
1158: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;
1159: END IF;
1160:
1161: IF l_prev_dir_attribute13 is not null and l_eam_direct_items_rec.attribute13 is null THEN
1162: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 1162: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;

1158: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;
1159: END IF;
1160:
1161: IF l_prev_dir_attribute13 is not null and l_eam_direct_items_rec.attribute13 is null THEN
1162: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;
1163: END IF;
1164:
1165: IF l_prev_dir_attribute14 is not null and l_eam_direct_items_rec.attribute14 is null THEN
1166: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 1166: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;

1162: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;
1163: END IF;
1164:
1165: IF l_prev_dir_attribute14 is not null and l_eam_direct_items_rec.attribute14 is null THEN
1166: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;
1167: END IF;
1168:
1169: IF l_prev_dir_attribute15 is not null and l_eam_direct_items_rec.attribute15 is null THEN
1170: l_eam_direct_items_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 1170: l_eam_direct_items_rec.attribute15 := FND_API.G_MISS_CHAR;

1166: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;
1167: END IF;
1168:
1169: IF l_prev_dir_attribute15 is not null and l_eam_direct_items_rec.attribute15 is null THEN
1170: l_eam_direct_items_rec.attribute15 := FND_API.G_MISS_CHAR;
1171: END IF;
1172:
1173: --Validate descriptive flexfield for workorder
1174: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field(

Line 1286: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

1282:
1283:
1284: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1285: if (l_eam_failure_entry_record.failure_date is null) then
1286: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
1287: end if;
1288: if (l_eam_failure_codes_tbl(1).failure_code is null) then
1289: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
1290: end if;

Line 1289: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

1285: if (l_eam_failure_entry_record.failure_date is null) then
1286: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
1287: end if;
1288: if (l_eam_failure_codes_tbl(1).failure_code is null) then
1289: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
1290: end if;
1291: if (l_eam_failure_codes_tbl(1).cause_code is null) then
1292: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
1293: end if;

Line 1292: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

1288: if (l_eam_failure_codes_tbl(1).failure_code is null) then
1289: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
1290: end if;
1291: if (l_eam_failure_codes_tbl(1).cause_code is null) then
1292: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
1293: end if;
1294: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
1295: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
1296: end if;

Line 1295: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

1291: if (l_eam_failure_codes_tbl(1).cause_code is null) then
1292: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
1293: end if;
1294: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
1295: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
1296: end if;
1297: if (l_eam_failure_codes_tbl(1).comments is null) then
1298: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
1299: end if;

Line 1298: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

1294: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
1295: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
1296: end if;
1297: if (l_eam_failure_codes_tbl(1).comments is null) then
1298: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
1299: end if;
1300: if(l_eam_failure_entry_record.failure_id is not null ) then
1301: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1302: else

Line 1303: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then

1299: end if;
1300: if(l_eam_failure_entry_record.failure_id is not null ) then
1301: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1302: else
1303: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then
1304: l_eam_failure_entry_record.transaction_type :=null;
1305: l_eam_failure_entry_record.failure_date :=null;
1306: else
1307: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 1316: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

1312: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1313: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1314:
1315: else
1316: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1317: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1318: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1319: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1320: )

Line 1317: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

1313: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1314:
1315: else
1316: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1317: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1318: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1319: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1320: )
1321: ) then

Line 1318: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

1314:
1315: else
1316: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1317: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1318: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1319: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1320: )
1321: ) then
1322: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 1319: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

1315: else
1316: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1317: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1318: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1319: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1320: )
1321: ) then
1322: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1323: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then

Line 1323: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then

1319: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1320: )
1321: ) then
1322: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1323: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
1324: l_eam_failure_codes_tbl(1).failure_code := null;
1325: end if;
1326: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
1327: l_eam_failure_codes_tbl(1).cause_code := null;

Line 1326: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then

1322: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1323: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
1324: l_eam_failure_codes_tbl(1).failure_code := null;
1325: end if;
1326: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
1327: l_eam_failure_codes_tbl(1).cause_code := null;
1328: end if;
1329: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
1330: l_eam_failure_codes_tbl(1).resolution_code := null;

Line 1329: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

1325: end if;
1326: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
1327: l_eam_failure_codes_tbl(1).cause_code := null;
1328: end if;
1329: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
1330: l_eam_failure_codes_tbl(1).resolution_code := null;
1331: end if;
1332: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
1333: l_eam_failure_codes_tbl(1).comments := null;

Line 1332: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

1328: end if;
1329: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
1330: l_eam_failure_codes_tbl(1).resolution_code := null;
1331: end if;
1332: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
1333: l_eam_failure_codes_tbl(1).comments := null;
1334: end if;
1335: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1336:

Line 1499: IF p_commit = FND_API.G_TRUE THEN

1495:
1496: END IF; /*MSP IF END*/
1497:
1498: IF(x_return_status='S') THEN
1499: IF p_commit = FND_API.G_TRUE THEN
1500: COMMIT WORK;
1501: end if;
1502: IF(l_eam_wo_tbl_out IS NOT NULL AND l_eam_wo_tbl_out.COUNT>0) THEN
1503: x_wip_entity_id := l_eam_wo_tbl_out(l_eam_wo_tbl_out.FIRST).wip_entity_id;

Line 1521: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1517: Wrapper procedure on top of WO API.This is used to create/update workorder with permits(old 12.1.3 code to be compatible with 12.2)
1518: ************************************************/
1519: PROCEDURE CREATE_UPDATE_WO
1520: (
1521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1522: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1523: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1524: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1525: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

Line 1720: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1716: method too large error for this particular procedure.
1717: ************************************************/
1718: PROCEDURE CREATE_UPDATE_WO
1719: (
1720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1721: p_eam_wo_tbl IN EAM_PROCESS_WO_PUB.eam_wo_tbl_type,
1722: p_eam_wo_relations_tbl IN EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type,
1723: p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type,
1724: p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type,

Line 2016: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

2012:
2013: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2014:
2015: IF (l_eam_failure_entry_record.failure_date IS NULL) THEN
2016: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
2017: END IF;
2018:
2019: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
2020: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

Line 2020: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

2016: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
2017: END IF;
2018:
2019: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
2020: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
2021: END IF;
2022:
2023: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
2024: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

Line 2024: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

2020: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
2021: END IF;
2022:
2023: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
2024: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
2025: END IF;
2026:
2027: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
2028: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

Line 2028: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

2024: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
2025: END IF;
2026:
2027: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
2028: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
2029: END IF;
2030:
2031: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
2032: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

Line 2032: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

2028: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
2029: END IF;
2030:
2031: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
2032: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
2033: END IF;
2034:
2035: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
2036: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

Line 2038: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN

2034:
2035: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
2036: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2037: ELSE
2038: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
2039: l_eam_failure_entry_record.transaction_type :=null;
2040: l_eam_failure_entry_record.failure_date :=null;
2041: ELSE
2042: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 2051: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

2047: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2048: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
2049:
2050: ELSE
2051: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2052: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2053: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2054: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2055: )

Line 2052: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

2048: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
2049:
2050: ELSE
2051: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2052: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2053: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2054: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2055: )
2056: ) THEN

Line 2053: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

2049:
2050: ELSE
2051: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2052: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2053: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2054: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2055: )
2056: ) THEN
2057: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 2054: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

2050: ELSE
2051: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2052: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2053: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2054: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2055: )
2056: ) THEN
2057: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2058:

Line 2059: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN

2055: )
2056: ) THEN
2057: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2058:
2059: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
2060: l_eam_failure_codes_tbl(1).failure_code := null;
2061: END IF;
2062:
2063: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

Line 2063: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

2059: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
2060: l_eam_failure_codes_tbl(1).failure_code := null;
2061: END IF;
2062:
2063: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
2064: l_eam_failure_codes_tbl(1).cause_code := NULL;
2065: END IF;
2066:
2067: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

Line 2067: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

2063: IF(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
2064: l_eam_failure_codes_tbl(1).cause_code := NULL;
2065: END IF;
2066:
2067: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
2068: l_eam_failure_codes_tbl(1).resolution_code := null;
2069: END IF;
2070:
2071: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

Line 2071: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

2067: IF(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
2068: l_eam_failure_codes_tbl(1).resolution_code := null;
2069: END IF;
2070:
2071: IF(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
2072: l_eam_failure_codes_tbl(1).comments := null;
2073: END IF;
2074: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
2075:

Line 2090: --Set the activity_id to Fnd_Api.G_Miss_Num if we want to delete the activity

2086: END IF;
2087:
2088: /* Failure Analysis Project End */
2089:
2090: --Set the activity_id to Fnd_Api.G_Miss_Num if we want to delete the activity
2091: l_eam_wo_tbl := p_eam_wo_tbl;
2092: IF(l_eam_wo_tbl IS NOT NULL AND l_eam_wo_tbl.COUNT>0) THEN
2093:
2094: l_eam_wo_rec := l_eam_wo_tbl(l_eam_wo_tbl.FIRST);

Line 2096: --set FND_API.G_MISS_xx if any columns are nulled out

2092: IF(l_eam_wo_tbl IS NOT NULL AND l_eam_wo_tbl.COUNT>0) THEN
2093:
2094: l_eam_wo_rec := l_eam_wo_tbl(l_eam_wo_tbl.FIRST);
2095:
2096: --set FND_API.G_MISS_xx if any columns are nulled out
2097: l_wo_exists := TRUE; --work order already exists...if no data found exception is thrown then l_wo_exists will be set to FALSE
2098:
2099: BEGIN
2100: l_wip_entity_id :=l_eam_wo_rec.wip_entity_id;

Line 2170: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;

2166: FROM WIP_DISCRETE_JOBS
2167: where wip_entity_id = l_wip_entity_id;
2168:
2169: IF(l_asset_number is NOT NULL and l_eam_wo_rec.asset_number IS NULL) THEN
2170: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;
2171: END IF;
2172:
2173: IF(l_rebuild_serial_number is NOT NULL and l_eam_wo_rec.rebuild_serial_number IS NULL) THEN
2174: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;

Line 2174: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;

2170: l_eam_wo_rec.asset_number := FND_API.G_MISS_CHAR;
2171: END IF;
2172:
2173: IF(l_rebuild_serial_number is NOT NULL and l_eam_wo_rec.rebuild_serial_number IS NULL) THEN
2174: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;
2175: END IF;
2176:
2177: IF(l_asset_group_id is NOT NULL and l_eam_wo_rec.asset_group_id IS NULL) THEN
2178: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;

Line 2178: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;

2174: l_eam_wo_rec.rebuild_serial_number := FND_API.G_MISS_CHAR;
2175: END IF;
2176:
2177: IF(l_asset_group_id is NOT NULL and l_eam_wo_rec.asset_group_id IS NULL) THEN
2178: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;
2179: END IF;
2180:
2181: IF(l_rebuild_item_id is NOT NULL and l_eam_wo_rec.rebuild_item_id IS NULL) THEN
2182: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;

Line 2182: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;

2178: l_eam_wo_rec.asset_group_id := FND_API.G_MISS_NUM;
2179: END IF;
2180:
2181: IF(l_rebuild_item_id is NOT NULL and l_eam_wo_rec.rebuild_item_id IS NULL) THEN
2182: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;
2183: END IF;
2184:
2185: IF l_prev_activity_id is not null and l_eam_wo_rec.asset_activity_id is null THEN
2186: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

Line 2186: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

2182: l_eam_wo_rec.rebuild_item_id:= FND_API.G_MISS_NUM;
2183: END IF;
2184:
2185: IF l_prev_activity_id is not null and l_eam_wo_rec.asset_activity_id is null THEN
2186: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
2187: END IF;
2188:
2189: IF l_prev_description is not null and l_eam_wo_rec.description is null THEN
2190: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;

Line 2190: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;

2186: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
2187: END IF;
2188:
2189: IF l_prev_description is not null and l_eam_wo_rec.description is null THEN
2190: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;
2191: END IF;
2192:
2193: IF l_prev_activity_type is not null and l_eam_wo_rec.activity_type is null THEN
2194: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;

Line 2194: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;

2190: l_eam_wo_rec.description := FND_API.G_MISS_CHAR;
2191: END IF;
2192:
2193: IF l_prev_activity_type is not null and l_eam_wo_rec.activity_type is null THEN
2194: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;
2195: END IF;
2196:
2197: IF l_prev_activity_cause is not null and l_eam_wo_rec.activity_cause is null THEN
2198: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;

Line 2198: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;

2194: l_eam_wo_rec.activity_type := FND_API.G_MISS_CHAR;
2195: END IF;
2196:
2197: IF l_prev_activity_cause is not null and l_eam_wo_rec.activity_cause is null THEN
2198: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;
2199: END IF;
2200:
2201: IF l_prev_activity_source is not null and l_eam_wo_rec.activity_source is null THEN
2202: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;

Line 2202: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;

2198: l_eam_wo_rec.activity_cause := FND_API.G_MISS_CHAR;
2199: END IF;
2200:
2201: IF l_prev_activity_source is not null and l_eam_wo_rec.activity_source is null THEN
2202: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;
2203: END IF;
2204:
2205: IF l_prev_shutdown_type is not null and l_eam_wo_rec.shutdown_type is null THEN
2206: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;

Line 2206: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;

2202: l_eam_wo_rec.activity_source := FND_API.G_MISS_CHAR;
2203: END IF;
2204:
2205: IF l_prev_shutdown_type is not null and l_eam_wo_rec.shutdown_type is null THEN
2206: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;
2207: END IF;
2208:
2209: IF l_prev_priority is not null and l_eam_wo_rec.priority is null THEN
2210: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;

Line 2210: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;

2206: l_eam_wo_rec.shutdown_type := FND_API.G_MISS_CHAR;
2207: END IF;
2208:
2209: IF l_prev_priority is not null and l_eam_wo_rec.priority is null THEN
2210: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;
2211: END IF;
2212:
2213: IF l_prev_work_order_type is not null and l_eam_wo_rec.work_order_type is null THEN
2214: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;

Line 2214: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;

2210: l_eam_wo_rec.priority := FND_API.G_MISS_NUM;
2211: END IF;
2212:
2213: IF l_prev_work_order_type is not null and l_eam_wo_rec.work_order_type is null THEN
2214: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;
2215: END IF;
2216:
2217: IF l_prev_attribute_category is not null and l_eam_wo_rec.attribute_category is null THEN
2218: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;

Line 2218: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;

2214: l_eam_wo_rec.work_order_type := FND_API.G_MISS_CHAR;
2215: END IF;
2216:
2217: IF l_prev_attribute_category is not null and l_eam_wo_rec.attribute_category is null THEN
2218: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;
2219: END IF;
2220:
2221: IF l_prev_attribute1 is not null and l_eam_wo_rec.attribute1 is null THEN
2222: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 2222: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;

2218: l_eam_wo_rec.attribute_category := FND_API.G_MISS_CHAR;
2219: END IF;
2220:
2221: IF l_prev_attribute1 is not null and l_eam_wo_rec.attribute1 is null THEN
2222: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;
2223: END IF;
2224:
2225: IF l_prev_attribute2 is not null and l_eam_wo_rec.attribute2 is null THEN
2226: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 2226: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;

2222: l_eam_wo_rec.attribute1 := FND_API.G_MISS_CHAR;
2223: END IF;
2224:
2225: IF l_prev_attribute2 is not null and l_eam_wo_rec.attribute2 is null THEN
2226: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;
2227: END IF;
2228:
2229: IF l_prev_attribute3 is not null and l_eam_wo_rec.attribute3 is null THEN
2230: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 2230: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;

2226: l_eam_wo_rec.attribute2 := FND_API.G_MISS_CHAR;
2227: END IF;
2228:
2229: IF l_prev_attribute3 is not null and l_eam_wo_rec.attribute3 is null THEN
2230: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;
2231: END IF;
2232:
2233: IF l_prev_attribute4 is not null and l_eam_wo_rec.attribute4 is null THEN
2234: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 2234: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;

2230: l_eam_wo_rec.attribute3 := FND_API.G_MISS_CHAR;
2231: END IF;
2232:
2233: IF l_prev_attribute4 is not null and l_eam_wo_rec.attribute4 is null THEN
2234: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;
2235: END IF;
2236:
2237: IF l_prev_attribute5 is not null and l_eam_wo_rec.attribute5 is null THEN
2238: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 2238: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;

2234: l_eam_wo_rec.attribute4 := FND_API.G_MISS_CHAR;
2235: END IF;
2236:
2237: IF l_prev_attribute5 is not null and l_eam_wo_rec.attribute5 is null THEN
2238: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;
2239: END IF;
2240:
2241: IF l_prev_attribute6 is not null and l_eam_wo_rec.attribute6 is null THEN
2242: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 2242: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;

2238: l_eam_wo_rec.attribute5 := FND_API.G_MISS_CHAR;
2239: END IF;
2240:
2241: IF l_prev_attribute6 is not null and l_eam_wo_rec.attribute6 is null THEN
2242: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;
2243: END IF;
2244:
2245: IF l_prev_attribute7 is not null and l_eam_wo_rec.attribute7 is null THEN
2246: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 2246: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;

2242: l_eam_wo_rec.attribute6 := FND_API.G_MISS_CHAR;
2243: END IF;
2244:
2245: IF l_prev_attribute7 is not null and l_eam_wo_rec.attribute7 is null THEN
2246: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;
2247: END IF;
2248:
2249: IF l_prev_attribute8 is not null and l_eam_wo_rec.attribute8 is null THEN
2250: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 2250: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;

2246: l_eam_wo_rec.attribute7 := FND_API.G_MISS_CHAR;
2247: END IF;
2248:
2249: IF l_prev_attribute8 is not null and l_eam_wo_rec.attribute8 is null THEN
2250: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;
2251: END IF;
2252:
2253: IF l_prev_attribute9 is not null and l_eam_wo_rec.attribute9 is null THEN
2254: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 2254: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;

2250: l_eam_wo_rec.attribute8 := FND_API.G_MISS_CHAR;
2251: END IF;
2252:
2253: IF l_prev_attribute9 is not null and l_eam_wo_rec.attribute9 is null THEN
2254: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;
2255: END IF;
2256:
2257: IF l_prev_attribute10 is not null and l_eam_wo_rec.attribute10 is null THEN
2258: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 2258: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;

2254: l_eam_wo_rec.attribute9 := FND_API.G_MISS_CHAR;
2255: END IF;
2256:
2257: IF l_prev_attribute10 is not null and l_eam_wo_rec.attribute10 is null THEN
2258: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;
2259: END IF;
2260:
2261: IF l_prev_attribute11 is not null and l_eam_wo_rec.attribute11 is null THEN
2262: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 2262: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;

2258: l_eam_wo_rec.attribute10 := FND_API.G_MISS_CHAR;
2259: END IF;
2260:
2261: IF l_prev_attribute11 is not null and l_eam_wo_rec.attribute11 is null THEN
2262: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;
2263: END IF;
2264:
2265: IF l_prev_attribute12 is not null and l_eam_wo_rec.attribute12 is null THEN
2266: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 2266: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;

2262: l_eam_wo_rec.attribute11 := FND_API.G_MISS_CHAR;
2263: END IF;
2264:
2265: IF l_prev_attribute12 is not null and l_eam_wo_rec.attribute12 is null THEN
2266: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;
2267: END IF;
2268:
2269: IF l_prev_attribute13 is not null and l_eam_wo_rec.attribute13 is null THEN
2270: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 2270: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;

2266: l_eam_wo_rec.attribute12 := FND_API.G_MISS_CHAR;
2267: END IF;
2268:
2269: IF l_prev_attribute13 is not null and l_eam_wo_rec.attribute13 is null THEN
2270: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;
2271: END IF;
2272:
2273: IF l_prev_attribute14 is not null and l_eam_wo_rec.attribute14 is null THEN
2274: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 2274: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;

2270: l_eam_wo_rec.attribute13 := FND_API.G_MISS_CHAR;
2271: END IF;
2272:
2273: IF l_prev_attribute14 is not null and l_eam_wo_rec.attribute14 is null THEN
2274: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;
2275: END IF;
2276:
2277: IF l_prev_attribute15 is not null and l_eam_wo_rec.attribute15 is null THEN
2278: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 2278: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;

2274: l_eam_wo_rec.attribute14 := FND_API.G_MISS_CHAR;
2275: END IF;
2276:
2277: IF l_prev_attribute15 is not null and l_eam_wo_rec.attribute15 is null THEN
2278: l_eam_wo_rec.attribute15 := FND_API.G_MISS_CHAR;
2279: END IF;
2280:
2281: /* Added for bug#6053425 Start */
2282:

Line 2284: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;

2280:
2281: /* Added for bug#6053425 Start */
2282:
2283: IF l_prev_project_id is not null AND l_eam_wo_rec.project_id is null THEN
2284: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;
2285: END IF;
2286:
2287: IF l_prev_task_id is not null AND l_eam_wo_rec.task_id is null THEN
2288: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;

Line 2288: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;

2284: l_eam_wo_rec.project_id := FND_API.G_MISS_NUM;
2285: END IF;
2286:
2287: IF l_prev_task_id is not null AND l_eam_wo_rec.task_id is null THEN
2288: l_eam_wo_rec.task_id := FND_API.G_MISS_NUM;
2289: END IF;
2290:
2291: /* Added for bug#6053425 End */
2292:

Line 2406: l_eam_op_rec.description := FND_API.G_MISS_CHAR;

2402: AND wo.operation_seq_num = l_eam_op_rec.operation_seq_num;
2403:
2404:
2405: IF l_prev_op_description is not null and l_eam_op_rec.description is null THEN
2406: l_eam_op_rec.description := FND_API.G_MISS_CHAR;
2407: END IF;
2408:
2409: IF l_prev_op_shutdown_type is not null and l_eam_op_rec.shutdown_type is null THEN
2410: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;

Line 2410: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;

2406: l_eam_op_rec.description := FND_API.G_MISS_CHAR;
2407: END IF;
2408:
2409: IF l_prev_op_shutdown_type is not null and l_eam_op_rec.shutdown_type is null THEN
2410: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;
2411: END IF;
2412:
2413: IF l_prev_op_long_description is not null and l_eam_op_rec.long_description is null THEN
2414: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;

Line 2414: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;

2410: l_eam_op_rec.shutdown_type := FND_API.G_MISS_CHAR;
2411: END IF;
2412:
2413: IF l_prev_op_long_description is not null and l_eam_op_rec.long_description is null THEN
2414: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;
2415: END IF;
2416:
2417: IF l_prev_op_attribute_category is not null and l_eam_op_rec.attribute_category is null THEN
2418: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;

Line 2418: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;

2414: l_eam_op_rec.long_description := FND_API.G_MISS_CHAR;
2415: END IF;
2416:
2417: IF l_prev_op_attribute_category is not null and l_eam_op_rec.attribute_category is null THEN
2418: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;
2419: END IF;
2420:
2421: IF l_prev_op_attribute1 is not null and l_eam_op_rec.attribute1 is null THEN
2422: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 2422: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;

2418: l_eam_op_rec.attribute_category := FND_API.G_MISS_CHAR;
2419: END IF;
2420:
2421: IF l_prev_op_attribute1 is not null and l_eam_op_rec.attribute1 is null THEN
2422: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;
2423: END IF;
2424:
2425: IF l_prev_op_attribute2 is not null and l_eam_op_rec.attribute2 is null THEN
2426: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 2426: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;

2422: l_eam_op_rec.attribute1 := FND_API.G_MISS_CHAR;
2423: END IF;
2424:
2425: IF l_prev_op_attribute2 is not null and l_eam_op_rec.attribute2 is null THEN
2426: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;
2427: END IF;
2428:
2429: IF l_prev_op_attribute3 is not null and l_eam_op_rec.attribute3 is null THEN
2430: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 2430: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;

2426: l_eam_op_rec.attribute2 := FND_API.G_MISS_CHAR;
2427: END IF;
2428:
2429: IF l_prev_op_attribute3 is not null and l_eam_op_rec.attribute3 is null THEN
2430: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;
2431: END IF;
2432:
2433: IF l_prev_op_attribute4 is not null and l_eam_op_rec.attribute4 is null THEN
2434: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 2434: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;

2430: l_eam_op_rec.attribute3 := FND_API.G_MISS_CHAR;
2431: END IF;
2432:
2433: IF l_prev_op_attribute4 is not null and l_eam_op_rec.attribute4 is null THEN
2434: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;
2435: END IF;
2436:
2437: IF l_prev_op_attribute5 is not null and l_eam_op_rec.attribute5 is null THEN
2438: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 2438: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;

2434: l_eam_op_rec.attribute4 := FND_API.G_MISS_CHAR;
2435: END IF;
2436:
2437: IF l_prev_op_attribute5 is not null and l_eam_op_rec.attribute5 is null THEN
2438: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;
2439: END IF;
2440:
2441: IF l_prev_op_attribute6 is not null and l_eam_op_rec.attribute6 is null THEN
2442: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 2442: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;

2438: l_eam_op_rec.attribute5 := FND_API.G_MISS_CHAR;
2439: END IF;
2440:
2441: IF l_prev_op_attribute6 is not null and l_eam_op_rec.attribute6 is null THEN
2442: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;
2443: END IF;
2444:
2445: IF l_prev_op_attribute7 is not null and l_eam_op_rec.attribute7 is null THEN
2446: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 2446: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;

2442: l_eam_op_rec.attribute6 := FND_API.G_MISS_CHAR;
2443: END IF;
2444:
2445: IF l_prev_op_attribute7 is not null and l_eam_op_rec.attribute7 is null THEN
2446: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;
2447: END IF;
2448:
2449: IF l_prev_op_attribute8 is not null and l_eam_op_rec.attribute8 is null THEN
2450: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 2450: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;

2446: l_eam_op_rec.attribute7 := FND_API.G_MISS_CHAR;
2447: END IF;
2448:
2449: IF l_prev_op_attribute8 is not null and l_eam_op_rec.attribute8 is null THEN
2450: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;
2451: END IF;
2452:
2453: IF l_prev_op_attribute9 is not null and l_eam_op_rec.attribute9 is null THEN
2454: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 2454: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;

2450: l_eam_op_rec.attribute8 := FND_API.G_MISS_CHAR;
2451: END IF;
2452:
2453: IF l_prev_op_attribute9 is not null and l_eam_op_rec.attribute9 is null THEN
2454: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;
2455: END IF;
2456:
2457: IF l_prev_op_attribute10 is not null and l_eam_op_rec.attribute10 is null THEN
2458: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 2458: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;

2454: l_eam_op_rec.attribute9 := FND_API.G_MISS_CHAR;
2455: END IF;
2456:
2457: IF l_prev_op_attribute10 is not null and l_eam_op_rec.attribute10 is null THEN
2458: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;
2459: END IF;
2460:
2461: IF l_prev_op_attribute11 is not null and l_eam_op_rec.attribute11 is null THEN
2462: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 2462: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;

2458: l_eam_op_rec.attribute10 := FND_API.G_MISS_CHAR;
2459: END IF;
2460:
2461: IF l_prev_op_attribute11 is not null and l_eam_op_rec.attribute11 is null THEN
2462: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;
2463: END IF;
2464:
2465: IF l_prev_op_attribute12 is not null and l_eam_op_rec.attribute12 is null THEN
2466: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 2466: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;

2462: l_eam_op_rec.attribute11 := FND_API.G_MISS_CHAR;
2463: END IF;
2464:
2465: IF l_prev_op_attribute12 is not null and l_eam_op_rec.attribute12 is null THEN
2466: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;
2467: END IF;
2468:
2469: IF l_prev_op_attribute13 is not null and l_eam_op_rec.attribute13 is null THEN
2470: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 2470: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;

2466: l_eam_op_rec.attribute12 := FND_API.G_MISS_CHAR;
2467: END IF;
2468:
2469: IF l_prev_op_attribute13 is not null and l_eam_op_rec.attribute13 is null THEN
2470: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;
2471: END IF;
2472:
2473: IF l_prev_op_attribute14 is not null and l_eam_op_rec.attribute14 is null THEN
2474: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 2474: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;

2470: l_eam_op_rec.attribute13 := FND_API.G_MISS_CHAR;
2471: END IF;
2472:
2473: IF l_prev_op_attribute14 is not null and l_eam_op_rec.attribute14 is null THEN
2474: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;
2475: END IF;
2476:
2477: IF l_prev_op_attribute15 is not null and l_eam_op_rec.attribute15 is null THEN
2478: l_eam_op_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 2478: l_eam_op_rec.attribute15 := FND_API.G_MISS_CHAR;

2474: l_eam_op_rec.attribute14 := FND_API.G_MISS_CHAR;
2475: END IF;
2476:
2477: IF l_prev_op_attribute15 is not null and l_eam_op_rec.attribute15 is null THEN
2478: l_eam_op_rec.attribute15 := FND_API.G_MISS_CHAR;
2479: END IF;
2480:
2481:
2482: EXCEPTION

Line 2595: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;

2591: null;
2592: END;
2593:
2594: IF l_prev_mat_attribute_category is not null and l_eam_mat_req_rec.attribute_category is null THEN
2595: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;
2596: END IF;
2597:
2598: IF l_prev_mat_attribute1 is not null and l_eam_mat_req_rec.attribute1 is null THEN
2599: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 2599: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;

2595: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;
2596: END IF;
2597:
2598: IF l_prev_mat_attribute1 is not null and l_eam_mat_req_rec.attribute1 is null THEN
2599: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;
2600: END IF;
2601:
2602: IF l_prev_mat_attribute2 is not null and l_eam_mat_req_rec.attribute2 is null THEN
2603: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 2603: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;

2599: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;
2600: END IF;
2601:
2602: IF l_prev_mat_attribute2 is not null and l_eam_mat_req_rec.attribute2 is null THEN
2603: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;
2604: END IF;
2605:
2606: IF l_prev_mat_attribute3 is not null and l_eam_mat_req_rec.attribute3 is null THEN
2607: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 2607: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;

2603: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;
2604: END IF;
2605:
2606: IF l_prev_mat_attribute3 is not null and l_eam_mat_req_rec.attribute3 is null THEN
2607: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;
2608: END IF;
2609:
2610: IF l_prev_mat_attribute4 is not null and l_eam_mat_req_rec.attribute4 is null THEN
2611: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 2611: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;

2607: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;
2608: END IF;
2609:
2610: IF l_prev_mat_attribute4 is not null and l_eam_mat_req_rec.attribute4 is null THEN
2611: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;
2612: END IF;
2613:
2614: IF l_prev_mat_attribute5 is not null and l_eam_mat_req_rec.attribute5 is null THEN
2615: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 2615: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;

2611: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;
2612: END IF;
2613:
2614: IF l_prev_mat_attribute5 is not null and l_eam_mat_req_rec.attribute5 is null THEN
2615: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;
2616: END IF;
2617:
2618: IF l_prev_mat_attribute6 is not null and l_eam_mat_req_rec.attribute6 is null THEN
2619: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 2619: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;

2615: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;
2616: END IF;
2617:
2618: IF l_prev_mat_attribute6 is not null and l_eam_mat_req_rec.attribute6 is null THEN
2619: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;
2620: END IF;
2621:
2622: IF l_prev_mat_attribute7 is not null and l_eam_mat_req_rec.attribute7 is null THEN
2623: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 2623: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;

2619: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;
2620: END IF;
2621:
2622: IF l_prev_mat_attribute7 is not null and l_eam_mat_req_rec.attribute7 is null THEN
2623: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;
2624: END IF;
2625:
2626: IF l_prev_mat_attribute8 is not null and l_eam_mat_req_rec.attribute8 is null THEN
2627: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 2627: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;

2623: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;
2624: END IF;
2625:
2626: IF l_prev_mat_attribute8 is not null and l_eam_mat_req_rec.attribute8 is null THEN
2627: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;
2628: END IF;
2629:
2630: IF l_prev_mat_attribute9 is not null and l_eam_mat_req_rec.attribute9 is null THEN
2631: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 2631: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;

2627: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;
2628: END IF;
2629:
2630: IF l_prev_mat_attribute9 is not null and l_eam_mat_req_rec.attribute9 is null THEN
2631: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;
2632: END IF;
2633:
2634: IF l_prev_mat_attribute10 is not null and l_eam_mat_req_rec.attribute10 is null THEN
2635: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 2635: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;

2631: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;
2632: END IF;
2633:
2634: IF l_prev_mat_attribute10 is not null and l_eam_mat_req_rec.attribute10 is null THEN
2635: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;
2636: END IF;
2637:
2638: IF l_prev_mat_attribute11 is not null and l_eam_mat_req_rec.attribute11 is null THEN
2639: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 2639: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;

2635: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;
2636: END IF;
2637:
2638: IF l_prev_mat_attribute11 is not null and l_eam_mat_req_rec.attribute11 is null THEN
2639: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;
2640: END IF;
2641:
2642: IF l_prev_mat_attribute12 is not null and l_eam_mat_req_rec.attribute12 is null THEN
2643: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 2643: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;

2639: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;
2640: END IF;
2641:
2642: IF l_prev_mat_attribute12 is not null and l_eam_mat_req_rec.attribute12 is null THEN
2643: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;
2644: END IF;
2645:
2646: IF l_prev_mat_attribute13 is not null and l_eam_mat_req_rec.attribute13 is null THEN
2647: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 2647: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;

2643: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;
2644: END IF;
2645:
2646: IF l_prev_mat_attribute13 is not null and l_eam_mat_req_rec.attribute13 is null THEN
2647: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;
2648: END IF;
2649:
2650: IF l_prev_mat_attribute14 is not null and l_eam_mat_req_rec.attribute14 is null THEN
2651: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 2651: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;

2647: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;
2648: END IF;
2649:
2650: IF l_prev_mat_attribute14 is not null and l_eam_mat_req_rec.attribute14 is null THEN
2651: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;
2652: END IF;
2653:
2654: IF l_prev_mat_attribute15 is not null and l_eam_mat_req_rec.attribute15 is null THEN
2655: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 2655: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;

2651: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;
2652: END IF;
2653:
2654: IF l_prev_mat_attribute15 is not null and l_eam_mat_req_rec.attribute15 is null THEN
2655: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;
2656: END IF;
2657:
2658: --Validate descriptive flexfield for materials - "Component Information"
2659: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field(

Line 2742: l_eam_direct_items_rec.attribute_category := FND_API.G_MISS_CHAR;

2738: null;
2739: END;
2740:
2741: IF l_prev_dir_attribute_category is not null and l_eam_direct_items_rec.attribute_category is null THEN
2742: l_eam_direct_items_rec.attribute_category := FND_API.G_MISS_CHAR;
2743: END IF;
2744:
2745: IF l_prev_dir_attribute1 is not null and l_eam_direct_items_rec.attribute1 is null THEN
2746: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 2746: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;

2742: l_eam_direct_items_rec.attribute_category := FND_API.G_MISS_CHAR;
2743: END IF;
2744:
2745: IF l_prev_dir_attribute1 is not null and l_eam_direct_items_rec.attribute1 is null THEN
2746: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;
2747: END IF;
2748:
2749: IF l_prev_dir_attribute2 is not null and l_eam_direct_items_rec.attribute2 is null THEN
2750: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 2750: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;

2746: l_eam_direct_items_rec.attribute1 := FND_API.G_MISS_CHAR;
2747: END IF;
2748:
2749: IF l_prev_dir_attribute2 is not null and l_eam_direct_items_rec.attribute2 is null THEN
2750: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;
2751: END IF;
2752:
2753: IF l_prev_dir_attribute3 is not null and l_eam_direct_items_rec.attribute3 is null THEN
2754: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 2754: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;

2750: l_eam_direct_items_rec.attribute2 := FND_API.G_MISS_CHAR;
2751: END IF;
2752:
2753: IF l_prev_dir_attribute3 is not null and l_eam_direct_items_rec.attribute3 is null THEN
2754: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;
2755: END IF;
2756:
2757: IF l_prev_dir_attribute4 is not null and l_eam_direct_items_rec.attribute4 is null THEN
2758: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 2758: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;

2754: l_eam_direct_items_rec.attribute3 := FND_API.G_MISS_CHAR;
2755: END IF;
2756:
2757: IF l_prev_dir_attribute4 is not null and l_eam_direct_items_rec.attribute4 is null THEN
2758: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;
2759: END IF;
2760:
2761: IF l_prev_dir_attribute5 is not null and l_eam_direct_items_rec.attribute5 is null THEN
2762: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 2762: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;

2758: l_eam_direct_items_rec.attribute4 := FND_API.G_MISS_CHAR;
2759: END IF;
2760:
2761: IF l_prev_dir_attribute5 is not null and l_eam_direct_items_rec.attribute5 is null THEN
2762: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;
2763: END IF;
2764:
2765: IF l_prev_dir_attribute6 is not null and l_eam_direct_items_rec.attribute6 is null THEN
2766: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 2766: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;

2762: l_eam_direct_items_rec.attribute5 := FND_API.G_MISS_CHAR;
2763: END IF;
2764:
2765: IF l_prev_dir_attribute6 is not null and l_eam_direct_items_rec.attribute6 is null THEN
2766: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;
2767: END IF;
2768:
2769: IF l_prev_dir_attribute7 is not null and l_eam_direct_items_rec.attribute7 is null THEN
2770: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 2770: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;

2766: l_eam_direct_items_rec.attribute6 := FND_API.G_MISS_CHAR;
2767: END IF;
2768:
2769: IF l_prev_dir_attribute7 is not null and l_eam_direct_items_rec.attribute7 is null THEN
2770: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;
2771: END IF;
2772:
2773: IF l_prev_dir_attribute8 is not null and l_eam_direct_items_rec.attribute8 is null THEN
2774: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 2774: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;

2770: l_eam_direct_items_rec.attribute7 := FND_API.G_MISS_CHAR;
2771: END IF;
2772:
2773: IF l_prev_dir_attribute8 is not null and l_eam_direct_items_rec.attribute8 is null THEN
2774: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;
2775: END IF;
2776:
2777: IF l_prev_dir_attribute9 is not null and l_eam_direct_items_rec.attribute9 is null THEN
2778: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 2778: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;

2774: l_eam_direct_items_rec.attribute8 := FND_API.G_MISS_CHAR;
2775: END IF;
2776:
2777: IF l_prev_dir_attribute9 is not null and l_eam_direct_items_rec.attribute9 is null THEN
2778: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;
2779: END IF;
2780:
2781: IF l_prev_dir_attribute10 is not null and l_eam_direct_items_rec.attribute10 is null THEN
2782: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 2782: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;

2778: l_eam_direct_items_rec.attribute9 := FND_API.G_MISS_CHAR;
2779: END IF;
2780:
2781: IF l_prev_dir_attribute10 is not null and l_eam_direct_items_rec.attribute10 is null THEN
2782: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;
2783: END IF;
2784:
2785: IF l_prev_dir_attribute11 is not null and l_eam_direct_items_rec.attribute11 is null THEN
2786: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 2786: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;

2782: l_eam_direct_items_rec.attribute10 := FND_API.G_MISS_CHAR;
2783: END IF;
2784:
2785: IF l_prev_dir_attribute11 is not null and l_eam_direct_items_rec.attribute11 is null THEN
2786: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;
2787: END IF;
2788:
2789: IF l_prev_dir_attribute12 is not null and l_eam_direct_items_rec.attribute12 is null THEN
2790: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 2790: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;

2786: l_eam_direct_items_rec.attribute11 := FND_API.G_MISS_CHAR;
2787: END IF;
2788:
2789: IF l_prev_dir_attribute12 is not null and l_eam_direct_items_rec.attribute12 is null THEN
2790: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;
2791: END IF;
2792:
2793: IF l_prev_dir_attribute13 is not null and l_eam_direct_items_rec.attribute13 is null THEN
2794: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 2794: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;

2790: l_eam_direct_items_rec.attribute12 := FND_API.G_MISS_CHAR;
2791: END IF;
2792:
2793: IF l_prev_dir_attribute13 is not null and l_eam_direct_items_rec.attribute13 is null THEN
2794: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;
2795: END IF;
2796:
2797: IF l_prev_dir_attribute14 is not null and l_eam_direct_items_rec.attribute14 is null THEN
2798: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 2798: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;

2794: l_eam_direct_items_rec.attribute13 := FND_API.G_MISS_CHAR;
2795: END IF;
2796:
2797: IF l_prev_dir_attribute14 is not null and l_eam_direct_items_rec.attribute14 is null THEN
2798: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;
2799: END IF;
2800:
2801: IF l_prev_dir_attribute15 is not null and l_eam_direct_items_rec.attribute15 is null THEN
2802: l_eam_direct_items_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 2802: l_eam_direct_items_rec.attribute15 := FND_API.G_MISS_CHAR;

2798: l_eam_direct_items_rec.attribute14 := FND_API.G_MISS_CHAR;
2799: END IF;
2800:
2801: IF l_prev_dir_attribute15 is not null and l_eam_direct_items_rec.attribute15 is null THEN
2802: l_eam_direct_items_rec.attribute15 := FND_API.G_MISS_CHAR;
2803: END IF;
2804:
2805: --Validate descriptive flexfield for workorder
2806: l_validate := EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field(

Line 2918: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

2914:
2915:
2916: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2917: if (l_eam_failure_entry_record.failure_date is null) then
2918: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
2919: end if;
2920: if (l_eam_failure_codes_tbl(1).failure_code is null) then
2921: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
2922: end if;

Line 2921: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

2917: if (l_eam_failure_entry_record.failure_date is null) then
2918: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
2919: end if;
2920: if (l_eam_failure_codes_tbl(1).failure_code is null) then
2921: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
2922: end if;
2923: if (l_eam_failure_codes_tbl(1).cause_code is null) then
2924: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
2925: end if;

Line 2924: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

2920: if (l_eam_failure_codes_tbl(1).failure_code is null) then
2921: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
2922: end if;
2923: if (l_eam_failure_codes_tbl(1).cause_code is null) then
2924: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
2925: end if;
2926: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
2927: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
2928: end if;

Line 2927: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

2923: if (l_eam_failure_codes_tbl(1).cause_code is null) then
2924: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
2925: end if;
2926: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
2927: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
2928: end if;
2929: if (l_eam_failure_codes_tbl(1).comments is null) then
2930: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
2931: end if;

Line 2930: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

2926: if (l_eam_failure_codes_tbl(1).resolution_code is null) then
2927: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
2928: end if;
2929: if (l_eam_failure_codes_tbl(1).comments is null) then
2930: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
2931: end if;
2932: if(l_eam_failure_entry_record.failure_id is not null ) then
2933: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2934: else

Line 2935: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then

2931: end if;
2932: if(l_eam_failure_entry_record.failure_id is not null ) then
2933: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2934: else
2935: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then
2936: l_eam_failure_entry_record.transaction_type :=null;
2937: l_eam_failure_entry_record.failure_date :=null;
2938: else
2939: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

Line 2948: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

2944: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2945: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
2946:
2947: else
2948: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2949: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2950: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2951: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2952: )

Line 2949: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

2945: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
2946:
2947: else
2948: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2949: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2950: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2951: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2952: )
2953: ) then

Line 2950: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

2946:
2947: else
2948: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2949: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2950: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2951: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2952: )
2953: ) then
2954: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 2951: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

2947: else
2948: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
2949: and (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
2950: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
2951: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2952: )
2953: ) then
2954: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2955: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then

Line 2955: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then

2951: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
2952: )
2953: ) then
2954: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2955: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
2956: l_eam_failure_codes_tbl(1).failure_code := null;
2957: end if;
2958: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
2959: l_eam_failure_codes_tbl(1).cause_code := null;

Line 2958: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then

2954: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2955: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
2956: l_eam_failure_codes_tbl(1).failure_code := null;
2957: end if;
2958: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
2959: l_eam_failure_codes_tbl(1).cause_code := null;
2960: end if;
2961: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
2962: l_eam_failure_codes_tbl(1).resolution_code := null;

Line 2961: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then

2957: end if;
2958: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then
2959: l_eam_failure_codes_tbl(1).cause_code := null;
2960: end if;
2961: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
2962: l_eam_failure_codes_tbl(1).resolution_code := null;
2963: end if;
2964: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
2965: l_eam_failure_codes_tbl(1).comments := null;

Line 2964: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then

2960: end if;
2961: if(l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) then
2962: l_eam_failure_codes_tbl(1).resolution_code := null;
2963: end if;
2964: if(l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) then
2965: l_eam_failure_codes_tbl(1).comments := null;
2966: end if;
2967: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
2968:

Line 3135: IF p_commit = FND_API.G_TRUE THEN

3131:
3132: END IF; /*MSP IF END*/
3133:
3134: IF(x_return_status='S') THEN
3135: IF p_commit = FND_API.G_TRUE THEN
3136: COMMIT WORK;
3137: end if;
3138: IF(l_eam_wo_tbl_out IS NOT NULL AND l_eam_wo_tbl_out.COUNT>0) THEN
3139: x_wip_entity_id := l_eam_wo_tbl_out(l_eam_wo_tbl_out.FIRST).wip_entity_id;