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, greatest(nvl(p_OldDisputeDate,sysdate-1), sysdate))
20: WHERE payment_schedule_id = p_PaymentScheduleId
21: AND end_date IS NULL;
22:

Line 26: INSERT INTO ar_dispute_history (

22:
23: if nvl(p_AmountInDispute,0) <> 0 then
24: -- 4640133 : insert row only for non-zero dispute amount
25:
26: INSERT INTO ar_dispute_history (
27: dispute_history_id,
28: payment_schedule_id,
29: amount_in_dispute,
30: amount_due_remaining,

Line 39: ar_dispute_history_s.nextval,

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