DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on AR_BATCHES

Line 136: P_BATCH_ID IN ar_batches.batch_id%TYPE,

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,

Line 139: P_NAME IN ar_batches.name%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,

Line 140: P_BATCH_DATE IN ar_batches.batch_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,

Line 141: P_GL_DATE IN ar_batches.gl_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,

Line 142: P_STATUS IN ar_batches.status%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,

Line 143: P_DEPOSIT_DATE IN ar_batches.deposit_date%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,

Line 144: P_CLOSED_DATE IN ar_batches.closed_date%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,

Line 145: P_TYPE IN ar_batches.type%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,

Line 146: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%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,

Line 147: P_CONTROL_COUNT IN ar_batches.control_count%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,

Line 148: P_CONTROL_AMOUNT IN ar_batches.control_amount%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,

Line 149: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%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,

Line 150: P_CURRENCY_CODE IN ar_batches.currency_code%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,

Line 151: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%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,

Line 152: P_EXCHANGE_DATE IN ar_batches.exchange_date%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,

Line 153: P_EXCHANGE_RATE IN ar_batches.exchange_rate%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,

Line 154: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%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,

Line 155: P_LOCKBOX_ID IN ar_batches.lockbox_id%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,

Line 156: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%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,

Line 157: P_COMMENTS IN ar_batches.comments%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,

Line 158: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%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,

Line 159: P_ATTRIBUTE1 IN ar_batches.attribute1%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,

Line 160: P_ATTRIBUTE2 IN ar_batches.attribute2%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,

Line 161: P_ATTRIBUTE3 IN ar_batches.attribute3%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,

Line 162: P_ATTRIBUTE4 IN ar_batches.attribute4%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,

Line 163: P_ATTRIBUTE5 IN ar_batches.attribute5%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,

Line 164: P_ATTRIBUTE6 IN ar_batches.attribute6%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,

Line 165: P_ATTRIBUTE7 IN ar_batches.attribute7%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,

Line 166: P_ATTRIBUTE8 IN ar_batches.attribute8%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,

Line 167: P_ATTRIBUTE9 IN ar_batches.attribute9%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,

Line 168: P_ATTRIBUTE10 IN ar_batches.attribute10%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,

Line 169: P_MEDIA_REFERENCE IN ar_batches.media_reference%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,

Line 170: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_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,

Line 171: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%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,

Line 172: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%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,

Line 173: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%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,

Line 174: P_ATTRIBUTE11 IN ar_batches.attribute11%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,

Line 175: P_ATTRIBUTE12 IN ar_batches.attribute12%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,

Line 176: P_ATTRIBUTE13 IN ar_batches.attribute13%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,

Line 177: P_ATTRIBUTE14 IN ar_batches.attribute14%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,

Line 178: P_ATTRIBUTE15 IN ar_batches.attribute15%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,

Line 179: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_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,

Line 180: P_PROGRAM_ID IN ar_batches.program_id%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,

Line 181: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%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,

Line 182: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_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,

Line 183: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%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

Line 184: P_REQUEST_ID IN ar_batches.request_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
188: );

Line 185: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_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: );
189:

Line 186: P_TRANSMISSION_ID IN ar_batches.transmission_id%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:
190: FUNCTION receipt_debit_memo_reversed( p_cash_receipt_id IN NUMBER)

Line 187: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%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)
191: RETURN VARCHAR2;