DBA Data[Home] [Help]

APPS.ARP_PS_UTIL dependencies on AR_ADJUSTMENTS

Line 409: p_type IN ar_adjustments.type%TYPE,

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

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

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

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

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

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

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

Line 455: | ar_adjustments.apply_date, |

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