[Home] [Help]
PACKAGE BODY: APPS.CSD_GEN_UTILITY_PVT
Source
1 PACKAGE BODY csd_gen_utility_pvt AS
2 /* $Header: csdvtgub.pls 120.1 2005/08/17 15:14:34 swai noship $*/
3
4 PROCEDURE set_debug_on IS
5 l_audsid NUMBER;
6 l_sid NUMBER;
7 l_os_user VARCHAR2(30);
8 BEGIN
9 IF csd_gen_utility_pvt.g_debug = fnd_api.g_false THEN
10 IF csd_gen_utility_pvt.g_file IS NULL THEN
11 SELECT USERENV('SESSIONID') INTO l_audsid FROM sys.dual;
12
13 SELECT sid, SUBSTR(osuser,1,8) INTO l_sid ,l_os_user
14 FROM v$session
15 WHERE audsid = l_audsid;
16
17 SELECT l_os_user||'.csd'||TO_CHAR(l_sid)||'.dbg'
18 INTO csd_gen_utility_pvt.g_file
19 FROM dual;
20 csd_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'w');
21 ELSE
22 csd_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
23 END IF;
24 csd_gen_utility_pvt.g_debug := fnd_api.g_true;
25 END IF;
26 EXCEPTION
27 WHEN OTHERS THEN
28 NULL;
29 END set_debug_on;
30
31 PROCEDURE set_debug_off IS
32 BEGIN
33 IF csd_gen_utility_pvt.is_debug_on THEN
34 utl_file.fclose(csd_gen_utility_pvt.g_file_ptr);
35 csd_gen_utility_pvt.g_debug := fnd_api.g_false;
36 END IF;
37 END set_debug_off;
38
39 FUNCTION is_debug_on RETURN BOOLEAN
40 IS
41 BEGIN
42 IF csd_gen_utility_pvt.g_debug = fnd_api.g_true THEN
43 RETURN TRUE;
44 ELSE
45 RETURN FALSE;
46 END IF;
47 END is_debug_on;
48
49 PROCEDURE ADD(
50 p_debug_msg IN VARCHAR2)
51 IS
52 BEGIN
53 --csd_gen_utility_pvt.add(p_debug_msg);
54 IF csd_gen_utility_pvt.g_debug_level > 0 THEN
55 set_debug_on;
56 IF is_debug_on THEN
57 IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
58 fnd_log.string(fnd_log.level_statement,'csd.plsql.csd_gen_utility_pvt',p_debug_msg);
59 END IF;
60 utl_file.put_line(g_file_ptr, p_debug_msg);
61 utl_file.fflush(g_file_ptr);
62 END IF;
63 END IF;
64 END ADD;
65
66 PROCEDURE dump_api_info(
67 p_pkg_name IN VARCHAR2,
68 p_api_name IN VARCHAR2)
69 IS
70 BEGIN
71 csd_gen_utility_pvt.ADD('Inside API :'||p_pkg_name||'.'||p_api_name);
72 END dump_api_info;
73
74 PROCEDURE dump_error_stack
75 IS
76 l_msg_count NUMBER;
77 l_msg_data VARCHAR2(2000);
78 l_msg_index_out NUMBER;
79 BEGIN
80 fnd_msg_pub.count_and_get(
81 p_count => l_msg_count,
82 p_data => l_msg_data);
83 FOR l_ind IN 1..l_msg_count
84 LOOP
85 fnd_msg_pub.get(
86 p_msg_index => l_ind,
87 p_encoded => fnd_api.g_false,
88 p_data => l_msg_data,
89 p_msg_index_out => l_msg_index_out);
90 csd_gen_utility_pvt.ADD('Error: '||l_msg_data);
91 END LOOP;
92 END dump_error_stack;
93
94 FUNCTION dump_error_stack RETURN VARCHAR2
95 IS
96 l_msg_count NUMBER;
97 l_msg_data VARCHAR2(2000);
98 l_msg_index_out NUMBER;
99 x_msg_data VARCHAR2(4000);
100 BEGIN
101 fnd_msg_pub.count_and_get(
102 p_count => l_msg_count,
103 p_data => l_msg_data);
104 FOR l_ind IN 1..l_msg_count
105 LOOP
106 fnd_msg_pub.get(
107 p_msg_index => l_ind,
108 p_encoded => fnd_api.g_false,
109 p_data => l_msg_data,
110 p_msg_index_out => l_msg_index_out);
111 x_msg_data := LTRIM(x_msg_data||' '||l_msg_data);
112 END LOOP;
113 RETURN x_msg_data;
114 EXCEPTION
115 WHEN OTHERS THEN
116 csd_gen_utility_pvt.ADD('Error in dump_error_stack:'||SQLERRM);
117 RETURN x_msg_data;
118 END dump_error_stack;
119
120 PROCEDURE dump_prod_txn_rec (
121 p_prod_txn_rec IN csd_process_pvt.product_txn_rec)
122 IS
123 l_rec csd_process_pvt.product_txn_rec;
124 BEGIN
125 l_rec := p_prod_txn_rec;
126
127 IF csd_gen_utility_pvt.g_debug_level >= 5 THEN
128 csd_gen_utility_pvt.ADD(' Product Txn Rec');
129 csd_gen_utility_pvt.ADD(' product_transaction_id :'|| l_rec.product_transaction_id );
130 csd_gen_utility_pvt.ADD(' repair_line_id :'|| l_rec.repair_line_id );
131 csd_gen_utility_pvt.ADD(' estimate_detail_id :'|| l_rec.estimate_detail_id );
132 csd_gen_utility_pvt.ADD(' action_type :'|| l_rec.action_type );
133 csd_gen_utility_pvt.ADD(' action_code :'|| l_rec.action_code );
134 csd_gen_utility_pvt.ADD(' incident_id :'|| l_rec.incident_id );
135 csd_gen_utility_pvt.ADD(' transaction_type_id :'|| l_rec.transaction_type_id );
136 csd_gen_utility_pvt.ADD(' business_process_id :'|| l_rec.business_process_id );
137 csd_gen_utility_pvt.ADD(' txn_billing_type_id :'|| l_rec.txn_billing_type_id );
138 csd_gen_utility_pvt.ADD(' original_source_id :'|| l_rec.original_source_id );
139 csd_gen_utility_pvt.ADD(' source_id :'|| l_rec.source_id );
140 csd_gen_utility_pvt.ADD(' line_type_id :'|| l_rec.line_type_id );
141 csd_gen_utility_pvt.ADD(' order_number :'|| l_rec.order_number );
142 csd_gen_utility_pvt.ADD(' status :'|| l_rec.status );
143 csd_gen_utility_pvt.ADD(' currency_code :'|| l_rec.currency_code );
144 csd_gen_utility_pvt.ADD(' line_category_code :'|| l_rec.line_category_code );
145 csd_gen_utility_pvt.ADD(' unit_of_measure_code :'|| l_rec.unit_of_measure_code );
146 csd_gen_utility_pvt.ADD(' inventory_item_id :'|| l_rec.inventory_item_id );
147 csd_gen_utility_pvt.ADD(' revision :'|| l_rec.revision );
148 csd_gen_utility_pvt.ADD(' quantity :'|| l_rec.quantity );
149 csd_gen_utility_pvt.ADD(' serial_number :'|| l_rec.source_serial_number );
150 csd_gen_utility_pvt.ADD(' lot_number :'|| l_rec.lot_number );
151 csd_gen_utility_pvt.ADD(' instance_id :'|| l_rec.source_instance_id );
152 csd_gen_utility_pvt.ADD(' instance_number :'|| l_rec.source_instance_number );
153 csd_gen_utility_pvt.ADD(' price_list_id :'|| l_rec.price_list_id );
154 csd_gen_utility_pvt.ADD(' contract_id :'|| l_rec.contract_id );
155 csd_gen_utility_pvt.ADD(' sub_inventory :'|| l_rec.sub_inventory );
156 csd_gen_utility_pvt.ADD(' organization_id :'|| l_rec.organization_id );
157 csd_gen_utility_pvt.ADD(' invoice_to_org_id :'|| l_rec.invoice_to_org_id );
158 csd_gen_utility_pvt.ADD(' ship_to_org_id :'|| l_rec.ship_to_org_id );
159 csd_gen_utility_pvt.ADD(' no_charge_flag :'|| l_rec.no_charge_flag );
160 csd_gen_utility_pvt.ADD(' interface_to_om_flag :'|| l_rec.interface_to_om_flag );
161 csd_gen_utility_pvt.ADD(' book_sales_order_flag :'|| l_rec.book_sales_order_flag );
162 csd_gen_utility_pvt.ADD(' release_sales_order_flag :'|| l_rec.release_sales_order_flag );
163 csd_gen_utility_pvt.ADD(' ship_sales_order_flag :'|| l_rec.ship_sales_order_flag );
164 csd_gen_utility_pvt.ADD(' process_txn_flag :'|| l_rec.process_txn_flag );
165 csd_gen_utility_pvt.ADD(' return_reason :'|| l_rec.return_reason );
166 csd_gen_utility_pvt.ADD(' return_by_date :'|| l_rec.return_by_date );
167 csd_gen_utility_pvt.ADD(' object_version_number :'|| l_rec.object_version_number );
168 csd_gen_utility_pvt.ADD(' security_group_id :'|| l_rec.security_group_id );
169 END IF;
170 END dump_prod_txn_rec;
171
172 PROCEDURE dump_sr_rec (
173 p_sr_rec IN csd_process_pvt.service_request_rec
174 ) IS
175 l_rec csd_process_pvt.service_request_rec := p_sr_rec;
176 BEGIN
177 csd_gen_utility_pvt.ADD(' request_date :'|| l_rec.request_date );
178 csd_gen_utility_pvt.ADD(' type_id :'|| l_rec.type_id );
179 csd_gen_utility_pvt.ADD(' type_name :'|| l_rec.type_name );
180 csd_gen_utility_pvt.ADD(' status_id :'|| l_rec.status_id );
181 csd_gen_utility_pvt.ADD(' status_name :'|| l_rec.status_name );
182 csd_gen_utility_pvt.ADD(' severity_id :'|| l_rec.severity_id );
183 csd_gen_utility_pvt.ADD(' severity_name :'|| l_rec.severity_name );
184 csd_gen_utility_pvt.ADD(' urgency_id :'|| l_rec.urgency_id );
185 csd_gen_utility_pvt.ADD(' urgency_name :'|| l_rec.urgency_name );
186 csd_gen_utility_pvt.ADD(' closed_date :'|| l_rec.closed_date );
187 csd_gen_utility_pvt.ADD(' owner_id :'|| l_rec.owner_id );
188 csd_gen_utility_pvt.ADD(' owner_group_id :'|| l_rec.owner_group_id );
189 csd_gen_utility_pvt.ADD(' publish_flag :'|| l_rec.publish_flag );
190 csd_gen_utility_pvt.ADD(' summary :'|| l_rec.summary );
191 csd_gen_utility_pvt.ADD(' caller_type :'|| l_rec.caller_type );
192 csd_gen_utility_pvt.ADD(' customer_id :'|| l_rec.customer_id );
193 csd_gen_utility_pvt.ADD(' customer_number :'|| l_rec.customer_number );
194 csd_gen_utility_pvt.ADD(' employee_number :'|| l_rec.employee_number );
195 csd_gen_utility_pvt.ADD(' verify_cp_flag :'|| l_rec.verify_cp_flag );
196 csd_gen_utility_pvt.ADD(' customer_product_id :'|| l_rec.customer_product_id );
197 csd_gen_utility_pvt.ADD(' cp_ref_number :'|| l_rec.cp_ref_number );
198 csd_gen_utility_pvt.ADD(' inventory_item_id :'|| l_rec.inventory_item_id );
199 csd_gen_utility_pvt.ADD(' inventory_org_id :'|| l_rec.inventory_org_id );
200 csd_gen_utility_pvt.ADD(' current_serial_number:'|| l_rec.current_serial_number );
201 csd_gen_utility_pvt.ADD(' original_order_number:'|| l_rec.original_order_number );
202 csd_gen_utility_pvt.ADD(' purchase_order_num :'|| l_rec.purchase_order_num );
203 csd_gen_utility_pvt.ADD(' problem_code :'|| l_rec.problem_code );
204 csd_gen_utility_pvt.ADD(' exp_resolution_date :'|| l_rec.exp_resolution_date );
205 csd_gen_utility_pvt.ADD(' bill_to_site_use_id :'|| l_rec.bill_to_site_use_id );
206 csd_gen_utility_pvt.ADD(' ship_to_site_use_id :'|| l_rec.ship_to_site_use_id );
207 csd_gen_utility_pvt.ADD(' contract_id :'|| l_rec.contract_id );
208 csd_gen_utility_pvt.ADD(' account_id :'|| l_rec.account_id );
209 csd_gen_utility_pvt.ADD(' resource_type :'|| l_rec.resource_type );
210 csd_gen_utility_pvt.ADD(' cust_po_number :'|| l_rec.cust_po_number );
211 csd_gen_utility_pvt.ADD(' cp_revision_id :'|| l_rec.cp_revision_id );
212 csd_gen_utility_pvt.ADD(' inv_item_revision :'|| l_rec.inv_item_revision );
213 csd_gen_utility_pvt.ADD(' sr_contact_point_id :'|| l_rec.sr_contact_point_id );
214 csd_gen_utility_pvt.ADD(' party_id :'|| l_rec.party_id );
215 csd_gen_utility_pvt.ADD(' contact_point_id :'|| l_rec.contact_point_id );
216 csd_gen_utility_pvt.ADD(' contact_point_type :'|| l_rec.contact_point_type );
217 csd_gen_utility_pvt.ADD(' primary_flag :'|| l_rec.primary_flag );
218 csd_gen_utility_pvt.ADD(' contact_type :'|| l_rec.contact_type );
219 END dump_sr_rec;
220
221 PROCEDURE dump_estimate_rec (
222 p_estimate_rec IN csd_repair_estimate_pvt.repair_estimate_rec
223 ) IS
224 l_rec csd_repair_estimate_pvt.repair_estimate_rec := p_estimate_rec;
225
226 BEGIN
227
228 csd_gen_utility_pvt.add('repair_estimate_id :'||l_rec.repair_estimate_id);
229 csd_gen_utility_pvt.add('repair_line_id :'||l_rec.repair_line_id );
230 csd_gen_utility_pvt.add('note_id :'||l_rec.note_id );
231 csd_gen_utility_pvt.add('estimate_date :'||l_rec.estimate_date );
232 csd_gen_utility_pvt.add('estimate_status :'||l_rec.estimate_status );
233 csd_gen_utility_pvt.add('lead_time :'||l_rec.lead_time );
234 csd_gen_utility_pvt.add('lead_time_uom :'||l_rec.lead_time_uom );
235 csd_gen_utility_pvt.add('work_summary :'||l_rec.work_summary );
236 csd_gen_utility_pvt.add('po_number :'||l_rec.po_number );
237 csd_gen_utility_pvt.add('last_update_date :'||l_rec.last_update_date );
238 csd_gen_utility_pvt.add('creation_date :'||l_rec.creation_date );
239 csd_gen_utility_pvt.add('last_updated_by :'||l_rec.last_updated_by );
240 csd_gen_utility_pvt.add('created_by :'||l_rec.created_by );
241 csd_gen_utility_pvt.add('last_update_login :'||l_rec.last_update_login );
242 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
243 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
244 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
245 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
246 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
247 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
248 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
249 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
250 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
251 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
252 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
253 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
254 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
255 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
256 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
257 csd_gen_utility_pvt.add('context :'||l_rec.context );
258 csd_gen_utility_pvt.add('object_version_number:'||l_rec.object_version_number );
259 csd_gen_utility_pvt.add('security_group_id :'||l_rec.security_group_id );
260
261 END dump_estimate_rec;
262
263 PROCEDURE dump_estimate_line_rec
264 (
265 p_estimate_line_rec IN csd_repair_estimate_pvt.repair_estimate_line_rec
266 ) IS
267 l_rec csd_repair_estimate_pvt.repair_estimate_line_rec := p_estimate_line_rec;
268
269 BEGIN
270
271 csd_gen_utility_pvt.add('repair_estimate_line_id :'||l_rec.repair_estimate_line_id );
272 csd_gen_utility_pvt.add('repair_estimate_id :'||l_rec.repair_estimate_id );
273 csd_gen_utility_pvt.add('repair_line_id :'||l_rec.repair_line_id );
274 csd_gen_utility_pvt.add('estimate_detail_id :'||l_rec.estimate_detail_id );
275 csd_gen_utility_pvt.add('incident_id :'||l_rec.incident_id );
276 csd_gen_utility_pvt.add('transaction_type_id :'||l_rec.transaction_type_id );
277 csd_gen_utility_pvt.add('business_process_id :'||l_rec.business_process_id );
278 csd_gen_utility_pvt.add('txn_billing_type_id :'||l_rec.txn_billing_type_id );
279 csd_gen_utility_pvt.add('original_source_id :'||l_rec.original_source_id );
280 csd_gen_utility_pvt.add('original_source_code:'||l_rec.original_source_code );
281 csd_gen_utility_pvt.add('source_id :'||l_rec.source_id );
282 csd_gen_utility_pvt.add('source_code :'||l_rec.source_code );
283 csd_gen_utility_pvt.add('line_type_id :'||l_rec.line_type_id );
284 csd_gen_utility_pvt.add('item_cost :'||l_rec.item_cost );
285 csd_gen_utility_pvt.add('customer_product_id :'||l_rec.customer_product_id );
286 csd_gen_utility_pvt.add('reference_number :'||l_rec.reference_number );
287 csd_gen_utility_pvt.add('item_revision :'||l_rec.item_revision );
288 csd_gen_utility_pvt.add('justification_notes :'||l_rec.justification_notes );
289 csd_gen_utility_pvt.add('estimate_status :'||l_rec.estimate_status );
290 csd_gen_utility_pvt.add('order_number :'||l_rec.order_number );
291 csd_gen_utility_pvt.add('purchase_order_num :'||l_rec.purchase_order_num );
292 csd_gen_utility_pvt.add('source_number :'||l_rec.source_number );
293 csd_gen_utility_pvt.add('status :'||l_rec.status );
294 csd_gen_utility_pvt.add('currency_code :'||l_rec.currency_code );
295 csd_gen_utility_pvt.add('line_category_code :'||l_rec.line_category_code );
296 csd_gen_utility_pvt.add('unit_of_measure_code:'||l_rec.unit_of_measure_code );
297 csd_gen_utility_pvt.add('original_source_number:'||l_rec.original_source_number );
298 csd_gen_utility_pvt.add('order_header_id :'||l_rec.order_header_id );
299 csd_gen_utility_pvt.add('order_line_id :'||l_rec.order_line_id );
300 csd_gen_utility_pvt.add('inventory_item_id :'||l_rec.inventory_item_id );
301 csd_gen_utility_pvt.add('after_warranty_cost :'||l_rec.after_warranty_cost );
302 csd_gen_utility_pvt.add('selling_price :'||l_rec.selling_price );
303 csd_gen_utility_pvt.add('original_system_reference:'||l_rec.original_system_reference );
304 csd_gen_utility_pvt.add('estimate_quantity :'||l_rec.estimate_quantity );
305 csd_gen_utility_pvt.add('serial_number :'||l_rec.serial_number );
306 csd_gen_utility_pvt.add('lot_number :'||l_rec.lot_number );
307 csd_gen_utility_pvt.add('instance_id :'||l_rec.instance_id );
308 csd_gen_utility_pvt.add('instance_number :'||l_rec.instance_number );
309 csd_gen_utility_pvt.add('price_list_id :'||l_rec.price_list_id );
310 csd_gen_utility_pvt.add('contract_id :'||l_rec.contract_id );
311 csd_gen_utility_pvt.add('coverage_id :'||l_rec.coverage_id );
312 csd_gen_utility_pvt.add('coverage_txn_group_id:'||l_rec.coverage_txn_group_id );
313 csd_gen_utility_pvt.add('coverage_bill_rate_id:'||l_rec.coverage_bill_rate_id );
314 csd_gen_utility_pvt.add('sub_inventory :'||l_rec.sub_inventory );
315 csd_gen_utility_pvt.add('organization_id :'||l_rec.organization_id );
316 csd_gen_utility_pvt.add('invoice_to_org_id :'||l_rec.invoice_to_org_id );
317 csd_gen_utility_pvt.add('ship_to_org_id :'||l_rec.ship_to_org_id );
318 csd_gen_utility_pvt.add('no_charge_flag :'||l_rec.no_charge_flag );
319 csd_gen_utility_pvt.add('interface_to_om_flag:'||l_rec.interface_to_om_flag );
320 csd_gen_utility_pvt.add('return_reason :'||l_rec.return_reason );
321 csd_gen_utility_pvt.add('return_by_date :'||l_rec.return_by_date );
322 csd_gen_utility_pvt.add('last_update_date :'||l_rec.last_update_date );
323 csd_gen_utility_pvt.add('creation_date :'||l_rec.creation_date );
324 csd_gen_utility_pvt.add('last_updated_by :'||l_rec.last_updated_by );
325 csd_gen_utility_pvt.add('created_by :'||l_rec.created_by );
326 csd_gen_utility_pvt.add('last_update_login :'||l_rec.last_update_login );
327 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
328 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
329 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
330 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
331 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
332 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
333 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
334 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
335 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
336 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
337 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
338 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
339 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
340 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
341 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
342 csd_gen_utility_pvt.add('context :'||l_rec.context );
343 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
344 csd_gen_utility_pvt.add('security_group_id :'||l_rec.security_group_id );
345 csd_gen_utility_pvt.add('charge_line_type :'||l_rec.charge_line_type );
346 csd_gen_utility_pvt.add('apply_contract_discount :'||l_rec.apply_contract_discount );
347 csd_gen_utility_pvt.add('coverage_id :'||l_rec.coverage_id );
348 csd_gen_utility_pvt.add('coverage_txn_group_id :'||l_rec.coverage_txn_group_id );
349 csd_gen_utility_pvt.add('est_line_source_type_code:'||l_rec.est_line_source_type_code );
350 csd_gen_utility_pvt.add('est_line_source_id1 :'||l_rec.est_line_source_id1 );
351 csd_gen_utility_pvt.add('est_line_source_id2 :'||l_rec.est_line_source_id1 );
352 csd_gen_utility_pvt.add('ro_service_code_id :'||l_rec.ro_service_code_id );
353
354 END dump_estimate_line_rec;
355
356 PROCEDURE dump_repair_order_group_rec
357 (
358 p_repair_order_group_rec IN csd_repair_groups_pvt.repair_order_group_rec
359 ) IS
360 l_rec csd_repair_groups_pvt.repair_order_group_rec := p_repair_order_group_rec;
361
362 BEGIN
363
364 csd_gen_utility_pvt.add('repair_group_id :'||l_rec.repair_group_id );
365 csd_gen_utility_pvt.add('incident_id :'||l_rec.incident_id );
366 csd_gen_utility_pvt.add('repair_group_number :'||l_rec.repair_group_number );
367 csd_gen_utility_pvt.add('repair_type_id :'||l_rec.repair_type_id );
368 csd_gen_utility_pvt.add('inventory_item_id :'||l_rec.inventory_item_id );
369 csd_gen_utility_pvt.add('unit_of_measure :'||l_rec.unit_of_measure );
370 csd_gen_utility_pvt.add('group_quantity :'||l_rec.group_quantity );
371 csd_gen_utility_pvt.add('repair_order_quantity :'||l_rec.repair_order_quantity );
372 csd_gen_utility_pvt.add('rma_quantity :'||l_rec.rma_quantity );
373 csd_gen_utility_pvt.add('received_quantity :'||l_rec.received_quantity);
374 csd_gen_utility_pvt.add('approved_quantity :'||l_rec.approved_quantity );
375 csd_gen_utility_pvt.add('submitted_quantity :'||l_rec.submitted_quantity );
376 csd_gen_utility_pvt.add('completed_quantity :'||l_rec.completed_quantity );
377 csd_gen_utility_pvt.add('released_quantity :'||l_rec.released_quantity );
378 csd_gen_utility_pvt.add('shipped_quantity :'||l_rec.shipped_quantity );
379 csd_gen_utility_pvt.add('created_by :'||l_rec.created_by );
380 csd_gen_utility_pvt.add('creation_date :'||l_rec.creation_date );
381 csd_gen_utility_pvt.add('last_updated_by :'||l_rec.last_updated_by );
382 csd_gen_utility_pvt.add('last_update_date :'||l_rec.last_update_date );
383 csd_gen_utility_pvt.add('last_update_login :'||l_rec.last_update_login );
384 csd_gen_utility_pvt.add('context :'||l_rec.context );
385 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
386 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
387 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
388 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
389 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
390 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
391 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
392 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
393 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
394 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
395 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
396 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
397 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
398 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
399 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
400 csd_gen_utility_pvt.add('security_group_id :'||l_rec.security_group_id );
401 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number);
402 csd_gen_utility_pvt.add('group_txn_status :'||l_rec.group_txn_status );
403
404 END dump_repair_order_group_rec;
405
406
407 PROCEDURE dump_hz_person_rec (
408 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type
409 )
410 IS
411 BEGIN
412 csd_gen_utility_pvt.ADD('HZ_PARTY_V2PUB.person_rec_type');
413 csd_gen_utility_pvt.add('pre_name_adjunct :'||p_person_rec.person_pre_name_adjunct );
414 csd_gen_utility_pvt.add('first_name :'||p_person_rec.person_first_name );
415 csd_gen_utility_pvt.add('middle_name :'||p_person_rec.person_middle_name );
416 csd_gen_utility_pvt.add('last_name :'||p_person_rec.person_last_name );
417 csd_gen_utility_pvt.add('name_suffix :'||p_person_rec.person_name_suffix );
418 csd_gen_utility_pvt.add('title :'||p_person_rec.person_title );
419 csd_gen_utility_pvt.add('academic_title :'||p_person_rec.person_academic_title );
420 csd_gen_utility_pvt.add('previous_last_name :'||p_person_rec.person_previous_last_name );
421 csd_gen_utility_pvt.add('initials :'||p_person_rec.person_initials );
422 csd_gen_utility_pvt.add('known_as :'||p_person_rec.known_as );
423 csd_gen_utility_pvt.add('known_as2 :'||p_person_rec.known_as2 );
424 csd_gen_utility_pvt.add('known_as3 :'||p_person_rec.known_as3 );
425 csd_gen_utility_pvt.add('known_as4 :'||p_person_rec.known_as4 );
426 csd_gen_utility_pvt.add('known_as5 :'||p_person_rec.known_as5 );
427 csd_gen_utility_pvt.add('person_name_phonetic :'||p_person_rec.person_name_phonetic );
428 csd_gen_utility_pvt.add('first_name_phonetic :'||p_person_rec.person_first_name_phonetic );
429 csd_gen_utility_pvt.add('last_name_phonetic :'||p_person_rec.person_last_name_phonetic );
430 csd_gen_utility_pvt.add('middle_name_phonetic :'||p_person_rec.middle_name_phonetic );
431 csd_gen_utility_pvt.add('tax_reference :'||p_person_rec.tax_reference );
432 csd_gen_utility_pvt.add('jgzz_fiscal_code :'||p_person_rec.jgzz_fiscal_code );
433 csd_gen_utility_pvt.add('person_iden_type :'||p_person_rec.person_iden_type );
434 csd_gen_utility_pvt.add('person_identifier :'||p_person_rec.person_identifier );
435 csd_gen_utility_pvt.add('date_of_birth :'||p_person_rec.date_of_birth );
436 csd_gen_utility_pvt.add('place_of_birth :'||p_person_rec.place_of_birth );
437 csd_gen_utility_pvt.add('date_of_death :'||p_person_rec.date_of_death );
438 csd_gen_utility_pvt.add('gender :'||p_person_rec.gender );
439 csd_gen_utility_pvt.add('declared_ethnicity :'||p_person_rec.declared_ethnicity );
440 csd_gen_utility_pvt.add('marital_status :'||p_person_rec.marital_status );
441 csd_gen_utility_pvt.add('marital_status_effective_date :'||p_person_rec.marital_status_effective_date);
442 csd_gen_utility_pvt.add('personal_income :'||p_person_rec.personal_income);
443 csd_gen_utility_pvt.add('head_of_household_flag :'||p_person_rec.head_of_household_flag );
444 csd_gen_utility_pvt.add('household_income :'||p_person_rec.household_income);
445 csd_gen_utility_pvt.add('household_size :'||p_person_rec.household_size);
446 csd_gen_utility_pvt.add('rent_own_ind :'||p_person_rec.rent_own_ind );
447 csd_gen_utility_pvt.add('last_known_gps :'||p_person_rec.last_known_gps );
448 csd_gen_utility_pvt.add('internal_flag :'||p_person_rec.internal_flag );
449 csd_gen_utility_pvt.add('content_source_type :'||p_person_rec.content_source_type );
450 csd_gen_utility_pvt.add('attribute_category :'||p_person_rec.attribute_category );
451 csd_gen_utility_pvt.add('attribute1 :'||p_person_rec.attribute1 );
452 csd_gen_utility_pvt.add('attribute2 :'||p_person_rec.attribute2 );
453 csd_gen_utility_pvt.add('attribute3 :'||p_person_rec.attribute3 );
454 csd_gen_utility_pvt.add('attribute4 :'||p_person_rec.attribute4 );
455 csd_gen_utility_pvt.add('attribute5 :'||p_person_rec.attribute5 );
456 csd_gen_utility_pvt.add('attribute6 :'||p_person_rec.attribute6 );
457 csd_gen_utility_pvt.add('attribute7 :'||p_person_rec.attribute7 );
458 csd_gen_utility_pvt.add('attribute8 :'||p_person_rec.attribute8 );
459 csd_gen_utility_pvt.add('attribute9 :'||p_person_rec.attribute9 );
460 csd_gen_utility_pvt.add('attribute10 :'||p_person_rec.attribute10 );
461 csd_gen_utility_pvt.add('attribute11 :'||p_person_rec.attribute11 );
462 csd_gen_utility_pvt.add('attribute12 :'||p_person_rec.attribute12 );
463 csd_gen_utility_pvt.add('attribute13 :'||p_person_rec.attribute13 );
464 csd_gen_utility_pvt.add('attribute14 :'||p_person_rec.attribute14 );
465 csd_gen_utility_pvt.add('attribute15 :'||p_person_rec.attribute15 );
466 csd_gen_utility_pvt.add('attribute16 :'||p_person_rec.attribute16 );
467 csd_gen_utility_pvt.add('attribute17 :'||p_person_rec.attribute17 );
468 csd_gen_utility_pvt.add('attribute18 :'||p_person_rec.attribute18 );
469 csd_gen_utility_pvt.add('attribute19 :'||p_person_rec.attribute19 );
470 csd_gen_utility_pvt.add('attribute20 :'||p_person_rec.attribute20 );
471 csd_gen_utility_pvt.add('party_rec.party_id :'||p_person_rec.party_rec.party_id);
472 csd_gen_utility_pvt.add('party_rec.party_number :'||p_person_rec.party_rec.party_number );
473 csd_gen_utility_pvt.add('party_rec.validated_flag :'||p_person_rec.party_rec.validated_flag );
474 csd_gen_utility_pvt.add('party_rec.orig_system_reference :'||p_person_rec.party_rec.orig_system_reference );
475 csd_gen_utility_pvt.add('party_rec.status :'||p_person_rec.party_rec.status );
476 csd_gen_utility_pvt.add('party_rec.category_code :'||p_person_rec.party_rec.category_code );
477 csd_gen_utility_pvt.add('party_rec.salutation :'||p_person_rec.party_rec.salutation );
478 csd_gen_utility_pvt.add('party_rec.attribute_category :'||p_person_rec.party_rec.attribute_category );
479 csd_gen_utility_pvt.add('party_rec.attribute1 :'||p_person_rec.party_rec.attribute1 );
480 csd_gen_utility_pvt.add('party_rec.attribute2 :'||p_person_rec.party_rec.attribute2 );
481 csd_gen_utility_pvt.add('party_rec.attribute3 :'||p_person_rec.party_rec.attribute3 );
482 csd_gen_utility_pvt.add('party_rec.attribute4 :'||p_person_rec.party_rec.attribute4 );
483 csd_gen_utility_pvt.add('party_rec.attribute5 :'||p_person_rec.party_rec.attribute5 );
484 csd_gen_utility_pvt.add('party_rec.attribute6 :'||p_person_rec.party_rec.attribute6 );
485 csd_gen_utility_pvt.add('party_rec.attribute7 :'||p_person_rec.party_rec.attribute7 );
486 csd_gen_utility_pvt.add('party_rec.attribute8 :'||p_person_rec.party_rec.attribute8 );
487 csd_gen_utility_pvt.add('party_rec.attribute9 :'||p_person_rec.party_rec.attribute9 );
488 csd_gen_utility_pvt.add('party_rec.attribute10 :'||p_person_rec.party_rec.attribute10 );
489 csd_gen_utility_pvt.add('party_rec.attribute11 :'||p_person_rec.party_rec.attribute11 );
490 csd_gen_utility_pvt.add('party_rec.attribute12 :'||p_person_rec.party_rec.attribute12 );
491 csd_gen_utility_pvt.add('party_rec.attribute13 :'||p_person_rec.party_rec.attribute13 );
492 csd_gen_utility_pvt.add('party_rec.attribute14 :'||p_person_rec.party_rec.attribute14 );
493 csd_gen_utility_pvt.add('party_rec.attribute15 :'||p_person_rec.party_rec.attribute15 );
494 csd_gen_utility_pvt.add('party_rec.attribute16 :'||p_person_rec.party_rec.attribute16 );
495 csd_gen_utility_pvt.add('party_rec.attribute17 :'||p_person_rec.party_rec.attribute17 );
496 csd_gen_utility_pvt.add('party_rec.attribute18 :'||p_person_rec.party_rec.attribute18 );
497 csd_gen_utility_pvt.add('party_rec.attribute19 :'||p_person_rec.party_rec.attribute19 );
498 csd_gen_utility_pvt.add('party_rec.attribute20 :'||p_person_rec.party_rec.attribute20 );
499 csd_gen_utility_pvt.add('party_rec.attribute21 :'||p_person_rec.party_rec.attribute21 );
500 csd_gen_utility_pvt.add('party_rec.attribute22 :'||p_person_rec.party_rec.attribute22 );
501 csd_gen_utility_pvt.add('party_rec.attribute23 :'||p_person_rec.party_rec.attribute23 );
502 csd_gen_utility_pvt.add('party_rec.attribute24 :'||p_person_rec.party_rec.attribute24 );
503 END dump_hz_person_rec;
504
505
506 PROCEDURE dump_hz_org_rec (
507 p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type
508 )
509 IS
510 BEGIN
511 csd_gen_utility_pvt.ADD('HZ_PARTY_V2PUB.organization_rec_type');
512 csd_gen_utility_pvt.add('organization_name :'||p_org_rec.organization_name );
513 -- csd_gen_utility_pvt.add('duns_number :'||p_org_rec.duns_number);
514 csd_gen_utility_pvt.add('duns_number_c :'||p_org_rec.duns_number_c );
515 csd_gen_utility_pvt.add('enquiry_duns :'||p_org_rec.enquiry_duns );
516 csd_gen_utility_pvt.add('ceo_name :'||p_org_rec.ceo_name );
517 csd_gen_utility_pvt.add('ceo_title :'||p_org_rec.ceo_title );
518 csd_gen_utility_pvt.add('principal_name :'||p_org_rec.principal_name );
519 csd_gen_utility_pvt.add('principal_title :'||p_org_rec.principal_title );
520 csd_gen_utility_pvt.add('legal_status :'||p_org_rec.legal_status );
521 csd_gen_utility_pvt.add('control_yr :'||p_org_rec.control_yr);
522 csd_gen_utility_pvt.add('employees_total :'||p_org_rec.employees_total);
523 csd_gen_utility_pvt.add('hq_branch_ind :'||p_org_rec.hq_branch_ind );
524 csd_gen_utility_pvt.add('branch_flag :'||p_org_rec.branch_flag );
525 csd_gen_utility_pvt.add('oob_ind :'||p_org_rec.oob_ind );
526 csd_gen_utility_pvt.add('line_of_business :'||p_org_rec.line_of_business );
527 csd_gen_utility_pvt.add('cong_dist_code :'||p_org_rec.cong_dist_code );
528 csd_gen_utility_pvt.add('sic_code :'||p_org_rec.sic_code );
529 csd_gen_utility_pvt.add('import_ind :'||p_org_rec.import_ind );
530 csd_gen_utility_pvt.add('export_ind :'||p_org_rec.export_ind );
531 csd_gen_utility_pvt.add('labor_surplus_ind :'||p_org_rec.labor_surplus_ind );
532 csd_gen_utility_pvt.add('debarment_ind :'||p_org_rec.debarment_ind );
533 csd_gen_utility_pvt.add('minority_owned_ind :'||p_org_rec.minority_owned_ind );
534 csd_gen_utility_pvt.add('minority_owned_type :'||p_org_rec.minority_owned_type );
535 csd_gen_utility_pvt.add('woman_owned_ind :'||p_org_rec.woman_owned_ind );
536 csd_gen_utility_pvt.add('disadv_8a_ind :'||p_org_rec.disadv_8a_ind );
537 csd_gen_utility_pvt.add('small_bus_ind :'||p_org_rec.small_bus_ind );
538 csd_gen_utility_pvt.add('rent_own_ind :'||p_org_rec.rent_own_ind );
539 csd_gen_utility_pvt.add('debarments_count :'||p_org_rec.debarments_count);
540 csd_gen_utility_pvt.add('debarments_date :'||p_org_rec.debarments_date);
541 csd_gen_utility_pvt.add('failure_score :'||p_org_rec.failure_score );
542 csd_gen_utility_pvt.add('failure_score_natnl_percentile :'||p_org_rec.failure_score_natnl_percentile);
543 csd_gen_utility_pvt.add('failure_score_override_code :'||p_org_rec.failure_score_override_code );
544 csd_gen_utility_pvt.add('failure_score_commentary :'||p_org_rec.failure_score_commentary );
545 csd_gen_utility_pvt.add('global_failure_score :'||p_org_rec.global_failure_score );
546 csd_gen_utility_pvt.add('db_rating :'||p_org_rec.db_rating );
547 csd_gen_utility_pvt.add('credit_score :'||p_org_rec.credit_score );
548 csd_gen_utility_pvt.add('credit_score_commentary :'||p_org_rec.credit_score_commentary );
549 csd_gen_utility_pvt.add('paydex_score :'||p_org_rec.paydex_score );
550 csd_gen_utility_pvt.add('paydex_three_months_ago :'||p_org_rec.paydex_three_months_ago );
551 csd_gen_utility_pvt.add('paydex_norm :'||p_org_rec.paydex_norm );
552 csd_gen_utility_pvt.add('best_time_contact_begin :'||p_org_rec.best_time_contact_begin);
553 csd_gen_utility_pvt.add('best_time_contact_end :'||p_org_rec.best_time_contact_end);
554 csd_gen_utility_pvt.add('organization_name_phonetic :'||p_org_rec.organization_name_phonetic );
555 csd_gen_utility_pvt.add('tax_reference :'||p_org_rec.tax_reference );
556 csd_gen_utility_pvt.add('gsa_indicator_flag :'||p_org_rec.gsa_indicator_flag );
557 csd_gen_utility_pvt.add('jgzz_fiscal_code :'||p_org_rec.jgzz_fiscal_code );
558 csd_gen_utility_pvt.add('analysis_fy :'||p_org_rec.analysis_fy );
559 csd_gen_utility_pvt.add('fiscal_yearend_month :'||p_org_rec.fiscal_yearend_month );
560 csd_gen_utility_pvt.add('curr_fy_potential_revenue :'||p_org_rec.curr_fy_potential_revenue);
561 csd_gen_utility_pvt.add('next_fy_potential_revenue :'||p_org_rec.next_fy_potential_revenue);
562 csd_gen_utility_pvt.add('year_established :'||p_org_rec.year_established);
563 csd_gen_utility_pvt.add('mission_statement :'||p_org_rec.mission_statement );
564 csd_gen_utility_pvt.add('organization_type :'||p_org_rec.organization_type );
565 csd_gen_utility_pvt.add('business_scope :'||p_org_rec.business_scope );
566 csd_gen_utility_pvt.add('corporation_class :'||p_org_rec.corporation_class );
567 csd_gen_utility_pvt.add('known_as :'||p_org_rec.known_as );
568 csd_gen_utility_pvt.add('known_as2 :'||p_org_rec.known_as2 );
569 csd_gen_utility_pvt.add('known_as3 :'||p_org_rec.known_as3 );
570 csd_gen_utility_pvt.add('known_as4 :'||p_org_rec.known_as4 );
571 csd_gen_utility_pvt.add('known_as5 :'||p_org_rec.known_as5 );
572 csd_gen_utility_pvt.add('local_bus_iden_type :'||p_org_rec.local_bus_iden_type );
573 csd_gen_utility_pvt.add('local_bus_identifier :'||p_org_rec.local_bus_identifier );
574 csd_gen_utility_pvt.add('pref_functional_currency :'||p_org_rec.pref_functional_currency );
575 csd_gen_utility_pvt.add('registration_type :'||p_org_rec.registration_type );
576 csd_gen_utility_pvt.add('total_employees_text :'||p_org_rec.total_employees_text );
577 csd_gen_utility_pvt.add('total_employees_ind :'||p_org_rec.total_employees_ind );
578 csd_gen_utility_pvt.add('total_emp_est_ind :'||p_org_rec.total_emp_est_ind );
579 csd_gen_utility_pvt.add('total_emp_min_ind :'||p_org_rec.total_emp_min_ind );
580 csd_gen_utility_pvt.add('parent_sub_ind :'||p_org_rec.parent_sub_ind );
581 csd_gen_utility_pvt.add('incorp_year :'||p_org_rec.incorp_year);
582 -- csd_gen_utility_pvt.add('primary_contact_id :'||p_org_rec.primary_contact_id);
583 csd_gen_utility_pvt.add('sic_code_type :'||p_org_rec.sic_code_type );
584 csd_gen_utility_pvt.add('public_private_ownership_flag :'||p_org_rec.public_private_ownership_flag );
585 csd_gen_utility_pvt.add('internal_flag :'||p_org_rec.internal_flag );
586 csd_gen_utility_pvt.add('local_activity_code_type :'||p_org_rec.local_activity_code_type );
587 csd_gen_utility_pvt.add('local_activity_code :'||p_org_rec.local_activity_code );
588 csd_gen_utility_pvt.add('emp_at_primary_adr :'||p_org_rec.emp_at_primary_adr );
589 csd_gen_utility_pvt.add('emp_at_primary_adr_text :'||p_org_rec.emp_at_primary_adr_text );
590 csd_gen_utility_pvt.add('emp_at_primary_adr_est_ind :'||p_org_rec.emp_at_primary_adr_est_ind );
591 csd_gen_utility_pvt.add('emp_at_primary_adr_min_ind :'||p_org_rec.emp_at_primary_adr_min_ind );
592 csd_gen_utility_pvt.add('high_credit :'||p_org_rec.high_credit);
593 csd_gen_utility_pvt.add('avg_high_credit :'||p_org_rec.avg_high_credit);
594 csd_gen_utility_pvt.add('total_payments :'||p_org_rec.total_payments);
595 csd_gen_utility_pvt.add('credit_score_class :'||p_org_rec.credit_score_class);
596 csd_gen_utility_pvt.add('credit_score_natl_percentile :'||p_org_rec.credit_score_natl_percentile);
597 csd_gen_utility_pvt.add('credit_score_incd_default :'||p_org_rec.credit_score_incd_default);
598 csd_gen_utility_pvt.add('credit_score_age :'||p_org_rec.credit_score_age);
599 csd_gen_utility_pvt.add('credit_score_date :'||p_org_rec.credit_score_date);
600 csd_gen_utility_pvt.add('credit_score_commentary2 :'||p_org_rec.credit_score_commentary2 );
601 csd_gen_utility_pvt.add('credit_score_commentary3 :'||p_org_rec.credit_score_commentary3 );
602 csd_gen_utility_pvt.add('credit_score_commentary4 :'||p_org_rec.credit_score_commentary4 );
603 csd_gen_utility_pvt.add('credit_score_commentary5 :'||p_org_rec.credit_score_commentary5 );
604 csd_gen_utility_pvt.add('credit_score_commentary6 :'||p_org_rec.credit_score_commentary6 );
605 csd_gen_utility_pvt.add('credit_score_commentary7 :'||p_org_rec.credit_score_commentary7 );
606 csd_gen_utility_pvt.add('credit_score_commentary8 :'||p_org_rec.credit_score_commentary8 );
607 csd_gen_utility_pvt.add('credit_score_commentary9 :'||p_org_rec.credit_score_commentary9 );
608 csd_gen_utility_pvt.add('credit_score_commentary10 :'||p_org_rec.credit_score_commentary10 );
609 csd_gen_utility_pvt.add('failure_score_class :'||p_org_rec.failure_score_class);
610 csd_gen_utility_pvt.add('failure_score_incd_default :'||p_org_rec.failure_score_incd_default);
611 csd_gen_utility_pvt.add('failure_score_age :'||p_org_rec.failure_score_age);
612 csd_gen_utility_pvt.add('failure_score_date :'||p_org_rec.failure_score_date);
613 csd_gen_utility_pvt.add('failure_score_commentary2 :'||p_org_rec.failure_score_commentary2 );
614 csd_gen_utility_pvt.add('failure_score_commentary3 :'||p_org_rec.failure_score_commentary3 );
615 csd_gen_utility_pvt.add('failure_score_commentary4 :'||p_org_rec.failure_score_commentary4 );
616 csd_gen_utility_pvt.add('failure_score_commentary5 :'||p_org_rec.failure_score_commentary5 );
617 csd_gen_utility_pvt.add('failure_score_commentary6 :'||p_org_rec.failure_score_commentary6 );
618 csd_gen_utility_pvt.add('failure_score_commentary7 :'||p_org_rec.failure_score_commentary7 );
619 csd_gen_utility_pvt.add('failure_score_commentary8 :'||p_org_rec.failure_score_commentary8 );
620 csd_gen_utility_pvt.add('failure_score_commentary9 :'||p_org_rec.failure_score_commentary9 );
621 csd_gen_utility_pvt.add('failure_score_commentary10 :'||p_org_rec.failure_score_commentary10 );
622 csd_gen_utility_pvt.add('maximum_credit_recommendation :'||p_org_rec.maximum_credit_recommendation);
623 csd_gen_utility_pvt.add('maximum_credit_currency_code :'||p_org_rec.maximum_credit_currency_code );
624 csd_gen_utility_pvt.add('displayed_duns_party_id :'||p_org_rec.displayed_duns_party_id);
625 csd_gen_utility_pvt.add('content_source_type :'||p_org_rec.content_source_type );
626 csd_gen_utility_pvt.add('content_source_number :'||p_org_rec.content_source_number );
627 csd_gen_utility_pvt.add('attribute_category :'||p_org_rec.attribute_category );
628 csd_gen_utility_pvt.add('attribute1 :'||p_org_rec.attribute1 );
629 csd_gen_utility_pvt.add('attribute2 :'||p_org_rec.attribute2 );
630 csd_gen_utility_pvt.add('attribute3 :'||p_org_rec.attribute3 );
631 csd_gen_utility_pvt.add('attribute4 :'||p_org_rec.attribute4 );
632 csd_gen_utility_pvt.add('attribute5 :'||p_org_rec.attribute5 );
633 csd_gen_utility_pvt.add('attribute6 :'||p_org_rec.attribute6 );
634 csd_gen_utility_pvt.add('attribute7 :'||p_org_rec.attribute7 );
635 csd_gen_utility_pvt.add('attribute8 :'||p_org_rec.attribute8 );
636 csd_gen_utility_pvt.add('attribute9 :'||p_org_rec.attribute9 );
637 csd_gen_utility_pvt.add('attribute10 :'||p_org_rec.attribute10 );
638 csd_gen_utility_pvt.add('attribute11 :'||p_org_rec.attribute11 );
639 csd_gen_utility_pvt.add('attribute12 :'||p_org_rec.attribute12 );
640 csd_gen_utility_pvt.add('attribute13 :'||p_org_rec.attribute13 );
641 csd_gen_utility_pvt.add('attribute14 :'||p_org_rec.attribute14 );
642 csd_gen_utility_pvt.add('attribute15 :'||p_org_rec.attribute15 );
643 csd_gen_utility_pvt.add('attribute16 :'||p_org_rec.attribute16 );
644 csd_gen_utility_pvt.add('attribute17 :'||p_org_rec.attribute17 );
645 csd_gen_utility_pvt.add('attribute18 :'||p_org_rec.attribute18 );
646 csd_gen_utility_pvt.add('attribute19 :'||p_org_rec.attribute19 );
647 csd_gen_utility_pvt.add('attribute20 :'||p_org_rec.attribute20 );
648 csd_gen_utility_pvt.add('party_rec.party_id :'||p_org_rec.party_rec.party_id);
649 csd_gen_utility_pvt.add('party_rec.party_number :'||p_org_rec.party_rec.party_number );
650 csd_gen_utility_pvt.add('party_rec.validated_flag :'||p_org_rec.party_rec.validated_flag );
651 csd_gen_utility_pvt.add('party_rec.orig_system_reference :'||p_org_rec.party_rec.orig_system_reference );
652 csd_gen_utility_pvt.add('party_rec.status :'||p_org_rec.party_rec.status );
653 csd_gen_utility_pvt.add('party_rec.category_code :'||p_org_rec.party_rec.category_code );
654 csd_gen_utility_pvt.add('party_rec.salutation :'||p_org_rec.party_rec.salutation );
655 csd_gen_utility_pvt.add('party_rec.attribute_category :'||p_org_rec.party_rec.attribute_category );
656 csd_gen_utility_pvt.add('party_rec.attribute1 :'||p_org_rec.party_rec.attribute1 );
657 csd_gen_utility_pvt.add('party_rec.attribute2 :'||p_org_rec.party_rec.attribute2 );
658 csd_gen_utility_pvt.add('party_rec.attribute3 :'||p_org_rec.party_rec.attribute3 );
659 csd_gen_utility_pvt.add('party_rec.attribute4 :'||p_org_rec.party_rec.attribute4 );
660 csd_gen_utility_pvt.add('party_rec.attribute5 :'||p_org_rec.party_rec.attribute5 );
661 csd_gen_utility_pvt.add('party_rec.attribute6 :'||p_org_rec.party_rec.attribute6 );
662 csd_gen_utility_pvt.add('party_rec.attribute7 :'||p_org_rec.party_rec.attribute7 );
663 csd_gen_utility_pvt.add('party_rec.attribute8 :'||p_org_rec.party_rec.attribute8 );
664 csd_gen_utility_pvt.add('party_rec.attribute9 :'||p_org_rec.party_rec.attribute9 );
665 csd_gen_utility_pvt.add('party_rec.attribute10 :'||p_org_rec.party_rec.attribute10 );
666 csd_gen_utility_pvt.add('party_rec.attribute11 :'||p_org_rec.party_rec.attribute11 );
667 csd_gen_utility_pvt.add('party_rec.attribute12 :'||p_org_rec.party_rec.attribute12 );
668 csd_gen_utility_pvt.add('party_rec.attribute13 :'||p_org_rec.party_rec.attribute13 );
669 csd_gen_utility_pvt.add('party_rec.attribute14 :'||p_org_rec.party_rec.attribute14 );
670 csd_gen_utility_pvt.add('party_rec.attribute15 :'||p_org_rec.party_rec.attribute15 );
671 csd_gen_utility_pvt.add('party_rec.attribute16 :'||p_org_rec.party_rec.attribute16 );
672 csd_gen_utility_pvt.add('party_rec.attribute17 :'||p_org_rec.party_rec.attribute17 );
673 csd_gen_utility_pvt.add('party_rec.attribute18 :'||p_org_rec.party_rec.attribute18 );
674 csd_gen_utility_pvt.add('party_rec.attribute19 :'||p_org_rec.party_rec.attribute19 );
675 csd_gen_utility_pvt.add('party_rec.attribute20 :'||p_org_rec.party_rec.attribute20 );
676 csd_gen_utility_pvt.add('party_rec.attribute21 :'||p_org_rec.party_rec.attribute21 );
677 csd_gen_utility_pvt.add('party_rec.attribute22 :'||p_org_rec.party_rec.attribute22 );
678 csd_gen_utility_pvt.add('party_rec.attribute23 :'||p_org_rec.party_rec.attribute23 );
679 csd_gen_utility_pvt.add('party_rec.attribute24 :'||p_org_rec.party_rec.attribute24 );
680 END dump_hz_org_rec;
681
682
683
684 PROCEDURE dump_hz_acct_rec (
685 p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type
686 )
687 IS
688 BEGIN
689 csd_gen_utility_pvt.add('HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type');
690 csd_gen_utility_pvt.add('cust_account_id :'||p_account_rec.cust_account_id);
691 csd_gen_utility_pvt.add('account_number :'||p_account_rec.account_number);
692 csd_gen_utility_pvt.add('attribute_category :'||p_account_rec.attribute_category);
693 csd_gen_utility_pvt.add('attribute1 :'||p_account_rec.attribute1);
694 csd_gen_utility_pvt.add('attribute2 :'||p_account_rec.attribute2);
695 csd_gen_utility_pvt.add('attribute3 :'||p_account_rec.attribute3);
696 csd_gen_utility_pvt.add('attribute4 :'||p_account_rec.attribute4);
697 csd_gen_utility_pvt.add('attribute5 :'||p_account_rec.attribute5);
698 csd_gen_utility_pvt.add('attribute6 :'||p_account_rec.attribute6);
699 csd_gen_utility_pvt.add('attribute7 :'||p_account_rec.attribute7);
700 csd_gen_utility_pvt.add('attribute8 :'||p_account_rec.attribute8);
701 csd_gen_utility_pvt.add('attribute9 :'||p_account_rec.attribute9);
702 csd_gen_utility_pvt.add('attribute10 :'||p_account_rec.attribute10);
703 csd_gen_utility_pvt.add('attribute11 :'||p_account_rec.attribute11);
704 csd_gen_utility_pvt.add('attribute12 :'||p_account_rec.attribute12);
705 csd_gen_utility_pvt.add('attribute13 :'||p_account_rec.attribute13);
706 csd_gen_utility_pvt.add('attribute14 :'||p_account_rec.attribute14);
707 csd_gen_utility_pvt.add('attribute15 :'||p_account_rec.attribute15);
708 csd_gen_utility_pvt.add('attribute16 :'||p_account_rec.attribute16);
709 csd_gen_utility_pvt.add('attribute17 :'||p_account_rec.attribute17);
710 csd_gen_utility_pvt.add('attribute18 :'||p_account_rec.attribute18);
711 csd_gen_utility_pvt.add('attribute19 :'||p_account_rec.attribute19);
712 csd_gen_utility_pvt.add('attribute20 :'||p_account_rec.attribute20);
713 csd_gen_utility_pvt.add('global_attribute_category :'||p_account_rec.global_attribute_category);
714 csd_gen_utility_pvt.add('global_attribute1 :'||p_account_rec.global_attribute1);
715 csd_gen_utility_pvt.add('global_attribute2 :'||p_account_rec.global_attribute2);
716 csd_gen_utility_pvt.add('global_attribute3 :'||p_account_rec.global_attribute3);
717 csd_gen_utility_pvt.add('global_attribute4 :'||p_account_rec.global_attribute4);
718 csd_gen_utility_pvt.add('global_attribute5 :'||p_account_rec.global_attribute5);
719 csd_gen_utility_pvt.add('global_attribute6 :'||p_account_rec.global_attribute6);
720 csd_gen_utility_pvt.add('global_attribute7 :'||p_account_rec.global_attribute7);
721 csd_gen_utility_pvt.add('global_attribute8 :'||p_account_rec.global_attribute8);
722 csd_gen_utility_pvt.add('global_attribute9 :'||p_account_rec.global_attribute9);
723 csd_gen_utility_pvt.add('global_attribute10 :'||p_account_rec.global_attribute10);
724 csd_gen_utility_pvt.add('global_attribute11 :'||p_account_rec.global_attribute11);
725 csd_gen_utility_pvt.add('global_attribute12 :'||p_account_rec.global_attribute12);
726 csd_gen_utility_pvt.add('global_attribute13 :'||p_account_rec.global_attribute13);
727 csd_gen_utility_pvt.add('global_attribute14 :'||p_account_rec.global_attribute14);
728 csd_gen_utility_pvt.add('global_attribute15 :'||p_account_rec.global_attribute15);
729 csd_gen_utility_pvt.add('global_attribute16 :'||p_account_rec.global_attribute16);
730 csd_gen_utility_pvt.add('global_attribute17 :'||p_account_rec.global_attribute17);
731 csd_gen_utility_pvt.add('global_attribute18 :'||p_account_rec.global_attribute18);
732 csd_gen_utility_pvt.add('global_attribute19 :'||p_account_rec.global_attribute19);
733 csd_gen_utility_pvt.add('global_attribute20 :'||p_account_rec.global_attribute20);
734 csd_gen_utility_pvt.add('orig_system_reference :'||p_account_rec.orig_system_reference);
735 csd_gen_utility_pvt.add('status :'||p_account_rec.status);
736 csd_gen_utility_pvt.add('customer_type :'||p_account_rec.customer_type);
737 csd_gen_utility_pvt.add('customer_class_code :'||p_account_rec.customer_class_code);
738 csd_gen_utility_pvt.add('primary_salesrep_id :'||p_account_rec.primary_salesrep_id);
739 csd_gen_utility_pvt.add('sales_channel_code :'||p_account_rec.sales_channel_code);
740 csd_gen_utility_pvt.add('order_type_id :'||p_account_rec.order_type_id);
741 csd_gen_utility_pvt.add('price_list_id :'||p_account_rec.price_list_id);
742 -- csd_gen_utility_pvt.add('subcategory_code :'||p_account_rec.subcategory_code);
743 csd_gen_utility_pvt.add('tax_code :'||p_account_rec.tax_code);
744 csd_gen_utility_pvt.add('fob_point :'||p_account_rec.fob_point);
745 csd_gen_utility_pvt.add('freight_term :'||p_account_rec.freight_term);
746 csd_gen_utility_pvt.add('ship_partial :'||p_account_rec.ship_partial);
747 csd_gen_utility_pvt.add('ship_via :'||p_account_rec.ship_via);
748 csd_gen_utility_pvt.add('warehouse_id :'||p_account_rec.warehouse_id);
749 -- csd_gen_utility_pvt.add('payment_term_id :'||p_account_rec.payment_term_id);
750 csd_gen_utility_pvt.add('tax_header_level_flag :'||p_account_rec.tax_header_level_flag);
751 csd_gen_utility_pvt.add('tax_rounding_rule :'||p_account_rec.tax_rounding_rule);
752 csd_gen_utility_pvt.add('coterminate_day_month :'||p_account_rec.coterminate_day_month);
753 csd_gen_utility_pvt.add('primary_specialist_id :'||p_account_rec.primary_specialist_id);
754 csd_gen_utility_pvt.add('secondary_specialist_id :'||p_account_rec.secondary_specialist_id);
755 csd_gen_utility_pvt.add('account_liable_flag :'||p_account_rec.account_liable_flag);
756 csd_gen_utility_pvt.add('current_balance :'||p_account_rec.current_balance);
757 csd_gen_utility_pvt.add('account_established_date :'||p_account_rec.account_established_date);
758 csd_gen_utility_pvt.add('account_termination_date :'||p_account_rec.account_termination_date);
759 csd_gen_utility_pvt.add('account_activation_date :'||p_account_rec.account_activation_date);
760 csd_gen_utility_pvt.add('department :'||p_account_rec.department);
761 csd_gen_utility_pvt.add('held_bill_expiration_date :'||p_account_rec.held_bill_expiration_date);
762 csd_gen_utility_pvt.add('hold_bill_flag :'||p_account_rec.hold_bill_flag);
763 csd_gen_utility_pvt.add('realtime_rate_flag :'||p_account_rec.realtime_rate_flag);
764 csd_gen_utility_pvt.add('acct_life_cycle_status :'||p_account_rec.acct_life_cycle_status);
765 csd_gen_utility_pvt.add('account_name :'||p_account_rec.account_name);
766 csd_gen_utility_pvt.add('deposit_refund_method :'||p_account_rec.deposit_refund_method);
767 csd_gen_utility_pvt.add('dormant_account_flag :'||p_account_rec.dormant_account_flag);
768 csd_gen_utility_pvt.add('npa_number :'||p_account_rec.npa_number);
769 csd_gen_utility_pvt.add('suspension_date :'||p_account_rec.suspension_date);
770 csd_gen_utility_pvt.add('source_code :'||p_account_rec.source_code);
771 csd_gen_utility_pvt.add('comments :'||p_account_rec.comments);
772 csd_gen_utility_pvt.add('dates_negative_tolerance :'||p_account_rec.dates_negative_tolerance);
773 csd_gen_utility_pvt.add('dates_positive_tolerance :'||p_account_rec.dates_positive_tolerance);
774 csd_gen_utility_pvt.add('date_type_preference :'||p_account_rec.date_type_preference);
775 csd_gen_utility_pvt.add('over_shipment_tolerance :'||p_account_rec.over_shipment_tolerance);
776 csd_gen_utility_pvt.add('under_shipment_tolerance :'||p_account_rec.under_shipment_tolerance);
777 csd_gen_utility_pvt.add('over_return_tolerance :'||p_account_rec.over_return_tolerance);
778 csd_gen_utility_pvt.add('under_return_tolerance :'||p_account_rec.under_return_tolerance);
779 csd_gen_utility_pvt.add('item_cross_ref_pref :'||p_account_rec.item_cross_ref_pref);
780 csd_gen_utility_pvt.add('ship_sets_include_lines_flag :'||p_account_rec.ship_sets_include_lines_flag);
781 csd_gen_utility_pvt.add('arrivalsets_include_lines_flag :'||p_account_rec.arrivalsets_include_lines_flag);
782 csd_gen_utility_pvt.add('sched_date_push_flag :'||p_account_rec.sched_date_push_flag);
783 csd_gen_utility_pvt.add('invoice_quantity_rule :'||p_account_rec.invoice_quantity_rule);
784 csd_gen_utility_pvt.add('pricing_event :'||p_account_rec.pricing_event);
785 csd_gen_utility_pvt.add('status_update_date :'||p_account_rec.status_update_date);
786 csd_gen_utility_pvt.add('autopay_flag :'||p_account_rec.autopay_flag);
787 csd_gen_utility_pvt.add('notify_flag :'||p_account_rec.notify_flag);
788 csd_gen_utility_pvt.add('last_batch_id :'||p_account_rec.last_batch_id);
789 END dump_hz_acct_rec;
790
791
792
793 PROCEDURE dump_hz_cust_profile_rec (
794 p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type
795 )
796 IS
797 BEGIN
798 csd_gen_utility_pvt.add('HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type');
799 csd_gen_utility_pvt.add('cust_account_profile_id :'||p_cust_profile_rec.cust_account_profile_id);
800 csd_gen_utility_pvt.add('cust_account_id :'||p_cust_profile_rec.cust_account_id);
801 csd_gen_utility_pvt.add('status :'||p_cust_profile_rec.status);
802 csd_gen_utility_pvt.add('collector_id :'||p_cust_profile_rec.collector_id);
803 csd_gen_utility_pvt.add('credit_analyst_id :'||p_cust_profile_rec.credit_analyst_id);
804 csd_gen_utility_pvt.add('credit_checking :'||p_cust_profile_rec.credit_checking);
805 csd_gen_utility_pvt.add('next_credit_review_date :'||p_cust_profile_rec.next_credit_review_date);
806 csd_gen_utility_pvt.add('tolerance :'||p_cust_profile_rec.tolerance);
807 csd_gen_utility_pvt.add('discount_terms :'||p_cust_profile_rec.discount_terms);
808 csd_gen_utility_pvt.add('dunning_letters :'||p_cust_profile_rec.dunning_letters);
809 csd_gen_utility_pvt.add('interest_charges :'||p_cust_profile_rec.interest_charges);
810 csd_gen_utility_pvt.add('send_statements :'||p_cust_profile_rec.send_statements);
811 csd_gen_utility_pvt.add('credit_balance_statements :'||p_cust_profile_rec.credit_balance_statements);
812 csd_gen_utility_pvt.add('credit_hold :'||p_cust_profile_rec.credit_hold);
813 csd_gen_utility_pvt.add('profile_class_id :'||p_cust_profile_rec.profile_class_id);
814 csd_gen_utility_pvt.add('site_use_id :'||p_cust_profile_rec.site_use_id);
815 csd_gen_utility_pvt.add('credit_rating :'||p_cust_profile_rec.credit_rating);
816 csd_gen_utility_pvt.add('risk_code :'||p_cust_profile_rec.risk_code);
817 csd_gen_utility_pvt.add('standard_terms :'||p_cust_profile_rec.standard_terms);
818 csd_gen_utility_pvt.add('override_terms :'||p_cust_profile_rec.override_terms);
819 csd_gen_utility_pvt.add('dunning_letter_set_id :'||p_cust_profile_rec.dunning_letter_set_id);
820 csd_gen_utility_pvt.add('interest_period_days :'||p_cust_profile_rec.interest_period_days);
821 csd_gen_utility_pvt.add('payment_grace_days :'||p_cust_profile_rec.payment_grace_days);
822 csd_gen_utility_pvt.add('discount_grace_days :'||p_cust_profile_rec.discount_grace_days);
823 csd_gen_utility_pvt.add('statement_cycle_id :'||p_cust_profile_rec.statement_cycle_id);
824 csd_gen_utility_pvt.add('account_status :'||p_cust_profile_rec.account_status);
825 csd_gen_utility_pvt.add('percent_collectable :'||p_cust_profile_rec.percent_collectable);
826 csd_gen_utility_pvt.add('autocash_hierarchy_id :'||p_cust_profile_rec.autocash_hierarchy_id);
827 csd_gen_utility_pvt.add('attribute_category :'||p_cust_profile_rec.attribute_category);
828 csd_gen_utility_pvt.add('attribute1 :'||p_cust_profile_rec.attribute1);
829 csd_gen_utility_pvt.add('attribute2 :'||p_cust_profile_rec.attribute2);
830 csd_gen_utility_pvt.add('attribute3 :'||p_cust_profile_rec.attribute3);
831 csd_gen_utility_pvt.add('attribute4 :'||p_cust_profile_rec.attribute4);
832 csd_gen_utility_pvt.add('attribute5 :'||p_cust_profile_rec.attribute5);
833 csd_gen_utility_pvt.add('attribute6 :'||p_cust_profile_rec.attribute6);
834 csd_gen_utility_pvt.add('attribute7 :'||p_cust_profile_rec.attribute7);
835 csd_gen_utility_pvt.add('attribute8 :'||p_cust_profile_rec.attribute8);
836 csd_gen_utility_pvt.add('attribute9 :'||p_cust_profile_rec.attribute9);
837 csd_gen_utility_pvt.add('attribute10 :'||p_cust_profile_rec.attribute10);
838 csd_gen_utility_pvt.add('attribute11 :'||p_cust_profile_rec.attribute11);
839 csd_gen_utility_pvt.add('attribute12 :'||p_cust_profile_rec.attribute12);
840 csd_gen_utility_pvt.add('attribute13 :'||p_cust_profile_rec.attribute13);
841 csd_gen_utility_pvt.add('attribute14 :'||p_cust_profile_rec.attribute14);
842 csd_gen_utility_pvt.add('attribute15 :'||p_cust_profile_rec.attribute15);
843 csd_gen_utility_pvt.add('auto_rec_incl_disputed_flag :'||p_cust_profile_rec.auto_rec_incl_disputed_flag);
844 csd_gen_utility_pvt.add('tax_printing_option :'||p_cust_profile_rec.tax_printing_option);
845 csd_gen_utility_pvt.add('charge_on_finance_charge_flag :'||p_cust_profile_rec.charge_on_finance_charge_flag);
846 csd_gen_utility_pvt.add('grouping_rule_id :'||p_cust_profile_rec.grouping_rule_id);
847 csd_gen_utility_pvt.add('clearing_days :'||p_cust_profile_rec.clearing_days);
848 csd_gen_utility_pvt.add('jgzz_attribute_category :'||p_cust_profile_rec.jgzz_attribute_category);
849 csd_gen_utility_pvt.add('jgzz_attribute1 :'||p_cust_profile_rec.jgzz_attribute1);
850 csd_gen_utility_pvt.add('jgzz_attribute2 :'||p_cust_profile_rec.jgzz_attribute2);
851 csd_gen_utility_pvt.add('jgzz_attribute3 :'||p_cust_profile_rec.jgzz_attribute3);
852 csd_gen_utility_pvt.add('jgzz_attribute4 :'||p_cust_profile_rec.jgzz_attribute4);
853 csd_gen_utility_pvt.add('jgzz_attribute5 :'||p_cust_profile_rec.jgzz_attribute5);
854 csd_gen_utility_pvt.add('jgzz_attribute6 :'||p_cust_profile_rec.jgzz_attribute6);
855 csd_gen_utility_pvt.add('jgzz_attribute7 :'||p_cust_profile_rec.jgzz_attribute7);
856 csd_gen_utility_pvt.add('jgzz_attribute8 :'||p_cust_profile_rec.jgzz_attribute8);
857 csd_gen_utility_pvt.add('jgzz_attribute9 :'||p_cust_profile_rec.jgzz_attribute9);
858 csd_gen_utility_pvt.add('jgzz_attribute10 :'||p_cust_profile_rec.jgzz_attribute10);
859 csd_gen_utility_pvt.add('jgzz_attribute11 :'||p_cust_profile_rec.jgzz_attribute11);
860 csd_gen_utility_pvt.add('jgzz_attribute12 :'||p_cust_profile_rec.jgzz_attribute12);
861 csd_gen_utility_pvt.add('jgzz_attribute13 :'||p_cust_profile_rec.jgzz_attribute13);
862 csd_gen_utility_pvt.add('jgzz_attribute14 :'||p_cust_profile_rec.jgzz_attribute14);
863 csd_gen_utility_pvt.add('jgzz_attribute15 :'||p_cust_profile_rec.jgzz_attribute15);
864 csd_gen_utility_pvt.add('global_attribute1 :'||p_cust_profile_rec.global_attribute1);
865 csd_gen_utility_pvt.add('global_attribute2 :'||p_cust_profile_rec.global_attribute2);
866 csd_gen_utility_pvt.add('global_attribute3 :'||p_cust_profile_rec.global_attribute3);
867 csd_gen_utility_pvt.add('global_attribute4 :'||p_cust_profile_rec.global_attribute4);
868 csd_gen_utility_pvt.add('global_attribute5 :'||p_cust_profile_rec.global_attribute5);
869 csd_gen_utility_pvt.add('global_attribute6 :'||p_cust_profile_rec.global_attribute6);
870 csd_gen_utility_pvt.add('global_attribute7 :'||p_cust_profile_rec.global_attribute7);
871 csd_gen_utility_pvt.add('global_attribute8 :'||p_cust_profile_rec.global_attribute8);
872 csd_gen_utility_pvt.add('global_attribute9 :'||p_cust_profile_rec.global_attribute9);
873 csd_gen_utility_pvt.add('global_attribute10 :'||p_cust_profile_rec.global_attribute10);
874 csd_gen_utility_pvt.add('global_attribute11 :'||p_cust_profile_rec.global_attribute11);
875 csd_gen_utility_pvt.add('global_attribute12 :'||p_cust_profile_rec.global_attribute12);
876 csd_gen_utility_pvt.add('global_attribute13 :'||p_cust_profile_rec.global_attribute13);
877 csd_gen_utility_pvt.add('global_attribute14 :'||p_cust_profile_rec.global_attribute14);
878 csd_gen_utility_pvt.add('global_attribute15 :'||p_cust_profile_rec.global_attribute15);
879 csd_gen_utility_pvt.add('global_attribute16 :'||p_cust_profile_rec.global_attribute16);
880 csd_gen_utility_pvt.add('global_attribute17 :'||p_cust_profile_rec.global_attribute17);
881 csd_gen_utility_pvt.add('global_attribute18 :'||p_cust_profile_rec.global_attribute18);
882 csd_gen_utility_pvt.add('global_attribute19 :'||p_cust_profile_rec.global_attribute19);
883 csd_gen_utility_pvt.add('global_attribute20 :'||p_cust_profile_rec.global_attribute20);
884 csd_gen_utility_pvt.add('global_attribute_category :'||p_cust_profile_rec.global_attribute_category);
885 csd_gen_utility_pvt.add('cons_inv_flag :'||p_cust_profile_rec.cons_inv_flag);
886 csd_gen_utility_pvt.add('cons_inv_type :'||p_cust_profile_rec.cons_inv_type);
887 csd_gen_utility_pvt.add('autocash_hierarchy_id_for_adr :'||p_cust_profile_rec.autocash_hierarchy_id_for_adr);
888 csd_gen_utility_pvt.add('lockbox_matching_option :'||p_cust_profile_rec.lockbox_matching_option);
889 END dump_hz_cust_profile_rec;
890
891
892
893 PROCEDURE dump_hz_phone_rec (
894 p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type
895 )
896 IS
897 BEGIN
898 csd_gen_utility_pvt.add('HZ_CONTACT_POINT_V2PUB.phone_rec_type');
899 csd_gen_utility_pvt.add('phone_calling_calendar :'||p_phone_rec.phone_calling_calendar);
900 csd_gen_utility_pvt.add('last_contact_dt_time :'||p_phone_rec.last_contact_dt_time);
901 csd_gen_utility_pvt.add('timezone_id :'||p_phone_rec.timezone_id);
902 csd_gen_utility_pvt.add('phone_area_code :'||p_phone_rec.phone_area_code);
903 csd_gen_utility_pvt.add('phone_country_code :'||p_phone_rec.phone_country_code);
904 csd_gen_utility_pvt.add('phone_number :'||p_phone_rec.phone_number);
905 csd_gen_utility_pvt.add('phone_extension :'||p_phone_rec.phone_extension);
906 csd_gen_utility_pvt.add('phone_line_type :'||p_phone_rec.phone_line_type);
907 csd_gen_utility_pvt.add('raw_phone_number :'||p_phone_rec.raw_phone_number);
908 END dump_hz_phone_rec;
909
910
911
912 PROCEDURE dump_hz_email_rec (
913 p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
914 )
915 IS
916 BEGIN
917 csd_gen_utility_pvt.add('HZ_CONTACT_POINT_PUB.email_rec_type');
918 csd_gen_utility_pvt.add('email_format :'||p_email_rec.email_format);
919 csd_gen_utility_pvt.add('email_address :'||p_email_rec.email_address);
920 END dump_hz_email_rec;
921
922
923
924 PROCEDURE dump_hz_web_rec (
925 p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type
926 )
927 IS
928 BEGIN
929 csd_gen_utility_pvt.add('HZ_CONTACT_POINT_PUB.web_rec_type');
930 csd_gen_utility_pvt.add('web_type :'||p_web_rec.web_type);
931 csd_gen_utility_pvt.add('url :'||p_web_rec.url);
932 END dump_hz_web_rec;
933
934
935
936 PROCEDURE dump_address_rec (
937 p_addr_rec IN CSD_PROCESS_PVT.address_rec_type
938 )
939 IS
940 BEGIN
941 csd_gen_utility_pvt.add('CSD_PROCESS_PVT.address_rec_type');
942 csd_gen_utility_pvt.add('location_id :'||p_addr_rec.location_id);
943 csd_gen_utility_pvt.add('address1 :'||p_addr_rec.address1);
944 csd_gen_utility_pvt.add('address2 :'||p_addr_rec.address2);
945 csd_gen_utility_pvt.add('address3 :'||p_addr_rec.address3);
946 csd_gen_utility_pvt.add('address4 :'||p_addr_rec.address4);
947 csd_gen_utility_pvt.add('city :'||p_addr_rec.city);
948 csd_gen_utility_pvt.add('state :'||p_addr_rec.state);
949 csd_gen_utility_pvt.add('postal_code :'||p_addr_rec.postal_code);
950 csd_gen_utility_pvt.add('province :'||p_addr_rec.province);
951 csd_gen_utility_pvt.add('county :'||p_addr_rec.county);
952 csd_gen_utility_pvt.add('country :'||p_addr_rec.country);
953 csd_gen_utility_pvt.add('language :'||p_addr_rec.language);
954 csd_gen_utility_pvt.add('position :'||p_addr_rec.position);
955 csd_gen_utility_pvt.add('address_key :'||p_addr_rec.address_key);
956 csd_gen_utility_pvt.add('postal_plus4_code :'||p_addr_rec.postal_plus4_code);
957 csd_gen_utility_pvt.add('delivery_point_code :'||p_addr_rec.delivery_point_code);
958 csd_gen_utility_pvt.add('location_directions :'||p_addr_rec.location_directions);
959 -- csd_gen_utility_pvt.add('address_error_code :'||p_addr_rec.address_error_code);
960 csd_gen_utility_pvt.add('clli_code :'||p_addr_rec.clli_code);
961 csd_gen_utility_pvt.add('short_description :'||p_addr_rec.short_description);
962 csd_gen_utility_pvt.add('description :'||p_addr_rec.description);
963 csd_gen_utility_pvt.add('sales_tax_geocode :'||p_addr_rec.sales_tax_geocode);
964 csd_gen_utility_pvt.add('sales_tax_inside_city_limits :'||p_addr_rec.sales_tax_inside_city_limits);
965 csd_gen_utility_pvt.add('address_effective_date :'||p_addr_rec.address_effective_date);
966 csd_gen_utility_pvt.add('address_expiration_date :'||p_addr_rec.address_expiration_date);
967 csd_gen_utility_pvt.add('address_style :'||p_addr_rec.address_style);
968 END dump_address_rec;
969
970 PROCEDURE dump_hz_party_site_rec (
971 p_party_site_rec IN HZ_PARTY_SITE_V2PUB.party_site_rec_type
972 )
973 IS
974 BEGIN
975 csd_gen_utility_pvt.add('HZ_PARTY_SITE_V2PUB.party_site_rec_type');
976 csd_gen_utility_pvt.add('party_site_id :'||p_party_site_rec.party_site_id);
977 csd_gen_utility_pvt.add('party_id :'||p_party_site_rec.party_id);
978 csd_gen_utility_pvt.add('location_id :'||p_party_site_rec.location_id);
979 csd_gen_utility_pvt.add('party_site_number :'||p_party_site_rec.party_site_number);
980 csd_gen_utility_pvt.add('orig_system_reference :'||p_party_site_rec.orig_system_reference);
981 csd_gen_utility_pvt.add('mailstop :'||p_party_site_rec.mailstop);
982 csd_gen_utility_pvt.add('identifying_address_flag :'||p_party_site_rec.identifying_address_flag);
983 csd_gen_utility_pvt.add('language :'||p_party_site_rec.language);
984 csd_gen_utility_pvt.add('status :'||p_party_site_rec.status);
985 csd_gen_utility_pvt.add('party_site_name :'||p_party_site_rec.party_site_name);
986 csd_gen_utility_pvt.add('attribute_category :'||p_party_site_rec.attribute_category);
987 csd_gen_utility_pvt.add('attribute1 :'||p_party_site_rec.attribute1);
988 csd_gen_utility_pvt.add('attribute2 :'||p_party_site_rec.attribute2);
989 csd_gen_utility_pvt.add('attribute3 :'||p_party_site_rec.attribute3);
990 csd_gen_utility_pvt.add('attribute4 :'||p_party_site_rec.attribute4);
991 csd_gen_utility_pvt.add('attribute5 :'||p_party_site_rec.attribute5);
992 csd_gen_utility_pvt.add('attribute6 :'||p_party_site_rec.attribute6);
993 csd_gen_utility_pvt.add('attribute7 :'||p_party_site_rec.attribute7);
994 csd_gen_utility_pvt.add('attribute8 :'||p_party_site_rec.attribute8);
995 csd_gen_utility_pvt.add('attribute9 :'||p_party_site_rec.attribute9);
996 csd_gen_utility_pvt.add('attribute10 :'||p_party_site_rec.attribute10);
997 csd_gen_utility_pvt.add('attribute11 :'||p_party_site_rec.attribute11);
998 csd_gen_utility_pvt.add('attribute12 :'||p_party_site_rec.attribute12);
999 csd_gen_utility_pvt.add('attribute13 :'||p_party_site_rec.attribute13);
1000 csd_gen_utility_pvt.add('attribute14 :'||p_party_site_rec.attribute14);
1001 csd_gen_utility_pvt.add('attribute15 :'||p_party_site_rec.attribute15);
1002 csd_gen_utility_pvt.add('attribute16 :'||p_party_site_rec.attribute16);
1003 csd_gen_utility_pvt.add('attribute17 :'||p_party_site_rec.attribute17);
1004 csd_gen_utility_pvt.add('attribute18 :'||p_party_site_rec.attribute18);
1005 csd_gen_utility_pvt.add('attribute19 :'||p_party_site_rec.attribute19);
1006 csd_gen_utility_pvt.add('attribute20 :'||p_party_site_rec.attribute20);
1007 csd_gen_utility_pvt.add('addressee :'||p_party_site_rec.addressee);
1008 END dump_hz_party_site_rec;
1009
1010
1011
1012 PROCEDURE dump_hz_party_site_use_rec (
1013 p_party_site_use_rec IN HZ_PARTY_SITE_V2PUB.party_site_use_rec_type
1014 )
1015 IS
1016 BEGIN
1017 csd_gen_utility_pvt.add('HZ_PARTY_SITE_V2PUB.party_site_use_rec_type');
1018 csd_gen_utility_pvt.add('party_site_use_id :'||p_party_site_use_rec.party_site_use_id);
1019 csd_gen_utility_pvt.add('comments :'||p_party_site_use_rec.comments);
1020 csd_gen_utility_pvt.add('site_use_type :'||p_party_site_use_rec.site_use_type);
1021 csd_gen_utility_pvt.add('party_site_id :'||p_party_site_use_rec.party_site_id);
1022 csd_gen_utility_pvt.add('primary_per_type :'||p_party_site_use_rec.primary_per_type);
1023 csd_gen_utility_pvt.add('status :'||p_party_site_use_rec.status);
1024 END dump_hz_party_site_use_rec;
1025
1026
1027
1028 PROCEDURE dump_hz_party_rel_rec (
1029 p_party_rel_rec IN HZ_RELATIONSHIP_V2PUB.relationship_rec_type
1030 )
1031 IS
1032 BEGIN
1033 csd_gen_utility_pvt.add('HZ_RELATIONSHIP_V2PUB.relationship_rec_type');
1034 csd_gen_utility_pvt.add('relationship_id :'||p_party_rel_rec.relationship_id);
1035
1036 csd_gen_utility_pvt.add('subject_id :'||p_party_rel_rec.subject_id);
1037 csd_gen_utility_pvt.add('subject_type :'||p_party_rel_rec.subject_type);
1038 csd_gen_utility_pvt.add('subject_table_name :'||p_party_rel_rec.subject_table_name);
1039 csd_gen_utility_pvt.add('object_id :'||p_party_rel_rec.object_id);
1040 csd_gen_utility_pvt.add('object_type :'||p_party_rel_rec.object_type);
1041 csd_gen_utility_pvt.add('object_table_name :'||p_party_rel_rec.object_table_name);
1042 csd_gen_utility_pvt.add('relationship_type :'||p_party_rel_rec.relationship_type);
1043 csd_gen_utility_pvt.add('comments :'||p_party_rel_rec.comments);
1044 csd_gen_utility_pvt.add('start_date :'||p_party_rel_rec.start_date);
1045 csd_gen_utility_pvt.add('end_date :'||p_party_rel_rec.end_date);
1046 csd_gen_utility_pvt.add('status :'||p_party_rel_rec.status);
1047 csd_gen_utility_pvt.add('content_source_type :'||p_party_rel_rec.content_source_type);
1048 csd_gen_utility_pvt.add('attribute_category :'||p_party_rel_rec.attribute_category);
1049 csd_gen_utility_pvt.add('attribute1 :'||p_party_rel_rec.attribute1);
1050 csd_gen_utility_pvt.add('attribute2 :'||p_party_rel_rec.attribute2);
1051 csd_gen_utility_pvt.add('attribute3 :'||p_party_rel_rec.attribute3);
1052 csd_gen_utility_pvt.add('attribute4 :'||p_party_rel_rec.attribute4);
1053 csd_gen_utility_pvt.add('attribute5 :'||p_party_rel_rec.attribute5);
1054 csd_gen_utility_pvt.add('attribute6 :'||p_party_rel_rec.attribute6);
1055 csd_gen_utility_pvt.add('attribute7 :'||p_party_rel_rec.attribute7);
1056 csd_gen_utility_pvt.add('attribute8 :'||p_party_rel_rec.attribute8);
1057 csd_gen_utility_pvt.add('attribute9 :'||p_party_rel_rec.attribute9);
1058 csd_gen_utility_pvt.add('attribute10 :'||p_party_rel_rec.attribute10);
1059 csd_gen_utility_pvt.add('attribute11 :'||p_party_rel_rec.attribute11);
1060 csd_gen_utility_pvt.add('attribute12 :'||p_party_rel_rec.attribute12);
1061 csd_gen_utility_pvt.add('attribute13 :'||p_party_rel_rec.attribute13);
1062 csd_gen_utility_pvt.add('attribute14 :'||p_party_rel_rec.attribute14);
1063 csd_gen_utility_pvt.add('attribute15 :'||p_party_rel_rec.attribute15);
1064 csd_gen_utility_pvt.add('attribute16 :'||p_party_rel_rec.attribute16);
1065 csd_gen_utility_pvt.add('attribute17 :'||p_party_rel_rec.attribute17);
1066 csd_gen_utility_pvt.add('attribute18 :'||p_party_rel_rec.attribute18);
1067 csd_gen_utility_pvt.add('attribute19 :'||p_party_rel_rec.attribute19);
1068 csd_gen_utility_pvt.add('attribute20 :'||p_party_rel_rec.attribute20);
1069 csd_gen_utility_pvt.add('party_rec.party_id :'||p_party_rel_rec.party_rec.party_id);
1070 csd_gen_utility_pvt.add('party_rec.party_number :'||p_party_rel_rec.party_rec.party_number );
1071 csd_gen_utility_pvt.add('party_rec.validated_flag :'||p_party_rel_rec.party_rec.validated_flag );
1072 csd_gen_utility_pvt.add('party_rec.orig_system_reference :'||p_party_rel_rec.party_rec.orig_system_reference );
1073 csd_gen_utility_pvt.add('party_rec.status :'||p_party_rel_rec.party_rec.status );
1074 csd_gen_utility_pvt.add('party_rec.category_code :'||p_party_rel_rec.party_rec.category_code );
1075 csd_gen_utility_pvt.add('party_rec.salutation :'||p_party_rel_rec.party_rec.salutation );
1076 csd_gen_utility_pvt.add('party_rec.attribute_category :'||p_party_rel_rec.party_rec.attribute_category );
1077 csd_gen_utility_pvt.add('party_rec.attribute1 :'||p_party_rel_rec.party_rec.attribute1 );
1078 csd_gen_utility_pvt.add('party_rec.attribute2 :'||p_party_rel_rec.party_rec.attribute2 );
1079 csd_gen_utility_pvt.add('party_rec.attribute3 :'||p_party_rel_rec.party_rec.attribute3 );
1080 csd_gen_utility_pvt.add('party_rec.attribute4 :'||p_party_rel_rec.party_rec.attribute4 );
1081 csd_gen_utility_pvt.add('party_rec.attribute5 :'||p_party_rel_rec.party_rec.attribute5 );
1082 csd_gen_utility_pvt.add('party_rec.attribute6 :'||p_party_rel_rec.party_rec.attribute6 );
1083 csd_gen_utility_pvt.add('party_rec.attribute7 :'||p_party_rel_rec.party_rec.attribute7 );
1084 csd_gen_utility_pvt.add('party_rec.attribute8 :'||p_party_rel_rec.party_rec.attribute8 );
1085 csd_gen_utility_pvt.add('party_rec.attribute9 :'||p_party_rel_rec.party_rec.attribute9 );
1086 csd_gen_utility_pvt.add('party_rec.attribute10 :'||p_party_rel_rec.party_rec.attribute10 );
1087 csd_gen_utility_pvt.add('party_rec.attribute11 :'||p_party_rel_rec.party_rec.attribute11 );
1088 csd_gen_utility_pvt.add('party_rec.attribute12 :'||p_party_rel_rec.party_rec.attribute12 );
1089 csd_gen_utility_pvt.add('party_rec.attribute13 :'||p_party_rel_rec.party_rec.attribute13 );
1090 csd_gen_utility_pvt.add('party_rec.attribute14 :'||p_party_rel_rec.party_rec.attribute14 );
1091 csd_gen_utility_pvt.add('party_rec.attribute15 :'||p_party_rel_rec.party_rec.attribute15 );
1092 csd_gen_utility_pvt.add('party_rec.attribute16 :'||p_party_rel_rec.party_rec.attribute16 );
1093 csd_gen_utility_pvt.add('party_rec.attribute17 :'||p_party_rel_rec.party_rec.attribute17 );
1094 csd_gen_utility_pvt.add('party_rec.attribute18 :'||p_party_rel_rec.party_rec.attribute18 );
1095 csd_gen_utility_pvt.add('party_rec.attribute19 :'||p_party_rel_rec.party_rec.attribute19 );
1096 csd_gen_utility_pvt.add('party_rec.attribute20 :'||p_party_rel_rec.party_rec.attribute20 );
1097 csd_gen_utility_pvt.add('party_rec.attribute21 :'||p_party_rel_rec.party_rec.attribute21 );
1098 csd_gen_utility_pvt.add('party_rec.attribute22 :'||p_party_rel_rec.party_rec.attribute22 );
1099 csd_gen_utility_pvt.add('party_rec.attribute23 :'||p_party_rel_rec.party_rec.attribute23 );
1100 csd_gen_utility_pvt.add('party_rec.attribute24 :'||p_party_rel_rec.party_rec.attribute24 );
1101 END dump_hz_party_rel_rec;
1102
1103
1104 PROCEDURE dump_diagnostic_code_rec (
1105 p_diagnostic_code_rec IN CSD_DIAGNOSTIC_CODES_PVT.diagnostic_code_rec_type
1106 ) IS
1107 l_rec csd_diagnostic_codes_pvt.diagnostic_code_rec_type := p_diagnostic_code_rec;
1108
1109 BEGIN
1110
1111 csd_gen_utility_pvt.add('diagnostic_code _id :'||l_rec.diagnostic_code_id );
1112 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1113 csd_gen_utility_pvt.add('diagnostic_code :'||l_rec.diagnostic_code );
1114 csd_gen_utility_pvt.add('description :'||l_rec.description );
1115 csd_gen_utility_pvt.add('active_from :'||l_rec.active_from );
1116 csd_gen_utility_pvt.add('active_to :'||l_rec.active_to );
1117 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1118 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1119 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1120 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1121 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1122 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1123 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1124 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1125 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1126 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1127 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1128 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1129 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1130 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1131 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1132 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1133
1134 END dump_diagnostic_code_rec;
1135
1136 PROCEDURE dump_dc_domain_rec (
1137 p_dc_domain_rec IN CSD_DC_DOMAINS_PVT.dc_domain_rec_type
1138 ) IS
1139 l_rec csd_dc_domains_pvt.dc_domain_rec_type := p_dc_domain_rec;
1140
1141 BEGIN
1142
1143 csd_gen_utility_pvt.add('dc_domain _id :'||l_rec.dc_domain_id );
1144 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1145 csd_gen_utility_pvt.add('diagnostic_code_id :'||l_rec.diagnostic_code_id );
1146 csd_gen_utility_pvt.add('inventory_item_id :'||l_rec.inventory_item_id );
1147 csd_gen_utility_pvt.add('category_id :'||l_rec.category_id );
1148 csd_gen_utility_pvt.add('category_set_id :'||l_rec.category_set_id );
1149 csd_gen_utility_pvt.add('domain_type_code :'||l_rec.domain_type_code );
1150 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1151 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1152 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1153 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1154 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1155 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1156 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1157 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1158 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1159 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1160 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1161 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1162 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1163 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1164 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1165 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1166
1167 END dump_dc_domain_rec;
1168
1169 PROCEDURE dump_ro_diagnostic_code_rec (
1170 p_ro_diagnostic_code_rec IN CSD_RO_DIAGNOSTIC_CODES_PVT.ro_diagnostic_code_rec_type
1171 ) IS
1172 l_rec csd_ro_diagnostic_codes_pvt.ro_diagnostic_code_rec_type := p_ro_diagnostic_code_rec;
1173
1174 BEGIN
1175
1176 csd_gen_utility_pvt.add('ro_diagnostic_code_id :'||l_rec.ro_diagnostic_code_id );
1177 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1178 csd_gen_utility_pvt.add('repair_line_id :'||l_rec.repair_line_id );
1179 csd_gen_utility_pvt.add('diagnostic_code_id :'||l_rec.diagnostic_code_id );
1180 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1181 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1182 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1183 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1184 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1185 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1186 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1187 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1188 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1189 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1190 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1191 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1192 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1193 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1194 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1195 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1196
1197 END dump_ro_diagnostic_code_rec;
1198
1199 PROCEDURE dump_service_code_rec (
1200 p_service_code_rec IN CSD_SERVICE_CODES_PVT.service_code_rec_type
1201 ) IS
1202 l_rec csd_service_codes_pvt.service_code_rec_type := p_service_code_rec;
1203
1204 BEGIN
1205
1206 csd_gen_utility_pvt.add('service_code _id :'||l_rec.service_code_id );
1207 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1208 csd_gen_utility_pvt.add('service_code :'||l_rec.service_code );
1209 csd_gen_utility_pvt.add('description :'||l_rec.description );
1210 csd_gen_utility_pvt.add('active_from :'||l_rec.active_from );
1211 csd_gen_utility_pvt.add('active_to :'||l_rec.active_to );
1212 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1213 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1214 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1215 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1216 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1217 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1218 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1219 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1220 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1221 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1222 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1223 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1224 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1225 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1226 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1227 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1228
1229 END dump_service_code_rec;
1230
1231 PROCEDURE dump_sc_domain_rec (
1232 p_sc_domain_rec IN CSD_SC_DOMAINS_PVT.sc_domain_rec_type
1233 ) IS
1234 l_rec csd_sc_domains_pvt.sc_domain_rec_type := p_sc_domain_rec;
1235
1236 BEGIN
1237
1238 csd_gen_utility_pvt.add('sc_domain _id :'||l_rec.sc_domain_id );
1239 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1240 csd_gen_utility_pvt.add('service_code_id :'||l_rec.service_code_id );
1241 csd_gen_utility_pvt.add('inventory_item_id :'||l_rec.inventory_item_id );
1242 csd_gen_utility_pvt.add('category_id :'||l_rec.category_id );
1243 csd_gen_utility_pvt.add('category_set_id :'||l_rec.category_set_id );
1244 csd_gen_utility_pvt.add('domain_type_code :'||l_rec.domain_type_code );
1245 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1246 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1247 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1248 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1249 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1250 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1251 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1252 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1253 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1254 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1255 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1256 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1257 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1258 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1259 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1260 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1261
1262 END dump_sc_domain_rec;
1263
1264
1265 PROCEDURE dump_sc_work_entity_rec (
1266 p_sc_work_entity_rec IN CSD_SC_WORK_ENTITIES_PVT.sc_work_entity_rec_type
1267 ) IS
1268 l_rec csd_sc_work_entities_pvt.sc_work_entity_rec_type := p_sc_work_entity_rec;
1269
1270 BEGIN
1271
1272 csd_gen_utility_pvt.add('sc_work_entity_id :'||l_rec.sc_work_entity_id );
1273 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1274 csd_gen_utility_pvt.add('service_code_id :'||l_rec.service_code_id );
1275 csd_gen_utility_pvt.add('work_entity_id1 :'||l_rec.work_entity_id1 );
1276 csd_gen_utility_pvt.add('work_entity_type_code :'||l_rec.work_entity_type_code );
1277 csd_gen_utility_pvt.add('work_entity_id2 :'||l_rec.work_entity_id2 );
1278 csd_gen_utility_pvt.add('work_entity_id3 :'||l_rec.work_entity_id3 );
1279 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1280 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1281 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1282 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1283 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1284 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1285 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1286 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1287 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1288 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1289 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1290 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1291 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1292 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1293 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1294 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1295
1296 END dump_sc_work_entity_rec;
1297
1298 PROCEDURE dump_ro_service_code_rec (
1299 p_ro_service_code_rec IN CSD_RO_SERVICE_CODES_PVT.ro_service_code_rec_type
1300 ) IS
1301 l_rec csd_ro_service_codes_pvt.ro_service_code_rec_type := p_ro_service_code_rec;
1302
1303 BEGIN
1304
1305 csd_gen_utility_pvt.add('ro_service_code_id :'||l_rec.ro_service_code_id );
1306 csd_gen_utility_pvt.add('object_version_number :'||l_rec.object_version_number );
1307 csd_gen_utility_pvt.add('repair_line_id :'||l_rec.repair_line_id );
1308 csd_gen_utility_pvt.add('service_code_id :'||l_rec.service_code_id );
1309 csd_gen_utility_pvt.add('source_type_code :'||l_rec.source_type_code );
1310 csd_gen_utility_pvt.add('source_solution_id :'||l_rec.source_solution_id );
1311 csd_gen_utility_pvt.add('applicable_flag :'||l_rec.applicable_flag );
1312 csd_gen_utility_pvt.add('attribute_category :'||l_rec.attribute_category );
1313 csd_gen_utility_pvt.add('attribute1 :'||l_rec.attribute1 );
1314 csd_gen_utility_pvt.add('attribute2 :'||l_rec.attribute2 );
1315 csd_gen_utility_pvt.add('attribute3 :'||l_rec.attribute3 );
1316 csd_gen_utility_pvt.add('attribute4 :'||l_rec.attribute4 );
1317 csd_gen_utility_pvt.add('attribute5 :'||l_rec.attribute5 );
1318 csd_gen_utility_pvt.add('attribute6 :'||l_rec.attribute6 );
1319 csd_gen_utility_pvt.add('attribute7 :'||l_rec.attribute7 );
1320 csd_gen_utility_pvt.add('attribute8 :'||l_rec.attribute8 );
1321 csd_gen_utility_pvt.add('attribute9 :'||l_rec.attribute9 );
1322 csd_gen_utility_pvt.add('attribute10 :'||l_rec.attribute10 );
1323 csd_gen_utility_pvt.add('attribute11 :'||l_rec.attribute11 );
1324 csd_gen_utility_pvt.add('attribute12 :'||l_rec.attribute12 );
1325 csd_gen_utility_pvt.add('attribute13 :'||l_rec.attribute13 );
1326 csd_gen_utility_pvt.add('attribute14 :'||l_rec.attribute14 );
1327 csd_gen_utility_pvt.add('attribute15 :'||l_rec.attribute15 );
1328
1329 END dump_ro_service_code_rec;
1330
1331
1332 PROCEDURE dump_repair_estimate_line_tbl (
1333 p_repair_estimate_line_tbl IN CSD_REPAIR_ESTIMATE_PVT.repair_estimate_line_tbl
1334 ) IS
1335 l_tbl CSD_REPAIR_ESTIMATE_PVT.repair_estimate_line_tbl := p_repair_estimate_line_tbl;
1336 BEGIN
1337 IF l_tbl.count > 0 THEN
1338 csd_gen_utility_pvt.add('repair_estimate_line_tbl count :'||l_tbl.count);
1339 FOR i IN l_tbl.first..l_tbl.last LOOP
1340 IF l_tbl.exists(i) THEN
1341 csd_gen_utility_pvt.add('repair_estimate_line_tbl('||to_char(i)||'):');
1342 dump_estimate_line_rec(l_tbl(i));
1343 END IF;
1344 END LOOP;
1345 END IF;
1346 END dump_repair_estimate_line_tbl;
1347
1348
1349 PROCEDURE dump_mle_lines_rec_type (
1350 p_mle_lines_rec IN CSD_REPAIR_ESTIMATE_PVT.mle_lines_rec_type
1351 ) IS
1352 l_rec CSD_REPAIR_ESTIMATE_PVT.mle_lines_rec_type := p_mle_lines_rec;
1353 BEGIN
1354 csd_gen_utility_pvt.add(' inventory_item_id :'||l_rec.inventory_item_id);
1355 csd_gen_utility_pvt.add(' uom :'||l_rec.uom);
1356 csd_gen_utility_pvt.add(' quantity :'||l_rec.quantity);
1357 csd_gen_utility_pvt.add(' selling_price :'||l_rec.selling_price);
1358 csd_gen_utility_pvt.add(' item_name :'||l_rec.item_name);
1359 csd_gen_utility_pvt.add(' comms_nl_trackable_flag :'||l_rec.comms_nl_trackable_flag);
1360 csd_gen_utility_pvt.add(' txn_billing_type_id :'||l_rec.txn_billing_type_id);
1361 csd_gen_utility_pvt.add(' est_line_source_type_code :'||l_rec.est_line_source_type_code);
1362 csd_gen_utility_pvt.add(' est_line_source_id1 :'||l_rec.est_line_source_id1);
1363 csd_gen_utility_pvt.add(' est_line_source_id2 :'||l_rec.est_line_source_id2);
1364 csd_gen_utility_pvt.add(' ro_service_code_id :'||l_rec.ro_service_code_id);
1365 END dump_mle_lines_rec_type;
1366
1367 PROCEDURE dump_mle_lines_tbl_type (
1368 p_mle_lines_tbl IN CSD_REPAIR_ESTIMATE_PVT.mle_lines_tbl_type
1369 ) IS
1370 l_tbl CSD_REPAIR_ESTIMATE_PVT.mle_lines_tbl_type := p_mle_lines_tbl;
1371 BEGIN
1372 IF l_tbl.count > 0 THEN
1373 csd_gen_utility_pvt.add('mle_lines_tbl count :'||l_tbl.count);
1374 FOR i IN l_tbl.first..l_tbl.last LOOP
1375 IF l_tbl.exists(i) THEN
1376 csd_gen_utility_pvt.add('mle_lines_tbl('||to_char(i)||'):');
1377 dump_mle_lines_rec_type(l_tbl(i));
1378 END IF;
1379 END LOOP;
1380 END IF;
1381 END dump_mle_lines_tbl_type;
1382
1383 Function G_CURRENT_RUNTIME_LEVEL Return Number IS
1384 Begin
1385 Return Fnd_Log.G_Current_Runtime_Level ;
1386 End ;
1387 END csd_gen_utility_pvt;