Rem drv: <create type="post_creation" /> 
Rem
Rem $Header: paf_default_func.sql 20-nov-2005.22:27:19 rahgupta Exp $
Rem
Rem paf_default_func.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      paf_default_func.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    rahgupta    11/20/05 - Remove sample entries 
Rem    ktlaw       11/04/05 - add more built-in functions 
Rem    rahgupta    10/28/05 - rahgupta_paf_enhancemnts
Rem    rahgupta    10/20/05 - add default functions 
Rem    rahgupta    10/19/05 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

BEGIN

  -- use name as paf.functions.paf: so that it is easier to identify
  INSERT INTO MGMT_PARAMETERS
    VALUES ( 'paf.functions.paf:concat', 'oracle.sysman.pp.paf.func.Concat', 
             'Provisioning Adivsor default function', 1 );
  
  INSERT INTO MGMT_PARAMETERS
    VALUES ( 'paf.functions.ora:concat', 'oracle.sysman.pp.paf.func.Concat', 
             'Provisioning Adivsor default function', 1 );

  INSERT INTO MGMT_PARAMETERS
    VALUES ( 'paf.functions.paf:getURNFromPath', 'oracle.sysman.pp.paf.func.GetURNFromPath', 
             'Provisioning Adivsor default function', 1 );
  
  INSERT INTO MGMT_PARAMETERS
    VALUES ( 'paf.functions.ora:getURNFromPath', 'oracle.sysman.pp.paf.func.GetURNFromPath', 
             'Provisioning Adivsor default function', 1 );
  
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:add' , 'oracle.sysman.pp.paf.func.Add' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:and' , 'oracle.sysman.pp.paf.func.And' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:avg' , 'oracle.sysman.pp.paf.func.Avg' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:contains' , 'oracle.sysman.pp.paf.func.Contains' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:divide' , 'oracle.sysman.pp.paf.func.Divide' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:eq' , 'oracle.sysman.pp.paf.func.Equals' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:sysprop' , 'oracle.sysman.pp.paf.func.GetSystemProperty' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:gt' , 'oracle.sysman.pp.paf.func.GreaterThan' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:ge' , 'oracle.sysman.pp.paf.func.GTEQ' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:isNull' , 'oracle.sysman.pp.paf.func.IsNull' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:lt' , 'oracle.sysman.pp.paf.func.LessThan' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:le' , 'oracle.sysman.pp.paf.func.LTEQ' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:listGet' , 'oracle.sysman.pp.paf.func.ListGet' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:mod' , 'oracle.sysman.pp.paf.func.Mod' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:multiply' , 'oracle.sysman.pp.paf.func.Multiply' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:not' , 'oracle.sysman.pp.paf.func.Not' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:ne' , 'oracle.sysman.pp.paf.func.NotEquals' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:or' , 'oracle.sysman.pp.paf.func.Or' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:strcmp' , 'oracle.sysman.pp.paf.func.StringCompare' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:strlen' , 'oracle.sysman.pp.paf.func.StringLength' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:substring' , 'oracle.sysman.pp.paf.func.Substring' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:subtract' , 'oracle.sysman.pp.paf.func.Subtract' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:sum' , 'oracle.sysman.pp.paf.func.Sum' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:trace' , 'oracle.sysman.pp.paf.func.Trace' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:null' , 'oracle.sysman.pp.paf.func.Null' , 'PAF funcs' , 1);
  INSERT INTO MGMT_PARAMETERS VALUES ( 'paf.functions.ora:list' , 'oracle.sysman.pp.paf.func.CreateList' , 'PAF funcs' , 1);
    

EXCEPTION WHEN OTHERS THEN NULL;

END;
/

COMMIT;