1 PACKAGE PAY_DK_HOLIDAY_PAY_PKG AS
2 /* $Header: pydkholp.pkh 120.1.12000000.2 2007/05/08 07:03:55 saurai noship $ */
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) RETURN NUMBER;
24
25 FUNCTION get_le_employment_details
26 (p_org_id IN NUMBER
27 ,p_le_work_hours OUT NOCOPY NUMBER
28 ,p_freq OUT NOCOPY VARCHAR2)RETURN NUMBER;
29
30 /* Bug Fix 4961994 , Added function get_eligible_days */
31 FUNCTION get_eligible_days(p_assignment_id IN NUMBER
32 ,p_org_id IN NUMBER
33 ,p_period_start_date IN DATE
34 ,p_period_end_date IN DATE
35 ,p_5days OUT NOCOPY NUMBER
36 ,p_6days OUT NOCOPY NUMBER) RETURN NUMBER;
37
38 /* Bug Fix 4947637 , Added function get_weekdays */
39 FUNCTION get_weekdays(p_period_start_date IN DATE
40 ,p_period_end_date IN DATE
41 ,p_work_pattern IN VARCHAR) RETURN NUMBER;
42
43 /* Bug Fix 5185910, Added function get_day_of_week */
44 FUNCTION get_day_of_week(p_date DATE) RETURN NUMBER;
45
46 /* Added for Public Holiday Pay */
47 FUNCTION get_pub_hol_pay_details(p_assignment_id IN NUMBER
48 ,p_organization_id IN NUMBER
49 ,p_effective_date IN DATE
50 ,p_sh_payment_rate OUT NOCOPY NUMBER) RETURN NUMBER;
51
52
53 END PAY_DK_HOLIDAY_PAY_PKG;
54