[Home] [Help]
177: ,P_LANGUAGE_CODE in varchar2 default null) is
178: blid number := p_data_pump_batch_line_id;
179: begin
180: if blid is not null then
181: delete from hr_pump_batch_lines where batch_line_id = blid;
182: delete from hr_pump_batch_exceptions
183: where source_type = 'BATCH_LINE' and source_id = blid;
184: end if;
185: insert into hr_pump_batch_lines
181: delete from hr_pump_batch_lines where batch_line_id = blid;
182: delete from hr_pump_batch_exceptions
183: where source_type = 'BATCH_LINE' and source_id = blid;
184: end if;
185: insert into hr_pump_batch_lines
186: (batch_id
187: ,batch_line_id
188: ,business_group_name
189: ,api_module_id
287: ,pval100
288: ,pval101)
289: values
290: (p_batch_id
291: ,nvl(blid,hr_pump_batch_lines_s.nextval)
292: ,p_data_pump_business_grp_name
293: ,1141
294: ,'U'
295: ,p_user_sequence
590: decode(l.pval100,cn,vn,vn,vn,l.pval100) p100,
591: l.pval100 d100,
592: decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
593: l.pval101 d101
594: from hr_pump_batch_lines l
595: where l.batch_line_id = p_batch_line_id;
596: --
597: c cr%rowtype;
598: l_validate boolean := false;
607: open cr;
608: fetch cr into c;
609: if cr%notfound then
610: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
611: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
612: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
613: hr_utility.set_message_token('VALUE',p_batch_line_id);
614: hr_utility.raise_error;
615: end if;
753: hr_data_pump.api_trc_off;
754: --
755: iuk(p_batch_line_id,c.p90,L_PERSONAL_PAYMENT_METHOD_ID);
756: --
757: update hr_pump_batch_lines l set
758: l.pval090 = decode(c.p90,null,cn,c.p90),
759: l.pval091 = decode(c.p91,null,cn,c.p91),
760: l.pval092 = decode(c.p92,null,cn,c.p92),
761: l.pval093 = decode(c.p93,null,cn,dc(c.p93)),