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 307: ar_payment_schedules.payment_schedule_id%TYPE,

303: p_gl_date IN DATE,
304: p_ccid IN
305: ar_receivable_applications.code_combination_id%TYPE,
306: p_payment_schedule_id IN
307: ar_payment_schedules.payment_schedule_id%TYPE,
308: p_application_rule IN ar_receivable_applications.application_rule%TYPE,
309: p_reversal_gl_date IN DATE default null,
310: p_ra_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
311: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project

Line 2211: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

2207: | 19-NOV-96 OSTEINME created |
2208: +===========================================================================*/
2209:
2210: PROCEDURE get_ps_rec( p_cash_receipt_id IN NUMBER,
2211: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
2212:
2213: l_ps_id NUMBER;
2214:
2215: BEGIN

Line 2219: FROM ar_payment_schedules

2215: BEGIN
2216:
2217: SELECT payment_schedule_id
2218: INTO l_ps_id
2219: FROM ar_payment_schedules
2220: WHERE cash_receipt_id = p_cash_receipt_id;
2221:
2222: -- the following should utimately be done with nowaitlock_fetch_p (but
2223: -- it didn't exist yet when this function was written and tested).