1 PACKAGE pyusexc AS
2 /* $Header: pyusexc.pkh 120.0 2005/05/29 02:19:28 appldev 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 : pyusexc.pkb
21
22 Description : PaYroll US legislation EXpiry Checking code.
23 Contains the expiry checking code associated with the US
24 balance dimensions. Following the change
25 to latest balance functionality, these need to be contained
26 as packaged procedures.
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ----------- ---------- ------ ------- --------------------------------------
32 30-JUL-1996 J ALLOUN Added error handling.
33 12-aug-2000 d Joshi Added the date_ec overloaded function
34 for as per the requirement of balance
35 adjustment
36 14-MAR-2005 Saurgupt Make the gscc changes.
37 18-MAY-2005 ahanda 115.3 Added procedure start_tdptd_date.
38
39 */
40
41 PROCEDURE date_ec
42 (
43 p_owner_payroll_action_id in number, -- run created balance.
44 p_user_payroll_action_id in number, -- current run.
45 p_owner_assignment_action_id in number, -- assact created balance.
46 p_user_assignment_action_id in number, -- current assact..
47 p_owner_effective_date in date, -- eff date of balance.
48 p_user_effective_date in date, -- eff date of current run.
49 p_dimension_name in varchar2, -- balance dimension name.
50 p_expiry_information out nocopy number -- dimension expired flag.
51 );
52
53 PROCEDURE date_ec
54 (
55 p_owner_payroll_action_id in number, -- run created balance.
56 p_user_payroll_action_id in number, -- current run.
57 p_owner_assignment_action_id in number, -- assact created balance.
58 p_user_assignment_action_id in number, -- current assact..
59 p_owner_effective_date in date, -- eff date of balance.
60 p_user_effective_date in date, -- eff date of current run.
61 p_dimension_name in varchar2, -- balance dimension name.
62 p_expiry_information out nocopy date -- dimension expired date.
63 );
64
65
66 PROCEDURE start_tdptd_date(p_effective_date IN DATE
67 ,p_start_date OUT NOCOPY DATE
68 ,p_payroll_id IN NUMBER DEFAULT NULL
69 ,p_bus_grp IN NUMBER DEFAULT NULL
70 ,p_asg_action IN NUMBER DEFAULT NULL);
71
72 end pyusexc;