[Home] [Help]
222: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
223: blid number := p_data_pump_batch_line_id;
224: begin
225: if blid is not null then
226: delete from hr_pump_batch_lines where batch_line_id = blid;
227: delete from hr_pump_batch_exceptions
228: where source_type = 'BATCH_LINE' and source_id = blid;
229: end if;
230: insert into hr_pump_batch_lines
226: delete from hr_pump_batch_lines where batch_line_id = blid;
227: delete from hr_pump_batch_exceptions
228: where source_type = 'BATCH_LINE' and source_id = blid;
229: end if;
230: insert into hr_pump_batch_lines
231: (batch_id
232: ,batch_line_id
233: ,business_group_name
234: ,api_module_id
377: ,pval151
378: ,pval152)
379: values
380: (p_batch_id
381: ,nvl(blid,hr_pump_batch_lines_s.nextval)
382: ,p_data_pump_business_grp_name
383: ,3857
384: ,'U'
385: ,p_user_sequence
829: decode(l.pval151,cn,vn,vn,vn,l.pval151) p151,
830: l.pval151 d151,
831: decode(l.pval152,cn,vn,vn,vn,l.pval152) p152,
832: l.pval152 d152
833: from hr_pump_batch_lines l
834: where l.batch_line_id = p_batch_line_id;
835: --
836: c cr%rowtype;
837: l_validate boolean := false;
866: open cr;
867: fetch cr into c;
868: if cr%notfound then
869: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
870: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
871: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
872: hr_utility.set_message_token('VALUE',p_batch_line_id);
873: hr_utility.raise_error;
874: end if;
1254: else
1255: c.p128 := 'FALSE';
1256: end if;
1257: --
1258: update hr_pump_batch_lines l set
1259: l.pval002 = decode(c.p2,null,cn,c.p2),
1260: l.pval115 = decode(c.p115,null,cn,c.p115),
1261: l.pval116 = decode(c.p116,null,cn,c.p116),
1262: l.pval117 = decode(c.p117,null,cn,c.p117),