1882: begin
1883:
1884: hr_utility.set_location('Entering : '||l_proc,10);
1885:
1886: /* Insert the details into HZ_PURGE_BATCHES.
1887: */
1888: hr_utility.set_location(l_proc,30);
1889: select hz_purge_batches_s.nextval
1890: into l_batchid
1885:
1886: /* Insert the details into HZ_PURGE_BATCHES.
1887: */
1888: hr_utility.set_location(l_proc,30);
1889: select hz_purge_batches_s.nextval
1890: into l_batchid
1891: from sys.dual;
1892:
1893: hr_utility.set_location(l_proc,40);
1890: into l_batchid
1891: from sys.dual;
1892:
1893: hr_utility.set_location(l_proc,40);
1894: insert into hz_purge_batches (batch_id,
1895: batch_name,
1896: subset_sql,
1897: creation_date,
1898: created_by,