1 PACKAGE pay_mx_ff_udfs AUTHID CURRENT_USER AS
2 /* $Header: pymxudfs.pkh 120.5.12020000.2 2012/07/05 01:26:04 amnaraya 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 30-Jul-2009 sjawid 115.4 Added new overloaded function get_idw
36 with context p_payroll_action_id,
37 and new parameter p_execute_old_idw_code.
38
39 11-May-2011 sjawid 115.7 Added new function get_tax_balance.
40 */
41 --
42 --
43 FUNCTION standard_hours_worked(
44 p_std_hrs in NUMBER,
45 p_range_start in DATE,
46 p_range_end in DATE,
47 p_std_freq in VARCHAR2)
48 RETURN NUMBER;
49 --
50 FUNCTION Convert_Period_Type(
51 p_bus_grp_id in NUMBER,
52 p_payroll_id in NUMBER,
53 p_tax_unit_id in NUMBER,
54 p_asst_work_schedule in VARCHAR2,
55 p_asst_std_hours in NUMBER,
56 p_figure in NUMBER,
57 p_from_freq in VARCHAR2,
58 p_to_freq in VARCHAR2,
59 p_period_start_date in DATE,
60 p_period_end_date in DATE,
61 p_asst_std_freq in VARCHAR2 )
62 RETURN NUMBER;
63 --
64 FUNCTION Work_Sch_Total_Hours_or_Days(
65 p_bg_id in NUMBER
66 ,p_ws_name in VARCHAR2
67 ,p_range_start in DATE
68 ,p_range_end in DATE
69 ,p_mode in VARCHAR2)
70 RETURN NUMBER;
71
72
73 FUNCTION Work_Sch_Total_Hours_or_Days( p_bg_id in NUMBER,
74 p_ws_name in VARCHAR2,
75 p_range_start in DATE,
76 p_range_end in DATE)
77 RETURN NUMBER;
78
79 FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
80 p_tax_unit_id hr_organization_units.organization_id%TYPE,
81 p_effective_date DATE,
82 p_mode VARCHAR2,
83 p_fixed_idw OUT NOCOPY NUMBER,
84 p_variable_idw OUT NOCOPY NUMBER)
85 RETURN NUMBER;
86
87
88 FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
89 p_tax_unit_id hr_organization_units.organization_id%TYPE,
90 p_effective_date DATE,
91 p_payroll_action_id NUMBER,
92 p_mode VARCHAR2,
93 p_fixed_idw OUT NOCOPY NUMBER,
94 p_variable_idw OUT NOCOPY NUMBER,
95 p_execute_old_idw_code VARCHAR2)
96 RETURN NUMBER;
97
98 FUNCTION get_date_paid(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
99 RETURN DATE;
100
101 FUNCTION get_mx_historic_rate (
102 p_business_group_id NUMBER
103 ,p_assignment_id NUMBER
104 ,p_tax_unit_id NUMBER
105 ,p_payroll_id NUMBER
106 ,p_effective_date DATE
107 ,p_rate_code VARCHAR2)
108 RETURN NUMBER;
109
110 FUNCTION get_daily_base_pay (
111 p_business_group_id NUMBER
112 ,p_assignment_id NUMBER
113 ,p_tax_unit_id NUMBER
114 ,p_payroll_id NUMBER
115 ,p_effective_date DATE )
116 RETURN NUMBER;
117
118 FUNCTION get_base_pay_for_tax_calc (
119 p_business_group_id NUMBER
120 ,p_assignment_id NUMBER
121 ,p_tax_unit_id NUMBER
122 ,p_payroll_id NUMBER
123 ,p_effective_date DATE
124 ,p_month_or_pay_period VARCHAR2)
125 RETURN NUMBER;
126
127
128 /*bug:14055388*/
129 FUNCTION GET_TAX_BALANCE(
130 p_assignment_action_id number,
131 p_tax_unit_id hr_organization_units.organization_id%TYPE,
132 p_effective_date DATE,
133 p_payroll_action_id NUMBER,
134 p_business_group_id NUMBER,
135 p_entity_name varchar2)
136 RETURN NUMBER;
137 --
138 --
139 END pay_mx_ff_udfs;
[Home] [Help]