[Home] [Help]
138: ,P_LIFE_EVENT_REASON in varchar2) is
139: blid number := p_data_pump_batch_line_id;
140: begin
141: if blid is not null then
142: delete from hr_pump_batch_lines where batch_line_id = blid;
143: delete from hr_pump_batch_exceptions
144: where source_type = 'BATCH_LINE' and source_id = blid;
145: end if;
146: insert into hr_pump_batch_lines
142: delete from hr_pump_batch_lines where batch_line_id = blid;
143: delete from hr_pump_batch_exceptions
144: where source_type = 'BATCH_LINE' and source_id = blid;
145: end if;
146: insert into hr_pump_batch_lines
147: (batch_id
148: ,batch_line_id
149: ,business_group_name
150: ,api_module_id
206: ,pval055
207: ,pval056)
208: values
209: (p_batch_id
210: ,nvl(blid,hr_pump_batch_lines_s.nextval)
211: ,p_data_pump_business_grp_name
212: ,477
213: ,'U'
214: ,p_user_sequence
391: l.pval053 d53,
392: decode(l.pval054,cn,dn,d(l.pval054)) p54,
393: decode(l.pval055,cn,vn,l.pval055) p55,
394: decode(l.pval056,cn,vn,l.pval056) p56
395: from hr_pump_batch_lines l
396: where l.batch_line_id = p_batch_line_id;
397: --
398: c cr%rowtype;
399: l_validate boolean := false;
405: open cr;
406: fetch cr into c;
407: if cr%notfound then
408: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
411: hr_utility.set_message_token('VALUE',p_batch_line_id);
412: hr_utility.raise_error;
413: end if;
497: ,P_DATETRACK_MODE => c.p55);
498: hr_data_pump.api_trc_off;
499:
500: --
501: update hr_pump_batch_lines l set
502: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
503: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
504: where l.rowid = c.myrowid;
505: --