1 package pay_pss_tx_steps_pkg AUTHID CURRENT_USER as
2 /* $Header: pypsst.pkh 120.0.12010000.2 2009/09/26 06:11:28 pgongada ship $ */
3 --
4 -- Valid source tables.
5 --
6 C_PAY_PERSONAL_PAYMENT_METHODS constant varchar2(2000) default
7 'PAY_PERSONAL_PAYMENT_METHODS_F';
8 --
9 -- Valid Amount Types.
10 --
11 C_PERCENTAGE constant varchar2(64) default 'PERCENTAGE';
12 C_PERCENTAGE_ONLY constant varchar2(64) default 'PERCENTAGE_ONLY';
13 C_MONETARY constant varchar2(64) default 'MONETARY';
14 C_MONETARY_ONLY constant varchar2(64) default 'MONETARY_ONLY';
15 C_REMAINING_PAY constant varchar2(64) default 'REMAINING_PAY';
16 --
17 -- Valid Payment Types.
18 --
19 C_CASH constant varchar2(2000) default 'CA';
20 C_CHECK constant varchar2(2000) default 'CH';
21 C_DEPOSIT constant varchar2(2000) default 'MT';
22 --
23 -- Valid states.
24 --
25 C_STATE_NEW constant varchar2(2000) default 'NEW';
26 C_STATE_FREED constant varchar2(2000) default 'FREED';
27 C_STATE_EXISTING constant varchar2(2000) default 'EXISTING';
28 C_STATE_DELETED constant varchar2(2000) default 'DELETED';
29 C_STATE_UPDATED constant varchar2(2000) default 'UPDATED';
30 ----------------------------------< insert_row >----------------------------
31 --
32 -- {Start Of Comments}
33 --
34 -- Description:
35 -- Inserts a row into PAY_PSS_TRANSACTION_STEPS.
36 --
37 -- Prerequisites:
38 -- None.
39 --
40 -- Post Success:
41 -- The row is inserted and the OUT parameters are populated.
42 --
43 -- Post Failure:
44 -- An exception is raised.
45 --
46 -- Access Status:
47 -- Internal Development Use Only.
48 --
49 -- {End Of Comments}
50 --
51 procedure insert_row
52 (p_transaction_id in out nocopy number
53 ,p_transaction_step_id out nocopy number
54 ,p_source_table in varchar2
55 ,p_state in varchar2
56 ,p_personal_payment_method_id in number
57 ,p_update_ovn in number
58 ,p_delete_ovn in number
59 ,p_update_datetrack_mode in varchar2
60 ,p_delete_datetrack_mode in varchar2
61 ,p_delete_disabled in varchar2
62 ,p_effective_date in date
63 ,p_org_payment_method_id in number
64 ,p_assignment_id in number
65 ,p_payment_type in varchar2
66 ,p_currency_code in varchar2
67 ,p_territory_code in varchar2
68 ,p_run_type_id in number
69 ,p_real_priority in number
70 ,p_logical_priority in number
71 ,p_amount_type in varchar2
72 ,p_amount in number
73 ,p_external_account_id in number
74 ,p_attribute_category in varchar2
75 ,p_attribute1 in varchar2
76 ,p_attribute2 in varchar2
77 ,p_attribute3 in varchar2
78 ,p_attribute4 in varchar2
79 ,p_attribute5 in varchar2
80 ,p_attribute6 in varchar2
81 ,p_attribute7 in varchar2
82 ,p_attribute8 in varchar2
83 ,p_attribute9 in varchar2
84 ,p_attribute10 in varchar2
85 ,p_attribute11 in varchar2
86 ,p_attribute12 in varchar2
87 ,p_attribute13 in varchar2
88 ,p_attribute14 in varchar2
89 ,p_attribute15 in varchar2
90 ,p_attribute16 in varchar2
91 ,p_attribute17 in varchar2
92 ,p_attribute18 in varchar2
93 ,p_attribute19 in varchar2
94 ,p_attribute20 in varchar2
95 ,p_o_real_priority in number
96 ,p_o_logical_priority in number
97 ,p_o_amount_type in varchar2
98 ,p_o_amount in number
99 ,p_o_external_account_id in number
100 ,p_o_attribute_category in varchar2
101 ,p_o_attribute1 in varchar2
102 ,p_o_attribute2 in varchar2
103 ,p_o_attribute3 in varchar2
104 ,p_o_attribute4 in varchar2
105 ,p_o_attribute5 in varchar2
106 ,p_o_attribute6 in varchar2
107 ,p_o_attribute7 in varchar2
108 ,p_o_attribute8 in varchar2
109 ,p_o_attribute9 in varchar2
110 ,p_o_attribute10 in varchar2
111 ,p_o_attribute11 in varchar2
112 ,p_o_attribute12 in varchar2
113 ,p_o_attribute13 in varchar2
114 ,p_o_attribute14 in varchar2
115 ,p_o_attribute15 in varchar2
116 ,p_o_attribute16 in varchar2
117 ,p_o_attribute17 in varchar2
118 ,p_o_attribute18 in varchar2
119 ,p_o_attribute19 in varchar2
120 ,p_o_attribute20 in varchar2
121 ,p_ppm_information_category in varchar2
122 ,p_ppm_information1 in varchar2
123 ,p_ppm_information2 in varchar2
124 ,p_ppm_information3 in varchar2
125 ,p_ppm_information4 in varchar2
126 ,p_ppm_information5 in varchar2
127 ,p_ppm_information6 in varchar2
128 ,p_ppm_information7 in varchar2
129 ,p_ppm_information8 in varchar2
130 ,p_ppm_information9 in varchar2
131 ,p_ppm_information10 in varchar2
132 ,p_ppm_information11 in varchar2
133 ,p_ppm_information12 in varchar2
134 ,p_ppm_information13 in varchar2
135 ,p_ppm_information14 in varchar2
136 ,p_ppm_information15 in varchar2
137 ,p_ppm_information16 in varchar2
138 ,p_ppm_information17 in varchar2
139 ,p_ppm_information18 in varchar2
140 ,p_ppm_information19 in varchar2
141 ,p_ppm_information20 in varchar2
142 ,p_ppm_information21 in varchar2
143 ,p_ppm_information22 in varchar2
144 ,p_ppm_information23 in varchar2
145 ,p_ppm_information24 in varchar2
146 ,p_ppm_information25 in varchar2
147 ,p_ppm_information26 in varchar2
148 ,p_ppm_information27 in varchar2
149 ,p_ppm_information28 in varchar2
150 ,p_ppm_information29 in varchar2
151 ,p_ppm_information30 in varchar2
152 ,p_o_ppm_information_category in varchar2
153 ,p_o_ppm_information1 in varchar2
154 ,p_o_ppm_information2 in varchar2
155 ,p_o_ppm_information3 in varchar2
156 ,p_o_ppm_information4 in varchar2
157 ,p_o_ppm_information5 in varchar2
158 ,p_o_ppm_information6 in varchar2
159 ,p_o_ppm_information7 in varchar2
160 ,p_o_ppm_information8 in varchar2
161 ,p_o_ppm_information9 in varchar2
162 ,p_o_ppm_information10 in varchar2
163 ,p_o_ppm_information11 in varchar2
164 ,p_o_ppm_information12 in varchar2
165 ,p_o_ppm_information13 in varchar2
166 ,p_o_ppm_information14 in varchar2
167 ,p_o_ppm_information15 in varchar2
168 ,p_o_ppm_information16 in varchar2
169 ,p_o_ppm_information17 in varchar2
170 ,p_o_ppm_information18 in varchar2
171 ,p_o_ppm_information19 in varchar2
172 ,p_o_ppm_information20 in varchar2
173 ,p_o_ppm_information21 in varchar2
174 ,p_o_ppm_information22 in varchar2
175 ,p_o_ppm_information23 in varchar2
176 ,p_o_ppm_information24 in varchar2
177 ,p_o_ppm_information25 in varchar2
178 ,p_o_ppm_information26 in varchar2
179 ,p_o_ppm_information27 in varchar2
180 ,p_o_ppm_information28 in varchar2
181 ,p_o_ppm_information29 in varchar2
182 ,p_o_ppm_information30 in varchar2
183 );
184 ----------------------------------< update_row >----------------------------
185 --
186 -- {Start Of Comments}
187 --
188 -- Description:
189 -- Updates a row from PAY_PSS_TRANSACTION_STEPS.
190 --
191 -- Prerequisites:
192 -- P_TRANSACTION_STEP_ID must refer to an existing row.
193 --
194 -- Post Success:
195 -- The row is updated.
196 --
197 -- Post Failure:
198 -- An exception is raised.
199 --
200 -- Access Status:
201 -- Internal Development Use Only.
202 --
203 -- {End Of Comments}
204 --
205 procedure update_row
206 (p_transaction_step_id in number
207 ,p_source_table in varchar2
208 ,p_state in varchar2
209 ,p_personal_payment_method_id in number
210 ,p_update_ovn in number
211 ,p_delete_ovn in number
212 ,p_update_datetrack_mode in varchar2
213 ,p_delete_datetrack_mode in varchar2
214 ,p_delete_disabled in varchar2
215 ,p_effective_date in date
216 ,p_org_payment_method_id in number
217 ,p_assignment_id in number
218 ,p_payment_type in varchar2
219 ,p_currency_code in varchar2
220 ,p_territory_code in varchar2
221 ,p_run_type_id in number
222 ,p_real_priority in number
223 ,p_logical_priority in number
224 ,p_amount_type in varchar2
225 ,p_amount in number
226 ,p_external_account_id in number
227 ,p_attribute_category in varchar2
228 ,p_attribute1 in varchar2
229 ,p_attribute2 in varchar2
230 ,p_attribute3 in varchar2
231 ,p_attribute4 in varchar2
232 ,p_attribute5 in varchar2
233 ,p_attribute6 in varchar2
234 ,p_attribute7 in varchar2
235 ,p_attribute8 in varchar2
236 ,p_attribute9 in varchar2
237 ,p_attribute10 in varchar2
238 ,p_attribute11 in varchar2
239 ,p_attribute12 in varchar2
240 ,p_attribute13 in varchar2
241 ,p_attribute14 in varchar2
242 ,p_attribute15 in varchar2
243 ,p_attribute16 in varchar2
244 ,p_attribute17 in varchar2
245 ,p_attribute18 in varchar2
246 ,p_attribute19 in varchar2
247 ,p_attribute20 in varchar2
248 ,p_o_real_priority in number
249 ,p_o_logical_priority in number
250 ,p_o_amount_type in varchar2
251 ,p_o_amount in number
252 ,p_o_external_account_id in number
253 ,p_o_attribute_category in varchar2
254 ,p_o_attribute1 in varchar2
255 ,p_o_attribute2 in varchar2
256 ,p_o_attribute3 in varchar2
257 ,p_o_attribute4 in varchar2
258 ,p_o_attribute5 in varchar2
259 ,p_o_attribute6 in varchar2
260 ,p_o_attribute7 in varchar2
261 ,p_o_attribute8 in varchar2
262 ,p_o_attribute9 in varchar2
263 ,p_o_attribute10 in varchar2
264 ,p_o_attribute11 in varchar2
265 ,p_o_attribute12 in varchar2
266 ,p_o_attribute13 in varchar2
267 ,p_o_attribute14 in varchar2
268 ,p_o_attribute15 in varchar2
269 ,p_o_attribute16 in varchar2
270 ,p_o_attribute17 in varchar2
271 ,p_o_attribute18 in varchar2
272 ,p_o_attribute19 in varchar2
273 ,p_o_attribute20 in varchar2
274 ,p_ppm_information_category in varchar2
275 ,p_ppm_information1 in varchar2
276 ,p_ppm_information2 in varchar2
277 ,p_ppm_information3 in varchar2
278 ,p_ppm_information4 in varchar2
279 ,p_ppm_information5 in varchar2
280 ,p_ppm_information6 in varchar2
281 ,p_ppm_information7 in varchar2
282 ,p_ppm_information8 in varchar2
283 ,p_ppm_information9 in varchar2
284 ,p_ppm_information10 in varchar2
285 ,p_ppm_information11 in varchar2
286 ,p_ppm_information12 in varchar2
287 ,p_ppm_information13 in varchar2
288 ,p_ppm_information14 in varchar2
289 ,p_ppm_information15 in varchar2
290 ,p_ppm_information16 in varchar2
291 ,p_ppm_information17 in varchar2
292 ,p_ppm_information18 in varchar2
293 ,p_ppm_information19 in varchar2
294 ,p_ppm_information20 in varchar2
295 ,p_ppm_information21 in varchar2
296 ,p_ppm_information22 in varchar2
297 ,p_ppm_information23 in varchar2
298 ,p_ppm_information24 in varchar2
299 ,p_ppm_information25 in varchar2
300 ,p_ppm_information26 in varchar2
301 ,p_ppm_information27 in varchar2
302 ,p_ppm_information28 in varchar2
303 ,p_ppm_information29 in varchar2
304 ,p_ppm_information30 in varchar2
305 ,p_o_ppm_information_category in varchar2
306 ,p_o_ppm_information1 in varchar2
307 ,p_o_ppm_information2 in varchar2
308 ,p_o_ppm_information3 in varchar2
309 ,p_o_ppm_information4 in varchar2
310 ,p_o_ppm_information5 in varchar2
311 ,p_o_ppm_information6 in varchar2
312 ,p_o_ppm_information7 in varchar2
313 ,p_o_ppm_information8 in varchar2
314 ,p_o_ppm_information9 in varchar2
315 ,p_o_ppm_information10 in varchar2
316 ,p_o_ppm_information11 in varchar2
317 ,p_o_ppm_information12 in varchar2
318 ,p_o_ppm_information13 in varchar2
319 ,p_o_ppm_information14 in varchar2
320 ,p_o_ppm_information15 in varchar2
321 ,p_o_ppm_information16 in varchar2
322 ,p_o_ppm_information17 in varchar2
323 ,p_o_ppm_information18 in varchar2
324 ,p_o_ppm_information19 in varchar2
325 ,p_o_ppm_information20 in varchar2
326 ,p_o_ppm_information21 in varchar2
327 ,p_o_ppm_information22 in varchar2
328 ,p_o_ppm_information23 in varchar2
329 ,p_o_ppm_information24 in varchar2
330 ,p_o_ppm_information25 in varchar2
331 ,p_o_ppm_information26 in varchar2
332 ,p_o_ppm_information27 in varchar2
333 ,p_o_ppm_information28 in varchar2
334 ,p_o_ppm_information29 in varchar2
335 ,p_o_ppm_information30 in varchar2
336 );
337 ----------------------------------< delete_row >----------------------------
338 --
339 -- {Start Of Comments}
340 --
341 -- Description:
342 -- Deletes a row from PAY_PSS_TRANSACTION_STEPS.
343 --
344 -- Prerequisites:
345 -- P_TRANSACTION_STEP_ID must refer to an existing row.
346 --
347 -- Post Success:
348 -- The row is deleted.
349 --
350 -- Post Failure:
351 -- An exception is raised.
352 --
353 -- Access Status:
354 -- Internal Development Use Only.
355 --
356 -- {End Of Comments}
357 --
358 procedure delete_row
359 (p_transaction_step_id in number
360 );
361 ---------------------------------< delete_rows >----------------------------
362 --
363 -- {Start Of Comments}
364 --
365 -- Description:
366 -- Deletes all rows, for a given transaction_id, from
367 -- PAY_PSS_TRANSACTION_STEPS.
368 --
369 -- Prerequisites:
370 -- P_TRANSACTION_ID must be in use.
371 --
372 -- Post Success:
373 -- The rows are deleted.
374 --
375 -- Post Failure:
376 -- An exception is raised.
377 --
378 -- Access Status:
379 -- Internal Development Use Only.
380 --
381 -- {End Of Comments}
382 --
383 procedure delete_rows
384 (p_transaction_id in number
385 );
386 --
387 end pay_pss_tx_steps_pkg;
[Home] [Help]