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,
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,
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,
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,
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 (
43 p_note_type IN ar_notes.note_type%type,
44 p_text IN ar_notes.text%type,
45 p_customer_call_id IN ar_notes.customer_call_id%type,
46 p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
47 p_call_action_id IN ar_notes.call_action_id%type,
48 p_note_id OUT NOCOPY ar_notes.note_id%type);
49
50
51
52 PROCEDURE insert_topic_cover (
53 p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
54 p_customer_id IN ar_customer_call_topics.customer_id%type,
55 p_collector_id IN ar_customer_call_topics.collector_id%type,
56 p_call_date IN ar_customer_call_topics.call_date%type,
57 p_site_use_id IN ar_customer_call_topics.site_use_id%type,
58 p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
59 p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
60 p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
61 p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
62 p_promise_date IN ar_customer_call_topics.promise_date%type,
63 p_promise_amount IN ar_customer_call_topics.promise_amount%type,
64 p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
65 p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
66 p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
67 p_call_outcome IN ar_customer_call_topics.call_outcome%type,
68 p_forecast_date IN ar_customer_call_topics.forecast_date%type,
69 p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
70 p_contact_id IN ar_customer_call_topics.contact_id%type,
71 p_phone_id IN ar_customer_call_topics.phone_id%type,
72 p_reason_code IN ar_customer_call_topics.reason_code%type,
73 p_attribute_category IN ar_customer_call_topics.attribute_category%type,
74 p_attribute1 IN ar_customer_call_topics.attribute1%type,
75 p_attribute2 IN ar_customer_call_topics.attribute2%type,
76 p_attribute3 IN ar_customer_call_topics.attribute3%type,
77 p_attribute4 IN ar_customer_call_topics.attribute4%type,
78 p_attribute5 IN ar_customer_call_topics.attribute5%type,
79 p_attribute6 IN ar_customer_call_topics.attribute6%type,
80 p_attribute7 IN ar_customer_call_topics.attribute7%type,
81 p_attribute8 IN ar_customer_call_topics.attribute8%type,
82 p_attribute9 IN ar_customer_call_topics.attribute9%type,
83 p_attribute10 IN ar_customer_call_topics.attribute10%type,
84 p_attribute11 IN ar_customer_call_topics.attribute11%type,
85 p_attribute12 IN ar_customer_call_topics.attribute12%type,
86 p_attribute13 IN ar_customer_call_topics.attribute13%type,
87 p_attribute14 IN ar_customer_call_topics.attribute14%type,
88 p_attribute15 IN ar_customer_call_topics.attribute15%type,
89 p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
90 p_complete_flag IN ar_customer_call_topics.complete_flag%type
91
92 );
93
94
95
96 PROCEDURE insert_action_cover (
97 p_customer_call_id IN ar_call_actions.customer_call_id%type,
98 p_customer_call_topic_id IN ar_call_actions.customer_call_topic_id%type,
99 p_action_code IN ar_call_actions.action_code%type,
100 p_action_amount IN ar_call_actions.action_amount%type,
101 p_partial_flag IN ar_call_actions.partial_invoice_amount_flag%type,
102 p_complete_flag IN ar_call_actions.complete_flag%type,
103 p_action_date IN ar_call_actions.action_date%type,
104 p_action_id IN OUT NOCOPY ar_call_actions.call_action_id%type,
105 p_notif_id IN ar_action_notifications.employee_id%type);
106
107
108 PROCEDURE insert_notification_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
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,
120 p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
121 p_rowid IN varchar2);
122
123 PROCEDURE update_action_cover (p_complete_flag IN ar_call_actions.complete_flag%type,
124 p_call_action_id IN ar_call_actions.call_action_id%type,
125 p_customer_call_id IN ar_call_actions.customer_call_id%type,
126 p_customer_call_topic_id IN ar_call_actions.customer_call_topic_id%type,
127 p_rowid IN varchar2);
128
129
130 END arp_ccc_pkg;