[Home] [Help]
126: ,P_LANGUAGE_CODE in varchar2) is
127: blid number := p_data_pump_batch_line_id;
128: begin
129: if blid is not null then
130: delete from hr_pump_batch_lines where batch_line_id = blid;
131: delete from hr_pump_batch_exceptions
132: where source_type = 'BATCH_LINE' and source_id = blid;
133: end if;
134: insert into hr_pump_batch_lines
130: delete from hr_pump_batch_lines where batch_line_id = blid;
131: delete from hr_pump_batch_exceptions
132: where source_type = 'BATCH_LINE' and source_id = blid;
133: end if;
134: insert into hr_pump_batch_lines
135: (batch_id
136: ,batch_line_id
137: ,business_group_name
138: ,api_module_id
185: ,pval046
186: ,pval047)
187: values
188: (p_batch_id
189: ,nvl(blid,hr_pump_batch_lines_s.nextval)
190: ,p_data_pump_business_grp_name
191: ,2203
192: ,'U'
193: ,p_user_sequence
331: l.pval044 p44,
332: l.pval045 p45,
333: decode(l.pval046,cn,vn,l.pval046) p46,
334: decode(l.pval047,cn,vn,l.pval047) p47
335: from hr_pump_batch_lines l
336: where l.batch_line_id = p_batch_line_id;
337: --
338: c cr%rowtype;
339: l_validate boolean := false;
344: open cr;
345: fetch cr into c;
346: if cr%notfound then
347: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
348: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
349: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
350: hr_utility.set_message_token('VALUE',p_batch_line_id);
351: hr_utility.raise_error;
352: end if;
415: ,P_OBJECT_VERSION_NUMBER => c.p45);
416: hr_data_pump.api_trc_off;
417:
418: --
419: update hr_pump_batch_lines l set
420: l.pval044 = decode(c.p44,null,cn,c.p44),
421: l.pval045 = decode(c.p45,null,cn,c.p45)
422: where l.rowid = c.myrowid;
423: --