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