REM drv: <create type="pkgbodys"/>`
Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/latest/dsvc/prov_job_util_pkgbodys.sql /st_emcore_10.2.0.4.2db11.2/1 2008/10/28 16:22:51 rahgupta Exp $
Rem
Rem prov_job_util_pkgbodys.sql
Rem
Rem Copyright (c) 2008, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      prov_job_util_pkgbodys.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    10/27/08 - Created
Rem

CREATE OR REPLACE PACKAGE BODY MGMT_PROV_JOB_UTIL AS

  PROCEDURE UPDATE_PROV_JOB
    (
      p_job_status IN SMP_EMD_NVPAIR_ARRAY
    )
  IS

  BEGIN

    -- Use Dynamic SQL for PAF Callback, as PAF exists only for EMPP
    EXECUTE IMMEDIATE 
      'BEGIN MGMT_PAF_JOB_UTIL.UPDATE_PAF_JOB ( :1 ); END;'
    USING p_job_status;

    -- WE IGNORE THIS ERROR AS PAF EXISTS ONLY FOR FULL INSTALLS

  EXCEPTION WHEN OTHERS THEN NULL;

  END UPDATE_PROV_JOB;

END MGMT_PROV_JOB_UTIL;

/

show errors;