1 PACKAGE HRWSCAL_PKG AUTHID CURRENT_USER as
2 /* $Header: hrwscal.pkh 115.0 99/07/17 05:37:22 porting ship $*/
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20
21 Name : hrwscal_pkg
22
23 Description : This package is the server side agent for
24 form HRWSCAL
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ---- ---- ---- ------ -----------
30 31-Oct-1995 agladsto 40.0 Initial Creation
31 30-JUL-1996 J.ALLOUN Added error handling.
32
33 */
34
35
36 -- Fetch pattern exception details
37 --
38 Procedure fetch_pattern_excpt_details(
39 p_exception_name in varchar2,
40 p_EXCEPTION_ID out number,
41 p_PATTERN_ID out number,
42 p_EXCEPTION_CATEGORY out varchar2,
43 p_EXCEPTION_START_TIME out date,
44 p_EXCEPTION_END_TIME out date,
45 p_PATTERN_NAME out varchar2,
46 p_NEW_EXCEPTION_INDICTOR out varchar2,
47 p_EXCEPTION_CATEGORY_MEANING out varchar2
48 );
49
50 END HRWSCAL_PKG;