[Home] [Help]
154: ,P_LANGUAGE_CODE in varchar2 default null) is
155: blid number := p_data_pump_batch_line_id;
156: begin
157: if blid is not null then
158: delete from hr_pump_batch_lines where batch_line_id = blid;
159: delete from hr_pump_batch_exceptions
160: where source_type = 'BATCH_LINE' and source_id = blid;
161: end if;
162: insert into hr_pump_batch_lines
158: delete from hr_pump_batch_lines where batch_line_id = blid;
159: delete from hr_pump_batch_exceptions
160: where source_type = 'BATCH_LINE' and source_id = blid;
161: end if;
162: insert into hr_pump_batch_lines
163: (batch_id
164: ,batch_line_id
165: ,business_group_name
166: ,api_module_id
241: ,pval077
242: ,pval078)
243: values
244: (p_batch_id
245: ,nvl(blid,hr_pump_batch_lines_s.nextval)
246: ,p_data_pump_business_grp_name
247: ,1386
248: ,'U'
249: ,p_user_sequence
472: decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
473: l.pval077 d77,
474: decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
475: l.pval078 d78
476: from hr_pump_batch_lines l
477: where l.batch_line_id = p_batch_line_id;
478: --
479: c cr%rowtype;
480: l_validate boolean := false;
489: open cr;
490: fetch cr into c;
491: if cr%notfound then
492: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
493: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
494: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
495: hr_utility.set_message_token('VALUE',p_batch_line_id);
496: hr_utility.raise_error;
497: end if;
612: hr_data_pump.api_trc_off;
613: --
614: iuk(p_batch_line_id,c.p67,L_PERSONAL_PAYMENT_METHOD_ID);
615: --
616: update hr_pump_batch_lines l set
617: l.pval067 = decode(c.p67,null,cn,c.p67),
618: l.pval068 = decode(c.p68,null,cn,c.p68),
619: l.pval069 = decode(c.p69,null,cn,c.p69),
620: l.pval070 = decode(c.p70,null,cn,dc(c.p70)),