DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_CASH_RECEIPTS

Line 170: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

166: *=========================================================================*/
167:
168:
169: PROCEDURE insert_batch(
170: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
171: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
172: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
174: p_currency_code IN ar_batches.currency_code%TYPE,

Line 172: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

168:
169: PROCEDURE insert_batch(
170: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
171: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
172: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
174: p_currency_code IN ar_batches.currency_code%TYPE,
175: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
176: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,

Line 173: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

169: PROCEDURE insert_batch(
170: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
171: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
172: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
174: p_currency_code IN ar_batches.currency_code%TYPE,
175: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
176: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
177: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 272: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,

268: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
269: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
270: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
271: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
272: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
273: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
274: p_batch_id IN ar_batches.batch_id%TYPE,
275: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
276: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 273: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,

269: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
270: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
271: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
272: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
273: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
274: p_batch_id IN ar_batches.batch_id%TYPE,
275: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
276: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
277: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,

Line 276: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

272: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
273: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
274: p_batch_id IN ar_batches.batch_id%TYPE,
275: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
276: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
277: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
278: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
279: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
280: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,

Line 278: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,

274: p_batch_id IN ar_batches.batch_id%TYPE,
275: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
276: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
277: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
278: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
279: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
280: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
281: p_return_status OUT NOCOPY VARCHAR2
282: );

Line 280: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,

276: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
277: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
278: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
279: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
280: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
281: p_return_status OUT NOCOPY VARCHAR2
282: );
283:
284:

Line 369: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,

365: | 16-JUL-2005 bichatte Created |
366: *=========================================================================*/
367: PROCEDURE insert_exceptions(
368: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
369: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
370: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
371: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
372: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
373: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,

Line 370: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

366: *=========================================================================*/
367: PROCEDURE insert_exceptions(
368: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
369: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
370: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
371: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
372: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
373: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
374: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

Line 372: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

368: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
369: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
370: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
371: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
372: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
373: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
374: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
375: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
376: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,

Line 373: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,

369: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
370: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
371: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
372: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
373: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
374: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
375: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
376: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
377: p_exception_code IN VARCHAR2,

Line 406: p_request_id ar_cash_receipts.request_id%TYPE

402: *=========================================================================*/
403:
404: PROCEDURE SUBMIT_REPORT (
405: p_batch_id ar_batches.batch_id%TYPE,
406: p_request_id ar_cash_receipts.request_id%TYPE
407: );
408:
409:
410: PROCEDURE rec_reset ( p_request_id NUMBER