DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on EAM_PROCESS_FAILURE_ENTRY_PUB

Line 206: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;

202: l_prev_project_id NUMBER;
203: l_prev_task_id NUMBER;
204: /* Added for bug#6053425 End */
205:
206: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
207: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
208: l_fail_dept_id NUMBER;
209: l_eam_location_id NUMBER;
210: l_eam_failure_code_required varchar2(30);

Line 207: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;

203: l_prev_task_id NUMBER;
204: /* Added for bug#6053425 End */
205:
206: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
207: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
208: l_fail_dept_id NUMBER;
209: l_eam_location_id NUMBER;
210: l_eam_failure_code_required varchar2(30);
211: l_wo_exists BOOLEAN;

Line 306: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

302: END;
303: END IF; --end of check for mainteannce_object_type =3
304:
305:
306: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
307: l_eam_failure_entry_record.source_type := 1;
308: l_eam_failure_entry_record.source_id := l_eam_wo_comp_rec.wip_entity_id;
309: l_eam_failure_entry_record.object_type := l_maintenance_object_type;
310: l_eam_failure_entry_record.object_id := l_maintenance_object_id;

Line 316: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

312: l_eam_failure_entry_record.current_organization_id := l_eam_wo_comp_rec.organization_id;
313: l_eam_failure_entry_record.department_id := l_fail_dept_id;
314: l_eam_failure_entry_record.area_id := l_eam_location_id;
315:
316: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
317:
318: IF (l_eam_failure_entry_record.failure_date IS NULL) THEN
319: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
320: END IF;

Line 339: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

335: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
336: END IF;
337:
338: IF(l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
339: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
340: ELSE
341: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
342: l_eam_failure_entry_record.transaction_type :=null;
343: l_eam_failure_entry_record.failure_date :=null;

Line 345: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

341: IF(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
342: l_eam_failure_entry_record.transaction_type :=null;
343: l_eam_failure_entry_record.failure_date :=null;
344: ELSE
345: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
346: END IF;
347: END IF;
348:
349: IF(l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN

Line 350: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

346: END IF;
347: END IF;
348:
349: IF(l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN
350: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
351: l_eam_wo_comp_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
352:
353: ELSE
354: IF( NOT( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

Line 360: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

356: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
357: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
358: )
359: ) THEN
360: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
361:
362: IF(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
363: l_eam_failure_codes_tbl(1).failure_code := null;
364: END IF;

Line 720: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

716: l_eam_wo_rec.failure_code_required := p_failure_code_required;
717:
718: IF(l_wo_exists = TRUE) THEN
719:
720: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
721: l_eam_failure_entry_record.source_type := 1;
722: l_eam_failure_entry_record.source_id := l_eam_wo_rec.wip_entity_id;
723: l_eam_failure_entry_record.object_type := l_eam_wo_rec.maintenance_object_type;
724: l_eam_failure_entry_record.object_id := l_eam_wo_rec.maintenance_object_id;

Line 731: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

727: l_eam_failure_entry_record.department_id := l_fail_dept_id;
728: l_eam_failure_entry_record.area_id := l_eam_location_id;
729:
730:
731: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
732: if (l_eam_failure_entry_record.failure_date is null) then
733: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
734: end if;
735: if (l_eam_failure_codes_tbl(1).failure_code is null) then

Line 748: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

744: if (l_eam_failure_codes_tbl(1).comments is null) then
745: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
746: end if;
747: if(l_eam_failure_entry_record.failure_id is not null ) then
748: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
749: else
750: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then
751: l_eam_failure_entry_record.transaction_type :=null;
752: l_eam_failure_entry_record.failure_date :=null;

Line 754: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;

750: if(l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) then
751: l_eam_failure_entry_record.transaction_type :=null;
752: l_eam_failure_entry_record.failure_date :=null;
753: else
754: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
755: end if;
756: end if;
757:
758: if(l_eam_failure_codes_tbl(1).failure_entry_id is not null) then

Line 759: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

755: end if;
756: end if;
757:
758: if(l_eam_failure_codes_tbl(1).failure_entry_id is not null) then
759: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
760: l_eam_wo_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
761:
762: else
763: if( not( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

Line 769: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

765: and (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
766: and (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
767: )
768: ) then
769: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
770: if(l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) then
771: l_eam_failure_codes_tbl(1).failure_code := null;
772: end if;
773: if(l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) then

Line 794: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

790: l_eam_wo_rec.eam_failure_entry_record := l_eam_failure_entry_record;
791:
792: ELSE -- work order is getting created
793:
794: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
795: l_eam_failure_entry_record.source_type := 1;
796: l_eam_failure_entry_record.source_id := l_eam_wo_rec.wip_entity_id;
797: l_eam_failure_entry_record.object_type := l_eam_wo_rec.maintenance_object_type;
798: l_eam_failure_entry_record.object_id := l_eam_wo_rec.maintenance_object_id;

Line 809: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

805: l_eam_failure_entry_record.transaction_type :=null;
806: end if;
807: l_eam_wo_rec.eam_failure_entry_record := l_eam_failure_entry_record;
808:
809: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
810: if( not( l_eam_failure_codes_tbl(1).failure_code is null
811: and l_eam_failure_codes_tbl(1).cause_code is null
812: and l_eam_failure_codes_tbl(1).resolution_code is null
813: and l_eam_failure_codes_tbl(1).comments is null