Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\system\system_pkgdef.sql
Rem drv: <create type="pkgdefs" pos="gensvc/gensvc_pkgdefs.sql+"/> Rem Rem $Header: system_pkgdef.sql 02-dec-2005.12:37:36 gan Exp $ Rem Rem system_pkgdef.sql Rem Rem Copyright (c) 2004, 2005, Oracle. All rights reserved. Rem Rem NAME Rem system_pkgdef.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem <short description of component this file declares/defines> Rem Rem NOTES Rem <other useful comments, qualifications, etc.> Rem Rem MODIFIED (MM/DD/YY) Rem gan 12/02/05 - Backport gan_bug-4669119 from main Rem neearora 08/01/05 - Bug 4525467. modified create_system to accept Rem type_meta_ver Rem gsbhatia 07/01/05 - New repmgr header impl Rem neearora 03/01/05 - added owner input parameter in modify_system and Rem create_system procedure Rem neearora 02/23/05 - Added new procedure upsert_system Rem ramalhot 02/02/05 - changed signature for system_pre_delete_callback Rem gan 10/14/04 - add pre target deletion cb Rem gan 10/13/04 - code refactoring Rem gan 10/06/04 - move some function tto util Rem gan 10/05/04 - gan_system_api_1 Rem gan 10/01/04 - Created Rem CREATE or REPLACE PACKAGE EM_SYSTEM AS G_MODULE_NAME constant VARCHAR2(100) := 'EM_SYSTEM'; -- PROCEDURE: CREATE_SYSTEM -- PURPOSE: -- Creates a system -- IN PARAMETERS -- p_system_name: Name of the system -- p_system_type: type of the system -- p_members: NV pair containing member taret names and their types -- p_owner: Owner of the system -- OUT PARAMETERS -- NONE -- ERROR CODES: -- TARGET_DOES_NOT_EXIST: If any of the members do not exist -- -- PROCEDURE CREATE_SYSTEM(p_system_name IN VARCHAR2, p_system_type IN VARCHAR2, p_members IN SMP_EMD_NVPAIR_ARRAY, p_timezone_region IN VARCHAR2, p_owner IN VARCHAR2 DEFAULT NULL, p_type_meta_ver IN VARCHAR2 DEFAULT '1.0' ); -- PROCEDURE: MODIFY_SYSTEM -- PURPOSE: -- Modifies the members of a system -- IN PARAMETERS -- p_system_name: Name of the system -- p_system_type: type of the system -- p_new_members: NV pair containing the new set of member taret names and their types -- to be added to the system -- p_owner: New owner of the system -- OUT PARAMETERS -- NONE -- ERROR CODES: -- TARGET_DOES_NOT_EXIST: If any of the targets do not exist PROCEDURE MODIFY_SYSTEM(p_system_name IN VARCHAR2, p_system_type IN VARCHAR2, p_new_members IN SMP_EMD_NVPAIR_ARRAY, p_owner IN VARCHAR2 DEFAULT NULL); -- PROCEDURE: MODIFY_SYSTEM -- PURPOSE: -- Modifies the members of a system -- IN PARAMETERS -- p_system_name: Name of the system -- p_system_type: type of the system -- p_members_add: NV pair containing the member taret names and their types -- to be added to the system -- p_members_del: NV pair containing the member taret names and their types -- to be deleted from the system. Any associations based on -- these targets are also deleted. -- p_owner: New owner of the system -- OUT PARAMETERS -- NONE -- ERROR CODES: -- TARGET_DOES_NOT_EXIST: If any of the targets do not exist PROCEDURE MODIFY_SYSTEM(p_system_name IN VARCHAR2, p_system_type IN VARCHAR2, p_members_add IN SMP_EMD_NVPAIR_ARRAY, p_members_del IN SMP_EMD_NVPAIR_ARRAY, p_owner IN VARCHAR2 DEFAULT NULL); -- -- PROCEDURE: DELETE_SYSTEM -- PURPOSE: -- Deletes a system -- IN PARAMETERS -- p_system_name: Name of the system -- p_system_type: type of the system -- OUT PARAMETERS -- NONE -- ERROR CODES: -- INSUFFICIENT_PRIV_ERR: If user does not have enough privileges -- PROCEDURE DELETE_SYSTEM(p_system_name IN VARCHAR2, p_system_type IN VARCHAR2); -- -- PROCEDURE: IS_SYSTEM -- PURPOSE: -- check if a type implements system interface -- IN PARAMETERS -- p_target_type: type of the system -- OUT PARAMETERS -- NONE -- ERROR CODES: -- RETURN: 1 for is, 0 for is-not -- FUNCTION is_system(p_target_type IN VARCHAR2) RETURN NUMBER; -- -- PROCEDURE: get_impacted_services -- PURPOSE: -- get all services impacted by a system change, such as target remove -- from system, system deletion. The impacted services run on the system and -- its ancestors -- IN PARAMETERS -- p_system_guid: the system -- p_targets: targets to remove from the system. -- If it is NULL, treate as all targets associations are removed. -- Only guid field in mgmt_guid_array is used -- OUT PARAMETERS -- NONE -- RETURN: array of service guid, only guid field in mgmt_guid_array -- is populated -- FUNCTION get_impacted_services(p_system_guid IN RAW, p_targets IN MGMT_GUID_ARRAY) RETURN MGMT_GUID_ARRAY; -- -- PROCEDURE: member_deletion_callback -- PURPOSE: -- callback when member assoc is deleted -- PROCEDURE member_deletion_callback(p_assoc_def_name IN VARCHAR2, p_source_target_name IN VARCHAR2, p_source_target_type IN VARCHAR2, p_assoc_target_name IN VARCHAR2, p_assoc_target_type IN VARCHAR2, p_scope_target_name IN VARCHAR2, p_scope_target_type IN VARCHAR2); -- -- PROCEDURE: runs_on_deletion_callback -- PURPOSE: -- callback when runs on assoc is deleted -- PROCEDURE runs_on_deletion_callback(p_assoc_def_name IN VARCHAR2, p_source_target_name IN VARCHAR2, p_source_target_type IN VARCHAR2, p_assoc_target_name IN VARCHAR2, p_assoc_target_type IN VARCHAR2, p_scope_target_name IN VARCHAR2, p_scope_target_type IN VARCHAR2); -- -- PROCEDURE: system_pre_del_callback -- PURPOSE -- callback when system is about to be deleted. Will cleanup the -- dependens assocs and metric dependency for all services running on it PROCEDURE system_pre_del_callback(p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_target_guid IN RAW); -- -- PROCEDURE: upsert_system -- PURPOSE -- this procedure will be used by emctl to create/update the system. If the system with the -- given name and type is not present then it will create a new system otherwise it will update -- the existing system, the p_members will be merged with existing members. PROCEDURE upsert_system(p_upsert IN NUMBER, p_system_name IN VARCHAR2, p_system_type IN VARCHAR2, p_members IN SMP_EMD_NVPAIR_ARRAY, p_timezone_region IN VARCHAR2); END; / show error;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de