DBA Data[Home] [Help]

APPS.OZF_DENORM_QUERIES_PVT dependencies on OZF_DENORM_QUERIES_S

Line 41: SELECT ozf_denorm_queries_s.NEXTVAL

37: l_string varchar2(32000):= l_denorm_queries_rec.SQL_STATEMENT;
38: l_denorm_count NUMBER;
39:
40: CURSOR c_denorm_queries_seq IS
41: SELECT ozf_denorm_queries_s.NEXTVAL
42: FROM DUAL;
43:
44:
45: CURSOR c_denorm_count(denorm_id IN NUMBER) IS

Line 307: UPDATE ozf_denorm_queries SET

303: string_length_check(temp_denorm_queries_rec.SQL_STATEMENT,l_stringArray);
304:
305:
306:
307: UPDATE ozf_denorm_queries SET
308: last_update_date = SYSDATE,
309: last_updated_by = FND_GLOBAL.user_id,
310: last_update_login = FND_GLOBAL.conc_login_id,
311: active_flag = nvl(temp_denorm_queries_rec.active_flag,'N'),