1 PACKAGE pay_ie_prsi AUTHID CURRENT_USER AS
2 /* $Header: pyieprsi.pkh 120.1 2009/05/06 05:10:32 knadhan ship $ */
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 ** 21-APR-2009 knadhan 8448176 Added function get_bal_value_30_04_09
19
20 -------------------------------------------------------------------------------
21 */
22 Function get_prsi_details( p_assignment_id in number
23 ,p_payroll_action_id in number
24 ,p_contribution_class out nocopy varchar2
25 ,p_overridden_subclass out nocopy varchar2
26 ,p_soc_ben_flag out nocopy varchar2
27 ,p_overridden_ins_weeks out nocopy number
28 ,p_community_flag out nocopy varchar2
29 ,p_exemption_start_date out nocopy date
30 ,p_exemption_end_date out nocopy date)
31 return number;
32 --
33 -- Calculate insurable weeks for Monthly employees
34 --
35 Function get_ins_weeks_for_monthly_emps (p_hire_date in date
36 ,p_proc_period_start_date in date
37 ,p_term_date in date
38 ,p_proc_period_end_date in date
39 ,p_processing_date in date)
40 return number;
41 --
42 Function get_period_type (p_payroll_id in number
43 ,p_session_date in date)
44 return varchar2;
45 --
46 Function get_period_start_date (p_payroll_id in number
47 ,p_session_date in date)
48 return varchar2;
49 --
50 Function get_period_end_date (p_payroll_id in number
51 ,p_session_date in date)
52 return varchar2;
53 --
54 /* knadhan */
55 FUNCTION get_bal_value_30_04_09 (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
56 ,p_tax_unit_id IN NUMBER
57 ,p_balance_name IN pay_balance_types.balance_name%TYPE
58 ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
59 ,p_till_date IN DATE) RETURN number;
60 end pay_ie_prsi;