[Home] [Help]
111: ,P_CONTACT_EXTRA_INFO_USER_KEY in varchar2) is
112: blid number := p_data_pump_batch_line_id;
113: begin
114: if blid is not null then
115: delete from hr_pump_batch_lines where batch_line_id = blid;
116: delete from hr_pump_batch_exceptions
117: where source_type = 'BATCH_LINE' and source_id = blid;
118: end if;
119: insert into hr_pump_batch_lines
115: delete from hr_pump_batch_lines where batch_line_id = blid;
116: delete from hr_pump_batch_exceptions
117: where source_type = 'BATCH_LINE' and source_id = blid;
118: end if;
119: insert into hr_pump_batch_lines
120: (batch_id
121: ,batch_line_id
122: ,business_group_name
123: ,api_module_id
155: ,pval031
156: ,pval032)
157: values
158: (p_batch_id
159: ,nvl(blid,hr_pump_batch_lines_s.nextval)
160: ,p_data_pump_business_grp_name
161: ,3222
162: ,'U'
163: ,p_user_sequence
258: l.pval030 d30,
259: decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
260: l.pval031 d31,
261: decode(l.pval032,cn,vn,l.pval032) p32
262: from hr_pump_batch_lines l
263: where l.batch_line_id = p_batch_line_id;
264: --
265: c cr%rowtype;
266: l_validate boolean := false;
273: open cr;
274: fetch cr into c;
275: if cr%notfound then
276: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
277: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
278: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
279: hr_utility.set_message_token('VALUE',p_batch_line_id);
280: hr_utility.raise_error;
281: end if;
348: ,P_EFFECTIVE_END_DATE => c.p29);
349: hr_data_pump.api_trc_off;
350:
351: --
352: update hr_pump_batch_lines l set
353: l.pval028 = decode(c.p28,null,cn,dc(c.p28)),
354: l.pval029 = decode(c.p29,null,cn,dc(c.p29))
355: where l.rowid = c.myrowid;
356: --