DBA Data[Home] [Help]

APPS.OKC_AQ_WRITE_ERROR_PVT dependencies on OKC_AQ_PVT

Line 15: p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,

11: PROCEDURE WRITE_MSGDATA(p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 ,
13: p_source_name IN VARCHAR2,
14: p_datetime IN DATE,
15: p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,
16: p_q_name IN VARCHAR2 ,
17: p_corrid IN VARCHAR2,
18: p_msgid IN RAW ,
19: p_message_name IN VARCHAR2 ,

Line 150: OKC_AQ_PVT.stop_listener;

146: END IF;
147: IF l_commit = 'T' THEN
148: IF proc_notfound <> 0 THEN
149: -- if ORA-06508 is found in the msg stack stop the listeners
150: OKC_AQ_PVT.stop_listener;
151: END IF;
152: commit;
153: END IF;
154: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 229: PROCEDURE get_clob_msg(p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,

225: BEGIN
226: NULL;
227: END DELETE_ERROR;
228:
229: PROCEDURE get_clob_msg(p_msg_tab IN OKC_AQ_PVT.msg_tab_typ,
230: p_q_name IN VARCHAR2,
231: p_corrid IN VARCHAR2,
232: p_msg_clob OUT NOCOPY CLOB,
233: x_return_status OUT NOCOPY VARCHAR2,