[Home] [Help]
196: ,P_LANGUAGE_CODE in varchar2 default null) is
197: blid number := p_data_pump_batch_line_id;
198: begin
199: if blid is not null then
200: delete from hr_pump_batch_lines where batch_line_id = blid;
201: delete from hr_pump_batch_exceptions
202: where source_type = 'BATCH_LINE' and source_id = blid;
203: end if;
204: insert into hr_pump_batch_lines
200: delete from hr_pump_batch_lines where batch_line_id = blid;
201: delete from hr_pump_batch_exceptions
202: where source_type = 'BATCH_LINE' and source_id = blid;
203: end if;
204: insert into hr_pump_batch_lines
205: (batch_id
206: ,batch_line_id
207: ,business_group_name
208: ,api_module_id
325: ,pval123
326: ,pval124)
327: values
328: (p_batch_id
329: ,nvl(blid,hr_pump_batch_lines_s.nextval)
330: ,p_data_pump_business_grp_name
331: ,3861
332: ,'U'
333: ,p_user_sequence
703: decode(l.pval123,cn,vn,vn,vn,l.pval123) p123,
704: l.pval123 d123,
705: decode(l.pval124,cn,vn,vn,vn,l.pval124) p124,
706: l.pval124 d124
707: from hr_pump_batch_lines l
708: where l.batch_line_id = p_batch_line_id;
709: --
710: c cr%rowtype;
711: l_validate boolean := false;
723: open cr;
724: fetch cr into c;
725: if cr%notfound then
726: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
727: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
728: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
729: hr_utility.set_message_token('VALUE',p_batch_line_id);
730: hr_utility.raise_error;
731: end if;
921: else
922: c.p118 := 'FALSE';
923: end if;
924: --
925: update hr_pump_batch_lines l set
926: l.pval109 = decode(c.p109,null,cn,c.p109),
927: l.pval110 = decode(c.p110,null,cn,c.p110),
928: l.pval111 = decode(c.p111,null,cn,c.p111),
929: l.pval112 = decode(c.p112,null,cn,c.p112),