APPS.ARP_PS_UTIL dependencies on AR_ADJUSTMENTS

Line 1555: p_type IN ar_adjustments.type%TYPE,

1551: | Finance Charges having tax code source attached.
1552: +===========================================================================*/
1553: PROCEDURE update_adj_related_columns(
1554: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1555: p_type IN ar_adjustments.type%TYPE,
1556: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1557: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1558: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1559: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

2261: | |
2262: | DESCRIPTION |
2263: | Determines gl_date_closed and actual_date_closed for a payment |
2264: | schedule. For each of the two, it returns the greatest date from |
2265: | ar_receivable_applications, ar_adjustments, and the input current |
2266: | date. If it finds no values for a date, a null string is returned. |
2267: | |
2268: | NOTE: This function does not correctly handle applications for future|
2269: | items or future cash receipts. If an application or adjustment that |

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

2271: | gl_date/trx_date or the cash receipt's gl_date/deposit_date, then the|
2272: | gl_date_closed/actual_date_closed should be the greatest dates - the |
2273: | ones from the item or cash receipt. The dates returned by armclps |
2274: | will be less than the correct ones because this function selects |
2275: | only from ar_receivable_applications, ar_adjustments and the input |
2276: | "current" dates.
2277: | |
2278: | |
2279: | SCOPE - PUBLIC |

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

2282: | schedule |
2283: | p_gl_reversal_date - gl_date of current uncommitted |
2284: | transaction |
2285: | p_reversal_date - apply date of current uncommitted xtion |
2286: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
2287: | ar_receivable_applications.gl_date, and |
2288: | current_gl_date. |
2289: | p_actual_date_closed - (output) greatest of |
2290: | ar_adjustments.apply_date, |

Line 2290: | ar_adjustments.apply_date, |

2286: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
2287: | ar_receivable_applications.gl_date, and |
2288: | current_gl_date. |
2289: | p_actual_date_closed - (output) greatest of |
2290: | ar_adjustments.apply_date, |
2291: | ar_receivable_applications.apply_date, |
2292: | and current_apply_date. |
2293: | |
2294: | MODIFICATION HISTORY - |

Line 2352: -- Get max dates from ar_adjustments

2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug('get_closed_dates: ' || ' after select appln' );
2350: END IF;
2351: --
2352: -- Get max dates from ar_adjustments
2353: --
2354: /* 18-MAY-2000 J Rautiainen BR Implementation
2355: * Added Bills Receivable transaction */
2356: /* Bug fix 3243565 : Deposits, Debit Memos and Chargebacks can also be

Line 2363: FROM ar_adjustments

2359: SELECT MAX(gl_date),
2360: MAX(apply_date)
2361: INTO l_gl_adj,
2362: l_act_adj
2363: FROM ar_adjustments
2364: WHERE status = 'A'
2365: AND payment_schedule_id = p_ps_id;
2366: END IF;
2367: --