APPS.IEM_THEMES_PVT dependencies on DUAL

Line 60: FROM dual;

56:
57: IF l_cnt=0 THEN
58: SELECT iem_themes_s1.nextval
59: INTO l_seq_id
60: FROM dual;
61: INSERT INTO iem_themes (theme_id,
62: classification_id,
63: theme,
64: score,

Line 374: from dual;

370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: select replace (replace ( replace (p_theme, '<', ''), '>', ''), '"', '''') into l_theme
374: from dual;
375:
376: l_theme2 := rtrim(ltrim(l_theme, ' '), ' ');
377:
378: -- Take this out. Handle duplicates in the exception block.

Line 505: from dual;

501:
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: select replace (replace ( replace (p_theme, '<', ''), '>', ''), '"', '''') into l_theme
505: from dual;
506:
507: l_theme2 := rtrim(ltrim(l_theme, ' '), ' ');
508:
509: -- Take this out. Handle duplicates in the exception block.

Line 842: from dual;

838: -- Initialize API return status to SUCCESS
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841: select replace (replace ( replace (p_theme, '<', ''), '>', ''), '"', '''') into l_theme
842: from dual;
843:
844: l_theme2 := rtrim(ltrim(l_theme, ' '), ' ');
845:
846: -- kbeagle 12-29-00 Added 'and NOT theme_id=p_theme_id' fix for bug 1339163

Line 974: FROM dual;

970: where classification_id=p_classification_id;
971: IF l_cnt=1 THEN
972: SELECT iem_themes_s1.nextval
973: INTO l_seq_id
974: FROM dual;
975: INSERT INTO iem_themes (theme_id,
976: classification_id,
977: theme,
978: score,