1 PACKAGE PAY_CORE_FF_UDFS AUTHID CURRENT_USER as
2 /* $Header: paycoreffudfs.pkh 120.3 2008/01/08 09:08:59 sudedas noship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1994 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9
10 Name : pay_core_ff_udfs
11 Filename : paycoreffudfs.sql
12 Change List
13 -----------
14 Date Name Vers Bug No Description
15 ---- ---- ---- ------ -----------
16 01-May-2005 sodhingr 115.0 Defines user defined function
17 used by international payroll
18 14-JUN-2005 sodhingr 115.1 Added the function
19 get_hourly_rate that returns
20 the hourly rate based on Salary
21 Basis.also added the function
22 calculate_actual_hours_worked
23 that calculates the hours
24 worked based on ATG/
25 workschedule/Std hrs
26 16-JUN-2005 pganguly 115.2 Fixed the GSCC issue.
27 07-OCT-2005 sodhingr 115.3 removed convert_period_type and added
28 p_days_or_hours to calculate_actual_hours_worked
29
30 07-FEB-2005 sodhingr 115.4 added convert_period_type and calculate_period_earnings
31 that can be used by the localization team and take care
32 of proration if core proration is not enabled.
33 08-Jan-2008 sudedas 115.4 6718164 Added new Function term_skip_rule_rwage
34 */
35
36
37 FUNCTION get_hourly_rate(
38 p_bg IN NUMBER -- context
39 ,p_assignment_id IN NUMBER -- context
40 ,p_payroll_id IN NUMBER -- context
41 ,p_element_entry_id IN NUMBER -- context
42 ,p_date_earned IN DATE -- context
43 ,p_assignment_action_id IN NUMBER)
44 RETURN NUMBER ;
45
46 FUNCTION calculate_actual_hours_worked
47 (assignment_action_id IN number --Context
48 ,assignment_id IN number --Context
49 ,business_group_id IN number --Context
50 ,element_entry_id IN number --Context
51 ,date_earned IN date --Context
52 ,p_period_start_date IN date
53 ,p_period_end_date IN date
54 ,p_schedule_category IN varchar2 default 'WORK'-- 'WORK'/'PAGER'
55 ,p_include_exceptions IN varchar2 default ''
56 ,p_busy_tentative_as IN varchar2 default 'FREE'-- 'BUSY'/FREE/NULL
57 ,p_legislation_code IN varchar2 default ''
58 ,p_schedule_source IN OUT nocopy varchar2 -- 'PER_ASG' for asg
59 ,p_schedule IN OUT nocopy varchar2 -- schedule
60 ,p_return_status OUT nocopy number
61 ,p_return_message OUT nocopy varchar2
62 ,p_days_or_hours IN VARCHAR2 default 'H' -- 'D' for days, 'H' for hours
63 )
64 RETURN NUMBER;
65
66 FUNCTION standard_hours_worked(
67 p_std_hrs in NUMBER,
68 p_range_start in DATE,
69 p_range_end in DATE,
70 p_std_freq in VARCHAR2) RETURN NUMBER;
71
72 FUNCTION Calculate_Period_Earnings (
73 p_bus_grp_id in NUMBER,
74 p_asst_id in NUMBER,
75 p_payroll_id in NUMBER,
76 p_ele_entry_id in NUMBER,
77 p_tax_unit_id in NUMBER,
78 p_date_earned in DATE,
79 p_assignment_action_id in NUMBER,
80 p_pay_basis in VARCHAR2 default NULL,
81 p_inpval_name in VARCHAR2 default NULL,
82 p_ass_hrly_figure in NUMBER,
83 p_period_start in DATE,
84 p_period_end in DATE,
85 p_actual_hours_worked in out nocopy NUMBER,
86 p_vac_hours_worked in out nocopy NUMBER,
87 p_vac_pay in out nocopy NUMBER,
88 p_sick_hours_worked in out nocopy NUMBER,
89 p_sick_pay in out nocopy NUMBER,
90 p_prorate in VARCHAR2 default 'Y',
91 p_asst_std_freq in VARCHAR2 default NULL)
92 RETURN NUMBER;
93 --
94
95 FUNCTION Convert_Period_Type(
96 p_bg in NUMBER -- context
97 ,p_assignment_id in NUMBER -- context
98 ,p_payroll_id in NUMBER -- context
99 ,p_element_entry_id in NUMBER -- context
100 ,p_date_earned in DATE -- context
101 ,p_assignment_action_id in NUMBER -- context
102 ,p_period_start_date IN DATE
103 ,p_period_end_date IN DATE
104 /*,p_schedule_category IN varchar2 --Optional
105 ,p_include_exceptions IN varchar2 --Optional
106 ,p_busy_tentative_as IN varchar2 --Optional
107 ,p_schedule_source IN varchar2
108 ,p_schedule IN varchar2*/
109 ,p_figure in NUMBER
110 ,p_from_freq in VARCHAR2
111 ,p_to_freq in VARCHAR2
112 ,p_asst_std_freq in VARCHAR2 default NULL
113 ,p_rate_calc_override in VARCHAR2 default 'NOT ENTERED')
114 RETURN NUMBER;
115 --
116 -- Added For Skip Rule for "Regular Wages" Element, "REGULAR_PAY"
117
118 FUNCTION term_skip_rule_rwage(ctx_payroll_id NUMBER
119 ,ctx_assignment_id NUMBER
120 ,ctx_date_earned DATE
121 ,p_user_entered_time VARCHAR2
122 ,p_final_pay_processed VARCHAR2
123 ,p_lspd_pay_processed VARCHAR2
124 ,p_payroll_termination_type VARCHAR2
125 ,p_bg_termination_type VARCHAR2
126 ,p_already_processed VARCHAR2)
127 RETURN VARCHAR2;
128
129 END pay_core_ff_udfs ;