1 package pay_mx_soe_ss_pkg AUTHID CURRENT_USER as
2 /* $Header: paymxsoe.pkh 120.2 2012/01/19 08:11:06 rpahune ship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, in *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Description: This package is used to show SS SOE for Mexico.
26
27 Change List
28 -----------
29 Date Name Vers Bug No Description
30 ----------- ---------- ----- ------- -----------------------------------
31 11-AUG-2004 vpandya 115.0 Created.
32 06-Jan-2005 vpandya 115.1 Added following functions:
33 - summary_balances
34 - hourly_earnings
35 - tax_balances
36 - deductions
37 - taxable_benefits
38 - other_balances
39 26-Jan-2005 vmehta 115.2 4145267 Changed curr_val and ytd_val
40 in summ_bal to varchar2(15)
41 08-Feb-2005 vpandya 115.3 4145833 Added function setParameters
42 17-Nov-2011 emunisek 115.4 13375560 Replaced Long Datatype by CLOB
43 */
44 --
45
46 FUNCTION employee_earnings( p_assignment_action_id in NUMBER )
47 RETURN CLOB;
48
49 FUNCTION employee_taxes( p_assignment_action_id in NUMBER )
50 RETURN CLOB;
51
52 FUNCTION tax_calc_details( p_assignment_action_id in NUMBER )
53 RETURN CLOB;
54
55 FUNCTION summary_balances( p_assignment_action_id in NUMBER )
56 RETURN CLOB;
57
58 TYPE summ_bal IS RECORD ( bal_name varchar2(240),
59 reporting_name varchar2(240),
60 curr_def_bal_id number(15),
61 ytd_def_bal_id number(15),
62 curr_val varchar2(15),
63 ytd_val varchar2(15));
64
65 TYPE summary_bal IS TABLE OF summ_bal INDEX BY BINARY_INTEGER;
66
67 FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )
68 RETURN CLOB;
69
70 FUNCTION taxable_benefits( p_assignment_action_id in NUMBER )
71 RETURN CLOB;
72
73 FUNCTION tax_balances( p_assignment_action_id in NUMBER )
74 RETURN CLOB;
75
76 FUNCTION deductions( p_assignment_action_id in NUMBER )
77 RETURN CLOB;
78
79 FUNCTION other_balances( p_assignment_action_id in NUMBER )
80 RETURN CLOB;
81
82 FUNCTION setParameters(p_assignment_action_id number)
83 RETURN VARCHAR2;
84
85 FUNCTION setParameters( p_person_id in number
86 , p_assignment_id number
87 , p_effective_date date)
88 RETURN VARCHAR2;
89
90 g_currency_code varchar2(10);
91
92 END pay_mx_soe_ss_pkg;