54: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
55: | |
56: +===========================================================================*/
57: PROCEDURE update_receipt_related_columns(
58: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
59: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
60: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
61: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
62: p_acctd_amount_applied OUT NOCOPY
55: | |
56: +===========================================================================*/
57: PROCEDURE update_receipt_related_columns(
58: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
59: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
60: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
61: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
62: p_acctd_amount_applied OUT NOCOPY
63: ar_receivable_applications.acctd_amount_applied_from%TYPE,
56: +===========================================================================*/
57: PROCEDURE update_receipt_related_columns(
58: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
59: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
60: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
61: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
62: p_acctd_amount_applied OUT NOCOPY
63: ar_receivable_applications.acctd_amount_applied_from%TYPE,
64: p_ps_rec IN ar_payment_schedules%ROWTYPE);
57: PROCEDURE update_receipt_related_columns(
58: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
59: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
60: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
61: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
62: p_acctd_amount_applied OUT NOCOPY
63: ar_receivable_applications.acctd_amount_applied_from%TYPE,
64: p_ps_rec IN ar_payment_schedules%ROWTYPE);
65: --
60: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
61: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
62: p_acctd_amount_applied OUT NOCOPY
63: ar_receivable_applications.acctd_amount_applied_from%TYPE,
64: p_ps_rec IN ar_payment_schedules%ROWTYPE);
65: --
66: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
67: --
68: /*===========================================================================+
133: | procedure (see definition below)
134: +===========================================================================*/
135: PROCEDURE update_invoice_related_columns(
136: p_app_type IN VARCHAR2,
137: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
138: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
134: +===========================================================================*/
135: PROCEDURE update_invoice_related_columns(
136: p_app_type IN VARCHAR2,
137: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
138: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
135: PROCEDURE update_invoice_related_columns(
136: p_app_type IN VARCHAR2,
137: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
138: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
136: p_app_type IN VARCHAR2,
137: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
138: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
137: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
138: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
138: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
158: p_rule_set_id OUT NOCOPY number,
159: p_ps_rec IN ar_payment_schedules%ROWTYPE);
160:
161: /*===========================================================================+
162: | PROCEDURE |
163: | update_invoice_related_columns (overloaded) |
223: | to facilitate etax disc proration.
224: +===========================================================================*/
225: PROCEDURE update_invoice_related_columns(
226: p_app_type IN VARCHAR2,
227: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
228: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
224: +===========================================================================*/
225: PROCEDURE update_invoice_related_columns(
226: p_app_type IN VARCHAR2,
227: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
228: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
225: PROCEDURE update_invoice_related_columns(
226: p_app_type IN VARCHAR2,
227: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
228: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
226: p_app_type IN VARCHAR2,
227: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
228: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
227: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
228: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
228: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,
249: p_ps_rec IN ar_payment_schedules%ROWTYPE,
250: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
251: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
252: p_gt_id OUT NOCOPY NUMBER);
253:
298: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
299: | |
300: +===========================================================================*/
301: PROCEDURE update_cm_related_columns(
302: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
303: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
304: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
306: p_freight_applied IN
299: | |
300: +===========================================================================*/
301: PROCEDURE update_cm_related_columns(
302: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
303: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
304: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
306: p_freight_applied IN
307: ar_receivable_applications.freight_applied%TYPE,
306: p_freight_applied IN
307: ar_receivable_applications.freight_applied%TYPE,
308: p_charges_applied IN
309: ar_receivable_applications.receivables_charges_applied%TYPE,
310: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
311: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
312: p_acctd_amount_applied OUT NOCOPY
313: ar_receivable_applications.acctd_amount_applied_to%TYPE,
314: p_ps_rec IN ar_payment_schedules%ROWTYPE,
307: ar_receivable_applications.freight_applied%TYPE,
308: p_charges_applied IN
309: ar_receivable_applications.receivables_charges_applied%TYPE,
310: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
311: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
312: p_acctd_amount_applied OUT NOCOPY
313: ar_receivable_applications.acctd_amount_applied_to%TYPE,
314: p_ps_rec IN ar_payment_schedules%ROWTYPE,
315: p_update_credit_flag IN VARCHAR2 DEFAULT NULL );
310: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
311: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
312: p_acctd_amount_applied OUT NOCOPY
313: ar_receivable_applications.acctd_amount_applied_to%TYPE,
314: p_ps_rec IN ar_payment_schedules%ROWTYPE,
315: p_update_credit_flag IN VARCHAR2 DEFAULT NULL );
316: --
317: /*===========================================================================+
318: | PROCEDURE |
344: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
345: | |
346: +===========================================================================*/
347: PROCEDURE update_adj_related_columns(
348: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
357: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
357: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
358:
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
357: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
358:
359: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
357: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
358:
359: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
360: --
361: /*===========================================================================+
401: | IN OUT NOCOPY in update_adj_related_columns |
402: | |
403: +===========================================================================*/
404: PROCEDURE update_adj_related_columns(
405: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
406: p_type IN ar_adjustments.type%TYPE,
407: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
403: +===========================================================================*/
404: PROCEDURE update_adj_related_columns(
405: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
406: p_type IN ar_adjustments.type%TYPE,
407: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
404: PROCEDURE update_adj_related_columns(
405: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
406: p_type IN ar_adjustments.type%TYPE,
407: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
416: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
417: --
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
416: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
417: --
418: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
416: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
417: --
418: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
419:
420: /*===========================================================================+
489: | 16-APR-98 GJWANG Bug Fix: 653643 declare this as public procedure |
490: | |
491: +===========================================================================*/
492: PROCEDURE populate_closed_dates(
493: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
494: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
495: p_app_type IN VARCHAR2,
496: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
497:
490: | |
491: +===========================================================================*/
492: PROCEDURE populate_closed_dates(
493: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
494: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
495: p_app_type IN VARCHAR2,
496: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
497:
498:
492: PROCEDURE populate_closed_dates(
493: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
494: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
495: p_app_type IN VARCHAR2,
496: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
497:
498:
499: END ARP_PS_UTIL;