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,
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,
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
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: );
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:
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:
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,
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:
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,
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,
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,
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,
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: