133: order by oh.header_id;
134:
135: subscr_ins_rec subscr_ins%rowtype;
136: om_ins_rec om_ins%rowtype;
137: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
139: l_return_status VARCHAR2(2000);
140: l_msg_count NUMBER;
141: l_msg_data VARCHAR2(2000);
134:
135: subscr_ins_rec subscr_ins%rowtype;
136: om_ins_rec om_ins%rowtype;
137: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
138: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
139: l_return_status VARCHAR2(2000);
140: l_msg_count NUMBER;
141: l_msg_data VARCHAR2(2000);
142: i NUMBER:=1;