APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_ASSET_FAILURE_CODES

Line 649: FROM eam_asset_failure_codes

645:
646: BEGIN
647: SELECT failure_entry_id , failure_code, cause_code, resolution_code, comments
648: INTO l_eam_failure_codes_tbl(i).failure_entry_id, l_failure_code, l_cause_code, l_resolution_code, l_comments
649: FROM eam_asset_failure_codes
650: WHERE failure_id = l_eam_failure_codes_tbl(i).failure_id;
651: EXCEPTION
652: WHEN NO_DATA_FOUND THEN
653: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE');

Line 666: FROM eam_asset_failure_codes

662:
663: BEGIN
664: SELECT failure_id , failure_code, cause_code, resolution_code, comments
665: INTO l_eam_failure_codes_tbl(i).failure_id, l_failure_code, l_cause_code, l_resolution_code, l_comments
666: FROM eam_asset_failure_codes
667: WHERE failure_entry_id = l_eam_failure_codes_tbl(i).failure_entry_id;
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN
670: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_FAILURE_ENTRY_ID');

Line 756: FROM eam_asset_failure_codes

752: ELSE
753: BEGIN
754: SELECT failure_code , cause_code , resolution_code , comments
755: INTO l_failure_code, l_cause_code, l_resolution_code, l_comments
756: FROM eam_asset_failure_codes
757: WHERE failure_id = l_eam_failure_entry_record.failure_id;
758: EXCEPTION
759: WHEN NO_DATA_FOUND THEN
760: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');

Line 826: FROM eam_asset_failure_codes

822: THEN
823: BEGIN
824: SELECT comments
825: INTO l_comments
826: FROM eam_asset_failure_codes
827: WHERE failure_id = l_eam_failure_entry_record.failure_id;
828: IF l_comments IS NOT NULL THEN
829: FND_MESSAGE.SET_NAME ('EAM', 'EAM_ENTER_FAILURE_INFO');
830: FND_MSG_PUB.Add;