15:
16: TYPE txn_cascade_tbl IS TABLE OF txn_cascade_rec INDEX BY binary_integer;
17:
18: PROCEDURE build_instance_id_list(
19: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
20: x_instance_id_list OUT NOCOPY varchar2,
21: x_return_status OUT NOCOPY varchar2);
22:
23: PROCEDURE build_txn_line_id_list(
20: x_instance_id_list OUT NOCOPY varchar2,
21: x_return_status OUT NOCOPY varchar2);
22:
23: PROCEDURE build_txn_line_id_list(
24: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
25: x_txn_line_id_list OUT NOCOPY varchar2,
26: x_return_status OUT NOCOPY varchar2);
27:
28: PROCEDURE build_party_dtl_id_list(
25: x_txn_line_id_list OUT NOCOPY varchar2,
26: x_return_status OUT NOCOPY varchar2);
27:
28: PROCEDURE build_party_dtl_id_list(
29: p_txn_party_detial_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
30: x_party_dtl_id_list OUT NOCOPY varchar2,
31: x_return_status OUT NOCOPY varchar2);
32:
33: PROCEDURE build_line_dtl_id_list(
30: x_party_dtl_id_list OUT NOCOPY varchar2,
31: x_return_status OUT NOCOPY varchar2);
32:
33: PROCEDURE build_line_dtl_id_list(
34: p_txn_line_detial_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
35: x_line_dtl_id_list OUT NOCOPY varchar2,
36: x_return_status OUT NOCOPY varchar2);
37:
38: PROCEDURE build_txn_system_id_list(
35: x_line_dtl_id_list OUT NOCOPY varchar2,
36: x_return_status OUT NOCOPY varchar2);
37:
38: PROCEDURE build_txn_system_id_list(
39: p_txn_line_detial_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
40: x_txn_system_id_list OUT NOCOPY varchar2,
41: x_return_status OUT NOCOPY varchar2);
42:
43: PROCEDURE merge_tables(
40: x_txn_system_id_list OUT NOCOPY varchar2,
41: x_return_status OUT NOCOPY varchar2);
42:
43: PROCEDURE merge_tables(
44: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
45: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
41: x_return_status OUT NOCOPY varchar2);
42:
43: PROCEDURE merge_tables(
44: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
45: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
42:
43: PROCEDURE merge_tables(
44: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
45: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
43: PROCEDURE merge_tables(
44: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
45: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
44: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
45: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
45: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
46: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
48: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
49: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
51: --
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59:
52: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59:
60: PROCEDURE convert_ids_to_index(
53: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59:
60: PROCEDURE convert_ids_to_index(
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
54: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59:
60: PROCEDURE convert_ids_to_index(
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
57: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59:
60: PROCEDURE convert_ids_to_index(
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
58: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59:
60: PROCEDURE convert_ids_to_index(
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
59:
60: PROCEDURE convert_ids_to_index(
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
67: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl);
60: PROCEDURE convert_ids_to_index(
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
67: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl);
68:
61: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
67: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl);
68:
69: PROCEDURE get_source_dtls(
62: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
67: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl);
68:
69: PROCEDURE get_source_dtls(
70: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
63: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
67: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl);
68:
69: PROCEDURE get_source_dtls(
70: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
71: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
68:
69: PROCEDURE get_source_dtls(
70: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
71: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
72: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
73: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
74: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
75: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
76: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
69: PROCEDURE get_source_dtls(
70: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
71: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
72: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
73: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
74: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
75: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
76: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
77: x_return_status OUT NOCOPY varchar2);
70: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
71: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
72: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
73: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
74: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
75: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
76: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
77: x_return_status OUT NOCOPY varchar2);
78:
71: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
72: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
73: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
74: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
75: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
76: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
77: x_return_status OUT NOCOPY varchar2);
78:
79: PROCEDURE cascade_child(
72: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
73: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
74: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
75: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
76: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
77: x_return_status OUT NOCOPY varchar2);
78:
79: PROCEDURE cascade_child(
80: p_data_string IN varchar2,