19: WHEN 6 THEN 'REALM_T$'
20: END;
21:
22: l_stmt := 'SELECT COUNT(*) FROM ' || l_tab || ' WHERE id# = :id AND language = :lang';
23: l_cursor := sys.dbms_sql.open_cursor;
24: sys.dbms_sql.parse( l_cursor, l_stmt, sys.dbms_sql.native );
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
20: END;
21:
22: l_stmt := 'SELECT COUNT(*) FROM ' || l_tab || ' WHERE id# = :id AND language = :lang';
23: l_cursor := sys.dbms_sql.open_cursor;
24: sys.dbms_sql.parse( l_cursor, l_stmt, sys.dbms_sql.native );
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
21:
22: l_stmt := 'SELECT COUNT(*) FROM ' || l_tab || ' WHERE id# = :id AND language = :lang';
23: l_cursor := sys.dbms_sql.open_cursor;
24: sys.dbms_sql.parse( l_cursor, l_stmt, sys.dbms_sql.native );
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
22: l_stmt := 'SELECT COUNT(*) FROM ' || l_tab || ' WHERE id# = :id AND language = :lang';
23: l_cursor := sys.dbms_sql.open_cursor;
24: sys.dbms_sql.parse( l_cursor, l_stmt, sys.dbms_sql.native );
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
30: then
23: l_cursor := sys.dbms_sql.open_cursor;
24: sys.dbms_sql.parse( l_cursor, l_stmt, sys.dbms_sql.native );
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
30: then
31: sys.dbms_sql.column_value( l_cursor, 1, l_lcnt );
24: sys.dbms_sql.parse( l_cursor, l_stmt, sys.dbms_sql.native );
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
30: then
31: sys.dbms_sql.column_value( l_cursor, 1, l_lcnt );
32: end if;
25: sys.dbms_sql.bind_variable( l_cursor, ':id', lid );
26: sys.dbms_sql.bind_variable( l_cursor, ':lang', l_lang );
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
30: then
31: sys.dbms_sql.column_value( l_cursor, 1, l_lcnt );
32: end if;
33: sys.dbms_sql.close_cursor(l_cursor);
27: sys.dbms_sql.define_column( l_cursor, 1, l_lcnt );
28: l_status := sys.dbms_sql.execute( l_cursor );
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
30: then
31: sys.dbms_sql.column_value( l_cursor, 1, l_lcnt );
32: end if;
33: sys.dbms_sql.close_cursor(l_cursor);
34:
35: if (l_lcnt = 0) then
29: if ( sys.dbms_sql.fetch_rows(l_cursor) > 0 )
30: then
31: sys.dbms_sql.column_value( l_cursor, 1, l_lcnt );
32: end if;
33: sys.dbms_sql.close_cursor(l_cursor);
34:
35: if (l_lcnt = 0) then
36: return 'us';
37: else