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