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_CALL_TOPICS

Line 144: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,

140:
141:
142:
143: PROCEDURE insert_topic_cover (
144: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
145: p_customer_id IN ar_customer_call_topics.customer_id%type,
146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,

Line 145: p_customer_id IN ar_customer_call_topics.customer_id%type,

141:
142:
143: PROCEDURE insert_topic_cover (
144: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
145: p_customer_id IN ar_customer_call_topics.customer_id%type,
146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,

Line 146: p_collector_id IN ar_customer_call_topics.collector_id%type,

142:
143: PROCEDURE insert_topic_cover (
144: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
145: p_customer_id IN ar_customer_call_topics.customer_id%type,
146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,

Line 147: p_call_date IN ar_customer_call_topics.call_date%type,

143: PROCEDURE insert_topic_cover (
144: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
145: p_customer_id IN ar_customer_call_topics.customer_id%type,
146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,

Line 148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,

144: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
145: p_customer_id IN ar_customer_call_topics.customer_id%type,
146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,

Line 149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,

145: p_customer_id IN ar_customer_call_topics.customer_id%type,
146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,

Line 150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,

146: p_collector_id IN ar_customer_call_topics.collector_id%type,
147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,

Line 151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,

147: p_call_date IN ar_customer_call_topics.call_date%type,
148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,

Line 152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,

148: p_site_use_id IN ar_customer_call_topics.site_use_id%type,
149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,

Line 153: p_promise_date IN ar_customer_call_topics.promise_date%type,

149: p_payment_schedule_id IN ar_customer_call_topics.payment_schedule_id%type,
150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,

Line 154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,

150: p_customer_trx_id IN ar_customer_call_topics.customer_trx_id%type,
151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,

Line 155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,

151: p_customer_trx_line_id IN ar_customer_call_topics.customer_trx_line_id%type,
152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,

Line 156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,

152: p_cash_receipt_id IN ar_customer_call_topics.cash_receipt_id%type,
153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,

Line 157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,

153: p_promise_date IN ar_customer_call_topics.promise_date%type,
154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,

Line 158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,

154: p_promise_amount IN ar_customer_call_topics.promise_amount%type,
155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,

Line 159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,

155: p_follow_up_date IN ar_customer_call_topics.follow_up_date%type,
156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,

Line 160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,

156: p_follow_up_action IN ar_customer_call_topics.follow_up_action%type,
157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,

Line 161: p_contact_id IN ar_customer_call_topics.contact_id%type,

157: p_follow_up_company_rep_id IN ar_customer_call_topics.follow_up_company_rep_id%type,
158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,

Line 162: p_phone_id IN ar_customer_call_topics.phone_id%type,

158: p_call_outcome IN ar_customer_call_topics.call_outcome%type,
159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,

Line 163: p_reason_code IN ar_customer_call_topics.reason_code%type,

159: p_forecast_date IN ar_customer_call_topics.forecast_date%type,
160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,

Line 164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,

160: p_collection_forecast IN ar_customer_call_topics.collection_forecast%type,
161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,

Line 165: p_attribute1 IN ar_customer_call_topics.attribute1%type,

161: p_contact_id IN ar_customer_call_topics.contact_id%type,
162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,

Line 166: p_attribute2 IN ar_customer_call_topics.attribute2%type,

162: p_phone_id IN ar_customer_call_topics.phone_id%type,
163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,

Line 167: p_attribute3 IN ar_customer_call_topics.attribute3%type,

163: p_reason_code IN ar_customer_call_topics.reason_code%type,
164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,

Line 168: p_attribute4 IN ar_customer_call_topics.attribute4%type,

164: p_attribute_category IN ar_customer_call_topics.attribute_category%type,
165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,

Line 169: p_attribute5 IN ar_customer_call_topics.attribute5%type,

165: p_attribute1 IN ar_customer_call_topics.attribute1%type,
166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,

Line 170: p_attribute6 IN ar_customer_call_topics.attribute6%type,

166: p_attribute2 IN ar_customer_call_topics.attribute2%type,
167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,

Line 171: p_attribute7 IN ar_customer_call_topics.attribute7%type,

167: p_attribute3 IN ar_customer_call_topics.attribute3%type,
168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,

Line 172: p_attribute8 IN ar_customer_call_topics.attribute8%type,

168: p_attribute4 IN ar_customer_call_topics.attribute4%type,
169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,

Line 173: p_attribute9 IN ar_customer_call_topics.attribute9%type,

169: p_attribute5 IN ar_customer_call_topics.attribute5%type,
170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,

Line 174: p_attribute10 IN ar_customer_call_topics.attribute10%type,

170: p_attribute6 IN ar_customer_call_topics.attribute6%type,
171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,

Line 175: p_attribute11 IN ar_customer_call_topics.attribute11%type,

171: p_attribute7 IN ar_customer_call_topics.attribute7%type,
172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,

Line 176: p_attribute12 IN ar_customer_call_topics.attribute12%type,

172: p_attribute8 IN ar_customer_call_topics.attribute8%type,
173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,
180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,

Line 177: p_attribute13 IN ar_customer_call_topics.attribute13%type,

173: p_attribute9 IN ar_customer_call_topics.attribute9%type,
174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,
180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
181: p_complete_flag IN ar_customer_call_topics.complete_flag%type

Line 178: p_attribute14 IN ar_customer_call_topics.attribute14%type,

174: p_attribute10 IN ar_customer_call_topics.attribute10%type,
175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,
180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
181: p_complete_flag IN ar_customer_call_topics.complete_flag%type
182: ) IS

Line 179: p_attribute15 IN ar_customer_call_topics.attribute15%type,

175: p_attribute11 IN ar_customer_call_topics.attribute11%type,
176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,
180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
181: p_complete_flag IN ar_customer_call_topics.complete_flag%type
182: ) IS
183:

Line 180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,

176: p_attribute12 IN ar_customer_call_topics.attribute12%type,
177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,
180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
181: p_complete_flag IN ar_customer_call_topics.complete_flag%type
182: ) IS
183:
184: l_topic_rec ar_customer_call_topics%rowtype;

Line 181: p_complete_flag IN ar_customer_call_topics.complete_flag%type

177: p_attribute13 IN ar_customer_call_topics.attribute13%type,
178: p_attribute14 IN ar_customer_call_topics.attribute14%type,
179: p_attribute15 IN ar_customer_call_topics.attribute15%type,
180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
181: p_complete_flag IN ar_customer_call_topics.complete_flag%type
182: ) IS
183:
184: l_topic_rec ar_customer_call_topics%rowtype;
185:

