[Home] [Help]
201: ,P_LANGUAGE_CODE in varchar2 default null) is
202: blid number := p_data_pump_batch_line_id;
203: begin
204: if blid is not null then
205: delete from hr_pump_batch_lines where batch_line_id = blid;
206: delete from hr_pump_batch_exceptions
207: where source_type = 'BATCH_LINE' and source_id = blid;
208: end if;
209: insert into hr_pump_batch_lines
205: delete from hr_pump_batch_lines where batch_line_id = blid;
206: delete from hr_pump_batch_exceptions
207: where source_type = 'BATCH_LINE' and source_id = blid;
208: end if;
209: insert into hr_pump_batch_lines
210: (batch_id
211: ,batch_line_id
212: ,business_group_name
213: ,api_module_id
335: ,pval127
336: ,pval128)
337: values
338: (p_batch_id
339: ,nvl(blid,hr_pump_batch_lines_s.nextval)
340: ,p_data_pump_business_grp_name
341: ,3219
342: ,'U'
343: ,p_user_sequence
727: decode(l.pval127,cn,vn,vn,vn,l.pval127) p127,
728: l.pval127 d127,
729: decode(l.pval128,cn,vn,vn,vn,l.pval128) p128,
730: l.pval128 d128
731: from hr_pump_batch_lines l
732: where l.batch_line_id = p_batch_line_id;
733: --
734: c cr%rowtype;
735: l_validate boolean := false;
749: open cr;
750: fetch cr into c;
751: if cr%notfound then
752: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
753: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
754: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
755: hr_utility.set_message_token('VALUE',p_batch_line_id);
756: hr_utility.raise_error;
757: end if;
961: else
962: c.p121 := 'FALSE';
963: end if;
964: --
965: update hr_pump_batch_lines l set
966: l.pval112 = decode(c.p112,null,cn,c.p112),
967: l.pval113 = decode(c.p113,null,cn,c.p113),
968: l.pval114 = decode(c.p114,null,cn,c.p114),
969: l.pval115 = decode(c.p115,null,cn,c.p115),