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_PROCESS_FAILURE_ENTRY_PVT dependencies on EAM_ASSET_FAILURE_CODES

Line 273: FROM eam_asset_failure_codes

269: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
270: BEGIN
271: SELECT failure_code, cause_code, resolution_code
272: INTO l_old_failure_code, l_old_cause_code, l_old_resolution_code
273: FROM eam_asset_failure_codes
274: WHERE failure_entry_id = l_eam_failure_codes_record.failure_entry_id;
275: EXCEPTION
276: WHEN NO_DATA_FOUND THEN
277: x_reason_failed:='EAM_FAILURE_CHILD_NOT_EXISTS';

Line 298: FROM eam_asset_failure_codes eafc

294: ELSE
295:
296: SELECT count(1)
297: INTO l_failure_codes_exists
298: FROM eam_asset_failure_codes eafc
299: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id
300: AND nvl(eafc.failure_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.failure_code,'NULL VALUE')
301: AND nvl(eafc.cause_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.cause_code,'NULL VALUE')
302: AND nvl(eafc.resolution_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.resolution_code,'NULL VALUE');

Line 334: FROM eam_asset_failure_codes eafc

330:
331: /* Check if the record already exists corresponding to the failure_id */
332: SELECT COUNT(1)
333: INTO l_failure_codes_exists
334: FROM eam_asset_failure_codes eafc
335: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id;
336:
337: IF l_failure_codes_exists >= 1 THEN
338: x_reason_failed:='EAM_MULTIPLE_CHILD';

Line 348: FROM eam_asset_failure_codes eafc

344:
345: /* Check for the Existing Record */
346: SELECT count(1)
347: INTO l_failure_codes_exists
348: FROM eam_asset_failure_codes eafc
349: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id
350: AND nvl(eafc.failure_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.failure_code,'NULL VALUE')
351: AND nvl(eafc.cause_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.cause_code,'NULL VALUE')
352: AND nvl(eafc.resolution_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.resolution_code,'NULL VALUE');

Line 366: FROM eam_asset_failure_codes eafc

362: Need to Verify Whether to Support Multiple Child Records with Comments Only
363: ELSE
364: SELECT count(1)
365: INTO l_failure_codes_exists
366: FROM eam_asset_failure_codes eafc
367: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id
368: *************/
369: END IF;
370: END IF; /* Create/ Update transaction type validation of failure codes */

Line 568: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;

564: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
565: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
566: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
567:
568: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;
569:
570: l_failure_id NUMBER;
571:
572: l_inventory_item_id NUMBER;

Line 808: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */

804: l_eam_failure_codes_record.combination_id := l_combination_id;
805:
806: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
807:
808: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */
809:
810: SELECT eam_asset_failure_codes_s.nextval
811: INTO l_failure_entry_id
812: FROM DUAL;

Line 810: SELECT eam_asset_failure_codes_s.nextval

806: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
807:
808: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */
809:
810: SELECT eam_asset_failure_codes_s.nextval
811: INTO l_failure_entry_id
812: FROM DUAL;
813: l_eam_failure_codes_record.failure_entry_id := l_failure_entry_id;
814:

Line 815: INSERT INTO eam_asset_failure_codes

811: INTO l_failure_entry_id
812: FROM DUAL;
813: l_eam_failure_codes_record.failure_entry_id := l_failure_entry_id;
814:
815: INSERT INTO eam_asset_failure_codes
816: (
817: failure_id,
818: failure_entry_id,
819: combination_id,

Line 845: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */

841: SYSDATE,
842: FND_GLOBAL.user_id,
843: FND_GLOBAL.user_id
844: );
845: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */
846:
847: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
848:
849: UPDATE eam_asset_failure_codes

Line 849: UPDATE eam_asset_failure_codes

845: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */
846:
847: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
848:
849: UPDATE eam_asset_failure_codes
850: SET failure_code = l_eam_failure_codes_record.failure_code
851: ,cause_code = l_eam_failure_codes_record.cause_code
852: ,resolution_code = l_eam_failure_codes_record.resolution_code
853: ,combination_id = nvl( l_eam_failure_codes_record.combination_id, combination_id)

Line 949: DELETE FROM eam_asset_failure_codes eafc

945: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(G_PKG_NAME||' Delete_Failure_Entry : Deleting the earlier failure data') ; END IF;
946:
947: SELECT failure_id INTO l_failure_id FROM eam_asset_failures WHERE source_id = p_source_id;
948:
949: DELETE FROM eam_asset_failure_codes eafc
950: WHERE eafc.failure_id=l_failure_id;
951:
952: DELETE FROM eam_asset_failures eaf
953: WHERE eaf.failure_id=l_failure_id;