1: PACKAGE arp_ccc_pkg AUTHID CURRENT_USER AS
2: /* $Header: ARCUECCS.pls 115.2 2002/11/15 02:27:35 anukumar ship $ */
3: PROCEDURE insert_call_cover (
4: p_customer_id IN ar_customer_calls.customer_id%type,
5: p_collector_id IN ar_customer_calls.collector_id%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
1: PACKAGE arp_ccc_pkg AUTHID CURRENT_USER AS
2: /* $Header: ARCUECCS.pls 115.2 2002/11/15 02:27:35 anukumar ship $ */
3: PROCEDURE insert_call_cover (
4: p_customer_id IN ar_customer_calls.customer_id%type,
5: p_collector_id IN ar_customer_calls.collector_id%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
2: /* $Header: ARCUECCS.pls 115.2 2002/11/15 02:27:35 anukumar ship $ */
3: PROCEDURE insert_call_cover (
4: p_customer_id IN ar_customer_calls.customer_id%type,
5: p_collector_id IN ar_customer_calls.collector_id%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
3: PROCEDURE insert_call_cover (
4: p_customer_id IN ar_customer_calls.customer_id%type,
5: p_collector_id IN ar_customer_calls.collector_id%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
4: p_customer_id IN ar_customer_calls.customer_id%type,
5: p_collector_id IN ar_customer_calls.collector_id%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
5: p_collector_id IN ar_customer_calls.collector_id%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
6: p_call_date IN ar_customer_calls.call_date%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
7: p_site_use_id IN ar_customer_calls.site_use_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
8: p_status IN ar_customer_calls.status%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
9: p_promise_date IN ar_customer_calls.promise_date%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
10: p_promise_amount IN ar_customer_calls.promise_amount%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
11: p_call_outcome IN ar_customer_calls.call_outcome%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
12: p_forecast_date IN ar_customer_calls.forecast_date%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
13: p_collection_forecast IN ar_customer_calls.collection_forecast%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
14: p_contact_id IN ar_customer_calls.contact_id%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
15: p_phone_id IN ar_customer_calls.phone_id%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
16: p_fax_id IN ar_customer_calls.fax_id%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
17: p_reason_code IN ar_customer_calls.reason_code%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
18: p_currency_code IN ar_customer_calls.currency_code%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
19: p_attribute_category IN ar_customer_calls.attribute_category%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
20: p_attribute1 IN ar_customer_calls.attribute1%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
21: p_attribute2 IN ar_customer_calls.attribute2%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
22: p_attribute3 IN ar_customer_calls.attribute3%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
23: p_attribute4 IN ar_customer_calls.attribute4%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
24: p_attribute5 IN ar_customer_calls.attribute5%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
25: p_attribute6 IN ar_customer_calls.attribute6%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
26: p_attribute7 IN ar_customer_calls.attribute7%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
27: p_attribute8 IN ar_customer_calls.attribute8%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
28: p_attribute9 IN ar_customer_calls.attribute9%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
29: p_attribute10 IN ar_customer_calls.attribute10%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
37: p_follow_up_action IN ar_customer_calls.follow_up_action%type,
30: p_attribute11 IN ar_customer_calls.attribute11%type,
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
37: p_follow_up_action IN ar_customer_calls.follow_up_action%type,
38: p_complete_flag IN ar_customer_calls.complete_flag%type
31: p_attribute12 IN ar_customer_calls.attribute12%type,
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
37: p_follow_up_action IN ar_customer_calls.follow_up_action%type,
38: p_complete_flag IN ar_customer_calls.complete_flag%type
39: );
32: p_attribute13 IN ar_customer_calls.attribute13%type,
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
37: p_follow_up_action IN ar_customer_calls.follow_up_action%type,
38: p_complete_flag IN ar_customer_calls.complete_flag%type
39: );
40:
33: p_attribute14 IN ar_customer_calls.attribute14%type,
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
37: p_follow_up_action IN ar_customer_calls.follow_up_action%type,
38: p_complete_flag IN ar_customer_calls.complete_flag%type
39: );
40:
41:
34: p_attribute15 IN ar_customer_calls.attribute15%type,
35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type,
36: p_follow_up_date IN ar_customer_calls.follow_up_date%type,
37: p_follow_up_action IN ar_customer_calls.follow_up_action%type,
38: p_complete_flag IN ar_customer_calls.complete_flag%type
39: );
40:
41:
42: PROCEDURE insert_note_cover (
109: p_call_action_id IN ar_action_notifications.call_action_id%type,
110: p_employee_id IN ar_action_notifications.employee_id%type);
111:
112:
113: PROCEDURE update_call_cover (p_status IN ar_customer_calls.status%type,
114: p_rowid IN VARCHAR2,
115: p_complete_flag IN ar_customer_calls.complete_flag%type
116: );
117:
111:
112:
113: PROCEDURE update_call_cover (p_status IN ar_customer_calls.status%type,
114: p_rowid IN VARCHAR2,
115: p_complete_flag IN ar_customer_calls.complete_flag%type
116: );
117:
118: PROCEDURE update_topic_cover (p_complete_flag IN ar_customer_call_topics.complete_flag%type,
119: p_customer_call_topic_id IN ar_customer_call_topics.customer_call_topic_id%type,