1 PACKAGE pay_ie_prsi AS
2 /* $Header: pyieprsi.pkh 120.0.12000000.1 2007/01/17 20:54:46 appldev noship $ */
3 /*
4 **
5 ** Copyright (C) 1999 Oracle Corporation
6 ** All Rights Reserved
7 **
8 ** IE PAYE package
9 **
10 ** Change List
11 ** ===========
12 **
13 ** Date Author Reference Description
14 ** -----------+--------+---------+-------------
15 ** 25 JUN 2001 ILeath N/A Created
16 ** 10-JAN-2003 SMRobins 2652940 Added function
17 ** get_ins_weeks_for_monthly_emps
18 -------------------------------------------------------------------------------
19 */
20 Function get_prsi_details( p_assignment_id in number
21 ,p_payroll_action_id in number
22 ,p_contribution_class out nocopy varchar2
23 ,p_overridden_subclass out nocopy varchar2
24 ,p_soc_ben_flag out nocopy varchar2
25 ,p_overridden_ins_weeks out nocopy number
26 ,p_community_flag out nocopy varchar2
27 ,p_exemption_start_date out nocopy date
28 ,p_exemption_end_date out nocopy date)
29 return number;
30 --
31 -- Calculate insurable weeks for Monthly employees
32 --
33 Function get_ins_weeks_for_monthly_emps (p_hire_date in date
34 ,p_proc_period_start_date in date
35 ,p_term_date in date
36 ,p_proc_period_end_date in date
37 ,p_processing_date in date)
38 return number;
39 --
40 Function get_period_type (p_payroll_id in number
41 ,p_session_date in date)
42 return varchar2;
43 --
44 Function get_period_start_date (p_payroll_id in number
45 ,p_session_date in date)
46 return varchar2;
47 --
48 Function get_period_end_date (p_payroll_id in number
49 ,p_session_date in date)
50 return varchar2;
51 --
52 end pay_ie_prsi;