132: p_module_name IN VARCHAR2,
133: p_module_version IN VARCHAR2);
134:
135: PROCEDURE Lock_Row(
136: P_BATCH_ID IN ar_batches.batch_id%TYPE,
137: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
138: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
139: P_NAME IN ar_batches.name%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
135: PROCEDURE Lock_Row(
136: P_BATCH_ID IN ar_batches.batch_id%TYPE,
137: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
138: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
139: P_NAME IN ar_batches.name%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
136: P_BATCH_ID IN ar_batches.batch_id%TYPE,
137: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
138: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
139: P_NAME IN ar_batches.name%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
137: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
138: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
139: P_NAME IN ar_batches.name%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
138: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
139: P_NAME IN ar_batches.name%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
139: P_NAME IN ar_batches.name%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
140: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
141: P_GL_DATE IN ar_batches.gl_date%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
142: P_STATUS IN ar_batches.status%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
143: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
144: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
145: P_TYPE IN ar_batches.type%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
147: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
148: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
150: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
152: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
155: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
157: P_COMMENTS IN ar_batches.comments%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
159: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
160: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
161: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
162: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
163: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
164: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
165: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
166: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
167: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
168: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
169: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
174: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
175: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
176: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
177: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
178: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
186: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
186: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
187: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE
180: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
186: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
187: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE
188: );
181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
186: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
187: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE
188: );
189:
182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
186: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
187: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE
188: );
189:
190: FUNCTION receipt_debit_memo_reversed( p_cash_receipt_id IN NUMBER)
183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
184: P_REQUEST_ID IN ar_batches.request_id%TYPE,
185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
186: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
187: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE
188: );
189:
190: FUNCTION receipt_debit_memo_reversed( p_cash_receipt_id IN NUMBER)
191: RETURN VARCHAR2;