1 PACKAGE SSPWSMAT_PKG as
2 /* $Header: sspwsmat.pkh 120.1 2005/06/15 04:09:03 tukumar noship $ */
3
4 procedure calculate_smp_form_fields
5 (
6 p_due_date in date,
7 p_ewc in out NOCOPY date,
8 p_earliest_mpp_start in out NOCOPY date,
9 p_qw in out NOCOPY date,
10 p_cont_emp_start_date in out NOCOPY date
11 );
12
13 procedure calculate_sap_form_fields
14 (
15 p_due_date in date,
16 p_matching_date in date,
17 p_earliest_mpp_start in out NOCOPY date,
18 p_qw in out NOCOPY date,
19 p_cont_emp_start_date in out NOCOPY date
20 );
21
22 procedure calculate_pab_form_fields
23 (
24 p_due_date in date,
25 p_ewc in out NOCOPY date,
26 p_qw in out NOCOPY date,
27 p_cont_emp_start_date in out NOCOPY date
28 );
29
30 procedure calculate_pad_form_fields
31 (
32 p_matching_date in date,
33 p_qw in out NOCOPY date,
34 p_cont_emp_start_date in out NOCOPY date
35 );
36
37 procedure get_latest_absence_date
38 (
39 p_maternity_id in number,
40 p_absence_attendance_id in out NOCOPY number,
41 p_abs_end_date in out NOCOPY date,
42 p_rec_found in out NOCOPY boolean
43 );
44
45 procedure upd_abse_end_date
46 (
47 p_maternity_id in number,
48 p_absence_attendance_id in number,
49 p_absence_end_date in date
50 );
51
52 END SSPWSMAT_PKG;