[Home] [Help]
153: ,P_LANGUAGE_CODE in varchar2 default null) is
154: blid number := p_data_pump_batch_line_id;
155: begin
156: if blid is not null then
157: delete from hr_pump_batch_lines where batch_line_id = blid;
158: delete from hr_pump_batch_exceptions
159: where source_type = 'BATCH_LINE' and source_id = blid;
160: end if;
161: insert into hr_pump_batch_lines
157: delete from hr_pump_batch_lines where batch_line_id = blid;
158: delete from hr_pump_batch_exceptions
159: where source_type = 'BATCH_LINE' and source_id = blid;
160: end if;
161: insert into hr_pump_batch_lines
162: (batch_id
163: ,batch_line_id
164: ,business_group_name
165: ,api_module_id
236: ,pval072
237: ,pval073)
238: values
239: (p_batch_id
240: ,nvl(blid,hr_pump_batch_lines_s.nextval)
241: ,p_data_pump_business_grp_name
242: ,2195
243: ,'U'
244: ,p_user_sequence
458: decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
459: l.pval072 d72,
460: decode(l.pval073,cn,vn,vn,vh,l.pval073) p73,
461: l.pval073 d73
462: from hr_pump_batch_lines l
463: where l.batch_line_id = p_batch_line_id;
464: --
465: c cr%rowtype;
466: l_validate boolean := false;
473: open cr;
474: fetch cr into c;
475: if cr%notfound then
476: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
477: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
478: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
479: hr_utility.set_message_token('VALUE',p_batch_line_id);
480: hr_utility.raise_error;
481: end if;
585: ,P_EFFECTIVE_END_DATE => c.p69);
586: hr_data_pump.api_trc_off;
587:
588: --
589: update hr_pump_batch_lines l set
590: l.pval066 = decode(c.p66,null,cn,c.p66),
591: l.pval067 = decode(c.p67,null,cn,c.p67),
592: l.pval068 = decode(c.p68,null,cn,dc(c.p68)),
593: l.pval069 = decode(c.p69,null,cn,dc(c.p69))