DBA Data[Home] [Help]

APPS.CAC_TASK_PURGE_PUB dependencies on DUAL

Line 200: select jtf_object_purge_proc_set_s.nextval into proc_seq_num from dual;

196:
197: If ( l_tab_tasks_id.COUNT > 0) then
198:
199: --inserting data into the global temp table
200: select jtf_object_purge_proc_set_s.nextval into proc_seq_num from dual;
201:
202:
203:
204: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 582: select jtf_object_purge_proc_set_s.nextval into proc_seq_num from dual;

578: END IF;
579:
580: If ( l_tab_tasks_id.COUNT > 0) then
581:
582: select jtf_object_purge_proc_set_s.nextval into proc_seq_num from dual;
583:
584: FORALL i in l_tab_tasks_id.first..l_tab_tasks_id.last
585:
586: Insert into jtf_object_purge_param_tmp p