[Home] [Help]
184: ,P_COMP_REF_UOM in varchar2 default null) is
185: blid number := p_data_pump_batch_line_id;
186: begin
187: if blid is not null then
188: delete from hr_pump_batch_lines where batch_line_id = blid;
189: delete from hr_pump_batch_exceptions
190: where source_type = 'BATCH_LINE' and source_id = blid;
191: end if;
192: insert into hr_pump_batch_lines
188: delete from hr_pump_batch_lines where batch_line_id = blid;
189: delete from hr_pump_batch_exceptions
190: where source_type = 'BATCH_LINE' and source_id = blid;
191: end if;
192: insert into hr_pump_batch_lines
193: (batch_id
194: ,batch_line_id
195: ,business_group_name
196: ,api_module_id
281: ,pval084
282: ,pval085)
283: values
284: (p_batch_id
285: ,nvl(blid,hr_pump_batch_lines_s.nextval)
286: ,p_data_pump_business_grp_name
287: ,385
288: ,'U'
289: ,p_user_sequence
566: decode(l.pval084,cn,vn,vn,vh,l.pval084) p84,
567: l.pval084 d84,
568: decode(l.pval085,cn,vn,vn,vh,l.pval085) p85,
569: l.pval085 d85
570: from hr_pump_batch_lines l
571: where l.batch_line_id = p_batch_line_id;
572: --
573: c cr%rowtype;
574: l_validate boolean := false;
588: open cr;
589: fetch cr into c;
590: if cr%notfound then
591: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
594: hr_utility.set_message_token('VALUE',p_batch_line_id);
595: hr_utility.raise_error;
596: end if;
774: ,P_DATETRACK_MODE => c.p79);
775: hr_data_pump.api_trc_off;
776:
777: --
778: update hr_pump_batch_lines l set
779: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
780: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
781: where l.rowid = c.myrowid;
782: --