1 PACKAGE pay_ca_payroll_utils AS
2 /* $Header: pycautil.pkh 120.1 2006/09/13 11:41:23 ssmukher noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_ca_payroll_utils
21
22 Description : The package has common functions used in
23 CA Payroll.
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ------ ------- --------------------------
29 24-JUN-2003 ssouresr 115.0 Created.
30 13-Sep-2006 ssmukher 115.1 Added a new procedure to delete
31 data from pay_file_details,
32 pay_payroll_actions and assginment actions.
33 *****************************************************************************/
34
35
36 /*****************************************************************************
37 Name : check_balance_status
38 Purpose : Function should be used to identify whether the balances relevant
39 to partcular attribute are valid for use of BRA.
40 Arguments : 1. Start Date
41 2. Business Group Id
42 3. Atttribute Name
43 Return : 'Y' for valid status and 'N' for invalid status of balance
44 Notes : It will used by Canadian Reports to find
45 if all the balances related to a report are valid or not
46 *****************************************************************************/
47
48 FUNCTION check_balance_status(
49 p_start_date in date,
50 p_business_group_id in hr_organization_units.organization_id%type,
51 p_attribute_name in varchar2)
52 RETURN VARCHAR2;
53
54 PROCEDURE delete_actionid(p_payroll_action_id IN NUMBER);
55
56 end pay_ca_payroll_utils;