[Home] [Help]
108: ,P_ATTRIBUTE20 in varchar2 default null) is
109: blid number := p_data_pump_batch_line_id;
110: begin
111: if blid is not null then
112: delete from hr_pump_batch_lines where batch_line_id = blid;
113: delete from hr_pump_batch_exceptions
114: where source_type = 'BATCH_LINE' and source_id = blid;
115: end if;
116: insert into hr_pump_batch_lines
112: delete from hr_pump_batch_lines where batch_line_id = blid;
113: delete from hr_pump_batch_exceptions
114: where source_type = 'BATCH_LINE' and source_id = blid;
115: end if;
116: insert into hr_pump_batch_lines
117: (batch_id
118: ,batch_line_id
119: ,business_group_name
120: ,api_module_id
149: ,pval026
150: ,pval027)
151: values
152: (p_batch_id
153: ,nvl(blid,hr_pump_batch_lines_s.nextval)
154: ,p_data_pump_business_grp_name
155: ,1315
156: ,'U'
157: ,p_user_sequence
244: decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
245: l.pval027 d27,
246: l.pval028 p28,
247: l.pval029 p29
248: from hr_pump_batch_lines l
249: where l.batch_line_id = p_batch_line_id;
250: --
251: c cr%rowtype;
252: l_validate boolean := false;
256: open cr;
257: fetch cr into c;
258: if cr%notfound then
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
264: end if;
298: ,P_OBJECT_VERSION_NUMBER => c.p29);
299: hr_data_pump.api_trc_off;
300:
301: --
302: update hr_pump_batch_lines l set
303: l.pval028 = decode(c.p28,null,cn,c.p28),
304: l.pval029 = decode(c.p29,null,cn,c.p29)
305: where l.rowid = c.myrowid;
306: --