APPS.ARP_PROCESS_HEADER dependencies on AR_PAYMENT_SCHEDULES

Line 199: ar_payment_schedules.amount_in_dispute%type,

195: ra_cust_trx_line_gl_dist.gl_date%type,
196: p_new_open_rec_flag IN
197: ra_cust_trx_types.accounting_affect_flag%type,
198: p_ps_dispute_amount IN
199: ar_payment_schedules.amount_in_dispute%type,
200: pd_dispute_date IN DATE,
201: p_ex_rate_changed_flag OUT NOCOPY boolean,
202: p_commitment_changed_flag OUT NOCOPY boolean,
203: p_gl_date_changed_flag OUT NOCOPY boolean,

Line 215: l_old_dispute_amount ar_payment_schedules.amount_in_dispute%type;

211:
212: l_old_trx_rec ra_customer_trx%rowtype;
213: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
214: l_old_open_rec_flag ra_cust_trx_types.accounting_affect_flag%type;
215: l_old_dispute_amount ar_payment_schedules.amount_in_dispute%type;
216: ld_old_dispute_date DATE;
217:
218: BEGIN
219:

Line 317: FROM ar_payment_schedules ps

313: , MAX(ps.dispute_date)
314: INTO l_old_dispute_amount,
315: p_number_of_payment_schedules
316: , ld_old_dispute_date
317: FROM ar_payment_schedules ps
318: WHERE ps.customer_trx_id = p_customer_trx_id;
319:
320: -- Return true if amount or date was changed
321: IF (p_ps_dispute_amount <> l_old_dispute_amount

Line 1069: | would cause the whole ar_payment_schedules

1065: | 29-NOV-95 Nigel Smith Added calls to Tax Engine. |
1066: | 10/10/1996 Harri Kaukovuo Added parameter pd_dispute_date
1067: | to set_flags().
1068: | Fixed bug when updating dispute amount
1069: | would cause the whole ar_payment_schedules
1070: | to be updated.
1071: +===========================================================================*/
1072:
1073: PROCEDURE update_header(

Line 1244: FROM ar_payment_schedules

1240: SELECT payment_schedule_id,
1241: amount_in_dispute,
1242: amount_due_remaining,
1243: dispute_date
1244: FROM ar_payment_schedules
1245: WHERE customer_trx_id = p_ctrx_id;
1246: l_old_dispute_date DATE;
1247: l_new_dispute_date DATE;
1248: l_old_dispute_amount NUMBER;

Line 1295: UPDATE ar_payment_schedules ps

1291: l_last_update_login);
1292: END IF;
1293: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
1294: CLOSE get_existing_ps;
1295: UPDATE ar_payment_schedules ps
1296: SET ps.amount_in_dispute = DECODE(p_ps_dispute_amount,
1297: NULL, ps.amount_in_dispute,
1298: 0, 0,
1299: DECODE(l_number_of_pay_scheds,