[Home] [Help]
128: ,P_OUTCOME_NAME in varchar2) 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: ,pval046
190: ,pval049)
191: values
192: (p_batch_id
193: ,nvl(blid,hr_pump_batch_lines_s.nextval)
194: ,p_data_pump_business_grp_name
195: ,3100
196: ,'U'
197: ,p_user_sequence
341: l.pval046 d46,
342: l.pval047 p47,
343: l.pval048 p48,
344: decode(l.pval049,cn,vn,l.pval049) p49
345: from hr_pump_batch_lines l
346: where l.batch_line_id = p_batch_line_id;
347: --
348: c cr%rowtype;
349: l_validate boolean := false;
354: open cr;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
420: ,P_OBJECT_VERSION_NUMBER => c.p48);
421: hr_data_pump.api_trc_off;
422:
423: --
424: update hr_pump_batch_lines l set
425: l.pval047 = decode(c.p47,null,cn,c.p47),
426: l.pval048 = decode(c.p48,null,cn,c.p48)
427: where l.rowid = c.myrowid;
428: --