APPS.EAM_ASSET_ROUTES_PUB dependencies on MTL_EAM_NETWORK_ASSETS

Line 218: p_desc_flex_name => 'MTL_EAM_NETWORK_ASSETS',

214: -- validate the desc. flex fields
215: if not EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field
216: (
217: p_app_short_name => 'INV',
218: p_desc_flex_name => 'MTL_EAM_NETWORK_ASSETS',
219: p_ATTRIBUTE_CATEGORY => p_ATTRIBUTE_CATEGORY,
220: p_ATTRIBUTE1 => p_ATTRIBUTE1,
221: p_ATTRIBUTE2 => p_ATTRIBUTE2,
222: p_ATTRIBUTE3 => p_ATTRIBUTE3,

Line 260: FROM MTL_EAM_NETWORK_ASSETS

256: is
257: l_count number;
258: BEGIN
259: SELECT COUNT(*) INTO l_count
260: FROM MTL_EAM_NETWORK_ASSETS
261: WHERE network_item_id= p_network_ITEM_id
262: AND network_serial_number= p_network_serial_number
263: AND inventory_item_id = p_inventory_item_id
264: AND serial_number= p_serial_number

Line 582: from mtl_eam_network_assets mena

578: /* validate that the row does not already exist */
579:
580: begin
581: select count(*) into l_count
582: from mtl_eam_network_assets mena
583: where mena.network_object_id = l_network_object_id
584: and mena.network_object_type = l_network_object_type
585: and mena.maintenance_object_id = l_maintenance_object_id
586: and mena.maintenance_object_type = l_maintenance_object_type;

Line 599: select MTL_EAM_NETWORK_ASSETS_S.NEXTVAL into l_network_id from dual;

595: null;
596: END ;
597:
598:
599: select MTL_EAM_NETWORK_ASSETS_S.NEXTVAL into l_network_id from dual;
600:
601:
602: INSERT INTO MTL_EAM_NETWORK_ASSETS (
603: NETWORK_ASSOCIATION_ID ,

Line 602: INSERT INTO MTL_EAM_NETWORK_ASSETS (

598:
599: select MTL_EAM_NETWORK_ASSETS_S.NEXTVAL into l_network_id from dual;
600:
601:
602: INSERT INTO MTL_EAM_NETWORK_ASSETS (
603: NETWORK_ASSOCIATION_ID ,
604: ORGANIZATION_ID ,
605: NETWORK_OBJECT_TYPE ,
606: NETWORK_OBJECT_ID ,

Line 1016: /* validate that the row already exists in MTL_EAM_NETWORK_ASSETS table */

1012: END;
1013:
1014:
1015: --------------------------------------------------------------------------------------------
1016: /* validate that the row already exists in MTL_EAM_NETWORK_ASSETS table */
1017:
1018: begin
1019: select count(*) into l_count
1020: from mtl_eam_network_assets mena

Line 1020: from mtl_eam_network_assets mena

1016: /* validate that the row already exists in MTL_EAM_NETWORK_ASSETS table */
1017:
1018: begin
1019: select count(*) into l_count
1020: from mtl_eam_network_assets mena
1021: where mena.network_object_id = l_network_object_id
1022: and mena.network_object_type = l_network_object_type
1023: and mena.maintenance_object_id = l_maintenance_object_id
1024: and mena.maintenance_object_type = l_maintenance_object_type

Line 1039: UPDATE MTL_EAM_NETWORK_ASSETS

1035: fnd_msg_pub.add;
1036: RAISE fnd_api.g_exc_error;
1037: END;
1038:
1039: UPDATE MTL_EAM_NETWORK_ASSETS
1040: SET
1041: START_DATE_ACTIVE = P_START_DATE_ACTIVE ,
1042: END_DATE_ACTIVE = P_END_DATE_ACTIVE ,
1043: ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY ,