DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on AR_PAYMENT_SCHEDULES

Line 270: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

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,

Line 271: p_trx_date_h IN ar_payment_schedules.trx_date%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,

Line 272: p_due_date_l IN ar_payment_schedules.due_date%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,

Line 273: p_due_date_h IN ar_payment_schedules.due_date%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,

Line 274: p_trx_num_l IN ar_payment_schedules.trx_number%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

Line 275: p_trx_num_h IN ar_payment_schedules.trx_number%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
279: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 319: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

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,

Line 322: p_due_date IN ar_payment_schedules.due_date%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,
324: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
325: p_exception_code IN VARCHAR2,
326: p_additional_message IN VARCHAR2