[Home] [Help]
PACKAGE BODY: APPS.CSI_T_GEN_UTILITY_PVT
Source
1 PACKAGE BODY csi_t_gen_utility_pvt AS
2 /* $Header: csivtgub.pls 120.7.12010000.2 2008/11/06 20:34:13 mashah ship $*/
3
4 PROCEDURE build_file_name(
5 p_file_segment1 IN varchar2,
6 p_file_segment2 IN varchar2,
7 p_file_segment3 IN varchar2 )
8 IS
9 BEGIN
10
11 csi_t_gen_utility_pvt.set_debug_off;
12
13 csi_t_gen_utility_pvt.g_file :=
14 p_file_segment1||'.'||p_file_segment2||'.dbg';
15
16 END build_file_name;
17
18 PROCEDURE set_debug_on IS
19 l_audsid number;
20 BEGIN
21 IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_false THEN
22 IF csi_t_gen_utility_pvt.g_file is null then
23 select userenv('SESSIONID') into l_audsid from sys.dual;
24 build_file_name(
25 p_file_segment1 => 'csi',
26 p_file_segment2 => l_audsid);
27 csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
28 ELSE
29 csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
30 END IF;
31 csi_t_gen_utility_pvt.g_debug := fnd_api.g_true;
32 END IF;
33 EXCEPTION
34 WHEN others then
35 null;
36 END set_debug_on;
37
38 PROCEDURE set_debug_off IS
39 BEGIN
40
41 IF csi_t_gen_utility_pvt.is_debug_on THEN
42 utl_file.fclose(csi_t_gen_utility_pvt.g_file_ptr);
43 csi_t_gen_utility_pvt.g_debug := fnd_api.g_false;
44 END IF;
45
46 END set_debug_off;
47
48 FUNCTION is_debug_on RETURN boolean
49 IS
50 BEGIN
51 IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
52 return TRUE;
53 ELSE
54 return FALSE;
55 END IF;
56 END is_debug_on;
57
58
59 PROCEDURE add(
60 p_debug_msg in varchar2)
61 IS
62 BEGIN
63
64 IF csi_t_gen_utility_pvt.g_debug_level > 0 THEN
65 set_debug_on;
66 IF is_debug_on THEN
67 utl_file.put_line(g_file_ptr, p_debug_msg);
68 utl_file.fflush(g_file_ptr);
69 END IF;
70 set_debug_off;
71 END IF;
72
73 EXCEPTION
74 WHEN others THEN
75 null;
76 END add;
77
78 /* */
79 PROCEDURE dump_api_info(
80 p_pkg_name IN varchar2,
81 p_api_name IN varchar2,
82 p_indent IN number )
83 IS
84 l_out varchar2(512);
85 BEGIN
86 l_out := 'Inside API :'||p_pkg_name||'.'||p_api_name;
87 l_out := lpad(l_out, length(l_out)+p_indent, ' ');
88 add(l_out);
89 END dump_api_info;
90
91
92 /* */
93 PROCEDURE dump_error_stack
94 IS
95 l_msg_count number;
96 l_msg_data varchar2(2000);
97 l_msg_index_out number;
98 BEGIN
99
100 fnd_msg_pub.count_and_get(
101 p_count => l_msg_count,
102 p_data => l_msg_data);
103
104 FOR l_ind IN 1..l_msg_count
105 LOOP
106
107 fnd_msg_pub.get(
108 p_msg_index => l_ind,
109 p_encoded => fnd_api.g_false,
110 p_data => l_msg_data,
111 p_msg_index_out => l_msg_index_out);
112
113 add('Error: '||l_msg_data);
114
115 END LOOP;
116
117 END dump_error_stack;
118
119 /* */
120 FUNCTION dump_error_stack RETURN varchar2
121 IS
122 l_msg_count number;
123 l_msg_data varchar2(2000);
124 l_msg_index_out number;
125 x_msg_data varchar2(4000);
126 BEGIN
127
128 x_msg_data := null;
129
130 fnd_msg_pub.count_and_get(
131 p_count => l_msg_count,
132 p_data => l_msg_data);
133
134 FOR l_ind IN 1..l_msg_count
135 LOOP
136
137 fnd_msg_pub.get(
138 p_msg_index => l_ind,
139 p_encoded => fnd_api.g_false,
140 p_data => l_msg_data,
141 p_msg_index_out => l_msg_index_out);
142
143 x_msg_data := ltrim(x_msg_data||' '||l_msg_data);
144
145 IF length(x_msg_data) > 1999 THEN
146 x_msg_data := substr(x_msg_data, 1, 1999);
147 exit;
148 END IF;
149
150 END LOOP;
151
152 RETURN x_msg_data;
153
154 EXCEPTION
155 when others then
156 add('Error in dump_error_stack:'||sqlerrm);
157 RETURN x_msg_data;
158 END dump_error_stack;
159
160 PROCEDURE dump_txn_systems_rec (
161 p_txn_systems_rec in csi_t_datastructures_grp.txn_system_rec)
162 is
163 l_rec csi_t_datastructures_grp.txn_system_rec;
164 begin
165 l_rec := p_txn_systems_rec;
166
167 add('txn_system_rec');
168 add(' transaction_system_id :'|| l_rec.transaction_system_id );
169 add(' transaction_line_id :'|| l_rec.transaction_line_id );
170
171 IF g_debug_level > 10 THEN
172 add(' customer_id :'|| l_rec.customer_id );
173 add(' bill_to_contact_id :'|| l_rec.bill_to_contact_id );
174 add(' ship_to_contact_id :'|| l_rec.ship_to_contact_id );
175 add(' system_name :'|| l_rec.system_name );
176 add(' description :'|| l_rec.description );
177 add(' system_type_code :'|| l_rec.system_type_code );
178 add(' system_number :'|| l_rec.system_number );
179 add(' technical_contact_id :'|| l_rec.technical_contact_id );
180 add(' service_admin_contact_id :'|| l_rec.service_admin_contact_id );
181 add(' ship_to_site_use_id :'|| l_rec.ship_to_site_use_id );
182 add(' bill_to_site_use_id :'|| l_rec.bill_to_site_use_id );
183 add(' install_site_use_id :'|| l_rec.install_site_use_id );
184 add(' coterminate_day_month :'|| l_rec.coterminate_day_month );
185 add(' config_system_type :'|| l_rec.config_system_type );
186 END IF;
187
188 IF g_debug_level > 25 THEN
189 add(' context :'|| l_rec.context );
190 add(' attribute1 :'|| l_rec.attribute1 );
191 add(' attribute2 :'|| l_rec.attribute2 );
192 add(' attribute3 :'|| l_rec.attribute3 );
193 add(' attribute4 :'|| l_rec.attribute4 );
194 add(' attribute5 :'|| l_rec.attribute5 );
195 add(' attribute6 :'|| l_rec.attribute6 );
196 add(' attribute7 :'|| l_rec.attribute7 );
197 add(' attribute8 :'|| l_rec.attribute8 );
198 add(' attribute9 :'|| l_rec.attribute9 );
199 add(' attribute10 :'|| l_rec.attribute10 );
200 add(' attribute11 :'|| l_rec.attribute11 );
201 add(' attribute12 :'|| l_rec.attribute12 );
202 add(' attribute13 :'|| l_rec.attribute13 );
203 add(' attribute14 :'|| l_rec.attribute14 );
204 add(' attribute15 :'|| l_rec.attribute15 );
205 add(' object_version_number :'|| l_rec.object_version_number );
206 END IF;
207 END dump_txn_systems_rec;
208
209 PROCEDURE dump_txn_line_rec(
210 p_txn_line_rec in csi_t_datastructures_grp.txn_line_rec)
211 IS
212 l_rec csi_t_datastructures_grp.txn_line_rec;
213 BEGIN
214
215 l_rec := p_txn_line_rec;
216
217 add('txn_line_rec :');
218 add(' transaction_line_id :'||l_rec.transaction_line_id );
219 add(' src_transaction_type_id :'||l_rec.source_transaction_type_id );
220 add(' src_transaction_table :'||l_rec.source_transaction_table );
221 add(' src_transaction_id :'||l_rec.source_transaction_id );
222 add(' processing_status :'||l_rec.processing_status );
223
224 IF g_debug_level > 10 THEN
225 add(' src_transaction_hdr_id :'||l_rec.source_txn_header_id );
226 add(' inv_material_txn_flag :'||l_rec.inv_material_txn_flag );
227 add(' error_code :'||l_rec.error_code );
228 add(' error_explanation :'||l_rec.error_explanation );
229 add(' api_caller_identity :'||l_rec.api_caller_identity);
230 add(' config_session_hdr_id :'||l_rec.config_session_hdr_id);
231 add(' config_session_rev_num :'||l_rec.config_session_rev_num);
232 add(' config_session_item_id :'||l_rec.config_session_item_id);
233 END IF;
234
235 IF g_debug_level > 25 then
236 add(' context :'|| l_rec.context );
237 add(' attribute1 :'|| l_rec.attribute1 );
238 add(' attribute2 :'|| l_rec.attribute2 );
239 add(' attribute3 :'|| l_rec.attribute3 );
240 add(' attribute4 :'|| l_rec.attribute4 );
241 add(' attribute5 :'|| l_rec.attribute5 );
242 add(' attribute6 :'|| l_rec.attribute6 );
243 add(' attribute7 :'|| l_rec.attribute7 );
244 add(' attribute8 :'|| l_rec.attribute8 );
245 add(' attribute9 :'|| l_rec.attribute9 );
246 add(' attribute10 :'|| l_rec.attribute10 );
247 add(' attribute11 :'|| l_rec.attribute11 );
248 add(' attribute12 :'|| l_rec.attribute12 );
249 add(' attribute13 :'|| l_rec.attribute13 );
250 add(' attribute14 :'|| l_rec.attribute14 );
251 add(' attribute15 :'|| l_rec.attribute15 );
252 add(' object_version_number :'|| l_rec.object_version_number );
253 END IF;
254
255 END dump_txn_line_rec;
256
257 PROCEDURE dump_line_detail_rec(
258 p_line_detail_rec in csi_t_datastructures_grp.txn_line_detail_rec)
259 is
260 l_rec csi_t_datastructures_grp.txn_line_detail_rec;
261 begin
262
263 l_rec := p_line_detail_rec ;
264
265 add('txn_line_detail_rec :');
266 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
267 add(' transaction_line_id :'|| l_rec.transaction_line_id );
268 add(' source_transaction_flag :'|| l_rec.source_transaction_flag );
269 add(' sub_type_id :'|| l_rec.sub_type_id );
270
271 IF g_debug_level > 5 then
272 add(' inv_organization_id :'|| l_rec.inv_organization_id );
273 add(' inventory_item_id :'|| l_rec.inventory_item_id );
274 add(' inventory_revision :'|| l_rec.inventory_revision );
275 add(' mfg_serial_number_flag :'|| l_rec.mfg_serial_number_flag );
276 add(' serial_number :'|| l_rec.serial_number );
277 add(' lot_number :'|| l_rec.lot_number );
278 add(' quantity :'|| l_rec.quantity );
279 add(' unit_of_measure :'|| l_rec.unit_of_measure );
280 add(' instance_exists_flag :'|| l_rec.instance_exists_flag );
281 add(' instance_id :'|| l_rec.instance_id );
282 add(' location_type_code :'|| l_rec.location_type_code );
283 add(' location_id :'|| l_rec.location_id );
284 add(' changed_instance_id :'|| l_rec.changed_instance_id );
285 add(' csi_system_id :'|| l_rec.csi_system_id );
286 add(' csi_transaction_id :'|| l_rec.csi_transaction_id );
287 add(' active_start_date :'|| l_rec.active_start_date );
288 add(' active_end_date :'|| l_rec.active_end_date );
289 add(' processing_status :'|| l_rec.processing_status );
290 add(' cascade_owner_flag :'|| l_rec.cascade_owner_flag );
291 add(' instance_status_id :'|| l_rec.instance_status_id );
292 add(' preserve_detail_flag :'|| l_rec.preserve_detail_flag );
293 END IF;
294
295 IF g_debug_level > 10 then
296 add(' preserve_detail_flag :'|| l_rec.preserve_detail_flag );
297 add(' item_condition_id :'|| l_rec.item_condition_id );
298 add(' instance_type_code :'|| l_rec.instance_type_code );
299 add(' qty_remaining :'|| l_rec.qty_remaining );
300 add(' installation_date :'|| l_rec.installation_date );
301 add(' in_service_date :'|| l_rec.in_service_date );
302 add(' external_reference :'|| l_rec.external_reference );
303 add(' transaction_system_id :'|| l_rec.transaction_system_id );
304 add(' sellable_flag :'|| l_rec.sellable_flag );
305 add(' version_label :'|| l_rec.version_label );
306 add(' return_by_date :'|| l_rec.return_by_date );
307 add(' reference_source_id :'|| l_rec.reference_source_id );
308 add(' reference_source_date :'|| l_rec.reference_source_date );
309 add(' object_version_number :'|| l_rec.object_version_number );
310 add(' inst_hdr_id :'|| l_rec.config_inst_hdr_id );
311 add(' inst_rev_num :'|| l_rec.config_inst_rev_num );
312 add(' inst_item_id :'|| l_rec.config_inst_item_id );
313 add(' inst_baseline_rev_num :'|| l_rec.config_inst_baseline_rev_num );
314 END IF;
315
316 IF g_debug_level > 25 then
317 add(' context :'|| l_rec.context );
318 add(' attribute1 :'|| l_rec.attribute1 );
319 add(' attribute2 :'|| l_rec.attribute2 );
320 add(' attribute3 :'|| l_rec.attribute3 );
321 add(' attribute4 :'|| l_rec.attribute4 );
322 add(' attribute5 :'|| l_rec.attribute5 );
323 add(' attribute6 :'|| l_rec.attribute6 );
324 add(' attribute7 :'|| l_rec.attribute7 );
325 add(' attribute8 :'|| l_rec.attribute8 );
326 add(' attribute9 :'|| l_rec.attribute9 );
327 add(' attribute10 :'|| l_rec.attribute10 );
328 add(' attribute11 :'|| l_rec.attribute11 );
329 add(' attribute12 :'|| l_rec.attribute12 );
330 add(' attribute13 :'|| l_rec.attribute13 );
331 add(' attribute14 :'|| l_rec.attribute14 );
332 add(' attribute15 :'|| l_rec.attribute15 );
333 END IF;
334
335 END dump_line_detail_rec;
336
337 PROCEDURE dump_party_detail_rec(
338 p_party_detail_rec in csi_t_datastructures_grp.txn_party_detail_rec )
339 is
340 l_rec csi_t_datastructures_grp.txn_party_detail_rec;
341 begin
342
343 l_rec := p_party_detail_rec;
344
345 add('txn_party_detail_rec :');
346 add(' txn_line_details_index :'|| l_rec.txn_line_details_index );
347 add(' txn_party_detail_id :'|| l_rec.txn_party_detail_id );
348 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
349 add(' txn_contact_party_index :'|| l_rec.txn_contact_party_index );
350
351 IF g_debug_level > 5 then
352 add(' party_source_table :'|| l_rec.party_source_table );
353 add(' party_source_id :'|| l_rec.party_source_id );
354 add(' relationship_type_code :'|| l_rec.relationship_type_code );
355 add(' instance_party_id :'|| l_rec.instance_party_id );
356 add(' contact_flag :'|| l_rec.contact_flag );
357 add(' contact_party_id :'|| l_rec.contact_party_id );
358 add(' primary_flag :'|| l_rec.primary_flag );
359 add(' preferred_flag :'|| l_rec.preferred_flag );
360 add(' active_start_date :'|| l_rec.active_start_date );
361 add(' active_end_date :'|| l_rec.active_end_date );
362 END IF;
363
364 IF g_debug_level >= 10 then
365 add(' preserve_detail_flag :'|| l_rec.preserve_detail_flag );
366 add(' object_version_number :'|| l_rec.object_version_number );
367 END IF;
368
369 IF g_debug_level > 25 then
370 add(' context :'|| l_rec.context );
371 add(' attribute1 :'|| l_rec.attribute1 );
372 add(' attribute2 :'|| l_rec.attribute2 );
373 add(' attribute3 :'|| l_rec.attribute3 );
374 add(' attribute4 :'|| l_rec.attribute4 );
375 add(' attribute5 :'|| l_rec.attribute5 );
376 add(' attribute6 :'|| l_rec.attribute6 );
377 add(' attribute7 :'|| l_rec.attribute7 );
378 add(' attribute8 :'|| l_rec.attribute8 );
379 add(' attribute9 :'|| l_rec.attribute9 );
380 add(' attribute10 :'|| l_rec.attribute10 );
381 add(' attribute11 :'|| l_rec.attribute11 );
382 add(' attribute12 :'|| l_rec.attribute12 );
383 add(' attribute13 :'|| l_rec.attribute13 );
384 add(' attribute14 :'|| l_rec.attribute14 );
385 add(' attribute15 :'|| l_rec.attribute15 );
386 END IF;
387
388 END dump_party_detail_rec;
389
390 PROCEDURE dump_pty_acct_rec(
391 p_pty_acct_rec in csi_t_datastructures_grp.txn_pty_acct_detail_rec)
392 IS
393 l_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
394 begin
395
396 l_rec := p_pty_acct_rec;
397
398 add('txn_pty_acct_detail_rec :');
399 add(' txn_party_details_index :'|| l_rec.txn_party_details_index );
400 add(' txn_account_detail_id :'|| l_rec.txn_account_detail_id );
401 add(' txn_party_detail_id :'|| l_rec.txn_party_detail_id );
402
403 IF g_debug_level > 5 THEN
404 add(' ip_account_id :'|| l_rec.ip_account_id );
405 add(' account_id :'|| l_rec.account_id );
406 add(' relationship_type_code :'|| l_rec.relationship_type_code );
407 add(' bill_to_address_id :'|| l_rec.bill_to_address_id );
408 add(' ship_to_address_id :'|| l_rec.ship_to_address_id );
409 add(' preserve_detail_flag :'|| l_rec.preserve_detail_flag );
410 add(' active_start_date :'|| l_rec.active_start_date );
411 add(' active_end_date :'|| l_rec.active_end_date );
412 END IF;
413
414 IF g_debug_level > 10 THEN
415 add(' object_version_number :'|| l_rec.object_version_number );
416 END IF;
417
418 IF g_debug_level > 25 THEN
419 add(' context :'|| l_rec.context );
420 add(' attribute1 :'|| l_rec.attribute1 );
421 add(' attribute2 :'|| l_rec.attribute2 );
422 add(' attribute3 :'|| l_rec.attribute3 );
423 add(' attribute4 :'|| l_rec.attribute4 );
424 add(' attribute5 :'|| l_rec.attribute5 );
425 add(' attribute6 :'|| l_rec.attribute6 );
426 add(' attribute7 :'|| l_rec.attribute7 );
427 add(' attribute8 :'|| l_rec.attribute8 );
428 add(' attribute9 :'|| l_rec.attribute9 );
429 add(' attribute10 :'|| l_rec.attribute10 );
430 add(' attribute11 :'|| l_rec.attribute11 );
431 add(' attribute12 :'|| l_rec.attribute12 );
432 add(' attribute13 :'|| l_rec.attribute13 );
433 add(' attribute14 :'|| l_rec.attribute14 );
434 add(' attribute15 :'|| l_rec.attribute15 );
435 END IF;
436
437 END dump_pty_acct_rec;
438
439 PROCEDURE dump_ii_rltns_rec(
440 p_ii_rltns_rec in csi_t_datastructures_grp.txn_ii_rltns_rec)
441 is
442 l_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
443 begin
444 l_rec := p_ii_rltns_rec;
445
446 add('txn_ii_rltns_rec :');
447 add(' txn_relationship_id :'|| l_rec.txn_relationship_id );
448 add(' transaction_line_id :'|| l_rec.transaction_line_id );
449
450 IF g_debug_level > 5 THEN
451
452 add(' subject_index_flag :'|| l_rec.subject_index_flag );
453 add(' subject_type :'|| l_rec.subject_type );
454 add(' subject_id :'|| l_rec.subject_id );
455 add(' relationship_type_code :'|| l_rec.relationship_type_code );
456 add(' object_index_flag :'|| l_rec.object_index_flag );
457 add(' object_type :'|| l_rec.object_type );
458 add(' object_id :'|| l_rec.object_id );
459 add(' csi_inst_relationship_id :'|| l_rec.csi_inst_relationship_id );
460 add(' active_start_date :'|| l_rec.active_start_date );
461 add(' active_end_date :'|| l_rec.active_end_date );
462
463 END IF;
464
465 IF g_debug_level > 10 THEN
466 add(' sub_config_inst_hdr_id :'|| l_rec.sub_config_inst_hdr_id );
467 add(' sub_config_inst_rev_num :'|| l_rec.sub_config_inst_rev_num );
468 add(' sub_config_inst_item_id :'|| l_rec.sub_config_inst_item_id );
469 add(' obj_config_inst_hdr_id :'|| l_rec.obj_config_inst_hdr_id );
470 add(' obj_config_inst_rev_num :'|| l_rec.obj_config_inst_rev_num );
471 add(' obj_config_inst_item_id :'|| l_rec.obj_config_inst_item_id );
472 add(' target_commitment_date :'|| l_rec.target_commitment_date );
473 add(' api_caller_identity :'|| l_rec.api_caller_identity );
474 add(' display_order :'|| l_rec.display_order );
475 add(' position_reference :'|| l_rec.position_reference );
476 add(' mandatory_flag :'|| l_rec.mandatory_flag );
477 add(' object_version_number :'|| l_rec.object_version_number );
478 END IF;
479
480 IF g_debug_level > 25 THEN
481 add(' context :'|| l_rec.context );
482 add(' attribute1 :'|| l_rec.attribute1 );
483 add(' attribute2 :'|| l_rec.attribute2 );
484 add(' attribute3 :'|| l_rec.attribute3 );
485 add(' attribute4 :'|| l_rec.attribute4 );
486 add(' attribute5 :'|| l_rec.attribute5 );
487 add(' attribute6 :'|| l_rec.attribute6 );
488 add(' attribute7 :'|| l_rec.attribute7 );
489 add(' attribute8 :'|| l_rec.attribute8 );
490 add(' attribute9 :'|| l_rec.attribute9 );
491 add(' attribute10 :'|| l_rec.attribute10 );
492 add(' attribute11 :'|| l_rec.attribute11 );
493 add(' attribute12 :'|| l_rec.attribute12 );
494 add(' attribute13 :'|| l_rec.attribute13 );
495 add(' attribute14 :'|| l_rec.attribute14 );
496 add(' attribute15 :'|| l_rec.attribute15 );
497 END IF;
498
499 END dump_ii_rltns_rec;
500
501 PROCEDURE dump_org_assgn_rec(
502 p_org_assgn_rec in csi_t_datastructures_grp.txn_org_assgn_rec)
503 is
504 l_rec csi_t_datastructures_grp.txn_org_assgn_rec;
505 begin
506
507 l_rec := p_org_assgn_rec;
508
509 add('txn_org_assgn_rec :');
510 add(' txn_line_details_index :'|| l_rec.txn_line_details_index );
511 add(' txn_operating_unit_id :'|| l_rec.txn_operating_unit_id );
512 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
513
514 IF g_debug_level > 5 then
515 add(' operating_unit_id :'|| l_rec.operating_unit_id );
516 add(' relationship_type_code :'|| l_rec.relationship_type_code );
517 add(' active_start_date :'|| l_rec.active_start_date );
518 add(' active_end_date :'|| l_rec.active_end_date );
519 END IF;
520
521 IF g_debug_level > 10 then
522 add(' instance_ou_id :'|| l_rec.instance_ou_id );
523 add(' preserve_detail_flag :'|| l_rec.preserve_detail_flag );
524 add(' object_version_number :'|| l_rec.object_version_number );
525 END IF;
526
527 IF g_debug_level > 25 then
528 add(' context :'|| l_rec.context );
529 add(' attribute1 :'|| l_rec.attribute1 );
530 add(' attribute2 :'|| l_rec.attribute2 );
531 add(' attribute3 :'|| l_rec.attribute3 );
532 add(' attribute4 :'|| l_rec.attribute4 );
533 add(' attribute5 :'|| l_rec.attribute5 );
534 add(' attribute6 :'|| l_rec.attribute6 );
535 add(' attribute7 :'|| l_rec.attribute7 );
536 add(' attribute8 :'|| l_rec.attribute8 );
537 add(' attribute9 :'|| l_rec.attribute9 );
538 add(' attribute10 :'|| l_rec.attribute10 );
539 add(' attribute11 :'|| l_rec.attribute11 );
540 add(' attribute12 :'|| l_rec.attribute12 );
541 add(' attribute13 :'|| l_rec.attribute13 );
542 add(' attribute14 :'|| l_rec.attribute14 );
543 add(' attribute15 :'|| l_rec.attribute15 );
544 END IF;
545
546 END dump_org_assgn_rec;
547
548 PROCEDURE dump_txn_eav_rec(
549 p_txn_eav_rec in csi_t_datastructures_grp.txn_ext_attrib_vals_rec)
550 is
551 l_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
552 begin
553
554 l_rec := p_txn_eav_rec;
555
556 add('txn_ext_attrib_vals_rec :');
557 add(' txn_line_details_index :'|| l_rec.txn_line_details_index );
558 add(' txn_attrib_detail_id :'|| l_rec.txn_attrib_detail_id );
559 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
560
561 IF g_debug_level > 5 then
562 add(' attrib_source_table :'|| l_rec.attrib_source_table );
563 add(' attribute_source_id :'|| l_rec.attribute_source_id );
564 add(' attribute_code :'|| l_rec.attribute_code );
565 add(' attribute_level :'|| l_rec.attribute_level );
566 add(' attribute_value :'|| l_rec.attribute_value );
567 add(' active_start_date :'|| l_rec.active_start_date );
568 add(' active_end_date :'|| l_rec.active_end_date );
569 END IF;
570
571 IF g_debug_level > 10 then
572 add(' preserve_detail_flag :'|| l_rec.preserve_detail_flag );
573 add(' object_version_number :'|| l_rec.object_version_number );
574 add(' process_flag :'|| l_rec.process_flag );
575 END IF;
576
577 IF g_debug_level > 25 then
578 add(' context :'|| l_rec.context );
579 add(' attribute1 :'|| l_rec.attribute1 );
580 add(' attribute2 :'|| l_rec.attribute2 );
581 add(' attribute3 :'|| l_rec.attribute3 );
582 add(' attribute4 :'|| l_rec.attribute4 );
583 add(' attribute5 :'|| l_rec.attribute5 );
584 add(' attribute6 :'|| l_rec.attribute6 );
585 add(' attribute7 :'|| l_rec.attribute7 );
586 add(' attribute8 :'|| l_rec.attribute8 );
587 add(' attribute9 :'|| l_rec.attribute9 );
588 add(' attribute10 :'|| l_rec.attribute10 );
589 add(' attribute11 :'|| l_rec.attribute11 );
590 add(' attribute12 :'|| l_rec.attribute12 );
591 add(' attribute13 :'|| l_rec.attribute13 );
592 add(' attribute14 :'|| l_rec.attribute14 );
593 add(' attribute15 :'|| l_rec.attribute15 );
594 END IF;
595 END dump_txn_eav_rec;
596
597 PROCEDURE dump_csi_ea_rec(
598 p_csi_ea_rec in csi_t_datastructures_grp.csi_ext_attribs_rec)
599 is
600 l_rec csi_t_datastructures_grp.csi_ext_attribs_rec;
601 begin
602
603 l_rec := p_csi_ea_rec;
604
605 add('csi_ext_attribs_rec :');
606 add(' attribute_id :'|| l_rec.attribute_id );
607 add(' attribute_level :'|| l_rec.attribute_level );
608
609 IF g_debug_level > 5 THEN
610 add(' master_organization_id :'|| l_rec.master_organization_id );
611 add(' inventory_item_id :'|| l_rec.inventory_item_id );
612 add(' item_category_id :'|| l_rec.item_category_id );
613 add(' instance_id :'|| l_rec.instance_id );
614 add(' attribute_code :'|| l_rec.attribute_code );
615 add(' attribute_name :'|| l_rec.attribute_name );
616 add(' attribute_category :'|| l_rec.attribute_category );
617 add(' description :'|| l_rec.description );
618 add(' active_start_date :'|| l_rec.active_start_date );
619 add(' active_end_date :'|| l_rec.active_end_date );
620 add(' object_version_number :'|| l_rec.object_version_number );
621 END IF;
622
623 IF g_debug_level > 25 then
624 add(' context :'|| l_rec.context );
625 add(' attribute1 :'|| l_rec.attribute1 );
626 add(' attribute2 :'|| l_rec.attribute2 );
627 add(' attribute3 :'|| l_rec.attribute3 );
628 add(' attribute4 :'|| l_rec.attribute4 );
629 add(' attribute5 :'|| l_rec.attribute5 );
630 add(' attribute6 :'|| l_rec.attribute6 );
631 add(' attribute7 :'|| l_rec.attribute7 );
632 add(' attribute8 :'|| l_rec.attribute8 );
633 add(' attribute9 :'|| l_rec.attribute9 );
634 add(' attribute10 :'|| l_rec.attribute10 );
635 add(' attribute11 :'|| l_rec.attribute11 );
636 add(' attribute12 :'|| l_rec.attribute12 );
637 add(' attribute13 :'|| l_rec.attribute13 );
638 add(' attribute14 :'|| l_rec.attribute14 );
639 add(' attribute15 :'|| l_rec.attribute15 );
640 END IF;
641
642 END dump_csi_ea_rec;
643
644 PROCEDURE dump_csi_eav_rec (
645 p_csi_eav_rec in csi_t_datastructures_grp.csi_ext_attrib_vals_rec)
646 IS
647 l_rec csi_t_datastructures_grp.csi_ext_attrib_vals_rec;
648 BEGIN
649
650 l_rec := p_csi_eav_rec;
651
652 add('csi_t_datastructures_grp.csi_ext_attrib_vals_rec :');
653 add(' attribute_value_id :'|| l_rec.attribute_value_id );
654 add(' instance_id :'|| l_rec.instance_id );
655 add(' attribute_id :'|| l_rec.attribute_id );
656 add(' attribute_value :'|| l_rec.attribute_value );
657
658 IF g_debug_level > 5 then
659 add(' active_start_date :'|| l_rec.active_start_date );
660 add(' active_end_date :'|| l_rec.active_end_date );
661 add(' object_version_number :'|| l_rec.object_version_number );
662 END IF;
663
664 IF g_debug_level > 25 then
665 add(' context :'|| l_rec.context );
666 add(' attribute1 :'|| l_rec.attribute1 );
667 add(' attribute2 :'|| l_rec.attribute2 );
668 add(' attribute3 :'|| l_rec.attribute3 );
669 add(' attribute4 :'|| l_rec.attribute4 );
670 add(' attribute5 :'|| l_rec.attribute5 );
671 add(' attribute6 :'|| l_rec.attribute6 );
672 add(' attribute7 :'|| l_rec.attribute7 );
673 add(' attribute8 :'|| l_rec.attribute8 );
674 add(' attribute9 :'|| l_rec.attribute9 );
675 add(' attribute10 :'|| l_rec.attribute10 );
676 add(' attribute11 :'|| l_rec.attribute11 );
677 add(' attribute12 :'|| l_rec.attribute12 );
678 add(' attribute13 :'|| l_rec.attribute13 );
679 add(' attribute14 :'|| l_rec.attribute14 );
680 add(' attribute15 :'|| l_rec.attribute15 );
681 END IF;
682
683 END dump_csi_eav_rec;
684
685 PROCEDURE dump_line_detail_ids_rec(
686 p_line_detail_ids_rec in csi_t_datastructures_grp.txn_line_detail_ids_rec)
687 IS
688 l_rec csi_t_datastructures_grp.txn_line_detail_ids_rec;
689 BEGIN
690 l_rec := p_line_detail_ids_rec;
691
692 add('txn_line_detail_ids_rec :');
693 add(' transaction_line_id :'|| l_rec.transaction_line_id );
694 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
695 END dump_line_detail_ids_rec;
696
697 PROCEDURE dump_party_detail_ids_rec(
698 p_party_detail_ids_rec in csi_t_datastructures_grp.txn_party_ids_rec )
699 IS
700 l_rec csi_t_datastructures_grp.txn_party_ids_rec ;
701 BEGIN
702 l_rec := p_party_detail_ids_rec ;
703
704 add('txn_party_ids_rec :');
705 add(' txn_party_detail_id :'|| l_rec.txn_party_detail_id );
706 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
707 END dump_party_detail_ids_rec;
708
709 PROCEDURE dump_pty_acct_ids_rec(
710 p_pty_acct_rec in csi_t_datastructures_grp.txn_pty_acct_ids_rec)
711 IS
712 l_rec csi_t_datastructures_grp.txn_pty_acct_ids_rec;
713 BEGIN
714 l_rec := p_pty_acct_rec;
715
716 add('txn_pty_acct_ids_rec :');
717 add(' txn_account_detail_id :'|| l_rec.txn_account_detail_id );
718 add(' txn_party_detail_id :'|| l_rec.txn_party_detail_id );
719 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
720
721 END dump_pty_acct_ids_rec;
722
723 PROCEDURE dump_ii_rltns_ids_rec(
724 p_ii_rltns_ids_rec in csi_t_datastructures_grp.txn_ii_rltns_ids_rec)
725 IS
726 l_rec csi_t_datastructures_grp.txn_ii_rltns_ids_rec;
727 BEGIN
728 l_rec := p_ii_rltns_ids_rec;
729
730 add('txn_ii_rltns_ids_rec :');
731 add(' txn_relationship_id :'|| l_rec.txn_relationship_id );
732 add(' transaction_line_id :'|| l_rec.transaction_line_id );
733
734 END dump_ii_rltns_ids_rec;
735
736 PROCEDURE dump_oa_ids_rec(
737 p_oa_ids_rec in csi_t_datastructures_grp.txn_org_assgn_ids_rec)
738 IS
739 l_rec csi_t_datastructures_grp.txn_org_assgn_ids_rec;
740
741 BEGIN
742
743 l_rec := p_oa_ids_rec;
744
745 add('txn_org_assgn_ids_rec :');
746 add(' txn_operating_unit_id :'|| l_rec.txn_operating_unit_id );
747 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
748
749 end dump_oa_ids_rec;
750
751 PROCEDURE dump_txn_ea_ids_rec(
752 p_txn_ea_ids_rec in csi_t_datastructures_grp.txn_ext_attrib_ids_rec)
753 is
754 l_rec csi_t_datastructures_grp.txn_ext_attrib_ids_rec;
755 begin
756 l_rec := p_txn_ea_ids_rec;
757
758 add('txn_ext_attrib_ids_rec :');
759 add(' txn_attrib_detail_id :'|| l_rec.txn_attrib_detail_id );
760 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
761
762 end dump_txn_ea_ids_rec;
763
764 PROCEDURE dump_txn_source_rec(
765 p_txn_source_rec in csi_t_ui_pvt.txn_source_rec)
766 IS
767 l_rec csi_t_ui_pvt.txn_source_rec;
768 BEGIN
769
770 l_rec := p_txn_source_rec;
771
772 IF g_debug_level > 25 THEN
773 add('txn_source_rec :');
774 add(' organization_id :'|| l_rec.organization_id );
775 add(' inventory_item_id :'|| l_rec.inventory_item_id );
776 add(' inventory_item_name :'|| l_rec.inventory_item_name );
777 add(' item_revision :'|| l_rec.item_revision );
778 add(' source_quantity :'|| l_rec.source_quantity );
779 add(' source_uom :'|| l_rec.source_uom );
780 add(' party_id :'|| l_rec.party_id );
781 add(' party_account_id :'|| l_rec.party_id );
782 add(' bill_to_address_id :'|| l_rec.bill_to_address_id );
783 add(' ship_to_address_id :'|| l_rec.ship_to_address_id );
784 add(' primary_uom :'|| l_rec.primary_uom );
785 add(' serial_control_flag :'|| l_rec.serial_control_flag );
786 add(' lot_control_flag :'|| l_rec.lot_control_flag );
787 add(' nl_trackable_flag :'|| l_rec.nl_trackable_flag );
788
789 END IF;
790 END dump_txn_source_rec;
791
792 PROCEDURE dump_txn_line_query_rec(
793 p_txn_line_query_rec in csi_t_datastructures_grp.txn_line_query_rec)
794 IS
795 l_rec csi_t_datastructures_grp.txn_line_query_rec;
796 BEGIN
797
798 l_rec := p_txn_line_query_rec;
799
800 add('txn_line_query_rec :');
801
802 add(' source_transaction_id :'|| l_rec.source_transaction_id );
803 add(' source_transaction_table :'|| l_rec.source_transaction_table );
804 add(' transaction_line_id :'|| l_rec.transaction_line_id );
805 add(' processing_status :'|| l_rec.processing_status );
806
807 IF g_debug_level > 10 THEN
808 add(' source_txn_header_id :'|| l_rec.source_txn_header_id );
809 add(' error_code :'|| l_rec.error_code );
810 add(' error_explanation :'|| l_rec.error_explanation );
811 add(' config_session_hdr_id :'|| l_rec.config_session_hdr_id );
812 add(' config_session_rev_num :'|| l_rec.config_session_rev_num );
813 add(' config_session_item_id :'|| l_rec.config_session_item_id );
814 END IF;
815
816 END dump_txn_line_query_rec;
817
818 PROCEDURE dump_txn_line_detail_query_rec(
819 p_txn_line_detail_query_rec in csi_t_datastructures_grp.txn_line_detail_query_rec)
820 IS
821 l_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
822 BEGIN
823 l_rec := p_txn_line_detail_query_rec;
824
825 add('txn_line_detail_query_rec :');
826 add(' source_transaction_flag :'|| l_rec.source_transaction_flag );
827 add(' txn_line_detail_id :'|| l_rec.txn_line_detail_id );
828 add(' sub_type_id :'|| l_rec.sub_type_id );
829 add(' processing_status :'|| l_rec.processing_status );
830
831 IF g_debug_level > 10 THEN
832 add(' csi_transaction_id :'|| l_rec.csi_transaction_id );
833 add(' error_code :'|| l_rec.error_code );
834 add(' error_explanation :'|| l_rec.error_explanation );
835 add(' instance_exists_flag :'|| l_rec.instance_exists_flag );
836 add(' instance_id :'|| l_rec.instance_id );
837 add(' csi_system_id :'|| l_rec.csi_system_id );
838 add(' transaction_system_id :'|| l_rec.transaction_system_id );
839 add(' inventory_item_id :'|| l_rec.inventory_item_id );
840 add(' inventory_revision :'|| l_rec.inventory_revision );
841 add(' inv_organization_id :'|| l_rec.inv_organization_id );
842 add(' serial_number :'|| l_rec.serial_number );
843 add(' mfg_serial_number_flag :'|| l_rec.mfg_serial_number_flag );
844 add(' lot_number :'|| l_rec.lot_number );
845 add(' location_type_code :'|| l_rec.location_type_code );
846 add(' external_reference :'|| l_rec.external_reference );
847 add(' return_by_date :'|| l_rec.return_by_date );
848 END IF;
849 END dump_txn_line_detail_query_rec;
850
851 PROCEDURE dump_csi_instance_rec(
852 p_csi_instance_rec in csi_datastructures_pub.instance_rec)
853 is
854 l_rec csi_datastructures_pub.instance_rec;
855 begin
856 l_rec := p_csi_instance_rec;
857
858 add('csi_instance_rec :');
859
860 add(' instance_id :'|| l_rec.instance_id);
861 add(' instance_number :'|| l_rec.instance_number);
862 add(' inventory_item_id :'|| l_rec.inventory_item_id);
863 add(' quantity :'|| l_rec.quantity);
864 add(' unit_of_measure :'|| l_rec.unit_of_measure);
865 add(' vld_organization_id :'|| l_rec.vld_organization_id);
866 add(' serial_number :'|| l_rec.serial_number);
867 add(' lot_number :'|| l_rec.lot_number);
868 add(' accounting_class_code :'|| l_rec.accounting_class_code);
869 add(' location_type_code :'|| l_rec.location_type_code);
870 add(' location_id :'|| l_rec.location_id);
871 add(' inv_organization_id :'|| l_rec.inv_organization_id);
872 add(' inv_subinventory_name :'|| l_rec.inv_subinventory_name);
873 add(' inv_locator_id :'|| l_rec.inv_locator_id);
874 add(' inventory_revision :'|| l_rec.inventory_revision);
875 add(' instance_usage_code :'|| l_rec.instance_usage_code);
876 add(' instance_status_id :'|| l_rec.instance_status_id);
877 add(' active_start_date :'|| l_rec.active_start_date);
878 add(' active_end_date :'|| l_rec.active_end_date);
879 add(' cascade owner flag :'|| l_rec.cascade_ownership_flag);
880
881 IF g_debug_level > 5 THEN
882 add(' mfg_serial_number_flag :'|| l_rec.mfg_serial_number_flag);
883 add(' system_id :'|| l_rec.system_id);
884 add(' last_oe_order_line_id :'|| l_rec.last_oe_order_line_id);
885 add(' last_oe_rma_line_id :'|| l_rec.last_oe_rma_line_id);
886 add(' last_wip_job_id :'|| l_rec.last_wip_job_id);
887 add(' wip_job_id :'|| l_rec.wip_job_id);
888 add(' return_by_date :'|| l_rec.return_by_date);
889 add(' actual_return_date :'|| l_rec.actual_return_date);
890 add(' object_version_number :'|| l_rec.object_version_number);
891 END IF;
892
893 IF g_debug_level > 10 THEN
894 add(' config_inst_hdr_id :'|| l_rec.config_inst_hdr_id);
895 add(' config_inst_rev_num :'|| l_rec.config_inst_rev_num);
896 add(' config_inst_item_id :'|| l_rec.config_inst_item_id);
897 add(' instance_condition_id :'|| l_rec.instance_condition_id);
898 add(' install_date :'|| l_rec.install_date);
899 add(' external_reference :'|| l_rec.external_reference);
900 add(' instance_type_code :'|| l_rec.instance_type_code);
901 add(' pa_project_id :'|| l_rec.pa_project_id);
902 add(' pa_project_task_id :'|| l_rec.pa_project_task_id);
903 add(' in_transit_order_line_id :'|| l_rec.in_transit_order_line_id);
904 add(' po_order_line_id :'|| l_rec.po_order_line_id);
905 add(' inv_master_org_id :'|| l_rec.inv_master_organization_id);
906 add(' last_po_po_line_id :'|| l_rec.last_po_po_line_id);
907 add(' last_oe_po_number :'|| l_rec.last_oe_po_number);
908 add(' last_pa_project_id :'|| l_rec.last_pa_project_id);
909 add(' last_pa_task_id :'|| l_rec.last_pa_task_id);
910 add(' last_oe_agreement_id :'|| l_rec.last_oe_agreement_id);
911 END IF;
912
913 IF g_debug_level > 15 THEN
914 add(' creation_complete_flag :'|| l_rec.creation_complete_flag);
915 add(' completeness_flag :'|| l_rec.completeness_flag);
916 add(' version_label :'|| l_rec.version_label);
917 add(' version_label_desc :'|| l_rec.version_label_description);
918 add(' customer_view_flag :'|| l_rec.customer_view_flag);
919 add(' merchant_view_flag :'|| l_rec.merchant_view_flag);
920 add(' sellable_flag :'|| l_rec.sellable_flag);
921 add(' manually_created_flag :'|| l_rec.manually_created_flag);
922 END IF;
923
924 IF g_debug_level > 25 THEN
925 add(' context :'|| l_rec.context);
926 add(' attribute1 :'|| l_rec.attribute1);
927 add(' attribute2 :'|| l_rec.attribute2);
928 add(' attribute3 :'|| l_rec.attribute3);
929 add(' attribute4 :'|| l_rec.attribute4);
930 add(' attribute5 :'|| l_rec.attribute5);
931 add(' attribute6 :'|| l_rec.attribute6);
932 add(' attribute7 :'|| l_rec.attribute7);
933 add(' attribute8 :'|| l_rec.attribute8);
934 add(' attribute9 :'|| l_rec.attribute9);
935 add(' attribute10 :'|| l_rec.attribute10);
936 add(' attribute11 :'|| l_rec.attribute11);
937 add(' attribute12 :'|| l_rec.attribute12);
938 add(' attribute13 :'|| l_rec.attribute13);
939 add(' attribute14 :'|| l_rec.attribute14);
940 add(' attribute15 :'|| l_rec.attribute15);
941 END IF;
942
943 END dump_csi_instance_rec;
944
945 PROCEDURE dump_csi_instance_tbl(
946 p_instance_tbl in csi_datastructures_pub.instance_tbl)
947 IS
948
949 l_inst_line varchar2(2000);
950
951 BEGIN
952
953 add('Instance ItemID Quantity Serial Number Lot Number UOM');
954 add('-------- ------- -------- ------------------ ------------------ ---');
955
956 IF p_instance_tbl.count > 0 THEN
957
958 FOR l_ind in p_instance_tbl.FIRST .. p_instance_tbl.LAST
959 LOOP
960 l_inst_line := rpad(to_char(p_instance_tbl(l_ind).instance_id), 10, ' ')||
961 rpad(to_char(p_instance_tbl(l_ind).inventory_item_id), 9, ' ')||
962 rpad(to_char(p_instance_tbl(l_ind).quantity),10, ' ')||
963 rpad(nvl(p_instance_tbl(l_ind).serial_number,' '),20, ' ')||
964 rpad(nvl(p_instance_tbl(l_ind).lot_number,' '),20, ' ')||
965 rpad(p_instance_tbl(l_ind).unit_of_measure,5, ' ');
966 add(l_inst_line);
967 END LOOP;
968
969 END IF;
970
971 END dump_csi_instance_tbl;
972
973 PROCEDURE dump_txn_tables(
974 p_ids_or_index_based IN varchar2,
975 p_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
976 p_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
977 p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
978 p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
979 p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
980 p_ea_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl)
981 IS
982 BEGIN
983
984 add('txn_line_details : '||p_line_detail_tbl.COUNT);
985 add('txn_party_details : '||p_party_detail_tbl.COUNT);
986 add('txn_party_acct_dtls : '||p_pty_acct_tbl.COUNT);
987 add('txn_ii_relations : '||p_ii_rltns_tbl.COUNT);
988 add('txn_org_assignments : '||p_org_assgn_tbl.COUNT);
989 add('txn_ext_attrib_vals : '||p_ea_vals_tbl.COUNT);
990
991 IF p_ids_or_index_based = 'I' THEN
992
993 IF p_line_detail_tbl.COUNT > 0 THEN
994 FOR l_td_ind IN p_line_detail_tbl.FIRST .. p_line_detail_tbl.LAST
995 LOOP
996 csi_t_gen_utility_pvt.dump_line_detail_rec(
997 p_line_detail_tbl(l_td_ind));
998
999 IF p_party_detail_tbl.COUNT > 0 THEN
1000 FOR l_pty_ind in p_party_detail_tbl.FIRST.. p_party_detail_tbl.LAST
1001 LOOP
1002
1003 IF p_party_detail_tbl(l_pty_ind).txn_line_detail_id =
1004 p_line_detail_tbl(l_td_ind).txn_line_detail_id THEN
1005
1006 csi_t_gen_utility_pvt.dump_party_detail_rec(
1007 p_party_detail_tbl(l_pty_ind));
1008
1009 IF p_pty_acct_tbl.COUNT > 0 THEN
1010 FOR l_pa_ind in p_pty_acct_tbl.FIRST .. p_pty_acct_tbl.LAST
1011 LOOP
1012 IF p_pty_acct_tbl(l_pa_ind).txn_party_detail_id =
1013 p_party_detail_tbl(l_pty_ind).txn_party_detail_id THEN
1014
1015 csi_t_gen_utility_pvt.dump_pty_acct_rec(
1016 p_pty_acct_tbl(l_pa_ind));
1017
1018 END IF;
1019 END LOOP;
1020 END IF;
1021
1022 END IF;
1023 END LOOP;
1024 END IF;
1025
1026 IF p_org_assgn_tbl.COUNT > 0 THEN
1027 FOR l_ind IN p_org_assgn_tbl.FIRST..p_org_assgn_tbl.LAST
1028 LOOP
1029 IF p_org_assgn_tbl(l_ind).txn_line_detail_id =
1030 p_line_detail_tbl(l_td_ind).txn_line_detail_id THEN
1031 csi_t_gen_utility_pvt.dump_org_assgn_rec(
1032 p_org_assgn_tbl(l_ind));
1033 END IF;
1034 END LOOP;
1035 END IF;
1036
1037 IF p_ea_vals_tbl.COUNT > 0 THEN
1038 FOR l_ind IN p_ea_vals_tbl.FIRST..p_ea_vals_tbl.LAST
1039 LOOP
1040
1041 IF p_ea_vals_tbl(l_ind).txn_line_detail_id =
1042 p_line_detail_tbl(l_td_ind).txn_line_detail_id THEN
1043
1044 csi_t_gen_utility_pvt.dump_txn_eav_rec(
1045 p_ea_vals_tbl(l_ind));
1046
1047 END IF;
1048
1049 END LOOP;
1050 END IF;
1051
1052 END LOOP;
1053 END IF;
1054
1055 ELSIF p_ids_or_index_based = 'X' THEN
1056 -- ## to be coded
1057 null;
1058 END IF;
1059
1060 IF p_ii_rltns_tbl.COUNT > 0 THEN
1061 FOR l_ind in p_ii_rltns_tbl.FIRST..p_ii_rltns_tbl.LAST
1062 LOOP
1063 csi_t_gen_utility_pvt.dump_ii_rltns_rec(
1064 p_ii_rltns_tbl(l_ind));
1065 END LOOP;
1066 END IF;
1067
1068 END dump_txn_tables;
1069
1070 PROCEDURE dump_txn_source_param_rec(
1071 p_txn_source_param_rec csi_t_ui_pvt.txn_source_param_rec)
1072 IS
1073 x_rec csi_t_ui_pvt.txn_source_param_rec;
1074 BEGIN
1075
1076 x_rec := p_txn_source_param_rec;
1077
1078 /*
1079 add('txn_source_param_rec :');
1080 add(' standalone_mode :'||x_rec.standalone_mode);
1081 add(' src_transaction_type_id :'||x_rec.source_transaction_type_id);
1082 add(' src_transaction_table :'||x_rec.source_transaction_table);
1083 add(' src_transaction_id :'||x_rec.source_transaction_id);
1084
1085 IF x_rec.standalone_mode <> 'Y' THEN
1086 add(' inventory_item_id :'||x_rec.inventory_item_id);
1087 add(' inv_orgn_id :'||x_rec.inv_orgn_id);
1088 add(' item_revision :'||x_rec.item_revision);
1089 add(' transacted_quantity :'||x_rec.transacted_quantity);
1090 add(' transacted_uom :'||x_rec.transacted_uom);
1091 add(' party_id :'||x_rec.party_id);
1092 add(' account_id :'||x_rec.account_id);
1093 add(' ship_to_org_id :'||x_rec.ship_to_org_id);
1094 add(' ship_to_contact_id :'||x_rec.ship_to_contact_id);
1095 add(' invoice_to_org_id :'||x_rec.invoice_to_org_id);
1096 add(' invoice_to_contact_id :'||x_rec.invoice_to_contact_id);
1097 END IF;
1098 */
1099
1100 END dump_txn_source_param_rec;
1101
1102 PROCEDURE dump_txn_instance_rec(
1103 p_txn_instance_rec IN csi_process_txn_grp.txn_instance_rec)
1104 IS
1105 l_rec csi_process_txn_grp.txn_instance_rec;
1106 BEGIN
1107
1108 l_rec := p_txn_instance_rec;
1109
1110 add('txn_instance_rec ');
1111
1112
1113 add(' ib_txn_segment_flag :'||l_rec.ib_txn_segment_flag);
1114 add(' instance_id :'||l_rec.instance_id);
1115 add(' new_instance_id :'||l_rec.new_instance_id);
1116 add(' instance_number :'||l_rec.instance_number);
1117 add(' external_reference :'||l_rec.external_reference);
1118 add(' vld_organization_id :'||l_rec.vld_organization_id);
1119 add(' master_organization_id :'||l_rec.inv_master_organization_id);
1120 add(' inventory_item_id :'||l_rec.inventory_item_id);
1121 add(' inventory_revision :'||l_rec.inventory_revision);
1122 add(' quantity :'||l_rec.quantity);
1123 add(' unit_of_measure :'||l_rec.unit_of_measure);
1124 add(' location_type_code :'||l_rec.location_type_code);
1125 add(' location_id :'||l_rec.location_id);
1126 add(' inv_organization_id :'||l_rec.inv_organization_id);
1127 add(' inv_subinventory_name :'||l_rec.inv_subinventory_name);
1128 add(' inv_locator_id :'||l_rec.inv_locator_id);
1129 add(' mfg_serial_number_flag :'||l_rec.mfg_serial_number_flag);
1130 add(' serial_number :'||l_rec.serial_number);
1131 add(' lot_number :'||l_rec.lot_number);
1132
1133 IF g_debug_level > 5 THEN
1134
1135 add(' accounting_class_code :'||l_rec.accounting_class_code);
1136 add(' instance_condition_id :'||l_rec.instance_condition_id);
1137 add(' instance_status_id :'||l_rec.instance_status_id);
1138 add(' customer_view_flag :'||l_rec.customer_view_flag);
1139 add(' merchant_view_flag :'||l_rec.merchant_view_flag);
1140 add(' sellable_flag :'||l_rec.sellable_flag);
1141 add(' system_id :'||l_rec.system_id);
1142 add(' instance_type_code :'||l_rec.instance_type_code);
1143 add(' active_start_date :'||l_rec.active_start_date);
1144 add(' active_end_date :'||l_rec.active_end_date);
1145 add(' pa_project_id :'||l_rec.pa_project_id);
1146 add(' pa_project_task_id :'||l_rec.pa_project_task_id);
1147 add(' in_transit_order_line_id :'||l_rec.in_transit_order_line_id);
1148 add(' wip_job_id :'||l_rec.wip_job_id);
1149 add(' po_order_line_id :'||l_rec.po_order_line_id);
1150 add(' last_oe_order_line_id :'||l_rec.last_oe_order_line_id);
1151 add(' last_oe_rma_line_id :'||l_rec.last_oe_rma_line_id);
1152 add(' last_po_po_line_id :'||l_rec.last_po_po_line_id);
1153 add(' last_oe_po_number :'||l_rec.last_oe_po_number);
1154 add(' last_wip_job_id :'||l_rec.last_wip_job_id);
1155 add(' last_pa_project_id :'||l_rec.last_pa_project_id);
1156 add(' last_pa_task_id :'||l_rec.last_pa_task_id);
1157 add(' last_oe_agreement_id :'||l_rec.last_oe_agreement_id);
1158 add(' install_date :'||l_rec.install_date);
1159 add(' manually_created_flag :'||l_rec.manually_created_flag);
1160 add(' return_by_date :'||l_rec.return_by_date);
1161 add(' actual_return_date :'||l_rec.actual_return_date);
1162 add(' creation_complete_flag :'||l_rec.creation_complete_flag);
1163 add(' completeness_flag :'||l_rec.completeness_flag);
1164 add(' last_txn_line_detail_id :'||l_rec.last_txn_line_detail_id);
1165 add(' install_loc_type_code :'||l_rec.install_location_type_code);
1166 add(' install_location_id :'||l_rec.install_location_id);
1167 add(' instance_usage_code :'||l_rec.instance_usage_code);
1168 add(' version_label :'||l_rec.version_label);
1169 add(' version_label_desc :'||l_rec.version_label_description);
1170 add(' object_version_number :'||l_rec.object_version_number);
1171
1172 END IF;
1173
1174 IF g_debug_level > 25 THEN
1175 add(' context :'||l_rec.context);
1176 add(' attribute1 :'||l_rec.attribute1);
1177 add(' attribute2 :'||l_rec.attribute2);
1178 add(' attribute3 :'||l_rec.attribute3);
1179 add(' attribute4 :'||l_rec.attribute4);
1180 add(' attribute5 :'||l_rec.attribute5);
1181 add(' attribute6 :'||l_rec.attribute6);
1182 add(' attribute7 :'||l_rec.attribute7);
1183 add(' attribute8 :'||l_rec.attribute8);
1184 add(' attribute9 :'||l_rec.attribute9);
1185 add(' attribute10 :'||l_rec.attribute10);
1186 add(' attribute11 :'||l_rec.attribute11);
1187 add(' attribute12 :'||l_rec.attribute12);
1188 add(' attribute13 :'||l_rec.attribute13);
1189 add(' attribute14 :'||l_rec.attribute14);
1190 add(' attribute15 :'||l_rec.attribute15);
1191 END IF;
1192
1193 END dump_txn_instance_rec;
1194
1195 PROCEDURE dump_dest_location_rec(
1196 p_dest_location_rec IN csi_process_txn_grp.dest_location_rec)
1197 IS
1198 l_rec csi_process_txn_grp.dest_location_rec;
1199 BEGIN
1200 l_rec := p_dest_location_rec;
1201
1202 add('dest_location_rec :');
1203 add(' location_type_code :'||l_rec.location_type_code);
1204 add(' location_id :'||l_rec.location_id);
1205 add(' inv_organization_id :'||l_rec.inv_organization_id);
1206 add(' inv_subinventory_name :'||l_rec.inv_subinventory_name);
1207 add(' inv_locator_id :'||l_rec.inv_locator_id);
1208 add(' pa_project_id :'||l_rec.pa_project_id);
1209 add(' pa_project_task_id :'||l_rec.pa_project_task_id);
1210 add(' in_transit_order_line_id :'||l_rec.in_transit_order_line_id);
1211 add(' wip_job_id :'||l_rec.wip_job_id);
1212 add(' po_order_line_id :'||l_rec.po_order_line_id);
1213 END dump_dest_location_rec;
1214
1215 PROCEDURE dump_txn_i_party_rec(
1216 p_txn_i_party_rec IN csi_process_txn_grp.txn_i_party_rec)
1217 IS
1218 l_rec csi_process_txn_grp.txn_i_party_rec;
1219 BEGIN
1220
1221 l_rec := p_txn_i_party_rec;
1222 add('txn_i_party_rec :');
1223 add(' instance_party_id :'||l_rec.instance_party_id);
1224 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1225 add(' instance_id :'||l_rec.instance_id);
1226 add(' party_source_table :'||l_rec.party_source_table);
1227 add(' party_id :'||l_rec.party_id);
1228 add(' relationship_type_code :'||l_rec.relationship_type_code);
1229 add(' contact_flag :'||l_rec.contact_flag);
1230 add(' contact_ip_id :'||l_rec.contact_ip_id);
1231 add(' active_start_date :'||l_rec.active_start_date);
1232 add(' active_end_date :'||l_rec.active_end_date);
1233 add(' object_version_number :'||l_rec.object_version_number);
1234
1235 IF g_debug_level > 25 THEN
1236 add(' context :'||l_rec.context);
1237 add(' attribute1 :'||l_rec.attribute1);
1238 add(' attribute2 :'||l_rec.attribute2);
1239 add(' attribute3 :'||l_rec.attribute3);
1240 add(' attribute4 :'||l_rec.attribute4);
1241 add(' attribute5 :'||l_rec.attribute5);
1242 add(' attribute6 :'||l_rec.attribute6);
1243 add(' attribute7 :'||l_rec.attribute7);
1244 add(' attribute8 :'||l_rec.attribute8);
1245 add(' attribute9 :'||l_rec.attribute9);
1246 add(' attribute10 :'||l_rec.attribute10);
1247 add(' attribute11 :'||l_rec.attribute11);
1248 add(' attribute12 :'||l_rec.attribute12);
1249 add(' attribute13 :'||l_rec.attribute13);
1250 add(' attribute14 :'||l_rec.attribute14);
1251 add(' attribute15 :'||l_rec.attribute15);
1252 END IF;
1253
1254 END dump_txn_i_party_rec;
1255
1256 PROCEDURE dump_txn_ip_account_rec(
1257 p_txn_ip_account_rec IN csi_process_txn_grp.txn_ip_account_rec)
1258 IS
1259 l_rec csi_process_txn_grp.txn_ip_account_rec;
1260 BEGIN
1261
1262 l_rec := p_txn_ip_account_rec;
1263
1264 add('txn_ip_account_rec :');
1265 add(' ip_account_id :'||l_rec.ip_account_id);
1266 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1267 add(' instance_party_id :'||l_rec.instance_party_id);
1268 add(' party_account_id :'||l_rec.party_account_id);
1269 add(' relationship_type_code :'||l_rec.relationship_type_code);
1270 add(' bill_to_address :'||l_rec.bill_to_address);
1271 add(' ship_to_address :'||l_rec.ship_to_address);
1272 add(' active_start_date :'||l_rec.active_start_date);
1273 add(' active_end_date :'||l_rec.active_end_date);
1274 add(' object_version_number :'||l_rec.object_version_number);
1275
1276 IF g_debug_level > 25 THEN
1277 add(' context :'||l_rec.context);
1278 add(' attribute1 :'||l_rec.attribute1);
1279 add(' attribute2 :'||l_rec.attribute2);
1280 add(' attribute3 :'||l_rec.attribute3);
1281 add(' attribute4 :'||l_rec.attribute4);
1282 add(' attribute5 :'||l_rec.attribute5);
1283 add(' attribute6 :'||l_rec.attribute6);
1284 add(' attribute7 :'||l_rec.attribute7);
1285 add(' attribute8 :'||l_rec.attribute8);
1286 add(' attribute9 :'||l_rec.attribute9);
1287 add(' attribute10 :'||l_rec.attribute10);
1288 add(' attribute11 :'||l_rec.attribute11);
1289 add(' attribute12 :'||l_rec.attribute12);
1290 add(' attribute13 :'||l_rec.attribute13);
1291 add(' attribute14 :'||l_rec.attribute14);
1292 add(' attribute15 :'||l_rec.attribute15);
1293 END IF;
1294
1295 END dump_txn_ip_account_rec;
1296
1297 PROCEDURE dump_txn_ii_rltns_rec(
1298 p_txn_ii_rltns_rec IN csi_process_txn_grp.txn_ii_relationship_rec)
1299 IS
1300 l_rec csi_process_txn_grp.txn_ii_relationship_rec;
1301 BEGIN
1302
1303 l_rec := p_txn_ii_rltns_rec;
1304
1305 add('txn_ii_relationship_rec :');
1306 add(' relationship_id :'||l_rec.relationship_id);
1307 add(' relationship_type_code :'||l_rec.relationship_type_code);
1308 add(' object_index :'||l_rec.object_index);
1309 add(' object_id :'||l_rec.object_id);
1310 add(' subject_index :'||l_rec.subject_index);
1311 add(' subject_id :'||l_rec.subject_id);
1312 add(' subject_has_child :'||l_rec.subject_has_child);
1313 add(' position_reference :'||l_rec.position_reference);
1314 add(' active_start_date :'||l_rec.active_start_date);
1315 add(' active_end_date :'||l_rec.active_end_date);
1316 add(' display_order :'||l_rec.display_order);
1317 add(' mandatory_flag :'||l_rec.mandatory_flag);
1318 add(' object_version_number :'||l_rec.object_version_number);
1319
1320 IF g_debug_level > 25 THEN
1321 add(' context :'||l_rec.context);
1322 add(' attribute1 :'||l_rec.attribute1);
1323 add(' attribute2 :'||l_rec.attribute2);
1324 add(' attribute3 :'||l_rec.attribute3);
1325 add(' attribute4 :'||l_rec.attribute4);
1326 add(' attribute5 :'||l_rec.attribute5);
1327 add(' attribute6 :'||l_rec.attribute6);
1328 add(' attribute7 :'||l_rec.attribute7);
1329 add(' attribute8 :'||l_rec.attribute8);
1330 add(' attribute9 :'||l_rec.attribute9);
1331 add(' attribute10 :'||l_rec.attribute10);
1332 add(' attribute11 :'||l_rec.attribute11);
1333 add(' attribute12 :'||l_rec.attribute12);
1334 add(' attribute13 :'||l_rec.attribute13);
1335 add(' attribute14 :'||l_rec.attribute14);
1336 add(' attribute15 :'||l_rec.attribute15);
1337 END IF;
1338
1339 END dump_txn_ii_rltns_rec;
1340
1341 PROCEDURE dump_txn_eav_rec(
1342 p_txn_eav_rec IN csi_process_txn_grp.txn_ext_attrib_value_rec)
1343 IS
1344 l_rec csi_process_txn_grp.txn_ext_attrib_value_rec;
1345 BEGIN
1346
1347 l_rec := p_txn_eav_rec;
1348
1349 add('txn_ext_attrib_value_rec :');
1350 add(' attribute_value_id :'||l_rec.attribute_value_id);
1351 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1352 add(' instance_id :'||l_rec.instance_id);
1353 add(' attribute_id :'||l_rec.attribute_id);
1354 add(' attribute_code :'||l_rec.attribute_code);
1355 add(' attribute_value :'||l_rec.attribute_value);
1356 add(' active_start_date :'||l_rec.active_start_date);
1357 add(' active_end_date :'||l_rec.active_end_date);
1358 add(' object_version_number :'||l_rec.object_version_number);
1359
1360 IF g_debug_level > 25 THEN
1361 add(' context :'||l_rec.context);
1362 add(' attribute1 :'||l_rec.attribute1);
1363 add(' attribute2 :'||l_rec.attribute2);
1364 add(' attribute3 :'||l_rec.attribute3);
1365 add(' attribute4 :'||l_rec.attribute4);
1366 add(' attribute5 :'||l_rec.attribute5);
1367 add(' attribute6 :'||l_rec.attribute6);
1368 add(' attribute7 :'||l_rec.attribute7);
1369 add(' attribute8 :'||l_rec.attribute8);
1370 add(' attribute9 :'||l_rec.attribute9);
1371 add(' attribute10 :'||l_rec.attribute10);
1372 add(' attribute11 :'||l_rec.attribute11);
1373 add(' attribute12 :'||l_rec.attribute12);
1374 add(' attribute13 :'||l_rec.attribute13);
1375 add(' attribute14 :'||l_rec.attribute14);
1376 add(' attribute15 :'||l_rec.attribute15);
1377 END IF;
1378
1379 END dump_txn_eav_rec;
1380
1381 PROCEDURE dump_txn_price_rec(
1382 p_txn_price_rec IN csi_process_txn_grp.txn_pricing_attrib_rec)
1383 IS
1384 l_rec csi_process_txn_grp.txn_pricing_attrib_rec;
1385 BEGIN
1386
1387 l_rec := p_txn_price_rec;
1388
1389 add('txn_pricing_attrib_rec :');
1390 add(' pricing_attribute_id :'||l_rec.pricing_attribute_id);
1391 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1392 add(' instance_id :'||l_rec.instance_id);
1393 add(' active_start_date :'||l_rec.active_start_date);
1394 add(' active_end_date :'||l_rec.active_end_date);
1395 add(' pricing_context :'||l_rec.pricing_context);
1396 add(' pricing_attribute1 :'||l_rec.pricing_attribute1);
1397 add(' pricing_attribute2 :'||l_rec.pricing_attribute2);
1398 add(' pricing_attribute3 :'||l_rec.pricing_attribute3);
1399 add(' pricing_attribute4 :'||l_rec.pricing_attribute4);
1400 add(' pricing_attribute5 :'||l_rec.pricing_attribute5);
1401
1402 IF g_debug_level > 15 THEN
1403 add(' pricing_attribute6 :'||l_rec.pricing_attribute6);
1404 add(' pricing_attribute7 :'||l_rec.pricing_attribute7);
1405 add(' pricing_attribute8 :'||l_rec.pricing_attribute8);
1406 add(' pricing_attribute9 :'||l_rec.pricing_attribute9);
1407 add(' pricing_attribute10 :'||l_rec.pricing_attribute10);
1408 add(' pricing_attribute11 :'||l_rec.pricing_attribute11);
1409 add(' pricing_attribute12 :'||l_rec.pricing_attribute12);
1410 add(' pricing_attribute13 :'||l_rec.pricing_attribute13);
1411 add(' pricing_attribute14 :'||l_rec.pricing_attribute14);
1412 add(' pricing_attribute15 :'||l_rec.pricing_attribute15);
1413 add(' object_version_number :'||l_rec.object_version_number);
1414 END IF;
1415
1416 IF g_debug_level > 25 THEN
1417 add(' pricing_attribute16 :'||l_rec.pricing_attribute16);
1418 add(' pricing_attribute17 :'||l_rec.pricing_attribute17);
1419 add(' pricing_attribute18 :'||l_rec.pricing_attribute18);
1420 add(' pricing_attribute19 :'||l_rec.pricing_attribute19);
1421 add(' pricing_attribute20 :'||l_rec.pricing_attribute20);
1422 add(' pricing_attribute21 :'||l_rec.pricing_attribute21);
1423 add(' pricing_attribute22 :'||l_rec.pricing_attribute22);
1424 add(' pricing_attribute23 :'||l_rec.pricing_attribute23);
1425 add(' pricing_attribute24 :'||l_rec.pricing_attribute24);
1426 add(' pricing_attribute25 :'||l_rec.pricing_attribute25);
1427 add(' pricing_attribute26 :'||l_rec.pricing_attribute26);
1428 add(' pricing_attribute27 :'||l_rec.pricing_attribute27);
1429 add(' pricing_attribute28 :'||l_rec.pricing_attribute28);
1430 add(' pricing_attribute29 :'||l_rec.pricing_attribute29);
1431 add(' pricing_attribute30 :'||l_rec.pricing_attribute30);
1432 add(' pricing_attribute31 :'||l_rec.pricing_attribute31);
1433 add(' pricing_attribute32 :'||l_rec.pricing_attribute32);
1434 add(' pricing_attribute33 :'||l_rec.pricing_attribute33);
1435 add(' pricing_attribute34 :'||l_rec.pricing_attribute34);
1436 add(' pricing_attribute35 :'||l_rec.pricing_attribute35);
1437 add(' pricing_attribute36 :'||l_rec.pricing_attribute36);
1438 add(' pricing_attribute37 :'||l_rec.pricing_attribute37);
1439 add(' pricing_attribute38 :'||l_rec.pricing_attribute38);
1440 add(' pricing_attribute39 :'||l_rec.pricing_attribute39);
1441 add(' pricing_attribute40 :'||l_rec.pricing_attribute40);
1442 add(' pricing_attribute41 :'||l_rec.pricing_attribute41);
1443 add(' pricing_attribute42 :'||l_rec.pricing_attribute42);
1444 add(' pricing_attribute43 :'||l_rec.pricing_attribute43);
1445 add(' pricing_attribute44 :'||l_rec.pricing_attribute44);
1446 add(' pricing_attribute45 :'||l_rec.pricing_attribute45);
1447 add(' pricing_attribute46 :'||l_rec.pricing_attribute46);
1448 add(' pricing_attribute47 :'||l_rec.pricing_attribute47);
1449 add(' pricing_attribute48 :'||l_rec.pricing_attribute48);
1450 add(' pricing_attribute49 :'||l_rec.pricing_attribute49);
1451 add(' pricing_attribute50 :'||l_rec.pricing_attribute50);
1452 add(' pricing_attribute51 :'||l_rec.pricing_attribute51);
1453 add(' pricing_attribute52 :'||l_rec.pricing_attribute52);
1454 add(' pricing_attribute53 :'||l_rec.pricing_attribute53);
1455 add(' pricing_attribute54 :'||l_rec.pricing_attribute54);
1456 add(' pricing_attribute55 :'||l_rec.pricing_attribute55);
1457 add(' pricing_attribute56 :'||l_rec.pricing_attribute56);
1458 add(' pricing_attribute57 :'||l_rec.pricing_attribute57);
1459 add(' pricing_attribute58 :'||l_rec.pricing_attribute58);
1460 add(' pricing_attribute59 :'||l_rec.pricing_attribute59);
1461 add(' pricing_attribute60 :'||l_rec.pricing_attribute60);
1462 add(' pricing_attribute61 :'||l_rec.pricing_attribute61);
1463 add(' pricing_attribute62 :'||l_rec.pricing_attribute62);
1464 add(' pricing_attribute63 :'||l_rec.pricing_attribute63);
1465 add(' pricing_attribute64 :'||l_rec.pricing_attribute64);
1466 add(' pricing_attribute65 :'||l_rec.pricing_attribute65);
1467 add(' pricing_attribute66 :'||l_rec.pricing_attribute66);
1468 add(' pricing_attribute67 :'||l_rec.pricing_attribute67);
1469 add(' pricing_attribute68 :'||l_rec.pricing_attribute68);
1470 add(' pricing_attribute69 :'||l_rec.pricing_attribute69);
1471 add(' pricing_attribute70 :'||l_rec.pricing_attribute70);
1472 add(' pricing_attribute71 :'||l_rec.pricing_attribute71);
1473 add(' pricing_attribute72 :'||l_rec.pricing_attribute72);
1474 add(' pricing_attribute73 :'||l_rec.pricing_attribute73);
1475 add(' pricing_attribute74 :'||l_rec.pricing_attribute74);
1476 add(' pricing_attribute75 :'||l_rec.pricing_attribute75);
1477 add(' pricing_attribute76 :'||l_rec.pricing_attribute76);
1478 add(' pricing_attribute77 :'||l_rec.pricing_attribute77);
1479 add(' pricing_attribute78 :'||l_rec.pricing_attribute78);
1480 add(' pricing_attribute79 :'||l_rec.pricing_attribute79);
1481 add(' pricing_attribute80 :'||l_rec.pricing_attribute80);
1482 add(' pricing_attribute81 :'||l_rec.pricing_attribute81);
1483 add(' pricing_attribute82 :'||l_rec.pricing_attribute82);
1484 add(' pricing_attribute83 :'||l_rec.pricing_attribute83);
1485 add(' pricing_attribute84 :'||l_rec.pricing_attribute84);
1486 add(' pricing_attribute85 :'||l_rec.pricing_attribute85);
1487 add(' pricing_attribute86 :'||l_rec.pricing_attribute86);
1488 add(' pricing_attribute87 :'||l_rec.pricing_attribute87);
1489 add(' pricing_attribute88 :'||l_rec.pricing_attribute88);
1490 add(' pricing_attribute89 :'||l_rec.pricing_attribute89);
1491 add(' pricing_attribute90 :'||l_rec.pricing_attribute90);
1492 add(' pricing_attribute91 :'||l_rec.pricing_attribute91);
1493 add(' pricing_attribute92 :'||l_rec.pricing_attribute92);
1494 add(' pricing_attribute93 :'||l_rec.pricing_attribute93);
1495 add(' pricing_attribute94 :'||l_rec.pricing_attribute94);
1496 add(' pricing_attribute95 :'||l_rec.pricing_attribute95);
1497 add(' pricing_attribute96 :'||l_rec.pricing_attribute96);
1498 add(' pricing_attribute97 :'||l_rec.pricing_attribute97);
1499 add(' pricing_attribute98 :'||l_rec.pricing_attribute98);
1500 add(' pricing_attribute99 :'||l_rec.pricing_attribute99);
1501 add(' pricing_attribute100 :'||l_rec.pricing_attribute100);
1502 add(' context :'||l_rec.context);
1503 add(' attribute1 :'||l_rec.attribute1);
1504 add(' attribute2 :'||l_rec.attribute2);
1505 add(' attribute3 :'||l_rec.attribute3);
1506 add(' attribute4 :'||l_rec.attribute4);
1507 add(' attribute5 :'||l_rec.attribute5);
1508 add(' attribute6 :'||l_rec.attribute6);
1509 add(' attribute7 :'||l_rec.attribute7);
1510 add(' attribute8 :'||l_rec.attribute8);
1511 add(' attribute9 :'||l_rec.attribute9);
1512 add(' attribute10 :'||l_rec.attribute10);
1513 add(' attribute11 :'||l_rec.attribute11);
1514 add(' attribute12 :'||l_rec.attribute12);
1515 add(' attribute13 :'||l_rec.attribute13);
1516 add(' attribute14 :'||l_rec.attribute14);
1517 add(' attribute15 :'||l_rec.attribute15);
1518 END IF;
1519
1520 END dump_txn_price_rec;
1521
1522 PROCEDURE dump_txn_org_unit_rec(
1523 p_txn_org_unit_rec IN csi_process_txn_grp.txn_org_unit_rec)
1524 IS
1525 l_rec csi_process_txn_grp.txn_org_unit_rec;
1526 BEGIN
1527
1528 l_rec := p_txn_org_unit_rec;
1529
1530 add('txn_org_unit_rec :');
1531 add(' instance_ou_id :'||l_rec.instance_ou_id);
1532 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1533 add(' instance_id :'||l_rec.instance_id);
1534 add(' operating_unit_id :'||l_rec.operating_unit_id);
1535 add(' relationship_type_code :'||l_rec.relationship_type_code);
1536 add(' active_start_date :'||l_rec.active_start_date);
1537 add(' active_end_date :'||l_rec.active_end_date);
1538 add(' object_version_number :'||l_rec.object_version_number);
1539
1540 IF g_debug_level > 25 THEN
1541 add(' context :'||l_rec.context);
1542 add(' attribute1 :'||l_rec.attribute1);
1543 add(' attribute2 :'||l_rec.attribute2);
1544 add(' attribute3 :'||l_rec.attribute3);
1545 add(' attribute4 :'||l_rec.attribute4);
1546 add(' attribute5 :'||l_rec.attribute5);
1547 add(' attribute6 :'||l_rec.attribute6);
1548 add(' attribute7 :'||l_rec.attribute7);
1549 add(' attribute8 :'||l_rec.attribute8);
1550 add(' attribute9 :'||l_rec.attribute9);
1551 add(' attribute10 :'||l_rec.attribute10);
1552 add(' attribute11 :'||l_rec.attribute11);
1553 add(' attribute12 :'||l_rec.attribute12);
1554 add(' attribute13 :'||l_rec.attribute13);
1555 add(' attribute14 :'||l_rec.attribute14);
1556 add(' attribute15 :'||l_rec.attribute15);
1557 END IF;
1558
1559 END dump_txn_org_unit_rec;
1560
1561 PROCEDURE dump_txn_asset_rec(
1562 p_txn_asset_rec IN csi_process_txn_grp.txn_instance_asset_rec)
1563 IS
1564 l_rec csi_process_txn_grp.txn_instance_asset_rec;
1565 BEGIN
1566
1567 l_rec := p_txn_asset_rec;
1568
1569 add('txn_instance_asset_rec :');
1570 add(' instance_asset_id :'||l_rec.instance_asset_id);
1571 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1572 add(' instance_id :'||l_rec.instance_id);
1573 add(' fa_asset_id :'||l_rec.fa_asset_id);
1574 add(' fa_book_type_code :'||l_rec.fa_book_type_code);
1575 add(' fa_location_id :'||l_rec.fa_location_id);
1576 add(' asset_quantity :'||l_rec.asset_quantity);
1577 add(' update_status :'||l_rec.update_status);
1578 add(' active_start_date :'||l_rec.active_start_date);
1579 add(' active_end_date :'||l_rec.active_end_date);
1580 add(' object_version_number :'||l_rec.object_version_number);
1581
1582 END dump_txn_asset_rec;
1583
1584 PROCEDURE dump_instance_query_rec(
1585 p_instance_query_rec IN csi_datastructures_pub.instance_query_rec)
1586 IS
1587 l_rec csi_datastructures_pub.instance_query_rec;
1588 BEGIN
1589 l_rec := p_instance_query_rec;
1590
1591 add('csi_datastructures_pub.instance_query_rec :');
1592 add(' instance_id :'||l_rec.instance_id);
1593 add(' inventory_item_id :'||l_rec.inventory_item_id);
1594 add(' inventory_revision :'||l_rec.inventory_revision);
1595 add(' serial_number :'||l_rec.serial_number);
1596 add(' lot_number :'||l_rec.lot_number);
1597 add(' unit_of_measure :'||l_rec.unit_of_measure);
1598 add(' location_type_code :'||l_rec.location_type_code);
1599 add(' location_id :'||l_rec.location_id);
1600 add(' inv_organization_id :'||l_rec.inv_organization_id);
1601 add(' inv_subinventory_name :'||l_rec.inv_subinventory_name);
1602 add(' inv_locator_id :'||l_rec.inv_locator_id);
1603 add(' instance_usage_code :'||l_rec.instance_usage_code);
1604 add(' in_transit_order_line_id :'||l_rec.in_transit_order_line_id);
1605 add(' wip_job_id :'||l_rec.wip_job_id);
1606 add(' last_oe_order_line_id :'||l_rec.last_oe_order_line_id);
1607 add(' last_oe_rma_line_id :'||l_rec.last_oe_rma_line_id);
1608 add(' last_wip_job_id :'||l_rec.last_wip_job_id);
1609
1610 IF g_debug_level > 10 THEN
1611 add(' instance_status_id :'||l_rec.instance_status_id);
1612 add(' instance_condition_id :'||l_rec.instance_condition_id);
1613 add(' instance_type_code :'||l_rec.instance_type_code);
1614 add(' master_organization_id :'||l_rec.inv_master_organization_id);
1615 add(' system_id :'||l_rec.system_id);
1616 add(' query_units_only :'||l_rec.query_units_only);
1617 add(' return_by_date :'||l_rec.return_by_date);
1618 add(' actual_return_date :'||l_rec.actual_return_date);
1619 add(' install_date :'||l_rec.install_date);
1620 add(' last_po_po_line_id :'||l_rec.last_po_po_line_id);
1621 add(' last_oe_po_number :'||l_rec.last_oe_po_number);
1622 add(' last_oe_agreement_id :'||l_rec.last_oe_agreement_id);
1623 add(' manually_created_flag :'||l_rec.manually_created_flag);
1624 add(' po_order_line_id :'||l_rec.po_order_line_id);
1625 add(' pa_project_id :'||l_rec.pa_project_id);
1626 add(' pa_project_task_id :'||l_rec.pa_project_task_id);
1627 add(' last_pa_project_id :'||l_rec.last_pa_project_id);
1628 add(' last_pa_task_id :'||l_rec.last_pa_task_id);
1629 END IF;
1630 END dump_instance_query_rec;
1631
1632 PROCEDURE dump_csi_party_rec(
1633 p_party_rec csi_datastructures_pub.party_rec)
1634 IS
1635 l_rec csi_datastructures_pub.party_rec;
1636 BEGIN
1637 l_rec := p_party_rec;
1638
1639 add('csi_datastructures_pub.party_rec :');
1640 add(' instance_party_id :'||l_rec.instance_party_id);
1641 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1642 add(' instance_id :'||l_rec.instance_id);
1643
1644 IF g_debug_level > 5 THEN
1645 add(' party_source_table :'||l_rec.party_source_table);
1646 add(' party_id :'||l_rec.party_id);
1647 add(' relationship_type_code :'||l_rec.relationship_type_code);
1648 add(' contact_flag :'||l_rec.contact_flag);
1649 add(' contact_ip_id :'||l_rec.contact_ip_id);
1650 add(' contact_parent_tbl_index :'||l_rec.contact_parent_tbl_index);
1651 add(' active_start_date :'||l_rec.active_start_date);
1652 add(' active_end_date :'||l_rec.active_end_date);
1653 add(' call_contracts :'||l_rec.call_contracts);
1654 END IF;
1655
1656 IF g_debug_level > 25 THEN
1657
1658 add(' context :'||l_rec.context);
1659 add(' attribute1 :'||l_rec.attribute1);
1660 add(' attribute2 :'||l_rec.attribute2);
1661 add(' attribute3 :'||l_rec.attribute3);
1662 add(' attribute4 :'||l_rec.attribute4);
1663 add(' attribute5 :'||l_rec.attribute5);
1664 add(' attribute6 :'||l_rec.attribute6);
1665 add(' attribute7 :'||l_rec.attribute7);
1666 add(' attribute8 :'||l_rec.attribute8);
1667 add(' attribute9 :'||l_rec.attribute9);
1668 add(' attribute10 :'||l_rec.attribute10);
1669 add(' attribute11 :'||l_rec.attribute11);
1670 add(' attribute12 :'||l_rec.attribute12);
1671 add(' attribute13 :'||l_rec.attribute13);
1672 add(' attribute14 :'||l_rec.attribute14);
1673 add(' attribute15 :'||l_rec.attribute15);
1674 add(' object_version_number :'||l_rec.object_version_number);
1675 add(' primary_flag :'||l_rec.primary_flag);
1676 add(' preferred_flag :'||l_rec.preferred_flag);
1677 add(' interface_id :'||l_rec.interface_id);
1678
1679 END IF;
1680
1681 END dump_csi_party_rec;
1682
1683 PROCEDURE dump_csi_party_tbl(
1684 p_party_tbl csi_datastructures_pub.party_tbl)
1685 IS
1686 BEGIN
1687 IF p_party_tbl.COUNT > 0 THEN
1688 FOR l_ind IN p_party_tbl.FIRST .. p_party_tbl.LAST
1689 LOOP
1690 add('dump party_tbl. record # '||l_ind);
1691 dump_csi_party_rec(p_party_tbl(l_ind));
1692 END LOOP;
1693 END IF;
1694 END dump_csi_party_tbl;
1695
1696 PROCEDURE dump_csi_account_rec(
1697 p_party_account_rec IN csi_datastructures_pub.party_account_rec)
1698 IS
1699 l_rec csi_datastructures_pub.party_account_rec;
1700 BEGIN
1701
1702 l_rec := p_party_account_rec;
1703
1704 add('csi_datastructures_pub.party_account_rec :');
1705 add(' ip_account_id :'||l_rec.ip_account_id);
1706 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1707 add(' instance_party_id :'||l_rec.instance_party_id);
1708 add(' party_account_id :'||l_rec.party_account_id);
1709 add(' relationship_type_code :'||l_rec.relationship_type_code);
1710 add(' bill_to_address :'||l_rec.bill_to_address);
1711 add(' ship_to_address :'||l_rec.ship_to_address);
1712 add(' call_contracts :'||l_rec.call_contracts);
1713 add(' active_start_date :'||l_rec.active_start_date);
1714 add(' active_end_date :'||l_rec.active_end_date);
1715
1716 IF g_debug_level > 25 THEN
1717
1718 add(' context :'||l_rec.context);
1719 add(' attribute1 :'||l_rec.attribute1);
1720 add(' attribute2 :'||l_rec.attribute2);
1721 add(' attribute3 :'||l_rec.attribute3);
1722 add(' attribute4 :'||l_rec.attribute4);
1723 add(' attribute5 :'||l_rec.attribute5);
1724 add(' attribute6 :'||l_rec.attribute6);
1725 add(' attribute7 :'||l_rec.attribute7);
1726 add(' attribute8 :'||l_rec.attribute8);
1727 add(' attribute9 :'||l_rec.attribute9);
1728 add(' attribute10 :'||l_rec.attribute10);
1729 add(' attribute11 :'||l_rec.attribute11);
1730 add(' attribute12 :'||l_rec.attribute12);
1731 add(' attribute13 :'||l_rec.attribute13);
1732 add(' attribute14 :'||l_rec.attribute14);
1733 add(' attribute15 :'||l_rec.attribute15);
1734 add(' object_version_number :'||l_rec.object_version_number);
1735 add(' vld_organization_id :'||l_rec.vld_organization_id);
1736 add(' expire_flag :'||l_rec.expire_flag);
1737 add(' grp_call_contracts :'||l_rec.grp_call_contracts);
1738
1739 END IF;
1740
1741 end dump_csi_account_rec;
1742
1743 PROCEDURE dump_csi_account_tbl(
1744 p_party_account_tbl IN csi_datastructures_pub.party_account_tbl)
1745 IS
1746 BEGIN
1747 IF p_party_account_tbl.COUNT > 0 THEN
1748 FOR l_ind IN p_party_account_tbl.FIRST .. p_party_account_tbl.LAST
1749 LOOP
1750 add('dump party_account_tbl. record # '||l_ind);
1751 dump_csi_account_rec(p_party_account_tbl(l_ind));
1752 END LOOP;
1753 END IF;
1754 END dump_csi_account_tbl;
1755
1756 PROCEDURE dump_eav_rec(
1757 p_eav_rec IN csi_datastructures_pub.extend_attrib_values_rec)
1758 IS
1759 l_rec csi_datastructures_pub.extend_attrib_values_rec;
1760 BEGIN
1761 l_rec := p_eav_rec;
1762
1763 add('csi_datastructures_pub.extend_attrib_values_rec :');
1764 add(' attribute_value_id :'||l_rec.attribute_value_id);
1765 add(' instance_id :'||l_rec.instance_id);
1766 add(' attribute_id :'||l_rec.attribute_id);
1767 add(' attribute_code :'||l_rec.attribute_code);
1768 add(' attribute_value :'||l_rec.attribute_value);
1769 add(' active_start_date :'||l_rec.active_start_date);
1770 add(' active_end_date :'||l_rec.active_end_date);
1771 END dump_eav_rec;
1772
1773 PROCEDURE dump_eav_tbl(
1774 p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl)
1775 IS
1776 BEGIN
1777 IF p_eav_tbl.count > 0 THEN
1778 FOR l_ind IN p_eav_tbl.FIRST .. p_eav_tbl.LAST
1779 LOOP
1780 add('dump extend_attrib_values_tbl. record # '||l_ind);
1781 dump_eav_rec(p_eav_tbl(l_ind));
1782 END LOOP;
1783 END IF;
1784 END dump_eav_tbl;
1785
1786 PROCEDURE dump_csi_ii_rltns_rec(
1787 p_ii_rltns_rec IN csi_datastructures_pub.ii_relationship_rec,
1788 p_rec_index IN number)
1789 IS
1790 l_rec csi_datastructures_pub.ii_relationship_rec;
1791 BEGIN
1792
1793 l_rec := p_ii_rltns_rec;
1794
1795 add('csi_datastructures_pub.ii_relationship_rec : record # :'||p_rec_index);
1796
1797 add(' relationship_id :'||l_rec.relationship_id);
1798 add(' subject_id :'||l_rec.subject_id);
1799 add(' relationship_type_code :'||l_rec.relationship_type_code);
1800 add(' object_id :'||l_rec.object_id);
1801 add(' active_start_date :'||l_rec.active_start_date);
1802 add(' active_end_date :'||l_rec.active_end_date);
1803
1804 IF g_debug_level > 15 THEN
1805 add(' subject_has_child :'||l_rec.subject_has_child);
1806 add(' position_reference :'||l_rec.position_reference);
1807 add(' display_order :'||l_rec.display_order);
1808 add(' mandatory_flag :'||l_rec.mandatory_flag);
1809 END IF;
1810
1811 IF g_debug_level > 25 THEN
1812 add(' context :'||l_rec.context);
1813 add(' attribute1 :'||l_rec.attribute1);
1814 add(' attribute2 :'||l_rec.attribute2);
1815 add(' attribute3 :'||l_rec.attribute3);
1816 add(' attribute4 :'||l_rec.attribute4);
1817 add(' attribute5 :'||l_rec.attribute5);
1818 add(' attribute6 :'||l_rec.attribute6);
1819 add(' attribute7 :'||l_rec.attribute7);
1820 add(' attribute8 :'||l_rec.attribute8);
1821 add(' attribute9 :'||l_rec.attribute9);
1822 add(' attribute10 :'||l_rec.attribute10);
1823 add(' attribute11 :'||l_rec.attribute11);
1824 add(' attribute12 :'||l_rec.attribute12);
1825 add(' attribute13 :'||l_rec.attribute13);
1826 add(' attribute14 :'||l_rec.attribute14);
1827 add(' attribute15 :'||l_rec.attribute15);
1828 add(' object_version_number :'||l_rec.object_version_number);
1829 add(' parent_tbl_index :'||l_rec.parent_tbl_index);
1830 add(' processed_flag :'||l_rec.processed_flag);
1831 add(' interface_id :'||l_rec.interface_id);
1832 END IF;
1833
1834 END dump_csi_ii_rltns_rec;
1835
1836 PROCEDURE dump_csi_ii_rltns_tbl(
1837 p_ii_rltns_tbl IN csi_datastructures_pub.ii_relationship_tbl)
1838 IS
1839 BEGIN
1840 IF p_ii_rltns_tbl.COUNT > 0 THEN
1841 FOR l_ind IN p_ii_rltns_tbl.FIRST .. p_ii_rltns_tbl.LAST
1842 LOOP
1843 dump_csi_ii_rltns_rec(p_ii_rltns_tbl(l_ind), l_ind);
1844 END LOOP;
1845 END IF;
1846 END dump_csi_ii_rltns_tbl;
1847
1848 PROCEDURE dump_csi_config_rec(
1849 p_config_rec IN csi_cz_int.config_rec)
1850 IS
1851 l_rec csi_cz_int.config_rec;
1852 BEGIN
1853 l_rec := p_config_rec;
1854
1855 add('csi_cz_int.config_rec :');
1856 add('config_inst_hdr_id :'||l_rec.config_inst_hdr_id);
1857 add('config_inst_item_id :'||l_rec.config_inst_item_id);
1858 add('config_inst_rev_num :'||l_rec.config_inst_rev_num);
1859 add('lock_status :'||l_rec.lock_status);
1860 IF g_debug_level > 10 THEN
1861 add('source_application_id :'||l_rec.source_application_id);
1862 add('source_txn_header_ref :'||l_rec.source_txn_header_ref);
1863 add('source_txn_line_ref1 :'||l_rec.source_txn_line_ref1);
1864 add('source_txn_line_ref2 :'||l_rec.source_txn_line_ref2);
1865 add('source_txn_line_ref3 :'||l_rec.source_txn_line_ref3);
1866 add('instance_id :'||l_rec.instance_id);
1867 add('lock_id :'||l_rec.lock_id);
1868 END IF;
1869 END dump_csi_config_rec;
1870
1871 PROCEDURE dump_csi_config_tbl(
1872 p_config_tbl IN csi_cz_int.config_tbl)
1873 IS
1874 BEGIN
1875 IF p_config_tbl.count > 0 THEN
1876 FOR l_ind IN p_config_tbl.FIRST .. p_config_tbl.LAST
1877 LOOP
1878 add('dump config_tbl. record # '||l_ind);
1879 dump_csi_config_rec(p_config_tbl(l_ind));
1880 END LOOP;
1881 END IF;
1882 END dump_csi_config_tbl;
1883
1884 PROCEDURE dump_mass_edit_rec(
1885 p_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec)
1886 IS
1887 l_rec csi_mass_edit_pub.mass_edit_rec;
1888 BEGIN
1889 l_rec := p_mass_edit_rec;
1890 add('csi_mass_edit_pub.mass_edit_rec :');
1891 add(' entry_id :'||l_rec.entry_id);
1892 add(' name :'||l_rec.name);
1893 add(' status_code :'||l_rec.status_code);
1894 add(' batch_type :'||l_rec.batch_type);
1895 add(' txn_line_id :'||l_rec.txn_line_id);
1896 add(' txn_line_detail_id :'||l_rec.txn_line_detail_id);
1897 add(' description :'||l_rec.description);
1898 add(' schedule_date :'||l_rec.schedule_date);
1899 add(' start_date :'||l_rec.start_date);
1900 add(' end_date :'||l_rec.end_date);
1901 add(' object_version_number :'||l_rec.object_version_number);
1902 add(' system_cascade :'||l_rec.system_cascade);
1903
1904 END dump_mass_edit_rec;
1905
1906 END csi_t_gen_utility_pvt;