DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on AR_CASH_RECEIPTS

Line 103: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

99:
100:
101: PROCEDURE insert_batch(
102: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
103: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
104: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

Line 105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

101: PROCEDURE insert_batch(
102: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
103: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
104: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
108: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
109: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

Line 106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

102: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
103: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
104: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
108: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
109: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
110: p_batch_id OUT NOCOPY NUMBER

Line 107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

103: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
104: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
108: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
109: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
110: p_batch_id OUT NOCOPY NUMBER
111: );

Line 108: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

104: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
108: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
109: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
110: p_batch_id OUT NOCOPY NUMBER
111: );
112:

Line 109: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

105: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
106: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
107: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
108: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
109: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
110: p_batch_id OUT NOCOPY NUMBER
111: );
112:
113:

Line 155: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_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,
159: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,

Line 196: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

192: | 16-JUL-2005 bichatte Created |
193: *=========================================================================*/
194:
195: PROCEDURE group_val_create_receipts(
196: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
197: p_batch_id IN ar_batches.batch_id%TYPE
198: );
199:
200:

Line 224: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,

220: | 16-JUL-2005 bichatte Created |
221: *=========================================================================*/
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,

Line 225: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

221: *=========================================================================*/
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,

Line 227: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

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,
231: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,

Line 228: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_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,
231: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
232: p_exception_code IN VARCHAR2,

Line 262: p_request_id ar_cash_receipts.request_id%TYPE

258: *=========================================================================*/
259:
260: PROCEDURE SUBMIT_REPORT (
261: p_batch_id ar_batches.batch_id%TYPE,
262: p_request_id ar_cash_receipts.request_id%TYPE
263: );
264:
265:
266: