162: global_attribute19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
163: global_attribute20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR);
164:
165: TYPE apply_out_rec_type IS RECORD
166: (receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
167: );
168: attribute_rec_const attribute_rec_type;
169: global_attribute_rec_const global_attribute_rec_type;
170:
172: apply_out_rec apply_out_rec_type;
173:
174: --Bug 3628401
175: TYPE apply_on_account_rec_type IS RECORD
176: (receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
177: );
178: g_apply_on_account_out_rec apply_on_account_rec_type;
179:
180:
189: customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
194: line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
195: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
196: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL
197: );
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
194: line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
195: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
196: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL
197: );
198: TYPE G_create_cash_rec_type IS RECORD
199: ( customer_id hz_cust_accounts.cust_account_id%TYPE,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
193: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
194: line_number ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
195: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
196: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL
197: );
198: TYPE G_create_cash_rec_type IS RECORD
199: ( customer_id hz_cust_accounts.cust_account_id%TYPE,
200: customer_name hz_parties.party_name%TYPE,
212: receipt_method_name ar_receipt_methods.name%TYPE
213: );
214: TYPE G_unapp_rec_type IS RECORD
215: (trx_number ra_customer_trx.trx_number%TYPE,
216: customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
213: );
214: TYPE G_unapp_rec_type IS RECORD
215: (trx_number ra_customer_trx.trx_number%TYPE,
216: customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
214: TYPE G_unapp_rec_type IS RECORD
215: (trx_number ra_customer_trx.trx_number%TYPE,
216: customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
216: customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223: receipt_number ar_cash_receipts.receipt_number%TYPE,
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223: receipt_number ar_cash_receipts.receipt_number%TYPE,
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225: TYPE G_activity_unapp_rec IS RECORD
226: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223: receipt_number ar_cash_receipts.receipt_number%TYPE,
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225: TYPE G_activity_unapp_rec IS RECORD
226: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
227: receipt_number ar_cash_receipts.receipt_number%TYPE,
228: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223: receipt_number ar_cash_receipts.receipt_number%TYPE,
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225: TYPE G_activity_unapp_rec IS RECORD
226: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
227: receipt_number ar_cash_receipts.receipt_number%TYPE,
228: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
229:
230: Original_create_cash_info G_create_cash_rec_type;
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225: TYPE G_activity_unapp_rec IS RECORD
226: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
227: receipt_number ar_cash_receipts.receipt_number%TYPE,
228: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
229:
230: Original_create_cash_info G_create_cash_rec_type;
231: Original_application_info G_application_rec_type;
232: Original_unapp_info G_unapp_rec_type;
356: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
357: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
360: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
360: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
360: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
360: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
368: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
361: -- this is the allocated receipt amount
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
368: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
369: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
362: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
368: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
369: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
370: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
363: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
368: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
369: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
370: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
371: p_called_from IN VARCHAR2 DEFAULT NULL,
364: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
365: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
366: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
367: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
368: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
369: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
370: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
371: p_called_from IN VARCHAR2 DEFAULT NULL,
372: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
369: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
370: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
371: p_called_from IN VARCHAR2 DEFAULT NULL,
372: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
373: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
374: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
375: -- ******* Global Flexfield parameters *******
376: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
377: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
373: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
374: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
375: -- ******* Global Flexfield parameters *******
376: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
377: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
378: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
374: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
375: -- ******* Global Flexfield parameters *******
376: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
377: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
378: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
375: -- ******* Global Flexfield parameters *******
376: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
377: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
378: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
376: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
377: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
378: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
377: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
378: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
385: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
378: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
385: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
386: p_org_id IN NUMBER DEFAULT NULL
379: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
385: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
386: p_org_id IN NUMBER DEFAULT NULL
387: );
380: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
385: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
386: p_org_id IN NUMBER DEFAULT NULL
387: );
388:
381: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
382: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
383: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
384: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
385: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
386: p_org_id IN NUMBER DEFAULT NULL
387: );
388:
389: -- LLCA
406: -- LLCA Parameters
407: p_llca_type IN VARCHAR2 DEFAULT 'S',
408: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
409: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
410: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
411: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
412: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
413: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
414: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
407: p_llca_type IN VARCHAR2 DEFAULT 'S',
408: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
409: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
410: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
411: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
412: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
413: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
414: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
415: p_line_discount IN NUMBER DEFAULT NULL,
408: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
409: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
410: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
411: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
412: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
413: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
414: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
415: p_line_discount IN NUMBER DEFAULT NULL,
416: p_tax_discount IN NUMBER DEFAULT NULL,
409: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
410: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
411: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
412: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
413: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
414: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
415: p_line_discount IN NUMBER DEFAULT NULL,
416: p_tax_discount IN NUMBER DEFAULT NULL,
417: p_freight_discount IN NUMBER DEFAULT NULL,
410: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
411: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
412: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
413: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
414: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
415: p_line_discount IN NUMBER DEFAULT NULL,
416: p_tax_discount IN NUMBER DEFAULT NULL,
417: p_freight_discount IN NUMBER DEFAULT NULL,
418: -- this is the allocated receipt amount
415: p_line_discount IN NUMBER DEFAULT NULL,
416: p_tax_discount IN NUMBER DEFAULT NULL,
417: p_freight_discount IN NUMBER DEFAULT NULL,
418: -- this is the allocated receipt amount
419: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
420: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
416: p_tax_discount IN NUMBER DEFAULT NULL,
417: p_freight_discount IN NUMBER DEFAULT NULL,
418: -- this is the allocated receipt amount
419: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
420: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
424: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
417: p_freight_discount IN NUMBER DEFAULT NULL,
418: -- this is the allocated receipt amount
419: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
420: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
424: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
425: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
418: -- this is the allocated receipt amount
419: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
420: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
424: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
425: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
426: p_called_from IN VARCHAR2 DEFAULT NULL,
419: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
420: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
424: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
425: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
426: p_called_from IN VARCHAR2 DEFAULT NULL,
427: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
420: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
421: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
422: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
423: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
424: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
425: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
426: p_called_from IN VARCHAR2 DEFAULT NULL,
427: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
428: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
424: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
425: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
426: p_called_from IN VARCHAR2 DEFAULT NULL,
427: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
428: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
429: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
430: -- ******* Global Flexfield parameters *******
431: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
432: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
428: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
429: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
430: -- ******* Global Flexfield parameters *******
431: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
432: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
433: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
429: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
430: -- ******* Global Flexfield parameters *******
431: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
432: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
433: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
430: -- ******* Global Flexfield parameters *******
431: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
432: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
433: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
431: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
432: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
433: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
432: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
433: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
440: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
433: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
440: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
441: p_org_id IN NUMBER DEFAULT NULL,
434: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
440: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
441: p_org_id IN NUMBER DEFAULT NULL,
442: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
435: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
440: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
441: p_org_id IN NUMBER DEFAULT NULL,
442: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
443: );
436: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
437: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
438: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
439: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
440: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
441: p_org_id IN NUMBER DEFAULT NULL,
442: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
443: );
444:
465: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
466: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
468: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
469: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
470: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
471: p_called_from IN VARCHAR2 DEFAULT NULL,
472: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
473: p_org_id IN NUMBER DEFAULT NULL
466: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
468: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
469: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
470: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
471: p_called_from IN VARCHAR2 DEFAULT NULL,
472: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
473: p_org_id IN NUMBER DEFAULT NULL
474: );
542: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
543: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
544: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
545: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
546: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
544: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
545: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
546: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
545: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
546: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
546: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
554: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
547: -- this is the allocated receipt amount
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
554: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
555: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
548: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
554: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
555: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
556: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
549: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
554: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
555: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
556: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
557: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
550: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
551: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
552: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
553: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
554: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
555: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
556: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
557: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
558: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
554: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
555: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
556: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
557: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
558: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
559: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
560: -- ******* Global Flexfield parameters *******
561: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
562: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
558: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
559: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
560: -- ******* Global Flexfield parameters *******
561: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
562: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
563: -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
564: -- processor such as iPayments
565: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
566: p_org_id IN NUMBER DEFAULT NULL
621: x_msg_data OUT NOCOPY VARCHAR2,
622: -- Receipt application parameters.
623: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
628: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
629: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
622: -- Receipt application parameters.
623: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
628: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
629: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
630: -- ******* Global Flexfield parameters *******
623: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
628: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
629: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
630: -- ******* Global Flexfield parameters *******
631: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
628: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
629: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
630: -- ******* Global Flexfield parameters *******
631: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
632: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
628: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
629: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
630: -- ******* Global Flexfield parameters *******
631: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
632: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
633: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
634: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
635: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636: p_called_from IN VARCHAR2 DEFAULT NULL,
629: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
630: -- ******* Global Flexfield parameters *******
631: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
632: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
633: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
634: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
635: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636: p_called_from IN VARCHAR2 DEFAULT NULL,
637: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
630: -- ******* Global Flexfield parameters *******
631: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
632: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
633: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
634: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
635: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636: p_called_from IN VARCHAR2 DEFAULT NULL,
637: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
638: p_secondary_app_ref_type IN
631: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
632: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
633: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
634: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
635: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636: p_called_from IN VARCHAR2 DEFAULT NULL,
637: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
638: p_secondary_app_ref_type IN
639: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
633: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
634: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
635: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636: p_called_from IN VARCHAR2 DEFAULT NULL,
637: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
638: p_secondary_app_ref_type IN
639: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
640: p_secondary_app_ref_num IN
641: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
635: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
636: p_called_from IN VARCHAR2 DEFAULT NULL,
637: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
638: p_secondary_app_ref_type IN
639: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
640: p_secondary_app_ref_num IN
641: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
642: p_org_id IN NUMBER DEFAULT NULL
643: );
637: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
638: p_secondary_app_ref_type IN
639: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
640: p_secondary_app_ref_num IN
641: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
642: p_org_id IN NUMBER DEFAULT NULL
643: );
644:
645: /*#
662: x_msg_data OUT NOCOPY VARCHAR2 ,
663: -- *** Receipt Info. parameters *****
664: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
665: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
666: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
667: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
668: p_org_id IN NUMBER DEFAULT NULL
669: );
670:
663: -- *** Receipt Info. parameters *****
664: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
665: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
666: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
667: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
668: p_org_id IN NUMBER DEFAULT NULL
669: );
670:
671: /*#
688: x_msg_data OUT NOCOPY VARCHAR2,
689: -- Receipt application parameters.
690: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
691: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
692: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
691: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
692: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
697: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
698: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
699: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
692: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
697: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
698: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
699: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
700: -- ******* Global Flexfield parameters *******
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
697: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
698: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
699: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
700: -- ******* Global Flexfield parameters *******
701: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
696: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
697: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
698: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
699: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
700: -- ******* Global Flexfield parameters *******
701: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
702: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
698: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
699: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
700: -- ******* Global Flexfield parameters *******
701: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
702: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
703: p_application_ref_type IN OUT NOCOPY
704: ar_receivable_applications.application_ref_type%TYPE,
705: p_application_ref_id IN OUT NOCOPY
706: ar_receivable_applications.application_ref_id%TYPE,
700: -- ******* Global Flexfield parameters *******
701: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
702: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
703: p_application_ref_type IN OUT NOCOPY
704: ar_receivable_applications.application_ref_type%TYPE,
705: p_application_ref_id IN OUT NOCOPY
706: ar_receivable_applications.application_ref_id%TYPE,
707: p_application_ref_num IN OUT NOCOPY
708: ar_receivable_applications.application_ref_num%TYPE,
702: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
703: p_application_ref_type IN OUT NOCOPY
704: ar_receivable_applications.application_ref_type%TYPE,
705: p_application_ref_id IN OUT NOCOPY
706: ar_receivable_applications.application_ref_id%TYPE,
707: p_application_ref_num IN OUT NOCOPY
708: ar_receivable_applications.application_ref_num%TYPE,
709: p_secondary_application_ref_id IN OUT NOCOPY
710: ar_receivable_applications.secondary_application_ref_id%TYPE,
704: ar_receivable_applications.application_ref_type%TYPE,
705: p_application_ref_id IN OUT NOCOPY
706: ar_receivable_applications.application_ref_id%TYPE,
707: p_application_ref_num IN OUT NOCOPY
708: ar_receivable_applications.application_ref_num%TYPE,
709: p_secondary_application_ref_id IN OUT NOCOPY
710: ar_receivable_applications.secondary_application_ref_id%TYPE,
711: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
712: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
706: ar_receivable_applications.application_ref_id%TYPE,
707: p_application_ref_num IN OUT NOCOPY
708: ar_receivable_applications.application_ref_num%TYPE,
709: p_secondary_application_ref_id IN OUT NOCOPY
710: ar_receivable_applications.secondary_application_ref_id%TYPE,
711: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
712: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
713: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
714: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
707: p_application_ref_num IN OUT NOCOPY
708: ar_receivable_applications.application_ref_num%TYPE,
709: p_secondary_application_ref_id IN OUT NOCOPY
710: ar_receivable_applications.secondary_application_ref_id%TYPE,
711: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
712: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
713: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
714: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
715: p_called_from IN VARCHAR2 DEFAULT NULL,
708: ar_receivable_applications.application_ref_num%TYPE,
709: p_secondary_application_ref_id IN OUT NOCOPY
710: ar_receivable_applications.secondary_application_ref_id%TYPE,
711: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
712: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
713: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
714: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
715: p_called_from IN VARCHAR2 DEFAULT NULL,
716: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
709: p_secondary_application_ref_id IN OUT NOCOPY
710: ar_receivable_applications.secondary_application_ref_id%TYPE,
711: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
712: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
713: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
714: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
715: p_called_from IN VARCHAR2 DEFAULT NULL,
716: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
717: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
715: p_called_from IN VARCHAR2 DEFAULT NULL,
716: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
717: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
718: p_secondary_app_ref_type IN
719: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
720: p_secondary_app_ref_num IN
721: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
722: p_org_id IN NUMBER DEFAULT NULL,
723: p_customer_reason IN
717: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
718: p_secondary_app_ref_type IN
719: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
720: p_secondary_app_ref_num IN
721: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
722: p_org_id IN NUMBER DEFAULT NULL,
723: p_customer_reason IN
724: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
725: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
720: p_secondary_app_ref_num IN
721: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
722: p_org_id IN NUMBER DEFAULT NULL,
723: p_customer_reason IN
724: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
725: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
726: ,p_pay_alone_flag IN VARCHAR2 DEFAULT NULL
727: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE DEFAULT NULL
728: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE DEFAULT NULL
755: x_msg_data OUT NOCOPY VARCHAR2 ,
756: -- *** Receipt Info. parameters *****
757: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
758: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
759: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
760: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
761: p_called_from IN VARCHAR2,
762: p_org_id IN NUMBER DEFAULT NULL
763: );
756: -- *** Receipt Info. parameters *****
757: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
758: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
759: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
760: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
761: p_called_from IN VARCHAR2,
762: p_org_id IN NUMBER DEFAULT NULL
763: );
764:
780: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
781: x_return_status OUT NOCOPY VARCHAR2,
782: x_msg_count OUT NOCOPY NUMBER,
783: x_msg_data OUT NOCOPY VARCHAR2,
784: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
785: -- Receipt application parameters.
786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
784: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
785: -- Receipt application parameters.
786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
785: -- Receipt application parameters.
786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
798: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
798: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
799: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
792: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
798: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
799: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
800: -- ******* Global Flexfield parameters *******
793: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
798: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
799: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
800: -- ******* Global Flexfield parameters *******
801: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
794: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
795: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
796: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
797: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
798: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
799: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
800: -- ******* Global Flexfield parameters *******
801: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
802: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
798: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
799: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
800: -- ******* Global Flexfield parameters *******
801: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
802: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
803: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
804: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
805: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
806: p_called_from IN VARCHAR2 DEFAULT NULL,
799: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
800: -- ******* Global Flexfield parameters *******
801: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
802: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
803: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
804: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
805: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
806: p_called_from IN VARCHAR2 DEFAULT NULL,
807: p_org_id IN NUMBER DEFAULT NULL
800: -- ******* Global Flexfield parameters *******
801: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
802: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
803: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
804: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
805: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
806: p_called_from IN VARCHAR2 DEFAULT NULL,
807: p_org_id IN NUMBER DEFAULT NULL
808: );
801: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
802: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
803: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
804: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
805: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
806: p_called_from IN VARCHAR2 DEFAULT NULL,
807: p_org_id IN NUMBER DEFAULT NULL
808: );
809:
826: x_msg_data OUT NOCOPY VARCHAR2 ,
827: -- *** Receipt Info. parameters *****
828: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
829: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
830: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
831: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
832: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
833: p_called_from IN VARCHAR2 DEFAULT NULL,
834: p_org_id IN NUMBER DEFAULT NULL
827: -- *** Receipt Info. parameters *****
828: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
829: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
830: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
831: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
832: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
833: p_called_from IN VARCHAR2 DEFAULT NULL,
834: p_org_id IN NUMBER DEFAULT NULL
835: );
928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
936: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
936: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
937: p_called_from IN VARCHAR2 DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
936: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
937: p_called_from IN VARCHAR2 DEFAULT NULL,
938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
936: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
937: p_called_from IN VARCHAR2 DEFAULT NULL,
938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
939: -- ******* Global Flexfield parameters *******
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
936: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
937: p_called_from IN VARCHAR2 DEFAULT NULL,
938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
939: -- ******* Global Flexfield parameters *******
940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
937: p_called_from IN VARCHAR2 DEFAULT NULL,
938: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
939: -- ******* Global Flexfield parameters *******
940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
942: p_org_id IN NUMBER DEFAULT NULL,
943: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
939: -- ******* Global Flexfield parameters *******
940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
942: p_org_id IN NUMBER DEFAULT NULL,
943: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
946: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
947: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
940: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
942: p_org_id IN NUMBER DEFAULT NULL,
943: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
946: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
947: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
948: );
941: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
942: p_org_id IN NUMBER DEFAULT NULL,
943: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
946: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
947: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
948: );
949:
942: p_org_id IN NUMBER DEFAULT NULL,
943: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
946: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
947: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
948: );
949:
950: /*#
943: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
944: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
945: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
946: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
947: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
948: );
949:
950: /*#
951: * Use this procedure to reverse a payment netting application on a cash receipt.
963: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
964: x_return_status OUT NOCOPY VARCHAR2 ,
965: x_msg_count OUT NOCOPY NUMBER ,
966: x_msg_data OUT NOCOPY VARCHAR2 ,
967: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
968: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
969: p_called_from IN VARCHAR2 DEFAULT NULL,
970: p_org_id IN NUMBER DEFAULT NULL);
971:
964: x_return_status OUT NOCOPY VARCHAR2 ,
965: x_msg_count OUT NOCOPY NUMBER ,
966: x_msg_data OUT NOCOPY VARCHAR2 ,
967: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
968: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
969: p_called_from IN VARCHAR2 DEFAULT NULL,
970: p_org_id IN NUMBER DEFAULT NULL);
971:
972: /*=======================================================================
1089: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1090: -- ** OUT NOCOPY variables for Creating receipt
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092: -- Receipt application parameters
1093: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1094: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1095: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1096: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1097: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1090: -- ** OUT NOCOPY variables for Creating receipt
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092: -- Receipt application parameters
1093: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1094: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1095: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1096: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1097: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1098: -- ******* Global Flexfield parameters *******
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092: -- Receipt application parameters
1093: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1094: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1095: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1096: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1097: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1098: -- ******* Global Flexfield parameters *******
1099: app_global_attribute_rec IN global_attribute_rec_type
1092: -- Receipt application parameters
1093: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1094: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1095: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1096: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1097: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1098: -- ******* Global Flexfield parameters *******
1099: app_global_attribute_rec IN global_attribute_rec_type
1100: DEFAULT global_attribute_rec_const,
1097: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1098: -- ******* Global Flexfield parameters *******
1099: app_global_attribute_rec IN global_attribute_rec_type
1100: DEFAULT global_attribute_rec_const,
1101: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1102: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1103: DEFAULT NULL,
1104: p_secondary_application_ref_id IN
1105: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1098: -- ******* Global Flexfield parameters *******
1099: app_global_attribute_rec IN global_attribute_rec_type
1100: DEFAULT global_attribute_rec_const,
1101: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1102: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1103: DEFAULT NULL,
1104: p_secondary_application_ref_id IN
1105: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1106: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1101: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1102: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1103: DEFAULT NULL,
1104: p_secondary_application_ref_id IN
1105: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1106: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1107: DEFAULT NULL,
1108: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1109: p_secondary_app_ref_type IN
1102: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1103: DEFAULT NULL,
1104: p_secondary_application_ref_id IN
1105: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1106: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1107: DEFAULT NULL,
1108: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1109: p_secondary_app_ref_type IN
1110: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1104: p_secondary_application_ref_id IN
1105: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1106: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1107: DEFAULT NULL,
1108: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1109: p_secondary_app_ref_type IN
1110: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1111: p_secondary_app_ref_num IN
1112: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1106: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1107: DEFAULT NULL,
1108: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1109: p_secondary_app_ref_type IN
1110: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1111: p_secondary_app_ref_num IN
1112: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1113:
1114: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1108: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1109: p_secondary_app_ref_type IN
1110: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1111: p_secondary_app_ref_num IN
1112: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1113:
1114: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1115: p_org_id IN NUMBER DEFAULT NULL
1116: ) ;