APPS.ARP_PROC_RCT_UTIL dependencies on AR_PAYMENT_SCHEDULES

Line 55: ar_payment_schedules.acctd_amount_due_remaining%TYPE,

51: p_cr_rec IN ar_cash_receipts%ROWTYPE,
52: p_gl_date IN DATE,
53: p_maturity_date IN DATE,
54: p_acctd_amount IN
55: ar_payment_schedules.acctd_amount_due_remaining%TYPE,
56: p_ps_id OUT NOCOPY
57: ar_payment_schedules.payment_schedule_id%TYPE
58: ) IS
59:

Line 57: ar_payment_schedules.payment_schedule_id%TYPE

53: p_maturity_date IN DATE,
54: p_acctd_amount IN
55: ar_payment_schedules.acctd_amount_due_remaining%TYPE,
56: p_ps_id OUT NOCOPY
57: ar_payment_schedules.payment_schedule_id%TYPE
58: ) IS
59:
60: l_ps_rec ar_payment_schedules%ROWTYPE;
61: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

Line 60: l_ps_rec ar_payment_schedules%ROWTYPE;

56: p_ps_id OUT NOCOPY
57: ar_payment_schedules.payment_schedule_id%TYPE
58: ) IS
59:
60: l_ps_rec ar_payment_schedules%ROWTYPE;
61: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
62:
63: l_status ar_cash_receipt_history.status%TYPE;
64: BEGIN

Line 61: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

57: ar_payment_schedules.payment_schedule_id%TYPE
58: ) IS
59:
60: l_ps_rec ar_payment_schedules%ROWTYPE;
61: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
62:
63: l_status ar_cash_receipt_history.status%TYPE;
64: BEGIN
65:

Line 298: ar_payment_schedules.payment_schedule_id%TYPE,

294: p_gl_date IN DATE,
295: p_ccid IN
296: ar_receivable_applications.code_combination_id%TYPE,
297: p_payment_schedule_id IN
298: ar_payment_schedules.payment_schedule_id%TYPE,
299: p_application_rule IN ar_receivable_applications.application_rule%TYPE,
300: p_reversal_gl_date IN DATE default null,
301: p_ra_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
302: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project

Line 2196: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

2192: | 19-NOV-96 OSTEINME created |
2193: +===========================================================================*/
2194:
2195: PROCEDURE get_ps_rec( p_cash_receipt_id IN NUMBER,
2196: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
2197:
2198: l_ps_id NUMBER;
2199:
2200: BEGIN

Line 2204: FROM ar_payment_schedules

2200: BEGIN
2201:
2202: SELECT payment_schedule_id
2203: INTO l_ps_id
2204: FROM ar_payment_schedules
2205: WHERE cash_receipt_id = p_cash_receipt_id;
2206:
2207: -- the following should utimately be done with nowaitlock_fetch_p (but
2208: -- it didn't exist yet when this function was written and tested).