186: ,P_BENEFIT_GROUP in varchar2 default null) is
187: blid number := p_data_pump_batch_line_id;
188: begin
189: if blid is not null then
190: delete from hr_pump_batch_lines where batch_line_id = blid;
191: delete from hr_pump_batch_exceptions
192: where source_type = 'BATCH_LINE' and source_id = blid;
193: end if;
194: insert into hr_pump_batch_lines
190: delete from hr_pump_batch_lines where batch_line_id = blid;
191: delete from hr_pump_batch_exceptions
192: where source_type = 'BATCH_LINE' and source_id = blid;
193: end if;
194: insert into hr_pump_batch_lines
195: (batch_id
196: ,batch_line_id
197: ,business_group_name
198: ,api_module_id
292: ,pval098
293: ,pval099)
294: values
295: (p_batch_id
296: ,nvl(blid,hr_pump_batch_lines_s.nextval)
297: ,p_data_pump_business_grp_name
298: ,2166
299: ,'U'
300: ,p_user_sequence
598: decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
599: l.pval098 d98,
600: decode(l.pval099,cn,vn,vn,vh,l.pval099) p99,
601: l.pval099 d99
602: from hr_pump_batch_lines l
603: where l.batch_line_id = p_batch_line_id;
604: --
605: c cr%rowtype;
606: l_validate boolean := false;
619: open cr;
620: fetch cr into c;
621: if cr%notfound then
622: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
623: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
624: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
625: hr_utility.set_message_token('VALUE',p_batch_line_id);
626: hr_utility.raise_error;
627: end if;
810: else
811: c.p93 := 'FALSE';
812: end if;
813: --
814: update hr_pump_batch_lines l set
815: l.pval009 = decode(c.p9,null,cn,c.p9),
816: l.pval087 = decode(c.p87,null,cn,dc(c.p87)),
817: l.pval088 = decode(c.p88,null,cn,dc(c.p88)),
818: l.pval089 = decode(c.p89,null,cn,c.p89),