eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_CUTIL dependencies on AR_PAYMENT_SCHEDULES

Line 33: FROM ar_payment_schedules

29: customer_site_use_id,
30: class,
31: trx_date,
32: dispute_date
33: FROM ar_payment_schedules
34: WHERE payment_schedule_id = p_ps_id;
35:
36:
37: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 37: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

33: FROM ar_payment_schedules
34: WHERE payment_schedule_id = p_ps_id;
35:
36:
37: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
38: p_due_date IN ar_payment_schedules.due_date%TYPE,
39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,

Line 38: p_due_date IN ar_payment_schedules.due_date%TYPE,

34: WHERE payment_schedule_id = p_ps_id;
35:
36:
37: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
38: p_due_date IN ar_payment_schedules.due_date%TYPE,
39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,

Line 39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,

35:
36:
37: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
38: p_due_date IN ar_payment_schedules.due_date%TYPE,
39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,

Line 40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,

36:
37: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
38: p_due_date IN ar_payment_schedules.due_date%TYPE,
39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,

Line 42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,

38: p_due_date IN ar_payment_schedules.due_date%TYPE,
39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,

Line 43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,

39: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,

Line 44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,

40: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,

Line 45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,

41: p_update_dff IN VARCHAR2,
42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,

Line 46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,

42: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,

Line 47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,

43: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,

Line 48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,

44: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,

Line 49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,

45: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,

Line 50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,

46: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,

Line 51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,

47: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,

Line 52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,

48: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,

Line 53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,

49: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,

Line 54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,

50: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,

Line 55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,

51: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,

Line 56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,

52: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,

Line 57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,

53: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,

Line 58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,

54: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,

Line 59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,

55: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,

Line 60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,

56: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,

Line 61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,

57: p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,

Line 62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,

58: p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE,
59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,

Line 63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,

59: p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE,
60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,

Line 64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,

60: p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,

Line 65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,

61: p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,

Line 66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,

62: p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,

Line 67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,

63: p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,

Line 68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,

64: p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,

Line 69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,

65: p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,

Line 70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,

66: p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,

Line 71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,

67: p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,

Line 72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,

68: p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,

Line 73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,

69: p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,

Line 74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,

70: p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,

Line 75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,

71: p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,

Line 76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,

72: p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,
80: p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE

Line 77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,

73: p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,
80: p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE
81: ) IS

Line 78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,

74: p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,
80: p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE
81: ) IS
82: BEGIN

Line 79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,

75: p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,
80: p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE
81: ) IS
82: BEGIN
83:

Line 80: p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE

76: p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
77: p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
78: p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
79: p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,
80: p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE
81: ) IS
82: BEGIN
83:
84: OPEN get_existing_ps(p_ps_id);

Line 136: THEN UPDATE ar_payment_schedules

132: CLOSE get_existing_ps;
133: /*4021729 set the last update date at time of saving record*/
134: l_last_update_date := SYSDATE;
135: IF p_update_dff = 'Y'
136: THEN UPDATE ar_payment_schedules
137: SET staged_dunning_level = p_staged_dunning_level,
138: dunning_level_override_date = p_dunning_level_override_date,
139: due_date = p_due_date,
140: amount_in_dispute = p_amount_in_dispute,

Line 183: ELSE UPDATE ar_payment_schedules

179: last_updated_by = l_last_updated_by,
180: last_update_login = l_last_update_login,
181: last_update_date = l_last_update_date
182: WHERE payment_schedule_id = p_ps_id;
183: ELSE UPDATE ar_payment_schedules
184: SET staged_dunning_level = p_staged_dunning_level,
185: dunning_level_override_date = p_dunning_level_override_date,
186: due_date = p_due_date,
187: amount_in_dispute = p_amount_in_dispute,

Line 218: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

214: Overloaded the procedure so that it can be used by ARXCOECC (Call form) which
215: does not want dunning related fields to be updated. This is used when a transaction
216: is put on dispute from calls form
217: */
218: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
219: p_due_date IN ar_payment_schedules.due_date%TYPE,
220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,

Line 219: p_due_date IN ar_payment_schedules.due_date%TYPE,

215: does not want dunning related fields to be updated. This is used when a transaction
216: is put on dispute from calls form
217: */
218: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
219: p_due_date IN ar_payment_schedules.due_date%TYPE,
220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,

Line 220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,

216: is put on dispute from calls form
217: */
218: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
219: p_due_date IN ar_payment_schedules.due_date%TYPE,
220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,

Line 221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,

217: */
218: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
219: p_due_date IN ar_payment_schedules.due_date%TYPE,
220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,

Line 223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,

219: p_due_date IN ar_payment_schedules.due_date%TYPE,
220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,

Line 224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,

220: p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,

Line 225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,

221: p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,

Line 226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,

222: p_update_dff IN VARCHAR2,
223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,

Line 227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,

223: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,

Line 228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,

224: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,

Line 229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,

225: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,

Line 230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,

226: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,

Line 231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,

227: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,

Line 232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,

228: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,

Line 233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,

229: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,

Line 234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,

230: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
238: p_attribute15 IN ar_payment_schedules.attribute15%TYPE

Line 235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,

231: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
238: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
239: )IS

