APPS.IEM_TEXT_PVT dependencies on IEM_INTENT_DTLS

Line 188: cursor c_query is select keyword,weight from iem_intent_dtls

184: is
185: l_kw_tbl iem_text_pvt.keyword_Rec_tbl;
186: l_theme_enabled varchar2(1);
187: l_count number:=1;
188: cursor c_query is select keyword,weight from iem_intent_dtls
189: where intent_id=p_intent_id
190: and query_Response='Q';
191: cursor c_resp is select keyword,weight from iem_intent_dtls
192: where intent_id=p_intent_id

Line 191: cursor c_resp is select keyword,weight from iem_intent_dtls

187: l_count number:=1;
188: cursor c_query is select keyword,weight from iem_intent_dtls
189: where intent_id=p_intent_id
190: and query_Response='Q';
191: cursor c_resp is select keyword,weight from iem_intent_dtls
192: where intent_id=p_intent_id
193: and query_Response='R';
194: l_flag number;
195: begin

Line 406: select keyword,weight from iem_intent_dtls where intent_id=p_intent_id

402: END IEM_PROCESS_PARTS;
403: PROCEDURE RETRIEVE_DOC(p_intent_id in varchar2,
404: x_status out nocopy varchar2) IS
405: cursor c1 is
406: select keyword,weight from iem_intent_dtls where intent_id=p_intent_id
407: and query_response='R';
408: l_imt_string varchar2(32767):=' ';
409: l_return_status VARCHAR2(20);
410: l_msg_count NUMBER;