[Home] [Help]
128: ,P_DPNT_PERSON_USER_KEY in varchar2 default null) is
129: blid number := p_data_pump_batch_line_id;
130: begin
131: if blid is not null then
132: delete from hr_pump_batch_lines where batch_line_id = blid;
133: delete from hr_pump_batch_exceptions
134: where source_type = 'BATCH_LINE' and source_id = blid;
135: end if;
136: insert into hr_pump_batch_lines
132: delete from hr_pump_batch_lines where batch_line_id = blid;
133: delete from hr_pump_batch_exceptions
134: where source_type = 'BATCH_LINE' and source_id = blid;
135: end if;
136: insert into hr_pump_batch_lines
137: (batch_id
138: ,batch_line_id
139: ,business_group_name
140: ,api_module_id
189: ,pval047
190: ,pval048)
191: values
192: (p_batch_id
193: ,nvl(blid,hr_pump_batch_lines_s.nextval)
194: ,p_data_pump_business_grp_name
195: ,1077
196: ,'U'
197: ,p_user_sequence
345: decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
346: l.pval047 d47,
347: decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
348: l.pval048 d48
349: from hr_pump_batch_lines l
350: where l.batch_line_id = p_batch_line_id;
351: --
352: c cr%rowtype;
353: l_validate boolean := false;
367: open cr;
368: fetch cr into c;
369: if cr%notfound then
370: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
371: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
372: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
373: hr_utility.set_message_token('VALUE',p_batch_line_id);
374: hr_utility.raise_error;
375: end if;
489: hr_data_pump.api_trc_off;
490: --
491: iuk(p_batch_line_id,c.p1,L_ELIG_DPNT_ID);
492: --
493: update hr_pump_batch_lines l set
494: l.pval001 = decode(c.p1,null,cn,c.p1),
495: l.pval041 = decode(c.p41,null,cn,c.p41)
496: where l.rowid = c.myrowid;
497: --