1 PACKAGE PAY_DK_HOLIDAY_PAY_PKG AUTHID CURRENT_USER AS
2 /* $Header: pydkholp.pkh 120.8 2012/01/19 09:03:32 rpahune ship $ */
3
4 /* Bug Fix 4961994 , Added Record variable */
5 TYPE l_type IS RECORD (date1 date, date2 date, value varchar2(5));
6 TYPE l_rec IS VARRAY(20) OF l_type;
7
8 FUNCTION get_allowance_perc(p_payroll_id NUMBER
9 ,p_date_earned DATE ) RETURN NUMBER;
10
11
12 FUNCTION get_prev_bal(p_assignment_id NUMBER
13 , p_balance_name VARCHAR2
14 , p_balance_dim VARCHAR2
15 , p_virtual_date DATE) RETURN NUMBER ;
16
17 /* Bug Fix 4950983 Added parameter p_work_pattern to function get_le_holiday_details */
18 FUNCTION get_le_holiday_details
19 (p_org_id IN NUMBER,
20 p_sal_accrual_rate OUT NOCOPY NUMBER,
21 p_hourly_accrual_rate OUT NOCOPY NUMBER,
22 p_use_holiday_card OUT NOCOPY VARCHAR2,
23 p_work_pattern OUT NOCOPY VARCHAR2,
24 p_hol_all_reduction OUT NOCOPY VARCHAR2) RETURN NUMBER;
25
26 FUNCTION get_le_employment_details
27 (p_org_id IN NUMBER
28 ,p_le_work_hours OUT NOCOPY NUMBER
29 ,p_freq OUT NOCOPY VARCHAR2)RETURN NUMBER;
30
31 /* Bug Fix 4961994 , Added function get_eligible_days */
32 FUNCTION get_eligible_days(p_assignment_id IN NUMBER
33 ,p_org_id IN NUMBER
34 ,p_period_start_date IN DATE
35 ,p_period_end_date IN DATE
36 ,p_5days OUT NOCOPY NUMBER
37 ,p_6days OUT NOCOPY NUMBER) RETURN NUMBER;
38
39 /* Bug Fix 4947637 , Added function get_weekdays */
40 FUNCTION get_weekdays(p_period_start_date IN DATE
41 ,p_period_end_date IN DATE
42 ,p_work_pattern IN VARCHAR) RETURN NUMBER;
43
44 /* Bug Fix 5185910, Added function get_day_of_week */
45 FUNCTION get_day_of_week(p_date DATE) RETURN NUMBER;
46
47 /* Added for Public Holiday Pay */
48 FUNCTION get_pub_hol_pay_details(p_assignment_id IN NUMBER
49 ,p_organization_id IN NUMBER
50 ,p_effective_date IN DATE
51 ,p_sh_payment_rate OUT NOCOPY NUMBER) RETURN NUMBER;
52
53 /*9495504 - To get number of maximum carry over days - abraghun*/
54 /* 9578958 Added parameter p_carryover_limit */
55 FUNCTION get_max_carryover_days(p_assignment_id IN NUMBER
56 ,p_organization_id IN NUMBER
57 ,p_effective_date IN DATE
58 ,p_carryover_limit IN NUMBER) RETURN NUMBER;
59
60 /* 10092419 start */
61 FUNCTION get_hol_Unpaid_details
62
63 (p_org_id IN NUMBER,
64 p_unpaid_def_Y_N OUT NOCOPY VARCHAR2,
65 p_def_5day_days OUT NOCOPY NUMBER,
66 p_def_6day_days OUT NOCOPY NUMBER
67 ) RETURN NUMBER;
68 /* 10092419 end */
69 END PAY_DK_HOLIDAY_PAY_PKG;
70