[Home] [Help]
199: ,P_RT_COMP_REF_UOM in varchar2 default null) is
200: blid number := p_data_pump_batch_line_id;
201: begin
202: if blid is not null then
203: delete from hr_pump_batch_lines where batch_line_id = blid;
204: delete from hr_pump_batch_exceptions
205: where source_type = 'BATCH_LINE' and source_id = blid;
206: end if;
207: insert into hr_pump_batch_lines
203: delete from hr_pump_batch_lines where batch_line_id = blid;
204: delete from hr_pump_batch_exceptions
205: where source_type = 'BATCH_LINE' and source_id = blid;
206: end if;
207: insert into hr_pump_batch_lines
208: (batch_id
209: ,batch_line_id
210: ,business_group_name
211: ,api_module_id
309: ,pval097
310: ,pval098)
311: values
312: (p_batch_id
313: ,nvl(blid,hr_pump_batch_lines_s.nextval)
314: ,p_data_pump_business_grp_name
315: ,626
316: ,'U'
317: ,p_user_sequence
640: decode(l.pval097,cn,vn,vn,vh,l.pval097) p97,
641: l.pval097 d97,
642: decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
643: l.pval098 d98
644: from hr_pump_batch_lines l
645: where l.batch_line_id = p_batch_line_id;
646: --
647: c cr%rowtype;
648: l_validate boolean := false;
665: open cr;
666: fetch cr into c;
667: if cr%notfound then
668: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
669: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
670: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
671: hr_utility.set_message_token('VALUE',p_batch_line_id);
672: hr_utility.raise_error;
673: end if;
900: ,P_DATETRACK_MODE => c.p89);
901: hr_data_pump.api_trc_off;
902:
903: --
904: update hr_pump_batch_lines l set
905: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
906: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
907: where l.rowid = c.myrowid;
908: --