1 PACKAGE HR_DE_GENERAL AUTHID CURRENT_USER AS
2 /* $Header: pedegenr.pkh 115.14 2003/02/24 16:01:48 rmakhija noship $ */
3 --
4 FUNCTION get_three_digit_code(p_legislation_code in varchar2)
5 RETURN VARCHAR2;
6 --
7 --
8 PROCEDURE get_social_insurance_globals(
9 p_business_group_id in number
10 ,p_effective_date in date
11 ,o_hlth_ins_contrib_insig_pct out nocopy number
12 ,o_pens_ins_contrib_insig_pct out nocopy number
13 ,o_spcl_care_ins_pct out nocopy number
14 ,o_pens_ins_pect out nocopy number
15 ,o_unemp_ins_pect out nocopy number
16 ,o_hlth_ins_mon_gross_contrib out nocopy number
17 ,o_pens_ins_mon_gross_contrib_w out nocopy number
18 ,o_pens_ins_mon_gross_contrib_e out nocopy number
19 ,o_minr_ins_mon_gross_contrib_w out nocopy number
20 ,o_minr_ins_mon_gross_contrib_e out nocopy number
21 ,o_hlth_ins_contrib_insigph_pct out nocopy number
22 ,o_pens_ins_contrib_insigph_pct out nocopy number
23 ,o_tax_contrib_insig_pct out nocopy number
24 ,o_tax_contrib_insigph_pct out nocopy number
25 ,o_pvt_hlth_ins_min_mon_gross out nocopy number
26 );
27 --
28 function business_group_currency
29 (p_business_group_id in hr_organization_units.business_group_id%type)
30 return fnd_currencies.currency_code%type;
31
32 function get_tax_office_details (p_organization_id in integer) return varchar2;
33 --
34 --
35 -- Function to return a value from a user table i.e. a user column instance.
36 --
37 FUNCTION get_uci
38 (p_effective_date DATE
39 ,p_user_table_id NUMBER
40 ,p_user_row_id NUMBER
41 ,p_user_column_name VARCHAR2) RETURN VARCHAR2;
42
43
44 -- Retrieve Provider names
45 function get_org_name (p_org_id in number) return varchar2;
46
47 -- Get the max effective_start_date for a given element entry id. This date is shown
48 -- on the tax Information screen.
49 function max_tax_info_date (p_element_entry_id in varchar2) return date;
50
51 --Retrieve end reason no for DE PS
52 function get_end_reason_no(p_end_reason_id in number) return number;
53 --
54 --retrieve the end reason text for DE PS
55 function get_end_reason_desc(p_end_reason_id in number) return varchar2;
56
57 END hr_de_general;