[Home] [Help]
208: ,P_BENEFIT_GROUP in varchar2 default null) is
209: blid number := p_data_pump_batch_line_id;
210: begin
211: if blid is not null then
212: delete from hr_pump_batch_lines where batch_line_id = blid;
213: delete from hr_pump_batch_exceptions
214: where source_type = 'BATCH_LINE' and source_id = blid;
215: end if;
216: insert into hr_pump_batch_lines
212: delete from hr_pump_batch_lines where batch_line_id = blid;
213: delete from hr_pump_batch_exceptions
214: where source_type = 'BATCH_LINE' and source_id = blid;
215: end if;
216: insert into hr_pump_batch_lines
217: (batch_id
218: ,batch_line_id
219: ,business_group_name
220: ,api_module_id
333: ,pval117
334: ,pval118)
335: values
336: (p_batch_id
337: ,nvl(blid,hr_pump_batch_lines_s.nextval)
338: ,p_data_pump_business_grp_name
339: ,1393
340: ,'U'
341: ,p_user_sequence
702: decode(l.pval117,cn,vn,vn,vh,l.pval117) p117,
703: l.pval117 d117,
704: decode(l.pval118,cn,vn,vn,vh,l.pval118) p118,
705: l.pval118 d118
706: from hr_pump_batch_lines l
707: where l.batch_line_id = p_batch_line_id;
708: --
709: c cr%rowtype;
710: l_validate boolean := false;
723: open cr;
724: fetch cr into c;
725: if cr%notfound then
726: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
727: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
728: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
729: hr_utility.set_message_token('VALUE',p_batch_line_id);
730: hr_utility.raise_error;
731: end if;
933: else
934: c.p112 := 'FALSE';
935: end if;
936: --
937: update hr_pump_batch_lines l set
938: l.pval009 = decode(c.p9,null,cn,c.p9),
939: l.pval106 = decode(c.p106,null,cn,dc(c.p106)),
940: l.pval107 = decode(c.p107,null,cn,dc(c.p107)),
941: l.pval108 = decode(c.p108,null,cn,c.p108),