[Home] [Help]
PACKAGE: APPS.PAY_PL_UTILITY
Source
1 PACKAGE pay_pl_utility AS
2 /* $Header: pyplutil.pkh 120.0 2005/10/14 04:04:24 mseshadr noship $ */
3 FUNCTION pay_pl_nip_format(p_nip IN NUMBER
4 ) RETURN VARCHAR2;
5 --
6
7
8 function pl_get_sii_details(
9 p_assignment_id number,
10 p_date_earned date ,
11 p_payroll_id number,
12 p_active_term_flag out nocopy varchar2,
13 p_sii_code out nocopy varchar2,
14 p_old_age_contrib out nocopy varchar2,
15 p_pension_contrib out nocopy varchar2,
16 p_sickness_contrib out nocopy varchar2,
17 p_work_injury_contrib out nocopy varchar2,
18 p_labor_contrib out nocopy varchar2,
19 p_unemployment_contrib out nocopy varchar2,
20 p_health_contrib out nocopy varchar2,
21 p_term_sii_code out nocopy varchar2,
22 p_term_old_age_contrib out nocopy varchar2,
23 p_term_pension_contrib out nocopy varchar2,
24 p_term_sickness_contrib out nocopy varchar2,
25 p_term_work_injury_contrib out nocopy varchar2,
26 p_term_labor_contrib out nocopy varchar2,
27 p_term_unemployment_contrib out nocopy varchar2,
28 p_term_health_contrib out nocopy varchar2
29 ) return number;
30
31 FUNCTION GET_RATE_OF_TAX(p_date_earned IN DATE,
32 p_taxable_base IN NUMBER,
33 p_rate_of_tax IN VARCHAR2,
34 p_spouse_or_child_flag IN VARCHAR2,
35 p_tax_percentage OUT NOCOPY NUMBER) RETURN NUMBER;
36
37 Function pl_get_tax_details(
38 p_assignment_id number,
39 p_date_earned date ,
40 p_payroll_id number,
41 p_sii_code out nocopy varchar2,
42 p_spouse_or_child_flag out nocopy varchar2,
43 p_income_reduction out nocopy varchar2,
44 p_tax_reduction out nocopy varchar2,
45 p_income_reduction_amount out nocopy NUMBER,
46 p_rate_of_tax out nocopy varchar2,
47 p_contract_category out nocopy varchar2,
48 p_contract_type out nocopy varchar2,
49 p_ir_flag out nocopy varchar2
50 ) return number;
51
52 END pay_pl_utility;