APPS.AST_WEBASSIST_PVT dependencies on AST_WEB_ASSISTS

Line 38: CURSOR c1 IS SELECT 'X' FROM ast_web_assists

34:
35: CURSOR c0 IS SELECT 'X' FROM ast_assists
36: WHERE assist_id = p_assist_rec.assist_id;
37:
38: CURSOR c1 IS SELECT 'X' FROM ast_web_assists
39: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
40:
41: CURSOR c2 IS SELECT 'X' FROM ast_web_searches
42: WHERE search_id = p_web_search_rec.search_id;

Line 161: INSERT INTO ast_web_assists(

157: THEN
158: OPEN c1;
159: FETCH c1 INTO P_DUMMY;
160: IF c1%notfound THEN
161: INSERT INTO ast_web_assists(
162: web_assist_id,
163: assist_id,
164: object_version_number,
165: proxy_host,

Line 579: FROM ast_web_assists

575: DECLARE
576: v_dummy char(1);
577:
578: CURSOR c1 IS SELECT 'X'
579: FROM ast_web_assists
580: WHERE web_assist_id = p_web_assist_rec.web_assist_id
581: FOR UPDATE;
582: BEGIN
583: OPEN c1;

Line 787: UPDATE ast_web_assists

783: -- Initialize API return status to success
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: -- API body
787: UPDATE ast_web_assists
788: SET
789: proxy_host = p_web_assist_rec.proxy_host,
790: proxy_port = p_web_assist_rec.proxy_port,
791: last_update_date = p_web_assist_rec.last_update_date,

Line 1059: DELETE FROM ast_web_assists

1055: WHERE search_id = p_web_search_rec.search_id;
1056: END IF;
1057:
1058: IF p_web_assist_rec.web_assist_id IS NOT NULL THEN
1059: DELETE FROM ast_web_assists
1060: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
1061: END IF;
1062:
1063: