[Home] [Help]
PACKAGE: APPS.PAY_MIX_ROLLBACK_PKG
Source
1 PACKAGE pay_mix_rollback_pkg AUTHID CURRENT_USER AS
2 /* $Header: pymixrbk.pkh 120.1 2006/11/29 12:26:43 susivasu noship $ */
3
4
5 --
6 -- undo_mix
7 --
8 --
9 -- NAME
10 -- undo_mix
11 --
12 -- DESCRIPTION
13 -- Performs rollback on element entries insert by mix, excluding
14 -- those that have been updated.
15 --
16 -- NOTES
17 --
18 --
19 --
20 -- Parameters used are:
21 --
22 -- p_retcode :
23 -- Required parameter generated by the SRS for the concurrent manager.
24 --
25 -- p_errbuf :
26 -- Required parameter generated by the SRS for the concurrent manager.
27 --
28 -- p_batch_header_id :
29 -- Identifies batch to be rolled back.
30 --
31 -- p_commit_all_or_nothing_flag :
32 -- If true, process fails immediately on first error, otherwise
33 -- continues to maximum error count.
34 --
35 -- p_reject_if_run_results_exist :
36 -- If true, errors a batch line if run results exist for the entry.
37 --
38 -- p_dml_mode :
39 -- Not used in this first version.
40 --
41 -- p_effective_session_date :
42 -- For delete_entry api. Passed as a varchar2 to overcome format
43 -- problems. This is rendered rendundant. See above change history.
44 --
45 -- p_leave_batch_flag :
46 -- If true, does not purge batch after rollback.
47 --
48 -- p_assignment_id :
49 -- Assignment to be rolled back.
50 --
51 -- p_asg_action_id :
52 -- Assignment action to be rolled back.
53 --
54
55 procedure undo_mix(
56 p_errbuf out nocopy varchar2,
57 p_retcode out nocopy number,
58 p_batch_header_id in number,
59 p_commit_all_or_nothing in varchar2 default 'Y',
60 p_reject_if_run_results_exist in varchar2 default 'Y',
61 p_dml_mode in varchar2,
62 p_leave_batch in varchar2 default 'Y',
63 p_assignment_id in number default null,
64 p_asg_action_id in number default null
65 );
66
67
68 --
69 -- run_results_exist
70 --
71 --
72 -- NAME
73 -- run_results_exist.
74 --
75 -- DESCRIPTION
76 -- checks for run results for the entry supplied.
77 --
78 -- NOTES
79 --
80 --
81 --
82 -- Parameters used are :
83 --
84 -- p_element_entry_id :
85 --
86 -- element_entry_id to check in pay_run_results.
87 --
88
89 function run_results_exist(p_element_entry_id in number
90 ,p_effective_session_date in date default null
91 ,p_chk_rollback_upd in varchar default null) return boolean;
92
93 --
94 -- insert_rollback_message
95 --
96 --
97 -- NAME
98 -- insert_rollback_message.
99 --
100 -- DESCRIPTION
101 -- inserts error message in pay_message_lines.
102 --
103 -- NOTES
104 --
105 --
106 --
107 -- Parameters used are :
108 --
109 -- p_level :
110 --
111 -- Level of operation at which error occurred. Can be 'H' for header
112 -- or 'L' for line.
113 --
114 -- p_batch_id :
115 --
116 -- For the source_type column.
117 --
118 -- p_severity :
119 --
120 -- For the message_level column.
121 --
122 -- p_fail :
123 --
124 -- Fail the process? True or false.
125 --
126
127 procedure insert_rollback_message(p_level in varchar2,
128 p_batch_id in number,
129 p_severity in varchar2,
130 p_fail in boolean);
131
132 --
133 -- action_parameter
134 --
135 --
136 -- NAME
137 -- action_parameter
138 --
139 -- DESCRIPTION
140 -- used to get the max_errors_allowed value from pay_action_parameters.
141 --
142 -- NOTES
143 --
144 --
145 -- Parameters used are:
146 --
147 -- p_param_name :
148 --
149 -- Parameter name to retrieve.
150
151 function action_parameter(p_param_name in varchar2)
152 return varchar2;
153
154
155 --
156 -- commit_messages
157 --
158 --
159 -- NAME
160 -- commit_messages.
161 --
162 -- DESCRIPTION
163 -- Commits process messages to the database following a rollback.
164 --
165 -- NOTES
166 --
167 --
168 -- No parameters required.
169 --
170
171 procedure commit_messages;
172
173
174 --
175 -- purge_rollback_messages.
176 --
177 --
178 -- NAME
179 -- purge_rollback_messages
180 --
181 -- DESCRIPTION
182 -- Removes rollback messages from pay_message_lines.
183 --
184 -- NOTES
185 --
186 --
187 --
188 -- Parameters used are :
189 --
190 -- p_source_id :
191 --
192 -- Source_ID of messages to be removed.
193 --
194 -- p_msg_type :
195 -- Messgae type of the above source.
196
197 procedure purge_rollback_messages(p_source_id in number,p_msg_type varchar2);
198
199
200 --
201 -- undo_mix_asg
202 --
203 --
204 -- NAME
205 -- undo_mix_asg
206 --
207 -- DESCRIPTION
208 -- Performs rollback on element entries insert by mixf for a given
209 -- assignment, excluding those that have been updated.
210 --
211 -- NOTES
212 --
213 --
214 --
215 -- Parameters used are:
216 --
217 -- p_asg_action_id :
218 -- Assignment action id.
219 --
220 --
221 --
222
223 procedure undo_mix_asg(
224 p_asg_action_id in number
225 );
226
227
228 --
229 -- set_status
230 --
231 --
232 -- NAME
233 -- set_status
234 --
235 -- DESCRIPTION
236 -- Set the status of the batch after rollback, if necessary
237 -- then it will purge the batch.
238 --
239 -- NOTES
240 --
241 --
242 --
243 -- Parameters used are:
244 --
245 -- p_payroll_action_id :
246 -- Payroll action id.
247 --
248 -- p_leave_row :
249 -- Parameter to indicated whether the payroll action
250 -- records will be removed after the rollback.
251 --
252 --
253
254 procedure set_status(
255 p_payroll_action_id in number,
256 p_leave_row in boolean
257 );
258
259
260 end pay_mix_rollback_pkg;