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 EAM_PROCESS_FAILURE_ENTRY_PUB

Line 212: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;

208: l_prev_project_id NUMBER;
209: l_prev_task_id NUMBER;
210: /* Added for bug#6053425 End */
211:
212: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
213: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
214: l_fail_dept_id NUMBER;
215: l_eam_location_id NUMBER;
216: l_eam_failure_code_required varchar2(30);

Line 213: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;

209: l_prev_task_id NUMBER;
210: /* Added for bug#6053425 End */
211:
212: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
213: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
214: l_fail_dept_id NUMBER;
215: l_eam_location_id NUMBER;
216: l_eam_failure_code_required varchar2(30);
217: l_wo_exists BOOLEAN;

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

369: END;
370: END IF; --end of check for mainteannce_object_type =3
371:
372:
373: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
374: l_eam_failure_entry_record.source_type := 1;
375: l_eam_failure_entry_record.source_id := l_eam_wo_comp_rec.wip_entity_id;
376: l_eam_failure_entry_record.object_type := l_maintenance_object_type;
377: l_eam_failure_entry_record.object_id := l_maintenance_object_id;

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

379: l_eam_failure_entry_record.current_organization_id := l_eam_wo_comp_rec.organization_id;
380: l_eam_failure_entry_record.department_id := l_fail_dept_id;
381: l_eam_failure_entry_record.area_id := l_eam_location_id;
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;

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

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;
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;

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

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 ;
413: END IF;
414: END IF;
415:
416: IF(l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN

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

413: END IF;
414: END IF;
415:
416: IF(l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN
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)

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

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:
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;

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

1269: l_eam_wo_rec.failure_code_required := p_failure_code_required;
1270:
1271: IF(l_wo_exists = TRUE) THEN
1272:
1273: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1274: l_eam_failure_entry_record.source_type := 1;
1275: l_eam_failure_entry_record.source_id := l_eam_wo_rec.wip_entity_id;
1276: l_eam_failure_entry_record.object_type := l_eam_wo_rec.maintenance_object_type;
1277: l_eam_failure_entry_record.object_id := l_eam_wo_rec.maintenance_object_id;

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

1280: l_eam_failure_entry_record.department_id := l_fail_dept_id;
1281: l_eam_failure_entry_record.area_id := l_eam_location_id;
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

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

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
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;

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

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 ;
1308: end if;
1309: end if;
1310:
1311: if(l_eam_failure_codes_tbl(1).failure_entry_id is not null) then

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

1308: end if;
1309: end if;
1310:
1311: if(l_eam_failure_codes_tbl(1).failure_entry_id is not null) then
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)

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

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
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

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

1343: l_eam_wo_rec.eam_failure_entry_record := l_eam_failure_entry_record;
1344:
1345: ELSE -- work order is getting created
1346:
1347: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1348: l_eam_failure_entry_record.source_type := 1;
1349: l_eam_failure_entry_record.source_id := l_eam_wo_rec.wip_entity_id;
1350: l_eam_failure_entry_record.object_type := l_eam_wo_rec.maintenance_object_type;
1351: l_eam_failure_entry_record.object_id := l_eam_wo_rec.maintenance_object_id;

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

1358: l_eam_failure_entry_record.transaction_type :=null;
1359: end if;
1360: l_eam_wo_rec.eam_failure_entry_record := l_eam_failure_entry_record;
1361:
1362: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1363: if( not( l_eam_failure_codes_tbl(1).failure_code is null
1364: and l_eam_failure_codes_tbl(1).cause_code is null
1365: and l_eam_failure_codes_tbl(1).resolution_code is null
1366: and l_eam_failure_codes_tbl(1).comments is null

Line 1842: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;

1838: l_prev_project_id NUMBER;
1839: l_prev_task_id NUMBER;
1840: /* Added for bug#6053425 End */
1841:
1842: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
1843: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
1844: l_fail_dept_id NUMBER;
1845: l_eam_location_id NUMBER;
1846: l_eam_failure_code_required varchar2(30);

Line 1843: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;

1839: l_prev_task_id NUMBER;
1840: /* Added for bug#6053425 End */
1841:
1842: l_eam_failure_entry_record EAM_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
1843: l_eam_failure_codes_tbl EAM_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
1844: l_fail_dept_id NUMBER;
1845: l_eam_location_id NUMBER;
1846: l_eam_failure_code_required varchar2(30);
1847: l_wo_exists BOOLEAN;

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

1999: END;
2000: END IF; --end of check for mainteannce_object_type =3
2001:
2002:
2003: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2004: l_eam_failure_entry_record.source_type := 1;
2005: l_eam_failure_entry_record.source_id := l_eam_wo_comp_rec.wip_entity_id;
2006: l_eam_failure_entry_record.object_type := l_maintenance_object_type;
2007: l_eam_failure_entry_record.object_id := l_maintenance_object_id;

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

2009: l_eam_failure_entry_record.current_organization_id := l_eam_wo_comp_rec.organization_id;
2010: l_eam_failure_entry_record.department_id := l_fail_dept_id;
2011: l_eam_failure_entry_record.area_id := l_eam_location_id;
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;

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

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;
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;

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

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 ;
2043: END IF;
2044: END IF;
2045:
2046: IF(l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN

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

2043: END IF;
2044: END IF;
2045:
2046: IF(l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN
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)

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

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:
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;

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

2901: l_eam_wo_rec.failure_code_required := p_failure_code_required;
2902:
2903: IF(l_wo_exists = TRUE) THEN
2904:
2905: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
2906: l_eam_failure_entry_record.source_type := 1;
2907: l_eam_failure_entry_record.source_id := l_eam_wo_rec.wip_entity_id;
2908: l_eam_failure_entry_record.object_type := l_eam_wo_rec.maintenance_object_type;
2909: l_eam_failure_entry_record.object_id := l_eam_wo_rec.maintenance_object_id;

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

2912: l_eam_failure_entry_record.department_id := l_fail_dept_id;
2913: l_eam_failure_entry_record.area_id := l_eam_location_id;
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

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

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
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;

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

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 ;
2940: end if;
2941: end if;
2942:
2943: if(l_eam_failure_codes_tbl(1).failure_entry_id is not null) then

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

2940: end if;
2941: end if;
2942:
2943: if(l_eam_failure_codes_tbl(1).failure_entry_id is not null) then
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)

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

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
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

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

2975: l_eam_wo_rec.eam_failure_entry_record := l_eam_failure_entry_record;
2976:
2977: ELSE -- work order is getting created
2978:
2979: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2980: l_eam_failure_entry_record.source_type := 1;
2981: l_eam_failure_entry_record.source_id := l_eam_wo_rec.wip_entity_id;
2982: l_eam_failure_entry_record.object_type := l_eam_wo_rec.maintenance_object_type;
2983: l_eam_failure_entry_record.object_id := l_eam_wo_rec.maintenance_object_id;

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

2990: l_eam_failure_entry_record.transaction_type :=null;
2991: end if;
2992: l_eam_wo_rec.eam_failure_entry_record := l_eam_failure_entry_record;
2993:
2994: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
2995: if( not( l_eam_failure_codes_tbl(1).failure_code is null
2996: and l_eam_failure_codes_tbl(1).cause_code is null
2997: and l_eam_failure_codes_tbl(1).resolution_code is null
2998: and l_eam_failure_codes_tbl(1).comments is null