APPS.EAM_ASSET_NUM_IMPORT_PVT dependencies on MTL_EAM_ATTR_VAL_INTERFACE

Line 288: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

284: WHERE CURRENT OF invalid_scope_asset_cur;
285:
286: -- 2001-12-28: chrng: To fix bug 2162520
287: -- Flag corresponding rows in meavi as Error as well.
288: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
289: SET meavi.error_number = 9999,
290: meavi.process_status = 'E',
291: meavi.error_message = 'Corresponding row in MTL_EAM_ASSET_NUM_INTERFACE has invalid Scope value'
292: WHERE meavi.process_status = 'P'

Line 334: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

330: meani.error_message = 'Incorrect Mode Value'
331: WHERE CURRENT OF invalid_mode_asset_cur;
332:
333: -- Flag corresponding rows in meavi as Error as well.
334: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
335: SET meavi.error_number = 9999,
336: meavi.process_status = 'E',
337: meavi.error_message = 'Corresponding row in MTL_EAM_ASSET_NUM_INTERFACE has invalid Mode value'
338: WHERE meavi.process_status = 'P'

Line 398: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

394: error_message = 'Invalid Organization. Check that it is NOT NULL, EXISTS and is EAM ENABLED'
395: WHERE CURRENT OF null_org_asset_cur;
396:
397: -- Flag corresponding rows in meavi as Error as well.
398: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
399: SET meavi.error_number = 9999,
400: meavi.process_status = 'E',
401: meavi.error_message = 'Corresponding row in MTL_EAM_ASSET_NUM_INTERFACE has invalid organzation'
402: WHERE meavi.process_status = 'P'