[Home] [Help]
124: ,P_LANGUAGE_CODE in varchar2 default null) is
125: blid number := p_data_pump_batch_line_id;
126: begin
127: if blid is not null then
128: delete from hr_pump_batch_lines where batch_line_id = blid;
129: delete from hr_pump_batch_exceptions
130: where source_type = 'BATCH_LINE' and source_id = blid;
131: end if;
132: insert into hr_pump_batch_lines
128: delete from hr_pump_batch_lines where batch_line_id = blid;
129: delete from hr_pump_batch_exceptions
130: where source_type = 'BATCH_LINE' and source_id = blid;
131: end if;
132: insert into hr_pump_batch_lines
133: (batch_id
134: ,batch_line_id
135: ,business_group_name
136: ,api_module_id
178: ,pval043
179: ,pval044)
180: values
181: (p_batch_id
182: ,nvl(blid,hr_pump_batch_lines_s.nextval)
183: ,p_data_pump_business_grp_name
184: ,1387
185: ,'U'
186: ,p_user_sequence
315: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
316: l.pval043 d43,
317: decode(l.pval044,cn,vn,vn,vh,l.pval044) p44,
318: l.pval044 d44
319: from hr_pump_batch_lines l
320: where l.batch_line_id = p_batch_line_id;
321: --
322: c cr%rowtype;
323: l_validate boolean := false;
330: open cr;
331: fetch cr into c;
332: if cr%notfound then
333: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
334: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
335: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
336: hr_utility.set_message_token('VALUE',p_batch_line_id);
337: hr_utility.raise_error;
338: end if;
413: ,P_EFFECTIVE_END_DATE => c.p40);
414: hr_data_pump.api_trc_off;
415:
416: --
417: update hr_pump_batch_lines l set
418: l.pval037 = decode(c.p37,null,cn,c.p37),
419: l.pval038 = decode(c.p38,null,cn,c.p38),
420: l.pval039 = decode(c.p39,null,cn,dc(c.p39)),
421: l.pval040 = decode(c.p40,null,cn,dc(c.p40))