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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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:
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: );
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:
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:
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:
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,
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,