[Home] [Help]
144: ,P_END_LIFE_REASON in varchar2 default null) is
145: blid number := p_data_pump_batch_line_id;
146: begin
147: if blid is not null then
148: delete from hr_pump_batch_lines where batch_line_id = blid;
149: delete from hr_pump_batch_exceptions
150: where source_type = 'BATCH_LINE' and source_id = blid;
151: end if;
152: insert into hr_pump_batch_lines
148: delete from hr_pump_batch_lines where batch_line_id = blid;
149: delete from hr_pump_batch_exceptions
150: where source_type = 'BATCH_LINE' and source_id = blid;
151: end if;
152: insert into hr_pump_batch_lines
153: (batch_id
154: ,batch_line_id
155: ,business_group_name
156: ,api_module_id
218: ,pval059
219: ,pval060)
220: values
221: (p_batch_id
222: ,nvl(blid,hr_pump_batch_lines_s.nextval)
223: ,p_data_pump_business_grp_name
224: ,1242
225: ,'U'
226: ,p_user_sequence
414: decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
415: l.pval059 d59,
416: decode(l.pval060,cn,vn,vn,vh,l.pval060) p60,
417: l.pval060 d60
418: from hr_pump_batch_lines l
419: where l.batch_line_id = p_batch_line_id;
420: --
421: c cr%rowtype;
422: l_validate boolean := false;
430: open cr;
431: fetch cr into c;
432: if cr%notfound then
433: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
434: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
435: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
436: hr_utility.set_message_token('VALUE',p_batch_line_id);
437: hr_utility.raise_error;
438: end if;
542: ,P_OBJECT_VERSION_NUMBER => c.p56);
543: hr_data_pump.api_trc_off;
544:
545: --
546: update hr_pump_batch_lines l set
547: l.pval056 = decode(c.p56,null,cn,c.p56)
548: where l.rowid = c.myrowid;
549: --
550: close cr;