[Home] [Help]
137: ,P_MGR_OVRID_PERSON_USER_KEY in varchar2 default null) is
138: blid number := p_data_pump_batch_line_id;
139: begin
140: if blid is not null then
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
146: (batch_id
147: ,batch_line_id
148: ,business_group_name
149: ,api_module_id
201: ,pval052
202: ,pval053)
203: values
204: (p_batch_id
205: ,nvl(blid,hr_pump_batch_lines_s.nextval)
206: ,p_data_pump_business_grp_name
207: ,652
208: ,'U'
209: ,p_user_sequence
367: decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
368: l.pval052 d52,
369: decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
370: l.pval053 d53
371: from hr_pump_batch_lines l
372: where l.batch_line_id = p_batch_line_id;
373: --
374: c cr%rowtype;
375: l_validate boolean := false;
393: open cr;
394: fetch cr into c;
395: if cr%notfound then
396: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
397: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
398: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
399: hr_utility.set_message_token('VALUE',p_batch_line_id);
400: hr_utility.raise_error;
401: end if;
581: ,P_EFFECTIVE_DATE => c.p43);
582: hr_data_pump.api_trc_off;
583:
584: --
585: update hr_pump_batch_lines l set
586: l.pval004 = decode(c.p4,null,cn,dc(c.p4)),
587: l.pval005 = decode(c.p5,null,cn,dc(c.p5)),
588: l.pval006 = decode(c.p6,null,cn,dc(c.p6))
589: where l.rowid = c.myrowid;