1 PACKAGE PAY_DK_GENERAL AS
2 /* $Header: pydkgenr.pkh 120.2.12000000.2 2007/05/07 11:52:03 saurai noship $ */
3
4 --
5 FUNCTION get_tax_card_details
6 (p_assignment_id IN NUMBER
7 ,p_effective_date IN DATE
8 ,p_tax_card_type OUT NOCOPY VARCHAR2
9 ,p_tax_percentage OUT NOCOPY NUMBER
10 ,p_tax_free_threshold OUT NOCOPY NUMBER
11 ,p_monthly_tax_deduction OUT NOCOPY NUMBER
12 ,p_bi_weekly_tax_deduction OUT NOCOPY NUMBER
13 ,p_weekly_tax_deduction OUT NOCOPY NUMBER
14 ,p_daily_tax_deduction OUT NOCOPY NUMBER) RETURN NUMBER;
15 --
16
17 FUNCTION get_tax_details
18 (p_assignment_id IN NUMBER
19 ,p_effective_date IN DATE
20 ,p_effective_start_date OUT NOCOPY DATE
21 ,p_effective_end_date OUT NOCOPY DATE
22 ) RETURN NUMBER;
23
24 --
25
26 FUNCTION get_le_employment_details
27 (p_org_id IN VARCHAR2
28 ,p_le_work_hours OUT NOCOPY NUMBER
29 ,p_freq OUT NOCOPY VARCHAR2
30 )RETURN NUMBER;
31
32 --
33
34 FUNCTION get_atp_details
35 (p_assignment_id IN NUMBER
36 ,p_effective_date IN DATE
37 ,p_effective_start_date OUT NOCOPY DATE
38 ,p_effective_end_date OUT NOCOPY DATE
39 ) RETURN NUMBER;
40
41
42 --
43
44 FUNCTION get_sp_details
45 (p_payroll_action_id IN NUMBER
46 ,p_cvr_number OUT NOCOPY VARCHAR2
47 ) RETURN NUMBER;
48
49
50 FUNCTION get_atp_override_hours
51 (p_assignment_id IN NUMBER
52 ,p_effective_date IN DATE
53 ) RETURN NUMBER;
54
55 FUNCTION get_holiday_details
56 (p_assignment_id IN NUMBER
57 ,p_effective_date IN DATE
58 ,p_abs_start_date IN DATE
59 ,p_abs_end_date IN DATE
60 ,p_start_date OUT NOCOPY DATE
61 ,p_end_date OUT NOCOPY DATE
62 ,p_over_days OUT NOCOPY NUMBER
63 ,p_over_hours OUT NOCOPY NUMBER
64 ) RETURN NUMBER;
65
66 FUNCTION get_IANA_charset RETURN VARCHAR2;
67
68 FUNCTION get_hour_sal_flag
69 (p_assignment_id IN NUMBER
70 ,p_effective_date IN DATE
71 ) RETURN VARCHAR2;
72
73 END PAY_DK_GENERAL;