1 package pay_payslip_util AUTHID CURRENT_USER as
2 /* $Header: paypaysliputil.pkh 120.5 2010/12/08 22:57:21 tclewis 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 for all functions and procedures
26 for Online Payslip for all legislations.
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ----------- ---------- ----- ------- -----------------------------------
32 02-FEB-2004 vpandya 115.0 Created.
33 26-JUN-2006 sodhingr 115.1 5033776 added new function, get_leg_rule_state
34 31-MAR-2009 sudedas 115.2 3816988 Introduced new parameter p_effective_date
35 for function get_id_for_employer_address
36 08-DEC-2010 tclewis 115.5 9571767 Added global variables:
37 g_business_group_id
38 g_employer_type
39 g_payslip_eff_dt used in
40 get_id_for_employer_address.
41 */
42 --
43
44 FUNCTION get_legislation_code( p_business_group_id in number )
45 RETURN VARCHAR2;
46
47 FUNCTION get_id_for_employer_address( p_business_group_id in number
48 ,p_tax_unit_id in number
49 ,p_organization_id in number
50 ,p_effective_date in date default fnd_date.canonical_to_date('1990/01/01'))
51 RETURN NUMBER;
52
53 FUNCTION get_leg_rule_state( p_business_group_id in number)
54 RETURN VARCHAR2 ;
55
56 gv_legislation_code varchar2(30) := NULL;
57 gv_employer_addr_cd varchar2(30) := NULL;
58
59 g_employer_type varchar2(100):= NULL;
60 g_payslip_eff_dt date:= NULL;
61 g_business_group_id number:=null;
62
63 end pay_payslip_util;