eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_AUTOREC_API dependencies on AR_PAYMENT_SCHEDULES

Line 138: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

134: | 16-JUL-2005 bichatte Created |
135: *=========================================================================*/
136:
137: PROCEDURE select_valid_invoices(
138: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

Line 139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

135: *=========================================================================*/
136:
137: PROCEDURE select_valid_invoices(
138: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
143: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

Line 140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

136:
137: PROCEDURE select_valid_invoices(
138: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
143: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
144: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,

Line 141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

137: PROCEDURE select_valid_invoices(
138: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
143: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
144: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
145: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,

Line 142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

138: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
143: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
144: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
145: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
146: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 143: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

139: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
140: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
141: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
142: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
143: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
144: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
145: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
146: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
147: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 153: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,

149: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
150: p_batch_id IN ar_batches.batch_id%TYPE,
151: p_approve_only_flag IN VARCHAR2 DEFAULT NULL,--Bug 5344405
152: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
153: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
154: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
155: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
156: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
157: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

Line 154: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,

150: p_batch_id IN ar_batches.batch_id%TYPE,
151: p_approve_only_flag IN VARCHAR2 DEFAULT NULL,--Bug 5344405
152: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
153: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
154: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
155: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
156: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
157: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
158: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,

Line 156: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,

152: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
153: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
154: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
155: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
156: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
157: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
158: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
159: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
160: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,

Line 159: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,

155: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
156: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
157: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
158: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
159: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
160: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
161: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
162: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
163: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,

Line 160: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,

156: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
157: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
158: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
159: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
160: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
161: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
162: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
163: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,
164: p_payment_channel_code OUT NOCOPY ar_receipt_methods.payment_channel_code%TYPE,

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

222: PROCEDURE insert_exceptions(
223: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
224: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
225: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
226: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
227: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
228: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
229: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
230: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,

Line 229: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

225: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
226: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
227: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
228: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
229: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
230: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
231: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
232: p_exception_code IN VARCHAR2,
233: p_additional_message IN VARCHAR2