DBA Data[Home] [Help]

APPS.ARP_PS_UTIL dependencies on AR_ADJUSTMENTS

Line 406: p_type IN ar_adjustments.type%TYPE,

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,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 427: | ar_receivable_applications, ar_adjustments, and the input current |

423: | |
424: | DESCRIPTION |
425: | Determines gl_date_closed and actual_date_closed for a payment |
426: | schedule. For each of the two, it returns the greatest date from |
427: | ar_receivable_applications, ar_adjustments, and the input current |
428: | date. If it finds no values for a date, a null string is returned. |
429: | |
430: | NOTE: This function does not correctly handle applications for future|
431: | items or future cash receipts. If an application or adjustment that |

Line 437: | only from ar_receivable_applications, ar_adjustments and the input |

433: | gl_date/trx_date or the cash receipt's gl_date/deposit_date, then the|
434: | gl_date_closed/actual_date_closed should be the greatest dates - the |
435: | ones from the item or cash receipt. The dates returned by armclps |
436: | will be less than the correct ones because this function selects |
437: | only from ar_receivable_applications, ar_adjustments and the input |
438: | "current" dates.
439: | |
440: | |
441: | SCOPE - PUBLIC |

Line 448: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |

444: | schedule |
445: | p_gl_reversal_date - gl_date of current uncommitted |
446: | transaction |
447: | p_reversal_date - apply date of current uncommitted xtion |
448: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
449: | ar_receivable_applications.gl_date, and |
450: | current_gl_date. |
451: | p_actual_date_closed - (output) greatest of |
452: | ar_adjustments.apply_date, |

Line 452: | ar_adjustments.apply_date, |

448: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
449: | ar_receivable_applications.gl_date, and |
450: | current_gl_date. |
451: | p_actual_date_closed - (output) greatest of |
452: | ar_adjustments.apply_date, |
453: | ar_receivable_applications.apply_date, |
454: | and current_apply_date. |
455: | |
456: +===========================================================================*/