eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CASHBOOK dependencies on AR_BATCHES

Line 2091: P_BATCH_ID IN ar_batches.batch_id%TYPE,

2087: END debit_memo_reversal;
2088:
2089:
2090: PROCEDURE Lock_Row(
2091: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,

Line 2094: P_NAME IN ar_batches.name%TYPE,

2090: PROCEDURE Lock_Row(
2091: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,

Line 2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,

2091: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,

Line 2096: P_GL_DATE IN ar_batches.gl_date%TYPE,

2092: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,

Line 2097: P_STATUS IN ar_batches.status%TYPE,

2093: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,

Line 2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,

2094: P_NAME IN ar_batches.name%TYPE,
2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,

Line 2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,

2095: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,

Line 2100: P_TYPE IN ar_batches.type%TYPE,

2096: P_GL_DATE IN ar_batches.gl_date%TYPE,
2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,

Line 2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,

2097: P_STATUS IN ar_batches.status%TYPE,
2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,

Line 2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,

2098: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,

Line 2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,

2099: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,

Line 2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,

2100: P_TYPE IN ar_batches.type%TYPE,
2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,

Line 2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,

2101: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,

Line 2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,

2102: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,

Line 2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,

2103: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,

Line 2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,

2104: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,

Line 2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,

2105: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,

Line 2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,

2106: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,

Line 2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,

2107: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,

Line 2112: P_COMMENTS IN ar_batches.comments%TYPE,

2108: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,

Line 2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,

2109: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,

Line 2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,

2110: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,

Line 2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,

2111: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,

Line 2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,

2112: P_COMMENTS IN ar_batches.comments%TYPE,
2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,

Line 2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,

2113: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,

Line 2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,

2114: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,

Line 2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,

2115: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,

Line 2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,

2116: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,

Line 2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,

2117: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,

Line 2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,

2118: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,

Line 2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,

2119: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,

2120: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,

Line 2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,

2121: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,

Line 2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,

2122: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,

Line 2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,

2123: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,

Line 2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,

2124: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,

Line 2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,

2125: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,

Line 2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,

2126: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,

Line 2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,

2127: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,

Line 2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,

2128: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,

Line 2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,

2129: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,

Line 2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,

2130: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,

Line 2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,

2131: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,

Line 2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,

2132: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,

Line 2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,

2133: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,

Line 2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,

2134: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2142: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)

Line 2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,

2135: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2142: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2143: IS

Line 2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,

2136: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2142: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2143: IS
2144:

Line 2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,

2137: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2142: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2143: IS
2144:
2145: CURSOR C IS

Line 2142: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)

2138: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2139: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2140: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2141: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2142: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2143: IS
2144:
2145: CURSOR C IS
2146: SELECT crh.cash_receipt_history_id

Line 2155: FROM ar_batches

2151: FOR UPDATE NOWAIT;
2152:
2153: CURSOR BATCH IS
2154: SELECT *
2155: FROM ar_batches
2156: WHERE batch_id = P_BATCH_ID
2157: FOR UPDATE NOWAIT;
2158:
2159: Recinfo C%ROWTYPE;

Line 2161: c_batch_id ar_batches.batch_id%TYPE;

2157: FOR UPDATE NOWAIT;
2158:
2159: Recinfo C%ROWTYPE;
2160: Batchinfo BATCH%ROWTYPE;
2161: c_batch_id ar_batches.batch_id%TYPE;
2162: c_amount ar_cash_receipt_history.amount%TYPE;
2163: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2164:
2165: BEGIN