[Home] [Help]
166: ,P_SHIP_TO_LOCATION_CODE in varchar2 default null) is
167: blid number := p_data_pump_batch_line_id;
168: begin
169: if blid is not null then
170: delete from hr_pump_batch_lines where batch_line_id = blid;
171: delete from hr_pump_batch_exceptions
172: where source_type = 'BATCH_LINE' and source_id = blid;
173: end if;
174: insert into hr_pump_batch_lines
170: delete from hr_pump_batch_lines where batch_line_id = blid;
171: delete from hr_pump_batch_exceptions
172: where source_type = 'BATCH_LINE' and source_id = blid;
173: end if;
174: insert into hr_pump_batch_lines
175: (batch_id
176: ,batch_line_id
177: ,business_group_name
178: ,api_module_id
261: ,pval080
262: ,pval081)
263: values
264: (p_batch_id
265: ,nvl(blid,hr_pump_batch_lines_s.nextval)
266: ,p_data_pump_business_grp_name
267: ,1267
268: ,'U'
269: ,p_user_sequence
514: decode(l.pval080,cn,vn,vn,vh,l.pval080) p80,
515: l.pval080 d80,
516: decode(l.pval081,cn,vn,vn,vh,l.pval081) p81,
517: l.pval081 d81
518: from hr_pump_batch_lines l
519: where l.batch_line_id = p_batch_line_id;
520: --
521: c cr%rowtype;
522: l_validate boolean := false;
530: open cr;
531: fetch cr into c;
532: if cr%notfound then
533: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
534: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
535: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
536: hr_utility.set_message_token('VALUE',p_batch_line_id);
537: hr_utility.raise_error;
538: end if;