1 PACKAGE ARP_PROCESS_CUTIL AS
2 /* $Header: ARCEUTLS.pls 120.2 2005/10/30 04:14:15 appldev ship $ */
3 /*============================================================================+
4 | MODIFICATION HISTORY |
5 | 27-FEB-02 Pravin Pawar Added new procedure update_ps_fdate. |
6 | Bug:2218144 |
7 | This is used to update follow_up_date_last |
8 | into PS table from cust call window. |
9 +=============================================================================+*/
10 procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
11 p_due_date IN ar_payment_schedules.due_date%TYPE,
12 p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
13 p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
14 p_update_dff IN VARCHAR2,
15 p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
16 p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
17 p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
18 p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
19 p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
20 p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
21 p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
22 p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
23 p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
24 p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
25 p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
26 p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
27 p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
28 p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
29 p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
30 p_attribute15 IN ar_payment_schedules.attribute15%TYPE,
31 p_staged_dunning_level IN ar_payment_schedules.staged_dunning_level%TYPE DEFAULT NULL,
32 p_dunning_level_override_date IN ar_payment_schedules.dunning_level_override_date%TYPE DEFAULT NULL,
33 p_global_attribute_category IN ar_payment_schedules.global_attribute_category%TYPE,
34 p_global_attribute1 IN ar_payment_schedules.global_attribute1%TYPE,
35 p_global_attribute2 IN ar_payment_schedules.global_attribute2%TYPE,
36 p_global_attribute3 IN ar_payment_schedules.global_attribute3%TYPE,
37 p_global_attribute4 IN ar_payment_schedules.global_attribute4%TYPE,
38 p_global_attribute5 IN ar_payment_schedules.global_attribute5%TYPE,
39 p_global_attribute6 IN ar_payment_schedules.global_attribute6%TYPE,
40 p_global_attribute7 IN ar_payment_schedules.global_attribute7%TYPE,
41 p_global_attribute8 IN ar_payment_schedules.global_attribute8%TYPE,
42 p_global_attribute9 IN ar_payment_schedules.global_attribute9%TYPE,
43 p_global_attribute10 IN ar_payment_schedules.global_attribute10%TYPE,
44 p_global_attribute11 IN ar_payment_schedules.global_attribute11%TYPE,
45 p_global_attribute12 IN ar_payment_schedules.global_attribute12%TYPE,
46 p_global_attribute13 IN ar_payment_schedules.global_attribute13%TYPE,
47 p_global_attribute14 IN ar_payment_schedules.global_attribute14%TYPE,
48 p_global_attribute15 IN ar_payment_schedules.global_attribute15%TYPE,
49 p_global_attribute16 IN ar_payment_schedules.global_attribute16%TYPE,
50 p_global_attribute17 IN ar_payment_schedules.global_attribute17%TYPE,
51 p_global_attribute18 IN ar_payment_schedules.global_attribute18%TYPE,
52 p_global_attribute19 IN ar_payment_schedules.global_attribute19%TYPE,
53 p_global_attribute20 IN ar_payment_schedules.global_attribute20%TYPE
54 ) ;
55 procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
56 p_due_date IN ar_payment_schedules.due_date%TYPE,
57 p_amount_in_dispute IN ar_payment_schedules.amount_in_dispute%TYPE,
58 p_dispute_date IN ar_payment_schedules.dispute_date%TYPE,
59 p_update_dff IN VARCHAR2,
60 p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
61 p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
62 p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
63 p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
64 p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
65 p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
66 p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
67 p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
68 p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
69 p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
70 p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
71 p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
72 p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
73 p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
74 p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
75 p_attribute15 IN ar_payment_schedules.attribute15%TYPE
76 ) ;
77 procedure update_ps( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
78 p_exclude_from_dunning IN ar_payment_schedules.exclude_from_dunning_flag%TYPE,
79 p_update_dff IN VARCHAR2,
80 p_attribute_category IN ar_payment_schedules.attribute_category%TYPE,
81 p_attribute1 IN ar_payment_schedules.attribute1%TYPE,
82 p_attribute2 IN ar_payment_schedules.attribute2%TYPE,
83 p_attribute3 IN ar_payment_schedules.attribute3%TYPE,
84 p_attribute4 IN ar_payment_schedules.attribute4%TYPE,
85 p_attribute5 IN ar_payment_schedules.attribute5%TYPE,
86 p_attribute6 IN ar_payment_schedules.attribute6%TYPE,
87 p_attribute7 IN ar_payment_schedules.attribute7%TYPE,
88 p_attribute8 IN ar_payment_schedules.attribute8%TYPE,
89 p_attribute9 IN ar_payment_schedules.attribute9%TYPE,
90 p_attribute10 IN ar_payment_schedules.attribute10%TYPE,
91 p_attribute11 IN ar_payment_schedules.attribute11%TYPE,
92 p_attribute12 IN ar_payment_schedules.attribute12%TYPE,
93 p_attribute13 IN ar_payment_schedules.attribute13%TYPE,
94 p_attribute14 IN ar_payment_schedules.attribute14%TYPE,
95 p_attribute15 IN ar_payment_schedules.attribute15%TYPE
96 ) ;
97 procedure update_ps_fdate( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
98 p_follow_up_date IN ar_payment_schedules.follow_up_date_last%TYPE
99 ) ;
100 End;