PACKAGE: APPS.PQH_EMPLOYMENT_CATEGORY

Source

1 PACKAGE pqh_employment_category AUTHID CURRENT_USER AS
2 /* $Header: pqhuseeo.pkh 115.6 2003/01/17 15:27:24 kgowripe noship $*/
3 --
4 --
5 PROCEDURE fetch_empl_categories (
6 	p_business_group_id	 in number,
7 	p_full_time_regular out nocopy varchar2,
8 	p_full_time_temp    out nocopy varchar2,
9 	p_part_time_regular out nocopy varchar2,
10 	p_part_time_temp    out nocopy varchar2 );
11 --
12 --
13 FUNCTION  identify_empl_category (
14 	p_empl_category		in varchar2,
15 	p_full_time_regular	in varchar2,
16 	p_full_time_temp   	in varchar2,
17 	p_part_time_regular	in varchar2,
18 	p_part_time_temp   	in varchar2)RETURN varchar2;
19 --
20 -- function for returning the equivalent no. of months given a duration
21 FUNCTION get_duration_in_months(
22           p_duration    IN NUMBER,
23           p_duration_units IN VARCHAR2,
24           p_business_group_id IN NUMBER,
25           p_ref_date    IN date DEFAULT sysdate) RETURN NUMBER;
26 --
27 FUNCTION   get_service_start_date (p_period_of_service_id IN NUMBER) RETURN DATE;
28 --
29 END pqh_employment_category;