1 PACKAGE pay_mx_ff_udfs AS
2 /* $Header: pymxudfs.pkh 120.2.12010000.1 2008/07/27 23:10:38 appldev ship $ */
3
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
8 * Chertsey, England. *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation UK Ltd, *
19 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
20 * England. *
21 * *
22 ******************************************************************
23
24 Change List
25 -----------
26 Date Name Vers Bug No Description
27 ----------- ---------- ----- ------- -----------------------------------
28 16-AUG-2001 vpandya 115.0 Created.
29 28-Nov-2004 vpandya 115.1 Changed pkg name to pay_mx_ff..
30 from hr_mx_ff_udfs.
31 30-Nov-2004 vmehta 115.2 Added get_idw function
32 06-Dec-2005 vpandya 115.3 Added following functions:
33 - get_base_pay
34 - get_mx_historic_rate
35 */
36 --
37 --
38 FUNCTION standard_hours_worked(
39 p_std_hrs in NUMBER,
40 p_range_start in DATE,
41 p_range_end in DATE,
42 p_std_freq in VARCHAR2)
43 RETURN NUMBER;
44 --
45 FUNCTION Convert_Period_Type(
46 p_bus_grp_id in NUMBER,
47 p_payroll_id in NUMBER,
48 p_tax_unit_id in NUMBER,
49 p_asst_work_schedule in VARCHAR2,
50 p_asst_std_hours in NUMBER,
51 p_figure in NUMBER,
52 p_from_freq in VARCHAR2,
53 p_to_freq in VARCHAR2,
54 p_period_start_date in DATE,
55 p_period_end_date in DATE,
56 p_asst_std_freq in VARCHAR2 )
57 RETURN NUMBER;
58 --
59 FUNCTION Work_Sch_Total_Hours_or_Days(
60 p_bg_id in NUMBER
61 ,p_ws_name in VARCHAR2
62 ,p_range_start in DATE
63 ,p_range_end in DATE
64 ,p_mode in VARCHAR2)
65 RETURN NUMBER;
66
67
68 FUNCTION Work_Sch_Total_Hours_or_Days( p_bg_id in NUMBER,
69 p_ws_name in VARCHAR2,
70 p_range_start in DATE,
71 p_range_end in DATE)
72 RETURN NUMBER;
73
74 FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
75 p_tax_unit_id hr_organization_units.organization_id%TYPE,
76 p_effective_date DATE,
77 p_mode VARCHAR2,
78 p_fixed_idw OUT NOCOPY NUMBER,
79 p_variable_idw OUT NOCOPY NUMBER)
80 RETURN NUMBER;
81
82 FUNCTION get_mx_historic_rate (
83 p_business_group_id NUMBER
84 ,p_assignment_id NUMBER
85 ,p_tax_unit_id NUMBER
86 ,p_payroll_id NUMBER
87 ,p_effective_date DATE
88 ,p_rate_code VARCHAR2)
89 RETURN NUMBER;
90
91 FUNCTION get_daily_base_pay (
92 p_business_group_id NUMBER
93 ,p_assignment_id NUMBER
94 ,p_tax_unit_id NUMBER
95 ,p_payroll_id NUMBER
96 ,p_effective_date DATE )
97 RETURN NUMBER;
98
99 FUNCTION get_base_pay_for_tax_calc (
100 p_business_group_id NUMBER
101 ,p_assignment_id NUMBER
102 ,p_tax_unit_id NUMBER
103 ,p_payroll_id NUMBER
104 ,p_effective_date DATE
105 ,p_month_or_pay_period VARCHAR2)
106 RETURN NUMBER;
107
108 --
109 --
110 END pay_mx_ff_udfs;