DBA Data[Home] [Help]

PACKAGE: APPS.PAY_PAYSLIP_UTIL

Source


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;