[Home] [Help]
258: ,P_SUPERVISOR_USER_KEY in varchar2 default null) is
259: blid number := p_data_pump_batch_line_id;
260: begin
261: if blid is not null then
262: delete from hr_pump_batch_lines where batch_line_id = blid;
263: delete from hr_pump_batch_exceptions
264: where source_type = 'BATCH_LINE' and source_id = blid;
265: end if;
266: insert into hr_pump_batch_lines
262: delete from hr_pump_batch_lines where batch_line_id = blid;
263: delete from hr_pump_batch_exceptions
264: where source_type = 'BATCH_LINE' and source_id = blid;
265: end if;
266: insert into hr_pump_batch_lines
267: (batch_id
268: ,batch_line_id
269: ,business_group_name
270: ,api_module_id
430: ,pval160
431: ,pval161)
432: values
433: (p_batch_id
434: ,nvl(blid,hr_pump_batch_lines_s.nextval)
435: ,p_data_pump_business_grp_name
436: ,1216
437: ,'U'
438: ,p_user_sequence
933: decode(l.pval160,cn,vn,vn,vh,l.pval160) p160,
934: l.pval160 d160,
935: decode(l.pval161,cn,vn,vn,vn,l.pval161) p161,
936: l.pval161 d161
937: from hr_pump_batch_lines l
938: where l.batch_line_id = p_batch_line_id;
939: --
940: c cr%rowtype;
941: l_validate boolean := false;
962: open cr;
963: fetch cr into c;
964: if cr%notfound then
965: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
966: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
967: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
968: hr_utility.set_message_token('VALUE',p_batch_line_id);
969: hr_utility.raise_error;
970: end if;
1321: else
1322: c.p4 := 'FALSE';
1323: end if;
1324: --
1325: update hr_pump_batch_lines l set
1326: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
1327: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
1328: l.pval003 = decode(c.p3,null,cn,c.p3),
1329: l.pval004 = decode(c.p4,null,cn,c.p4),