[Home] [Help]
168: ,P_NAME in varchar2) is
169: blid number := p_data_pump_batch_line_id;
170: begin
171: if blid is not null then
172: delete from hr_pump_batch_lines where batch_line_id = blid;
173: delete from hr_pump_batch_exceptions
174: where source_type = 'BATCH_LINE' and source_id = blid;
175: end if;
176: insert into hr_pump_batch_lines
172: delete from hr_pump_batch_lines where batch_line_id = blid;
173: delete from hr_pump_batch_exceptions
174: where source_type = 'BATCH_LINE' and source_id = blid;
175: end if;
176: insert into hr_pump_batch_lines
177: (batch_id
178: ,batch_line_id
179: ,business_group_name
180: ,api_module_id
269: ,pval088
270: ,pval089)
271: values
272: (p_batch_id
273: ,nvl(blid,hr_pump_batch_lines_s.nextval)
274: ,p_data_pump_business_grp_name
275: ,2833
276: ,'U'
277: ,p_user_sequence
541: l.pval086 p86,
542: l.pval087 p87,
543: decode(l.pval088,cn,nn,n(l.pval088)) p88,
544: decode(l.pval089,cn,vn,l.pval089) p89
545: from hr_pump_batch_lines l
546: where l.batch_line_id = p_batch_line_id;
547: --
548: c cr%rowtype;
549: l_validate boolean := false;
556: open cr;
557: fetch cr into c;
558: if cr%notfound then
559: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
560: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
561: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
562: hr_utility.set_message_token('VALUE',p_batch_line_id);
563: hr_utility.raise_error;
564: end if;
670: ,P_NAME => c.p89);
671: hr_data_pump.api_trc_off;
672:
673: --
674: update hr_pump_batch_lines l set
675: l.pval086 = decode(c.p86,null,cn,c.p86),
676: l.pval087 = decode(c.p87,null,cn,c.p87),
677: l.pval088 = decode(c.p88,null,cn,c.p88),
678: l.pval089 = decode(c.p89,null,cn,c.p89)