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;
366: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
367: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
370: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
371: -- this is the allocated receipt amount
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
370: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
371: -- this is the allocated receipt amount
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
370: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
371: -- this is the allocated receipt amount
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
370: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
371: -- this is the allocated receipt amount
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
371: -- this is the allocated receipt amount
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
372: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
380: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
373: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
380: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
381: p_called_from IN VARCHAR2 DEFAULT NULL,
374: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
375: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
376: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
377: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
378: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
380: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
381: p_called_from IN VARCHAR2 DEFAULT NULL,
382: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
379: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
380: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
381: p_called_from IN VARCHAR2 DEFAULT NULL,
382: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
383: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
385: -- ******* Global Flexfield parameters *******
386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
383: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
385: -- ******* Global Flexfield parameters *******
386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
388: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
384: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
385: -- ******* Global Flexfield parameters *******
386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
388: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
385: -- ******* Global Flexfield parameters *******
386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
388: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
386: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
388: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
387: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
388: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
395: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
388: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
395: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
396: p_org_id IN NUMBER DEFAULT NULL
389: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
395: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
396: p_org_id IN NUMBER DEFAULT NULL
397: );
390: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
395: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
396: p_org_id IN NUMBER DEFAULT NULL
397: );
398:
391: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
392: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
393: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
394: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
395: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
396: p_org_id IN NUMBER DEFAULT NULL
397: );
398:
399: -- LLCA
416: -- LLCA Parameters
417: p_llca_type IN VARCHAR2 DEFAULT 'S',
418: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
419: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
420: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
421: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
422: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
423: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
424: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
417: p_llca_type IN VARCHAR2 DEFAULT 'S',
418: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
419: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
420: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
421: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
422: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
423: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
424: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
425: p_line_discount IN NUMBER DEFAULT NULL,
418: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
419: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
420: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
421: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
422: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
423: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
424: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
425: p_line_discount IN NUMBER DEFAULT NULL,
426: p_tax_discount IN NUMBER DEFAULT NULL,
419: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
420: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
421: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
422: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
423: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
424: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
425: p_line_discount IN NUMBER DEFAULT NULL,
426: p_tax_discount IN NUMBER DEFAULT NULL,
427: p_freight_discount IN NUMBER DEFAULT NULL,
420: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
421: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
422: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
423: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
424: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
425: p_line_discount IN NUMBER DEFAULT NULL,
426: p_tax_discount IN NUMBER DEFAULT NULL,
427: p_freight_discount IN NUMBER DEFAULT NULL,
428: -- this is the allocated receipt amount
425: p_line_discount IN NUMBER DEFAULT NULL,
426: p_tax_discount IN NUMBER DEFAULT NULL,
427: p_freight_discount IN NUMBER DEFAULT NULL,
428: -- this is the allocated receipt amount
429: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
430: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
426: p_tax_discount IN NUMBER DEFAULT NULL,
427: p_freight_discount IN NUMBER DEFAULT NULL,
428: -- this is the allocated receipt amount
429: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
430: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
434: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
427: p_freight_discount IN NUMBER DEFAULT NULL,
428: -- this is the allocated receipt amount
429: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
430: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
434: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
435: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
428: -- this is the allocated receipt amount
429: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
430: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
434: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
435: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
436: p_called_from IN VARCHAR2 DEFAULT NULL,
429: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
430: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
434: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
435: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
436: p_called_from IN VARCHAR2 DEFAULT NULL,
437: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
430: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
431: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
432: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
433: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
434: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
435: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
436: p_called_from IN VARCHAR2 DEFAULT NULL,
437: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
438: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
434: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
435: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
436: p_called_from IN VARCHAR2 DEFAULT NULL,
437: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
438: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
439: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
440: -- ******* Global Flexfield parameters *******
441: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
442: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
438: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
439: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
440: -- ******* Global Flexfield parameters *******
441: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
442: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
443: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
439: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
440: -- ******* Global Flexfield parameters *******
441: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
442: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
443: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
440: -- ******* Global Flexfield parameters *******
441: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
442: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
443: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
441: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
442: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
443: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
442: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
443: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
450: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
443: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
450: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
451: p_org_id IN NUMBER DEFAULT NULL,
444: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
450: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
451: p_org_id IN NUMBER DEFAULT NULL,
452: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
445: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
450: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
451: p_org_id IN NUMBER DEFAULT NULL,
452: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
453: );
446: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
447: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
448: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
450: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
451: p_org_id IN NUMBER DEFAULT NULL,
452: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
453: );
454:
475: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
478: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
479: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
480: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
481: p_called_from IN VARCHAR2 DEFAULT NULL,
482: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
483: p_org_id IN NUMBER DEFAULT NULL
476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
478: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
479: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
480: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
481: p_called_from IN VARCHAR2 DEFAULT NULL,
482: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
483: p_org_id IN NUMBER DEFAULT NULL
484: );
552: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
553: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
554: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
555: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
556: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
557: -- this is the allocated receipt amount
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
554: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
555: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
556: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
557: -- this is the allocated receipt amount
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
555: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
556: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
557: -- this is the allocated receipt amount
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
556: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
557: -- this is the allocated receipt amount
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
557: -- this is the allocated receipt amount
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
558: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
566: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
559: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
566: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
567: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
560: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
561: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
562: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
563: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
566: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
567: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
568: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
564: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
565: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
566: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
567: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
568: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
569: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
570: -- ******* Global Flexfield parameters *******
571: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
572: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
568: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
569: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
570: -- ******* Global Flexfield parameters *******
571: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
572: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
573: -- OSTEINME 3/9/2001: added flag that indicates whether to call payment
574: -- processor such as iPayments
575: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
576: p_org_id IN NUMBER DEFAULT NULL
631: x_msg_data OUT NOCOPY VARCHAR2,
632: -- Receipt application parameters.
633: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
634: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
638: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
639: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
632: -- Receipt application parameters.
633: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
634: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
638: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
639: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
640: -- ******* Global Flexfield parameters *******
633: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
634: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
638: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
639: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
640: -- ******* Global Flexfield parameters *******
641: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
634: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
638: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
639: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
640: -- ******* Global Flexfield parameters *******
641: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
642: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
638: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
639: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
640: -- ******* Global Flexfield parameters *******
641: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
642: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
643: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
644: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
645: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646: p_called_from IN VARCHAR2 DEFAULT NULL,
639: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
640: -- ******* Global Flexfield parameters *******
641: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
642: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
643: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
644: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
645: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646: p_called_from IN VARCHAR2 DEFAULT NULL,
647: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
640: -- ******* Global Flexfield parameters *******
641: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
642: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
643: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
644: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
645: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646: p_called_from IN VARCHAR2 DEFAULT NULL,
647: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
648: p_secondary_app_ref_type IN
641: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
642: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
643: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
644: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
645: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646: p_called_from IN VARCHAR2 DEFAULT NULL,
647: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
648: p_secondary_app_ref_type IN
649: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
643: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
644: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
645: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646: p_called_from IN VARCHAR2 DEFAULT NULL,
647: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
648: p_secondary_app_ref_type IN
649: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
650: p_secondary_app_ref_num IN
651: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
645: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
646: p_called_from IN VARCHAR2 DEFAULT NULL,
647: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
648: p_secondary_app_ref_type IN
649: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
650: p_secondary_app_ref_num IN
651: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
652: p_org_id IN NUMBER DEFAULT NULL
653: );
647: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
648: p_secondary_app_ref_type IN
649: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
650: p_secondary_app_ref_num IN
651: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
652: p_org_id IN NUMBER DEFAULT NULL
653: );
654:
655: /*#
672: x_msg_data OUT NOCOPY VARCHAR2 ,
673: -- *** Receipt Info. parameters *****
674: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
675: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
676: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
677: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
678: p_org_id IN NUMBER DEFAULT NULL
679: );
680:
673: -- *** Receipt Info. parameters *****
674: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
675: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
676: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
677: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
678: p_org_id IN NUMBER DEFAULT NULL
679: );
680:
681: /*#
698: x_msg_data OUT NOCOPY VARCHAR2,
699: -- Receipt application parameters.
700: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
701: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
702: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
701: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
702: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
707: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
708: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
709: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
702: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
707: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
708: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
709: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
710: -- ******* Global Flexfield parameters *******
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
707: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
708: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
709: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
710: -- ******* Global Flexfield parameters *******
711: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
706: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
707: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
708: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
709: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
710: -- ******* Global Flexfield parameters *******
711: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
712: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
708: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
709: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
710: -- ******* Global Flexfield parameters *******
711: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
712: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
713: p_application_ref_type IN OUT NOCOPY
714: ar_receivable_applications.application_ref_type%TYPE,
715: p_application_ref_id IN OUT NOCOPY
716: ar_receivable_applications.application_ref_id%TYPE,
710: -- ******* Global Flexfield parameters *******
711: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
712: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
713: p_application_ref_type IN OUT NOCOPY
714: ar_receivable_applications.application_ref_type%TYPE,
715: p_application_ref_id IN OUT NOCOPY
716: ar_receivable_applications.application_ref_id%TYPE,
717: p_application_ref_num IN OUT NOCOPY
718: ar_receivable_applications.application_ref_num%TYPE,
712: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
713: p_application_ref_type IN OUT NOCOPY
714: ar_receivable_applications.application_ref_type%TYPE,
715: p_application_ref_id IN OUT NOCOPY
716: ar_receivable_applications.application_ref_id%TYPE,
717: p_application_ref_num IN OUT NOCOPY
718: ar_receivable_applications.application_ref_num%TYPE,
719: p_secondary_application_ref_id IN OUT NOCOPY
720: ar_receivable_applications.secondary_application_ref_id%TYPE,
714: ar_receivable_applications.application_ref_type%TYPE,
715: p_application_ref_id IN OUT NOCOPY
716: ar_receivable_applications.application_ref_id%TYPE,
717: p_application_ref_num IN OUT NOCOPY
718: ar_receivable_applications.application_ref_num%TYPE,
719: p_secondary_application_ref_id IN OUT NOCOPY
720: ar_receivable_applications.secondary_application_ref_id%TYPE,
721: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
722: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
716: ar_receivable_applications.application_ref_id%TYPE,
717: p_application_ref_num IN OUT NOCOPY
718: ar_receivable_applications.application_ref_num%TYPE,
719: p_secondary_application_ref_id IN OUT NOCOPY
720: ar_receivable_applications.secondary_application_ref_id%TYPE,
721: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
722: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
723: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
724: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
717: p_application_ref_num IN OUT NOCOPY
718: ar_receivable_applications.application_ref_num%TYPE,
719: p_secondary_application_ref_id IN OUT NOCOPY
720: ar_receivable_applications.secondary_application_ref_id%TYPE,
721: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
722: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
723: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
724: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
725: p_called_from IN VARCHAR2 DEFAULT NULL,
718: ar_receivable_applications.application_ref_num%TYPE,
719: p_secondary_application_ref_id IN OUT NOCOPY
720: ar_receivable_applications.secondary_application_ref_id%TYPE,
721: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
722: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
723: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
724: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
725: p_called_from IN VARCHAR2 DEFAULT NULL,
726: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
719: p_secondary_application_ref_id IN OUT NOCOPY
720: ar_receivable_applications.secondary_application_ref_id%TYPE,
721: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
722: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
723: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
724: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
725: p_called_from IN VARCHAR2 DEFAULT NULL,
726: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
727: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
725: p_called_from IN VARCHAR2 DEFAULT NULL,
726: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
727: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
728: p_secondary_app_ref_type IN
729: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
730: p_secondary_app_ref_num IN
731: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
732: p_org_id IN NUMBER DEFAULT NULL,
733: p_customer_reason IN
727: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
728: p_secondary_app_ref_type IN
729: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
730: p_secondary_app_ref_num IN
731: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
732: p_org_id IN NUMBER DEFAULT NULL,
733: p_customer_reason IN
734: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
735: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
730: p_secondary_app_ref_num IN
731: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
732: p_org_id IN NUMBER DEFAULT NULL,
733: p_customer_reason IN
734: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
735: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
736: ,p_pay_alone_flag IN VARCHAR2 DEFAULT NULL
737: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE DEFAULT NULL
738: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE DEFAULT NULL
767: x_msg_data OUT NOCOPY VARCHAR2 ,
768: -- *** Receipt Info. parameters *****
769: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
770: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
771: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
772: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
773: p_called_from IN VARCHAR2,
774: p_org_id IN NUMBER DEFAULT NULL
775: );
768: -- *** Receipt Info. parameters *****
769: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
770: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
771: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
772: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
773: p_called_from IN VARCHAR2,
774: p_org_id IN NUMBER DEFAULT NULL
775: );
776:
792: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
793: x_return_status OUT NOCOPY VARCHAR2,
794: x_msg_count OUT NOCOPY NUMBER,
795: x_msg_data OUT NOCOPY VARCHAR2,
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797: -- Receipt application parameters.
798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797: -- Receipt application parameters.
798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
797: -- Receipt application parameters.
798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
810: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
810: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
811: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
804: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
810: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
811: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
812: -- ******* Global Flexfield parameters *******
805: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
810: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
811: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
812: -- ******* Global Flexfield parameters *******
813: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
806: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
807: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
808: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
809: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
810: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
811: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
812: -- ******* Global Flexfield parameters *******
813: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
814: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
810: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
811: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
812: -- ******* Global Flexfield parameters *******
813: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
814: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
815: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
816: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
817: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
818: p_called_from IN VARCHAR2 DEFAULT NULL,
811: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
812: -- ******* Global Flexfield parameters *******
813: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
814: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
815: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
816: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
817: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
818: p_called_from IN VARCHAR2 DEFAULT NULL,
819: p_org_id IN NUMBER DEFAULT NULL
812: -- ******* Global Flexfield parameters *******
813: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
814: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
815: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
816: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
817: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
818: p_called_from IN VARCHAR2 DEFAULT NULL,
819: p_org_id IN NUMBER DEFAULT NULL
820: );
813: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
814: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
815: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
816: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
817: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
818: p_called_from IN VARCHAR2 DEFAULT NULL,
819: p_org_id IN NUMBER DEFAULT NULL
820: );
821:
838: x_msg_data OUT NOCOPY VARCHAR2 ,
839: -- *** Receipt Info. parameters *****
840: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
841: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
842: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
843: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
844: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
845: p_called_from IN VARCHAR2 DEFAULT NULL,
846: p_org_id IN NUMBER DEFAULT NULL
839: -- *** Receipt Info. parameters *****
840: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
841: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
842: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
843: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
844: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
845: p_called_from IN VARCHAR2 DEFAULT NULL,
846: p_org_id IN NUMBER DEFAULT NULL
847: );
940: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
948: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
948: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
949: p_called_from IN VARCHAR2 DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
948: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
949: p_called_from IN VARCHAR2 DEFAULT NULL,
950: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
948: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
949: p_called_from IN VARCHAR2 DEFAULT NULL,
950: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
951: -- ******* Global Flexfield parameters *******
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
948: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
949: p_called_from IN VARCHAR2 DEFAULT NULL,
950: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
951: -- ******* Global Flexfield parameters *******
952: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
949: p_called_from IN VARCHAR2 DEFAULT NULL,
950: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
951: -- ******* Global Flexfield parameters *******
952: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
953: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
954: p_org_id IN NUMBER DEFAULT NULL,
955: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
951: -- ******* Global Flexfield parameters *******
952: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
953: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
954: p_org_id IN NUMBER DEFAULT NULL,
955: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
958: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
959: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
952: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
953: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
954: p_org_id IN NUMBER DEFAULT NULL,
955: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
958: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
959: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
960: );
953: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
954: p_org_id IN NUMBER DEFAULT NULL,
955: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
958: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
959: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
960: );
961:
954: p_org_id IN NUMBER DEFAULT NULL,
955: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
958: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
959: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
960: );
961:
962: /*#
955: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
956: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
957: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
958: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
959: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
960: );
961:
962: /*#
963: * Use this procedure to reverse a payment netting application on a cash receipt.
975: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
976: x_return_status OUT NOCOPY VARCHAR2 ,
977: x_msg_count OUT NOCOPY NUMBER ,
978: x_msg_data OUT NOCOPY VARCHAR2 ,
979: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
980: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
981: p_called_from IN VARCHAR2 DEFAULT NULL,
982: p_org_id IN NUMBER DEFAULT NULL);
983:
976: x_return_status OUT NOCOPY VARCHAR2 ,
977: x_msg_count OUT NOCOPY NUMBER ,
978: x_msg_data OUT NOCOPY VARCHAR2 ,
979: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
980: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
981: p_called_from IN VARCHAR2 DEFAULT NULL,
982: p_org_id IN NUMBER DEFAULT NULL);
983:
984: /*=======================================================================
1101: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1102: -- ** OUT NOCOPY variables for Creating receipt
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104: -- Receipt application parameters
1105: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1106: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1107: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1108: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1109: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1102: -- ** OUT NOCOPY variables for Creating receipt
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104: -- Receipt application parameters
1105: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1106: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1107: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1108: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1109: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1110: -- ******* Global Flexfield parameters *******
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104: -- Receipt application parameters
1105: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1106: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1107: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1108: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1109: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1110: -- ******* Global Flexfield parameters *******
1111: app_global_attribute_rec IN global_attribute_rec_type
1104: -- Receipt application parameters
1105: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1106: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1107: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1108: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1109: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1110: -- ******* Global Flexfield parameters *******
1111: app_global_attribute_rec IN global_attribute_rec_type
1112: DEFAULT global_attribute_rec_const,
1109: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1110: -- ******* Global Flexfield parameters *******
1111: app_global_attribute_rec IN global_attribute_rec_type
1112: DEFAULT global_attribute_rec_const,
1113: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1114: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1115: DEFAULT NULL,
1116: p_secondary_application_ref_id IN
1117: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1110: -- ******* Global Flexfield parameters *******
1111: app_global_attribute_rec IN global_attribute_rec_type
1112: DEFAULT global_attribute_rec_const,
1113: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1114: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1115: DEFAULT NULL,
1116: p_secondary_application_ref_id IN
1117: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1118: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1113: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1114: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1115: DEFAULT NULL,
1116: p_secondary_application_ref_id IN
1117: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1118: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1119: DEFAULT NULL,
1120: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1121: p_secondary_app_ref_type IN
1114: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
1115: DEFAULT NULL,
1116: p_secondary_application_ref_id IN
1117: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1118: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1119: DEFAULT NULL,
1120: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1121: p_secondary_app_ref_type IN
1122: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1116: p_secondary_application_ref_id IN
1117: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1118: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1119: DEFAULT NULL,
1120: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1121: p_secondary_app_ref_type IN
1122: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1123: p_secondary_app_ref_num IN
1124: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1118: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1119: DEFAULT NULL,
1120: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1121: p_secondary_app_ref_type IN
1122: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1123: p_secondary_app_ref_num IN
1124: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1125:
1126: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1120: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1121: p_secondary_app_ref_type IN
1122: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
1123: p_secondary_app_ref_num IN
1124: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
1125:
1126: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1127: p_org_id IN NUMBER DEFAULT NULL
1128: ) ;