[Home] [Help]
147: ,P_SETS_OF_BOOK_NAME in varchar2 default null) is
148: blid number := p_data_pump_batch_line_id;
149: begin
150: if blid is not null then
151: delete from hr_pump_batch_lines where batch_line_id = blid;
152: delete from hr_pump_batch_exceptions
153: where source_type = 'BATCH_LINE' and source_id = blid;
154: end if;
155: insert into hr_pump_batch_lines
151: delete from hr_pump_batch_lines where batch_line_id = blid;
152: delete from hr_pump_batch_exceptions
153: where source_type = 'BATCH_LINE' and source_id = blid;
154: end if;
155: insert into hr_pump_batch_lines
156: (batch_id
157: ,batch_line_id
158: ,business_group_name
159: ,api_module_id
227: ,pval070
228: ,pval071)
229: values
230: (p_batch_id
231: ,nvl(blid,hr_pump_batch_lines_s.nextval)
232: ,p_data_pump_business_grp_name
233: ,3224
234: ,'U'
235: ,p_user_sequence
443: l.pval069 p69,
444: decode(l.pval070,cn,vn,l.pval070) p70,
445: decode(l.pval071,cn,vn,vn,vh,l.pval071) p71,
446: l.pval071 d71
447: from hr_pump_batch_lines l
448: where l.batch_line_id = p_batch_line_id;
449: --
450: c cr%rowtype;
451: l_validate boolean := false;
458: open cr;
459: fetch cr into c;
460: if cr%notfound then
461: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
462: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
463: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
464: hr_utility.set_message_token('VALUE',p_batch_line_id);
465: hr_utility.raise_error;
466: end if;
570: ,P_EXTERNAL_ACCOUNT_ID => c.p69);
571: hr_data_pump.api_trc_off;
572:
573: --
574: update hr_pump_batch_lines l set
575: l.pval065 = decode(c.p65,null,cn,dc(c.p65)),
576: l.pval066 = decode(c.p66,null,cn,dc(c.p66)),
577: l.pval067 = decode(c.p67,null,cn,c.p67),
578: l.pval068 = decode(c.p68,null,cn,c.p68),