[Home] [Help]
188: ,P_BENEFIT_GROUP in varchar2 default null) is
189: blid number := p_data_pump_batch_line_id;
190: begin
191: if blid is not null then
192: delete from hr_pump_batch_lines where batch_line_id = blid;
193: delete from hr_pump_batch_exceptions
194: where source_type = 'BATCH_LINE' and source_id = blid;
195: end if;
196: insert into hr_pump_batch_lines
192: delete from hr_pump_batch_lines where batch_line_id = blid;
193: delete from hr_pump_batch_exceptions
194: where source_type = 'BATCH_LINE' and source_id = blid;
195: end if;
196: insert into hr_pump_batch_lines
197: (batch_id
198: ,batch_line_id
199: ,business_group_name
200: ,api_module_id
309: ,pval117
310: ,pval118)
311: values
312: (p_batch_id
313: ,nvl(blid,hr_pump_batch_lines_s.nextval)
314: ,p_data_pump_business_grp_name
315: ,1373
316: ,'U'
317: ,p_user_sequence
670: decode(l.pval117,cn,vn,vn,vn,l.pval117) p117,
671: l.pval117 d117,
672: decode(l.pval118,cn,vn,vn,vn,l.pval118) p118,
673: l.pval118 d118
674: from hr_pump_batch_lines l
675: where l.batch_line_id = p_batch_line_id;
676: --
677: c cr%rowtype;
678: l_validate boolean := false;
691: open cr;
692: fetch cr into c;
693: if cr%notfound then
694: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
695: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
696: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
697: hr_utility.set_message_token('VALUE',p_batch_line_id);
698: hr_utility.raise_error;
699: end if;
878: else
879: c.p113 := 'FALSE';
880: end if;
881: --
882: update hr_pump_batch_lines l set
883: l.pval008 = decode(c.p8,null,cn,c.p8),
884: l.pval101 = decode(c.p101,null,cn,c.p101),
885: l.pval102 = decode(c.p102,null,cn,c.p102),
886: l.pval103 = decode(c.p103,null,cn,c.p103),