28: l_msg_tbl okc_aq_pvt.msg_tab_typ;
29: l_msg_count number;
30: l_msg_data varchar2(1000);
31: l_return_status varchar2(1);
32: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
33: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
34: l_version VARCHAR2(255); --modified for bug 3007067
35:
36: CURSOR cur_corr_csr IS
29: l_msg_count number;
30: l_msg_data varchar2(1000);
31: l_return_status varchar2(1);
32: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
33: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
34: l_version VARCHAR2(255); --modified for bug 3007067
35:
36: CURSOR cur_corr_csr IS
37: SELECT aae.element_name
205: l_msg_tbl okc_aq_pvt.msg_tab_typ;
206: l_msg_count number;
207: l_msg_data varchar2(1000);
208: l_return_status varchar2(1);
209: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
210: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
211: l_version VARCHAR2(255); --modified for bug 3007067
212:
213: CURSOR cur_corr_csr IS
206: l_msg_count number;
207: l_msg_data varchar2(1000);
208: l_return_status varchar2(1);
209: l_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
210: x_hstv_rec OKC_K_HISTORY_PVT.hstv_rec_type;
211: l_version VARCHAR2(255); --modified for bug 3007067
212:
213: CURSOR cur_corr_csr IS
214: SELECT aae.element_name