[Home] [Help]
242: ,P_SUPERVISOR_USER_KEY in varchar2 default null) is
243: blid number := p_data_pump_batch_line_id;
244: begin
245: if blid is not null then
246: delete from hr_pump_batch_lines where batch_line_id = blid;
247: delete from hr_pump_batch_exceptions
248: where source_type = 'BATCH_LINE' and source_id = blid;
249: end if;
250: insert into hr_pump_batch_lines
246: delete from hr_pump_batch_lines where batch_line_id = blid;
247: delete from hr_pump_batch_exceptions
248: where source_type = 'BATCH_LINE' and source_id = blid;
249: end if;
250: insert into hr_pump_batch_lines
251: (batch_id
252: ,batch_line_id
253: ,business_group_name
254: ,api_module_id
416: ,pval163
417: ,pval164)
418: values
419: (p_batch_id
420: ,nvl(blid,hr_pump_batch_lines_s.nextval)
421: ,p_data_pump_business_grp_name
422: ,1215
423: ,'U'
424: ,p_user_sequence
924: decode(l.pval163,cn,vn,vn,vn,l.pval163) p163,
925: l.pval163 d163,
926: decode(l.pval164,cn,vn,vn,vn,l.pval164) p164,
927: l.pval164 d164
928: from hr_pump_batch_lines l
929: where l.batch_line_id = p_batch_line_id;
930: --
931: c cr%rowtype;
932: l_validate boolean := false;
951: open cr;
952: fetch cr into c;
953: if cr%notfound then
954: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
955: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
956: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
957: hr_utility.set_message_token('VALUE',p_batch_line_id);
958: hr_utility.raise_error;
959: end if;
1279: ,P_SECURITY_PROFILE_ID => c.p149);
1280: hr_data_pump.api_trc_off;
1281:
1282: --
1283: update hr_pump_batch_lines l set
1284: l.pval001 = decode(c.p1,null,cn,c.p1),
1285: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
1286: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
1287: l.pval004 = decode(c.p4,null,cn,c.p4),