[Home] [Help]
209: ,P_BENEFIT_GROUP in varchar2 default null) is
210: blid number := p_data_pump_batch_line_id;
211: begin
212: if blid is not null then
213: delete from hr_pump_batch_lines where batch_line_id = blid;
214: delete from hr_pump_batch_exceptions
215: where source_type = 'BATCH_LINE' and source_id = blid;
216: end if;
217: insert into hr_pump_batch_lines
213: delete from hr_pump_batch_lines where batch_line_id = blid;
214: delete from hr_pump_batch_exceptions
215: where source_type = 'BATCH_LINE' and source_id = blid;
216: end if;
217: insert into hr_pump_batch_lines
218: (batch_id
219: ,batch_line_id
220: ,business_group_name
221: ,api_module_id
335: ,pval118
336: ,pval119)
337: values
338: (p_batch_id
339: ,nvl(blid,hr_pump_batch_lines_s.nextval)
340: ,p_data_pump_business_grp_name
341: ,1392
342: ,'U'
343: ,p_user_sequence
705: decode(l.pval118,cn,vn,vn,vh,l.pval118) p118,
706: l.pval118 d118,
707: decode(l.pval119,cn,vn,vn,vh,l.pval119) p119,
708: l.pval119 d119
709: from hr_pump_batch_lines l
710: where l.batch_line_id = p_batch_line_id;
711: --
712: c cr%rowtype;
713: l_validate boolean := false;
726: open cr;
727: fetch cr into c;
728: if cr%notfound then
729: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
730: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
731: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
732: hr_utility.set_message_token('VALUE',p_batch_line_id);
733: hr_utility.raise_error;
734: end if;
937: else
938: c.p113 := 'FALSE';
939: end if;
940: --
941: update hr_pump_batch_lines l set
942: l.pval009 = decode(c.p9,null,cn,c.p9),
943: l.pval107 = decode(c.p107,null,cn,dc(c.p107)),
944: l.pval108 = decode(c.p108,null,cn,dc(c.p108)),
945: l.pval109 = decode(c.p109,null,cn,c.p109),