Line 184: l_topic_rec ar_customer_call_topics%rowtype;

180: p_topic_id OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type,
181: p_complete_flag IN ar_customer_call_topics.complete_flag%type
182: ) IS
183:
184: l_topic_rec ar_customer_call_topics%rowtype;
185:
186: BEGIN
187:
188: /*---------------------+

Line 324: PROCEDURE update_topic_cover (p_complete_flag IN ar_customer_call_topics.complete_flag%type,

320:
321:
322:
323:
324: PROCEDURE update_topic_cover (p_complete_flag IN ar_customer_call_topics.complete_flag%type,
325: p_customer_call_topic_id IN ar_customer_call_topics.customer_call_topic_id%type,
326: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
327: p_rowid IN varchar2) IS
328:

Line 325: p_customer_call_topic_id IN ar_customer_call_topics.customer_call_topic_id%type,

321:
322:
323:
324: PROCEDURE update_topic_cover (p_complete_flag IN ar_customer_call_topics.complete_flag%type,
325: p_customer_call_topic_id IN ar_customer_call_topics.customer_call_topic_id%type,
326: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
327: p_rowid IN varchar2) IS
328:
329: l_topic_rec ar_customer_call_topics%rowtype;

Line 326: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,

322:
323:
324: PROCEDURE update_topic_cover (p_complete_flag IN ar_customer_call_topics.complete_flag%type,
325: p_customer_call_topic_id IN ar_customer_call_topics.customer_call_topic_id%type,
326: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
327: p_rowid IN varchar2) IS
328:
329: l_topic_rec ar_customer_call_topics%rowtype;
330:

Line 329: l_topic_rec ar_customer_call_topics%rowtype;

325: p_customer_call_topic_id IN ar_customer_call_topics.customer_call_topic_id%type,
326: p_customer_call_id IN ar_customer_call_topics.customer_call_id%type,
327: p_rowid IN varchar2) IS
328:
329: l_topic_rec ar_customer_call_topics%rowtype;
330:
331: BEGIN
332:
333: l_topic_rec.complete_flag := p_complete_flag;