DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_PAYMENT_SCHEDULES

Line 266: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

262:
263: PROCEDURE select_update_rec(
264: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
265: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
266: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
267: p_trx_date_h IN ar_payment_schedules.trx_date%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,

Line 267: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

263: PROCEDURE select_update_rec(
264: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
265: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
266: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
267: p_trx_date_h IN ar_payment_schedules.trx_date%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,

Line 268: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

264: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
265: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
266: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
267: p_trx_date_h IN ar_payment_schedules.trx_date%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,

Line 269: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

265: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
266: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
267: p_trx_date_h IN ar_payment_schedules.trx_date%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,

Line 270: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

266: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
267: p_trx_date_h IN ar_payment_schedules.trx_date%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,

Line 271: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

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

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

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,
375: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,

Line 374: p_due_date IN ar_payment_schedules.due_date%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,
378: p_additional_message IN VARCHAR2