[Home] [Help]
111: ,P_ISSUING_COUNTRY 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: ,pval030
156: ,pval031)
157: values
158: (p_batch_id
159: ,nvl(blid,hr_pump_batch_lines_s.nextval)
160: ,p_data_pump_business_grp_name
161: ,3211
162: ,'U'
163: ,p_user_sequence
250: decode(l.pval028,cn,vn,l.pval028) p28,
251: decode(l.pval029,cn,vn,l.pval029) p29,
252: decode(l.pval030,cn,vn,l.pval030) p30,
253: decode(l.pval031,cn,vn,l.pval031) p31
254: from hr_pump_batch_lines l
255: where l.batch_line_id = p_batch_line_id;
256: --
257: c cr%rowtype;
258: l_validate boolean := false;
267: open cr;
268: fetch cr into c;
269: if cr%notfound then
270: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
271: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
272: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
273: hr_utility.set_message_token('VALUE',p_batch_line_id);
274: hr_utility.raise_error;
275: end if;
343: hr_data_pump.api_trc_off;
344: --
345: iuk(p_batch_line_id,c.p26,L_PERSON_EXTRA_INFO_ID);
346: --
347: update hr_pump_batch_lines l set
348: l.pval026 = decode(c.p26,null,cn,c.p26),
349: l.pval027 = decode(c.p27,null,cn,c.p27)
350: where l.rowid = c.myrowid;
351: --