1 package pay_bf_expc AUTHID CURRENT_USER as
2 /* $Header: paybfexc.pkh 115.0 1999/11/24 02:18:27 pkm ship $ */
3
4 /*------------------------------ pytd_ec ------------------------------------*/
5 /*
6 NAME
7 pytd_ec - Person Tax Year To Date expiry check.
8 DESCRIPTION
9 Expiry checking code for the following:
10 BF Person-level Tax Year to Date Balance Dimension
11 NOTES
12 <none>
13 */
14 procedure pytd_ec
15 (
16 p_owner_payroll_action_id in number, -- run created balance.
17 p_user_payroll_action_id in number, -- current run.
18 p_owner_assignment_action_id in number, -- assact created balance.
19 p_user_assignment_action_id in number, -- current assact..
20 p_owner_effective_date in date, -- eff date of balance.
21 p_user_effective_date in date, -- eff date of current run.
22 p_dimension_name in varchar2, -- balance dimension name.
23 p_expiry_information out number -- dimension expired flag.
24 );
25
26 /*------------------------------ aytd_ec ------------------------------------*/
27 /*
28 NAME
29 aytd_ec - Assignment Tax Year To Date expiry check.
30 DESCRIPTION
31 Expiry checking code for the following:
32 BF Assignment-level Tax Year to Date Balance Dimension
33 NOTES
34 The associtated dimension is expiry checked at
35 Payroll Action level.
36 */
37 procedure aytd_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 number -- dimension expired flag.
47 );
48
49 /*------------------------------ pptd_ec ------------------------------------*/
50 /*
51 NAME
52 pptd_ec - Person Period To Date Expiry Check.
53 DESCRIPTION
54 Expiry checking code for the following:
55 BF Person-level Period to Date Balance Dimension
56 NOTES
57 Associated dimension is expiry checked at
58 Payroll Action level.
59 */
60 procedure pptd_ec
61 (
62 p_owner_payroll_action_id in number, -- run created balance.
63 p_user_payroll_action_id in number, -- current run.
64 p_owner_assignment_action_id in number, -- assact created balance.
65 p_user_assignment_action_id in number, -- current assact..
66 p_owner_effective_date in date, -- eff date of balance.
67 p_user_effective_date in date, -- eff date of current run.
68 p_dimension_name in varchar2, -- balance dimension name.
69 p_expiry_information out number -- dimension expired flag.
70 );
71
72 /*------------------------------ aptd_ec ------------------------------------*/
73 /*
74 NAME
75 aptd_ec - Assignment Period To Date Expiry Check.
76 DESCRIPTION
77 Expiry checking code for the following:
78 BF Assignment-level Period to Date Balance Dimension
79 NOTES
80 Associated dimension is expiry checked at
81 Payroll Action level.
82 */
83 procedure aptd_ec
84 (
85 p_owner_payroll_action_id in number, -- run created balance.
86 p_user_payroll_action_id in number, -- current run.
87 p_owner_assignment_action_id in number, -- assact created balance.
88 p_user_assignment_action_id in number, -- current assact..
89 p_owner_effective_date in date, -- eff date of balance.
90 p_user_effective_date in date, -- eff date of current run.
91 p_dimension_name in varchar2, -- balance dimension name.
92 p_expiry_information out number -- dimension expired flag.
93 );
94
95 /*---------------------------- pptd_alc_ec ---------------------------------*/
96 /*
97 NAME
98 aptd_ec - Person Period To Date Assact Level Expiry Check.
99 DESCRIPTION
100 Expiry checking code for the following:
101 BF Person-level Period to Date Balance Dimension (test)
102 NOTES
103 The associated dimension is expiry checked at
104 Assignment Action ID level.
105
106 This expiry checking code does access the list of
107 balance context values.
108 */
109 procedure pptd_alc_ec
110 (
111 p_owner_payroll_action_id in number, -- run created balance.
112 p_user_payroll_action_id in number, -- current run.
113 p_owner_assignment_action_id in number, -- assact created balance.
114 p_user_assignment_action_id in number, -- current assact..
115 p_owner_effective_date in date, -- eff date of balance.
116 p_user_effective_date in date, -- eff date of current run.
117 p_dimension_name in varchar2, -- balance dimension name.
118 p_balance_context_values in varchar2, -- list of context values.
119 p_expiry_information out number -- dimension expired flag.
120 );
121
122 /*-------------------------- always_expires --------------------------------*/
123 /*
124 NAME
125 always_expires - Always expires procedure.
126 DESCRIPTION
127 Returns value that will cause expiry.
128 NOTES
129 This is useful for where we wish to create a balance on
130 the database that is really a run level balance, but happens
131 to have a dimension type of 'A' or 'P'.
132 */
133 procedure always_expires
134 (
135 p_owner_payroll_action_id in number, -- run created balance.
136 p_user_payroll_action_id in number, -- current run.
137 p_owner_assignment_action_id in number, -- assact created balance.
138 p_user_assignment_action_id in number, -- current assact..
139 p_owner_effective_date in date, -- eff date of balance.
140 p_user_effective_date in date, -- eff date of current run.
141 p_dimension_name in varchar2, -- balance dimension name.
142 p_expiry_information out number -- dimension expired flag.
143 );
144
145 /*-------------------------- never_expires --------------------------------*/
146 /*
147 NAME
148 never_expires - Never expires procedure.
149 DESCRIPTION
150 When called, always returns a value that will not cause expiry.
151 NOTES
152 Although this expiry check could be replaced in reality with
153 the 'never expires' expiry checking level, this is left here
154 to reproduce the functionality of the original tests.
155 */
156 procedure never_expires
157 (
158 p_owner_payroll_action_id in number, -- run created balance.
159 p_user_payroll_action_id in number, -- current run.
160 p_owner_assignment_action_id in number, -- assact created balance.
161 p_user_assignment_action_id in number, -- current assact..
162 p_owner_effective_date in date, -- eff date of balance.
163 p_user_effective_date in date, -- eff date of current run.
164 p_dimension_name in varchar2, -- balance dimension name.
165 p_expiry_information out number -- dimension expired flag.
166 );
167
168 /*------------------------------ pcon_ec -----------------------------------*/
169 /*
170 NAME
171 pcon_ec - Person CONtracted in Expiry Check.
172 DESCRIPTION
173 Expiry checking code for the following:
174 BF Person-level Contracted In YTD Balance Dimension
175 NOTES
176 The associated dimension is expiry checked at
177 Payroll Action level.
178
179 The associated dimension never expires, thus the
180 expiry_information flag always returns (FALSE).
181 */
182 procedure pcon_ec
183 (
184 p_owner_payroll_action_id in number, -- run created balance.
185 p_user_payroll_action_id in number, -- current run.
186 p_owner_assignment_action_id in number, -- assact created balance.
187 p_user_assignment_action_id in number, -- current assact..
188 p_owner_effective_date in date, -- eff date of balance.
189 p_user_effective_date in date, -- eff date of current run.
190 p_dimension_name in varchar2, -- balance dimension name.
191 p_expiry_information out number -- dimension expired flag.
192 );
193
194 /*------------------------------ pcon_fc -----------------------------------*/
195 /*
196 NAME
197 pcon_fc - Person CONtracted in Feed Check.
198 DESCRIPTION
199 Feed checking code for the following:
200 BF Person-level Contracted In YTD Balance Dimension
201 NOTES
202 <none>
203 */
204 procedure pcon_fc
205 (
206 p_payroll_action_id in number,
207 p_assignment_action_id in number,
208 p_assignment_id in number,
209 p_effective_date in date,
210 p_dimension_name in varchar2,
211 p_balance_contexts in varchar2,
212 p_feed_flag in out number
213 );
214
215 end pay_bf_expc;