DBA Data[Home] [Help]

APPS.OKC_CHG_APR_ASMBLR_PVT dependencies on OKC_AQ_PVT

Line 26: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

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

Line 27: l_msg_tbl okc_aq_pvt.msg_tab_typ;

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

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

54:
55: -- check if action is enabled
56: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN
57:
58: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
59: FOR corr_rec IN cur_corr_csr LOOP
60:
61: IF corr_rec.element_name = 'CHAPP_DATE' THEN
62: l_msg_tbl.extend;

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

113: ,x_msg_data => l_msg_data
114: ,x_return_status => l_return_status
115: ,p_corrid_rec => l_corrid_rec
116: ,p_msg_tab => l_msg_tbl
117: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
118:
119: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
120: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN