[Home] [Help]
189: ,P_BENEFIT_GROUP in varchar2 default null) is
190: blid number := p_data_pump_batch_line_id;
191: begin
192: if blid is not null then
193: delete from hr_pump_batch_lines where batch_line_id = blid;
194: delete from hr_pump_batch_exceptions
195: where source_type = 'BATCH_LINE' and source_id = blid;
196: end if;
197: insert into hr_pump_batch_lines
193: delete from hr_pump_batch_lines where batch_line_id = blid;
194: delete from hr_pump_batch_exceptions
195: where source_type = 'BATCH_LINE' and source_id = blid;
196: end if;
197: insert into hr_pump_batch_lines
198: (batch_id
199: ,batch_line_id
200: ,business_group_name
201: ,api_module_id
311: ,pval118
312: ,pval119)
313: values
314: (p_batch_id
315: ,nvl(blid,hr_pump_batch_lines_s.nextval)
316: ,p_data_pump_business_grp_name
317: ,3207
318: ,'U'
319: ,p_user_sequence
672: decode(l.pval118,cn,vn,vn,vn,l.pval118) p118,
673: l.pval118 d118,
674: decode(l.pval119,cn,vn,vn,vn,l.pval119) p119,
675: l.pval119 d119
676: from hr_pump_batch_lines l
677: where l.batch_line_id = p_batch_line_id;
678: --
679: c cr%rowtype;
680: l_validate boolean := false;
693: open cr;
694: fetch cr into c;
695: if cr%notfound then
696: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
697: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
698: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
699: hr_utility.set_message_token('VALUE',p_batch_line_id);
700: hr_utility.raise_error;
701: end if;
881: else
882: c.p114 := 'FALSE';
883: end if;
884: --
885: update hr_pump_batch_lines l set
886: l.pval008 = decode(c.p8,null,cn,c.p8),
887: l.pval102 = decode(c.p102,null,cn,c.p102),
888: l.pval103 = decode(c.p103,null,cn,c.p103),
889: l.pval104 = decode(c.p104,null,cn,c.p104),