Rem
Rem $Header: jobs_audit_pkgdef.sql 04-oct-2004.05:05:13 shianand Exp $
Rem
Rem jobs_audit_pkgdef.sql
Rem
Rem Copyright (c) 2004, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      jobs_audit_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    shianand    10/04/04 - shianand_shi_job_user_audit
Rem    shianand    09/02/04 - Created
Rem

--This package generate and put the "audit" data into MGMT_JOB_AUDIT_HISTORY table

--job_name: The name of a specific job whose audit trail is required

--username : The the name of the user who submitted the job, username could be 
--null in that case all the jobs with in the specified time interval will be scanned
--and stored inside the table

--job_owner: The job owner.
--job_type: The job type to get audit information for
--start_time, end_time: If specified, the time interval between which to look for jobs



CREATE OR REPLACE PACKAGE MGMT_JOB_AUDIT_HISTORY_DATA IS

PROCEDURE generate_job_audit_data_jname(p_job_name IN VARCHAR2,
                                        p_job_owner IN VARCHAR2);

PROCEDURE generate_job_audit_data_jtype(p_job_type IN VARCHAR2,
                                        p_start_time IN DATE,
                                        p_end_time IN DATE);

PROCEDURE generate_job_audit_data_juser(p_username IN VARCHAR2 DEFAULT NULL,
                                        p_start_time IN DATE,
                                        p_end_time IN DATE);                                  

END MGMT_JOB_AUDIT_HISTORY_DATA;
/
show errors;