APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_ASSET_FAILURE_CODES

Line 643: FROM eam_asset_failure_codes

639:
640: BEGIN
641: SELECT failure_entry_id , failure_code, cause_code, resolution_code, comments
642: INTO l_eam_failure_codes_tbl(i).failure_entry_id, l_failure_code, l_cause_code, l_resolution_code, l_comments
643: FROM eam_asset_failure_codes
644: WHERE failure_id = l_eam_failure_codes_tbl(i).failure_id;
645: EXCEPTION
646: WHEN NO_DATA_FOUND THEN
647: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');

Line 660: FROM eam_asset_failure_codes

656:
657: BEGIN
658: SELECT failure_id , failure_code, cause_code, resolution_code, comments
659: INTO l_eam_failure_codes_tbl(i).failure_id, l_failure_code, l_cause_code, l_resolution_code, l_comments
660: FROM eam_asset_failure_codes
661: WHERE failure_entry_id = l_eam_failure_codes_tbl(i).failure_entry_id;
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ENTRY_ID');

Line 750: FROM eam_asset_failure_codes

746: ELSE
747: BEGIN
748: SELECT failure_code , cause_code , resolution_code , comments
749: INTO l_failure_code, l_cause_code, l_resolution_code, l_comments
750: FROM eam_asset_failure_codes
751: WHERE failure_id = l_eam_failure_entry_record.failure_id;
752: EXCEPTION
753: WHEN NO_DATA_FOUND THEN
754: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

Line 820: FROM eam_asset_failure_codes

816: THEN
817: BEGIN
818: SELECT comments
819: INTO l_comments
820: FROM eam_asset_failure_codes
821: WHERE failure_id = l_eam_failure_entry_record.failure_id;
822: IF l_comments IS NOT NULL THEN
823: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
824: FND_MSG_PUB.Add;