1 PACKAGE PAY_DK_GENERAL AUTHID CURRENT_USER AS
2 /* $Header: pydkgenr.pkh 120.8.12020000.2 2012/09/05 05:34:16 rsahai ship $ */
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 FUNCTION GET_UTF8TOANSI
74 (p_utf8_str IN VARCHAR2
75 ) RETURN VARCHAR2;
76
77 /* 9127044 */
78 FUNCTION get_asg_start_date
79 (p_business_group_id IN NUMBER
80 ,p_assignment_id IN NUMBER)
81 RETURN DATE;
82
83 /* 9727277 */
84 FUNCTION PENSION_TO_PROCESS_FLAG
85 (p_assignment_id IN NUMBER
86 ,p_element_type_id IN NUMBER
87 ,p_effective_date IN DATE
88 ) RETURN VARCHAR2;
89
90 --14581183
91 FUNCTION get_pbs_400_flag
92 (p_payroll_action_id IN NUMBER
93 ) RETURN VARCHAR2;
94 --14581183
95
96 END PAY_DK_GENERAL;