266: | 16-JUL-2005 bichatte Created |
267: *=========================================================================*/
268:
269: PROCEDURE select_valid_invoices(
270: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
271: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
267: *=========================================================================*/
268:
269: PROCEDURE select_valid_invoices(
270: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
271: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
275: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
268:
269: PROCEDURE select_valid_invoices(
270: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
271: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
275: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
276: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
269: PROCEDURE select_valid_invoices(
270: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
271: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
275: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
276: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
277: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
270: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
271: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
275: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
276: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
277: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
278: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
271: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
272: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
273: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
274: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
275: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
276: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
277: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
278: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
279: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
315: PROCEDURE insert_exceptions(
316: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
317: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
318: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
319: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
320: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
321: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
322: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
323: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
318: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
319: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
320: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
321: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
322: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
323: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
324: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
325: p_exception_code IN VARCHAR2,
326: p_additional_message IN VARCHAR2