[Home] [Help]
163: ,P_BENEFIT_GROUP in varchar2 default null) is
164: blid number := p_data_pump_batch_line_id;
165: begin
166: if blid is not null then
167: delete from hr_pump_batch_lines where batch_line_id = blid;
168: delete from hr_pump_batch_exceptions
169: where source_type = 'BATCH_LINE' and source_id = blid;
170: end if;
171: insert into hr_pump_batch_lines
167: delete from hr_pump_batch_lines where batch_line_id = blid;
168: delete from hr_pump_batch_exceptions
169: where source_type = 'BATCH_LINE' and source_id = blid;
170: end if;
171: insert into hr_pump_batch_lines
172: (batch_id
173: ,batch_line_id
174: ,business_group_name
175: ,api_module_id
259: ,pval088
260: ,pval089)
261: values
262: (p_batch_id
263: ,nvl(blid,hr_pump_batch_lines_s.nextval)
264: ,p_data_pump_business_grp_name
265: ,3872
266: ,'U'
267: ,p_user_sequence
535: decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
536: l.pval088 d88,
537: decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
538: l.pval089 d89
539: from hr_pump_batch_lines l
540: where l.batch_line_id = p_batch_line_id;
541: --
542: c cr%rowtype;
543: l_validate boolean := false;
554: open cr;
555: fetch cr into c;
556: if cr%notfound then
557: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
558: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
559: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
560: hr_utility.set_message_token('VALUE',p_batch_line_id);
561: hr_utility.raise_error;
562: end if;
704: else
705: c.p84 := 'FALSE';
706: end if;
707: --
708: update hr_pump_batch_lines l set
709: l.pval077 = decode(c.p77,null,cn,c.p77),
710: l.pval078 = decode(c.p78,null,cn,c.p78),
711: l.pval079 = decode(c.p79,null,cn,dc(c.p79)),
712: l.pval080 = decode(c.p80,null,cn,dc(c.p80)),