DBA Data[Home] [Help]

APPS.OKC_SCHR_AD_ASMBLR_PVT dependencies on OKC_AQ_PVT

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

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

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

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

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

136: ,x_msg_data => l_msg_data
137: ,x_return_status => l_return_status
138: ,p_corrid_rec => l_corrid_rec
139: ,p_msg_tab => l_msg_tbl
140: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
141:
142: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
143: commit;
144: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN