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_CCC_PKG dependencies on AR_CUSTOMER_CALLS

Line 4: p_customer_id IN ar_customer_calls.customer_id%type,

1: PACKAGE BODY arp_ccc_pkg AS
2: /* $Header: ARCUECCB.pls 115.2 2002/11/15 02:27:24 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,

Line 5: p_collector_id IN ar_customer_calls.collector_id%type,

1: PACKAGE BODY arp_ccc_pkg AS
2: /* $Header: ARCUECCB.pls 115.2 2002/11/15 02:27:24 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,

Line 6: p_call_date IN ar_customer_calls.call_date%type,

2: /* $Header: ARCUECCB.pls 115.2 2002/11/15 02:27:24 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,

Line 7: p_site_use_id IN ar_customer_calls.site_use_id%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,

Line 8: p_status IN ar_customer_calls.status%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,

Line 9: p_promise_date IN ar_customer_calls.promise_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,

Line 10: p_promise_amount IN ar_customer_calls.promise_amount%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,

Line 11: p_call_outcome IN ar_customer_calls.call_outcome%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,

Line 12: p_forecast_date IN ar_customer_calls.forecast_date%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,

Line 13: p_collection_forecast IN ar_customer_calls.collection_forecast%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,

Line 14: p_contact_id IN ar_customer_calls.contact_id%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,

Line 15: p_phone_id IN ar_customer_calls.phone_id%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,

Line 16: p_fax_id IN ar_customer_calls.fax_id%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,

Line 17: p_reason_code IN ar_customer_calls.reason_code%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,

Line 18: p_currency_code IN ar_customer_calls.currency_code%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,

Line 19: p_attribute_category IN ar_customer_calls.attribute_category%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,

Line 20: p_attribute1 IN ar_customer_calls.attribute1%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,

Line 21: p_attribute2 IN ar_customer_calls.attribute2%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,

Line 22: p_attribute3 IN ar_customer_calls.attribute3%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,

Line 23: p_attribute4 IN ar_customer_calls.attribute4%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,

Line 24: p_attribute5 IN ar_customer_calls.attribute5%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,

Line 25: p_attribute6 IN ar_customer_calls.attribute6%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,

Line 26: p_attribute7 IN ar_customer_calls.attribute7%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,

Line 27: p_attribute8 IN ar_customer_calls.attribute8%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,

Line 28: p_attribute9 IN ar_customer_calls.attribute9%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,

Line 29: p_attribute10 IN ar_customer_calls.attribute10%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,

Line 30: p_attribute11 IN ar_customer_calls.attribute11%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,

Line 31: p_attribute12 IN ar_customer_calls.attribute12%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,

Line 32: p_attribute13 IN ar_customer_calls.attribute13%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,

Line 33: p_attribute14 IN ar_customer_calls.attribute14%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,

Line 34: p_attribute15 IN ar_customer_calls.attribute15%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

Line 35: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%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: ) IS

Line 36: p_follow_up_date IN ar_customer_calls.follow_up_date%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: ) IS
40:

Line 37: p_follow_up_action IN ar_customer_calls.follow_up_action%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: ) IS
40:
41: l_call_rec ar_customer_calls%rowtype;

Line 38: p_complete_flag IN ar_customer_calls.complete_flag%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: ) IS
40:
41: l_call_rec ar_customer_calls%rowtype;
42:

Line 41: l_call_rec ar_customer_calls%rowtype;

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: ) IS
40:
41: l_call_rec ar_customer_calls%rowtype;
42:
43: BEGIN
44:
45: /*-------------------------------------------------+

Line 306: PROCEDURE update_call_cover (p_status IN ar_customer_calls.status%type,

302: arp_cce_pkg.insert_notification(l_notification_rec);
303: END insert_notification_cover;
304:
305:
306: PROCEDURE update_call_cover (p_status IN ar_customer_calls.status%type,
307: p_rowid IN VARCHAR2,
308: p_complete_flag IN ar_customer_calls.complete_flag%type) IS
309:
310: l_call_rec ar_customer_calls%rowtype;

Line 308: p_complete_flag IN ar_customer_calls.complete_flag%type) IS

304:
305:
306: PROCEDURE update_call_cover (p_status IN ar_customer_calls.status%type,
307: p_rowid IN VARCHAR2,
308: p_complete_flag IN ar_customer_calls.complete_flag%type) IS
309:
310: l_call_rec ar_customer_calls%rowtype;
311:
312: BEGIN

Line 310: l_call_rec ar_customer_calls%rowtype;

306: PROCEDURE update_call_cover (p_status IN ar_customer_calls.status%type,
307: p_rowid IN VARCHAR2,
308: p_complete_flag IN ar_customer_calls.complete_flag%type) IS
309:
310: l_call_rec ar_customer_calls%rowtype;
311:
312: BEGIN
313:
314: l_call_rec.status := p_status;