DBA Data[Home] [Help]

APPS.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_AQ_PUB

Line 27: --l_corrid_rec okc_aq_pub.corrid_rec_typ;

23: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
24: k NUMBER;
25: l_last_rundate DATE;
26: l_variance okc_condition_headers_b.cnh_variance%TYPE;
27: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
28: l_msg_tbl okc_aq_pub.msg_tab_typ;
29: l_element_name okc_action_attributes_b.element_name%TYPE;
30: l_element_value VARCHAR2(100);
31: l_acn_id NUMBER;

Line 28: l_msg_tbl okc_aq_pub.msg_tab_typ;

24: k NUMBER;
25: l_last_rundate DATE;
26: l_variance okc_condition_headers_b.cnh_variance%TYPE;
27: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
28: l_msg_tbl okc_aq_pub.msg_tab_typ;
29: l_element_name okc_action_attributes_b.element_name%TYPE;
30: l_element_value VARCHAR2(100);
31: l_acn_id NUMBER;
32:

Line 188: /* OKC_AQ_PUB.send_message(p_api_version =>1.0

184: END IF;
185: END LOOP;
186: -- call OKC_AQ_PVT.send_messages to generate the XML string and put it
187: -- on the queue
188: /* OKC_AQ_PUB.send_message(p_api_version =>1.0
189: ,p_init_msg_list => 'F'
190: ,x_msg_count => x_msg_count
191: ,x_msg_data => x_msg_data
192: ,x_return_status => l_return_status

Line 291: --l_corrid_rec okc_aq_pub.corrid_rec_typ;

287: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
288: k NUMBER;
289: l_last_rundate DATE;
290: l_variance okc_condition_headers_b.cnh_variance%TYPE;
291: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
292: l_msg_tbl okc_aq_pub.msg_tab_typ;
293: l_element_name okc_action_attributes_b.element_name%TYPE;
294: l_element_value VARCHAR2(100);
295: l_acn_id NUMBER;

Line 292: l_msg_tbl okc_aq_pub.msg_tab_typ;

288: k NUMBER;
289: l_last_rundate DATE;
290: l_variance okc_condition_headers_b.cnh_variance%TYPE;
291: --l_corrid_rec okc_aq_pub.corrid_rec_typ;
292: l_msg_tbl okc_aq_pub.msg_tab_typ;
293: l_element_name okc_action_attributes_b.element_name%TYPE;
294: l_element_value VARCHAR2(100);
295: l_acn_id NUMBER;
296:

Line 470: okc_debug.Log('140: Calling OKC_AQ_PUB.send_message ',2);

466: END IF;
467: END LOOP; -- built the element table for K
468:
469: IF (l_debug = 'Y') THEN
470: okc_debug.Log('140: Calling OKC_AQ_PUB.send_message ',2);
471: END IF;
472:
473: -- call OKC_AQ_PVT.send_messages to generate the XML string and put it
474: -- on the queue

Line 475: /* OKC_AQ_PUB.send_message(p_api_version =>'1.0'

471: END IF;
472:
473: -- call OKC_AQ_PVT.send_messages to generate the XML string and put it
474: -- on the queue
475: /* OKC_AQ_PUB.send_message(p_api_version =>'1.0'
476: ,p_init_msg_list => 'F'
477: ,x_msg_count => x_msg_count
478: ,x_msg_data => x_msg_data
479: ,x_return_status => l_return_status

Line 503: okc_debug.Log('150: Called OKC_AQ_PUB.send_message ',2);

499: p_msg_tab =>l_msg_tbl
500: );
501:
502: IF (l_debug = 'Y') THEN
503: okc_debug.Log('150: Called OKC_AQ_PUB.send_message ',2);
504: okc_debug.Log('160: l_return_status : '||l_return_status,2);
505: END IF;
506:
507: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN