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 2524: P_BATCH_ID IN ar_batches.batch_id%TYPE,

2520: END debit_memo_reversal;
2521:
2522:
2523: PROCEDURE Lock_Row(
2524: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,

Line 2527: P_NAME IN ar_batches.name%TYPE,

2523: PROCEDURE Lock_Row(
2524: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,

Line 2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,

2524: P_BATCH_ID IN ar_batches.batch_id%TYPE,
2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,

Line 2529: P_GL_DATE IN ar_batches.gl_date%TYPE,

2525: P_AMOUNT IN ar_cash_receipt_history.amount%TYPE,
2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,

Line 2530: P_STATUS IN ar_batches.status%TYPE,

2526: P_ACCTD_AMOUNT IN ar_cash_receipt_history.acctd_amount%TYPE,
2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,

Line 2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,

2527: P_NAME IN ar_batches.name%TYPE,
2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,

Line 2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,

2528: P_BATCH_DATE IN ar_batches.batch_date%TYPE,
2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,

Line 2533: P_TYPE IN ar_batches.type%TYPE,

2529: P_GL_DATE IN ar_batches.gl_date%TYPE,
2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,

Line 2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,

2530: P_STATUS IN ar_batches.status%TYPE,
2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,

Line 2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,

2531: P_DEPOSIT_DATE IN ar_batches.deposit_date%TYPE,
2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,

Line 2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,

2532: P_CLOSED_DATE IN ar_batches.closed_date%TYPE,
2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,

Line 2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,

2533: P_TYPE IN ar_batches.type%TYPE,
2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,

Line 2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,

2534: P_BATCH_SOURCE_ID IN ar_batches.batch_source_id%TYPE,
2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,

Line 2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,

2535: P_CONTROL_COUNT IN ar_batches.control_count%TYPE,
2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,

Line 2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,

2536: P_CONTROL_AMOUNT IN ar_batches.control_amount%TYPE,
2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,

Line 2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,

2537: P_BATCH_APPLIED_STATUS IN ar_batches.batch_applied_status%TYPE,
2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,

Line 2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,

2538: P_CURRENCY_CODE IN ar_batches.currency_code%TYPE,
2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,

Line 2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,

2539: P_EXCHANGE_RATE_TYPE IN ar_batches.exchange_rate_type%TYPE,
2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,

Line 2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,

2540: P_EXCHANGE_DATE IN ar_batches.exchange_date%TYPE,
2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,

Line 2545: P_COMMENTS IN ar_batches.comments%TYPE,

2541: P_EXCHANGE_RATE IN ar_batches.exchange_rate%TYPE,
2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,

Line 2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,

2542: P_TRANSMISSION_REQUEST_ID IN ar_batches.transmission_request_id%TYPE,
2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,

Line 2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,

2543: P_LOCKBOX_ID IN ar_batches.lockbox_id%TYPE,
2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,

Line 2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,

2544: P_LOCKBOX_BATCH_NAME IN ar_batches.lockbox_batch_name%TYPE,
2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,

Line 2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,

2545: P_COMMENTS IN ar_batches.comments%TYPE,
2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,

Line 2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,

2546: P_ATTRIBUTE_CATEGORY IN ar_batches.attribute_category%TYPE,
2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,

Line 2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,

2547: P_ATTRIBUTE1 IN ar_batches.attribute1%TYPE,
2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,

Line 2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,

2548: P_ATTRIBUTE2 IN ar_batches.attribute2%TYPE,
2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,

Line 2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,

2549: P_ATTRIBUTE3 IN ar_batches.attribute3%TYPE,
2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,

Line 2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,

2550: P_ATTRIBUTE4 IN ar_batches.attribute4%TYPE,
2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,

Line 2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,

2551: P_ATTRIBUTE5 IN ar_batches.attribute5%TYPE,
2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,

Line 2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,

2552: P_ATTRIBUTE6 IN ar_batches.attribute6%TYPE,
2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,

Line 2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,

2553: P_ATTRIBUTE7 IN ar_batches.attribute7%TYPE,
2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,

Line 2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,

2554: P_ATTRIBUTE8 IN ar_batches.attribute8%TYPE,
2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,

Line 2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,

2555: P_ATTRIBUTE9 IN ar_batches.attribute9%TYPE,
2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,

Line 2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,

2556: P_ATTRIBUTE10 IN ar_batches.attribute10%TYPE,
2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,

Line 2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,

2557: P_MEDIA_REFERENCE IN ar_batches.media_reference%TYPE,
2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,

Line 2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,

2558: P_OPERATION_REQUEST_ID IN ar_batches.operation_request_id%TYPE,
2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,

Line 2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,

2559: P_RECEIPT_METHOD_ID IN ar_batches.receipt_method_id%TYPE,
2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,

Line 2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,

2560: P_REMITTANCE_BANK_ACCOUNT_ID IN ar_batches.remit_bank_acct_use_id%TYPE,
2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,

Line 2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,

2561: P_RECEIPT_CLASS_ID IN ar_batches.receipt_class_id%TYPE,
2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,

Line 2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,

2562: P_ATTRIBUTE11 IN ar_batches.attribute11%TYPE,
2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,

Line 2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,

2563: P_ATTRIBUTE12 IN ar_batches.attribute12%TYPE,
2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,

Line 2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,

2564: P_ATTRIBUTE13 IN ar_batches.attribute13%TYPE,
2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,

Line 2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,

2565: P_ATTRIBUTE14 IN ar_batches.attribute14%TYPE,
2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,

Line 2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,

2566: P_ATTRIBUTE15 IN ar_batches.attribute15%TYPE,
2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,

Line 2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,

2567: P_PROGRAM_APPLICATION_ID IN ar_batches.program_application_id%TYPE,
2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2575: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)

Line 2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,

2568: P_PROGRAM_ID IN ar_batches.program_id%TYPE,
2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2575: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2576: IS

Line 2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,

2569: P_PROGRAM_UPDATE_DATE IN ar_batches.program_update_date%TYPE,
2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2575: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2576: IS
2577:

Line 2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,

2570: P_REMITTANCE_BANK_BRANCH_ID IN ar_batches.remittance_bank_branch_id%TYPE,
2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2575: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2576: IS
2577:
2578: CURSOR C IS

Line 2575: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)

2571: P_REMIT_METHOD_CODE IN ar_batches.remit_method_code%TYPE,
2572: P_REQUEST_ID IN ar_batches.request_id%TYPE,
2573: P_SET_OF_BOOKS_ID IN ar_batches.set_of_books_id%TYPE,
2574: P_TRANSMISSION_ID IN ar_batches.transmission_id%TYPE,
2575: P_BANK_DEPOSIT_NUMBER IN ar_batches.bank_deposit_number%TYPE)
2576: IS
2577:
2578: CURSOR C IS
2579: SELECT crh.cash_receipt_history_id

Line 2588: FROM ar_batches

2584: FOR UPDATE NOWAIT;
2585:
2586: CURSOR BATCH IS
2587: SELECT *
2588: FROM ar_batches
2589: WHERE batch_id = P_BATCH_ID
2590: FOR UPDATE NOWAIT;
2591:
2592: Recinfo C%ROWTYPE;

Line 2594: c_batch_id ar_batches.batch_id%TYPE;

2590: FOR UPDATE NOWAIT;
2591:
2592: Recinfo C%ROWTYPE;
2593: Batchinfo BATCH%ROWTYPE;
2594: c_batch_id ar_batches.batch_id%TYPE;
2595: c_amount ar_cash_receipt_history.amount%TYPE;
2596: c_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2597:
2598: BEGIN