1 package pyieexc AUTHID CURRENT_USER as
2 /* $Header: pyieexc.pkh 115.8 2004/05/27 00:25:52 rtulaban ship $ */
3 /* Copyright (c) Oracle Corporation 1994. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pyieexc.pkh - PaYroll Test IE legislation EXpiry Checking code.
9 DESCRIPTION
10 Contains the expiry checking code for the balance dimensions
11 created for IRELAND.
12 PUBLIC FUNCTIONS
13 <none>
14 PRIVATE FUNCTIONS
15 <none>
16 NOTES
17 <none>
18 MODIFIED (DD/MM/YY)
19 rmakhija 15/06/01 - first created by editing similar package of GB localization.
20 abhaduri 16/04/02 - added ASG_PROC_PTD_EC procedure for new dimension
21 _ELEMENT_PTD for Attachment of Earnings Order.
22 mmahmad 24/01/03 Added NOCOPY
23 vmkhande 16/04/03 Added expiry code for ASG_QTD
24 npershad 30/10/03 Added expiry code for ASG_TWO_YTD
25 rtulaban 26/05/04 Added start date code for ASG_TWO_YTD.
26 */
27 /*------------------------------ ASG_PTD_EC ----------------------------*/
28 /*
29 NAME
30 ASG_PTD_EC - Assignment-level Period to Date expiry check.
31 DESCRIPTION
32 Expiry checking code for the following:
33 IE Assignment-level Period To Date Balance Dimension
34 NOTES
35 The associated dimension is expiry checked at assignment action level
36 */
37 procedure ASG_PTD_EC
38 (
39 p_owner_payroll_action_id in number, -- run created balance.
40 p_user_payroll_action_id in number, -- current run.
41 p_owner_assignment_action_id in number, -- assact created balance.
42 p_user_assignment_action_id in number, -- current assact..
43 p_owner_effective_date in date, -- eff date of balance.
44 p_user_effective_date in date, -- eff date of current run.
45 p_dimension_name in varchar2, -- balance dimension name.
46 p_expiry_information out NOCOPY number -- dimension expired flag.
47 ) ;
48
49 /*------------------------------ ASG_YTD_EC -------------------------*/
50 /*
51 NAME
52 ASG_YTD_EC - Assignment Tax Year to Date expiry check
53 DESCRIPTION
54 Expiry checking code for the following:
55 IE Assignment-level Tax Year to Date dimension
56 NOTES
57 The associated dimension is expiry checked at assignment action level
58 */
59 procedure ASG_YTD_EC
60 (
61 p_owner_payroll_action_id in number, -- run created balance.
62 p_user_payroll_action_id in number, -- current run.
63 p_owner_assignment_action_id in number, -- assact created balance.
64 p_user_assignment_action_id in number, -- current assact..
65 p_owner_effective_date in date, -- eff date of balance.
66 p_user_effective_date in date, -- eff date of current run.
67 p_dimension_name in varchar2, -- balance dimension name.
68 p_expiry_information out NOCOPY number -- dimension expired flag.
69 ) ;
70
71 /*------------------------------ ASG_PROC_PTD_EC ----------------------------*/
72 /*
73 NAME
74 ASG_PROC_PTD_EC - Assignment Processing Period to Date expiry check.
75 DESCRIPTION
76 Expiry checking code for the following:
77 IE Element-level Process Period To Date Balance Dimension
78 NOTES
79 The associtated dimension is expiry checked at payroll action level
80 */
81 procedure ASG_PROC_PTD_EC
82 (
83 p_owner_payroll_action_id in number, -- run created balance.
84 p_user_payroll_action_id in number, -- current run.
85 p_owner_assignment_action_id in number, -- assact created balance.
86 p_user_assignment_action_id in number, -- current assact..
87 p_owner_effective_date in date, -- eff date of balance.
88 p_user_effective_date in date, -- eff date of current run.
89 p_dimension_name in varchar2, -- balance dimension name.
90 p_expiry_information out NOCOPY number -- dimension expired flag.
91 ) ;
92 /*------------------------------ ASG_QTD_EC ----------------------------*/
93 /*
94 NAME
95 ASG_QTD_EC - Assignment-level Quater to Date expiry check.
96 DESCRIPTION
97 Expiry checking code for the following:
98 IE Assignment-level Quater To Date Balance Dimension
99 NOTES
100 The associated dimension is expiry checked at assignment action level
101 */
102 procedure ASG_QTD_EC
103 (
104 p_owner_payroll_action_id in number, -- run created balance.
105 p_user_payroll_action_id in number, -- current run.
106 p_owner_assignment_action_id in number, -- assact created balance.
107 p_user_assignment_action_id in number, -- current assact..
108 p_owner_effective_date in date, -- eff date of balance.
109 p_user_effective_date in date, -- eff date of current run.
110 p_dimension_name in varchar2, -- balance dimension name.
111 p_expiry_information out NOCOPY number -- dimension expired flag.
112 ) ;
113 /*------------------------------ ASG_TWO_YTD_EC -------------------------*/
114 /*
115 NAME
116 ASG_YTD_EC - Assignment Previous Year/Tax Year to Date expiry check
117 DESCRIPTION
118 Expiry checking code for the following:
119 IE Assignment-level Previous Year/Tax Year to Date dimension
120 NOTES
121 The associated dimension is expiry checked at assignment action level
122 */
123 procedure ASG_TWO_YTD_EC
124 (
125 p_owner_payroll_action_id in number, -- run created balance.
126 p_user_payroll_action_id in number, -- current run.
127 p_owner_assignment_action_id in number, -- assact created balance.
128 p_user_assignment_action_id in number, -- current assact..
129 p_owner_effective_date in date, -- eff date of balance.
130 p_user_effective_date in date, -- eff date of current run.
131 p_dimension_name in varchar2, -- balance dimension name.
132 p_expiry_information out NOCOPY number -- dimension expired flag.
133 ) ;
134 -----------------------------------------------------------------------------
135 -- Procedure: PROC_TWO_YTD_START
136 -- Description: used by TWO_YTD Dimensions for Run Level Balances only.
137 -- This procedure accepts a date and assignment action and other
138 -- params, and returns the start date of the Previous Tax Year, depending
139 -- on the regular payment date of the payroll action.
140
141 procedure proc_two_ytd_start
142 (
143 p_period_type in varchar2 default null,
144 p_effective_date in date default null,
145 p_start_date out nocopy date,
146 p_start_date_code in varchar2 default null,
147 p_payroll_id in number,
148 p_bus_grp in number default null,
149 p_action_type in varchar2 default null,
150 p_asg_action in number
151 );
152
153 -----------------------------------------------------------------------------
154 end pyieexc;