APPS.OKC_CG_UPD_ASMBLR_PVT dependencies on OKC_AQ_PVT

Line 19: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

15: l_api_name CONSTANT VARCHAR2(30) := 'ACN_ASSEMBLE';
16: l_api_version CONSTANT NUMBER := 1.0;
17: l_init_msg_list VARCHAR2(1) ;
18: i NUMBER;
19: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
20: l_msg_tbl okc_aq_pvt.msg_tab_typ;
21: l_msg_count number;
22: l_msg_data varchar2(1000);
23: l_return_status varchar2(1);

Line 20: l_msg_tbl okc_aq_pvt.msg_tab_typ;

16: l_api_version CONSTANT NUMBER := 1.0;
17: l_init_msg_list VARCHAR2(1) ;
18: i NUMBER;
19: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
20: l_msg_tbl okc_aq_pvt.msg_tab_typ;
21: l_msg_count number;
22: l_msg_data varchar2(1000);
23: l_return_status varchar2(1);
24: l_counter_group_id okx_counter_groups_v.counter_group_id%TYPE;

Line 87: l_msg_tbl := okc_aq_pvt.msg_tab_typ();

83: i := 0;
84:
85: -- check if action is enabled
86: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN
87: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
88: FOR ename_rec IN ename_cur
89: LOOP
90: OPEN ctr_grp_cur;
91: FETCH ctr_grp_cur INTO ctr_grp_rec;

Line 146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);

142: ,x_msg_data => l_msg_data
143: ,x_return_status => l_return_status
144: ,p_corrid_rec => l_corrid_rec
145: ,p_msg_tab => l_msg_tbl
146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN