eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PS_UTIL dependencies on AR_PAYMENT_SCHEDULES

Line 59: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

55: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
56: | |
57: +===========================================================================*/
58: PROCEDURE update_receipt_related_columns(
59: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
60: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY

Line 60: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

56: | |
57: +===========================================================================*/
58: PROCEDURE update_receipt_related_columns(
59: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
60: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,

Line 61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

57: +===========================================================================*/
58: PROCEDURE update_receipt_related_columns(
59: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
60: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,
65: p_ps_rec IN ar_payment_schedules%ROWTYPE,

Line 62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

58: PROCEDURE update_receipt_related_columns(
59: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
60: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,
65: p_ps_rec IN ar_payment_schedules%ROWTYPE,
66: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

Line 65: p_ps_rec IN ar_payment_schedules%ROWTYPE,

61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,
65: p_ps_rec IN ar_payment_schedules%ROWTYPE,
66: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
67: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL); -- For Bug 6924942
68: --
69: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8

Line 66: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,
65: p_ps_rec IN ar_payment_schedules%ROWTYPE,
66: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
67: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL); -- For Bug 6924942
68: --
69: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
70: --

Line 67: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL); -- For Bug 6924942

63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,
65: p_ps_rec IN ar_payment_schedules%ROWTYPE,
66: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
67: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL); -- For Bug 6924942
68: --
69: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
70: --
71: /*===========================================================================+

Line 140: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

136: | procedure (see definition below)
137: +===========================================================================*/
138: PROCEDURE update_invoice_related_columns(
139: p_app_type IN VARCHAR2,
140: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

137: +===========================================================================*/
138: PROCEDURE update_invoice_related_columns(
139: p_app_type IN VARCHAR2,
140: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
145: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

138: PROCEDURE update_invoice_related_columns(
139: p_app_type IN VARCHAR2,
140: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
145: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
146: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

139: p_app_type IN VARCHAR2,
140: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
145: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
146: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
147: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,

Line 144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

140: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
145: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
146: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
147: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
148: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,

Line 145: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

141: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
142: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
143: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
144: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
145: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
146: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
147: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
148: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
149: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 162: p_ps_rec IN ar_payment_schedules%ROWTYPE);

158: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
159: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
160: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
161: p_rule_set_id OUT NOCOPY number,
162: p_ps_rec IN ar_payment_schedules%ROWTYPE);
163:
164: /*===========================================================================+
165: | PROCEDURE |
166: | update_invoice_related_columns (overloaded) |

Line 230: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

226: | to facilitate etax disc proration.
227: +===========================================================================*/
228: PROCEDURE update_invoice_related_columns(
229: p_app_type IN VARCHAR2,
230: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

227: +===========================================================================*/
228: PROCEDURE update_invoice_related_columns(
229: p_app_type IN VARCHAR2,
230: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
235: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

228: PROCEDURE update_invoice_related_columns(
229: p_app_type IN VARCHAR2,
230: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
235: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
236: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

229: p_app_type IN VARCHAR2,
230: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
235: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
236: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
237: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,

Line 234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

230: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
235: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
236: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
237: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
238: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,

Line 235: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

231: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
232: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
233: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
234: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
235: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
236: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
237: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
238: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
239: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 252: p_ps_rec IN ar_payment_schedules%ROWTYPE,

248: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
249: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
250: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
251: p_rule_set_id OUT NOCOPY number,
252: p_ps_rec IN ar_payment_schedules%ROWTYPE,
253: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
254: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
255: p_gt_id OUT NOCOPY NUMBER);
256:

Line 305: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

301: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
302: | |
303: +===========================================================================*/
304: PROCEDURE update_cm_related_columns(
305: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
306: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
307: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
308: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
309: p_freight_applied IN

Line 306: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

302: | |
303: +===========================================================================*/
304: PROCEDURE update_cm_related_columns(
305: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
306: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
307: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
308: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
309: p_freight_applied IN
310: ar_receivable_applications.freight_applied%TYPE,

Line 313: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

309: p_freight_applied IN
310: ar_receivable_applications.freight_applied%TYPE,
311: p_charges_applied IN
312: ar_receivable_applications.receivables_charges_applied%TYPE,
313: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
314: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
315: p_acctd_amount_applied OUT NOCOPY
316: ar_receivable_applications.acctd_amount_applied_to%TYPE,
317: p_ps_rec IN ar_payment_schedules%ROWTYPE,

Line 314: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

310: ar_receivable_applications.freight_applied%TYPE,
311: p_charges_applied IN
312: ar_receivable_applications.receivables_charges_applied%TYPE,
313: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
314: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
315: p_acctd_amount_applied OUT NOCOPY
316: ar_receivable_applications.acctd_amount_applied_to%TYPE,
317: p_ps_rec IN ar_payment_schedules%ROWTYPE,
318: p_update_credit_flag IN VARCHAR2 DEFAULT NULL );

Line 317: p_ps_rec IN ar_payment_schedules%ROWTYPE,

313: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
314: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
315: p_acctd_amount_applied OUT NOCOPY
316: ar_receivable_applications.acctd_amount_applied_to%TYPE,
317: p_ps_rec IN ar_payment_schedules%ROWTYPE,
318: p_update_credit_flag IN VARCHAR2 DEFAULT NULL );
319: --
320: /*===========================================================================+
321: | PROCEDURE |

Line 351: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

347: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
348: | |
349: +===========================================================================*/
350: PROCEDURE update_adj_related_columns(
351: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
352: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
353: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
354: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
355: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,

Line 356: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

352: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
353: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
354: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
355: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
356: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
357: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
358: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
359: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
360: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);

Line 357: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

353: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
354: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
355: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
356: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
357: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
358: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
359: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
360: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
361:

Line 358: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

354: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
355: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
356: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
357: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
358: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
359: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
360: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
361:
362: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8

Line 360: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);

356: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
357: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
358: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
359: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
360: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
361:
362: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
363: --
364: /*===========================================================================+

Line 408: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

404: | IN OUT NOCOPY in update_adj_related_columns |
405: | |
406: +===========================================================================*/
407: PROCEDURE update_adj_related_columns(
408: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
409: p_type IN ar_adjustments.type%TYPE,
410: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
411: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
412: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 410: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,

406: +===========================================================================*/
407: PROCEDURE update_adj_related_columns(
408: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
409: p_type IN ar_adjustments.type%TYPE,
410: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
411: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
412: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
413: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
414: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 411: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

407: PROCEDURE update_adj_related_columns(
408: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
409: p_type IN ar_adjustments.type%TYPE,
410: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
411: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
412: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
413: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
414: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
415: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 416: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

412: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
413: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
414: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
415: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
416: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
417: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
418: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
419: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
420: --

Line 417: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

413: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
414: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
415: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
416: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
417: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
418: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
419: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
420: --
421: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8

Line 419: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);

415: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
416: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
417: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
418: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
419: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
420: --
421: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
422:
423: /*===========================================================================+

Line 496: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

492: | 16-APR-98 GJWANG Bug Fix: 653643 declare this as public procedure |
493: | |
494: +===========================================================================*/
495: PROCEDURE populate_closed_dates(
496: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
497: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
498: p_app_type IN VARCHAR2,
499: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
500:

Line 497: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

493: | |
494: +===========================================================================*/
495: PROCEDURE populate_closed_dates(
496: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
497: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
498: p_app_type IN VARCHAR2,
499: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
500:
501:

Line 499: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );

495: PROCEDURE populate_closed_dates(
496: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
497: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
498: p_app_type IN VARCHAR2,
499: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
500:
501:
502: END ARP_PS_UTIL;