110: ,P_ISSUING_COUNTRY in varchar2 default null) is
111: blid number := p_data_pump_batch_line_id;
112: begin
113: if blid is not null then
114: delete from hr_pump_batch_lines where batch_line_id = blid;
115: delete from hr_pump_batch_exceptions
116: where source_type = 'BATCH_LINE' and source_id = blid;
117: end if;
118: insert into hr_pump_batch_lines
114: delete from hr_pump_batch_lines where batch_line_id = blid;
115: delete from hr_pump_batch_exceptions
116: where source_type = 'BATCH_LINE' and source_id = blid;
117: end if;
118: insert into hr_pump_batch_lines
119: (batch_id
120: ,batch_line_id
121: ,business_group_name
122: ,api_module_id
153: ,pval028
154: ,pval029)
155: values
156: (p_batch_id
157: ,nvl(blid,hr_pump_batch_lines_s.nextval)
158: ,p_data_pump_business_grp_name
159: ,3212
160: ,'U'
161: ,p_user_sequence
252: decode(l.pval028,cn,vn,vn,vh,l.pval028) p28,
253: l.pval028 d28,
254: decode(l.pval029,cn,vn,vn,vh,l.pval029) p29,
255: l.pval029 d29
256: from hr_pump_batch_lines l
257: where l.batch_line_id = p_batch_line_id;
258: --
259: c cr%rowtype;
260: l_validate boolean := false;
269: open cr;
270: fetch cr into c;
271: if cr%notfound then
272: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
273: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
274: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
275: hr_utility.set_message_token('VALUE',p_batch_line_id);
276: hr_utility.raise_error;
277: end if;