[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: ,1387
293: ,'U'
294: ,p_user_sequence
585: decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
586: l.pval097 d97,
587: decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
588: l.pval098 d98
589: from hr_pump_batch_lines l
590: where l.batch_line_id = p_batch_line_id;
591: --
592: c cr%rowtype;
593: l_validate boolean := false;
600: open cr;
601: fetch cr into c;
602: if cr%notfound then
603: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
604: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
605: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
606: hr_utility.set_message_token('VALUE',p_batch_line_id);
607: hr_utility.raise_error;
608: end if;
737: ,P_PPM_INFORMATION30 => c.p94);
738: hr_data_pump.api_trc_off;
739:
740: --
741: update hr_pump_batch_lines l set
742: l.pval038 = decode(c.p38,null,cn,c.p38),
743: l.pval039 = decode(c.p39,null,cn,c.p39),
744: l.pval040 = decode(c.p40,null,cn,dc(c.p40)),
745: l.pval041 = decode(c.p41,null,cn,dc(c.p41))