DBA Data[Home] [Help]

APPS.OKC_SCHR_PD_ASMBLR_PVT dependencies on OKC_AQ_PVT

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

73: FOR rule_rec in rul_cur(p_rtve_id => p_rtv_id) LOOP
74: FOR k1_rec in chr_csr(p_chr_id => rule_rec.dnz_chr_id) LOOP
75: k := 1;
76: --Initialize the table
77: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
78: FOR elements_rec IN elements_csr LOOP
79: --Build the elements table
80: IF elements_rec.element_name = 'K_ID' THEN
81: l_msg_tbl.extend;

Line 129: -- call OKC_AQ_PVT.send_messages to generate the XML string and put it

125: END IF;
126: k := k + 1;
127: END LOOP;
128:
129: -- call OKC_AQ_PVT.send_messages to generate the XML string and put it
130: -- on the queue
131: OKC_AQ_PUB.send_message(p_api_version =>1.0
132: ,p_init_msg_list => 'F'
133: ,x_msg_count => l_msg_count

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

134: ,x_msg_data => l_msg_data
135: ,x_return_status => l_return_status
136: ,p_corrid_rec => l_corrid_rec
137: ,p_msg_tab => l_msg_tbl
138: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
139:
140: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN