1 PACKAGE SSPWSMAT_PKG AUTHID CURRENT_USER as
2 /* $Header: sspwsmat.pkh 120.2 2010/11/17 10:05:50 npannamp ship $ */
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 calculate_apab_form_fields
38 (
39 p_due_date in date,
40 p_ewc in out NOCOPY date,
41 p_qw in out NOCOPY date,
42 p_cont_emp_start_date in out NOCOPY date
43 );
44
45 procedure calculate_apad_form_fields
46 (
47 p_matching_date in date,
48 p_qw in out NOCOPY date,
49 p_cont_emp_start_date in out NOCOPY date
50 );
51
52 procedure get_latest_absence_date
53 (
54 p_maternity_id in number,
55 p_absence_attendance_id in out NOCOPY number,
56 p_abs_end_date in out NOCOPY date,
57 p_rec_found in out NOCOPY boolean
58 );
59
60 procedure upd_abse_end_date
61 (
62 p_maternity_id in number,
63 p_absence_attendance_id in number,
64 p_absence_end_date in date
65 );
66
67 END SSPWSMAT_PKG;