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

CREATE OR REPLACE PACKAGE MGMT_PROV_JOB_UTIL AS

  PROV_JOB_ID constant VARCHAR2(64) := 'PROV_JOB_ID';
  PROV_JOB_EXEC_ID constant VARCHAR2(64) := 'PROV_JOB_EXEC_ID';
  PROV_JOB_STATUS constant VARCHAR2(64) := 'PROV_JOB_STATUS';
  PROV_JOB_STATUS_BUCKET constant VARCHAR2(64) := 'PROV_JOB_STATUS_BUCKET';

  PROCEDURE UPDATE_PROV_JOB
    (
      p_job_status IN SMP_EMD_NVPAIR_ARRAY
    );

END MGMT_PROV_JOB_UTIL;

/

show errors;