Rem
Rem $Header: webapp_upgrade_pkgdef.sql 13-may-2005.19:42:46 rmarripa Exp $
Rem
Rem webapp_upgrade_pkgdef.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      webapp_upgrade_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    rmarripa    05/13/05 - add sync beacon 
Rem    rmarripa    05/11/05 - add module name 
Rem    rmarripa    12/24/04 - rmarripa_webapp_upgrade_changes
Rem    rmarripa    12/22/04 - Created
Rem
CREATE OR REPLACE PACKAGE webapp_upgrade_job AS

UPGRADE_ASSOC_BEACON CONSTANT VARCHAR2(64) := 'UpgradeAssociatedBeacon';
NO_UPGRADE_ASSOC_BEACON CONSTANT VARCHAR2(32) := 'None';
MODULE_NAME VARCHAR2(32) := 'Webapp10gR2Upgrade';

PROCEDURE UPGRADE_TARGET_DATA( tgt_name IN VARCHAR2,
                               tgt_type IN VARCHAR2,
                               beacon_name IN VARCHAR2,
                               beacon_type IN VARCHAR2);
    
PROCEDURE MIGRATE_METRIC_HISTORY;

FUNCTION ALTERED_KEY_VALUE(p_target IN RAW,
                           p_old_key IN VARCHAR2,
                           p_beacon_name IN VARCHAR2 DEFAULT NULL)
                               RETURN RAW;

FUNCTION GENERATE_KEY_VALUE(p_target IN RAW,
                            p_txn_name IN VARCHAR2,
                            p_beacon_name IN VARCHAR2 DEFAULT NULL)
                               RETURN RAW;

FUNCTION  CORRECT_BCN_VALUE(p_target IN RAW)
                               RETURN VARCHAR2;

PROCEDURE SYNC_ASSOC_BEACONS( tgt_name IN VARCHAR2,
                              tgt_type IN VARCHAR2);

END webapp_upgrade_job;
/
show errors;