[Home] [Help]
158: ,P_CNT_INFORMATION30 in varchar2 default null) is
159: blid number := p_data_pump_batch_line_id;
160: begin
161: if blid is not null then
162: delete from hr_pump_batch_lines where batch_line_id = blid;
163: delete from hr_pump_batch_exceptions
164: where source_type = 'BATCH_LINE' and source_id = blid;
165: end if;
166: insert into hr_pump_batch_lines
162: delete from hr_pump_batch_lines where batch_line_id = blid;
163: delete from hr_pump_batch_exceptions
164: where source_type = 'BATCH_LINE' and source_id = blid;
165: end if;
166: insert into hr_pump_batch_lines
167: (batch_id
168: ,batch_line_id
169: ,business_group_name
170: ,api_module_id
249: ,pval079
250: ,pval080)
251: values
252: (p_batch_id
253: ,nvl(blid,hr_pump_batch_lines_s.nextval)
254: ,p_data_pump_business_grp_name
255: ,1702
256: ,'U'
257: ,p_user_sequence
489: decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
490: l.pval079 d79,
491: decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
492: l.pval080 d80
493: from hr_pump_batch_lines l
494: where l.batch_line_id = p_batch_line_id;
495: --
496: c cr%rowtype;
497: l_validate boolean := false;
502: open cr;
503: fetch cr into c;
504: if cr%notfound then
505: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
506: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
507: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
508: hr_utility.set_message_token('VALUE',p_batch_line_id);
509: hr_utility.raise_error;
510: end if;
595: hr_data_pump.api_trc_off;
596: --
597: iuk(p_batch_line_id,c.p1,L_EMP_COUNTY_TAX_RULE_ID);
598: --
599: update hr_pump_batch_lines l set
600: l.pval001 = decode(c.p1,null,cn,c.p1),
601: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
602: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
603: l.pval017 = decode(c.p17,null,cn,c.p17)