APPS.OKC_K_STS_CHG_ASMBLR_PVT dependencies on OKC_AQ_PVT

Line 27: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

23:
24: l_api_name CONSTANT VARCHAR2(30) := 'acn_assemble';
25: l_api_version CONSTANT NUMBER := 1.0;
26: i NUMBER := 1;
27: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
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);

Line 28: l_msg_tbl okc_aq_pvt.msg_tab_typ;

24: l_api_name CONSTANT VARCHAR2(30) := 'acn_assemble';
25: l_api_version CONSTANT NUMBER := 1.0;
26: i NUMBER := 1;
27: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
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;

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

90:
91: l_corrid_rec.corrid := 'K_STS_CHANGE' ;
92: -- check if action is enabled
93: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN
94: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
95: FOR corr_rec IN cur_corr_csr
96: LOOP
97:
98: IF corr_rec.element_name = 'K_CUR_STS_CODE' THEN

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

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

Line 204: l_corrid_rec okc_aq_pvt.corrid_rec_typ;

200:
201: l_api_name CONSTANT VARCHAR2(30) := 'acn_assemble';
202: l_api_version CONSTANT NUMBER := 1.0;
203: i NUMBER := 1;
204: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
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);

Line 205: l_msg_tbl okc_aq_pvt.msg_tab_typ;

201: l_api_name CONSTANT VARCHAR2(30) := 'acn_assemble';
202: l_api_version CONSTANT NUMBER := 1.0;
203: i NUMBER := 1;
204: l_corrid_rec okc_aq_pvt.corrid_rec_typ;
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;

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

271: l_corrid_rec.corrid := 'K_STS_CHANGE' ;
272: -- check if action is enabled
273: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN
274:
275: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
276: FOR corr_rec IN cur_corr_csr
277: LOOP
278:
279: IF corr_rec.element_name = 'K_CUR_STS_CODE' THEN

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

321: ,x_msg_data => l_msg_data
322: ,x_return_status => l_return_status
323: ,p_corrid_rec => l_corrid_rec
324: ,p_msg_tab => l_msg_tbl
325: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
326:
327: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
329: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN