DBA Data[Home] [Help]

APPS.OKC_CHG_REJ_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 55: l_msg_tbl := okc_aq_pvt.msg_tab_typ();

51: END IF;
52: l_corrid_rec.corrid := 'CH_REJECT' ;
53: -- check if action is enabled
54: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN
55: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
56: FOR corr_rec IN cur_corr_csr
57: LOOP
58:
59: IF corr_rec.element_name = 'CHANGE_ID' THEN

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

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