[Home] [Help]
109: ,P_WEIGHT in varchar2 default null) is
110: blid number := p_data_pump_batch_line_id;
111: begin
112: if blid is not null then
113: delete from hr_pump_batch_lines where batch_line_id = blid;
114: delete from hr_pump_batch_exceptions
115: where source_type = 'BATCH_LINE' and source_id = blid;
116: end if;
117: insert into hr_pump_batch_lines
113: delete from hr_pump_batch_lines where batch_line_id = blid;
114: delete from hr_pump_batch_exceptions
115: where source_type = 'BATCH_LINE' and source_id = blid;
116: end if;
117: insert into hr_pump_batch_lines
118: (batch_id
119: ,batch_line_id
120: ,business_group_name
121: ,api_module_id
151: ,pval028
152: ,pval029)
153: values
154: (p_batch_id
155: ,nvl(blid,hr_pump_batch_lines_s.nextval)
156: ,p_data_pump_business_grp_name
157: ,3209
158: ,'U'
159: ,p_user_sequence
249: decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
250: l.pval028 d28,
251: decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
252: l.pval029 d29
253: from hr_pump_batch_lines l
254: where l.batch_line_id = p_batch_line_id;
255: --
256: c cr%rowtype;
257: l_validate boolean := false;
265: open cr;
266: fetch cr into c;
267: if cr%notfound then
268: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
269: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
270: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
271: hr_utility.set_message_token('VALUE',p_batch_line_id);
272: hr_utility.raise_error;
273: end if;
331: hr_data_pump.api_trc_off;
332: --
333: iuk(p_batch_line_id,c.p25,L_PERSON_EXTRA_INFO_ID);
334: --
335: update hr_pump_batch_lines l set
336: l.pval025 = decode(c.p25,null,cn,c.p25),
337: l.pval026 = decode(c.p26,null,cn,c.p26)
338: where l.rowid = c.myrowid;
339: --