Line 236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,

232: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
238: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
239: )IS
240: BEGIN

Line 237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,

233: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
238: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
239: )IS
240: BEGIN
241:

Line 238: p_attribute15 IN ar_payment_schedules.attribute15%TYPE

234: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
235: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
236: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
237: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
238: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
239: )IS
240: BEGIN
241:
242: OPEN get_existing_ps(p_ps_id);

Line 295: THEN UPDATE ar_payment_schedules

291: CLOSE get_existing_ps;
292: /*4021729 set the last update date at time of saving record*/
293: l_last_update_date := SYSDATE;
294: IF p_update_dff = 'Y'
295: THEN UPDATE ar_payment_schedules
296: SET due_date = p_due_date,
297: amount_in_dispute = p_amount_in_dispute,
298: dispute_date = p_dispute_date,
299: attribute_category = p_attribute_category,

Line 319: ELSE UPDATE ar_payment_schedules

315: last_updated_by = l_last_updated_by,
316: last_update_login = l_last_update_login,
317: last_update_date = l_last_update_date
318: WHERE payment_schedule_id = p_ps_id;
319: ELSE UPDATE ar_payment_schedules
320: SET due_date = p_due_date,
321: amount_in_dispute = p_amount_in_dispute,
322: dispute_date = p_dispute_date,
323: last_updated_by = l_last_updated_by,

Line 346: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

342: THEN arp_standard.debug('EXCEPTION: ARP_PROCESS_CUTIL.update_ps ARXCOECC Dispute Action');
343: RAISE;
344:
345: END;
346: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
347: p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,
348: p_update_dff VARCHAR2,
349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,

Line 347: p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,

343: RAISE;
344:
345: END;
346: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
347: p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,
348: p_update_dff VARCHAR2,
349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,

Line 349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,

345: END;
346: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
347: p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,
348: p_update_dff VARCHAR2,
349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,

Line 350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,

346: procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
347: p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,
348: p_update_dff VARCHAR2,
349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,

Line 351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,

347: p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,
348: p_update_dff VARCHAR2,
349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,

Line 352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,

348: p_update_dff VARCHAR2,
349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,

Line 353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,

349: p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,

Line 354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,

350: p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,

Line 355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,

351: p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,

Line 356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,

352: p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,

Line 357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,

353: p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,

Line 358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,

354: p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,

Line 359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,

355: p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,

Line 360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,

356: p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
364: p_attribute15 IN ar_payment_schedules.attribute15%TYPE

Line 361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,

357: p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
364: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
365: )

Line 362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,

358: p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
364: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
365: )
366: IS

Line 363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,

359: p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
364: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
365: )
366: IS
367: BEGIN

Line 364: p_attribute15 IN ar_payment_schedules.attribute15%TYPE

360: p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
361: p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
362: p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
363: p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
364: p_attribute15 IN ar_payment_schedules.attribute15%TYPE
365: )
366: IS
367: BEGIN
368: /*4021729 set the last update date at time of saving record*/

Line 371: THEN UPDATE ar_payment_schedules

367: BEGIN
368: /*4021729 set the last update date at time of saving record*/
369: l_last_update_date := SYSDATE;
370: IF p_update_dff = 'Y'
371: THEN UPDATE ar_payment_schedules
372: SET exclude_from_dunning_flag = p_exclude_from_dunning,
373: attribute_category = p_attribute_category,
374: attribute1 = p_attribute1,
375: attribute2 = p_attribute2,

Line 393: ELSE UPDATE ar_payment_schedules

389: last_updated_by = l_last_updated_by,
390: last_update_login = l_last_update_login,
391: last_update_date = l_last_update_date
392: WHERE payment_schedule_id = p_ps_id;
393: ELSE UPDATE ar_payment_schedules
394: SET exclude_from_dunning_flag = p_exclude_from_dunning,
395: last_updated_by = l_last_updated_by,
396: last_update_login = l_last_update_login,
397: last_update_date = l_last_update_date

Line 407: procedure update_ps_fdate( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

403: THEN arp_standard.debug('EXCEPTION: ARP_PROCESS_CUTIL.update_ps Dunning Action');
404: RAISE;
405:
406: END;
407: procedure update_ps_fdate( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
408: p_follow_up_date IN ar_payment_schedules.follow_up_date_last%TYPE)
409: IS
410: BEGIN
411: IF p_ps_id IS NOT NULL THEN

Line 408: p_follow_up_date IN ar_payment_schedules.follow_up_date_last%TYPE)

404: RAISE;
405:
406: END;
407: procedure update_ps_fdate( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
408: p_follow_up_date IN ar_payment_schedules.follow_up_date_last%TYPE)
409: IS
410: BEGIN
411: IF p_ps_id IS NOT NULL THEN
412: UPDATE ar_payment_schedules

Line 412: UPDATE ar_payment_schedules

408: p_follow_up_date IN ar_payment_schedules.follow_up_date_last%TYPE)
409: IS
410: BEGIN
411: IF p_ps_id IS NOT NULL THEN
412: UPDATE ar_payment_schedules
413: SET follow_up_date_last = p_follow_up_date
414: WHERE payment_schedule_id = p_ps_id;
415: END IF;
416: EXCEPTION