1 package pay_mx_soe_ss_pkg as
2 /* $Header: paymxsoe.pkh 120.0 2005/05/29 02:40:14 appldev noship $ */
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 */
43 --
44
45 FUNCTION employee_earnings( p_assignment_action_id in NUMBER )
46 RETURN LONG;
47
48 FUNCTION employee_taxes( p_assignment_action_id in NUMBER )
49 RETURN LONG;
50
51 FUNCTION tax_calc_details( p_assignment_action_id in NUMBER )
52 RETURN LONG;
53
54 FUNCTION summary_balances( p_assignment_action_id in NUMBER )
55 RETURN LONG;
56
57 TYPE summ_bal IS RECORD ( bal_name varchar2(240),
58 reporting_name varchar2(240),
59 curr_def_bal_id number(15),
60 ytd_def_bal_id number(15),
61 curr_val varchar2(15),
62 ytd_val varchar2(15));
63
64 TYPE summary_bal IS TABLE OF summ_bal INDEX BY BINARY_INTEGER;
65
66 FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )
67 RETURN LONG;
68
69 FUNCTION taxable_benefits( p_assignment_action_id in NUMBER )
70 RETURN LONG;
71
72 FUNCTION tax_balances( p_assignment_action_id in NUMBER )
73 RETURN LONG;
74
75 FUNCTION deductions( p_assignment_action_id in NUMBER )
76 RETURN LONG;
77
78 FUNCTION other_balances( p_assignment_action_id in NUMBER )
79 RETURN LONG;
80
81 FUNCTION setParameters(p_assignment_action_id number)
82 RETURN VARCHAR2;
83
84 FUNCTION setParameters( p_person_id in number
85 , p_assignment_id number
86 , p_effective_date date)
87 RETURN VARCHAR2;
88
89 g_currency_code varchar2(10);
90
91 END pay_mx_soe_ss_pkg;
[Home] [Help]