DBA Data[Home] [Help]

APPS.OKC_K_RENEW_ASMBLR_PVT dependencies on OKC_AQ_PVT

Line 29: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

25:
26: l_api_name CONSTANT VARCHAR2(30) := 'acn_assemble';
27: l_api_version CONSTANT NUMBER := 1.0;
28: i NUMBER := 1;
29: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
30: l_msg_tbl okc_aq_pvt.msg_tab_typ;
31: l_msg_count number;
32: l_msg_data varchar2(1000);
33: l_return_status varchar2(1);

Line 30: l_msg_tbl okc_aq_pvt.msg_tab_typ;

26: l_api_name CONSTANT VARCHAR2(30) := 'acn_assemble';
27: l_api_version CONSTANT NUMBER := 1.0;
28: i NUMBER := 1;
29: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
30: l_msg_tbl okc_aq_pvt.msg_tab_typ;
31: l_msg_count number;
32: l_msg_data varchar2(1000);
33: l_return_status varchar2(1);
34:

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

58: -- check if action is enabled
59: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN
60:
61:
62: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
63: FOR corr_rec IN cur_corr_csr
64: LOOP
65:
66: IF corr_rec.element_name = 'K_CLASS' THEN

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

152: ,x_msg_data => l_msg_data
153: ,x_return_status => l_return_status
154: ,p_corrid_rec => l_corrid_rec
155: ,p_msg_tab => l_msg_tbl
156: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
157:
158: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN