[Home] [Help]
PACKAGE BODY: APPS.PAY_PSS_TX_STEPS_PKG
Source
1 package body pay_pss_tx_steps_pkg as
2 /* $Header: pypsst.pkb 115.5 2004/04/04 21:05:11 tvankayl noship $ */
3 ----------------------------------< insert_row >----------------------------
4 procedure insert_row
5 (p_transaction_id in out nocopy number
6 ,p_transaction_step_id out nocopy number
7 ,p_source_table in varchar2
8 ,p_state in varchar2
9 ,p_personal_payment_method_id in number
10 ,p_update_ovn in number
11 ,p_delete_ovn in number
12 ,p_update_datetrack_mode in varchar2
13 ,p_delete_datetrack_mode in varchar2
14 ,p_delete_disabled in varchar2
15 ,p_effective_date in date
16 ,p_org_payment_method_id in number
17 ,p_assignment_id in number
18 ,p_payment_type in varchar2
19 ,p_currency_code in varchar2
20 ,p_territory_code in varchar2
21 ,p_run_type_id in number
22 ,p_real_priority in number
23 ,p_logical_priority in number
24 ,p_amount_type in varchar2
25 ,p_amount in number
26 ,p_external_account_id in number
27 ,p_attribute_category in varchar2
28 ,p_attribute1 in varchar2
29 ,p_attribute2 in varchar2
30 ,p_attribute3 in varchar2
31 ,p_attribute4 in varchar2
32 ,p_attribute5 in varchar2
33 ,p_attribute6 in varchar2
34 ,p_attribute7 in varchar2
35 ,p_attribute8 in varchar2
36 ,p_attribute9 in varchar2
37 ,p_attribute10 in varchar2
38 ,p_attribute11 in varchar2
39 ,p_attribute12 in varchar2
40 ,p_attribute13 in varchar2
41 ,p_attribute14 in varchar2
42 ,p_attribute15 in varchar2
43 ,p_attribute16 in varchar2
44 ,p_attribute17 in varchar2
45 ,p_attribute18 in varchar2
46 ,p_attribute19 in varchar2
47 ,p_attribute20 in varchar2
48 ,p_o_real_priority in number
49 ,p_o_logical_priority in number
50 ,p_o_amount_type in varchar2
51 ,p_o_amount in number
52 ,p_o_external_account_id in number
53 ,p_o_attribute_category in varchar2
54 ,p_o_attribute1 in varchar2
55 ,p_o_attribute2 in varchar2
56 ,p_o_attribute3 in varchar2
57 ,p_o_attribute4 in varchar2
58 ,p_o_attribute5 in varchar2
59 ,p_o_attribute6 in varchar2
60 ,p_o_attribute7 in varchar2
61 ,p_o_attribute8 in varchar2
62 ,p_o_attribute9 in varchar2
63 ,p_o_attribute10 in varchar2
64 ,p_o_attribute11 in varchar2
65 ,p_o_attribute12 in varchar2
66 ,p_o_attribute13 in varchar2
67 ,p_o_attribute14 in varchar2
68 ,p_o_attribute15 in varchar2
69 ,p_o_attribute16 in varchar2
70 ,p_o_attribute17 in varchar2
71 ,p_o_attribute18 in varchar2
72 ,p_o_attribute19 in varchar2
73 ,p_o_attribute20 in varchar2
74 ) is
75 l_transaction_id number := p_transaction_id;
76 l_transaction_step_id number;
77 begin
78 --
79 -- Create (and return) transaction_id, if necessary.
80 --
81 if l_transaction_id is null then
82 select pay_pss_transactions_s.nextval
83 into l_transaction_id
84 from dual;
85 p_transaction_id := l_transaction_id;
86 end if;
87 --
88 -- Create and return the transaction_step_id.
89 --
90 select pay_pss_transaction_steps_s.nextval
91 into l_transaction_step_id
92 from dual;
93 p_transaction_step_id := l_transaction_step_id;
94 --
95 -- Do the insert.
96 --
97 insert into pay_pss_transaction_steps
98 (transaction_step_id
99 ,transaction_id
100 ,source_table
101 ,state
102 ,personal_payment_method_id
103 ,update_ovn
104 ,delete_ovn
105 ,update_datetrack_mode
106 ,delete_datetrack_mode
107 ,delete_disabled
108 ,effective_date
109 ,org_payment_method_id
110 ,assignment_id
111 ,payment_type
112 ,currency_code
113 ,territory_code
114 ,real_priority
115 ,logical_priority
116 ,amount_type
117 ,amount
118 ,external_account_id
119 ,attribute_category
120 ,attribute1
121 ,attribute2
122 ,attribute3
123 ,attribute4
124 ,attribute5
125 ,attribute6
126 ,attribute7
127 ,attribute8
128 ,attribute9
129 ,attribute10
130 ,attribute11
131 ,attribute12
132 ,attribute13
133 ,attribute14
134 ,attribute15
135 ,attribute16
136 ,attribute17
137 ,attribute18
138 ,attribute19
139 ,attribute20
140 ,o_real_priority
141 ,o_logical_priority
142 ,o_amount_type
143 ,o_amount
144 ,o_external_account_id
145 ,o_attribute_category
146 ,o_attribute1
147 ,o_attribute2
148 ,o_attribute3
149 ,o_attribute4
150 ,o_attribute5
151 ,o_attribute6
152 ,o_attribute7
153 ,o_attribute8
154 ,o_attribute9
155 ,o_attribute10
156 ,o_attribute11
157 ,o_attribute12
158 ,o_attribute13
159 ,o_attribute14
160 ,o_attribute15
161 ,o_attribute16
162 ,o_attribute17
163 ,o_attribute18
164 ,o_attribute19
165 ,o_attribute20
166 ,run_type_id
167 )
168 values
169 (l_transaction_step_id
170 ,l_transaction_id
171 ,p_source_table
172 ,p_state
173 ,p_personal_payment_method_id
174 ,p_update_ovn
175 ,p_delete_ovn
176 ,p_update_datetrack_mode
177 ,p_delete_datetrack_mode
178 ,p_delete_disabled
179 ,p_effective_date
180 ,p_org_payment_method_id
181 ,p_assignment_id
182 ,p_payment_type
183 ,p_currency_code
184 ,p_territory_code
185 ,p_real_priority
186 ,p_logical_priority
187 ,p_amount_type
188 ,p_amount
189 ,p_external_account_id
190 ,p_attribute_category
191 ,p_attribute1
192 ,p_attribute2
193 ,p_attribute3
194 ,p_attribute4
195 ,p_attribute5
196 ,p_attribute6
197 ,p_attribute7
198 ,p_attribute8
199 ,p_attribute9
200 ,p_attribute10
201 ,p_attribute11
202 ,p_attribute12
203 ,p_attribute13
204 ,p_attribute14
205 ,p_attribute15
206 ,p_attribute16
207 ,p_attribute17
208 ,p_attribute18
209 ,p_attribute19
210 ,p_attribute20
211 ,p_o_real_priority
212 ,p_o_logical_priority
213 ,p_o_amount_type
214 ,p_o_amount
215 ,p_o_external_account_id
216 ,p_o_attribute_category
217 ,p_o_attribute1
218 ,p_o_attribute2
219 ,p_o_attribute3
220 ,p_o_attribute4
221 ,p_o_attribute5
222 ,p_o_attribute6
223 ,p_o_attribute7
224 ,p_o_attribute8
225 ,p_o_attribute9
226 ,p_o_attribute10
227 ,p_o_attribute11
228 ,p_o_attribute12
229 ,p_o_attribute13
230 ,p_o_attribute14
231 ,p_o_attribute15
232 ,p_o_attribute16
233 ,p_o_attribute17
234 ,p_o_attribute18
235 ,p_o_attribute19
236 ,p_o_attribute20
237 ,p_run_type_id
238 );
239 end insert_row;
240 ----------------------------------< update_row >----------------------------
241 procedure update_row
242 (p_transaction_step_id in number
243 ,p_source_table in varchar2
244 ,p_state in varchar2
245 ,p_personal_payment_method_id in number
246 ,p_update_ovn in number
247 ,p_delete_ovn in number
248 ,p_update_datetrack_mode in varchar2
249 ,p_delete_datetrack_mode in varchar2
250 ,p_delete_disabled in varchar2
251 ,p_effective_date in date
252 ,p_org_payment_method_id in number
253 ,p_assignment_id in number
254 ,p_payment_type in varchar2
255 ,p_currency_code in varchar2
256 ,p_territory_code in varchar2
257 ,p_run_type_id in number
258 ,p_real_priority in number
259 ,p_logical_priority in number
260 ,p_amount_type in varchar2
261 ,p_amount in number
262 ,p_external_account_id in number
263 ,p_attribute_category in varchar2
264 ,p_attribute1 in varchar2
265 ,p_attribute2 in varchar2
266 ,p_attribute3 in varchar2
267 ,p_attribute4 in varchar2
268 ,p_attribute5 in varchar2
269 ,p_attribute6 in varchar2
270 ,p_attribute7 in varchar2
271 ,p_attribute8 in varchar2
272 ,p_attribute9 in varchar2
273 ,p_attribute10 in varchar2
274 ,p_attribute11 in varchar2
275 ,p_attribute12 in varchar2
276 ,p_attribute13 in varchar2
277 ,p_attribute14 in varchar2
278 ,p_attribute15 in varchar2
279 ,p_attribute16 in varchar2
280 ,p_attribute17 in varchar2
281 ,p_attribute18 in varchar2
282 ,p_attribute19 in varchar2
283 ,p_attribute20 in varchar2
284 ,p_o_real_priority in number
285 ,p_o_logical_priority in number
286 ,p_o_amount_type in varchar2
287 ,p_o_amount in number
288 ,p_o_external_account_id in number
289 ,p_o_attribute_category in varchar2
290 ,p_o_attribute1 in varchar2
291 ,p_o_attribute2 in varchar2
292 ,p_o_attribute3 in varchar2
293 ,p_o_attribute4 in varchar2
294 ,p_o_attribute5 in varchar2
295 ,p_o_attribute6 in varchar2
296 ,p_o_attribute7 in varchar2
297 ,p_o_attribute8 in varchar2
298 ,p_o_attribute9 in varchar2
299 ,p_o_attribute10 in varchar2
300 ,p_o_attribute11 in varchar2
301 ,p_o_attribute12 in varchar2
302 ,p_o_attribute13 in varchar2
303 ,p_o_attribute14 in varchar2
304 ,p_o_attribute15 in varchar2
305 ,p_o_attribute16 in varchar2
306 ,p_o_attribute17 in varchar2
307 ,p_o_attribute18 in varchar2
308 ,p_o_attribute19 in varchar2
309 ,p_o_attribute20 in varchar2
310 ) is
311 begin
312 update pay_pss_transaction_steps p
313 set p.source_table = p_source_table
314 , p.state = p_state
315 , p.personal_payment_method_id = p_personal_payment_method_id
316 , p.update_ovn = p_update_ovn
317 , p.delete_ovn = p_delete_ovn
318 , p.update_datetrack_mode = p_update_datetrack_mode
319 , p.delete_datetrack_mode = p_delete_datetrack_mode
320 , p.delete_disabled = p_delete_disabled
321 , p.effective_date = p_effective_date
322 , p.org_payment_method_id = p_org_payment_method_id
323 , p.assignment_id = p_assignment_id
324 , p.payment_type = p_payment_type
325 , p.currency_code = p_currency_code
326 , p.territory_code = p_territory_code
327 , p.real_priority = p_real_priority
328 , p.logical_priority = p_logical_priority
329 , p.amount_type = p_amount_type
330 , p.amount = p_amount
331 , p.external_account_id = p_external_account_id
332 , p.attribute_category = p_attribute_category
333 , p.attribute1 = p_attribute1
334 , p.attribute2 = p_attribute2
335 , p.attribute3 = p_attribute3
336 , p.attribute4 = p_attribute4
337 , p.attribute5 = p_attribute5
338 , p.attribute6 = p_attribute6
339 , p.attribute7 = p_attribute7
340 , p.attribute8 = p_attribute8
341 , p.attribute9 = p_attribute9
342 , p.attribute10 = p_attribute10
343 , p.attribute11 = p_attribute11
344 , p.attribute12 = p_attribute12
345 , p.attribute13 = p_attribute13
346 , p.attribute14 = p_attribute14
347 , p.attribute15 = p_attribute15
348 , p.attribute16 = p_attribute16
349 , p.attribute17 = p_attribute17
350 , p.attribute18 = p_attribute18
351 , p.attribute19 = p_attribute19
352 , p.attribute20 = p_attribute20
353 , p.o_real_priority = p_o_real_priority
354 , p.o_logical_priority = p_o_logical_priority
355 , p.o_amount_type = p_o_amount_type
356 , p.o_amount = p_o_amount
357 , p.o_external_account_id = p_o_external_account_id
358 , p.o_attribute_category = p_o_attribute_category
359 , p.o_attribute1 = p_o_attribute1
360 , p.o_attribute2 = p_o_attribute2
361 , p.o_attribute3 = p_o_attribute3
362 , p.o_attribute4 = p_o_attribute4
363 , p.o_attribute5 = p_o_attribute5
364 , p.o_attribute6 = p_o_attribute6
365 , p.o_attribute7 = p_o_attribute7
366 , p.o_attribute8 = p_o_attribute8
367 , p.o_attribute9 = p_o_attribute9
368 , p.o_attribute10 = p_o_attribute10
369 , p.o_attribute11 = p_o_attribute11
370 , p.o_attribute12 = p_o_attribute12
371 , p.o_attribute13 = p_o_attribute13
372 , p.o_attribute14 = p_o_attribute14
373 , p.o_attribute15 = p_o_attribute15
374 , p.o_attribute16 = p_o_attribute16
375 , p.o_attribute17 = p_o_attribute17
376 , p.o_attribute18 = p_o_attribute18
377 , p.o_attribute19 = p_o_attribute19
378 , p.o_attribute20 = p_o_attribute20
379 , p.run_type_id = p_run_type_id
380 where p.transaction_step_id = p_transaction_step_id;
381 end update_row;
382 ----------------------------------< delete_row >----------------------------
383 procedure delete_row
384 (p_transaction_step_id in number
385 ) is
386 begin
387 delete
388 from pay_pss_transaction_steps
389 where transaction_step_id = p_transaction_step_id;
390 end delete_row;
391 ---------------------------------< delete_rows >----------------------------
392 procedure delete_rows
393 (p_transaction_id in number
394 ) is
395 begin
396 delete
397 from pay_pss_transaction_steps
398 where transaction_id = p_transaction_id;
399 end delete_rows;
400 --
401 end pay_pss_tx_steps_pkg;