[Home] [Help]
123: ,P_LANGUAGE_CODE in varchar2 default null) is
124: blid number := p_data_pump_batch_line_id;
125: begin
126: if blid is not null then
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
132: (batch_id
133: ,batch_line_id
134: ,business_group_name
135: ,api_module_id
176: ,pval042
177: ,pval043)
178: values
179: (p_batch_id
180: ,nvl(blid,hr_pump_batch_lines_s.nextval)
181: ,p_data_pump_business_grp_name
182: ,2214
183: ,'U'
184: ,p_user_sequence
310: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
311: l.pval042 d42,
312: decode(l.pval043,cn,vn,vn,vh,l.pval043) p43,
313: l.pval043 d43
314: from hr_pump_batch_lines l
315: where l.batch_line_id = p_batch_line_id;
316: --
317: c cr%rowtype;
318: l_validate boolean := false;
325: open cr;
326: fetch cr into c;
327: if cr%notfound then
328: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
329: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
330: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
331: hr_utility.set_message_token('VALUE',p_batch_line_id);
332: hr_utility.raise_error;
333: end if;
407: ,P_EFFECTIVE_END_DATE => c.p39);
408: hr_data_pump.api_trc_off;
409:
410: --
411: update hr_pump_batch_lines l set
412: l.pval036 = decode(c.p36,null,cn,c.p36),
413: l.pval037 = decode(c.p37,null,cn,c.p37),
414: l.pval038 = decode(c.p38,null,cn,dc(c.p38)),
415: l.pval039 = decode(c.p39,null,cn,dc(c.p39))