[Home] [Help]
109: ,P_CONTACTEE_USER_KEY in varchar2) 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: ,pval031
152: ,pval032)
153: values
154: (p_batch_id
155: ,nvl(blid,hr_pump_batch_lines_s.nextval)
156: ,p_data_pump_business_grp_name
157: ,3221
158: ,'U'
159: ,p_user_sequence
247: decode(l.pval029,cn,dn,d(l.pval029)) p29,
248: decode(l.pval030,cn,dn,d(l.pval030)) p30,
249: decode(l.pval031,cn,vn,l.pval031) p31,
250: decode(l.pval032,cn,vn,l.pval032) p32
251: from hr_pump_batch_lines l
252: where l.batch_line_id = p_batch_line_id;
253: --
254: c cr%rowtype;
255: l_validate boolean := false;
260: open cr;
261: fetch cr into c;
262: if cr%notfound then
263: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
264: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
265: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
266: hr_utility.set_message_token('VALUE',p_batch_line_id);
267: hr_utility.raise_error;
268: end if;
313: ,P_EFFECTIVE_END_DATE => c.p30);
314: hr_data_pump.api_trc_off;
315:
316: --
317: update hr_pump_batch_lines l set
318: l.pval027 = decode(c.p27,null,cn,c.p27),
319: l.pval028 = decode(c.p28,null,cn,c.p28),
320: l.pval029 = decode(c.p29,null,cn,dc(c.p29)),
321: l.pval030 = decode(c.p30,null,cn,dc(c.p30))