60: l_return_status VARCHAR2(1);
61: l_msg_count NUMBER;
62: l_msg_data VARCHAR2(2000);
63:
64: l_instance_rec csi_datastructures_pub.instance_rec;
65: l_transaction_rec csi_datastructures_pub.transaction_rec;
66: l_instance_tbl csi_datastructures_pub.instance_tbl;
67: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
68: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
61: l_msg_count NUMBER;
62: l_msg_data VARCHAR2(2000);
63:
64: l_instance_rec csi_datastructures_pub.instance_rec;
65: l_transaction_rec csi_datastructures_pub.transaction_rec;
66: l_instance_tbl csi_datastructures_pub.instance_tbl;
67: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
68: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
69: l_party_site_id rrs_sites_b.site_party_id%TYPE;
62: l_msg_data VARCHAR2(2000);
63:
64: l_instance_rec csi_datastructures_pub.instance_rec;
65: l_transaction_rec csi_datastructures_pub.transaction_rec;
66: l_instance_tbl csi_datastructures_pub.instance_tbl;
67: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
68: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
69: l_party_site_id rrs_sites_b.site_party_id%TYPE;
70:
63:
64: l_instance_rec csi_datastructures_pub.instance_rec;
65: l_transaction_rec csi_datastructures_pub.transaction_rec;
66: l_instance_tbl csi_datastructures_pub.instance_tbl;
67: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
68: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
69: l_party_site_id rrs_sites_b.site_party_id%TYPE;
70:
71:
64: l_instance_rec csi_datastructures_pub.instance_rec;
65: l_transaction_rec csi_datastructures_pub.transaction_rec;
66: l_instance_tbl csi_datastructures_pub.instance_tbl;
67: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
68: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
69: l_party_site_id rrs_sites_b.site_party_id%TYPE;
70:
71:
72: TYPE l_parent_child_ids_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;