[Home] [Help]
178: ,P_LANGUAGE_CODE in varchar2 default null) is
179: blid number := p_data_pump_batch_line_id;
180: begin
181: if blid is not null then
182: delete from hr_pump_batch_lines where batch_line_id = blid;
183: delete from hr_pump_batch_exceptions
184: where source_type = 'BATCH_LINE' and source_id = blid;
185: end if;
186: insert into hr_pump_batch_lines
182: delete from hr_pump_batch_lines where batch_line_id = blid;
183: delete from hr_pump_batch_exceptions
184: where source_type = 'BATCH_LINE' and source_id = blid;
185: end if;
186: insert into hr_pump_batch_lines
187: (batch_id
188: ,batch_line_id
189: ,business_group_name
190: ,api_module_id
286: ,pval097
287: ,pval098)
288: values
289: (p_batch_id
290: ,nvl(blid,hr_pump_batch_lines_s.nextval)
291: ,p_data_pump_business_grp_name
292: ,1146
293: ,'U'
294: ,p_user_sequence
583: decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
584: l.pval097 d97,
585: decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
586: l.pval098 d98
587: from hr_pump_batch_lines l
588: where l.batch_line_id = p_batch_line_id;
589: --
590: c cr%rowtype;
591: l_validate boolean := false;
598: open cr;
599: fetch cr into c;
600: if cr%notfound then
601: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
602: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
603: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
604: hr_utility.set_message_token('VALUE',p_batch_line_id);
605: hr_utility.raise_error;
606: end if;
735: ,P_EFFECTIVE_END_DATE => c.p94);
736: hr_data_pump.api_trc_off;
737:
738: --
739: update hr_pump_batch_lines l set
740: l.pval091 = decode(c.p91,null,cn,c.p91),
741: l.pval092 = decode(c.p92,null,cn,c.p92),
742: l.pval093 = decode(c.p93,null,cn,dc(c.p93)),
743: l.pval094 = decode(c.p94,null,cn,dc(c.p94))