APPS.ARP_PS_UTIL dependencies on AR_ADJUSTMENTS

Line 1685: p_type IN ar_adjustments.type%TYPE,

1681: | Finance Charges having tax code source attached.
1682: +===========================================================================*/
1683: PROCEDURE update_adj_related_columns(
1684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1685: p_type IN ar_adjustments.type%TYPE,
1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1689: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

2391: | |
2392: | DESCRIPTION |
2393: | Determines gl_date_closed and actual_date_closed for a payment |
2394: | schedule. For each of the two, it returns the greatest date from |
2395: | ar_receivable_applications, ar_adjustments, and the input current |
2396: | date. If it finds no values for a date, a null string is returned. |
2397: | |
2398: | NOTE: This function does not correctly handle applications for future|
2399: | items or future cash receipts. If an application or adjustment that |

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

2401: | gl_date/trx_date or the cash receipt's gl_date/deposit_date, then the|
2402: | gl_date_closed/actual_date_closed should be the greatest dates - the |
2403: | ones from the item or cash receipt. The dates returned by armclps |
2404: | will be less than the correct ones because this function selects |
2405: | only from ar_receivable_applications, ar_adjustments and the input |
2406: | "current" dates.
2407: | |
2408: | |
2409: | SCOPE - PUBLIC |

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

2412: | schedule |
2413: | p_gl_reversal_date - gl_date of current uncommitted |
2414: | transaction |
2415: | p_reversal_date - apply date of current uncommitted xtion |
2416: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
2417: | ar_receivable_applications.gl_date, and |
2418: | current_gl_date. |
2419: | p_actual_date_closed - (output) greatest of |
2420: | ar_adjustments.apply_date, |

Line 2420: | ar_adjustments.apply_date, |

2416: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
2417: | ar_receivable_applications.gl_date, and |
2418: | current_gl_date. |
2419: | p_actual_date_closed - (output) greatest of |
2420: | ar_adjustments.apply_date, |
2421: | ar_receivable_applications.apply_date, |
2422: | and current_apply_date. |
2423: | |
2424: | MODIFICATION HISTORY - |

Line 2482: -- Get max dates from ar_adjustments

2478: IF PG_DEBUG in ('Y', 'C') THEN
2479: arp_debug.debug('get_closed_dates: ' || ' after select appln' );
2480: END IF;
2481: --
2482: -- Get max dates from ar_adjustments
2483: --
2484: /* 18-MAY-2000 J Rautiainen BR Implementation
2485: * Added Bills Receivable transaction */
2486: /* Bug fix 3243565 : Deposits, Debit Memos and Chargebacks can also be

Line 2493: FROM ar_adjustments

2489: SELECT MAX(gl_date),
2490: MAX(apply_date)
2491: INTO l_gl_adj,
2492: l_act_adj
2493: FROM ar_adjustments
2494: WHERE status = 'A'
2495: AND payment_schedule_id = p_ps_id;
2496: END IF;
2497: --