1 package pay_nz_exc as
2 /* $Header: pynzexc.pkh 120.2.12010000.1 2008/07/27 23:17:06 appldev 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 -- 22-Jul-2003 puchil 1.2 3004603 Added overloaded function to populate
13 -- latest balances for balance adjustment
14 -- correctly
15 -- 05-Aug-2003 puchil 1.3 3062941 Changed the package name from pynzexc
16 -- to pay_nz_exc
17 -- 10-Aug-2004 sshankar 1.4 3181581 Removed function ASG_PTD_EC, expiry
18 -- checking code for _ASG_PTD.
19 -- 16-Nov-2004 snekkala 1.5 3828575 Added Start Date Code Procedures
20 -- 23-Nov-2004 snekkala 1.6 3828575 Modified as per review comments
21 -- 12-Apr-2007 dduvvuri 1.7 5846247 Added procedure start_code_11mths_prev
22 -- for KiwiSaver Stat Requirement for NZ
23 -- from 1st July 2007
24 -- 27-Apr-2007 dduvvuri 1.8 5846247 Changed Tab characters to spaces.
25 -- -----------+---------------+--------+--------+-----------------------+
26 --
27 -------------------------------- asg_span_ec -----------------------------------------
28 /*
29 *
30 * name
31 * asg_span_ec - assignment processing span to date expiry check.
32 * description
33 * expiry checking code for the following:
34 * nz assignment-level process year to date balance dimension
35 * nz assignment-level process fiscal year to date balance dimension
36 * nz assignment-level process fiscal quarter to date balance dimension
37 * nz assignment-level process holiday year to date balance dimension
38 * notes
39 * the associated dimension is expiry checked at assignment action level
40 */
41 --
42 procedure asg_span_ec ( p_owner_payroll_action_id in number -- run created balance.
43 , p_user_payroll_action_id in number -- current run.
44 , p_owner_assignment_action_id in number -- assact created balance.
45 , p_user_assignment_action_id in number -- current assact.
46 , p_owner_effective_date in date -- eff date of balance.
47 , p_user_effective_date in date -- eff date of current run.
48 , p_dimension_name in varchar2 -- balance dimension name.
49 , p_expiry_information out nocopy number -- dimension expired flag.
50 ) ;
51 --
52 ---------------------------- Overloaded asg_span_ec ------------------------------------
53 /*
54 *
55 * name
56 * asg_span_ec - assignment processing span to date expiry check.
57 * description
58 * Overloaded expiry checking code for the following:
59 * nz assignment-level process year to date balance dimension
60 * nz assignment-level process fiscal year to date balance dimension
61 * nz assignment-level process fiscal quarter to date balance dimension
62 * nz assignment-level process holiday year to date balance dimension
63 * notes
64 * the associated dimension is expiry checked at assignment action level
65 */
66 --
67 procedure asg_span_ec ( p_owner_payroll_action_id in number -- run created balance.
68 , p_user_payroll_action_id in number -- current run.
69 , p_owner_assignment_action_id in number -- assact created balance.
70 , p_user_assignment_action_id in number -- current assact.
71 , p_owner_effective_date in date -- eff date of balance.
72 , p_user_effective_date in date -- eff date of current run.
73 , p_dimension_name in varchar2 -- balance dimension name.
74 , p_expiry_information out nocopy date -- dimension expired flag.
75 ) ;
76 --
77 PROCEDURE start_code_4week( p_effective_date IN DATE
78 , p_start_date OUT NOCOPY DATE
79 , p_payroll_id IN NUMBER
80 , p_bus_grp IN NUMBER
81 , p_asg_action IN NUMBER
82 );
83
84
85 PROCEDURE start_code_4weeks_prev( p_effective_date IN DATE
86 , p_start_date OUT NOCOPY DATE
87 , p_payroll_id IN NUMBER
88 , p_bus_grp IN NUMBER
89 , p_asg_action IN NUMBER
90 );
91
92 PROCEDURE start_code_hol_ytd( p_effective_date IN DATE
93 , p_start_date OUT NOCOPY DATE
94 , p_payroll_id IN NUMBER
95 , p_bus_grp IN NUMBER
96 , p_asg_action IN NUMBER
97 );
98
99 PROCEDURE start_code_12mths_prev( p_effective_date IN DATE
100 , p_start_date OUT NOCOPY DATE
101 , p_payroll_id IN NUMBER
102 , p_bus_grp IN NUMBER
103 , p_asg_action IN NUMBER
104 );
105 /* Changes for Bug 5846247 start*/
106 PROCEDURE start_code_11mths_prev( p_effective_date IN DATE
107 , p_start_date OUT NOCOPY DATE
108 , p_payroll_id IN NUMBER
109 , p_bus_grp IN NUMBER
110 , p_asg_action IN NUMBER
111 );
112 end pay_nz_exc;
113 /* Changes for Bug 5846247 end*/
114