APPS.IEX_WEBDIR_PKG dependencies on IEX_WEB_ASSISTS

Line 34: CURSOR c1 IS SELECT 'X' FROM IEX_WEB_ASSISTS

30: l_return_status VARCHAR2(1);
31: l_msg_count NUMBER;
32: l_msg_data VARCHAR2(32767);
33:
34: CURSOR c1 IS SELECT 'X' FROM IEX_WEB_ASSISTS
35: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
36:
37: CURSOR c2 IS SELECT 'X' FROM IEX_WEB_SEARCHES
38: WHERE search_id = p_web_search_rec.search_id;

Line 75: INSERT INTO IEX_WEB_ASSISTS(

71: THEN
72: OPEN c1;
73: FETCH c1 INTO P_DUMMY;
74: IF c1%notfound THEN
75: INSERT INTO IEX_WEB_ASSISTS(
76: web_assist_id,
77: assist_id,
78: object_version_number,
79: proxy_host,

Line 368: FROM IEX_WEB_assists

364: DECLARE
365: v_dummy char(1);
366:
367: CURSOR c1 IS SELECT 'X'
368: FROM IEX_WEB_assists
369: WHERE web_assist_id = p_web_assist_rec.web_assist_id
370: FOR UPDATE;
371: BEGIN
372: OPEN c1;

Line 494: UPDATE IEX_WEB_assists

490: -- Initialize API return status to success
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: -- API body
494: UPDATE IEX_WEB_assists
495: SET
496: proxy_host = p_web_assist_rec.proxy_host,
497: proxy_port = p_web_assist_rec.proxy_port,
498: last_update_date = p_web_assist_rec.last_update_date,

Line 686: DELETE FROM IEX_WEB_assists

682: WHERE search_id = p_web_search_rec.search_id;
683: END IF;
684:
685: IF p_web_assist_rec.web_assist_id IS NOT NULL THEN
686: DELETE FROM IEX_WEB_assists
687: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
688: END IF;
689:
690: