APPS.JTF_FM_QUERY_LINK_PKG dependencies on JTF_FM_QUERY_MES

Line 119: from jtf_fm_query_mes

115: where query_id = p_query_id;
116:
117: CURSOR VALIDATE_UNIQUE(p_query_id NUMBER, p_content_id NUMBER) IS
118: select query_id, mes_doc_id
119: from jtf_fm_query_mes
120: where query_id = p_query_id
121: and mes_doc_id = p_content_id;
122:
123: BEGIN

Line 188: INSERT INTO jtf_fm_query_mes (

184: END IF;
185:
186: CLOSE VALIDATE_QUERY;
187:
188: INSERT INTO jtf_fm_query_mes (
189: mes_doc_id,
190: query_id,
191: LAST_UPDATE_DATE,
192: LAST_UPDATED_BY,

Line 312: from jtf_fm_query_mes

308: where query_id = p_query_id;
309:
310: CURSOR VALIDATE_UNIQUE(p_query_id NUMBER, p_content_id NUMBER) IS
311: select query_id, mes_doc_id
312: from jtf_fm_query_mes
313: where query_id = p_query_id
314: and mes_doc_id = p_content_id;
315:
316: BEGIN

Line 355: DELETE FROM jtf_fm_query_mes

351: NULL;
352: PRINT_MESSAGE('Link does not exist. Unlink_Content_to_query doing nothing.');
353: ELSE
354:
355: DELETE FROM jtf_fm_query_mes
356: WHERE mes_doc_id = p_content_id
357: and query_id = p_query_id;
358:
359: END IF;