1 PACKAGE pay_nl_eoy_pkg AUTHID CURRENT_USER AS
2 /* $Header: pynleoy.pkh 120.1 2006/07/07 12:31:18 grchandr noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Function: GET_PREV_YEAR_TAX_INCOME
6 -- Function which returns the previous year taxable income for a person as
7 --on effective date
8 ---------------------------------------------------------------------------
9
10 function GET_PREV_YEAR_TAX_INCOME(p_assignment_id NUMBER
11 ,p_effective_date DATE
12 ,p_payroll_action_id NUMBER) RETURN NUMBER;
13
14 function GET_PREV_YEAR_TAX_INCOME(p_assignment_id NUMBER
15 ,p_effective_date DATE) RETURN NUMBER;
16 ---------------------------------------------------------------------------
17 -- Procedure: get_balance_values
18 -- Procedure which returns the balance values of a assignment for a given date
19 ---------------------------------------------------------------------------
20
21 Procedure get_balance_values( l_assignment_id IN NUMBER
22 ,l_prev_year_end_date IN DATE
23 ,l_period_end_date IN DATE
24 ,l_std_tax_income OUT NOCOPY NUMBER
25 ,l_spl_tax_income OUT NOCOPY NUMBER
26 ,l_retrostd_tax_income OUT NOCOPY NUMBER
27 ,l_retrostdcurrq_tax_income OUT NOCOPY NUMBER
28 ,l_retrospl_tax_income OUT NOCOPY NUMBER
29 ,l_hol_allow_pay_income OUT NOCOPY NUMBER
30 ,l_hol_allow_tax_income OUT NOCOPY NUMBER
31 ,l_retrohol_allow_tax_income OUT NOCOPY NUMBER
32 ,l_std_tax_income_ptd OUT NOCOPY NUMBER
33 ,l_spl_tax_income_ptd OUT NOCOPY NUMBER
34 ,l_retrostd_tax_income_ptd OUT NOCOPY NUMBER
35 ,l_retrostdcurrq_tax_income_ptd OUT NOCOPY NUMBER
36 ,l_retrospl_tax_income_ptd OUT NOCOPY NUMBER
37 ,l_hol_allow_pay_income_ptd OUT NOCOPY NUMBER
38 ,l_hol_allow_tax_income_ptd OUT NOCOPY NUMBER
39 ,l_rethol_allow_tax_income_ptd OUT NOCOPY NUMBER);
40
41 ---------------------------------------------------------------------------
42 -- Procedure: reset_override_lastyr_sal
43 -- Procedure which resets the override value of all the assignments at the
44 --end of the year
45 ---------------------------------------------------------------------------
46
47 PROCEDURE reset_override_lastyr_sal(errbuf out nocopy varchar2,
48 retcode out nocopy varchar2,
49 p_date in varchar2,
50 p_org_struct_id in number,
51 p_hr_org_id in number,
52 p_business_group_id in number
53 );
54
55 ---------------------------------------------------------------------------
56 -- Procedure: end_of_year_process
57 -- Generic Procedure for end of the year process
58 ---------------------------------------------------------------------------
59
60 PROCEDURE end_of_year_process (errbuf out nocopy varchar2,
61 retcode out nocopy varchar2,
62 p_date in varchar2,
63 p_org_struct_id in number,
64 p_hr_org_id in number,
65 p_business_group_id in number
66 );
67
68 ---------------------------------------------------------------------------
69 -- Procedure: update_assignments
70 --Procedure which does the datetrack update of all the assignments of a
71 --person with override value
72 ---------------------------------------------------------------------------
73
74 Procedure update_assignments (p_assignment_id IN NUMBER
75 ,p_person_id IN NUMBER
76 ,p_effective_date IN DATE
77 ,p_override_value IN NUMBER
78 ,p_dt_update_mode IN VARCHAR2);
79
80 END pay_nl_eoy_pkg;