[Home] [Help]
148: ,P_SETS_OF_BOOK_NAME in varchar2 default null) is
149: blid number := p_data_pump_batch_line_id;
150: begin
151: if blid is not null then
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
157: (batch_id
158: ,batch_line_id
159: ,business_group_name
160: ,api_module_id
229: ,pval072
230: ,pval073)
231: values
232: (p_batch_id
233: ,nvl(blid,hr_pump_batch_lines_s.nextval)
234: ,p_data_pump_business_grp_name
235: ,3223
236: ,'U'
237: ,p_user_sequence
448: l.pval071 p71,
449: decode(l.pval072,cn,nn,n(l.pval072)) p72,
450: decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
451: l.pval073 d73
452: from hr_pump_batch_lines l
453: where l.batch_line_id = p_batch_line_id;
454: --
455: c cr%rowtype;
456: l_validate boolean := false;
463: open cr;
464: fetch cr into c;
465: if cr%notfound then
466: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
467: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
468: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
469: hr_utility.set_message_token('VALUE',p_batch_line_id);
470: hr_utility.raise_error;
471: end if;
566: hr_data_pump.api_trc_off;
567: --
568: iuk(p_batch_line_id,c.p65,L_ORG_PAYMENT_METHOD_ID);
569: --
570: update hr_pump_batch_lines l set
571: l.pval065 = decode(c.p65,null,cn,c.p65),
572: l.pval066 = decode(c.p66,null,cn,dc(c.p66)),
573: l.pval067 = decode(c.p67,null,cn,dc(c.p67)),
574: l.pval068 = decode(c.p68,null,cn,c.p68),