1 package pynzexc AUTHID CURRENT_USER as
2 /* $Header: pynzexc.pkh 115.1 2002/12/03 05:02:22 srrajago ship $ */
3 --
4 -- Change List
5 -- ----------
6 -- DATE Name Vers Bug No Description
7 -- -----------+---------------+--------+--------+-----------------------+
8 -- 13-Aug-1999 sclarke 1.0 Created
9 -- 03-Dec-2002 srrajago 1.1 2689221 Included 'nocopy' option for the 'out'
10 -- parameters of all the procedures,dbdrv
11 -- and checkfile commands.
12 -- -----------+---------------+--------+--------+-----------------------+
13 --
14 -------------------------------- asg_ptd_ec ---------------------------------
15 /*
16 * name
17 * asg_ptd_ec - assignment processing period to date expiry check.
18 * description
19 * expiry checking code for the following:
20 * nz assignment-level process period to date balance dimension
21 * notes
22 * the associtated dimension is expiry checked at assignment action level
23 */
24 --
25 procedure asg_ptd_ec( p_owner_payroll_action_id in number -- run created balance.
26 , p_user_payroll_action_id in number -- current run.
27 , p_owner_assignment_action_id in number -- assact created balance.
28 , p_user_assignment_action_id in number -- current assact..
29 , p_owner_effective_date in date -- eff date of balance.
30 , p_user_effective_date in date -- eff date of current run.
31 , p_dimension_name in varchar2 -- balance dimension name.
32 , p_expiry_information out nocopy number -- dimension expired flag.
33 ) ;
34 --
35 -------------------------------- asg_span_ec -----------------------------------------
36 /*
37 *
38 * name
39 * asg_span_ec - assignment processing span to date expiry check.
40 * description
41 * expiry checking code for the following:
42 * nz assignment-level process year to date balance dimension
43 * nz assignment-level process fiscal year to date balance dimension
44 * nz assignment-level process fiscal quarter to date balance dimension
45 * nz assignment-level process holiday year to date balance dimension
46 * notes
47 * the associated dimension is expiry checked at assignment action level
48 */
49 --
50 procedure asg_span_ec ( p_owner_payroll_action_id in number -- run created balance.
51 , p_user_payroll_action_id in number -- current run.
52 , p_owner_assignment_action_id in number -- assact created balance.
53 , p_user_assignment_action_id in number -- current assact.
54 , p_owner_effective_date in date -- eff date of balance.
55 , p_user_effective_date in date -- eff date of current run.
56 , p_dimension_name in varchar2 -- balance dimension name.
57 , p_expiry_information out nocopy number -- dimension expired flag.
58 ) ;
59 --
60 end pynzexc;