DBA Data[Home] [Help]

PACKAGE: APPS.IBY_UPG_PPP_PKG

Source


1 package IBY_UPG_PPP_PKG as
2 /* $Header: ibypppus.pls 120.3.12010000.1 2008/07/28 05:42:04 appldev ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_SYSTEM_PROFILE_CODE in VARCHAR2,
7   X_REMIT_PMT_DETAILS_LENGTH_LIM in NUMBER,
8   X_REMIT_REMITTANCE_ADVICE_FORM in VARCHAR2,
9   X_REMIT_SRA_OVERRIDE_PAYEE_FLA in VARCHAR2,
10   X_REMIT_ADVICE_DELIVERY_METHOD in VARCHAR2,
11   X_REMIT_AUTOMATIC_SRA_SUBMIT in VARCHAR2,
12   X_OBJECT_VERSION_NUMBER in NUMBER,
13   X_PMT_PAYMENT_DETAILS_FORMULA in VARCHAR2,
14   X_INST_GROUP_BY_LEGAL_ENTITY in VARCHAR2,
15   X_INST_GROUP_BY_BILL_PAYABLE in VARCHAR2,
16   X_INST_GROUP_BY_MAX_INSTRUCTIO in VARCHAR2,
17   X_INST_GROUP_BY_ORGANIZATION in VARCHAR2,
18   X_INST_GROUP_BY_PAYMENT_FUNCTI in VARCHAR2,
19   X_INST_GROUP_BY_PAYMENT_REASON in VARCHAR2,
20   X_INST_GROUP_BY_RFC in VARCHAR2,
21   X_INST_MAX_PAYMENTS_PER_INSTR in NUMBER,
22   X_INST_MAX_AMOUNT_PER_INSTR_VA in NUMBER,
23   X_INST_MAX_AMOUNT_PER_INSTR_CU in VARCHAR2,
24   X_INST_MAX_AMOUNT_FX_RATE_TYPE in VARCHAR2,
25   X_INST_SORT_OPTION_1 in VARCHAR2,
26   X_INST_SORT_ORDER_1 in VARCHAR2,
27   X_INST_SORT_OPTION_2 in VARCHAR2,
28   X_POSITIVE_PAY_DELIVERY_FLAG in VARCHAR2,
29   X_TRANSMIT_INSTR_IMMED_FLAG in VARCHAR2,
30   X_AUTOMATIC_PI_REG_SUBMIT in VARCHAR2,
31   X_PMT_GROUP_BY_DELIVERY_CHANNE in VARCHAR2,
32   X_PMT_GROUP_BY_REMITTANCE_MES in VARCHAR2,
33   X_PMT_GROUP_BY_MAX_DOCUMENTS in VARCHAR2,
34   X_PMT_GROUP_BY_UNIQUE_REMIT_ID in VARCHAR2,
35   X_PMT_GROUP_BY_SETTLE_PRIORITY in VARCHAR2,
36   X_PMT_GROUP_BY_PAYMENT_REASON in VARCHAR2,
37   X_PMT_GROUP_BY_DUE_DATE_FLAG in VARCHAR2,
38   X_PMT_MAX_DOCUMENTS_PER_PAYMEN in NUMBER,
39   X_PMT_PAYMENT_DETAILS_LENGTH_L in NUMBER,
40   X_PMT_GROUP_BY_PAYMENT_DETAILS in VARCHAR2,
41   X_PMT_GROUP_BY_BANK_CHARGE_BEA in VARCHAR2,
42   X_INST_SORT_ORDER_2 in VARCHAR2,
43   X_INST_SORT_OPTION_3 in VARCHAR2,
44   X_INST_SORT_ORDER_3 in VARCHAR2,
45   X_REMIT_DOCUMENT_COUNT_LIMIT in NUMBER,
46   X_REMIT_ALLOW_MULTIPLE_COPY_FL in VARCHAR2,
47   X_INST_GROUP_BY_PAYMENT_DATE in VARCHAR2,
48   X_INST_GROUP_BY_PAYMENT_CURREN in VARCHAR2,
49   X_INST_GROUP_BY_INT_BANK_ACCT in VARCHAR2,
50   X_INST_GROUP_BY_MAX_PAYMENTS in VARCHAR2,
51   X_INST_GROUP_BY_PAY_SERVICE_RE in VARCHAR2,
52   X_DCL_ONLY_FOREIGN_CURR_PMT_FL in VARCHAR2,
53   X_DECLARATION_REPORT_FORMAT_CO in VARCHAR2,
54   X_DECLARATION_CURR_FX_RATE_TYP in VARCHAR2,
55   X_DECLARATION_CURRENCY_CODE in VARCHAR2,
56   X_DECLARATION_THRESHOLD_AMOUNT in NUMBER,
57   X_BANK_INSTRUCTION1_CODE in VARCHAR2,
58   X_BANK_INSTRUCTION2_CODE in VARCHAR2,
59   X_BANK_INSTRUCTION_DETAILS in VARCHAR2,
60   X_PAYMENT_TEXT_MESSAGE1 in VARCHAR2,
61   X_PAYMENT_TEXT_MESSAGE2 in VARCHAR2,
62   X_ACK_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
63   X_ACK_SECURITY_PROTOCOL_CODE in VARCHAR2,
64   X_SEND_TO_FILE_FLAG in VARCHAR2,
65   X_PI_REGISTER_FORMAT in VARCHAR2,
66   X_BEP_ACCOUNT_ID in NUMBER,
67   X_APPLICABLE_PMT_METHOD in VARCHAR2,
68   X_APPLICABLE_CURRENCY in VARCHAR2,
69   X_APPLICABLE_PAYER_ORG in VARCHAR2,
70   X_APPLICABLE_INT_BANK_ACCOUNT in VARCHAR2,
71   X_BEP_SUFFIX in VARCHAR2,
72   X_SECURITY_PROTOCOL_CODE in VARCHAR2,
73   X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
74   X_PAYMENT_FORMAT_CODE in VARCHAR2,
75   X_POSITIVE_PAY_FORMAT_CODE in VARCHAR2,
76   X_PAY_FILE_LETTER_FORMAT_CODE in VARCHAR2,
77   X_PRINT_INSTRUCTION_IMMED_FLAG in VARCHAR2,
78   X_PERIODIC_SEQUENCE_NAME_1 in VARCHAR2,
79   X_PERIODIC_SEQUENCE_NAME_2 in VARCHAR2,
80   X_PERIODIC_SEQUENCE_NAME_3 in VARCHAR2,
81   X_PROCESSING_TYPE in VARCHAR2,
82   X_MARK_COMPLETE_EVENT in VARCHAR2,
83   X_MANUAL_MARK_COMPLETE_FLAG in VARCHAR2,
84   X_DECLARATION_OPTION in VARCHAR2,
85   X_SYSTEM_PROFILE_NAME in VARCHAR2,
86   X_SYSTEM_PROFILE_DESCRIPTION in VARCHAR2,
87   X_CREATION_DATE in DATE,
88   X_CREATED_BY in NUMBER,
89   X_LAST_UPDATE_DATE in DATE,
90   X_LAST_UPDATED_BY in NUMBER,
91   X_LAST_UPDATE_LOGIN in NUMBER,
92   X_ELECTRONIC_PROCESSING_CHNNL in VARCHAR2,
93   X_LOGICAL_GROUPING_MODE in VARCHAR2,
94   X_BATCH_BOOKING_FLAG in VARCHAR2,
95   X_INST_GROUP_BY_PAYMENT_METHOD in VARCHAR2
96 );
97 procedure LOCK_ROW (
98   X_SYSTEM_PROFILE_CODE in VARCHAR2,
99   X_REMIT_PMT_DETAILS_LENGTH_LIM in NUMBER,
100   X_REMIT_REMITTANCE_ADVICE_FORM in VARCHAR2,
101   X_REMIT_SRA_OVERRIDE_PAYEE_FLA in VARCHAR2,
102   X_REMIT_ADVICE_DELIVERY_METHOD in VARCHAR2,
103   X_REMIT_AUTOMATIC_SRA_SUBMIT in VARCHAR2,
104   X_OBJECT_VERSION_NUMBER in NUMBER,
105   X_PMT_PAYMENT_DETAILS_FORMULA in VARCHAR2,
106   X_INST_GROUP_BY_LEGAL_ENTITY in VARCHAR2,
107   X_INST_GROUP_BY_BILL_PAYABLE in VARCHAR2,
108   X_INST_GROUP_BY_MAX_INSTRUCTIO in VARCHAR2,
109   X_INST_GROUP_BY_ORGANIZATION in VARCHAR2,
110   X_INST_GROUP_BY_PAYMENT_FUNCTI in VARCHAR2,
111   X_INST_GROUP_BY_PAYMENT_REASON in VARCHAR2,
112   X_INST_GROUP_BY_RFC in VARCHAR2,
113   X_INST_MAX_PAYMENTS_PER_INSTR in NUMBER,
114   X_INST_MAX_AMOUNT_PER_INSTR_VA in NUMBER,
115   X_INST_MAX_AMOUNT_PER_INSTR_CU in VARCHAR2,
116   X_INST_MAX_AMOUNT_FX_RATE_TYPE in VARCHAR2,
117   X_INST_SORT_OPTION_1 in VARCHAR2,
118   X_INST_SORT_ORDER_1 in VARCHAR2,
119   X_INST_SORT_OPTION_2 in VARCHAR2,
120   X_POSITIVE_PAY_DELIVERY_FLAG in VARCHAR2,
121   X_TRANSMIT_INSTR_IMMED_FLAG in VARCHAR2,
122   X_AUTOMATIC_PI_REG_SUBMIT in VARCHAR2,
123   X_PMT_GROUP_BY_DELIVERY_CHANNE in VARCHAR2,
124   X_PMT_GROUP_BY_REMITTANCE_MES in VARCHAR2,
125   X_PMT_GROUP_BY_MAX_DOCUMENTS in VARCHAR2,
126   X_PMT_GROUP_BY_UNIQUE_REMIT_ID in VARCHAR2,
127   X_PMT_GROUP_BY_SETTLE_PRIORITY in VARCHAR2,
128   X_PMT_GROUP_BY_PAYMENT_REASON in VARCHAR2,
129   X_PMT_GROUP_BY_DUE_DATE_FLAG in VARCHAR2,
130   X_PMT_MAX_DOCUMENTS_PER_PAYMEN in NUMBER,
131   X_PMT_PAYMENT_DETAILS_LENGTH_L in NUMBER,
132   X_PMT_GROUP_BY_PAYMENT_DETAILS in VARCHAR2,
133   X_PMT_GROUP_BY_BANK_CHARGE_BEA in VARCHAR2,
134   X_INST_SORT_ORDER_2 in VARCHAR2,
135   X_INST_SORT_OPTION_3 in VARCHAR2,
136   X_INST_SORT_ORDER_3 in VARCHAR2,
137   X_REMIT_DOCUMENT_COUNT_LIMIT in NUMBER,
138   X_REMIT_ALLOW_MULTIPLE_COPY_FL in VARCHAR2,
139   X_INST_GROUP_BY_PAYMENT_DATE in VARCHAR2,
140   X_INST_GROUP_BY_PAYMENT_CURREN in VARCHAR2,
141   X_INST_GROUP_BY_INT_BANK_ACCT in VARCHAR2,
142   X_INST_GROUP_BY_MAX_PAYMENTS in VARCHAR2,
143   X_INST_GROUP_BY_PAY_SERVICE_RE in VARCHAR2,
144   X_DCL_ONLY_FOREIGN_CURR_PMT_FL in VARCHAR2,
145   X_DECLARATION_REPORT_FORMAT_CO in VARCHAR2,
146   X_DECLARATION_CURR_FX_RATE_TYP in VARCHAR2,
147   X_DECLARATION_CURRENCY_CODE in VARCHAR2,
148   X_DECLARATION_THRESHOLD_AMOUNT in NUMBER,
149   X_BANK_INSTRUCTION1_CODE in VARCHAR2,
150   X_BANK_INSTRUCTION2_CODE in VARCHAR2,
151   X_BANK_INSTRUCTION_DETAILS in VARCHAR2,
152   X_PAYMENT_TEXT_MESSAGE1 in VARCHAR2,
153   X_PAYMENT_TEXT_MESSAGE2 in VARCHAR2,
154   X_ACK_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
155   X_ACK_SECURITY_PROTOCOL_CODE in VARCHAR2,
156   X_SEND_TO_FILE_FLAG in VARCHAR2,
157   X_PI_REGISTER_FORMAT in VARCHAR2,
158   X_BEP_ACCOUNT_ID in NUMBER,
159   X_APPLICABLE_PMT_METHOD in VARCHAR2,
160   X_APPLICABLE_CURRENCY in VARCHAR2,
161   X_APPLICABLE_PAYER_ORG in VARCHAR2,
162   X_APPLICABLE_INT_BANK_ACCOUNT in VARCHAR2,
163   X_BEP_SUFFIX in VARCHAR2,
164   X_SECURITY_PROTOCOL_CODE in VARCHAR2,
165   X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
166   X_PAYMENT_FORMAT_CODE in VARCHAR2,
167   X_POSITIVE_PAY_FORMAT_CODE in VARCHAR2,
168   X_PAY_FILE_LETTER_FORMAT_CODE in VARCHAR2,
169   X_PRINT_INSTRUCTION_IMMED_FLAG in VARCHAR2,
170   X_PERIODIC_SEQUENCE_NAME_1 in VARCHAR2,
171   X_PERIODIC_SEQUENCE_NAME_2 in VARCHAR2,
172   X_PERIODIC_SEQUENCE_NAME_3 in VARCHAR2,
173   X_PROCESSING_TYPE in VARCHAR2,
174   X_MARK_COMPLETE_EVENT in VARCHAR2,
175   X_MANUAL_MARK_COMPLETE_FLAG in VARCHAR2,
176   X_DECLARATION_OPTION in VARCHAR2,
177   X_SYSTEM_PROFILE_NAME in VARCHAR2,
178   X_SYSTEM_PROFILE_DESCRIPTION in VARCHAR2,
179   X_ELECTRONIC_PROCESSING_CHNNL in VARCHAR2,
180   X_LOGICAL_GROUPING_MODE in VARCHAR2,
181   X_BATCH_BOOKING_FLAG in VARCHAR2,
182   X_INST_GROUP_BY_PAYMENT_METHOD in VARCHAR2
183 );
184 procedure UPDATE_ROW (
185   X_SYSTEM_PROFILE_CODE in VARCHAR2,
186   X_REMIT_PMT_DETAILS_LENGTH_LIM in NUMBER,
187   X_REMIT_REMITTANCE_ADVICE_FORM in VARCHAR2,
188   X_REMIT_SRA_OVERRIDE_PAYEE_FLA in VARCHAR2,
189   X_REMIT_ADVICE_DELIVERY_METHOD in VARCHAR2,
190   X_REMIT_AUTOMATIC_SRA_SUBMIT in VARCHAR2,
191   X_OBJECT_VERSION_NUMBER in NUMBER,
192   X_PMT_PAYMENT_DETAILS_FORMULA in VARCHAR2,
193   X_INST_GROUP_BY_LEGAL_ENTITY in VARCHAR2,
194   X_INST_GROUP_BY_BILL_PAYABLE in VARCHAR2,
195   X_INST_GROUP_BY_MAX_INSTRUCTIO in VARCHAR2,
196   X_INST_GROUP_BY_ORGANIZATION in VARCHAR2,
197   X_INST_GROUP_BY_PAYMENT_FUNCTI in VARCHAR2,
198   X_INST_GROUP_BY_PAYMENT_REASON in VARCHAR2,
199   X_INST_GROUP_BY_RFC in VARCHAR2,
200   X_INST_MAX_PAYMENTS_PER_INSTR in NUMBER,
201   X_INST_MAX_AMOUNT_PER_INSTR_VA in NUMBER,
202   X_INST_MAX_AMOUNT_PER_INSTR_CU in VARCHAR2,
203   X_INST_MAX_AMOUNT_FX_RATE_TYPE in VARCHAR2,
204   X_INST_SORT_OPTION_1 in VARCHAR2,
205   X_INST_SORT_ORDER_1 in VARCHAR2,
206   X_INST_SORT_OPTION_2 in VARCHAR2,
207   X_POSITIVE_PAY_DELIVERY_FLAG in VARCHAR2,
208   X_TRANSMIT_INSTR_IMMED_FLAG in VARCHAR2,
209   X_AUTOMATIC_PI_REG_SUBMIT in VARCHAR2,
210   X_PMT_GROUP_BY_DELIVERY_CHANNE in VARCHAR2,
211   X_PMT_GROUP_BY_REMITTANCE_MES in VARCHAR2,
212   X_PMT_GROUP_BY_MAX_DOCUMENTS in VARCHAR2,
213   X_PMT_GROUP_BY_UNIQUE_REMIT_ID in VARCHAR2,
214   X_PMT_GROUP_BY_SETTLE_PRIORITY in VARCHAR2,
215   X_PMT_GROUP_BY_PAYMENT_REASON in VARCHAR2,
216   X_PMT_GROUP_BY_DUE_DATE_FLAG in VARCHAR2,
217   X_PMT_MAX_DOCUMENTS_PER_PAYMEN in NUMBER,
218   X_PMT_PAYMENT_DETAILS_LENGTH_L in NUMBER,
219   X_PMT_GROUP_BY_PAYMENT_DETAILS in VARCHAR2,
220   X_PMT_GROUP_BY_BANK_CHARGE_BEA in VARCHAR2,
221   X_INST_SORT_ORDER_2 in VARCHAR2,
222   X_INST_SORT_OPTION_3 in VARCHAR2,
223   X_INST_SORT_ORDER_3 in VARCHAR2,
224   X_REMIT_DOCUMENT_COUNT_LIMIT in NUMBER,
225   X_REMIT_ALLOW_MULTIPLE_COPY_FL in VARCHAR2,
226   X_INST_GROUP_BY_PAYMENT_DATE in VARCHAR2,
227   X_INST_GROUP_BY_PAYMENT_CURREN in VARCHAR2,
228   X_INST_GROUP_BY_INT_BANK_ACCT in VARCHAR2,
229   X_INST_GROUP_BY_MAX_PAYMENTS in VARCHAR2,
230   X_INST_GROUP_BY_PAY_SERVICE_RE in VARCHAR2,
231   X_DCL_ONLY_FOREIGN_CURR_PMT_FL in VARCHAR2,
232   X_DECLARATION_REPORT_FORMAT_CO in VARCHAR2,
233   X_DECLARATION_CURR_FX_RATE_TYP in VARCHAR2,
234   X_DECLARATION_CURRENCY_CODE in VARCHAR2,
235   X_DECLARATION_THRESHOLD_AMOUNT in NUMBER,
236   X_BANK_INSTRUCTION1_CODE in VARCHAR2,
237   X_BANK_INSTRUCTION2_CODE in VARCHAR2,
238   X_BANK_INSTRUCTION_DETAILS in VARCHAR2,
239   X_PAYMENT_TEXT_MESSAGE1 in VARCHAR2,
240   X_PAYMENT_TEXT_MESSAGE2 in VARCHAR2,
241   X_ACK_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
242   X_ACK_SECURITY_PROTOCOL_CODE in VARCHAR2,
243   X_SEND_TO_FILE_FLAG in VARCHAR2,
244   X_PI_REGISTER_FORMAT in VARCHAR2,
245   X_BEP_ACCOUNT_ID in NUMBER,
246   X_APPLICABLE_PMT_METHOD in VARCHAR2,
247   X_APPLICABLE_CURRENCY in VARCHAR2,
248   X_APPLICABLE_PAYER_ORG in VARCHAR2,
249   X_APPLICABLE_INT_BANK_ACCOUNT in VARCHAR2,
250   X_BEP_SUFFIX in VARCHAR2,
251   X_SECURITY_PROTOCOL_CODE in VARCHAR2,
252   X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
253   X_PAYMENT_FORMAT_CODE in VARCHAR2,
254   X_POSITIVE_PAY_FORMAT_CODE in VARCHAR2,
255   X_PAY_FILE_LETTER_FORMAT_CODE in VARCHAR2,
256   X_PRINT_INSTRUCTION_IMMED_FLAG in VARCHAR2,
257   X_PERIODIC_SEQUENCE_NAME_1 in VARCHAR2,
258   X_PERIODIC_SEQUENCE_NAME_2 in VARCHAR2,
259   X_PERIODIC_SEQUENCE_NAME_3 in VARCHAR2,
260   X_PROCESSING_TYPE in VARCHAR2,
261   X_MARK_COMPLETE_EVENT in VARCHAR2,
262   X_MANUAL_MARK_COMPLETE_FLAG in VARCHAR2,
263   X_DECLARATION_OPTION in VARCHAR2,
264   X_SYSTEM_PROFILE_NAME in VARCHAR2,
265   X_SYSTEM_PROFILE_DESCRIPTION in VARCHAR2,
266   X_LAST_UPDATE_DATE in DATE,
267   X_LAST_UPDATED_BY in NUMBER,
268   X_LAST_UPDATE_LOGIN in NUMBER,
269   X_ELECTRONIC_PROCESSING_CHNNL in VARCHAR2,
270   X_LOGICAL_GROUPING_MODE in VARCHAR2,
271   X_BATCH_BOOKING_FLAG in VARCHAR2,
272   X_INST_GROUP_BY_PAYMENT_METHOD in VARCHAR2
273  );
274 procedure DELETE_ROW (
275   X_SYSTEM_PROFILE_CODE in VARCHAR2
276 );
277 procedure ADD_LANGUAGE;
278 
279 procedure LOAD_ROW (
280   X_SYSTEM_PROFILE_CODE in VARCHAR2,
281   X_BEP_SUFFIX in VARCHAR2,
282   X_SECURITY_PROTOCOL_CODE in VARCHAR2,
283   X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
284   X_PAYMENT_FORMAT_CODE in VARCHAR2,
285   X_POSITIVE_PAY_FORMAT_CODE in VARCHAR2,
286   X_PAY_FILE_LETTER_FORMAT_CODE in VARCHAR2,
287   X_PRINT_INSTRUCTION_IMMED_FLAG in VARCHAR2,
288   X_PERIODIC_SEQUENCE_NAME_1 in VARCHAR2,
289   X_PERIODIC_SEQUENCE_NAME_2 in VARCHAR2,
290   X_PERIODIC_SEQUENCE_NAME_3 in VARCHAR2,
291   X_PROCESSING_TYPE in VARCHAR2,
292   X_MARK_COMPLETE_EVENT in VARCHAR2,
293   X_MANUAL_MARK_COMPLETE_FLAG in VARCHAR2,
294   X_POSITIVE_PAY_DELIVERY_FLAG in VARCHAR2,
295   X_TRANSMIT_INSTR_IMMED_FLAG in VARCHAR2,
296   X_AUTOMATIC_PI_REG_SUBMIT in VARCHAR2,
297   X_DECLARATION_OPTION in VARCHAR2,
298   X_DCL_ONLY_FOREIGN_CURR_PMT_FL in VARCHAR2,
299   X_DECLARATION_REPORT_FORMAT_CO in VARCHAR2,
300   X_DECLARATION_CURR_FX_RATE_TYP in VARCHAR2,
301   X_DECLARATION_CURRENCY_CODE in VARCHAR2,
302   X_DECLARATION_THRESHOLD_AMOUNT in NUMBER,
303   X_BANK_INSTRUCTION1_CODE in VARCHAR2,
304   X_BANK_INSTRUCTION2_CODE in VARCHAR2,
305   X_BANK_INSTRUCTION_DETAILS in VARCHAR2,
306   X_PAYMENT_TEXT_MESSAGE1 in VARCHAR2,
307   X_PAYMENT_TEXT_MESSAGE2 in VARCHAR2,
308   X_ACK_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
309   X_ACK_SECURITY_PROTOCOL_CODE in VARCHAR2,
310   X_SEND_TO_FILE_FLAG in VARCHAR2,
311   X_PI_REGISTER_FORMAT in VARCHAR2,
312   X_BEP_ACCOUNT_ID in NUMBER,
313   X_APPLICABLE_PMT_METHOD in VARCHAR2,
314   X_APPLICABLE_CURRENCY in VARCHAR2,
315   X_APPLICABLE_PAYER_ORG in VARCHAR2,
316   X_APPLICABLE_INT_BANK_ACCOUNT in VARCHAR2,
317   X_PMT_GROUP_BY_PAYMENT_DETAILS in VARCHAR2,
318   X_PMT_GROUP_BY_BANK_CHARGE_BEA in VARCHAR2,
319   X_PMT_GROUP_BY_DELIVERY_CHANNE in VARCHAR2,
320   X_PMT_GROUP_BY_REMITTANCE_MES in VARCHAR2,
321   X_PMT_GROUP_BY_MAX_DOCUMENTS in VARCHAR2,
322   X_PMT_GROUP_BY_UNIQUE_REMIT_ID in VARCHAR2,
323   X_PMT_GROUP_BY_SETTLE_PRIORITY in VARCHAR2,
324   X_PMT_GROUP_BY_PAYMENT_REASON in VARCHAR2,
325   X_PMT_GROUP_BY_DUE_DATE_FLAG in VARCHAR2,
326   X_PMT_MAX_DOCUMENTS_PER_PAYMEN in NUMBER,
327   X_PMT_PAYMENT_DETAILS_LENGTH_L in NUMBER,
328   X_PMT_PAYMENT_DETAILS_FORMULA in VARCHAR2,
329   X_INST_GROUP_BY_PAYMENT_DATE in VARCHAR2,
330   X_INST_GROUP_BY_PAYMENT_CURREN in VARCHAR2,
331   X_INST_GROUP_BY_INT_BANK_ACCT in VARCHAR2,
332   X_INST_GROUP_BY_MAX_PAYMENTS in VARCHAR2,
333   X_INST_GROUP_BY_PAY_SERVICE_RE in VARCHAR2,
334   X_INST_GROUP_BY_LEGAL_ENTITY in VARCHAR2,
335   X_INST_GROUP_BY_BILL_PAYABLE in VARCHAR2,
336   X_INST_GROUP_BY_MAX_INSTRUCTIO in VARCHAR2,
337   X_INST_GROUP_BY_ORGANIZATION in VARCHAR2,
338   X_INST_GROUP_BY_PAYMENT_FUNCTI in VARCHAR2,
339   X_INST_GROUP_BY_PAYMENT_REASON in VARCHAR2,
340   X_INST_GROUP_BY_RFC in VARCHAR2,
341   X_INST_MAX_PAYMENTS_PER_INSTR in NUMBER,
342   X_INST_MAX_AMOUNT_PER_INSTR_VA in NUMBER,
343   X_INST_MAX_AMOUNT_PER_INSTR_CU in VARCHAR2,
344   X_INST_MAX_AMOUNT_FX_RATE_TYPE in VARCHAR2,
345   X_INST_SORT_OPTION_1 in VARCHAR2,
346   X_INST_SORT_ORDER_1 in VARCHAR2,
347   X_INST_SORT_OPTION_2 in VARCHAR2,
348   X_INST_SORT_ORDER_2 in VARCHAR2,
349   X_INST_SORT_OPTION_3 in VARCHAR2,
350   X_INST_SORT_ORDER_3 in VARCHAR2,
351   X_REMIT_DOCUMENT_COUNT_LIMIT in NUMBER,
352   X_REMIT_ALLOW_MULTIPLE_COPY_FL in VARCHAR2,
353   X_REMIT_PMT_DETAILS_LENGTH_LIM in NUMBER,
354   X_REMIT_REMITTANCE_ADVICE_FORM in VARCHAR2,
355   X_REMIT_SRA_OVERRIDE_PAYEE_FLA in VARCHAR2,
356   X_REMIT_ADVICE_DELIVERY_METHOD in VARCHAR2,
357   X_REMIT_AUTOMATIC_SRA_SUBMIT in VARCHAR2,
358   X_SYSTEM_PROFILE_NAME in VARCHAR2,
359   X_SYSTEM_PROFILE_DESCRIPTION in VARCHAR2,
360   X_CREATION_DATE in DATE,
361   X_CREATED_BY in NUMBER,
362   X_LAST_UPDATE_DATE in DATE,
363   X_LAST_UPDATED_BY in NUMBER,
364   X_LAST_UPDATE_LOGIN in NUMBER,
365   X_OBJECT_VERSION_NUMBER in NUMBER,
366   X_ELECTRONIC_PROCESSING_CHNNL in VARCHAR2,
367   X_LOGICAL_GROUPING_MODE in VARCHAR2,
368   X_BATCH_BOOKING_FLAG in VARCHAR2,
369   X_INST_GROUP_BY_PAYMENT_METHOD in VARCHAR2
370   );
371 
372 procedure TRANSLATE_ROW (
373   X_SYSTEM_PROFILE_CODE in VARCHAR2,
374   X_SYSTEM_PROFILE_NAME in VARCHAR2,
375   X_SYSTEM_PROFILE_DESCRIPTION in VARCHAR2,
376   X_LAST_UPDATE_DATE in DATE,
377   X_LAST_UPDATED_BY in NUMBER,
378   X_LAST_UPDATE_LOGIN in NUMBER);
379 
380 end IBY_UPG_PPP_PKG;