[Home] [Help]
216: ,P_BENEFIT_GROUP in varchar2 default null) is
217: blid number := p_data_pump_batch_line_id;
218: begin
219: if blid is not null then
220: delete from hr_pump_batch_lines where batch_line_id = blid;
221: delete from hr_pump_batch_exceptions
222: where source_type = 'BATCH_LINE' and source_id = blid;
223: end if;
224: insert into hr_pump_batch_lines
220: delete from hr_pump_batch_lines where batch_line_id = blid;
221: delete from hr_pump_batch_exceptions
222: where source_type = 'BATCH_LINE' and source_id = blid;
223: end if;
224: insert into hr_pump_batch_lines
225: (batch_id
226: ,batch_line_id
227: ,business_group_name
228: ,api_module_id
349: ,pval125
350: ,pval126)
351: values
352: (p_batch_id
353: ,nvl(blid,hr_pump_batch_lines_s.nextval)
354: ,p_data_pump_business_grp_name
355: ,3875
356: ,'U'
357: ,p_user_sequence
744: decode(l.pval125,cn,vn,vn,vh,l.pval125) p125,
745: l.pval125 d125,
746: decode(l.pval126,cn,vn,vn,vh,l.pval126) p126,
747: l.pval126 d126
748: from hr_pump_batch_lines l
749: where l.batch_line_id = p_batch_line_id;
750: --
751: c cr%rowtype;
752: l_validate boolean := false;
765: open cr;
766: fetch cr into c;
767: if cr%notfound then
768: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
769: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
770: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
771: hr_utility.set_message_token('VALUE',p_batch_line_id);
772: hr_utility.raise_error;
773: end if;
983: else
984: c.p120 := 'FALSE';
985: end if;
986: --
987: update hr_pump_batch_lines l set
988: l.pval009 = decode(c.p9,null,cn,c.p9),
989: l.pval114 = decode(c.p114,null,cn,dc(c.p114)),
990: l.pval115 = decode(c.p115,null,cn,dc(c.p115)),
991: l.pval116 = decode(c.p116,null,cn,c.p116),