DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_REMIT_REFS

Line 111: remit_reference_id AR_CASH_REMIT_REFS.remit_reference_id%TYPE,

107: );
108: TYPE pmt_rec_tab IS TABLE OF pmt_rec_record INDEX BY BINARY_INTEGER;
109:
110: TYPE selected_recos IS RECORD(
111: remit_reference_id AR_CASH_REMIT_REFS.remit_reference_id%TYPE,
112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,
113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE,
114: ref_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,

Line 112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,

108: TYPE pmt_rec_tab IS TABLE OF pmt_rec_record INDEX BY BINARY_INTEGER;
109:
110: TYPE selected_recos IS RECORD(
111: remit_reference_id AR_CASH_REMIT_REFS.remit_reference_id%TYPE,
112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,
113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE,
114: ref_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,
116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,

Line 113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE,

109:
110: TYPE selected_recos IS RECORD(
111: remit_reference_id AR_CASH_REMIT_REFS.remit_reference_id%TYPE,
112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,
113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE,
114: ref_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,
116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,
117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,

Line 114: ref_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,

110: TYPE selected_recos IS RECORD(
111: remit_reference_id AR_CASH_REMIT_REFS.remit_reference_id%TYPE,
112: ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE,
113: ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE,
114: ref_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
115: cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE,
116: pay_from_customer AR_CASH_RECEIPTS.pay_from_customer%TYPE,
117: cr_customer_site_use_id AR_CASH_RECEIPTS.customer_site_use_id%TYPE,
118: customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE,

Line 132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,

128: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
129: discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE,
130: discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE,
131: amount_applied AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
132: trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE,
133: amount_applied_from AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
134: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
135: cons_inv_id AR_CASH_RECOS.cons_inv_id%TYPE,
136: match_score_value AR_CASH_RECOS.match_score_value%TYPE,

Line 232: TYPE line_num_tab IS TABLE OF ar_cash_remit_refs.line_number%TYPE

228: TYPE ussgl_trx_code_tab IS TABLE OF ar_payments_interface.ussgl_transaction_code1%TYPE
229: INDEX BY BINARY_INTEGER;
230: TYPE inv_status_tab IS TABLE OF ar_payments_interface.invoice1_status%TYPE
231: INDEX BY BINARY_INTEGER;
232: TYPE line_num_tab IS TABLE OF ar_cash_remit_refs.line_number%TYPE
233: INDEX BY BINARY_INTEGER;
234:
235: /* * This procedure is called from the concurrent request. This in turns *
236: * spawns the child program if submitted with total_workers > 1. * */

Line 270: FUNCTION get_cross_curr_rate(p_amount_applied IN ar_cash_remit_refs.amount_applied%TYPE

266: /* * This function returns a new sequence number * */
267: FUNCTION get_next_reco_id( p_reco_num IN NUMBER)
268: RETURN NUMBER;
269:
270: FUNCTION get_cross_curr_rate(p_amount_applied IN ar_cash_remit_refs.amount_applied%TYPE
271: , p_amount_applied_from IN ar_cash_remit_refs.amount_applied_from%TYPE
272: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE
273: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)
274: RETURN NUMBER;

Line 271: , p_amount_applied_from IN ar_cash_remit_refs.amount_applied_from%TYPE

267: FUNCTION get_next_reco_id( p_reco_num IN NUMBER)
268: RETURN NUMBER;
269:
270: FUNCTION get_cross_curr_rate(p_amount_applied IN ar_cash_remit_refs.amount_applied%TYPE
271: , p_amount_applied_from IN ar_cash_remit_refs.amount_applied_from%TYPE
272: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE
273: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)
274: RETURN NUMBER;
275: