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 269: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,

265: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
266: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
267: p_customer_name_l IN hz_parties.party_name%type,
268: p_customer_name_h IN hz_parties.party_name%type,
269: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
270: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
271: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
272: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
273: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

Line 270: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,

266: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
267: p_customer_name_l IN hz_parties.party_name%type,
268: p_customer_name_h IN hz_parties.party_name%type,
269: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
270: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
271: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
272: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
273: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
274: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

Line 277: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,

273: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
274: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
275: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
276: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
277: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
278: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
279: p_batch_id IN ar_batches.batch_id%TYPE,
280: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
281: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 278: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,

274: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
275: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
276: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
277: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
278: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
279: p_batch_id IN ar_batches.batch_id%TYPE,
280: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
281: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
282: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,

Line 281: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

277: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
278: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
279: p_batch_id IN ar_batches.batch_id%TYPE,
280: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
281: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
282: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
283: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
284: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
285: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,

Line 283: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,

279: p_batch_id IN ar_batches.batch_id%TYPE,
280: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
281: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
282: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
283: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
284: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
285: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
286: p_return_status OUT NOCOPY VARCHAR2
287: );

Line 285: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,

281: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
282: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
283: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
284: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
285: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
286: p_return_status OUT NOCOPY VARCHAR2
287: );
288:
289:

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

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

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

371: *=========================================================================*/
372: PROCEDURE insert_exceptions(
373: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
374: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
375: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
376: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
377: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
378: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
379: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

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

373: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
374: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
375: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
376: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
377: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
378: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
379: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
380: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
381: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,

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

374: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
375: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
376: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
377: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
378: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
379: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
380: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
381: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
382: p_exception_code IN VARCHAR2,

Line 411: p_request_id ar_cash_receipts.request_id%TYPE

407: *=========================================================================*/
408:
409: PROCEDURE SUBMIT_REPORT (
410: p_batch_id ar_batches.batch_id%TYPE,
411: p_request_id ar_cash_receipts.request_id%TYPE
412: );
413:
414:
415: PROCEDURE rec_reset ( p_request_id NUMBER