134: ,P_PERSON_EXTRA_INFO_USER_KEY in varchar2) is
135: blid number := p_data_pump_batch_line_id;
136: begin
137: if blid is not null then
138: delete from hr_pump_batch_lines where batch_line_id = blid;
139: delete from hr_pump_batch_exceptions
140: where source_type = 'BATCH_LINE' and source_id = blid;
141: end if;
142: insert into hr_pump_batch_lines
138: delete from hr_pump_batch_lines where batch_line_id = blid;
139: delete from hr_pump_batch_exceptions
140: where source_type = 'BATCH_LINE' and source_id = blid;
141: end if;
142: insert into hr_pump_batch_lines
143: (batch_id
144: ,batch_line_id
145: ,business_group_name
146: ,api_module_id
201: ,pval052
202: ,pval053)
203: values
204: (p_batch_id
205: ,nvl(blid,hr_pump_batch_lines_s.nextval)
206: ,p_data_pump_business_grp_name
207: ,1227
208: ,'U'
209: ,p_user_sequence
372: l.pval051 d51,
373: decode(l.pval052,cn,vn,vn,vh,l.pval052) p52,
374: l.pval052 d52,
375: decode(l.pval053,cn,vn,l.pval053) p53
376: from hr_pump_batch_lines l
377: where l.batch_line_id = p_batch_line_id;
378: --
379: c cr%rowtype;
380: l_validate boolean := false;
386: open cr;
387: fetch cr into c;
388: if cr%notfound then
389: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
390: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
391: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
392: hr_utility.set_message_token('VALUE',p_batch_line_id);
393: hr_utility.raise_error;
394: end if;