76: p_format_flag IN VARCHAR2,
77: p_batch_id IN ar_batches.batch_id%TYPE,
78: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
79: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
80: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
81: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
82: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
83: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
84: p_document_number_low IN NUMBER,
77: p_batch_id IN ar_batches.batch_id%TYPE,
78: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
79: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
80: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
81: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
82: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
83: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
84: p_document_number_low IN NUMBER,
85: p_document_number_high IN NUMBER,
78: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
79: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
80: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
81: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
82: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
83: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
84: p_document_number_low IN NUMBER,
85: p_document_number_high IN NUMBER,
86: p_customer_number_low IN hz_cust_accounts.account_number%TYPE,
79: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
80: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
81: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
82: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
83: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
84: p_document_number_low IN NUMBER,
85: p_document_number_high IN NUMBER,
86: p_customer_number_low IN hz_cust_accounts.account_number%TYPE,
87: p_customer_number_high IN hz_cust_accounts.account_number%TYPE,
100: p_bank_account_low IN VARCHAR2,
101: p_bank_account_high IN VARCHAR2 );
102:
103: PROCEDURE add_or_rm_txn_from_auto_batch(
104: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
105: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
106: p_selected_for_rec_batch_id IN
107: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
108: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
104: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
105: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
106: p_selected_for_rec_batch_id IN
107: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
108: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
109: p_customer_bank_account_id IN
110: ra_customer_trx.customer_bank_account_id%TYPE,
111: p_module_name IN VARCHAR2,
112: p_module_version IN VARCHAR2 );
106: p_selected_for_rec_batch_id IN
107: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
108: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
109: p_customer_bank_account_id IN
110: ra_customer_trx.customer_bank_account_id%TYPE,
111: p_module_name IN VARCHAR2,
112: p_module_version IN VARCHAR2 );
113:
114: ----------------- Private functions/procedures ------------------