Rem drv: <create type="pkgdefs"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/dg/dg_pkgdefs.sql /st_emdbsa_11.2/1 2009/01/27 16:16:51 mmootha Exp $
Rem
Rem dg_pkgdefs.sql
Rem
Rem Copyright (c) 2008, Oracle and/or its affiliates. All rights reserved.
Rem
Rem    NAME
Rem      dg_pkgdefs.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    ngade       09/25/08 -  "Code slap 10.2.0.5.0 -> 11.2SA"
Rem    sjconnol    07/31/07 - Add cols
Rem    ngade       03/18/07 - Created
Rem

CREATE OR REPLACE  PACKAGE MGMT_HA_DG AS

-- PL/SQL Procedure used by loader to handle table inserts for HA_DG_TARGET_SUMMARY

PROCEDURE update_mgmt_ha_dg_target_sum(
    p_target_guid IN RAW,
    p_collection_timestamp IN DATE DEFAULT SYSDATE,
    p_source_type IN VARCHAR2 DEFAULT NULL,
    p_row_type IN VARCHAR2 DEFAULT NULL,
    p_using_broker IN VARCHAR2 DEFAULT NULL,
    p_active_stby IN VARCHAR2 DEFAULT NULL,
    p_db_unique_name IN VARCHAR2 DEFAULT NULL,
    p_db_id IN NUMBER DEFAULT NULL,
    p_prmy_db_unique_name IN VARCHAR2 DEFAULT NULL,
    p_prmy_db_id IN NUMBER DEFAULT NULL,
    p_role IN VARCHAR2 DEFAULT NULL,
    p_stby_list IN VARCHAR2 DEFAULT NULL,
    p_protection_mode IN VARCHAR2 DEFAULT NULL,
    p_fsfo_status IN VARCHAR2 DEFAULT NULL,
    p_status IN VARCHAR2 DEFAULT NULL,
    p_transport_lag IN NUMBER DEFAULT NULL,
    p_apply_lag IN NUMBER DEFAULT NULL);

END MGMT_HA_DG;
/

show errors;