APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on MTL_EAM_ATTR_VAL_INTERFACE

Line 120: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

116: WHERE interface_header_id = p_asset_rec.interface_header_id;
117:
118: -- 2002-01-02: chrng: To fix bug 2167988, also flag the corresponding
119: -- rows in Asset Attribute interface table as error
120: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
121: SET meavi.error_number = 9999,
122: meavi.process_status = 'E',
123: meavi.error_message = 'Import of corresponding row in MTL_EAM_ASSET_NUM_INTERFACE failed'
124: WHERE meavi.interface_header_id = p_asset_rec.interface_header_id

Line 973: FROM mtl_eam_attr_val_interface

969: association_id,
970: process_status,
971: error_number,
972: error_message
973: FROM mtl_eam_attr_val_interface
974: WHERE interface_header_id = asset_rec.interface_header_id;
975:
976: TYPE meavi_tabtype IS TABLE OF meavi_cur%ROWTYPE
977: INDEX BY BINARY_INTEGER;

Line 1009: UPDATE mtl_eam_attr_val_interface

1005: i := meavi_tab.FIRST;
1006: LOOP
1007: EXIT WHEN i IS NULL;
1008:
1009: UPDATE mtl_eam_attr_val_interface
1010: SET application_id = meavi_tab(i).application_id,
1011: descriptive_flexfield_name = meavi_tab(i).descriptive_flexfield_name,
1012: application_column_name = meavi_tab(i).application_column_name,
1013: association_id = meavi_tab(i).association_id,