APPS.ARP_DISPUTE_HISTORY dependencies on AR_DISPUTE_HISTORY

Line 18: UPDATE ar_dispute_history

14: p_LastUpdateDate IN DATE,
15: p_lastUpdateLogin IN NUMBER ) IS
16: BEGIN
17:
18: UPDATE ar_dispute_history
19: SET end_date = nvl(p_DisputeDate,
20: greatest(p_OldDisputeDate, sysdate))
21: WHERE payment_schedule_id = p_PaymentScheduleId
22: AND end_date IS NULL;

Line 25: INSERT INTO ar_dispute_history (

21: WHERE payment_schedule_id = p_PaymentScheduleId
22: AND end_date IS NULL;
23:
24:
25: INSERT INTO ar_dispute_history (
26: dispute_history_id,
27: payment_schedule_id,
28: amount_in_dispute,
29: amount_due_remaining,

Line 38: ar_dispute_history_s.nextval,

34: last_updated_by,
35: last_update_date,
36: last_update_login )
37: VALUES (
38: ar_dispute_history_s.nextval,
39: p_OldPaymentScheduleId,
40: NVL(p_AmountInDispute, 0),
41: p_AmountDueRemaining,
42: DECODE(p_OldAmountInDispute, NULL, NVL(p_AmountInDispute,0),