1 PACKAGE be_call_ff_pkg AUTHID CURRENT_USER AS
2 -- $Header: pebeclff.pkh 115.8 2003/02/07 09:52:19 atrivedi noship $
3 --
4 -- computes the employee's notice period
5 --
6 PROCEDURE calculate_notice_period
7 ( p_service_years IN NUMBER,
8 p_service_months IN NUMBER,
9 p_age_years IN NUMBER,
10 p_age_months IN NUMBER,
11 p_salary IN NUMBER,
12 p_notice_type IN VARCHAR2,
13 p_derivation_method IN VARCHAR2,
14 p_assignment_id IN NUMBER,
15 p_business_group_id IN NUMBER,
16 p_legislation_code IN VARCHAR2,
17 p_session_date IN DATE,
18 p_notice_period IN OUT NOCOPY NUMBER,
19 p_counter_notice IN OUT NOCOPY NUMBER,
20 p_leave_days IN OUT NOCOPY VARCHAR2);
21
22 --
23 -- Validates the NI number
24 --
25 FUNCTION check_ni
26 ( p_national_identifier IN VARCHAR2,
27 p_birth_date IN DATE,
28 p_gender IN VARCHAR2,
29 p_event IN VARCHAR2,
30 p_person_id IN NUMBER,
31 p_business_group_id IN NUMBER,
32 p_legislation_code IN VARCHAR2 DEFAULT 'BE',
33 p_session_date IN DATE) RETURN VARCHAR2;
34
35 end be_call_ff_pkg;
36
[Home] [Help]