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 1018: /* validate that the row already exists in MTL_EAM_NETWORK_ASSETS table */

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

Line 1022: from mtl_eam_network_assets mena

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

Line 1041: UPDATE MTL_EAM_NETWORK_ASSETS

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