1 PACKAGE SSPWSMED_PKG AUTHID CURRENT_USER as
2 /* $Header: sspwsmed.pkh 115.0 99/07/16 23:04:12 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 : sspwsmed_pkg
22
23 Description : This package is the server side agent for SMP/SSP
24 form SSPWSMED
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ---- ---- ---- ------ -----------
30 22-AUG-1995 ssethi 40.0 Initial Creation
31 13-SEP-1995 ssethi Added two procedures to
32 update the evidence
33 status if the current
34 one is 'Current'.
35
36 */
37
38 PROCEDURE get_medical_sequence (p_medical_id in out number);
39
40 PROCEDURE check_unique_mat_evidence
41 (p_evidence_source in varchar2,
42 p_evidence_date in date,
43 p_maternity_id in number,
44 p_medical_id in number);
45
46 PROCEDURE check_unique_abs_evidence
47 (p_evidence_source in varchar2,
48 p_evidence_date in date,
49 p_absence_attendance_id in number,
50 p_medical_id in number);
51
52 PROCEDURE upd_prev_sick_evid (p_absence_attendance_id in number);
53
54 PROCEDURE upd_prev_mat_evid (p_maternity_id in number);
55
56 END SSPWSMED_PKG;