DBA Data[Home] [Help]

APPS.JTF_IH_IEC_PVT dependencies on DUAL

Line 65: SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;

61:
62: for L in 1..P_COUNT
63: Loop
64:
65: SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;
66: -- dbms_output.put_line('Media ID Returned: ' || to_char(l_media_id));
67:
68: INSERT INTO jtf_ih_media_items
69: (

Line 141: l_media_id_stmt := l_media_id_stmt || ' from dual order by 1';

137: if( L <> l_media_id_tab.count )then
138: l_media_id_stmt := l_media_id_stmt ||',';
139: end if;
140: end loop;
141: l_media_id_stmt := l_media_id_stmt || ' from dual order by 1';
142:
143: -- dbms_output.put_line('Cursor statement construction complete');
144: -- dbms_output.put_line('statement length = ' || to_char(length(l_media_id_stmt)));
145: