1 package PAY_NL_TAX_PKG as
2 /* $Header: pynltax.pkh 120.0.12000000.1 2007/01/17 23:01:58 appldev noship $ */
3
4 FUNCTION get_age_payroll_period(p_assignment_id IN NUMBER
5 ,p_payroll_id IN NUMBER
6 ,p_date_earned IN DATE)
7 RETURN NUMBER;
8
9 FUNCTION check_age_payroll_period(p_person_id IN NUMBER
10 ,p_payroll_id IN NUMBER
11 ,p_date_earned IN DATE)
12 RETURN NUMBER;
13
14 FUNCTION get_age_calendar_year(p_assignment_id IN NUMBER
15 ,p_date_earned IN DATE)
16 RETURN NUMBER;
17
18 FUNCTION get_age_system_date(p_assignment_id IN NUMBER
19 ,p_date_earned IN DATE)
20 RETURN NUMBER;
21
22 FUNCTION chk_lbr_tx_indicator (p_person_id number,p_assignment_id number)
23 return boolean;
24
25 FUNCTION get_payroll_prd(p_payroll_id number)
26 RETURN VARCHAR2;
27
28 PROCEDURE chk_tax_code (p_tax_code in varchar2,
29 p_pay_num in number,
30 p_1_digit out nocopy varchar2,
31 p_2_digit out nocopy varchar2,
32 p_3_digit out nocopy varchar2,
33 p_valid out nocopy boolean
34 );
35 PROCEDURE get_period_type_code(p_payroll_prd in Varchar2,p_period_type out nocopy varchar2,p_period_code out nocopy number);
36
37 PROCEDURE set_spl_inds( p_spl_ind1 in varchar2
38 ,p_spl_ind2 in varchar2
39 ,p_spl_ind3 in varchar2
40 ,p_spl_ind4 in varchar2
41 ,p_spl_ind5 in varchar2
42 ,p_spl_ind6 in varchar2
43 ,p_spl_ind7 in varchar2
44 ,p_spl_ind8 in varchar2
45 ,p_spl_ind9 in varchar2
46 ,p_spl_ind10 in varchar2
47 ,p_spl_ind11 in varchar2
48 ,p_spl_ind12 in varchar2
49 ,p_spl_ind13 in varchar2
50 ,l_set out nocopy boolean
51 ,p_spl_ind out nocopy varchar2);
52
53 PROCEDURE get_spl_inds( p_spl_ind in varchar2
54 ,p_spl_ind1 out nocopy varchar2
55 ,p_spl_ind2 out nocopy varchar2
56 ,p_spl_ind3 out nocopy varchar2
57 ,p_spl_ind4 out nocopy varchar2
58 ,p_spl_ind5 out nocopy varchar2
59 ,p_spl_ind6 out nocopy varchar2
60 ,p_spl_ind7 out nocopy varchar2
61 ,p_spl_ind8 out nocopy varchar2
62 ,p_spl_ind9 out nocopy varchar2
63 ,p_spl_ind10 out nocopy varchar2
64 ,p_spl_ind11 out nocopy varchar2
65 ,p_spl_ind12 out nocopy varchar2
66 ,p_spl_ind13 out nocopy varchar2
67 );
68
69 FUNCTION get_age_hire_date(p_business_group_id IN NUMBER
70 ,p_assignment_id IN NUMBER
71 ,p_date_earned IN DATE)
72 RETURN NUMBER;
73 END PAY_NL_TAX_PKG;