DBA Data[Home] [Help]

APPS.HRDPP_CREATE_SUPPLEMENTARY_ROL dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 141: delete from hr_pump_batch_exceptions

137: blid number := p_data_pump_batch_line_id;
138: begin
139: if blid is not null then
140: delete from hr_pump_batch_lines where batch_line_id = blid;
141: delete from hr_pump_batch_exceptions
142: where source_type = 'BATCH_LINE' and source_id = blid;
143: end if;
144: insert into hr_pump_batch_lines
145: (batch_id