1 PACKAGE hr_us_osha AUTHID CURRENT_USER AS
2 /* $Header: peusosha.pkh 120.1 2005/06/13 04:51:15 bshukla noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ****************************************************************** */
22 /*
23 Name : hr_us_osha (HEADER)
24
25 Description : This package declares a function required to generate
26 OSHA-reportable incident case numbers.
27
28 Change List
29 -----------
30
31 Version Date Author ER/CR No. Description of Change
32 -------+---------+----------+---------+--------------------------
33 70.0 27-Apr-95 SSDESAI Created
34 115.1 13-AUG-01 GPERRY Changed routine so that it creates
35 unique case numbers and fills in
36 missed numbers.
37 WWBUG 1714703.
38 115.2 13-JUN-05 bshukla Added dbdrv statements for Bug
39 4421316
40 ================================================================= */
41 --
42 --
43 -- Called as a default for the Case Number segment of the
44 -- OSHA-reportable Incident Flex Structure.
45 --
46 --------------------------------------------------------------------
47 function generate_case_number return varchar2;
48 --------------------------------------------------------------------
49 --
50 END hr_us_osha;