[Home] [Help]
187: ,P_BENEFIT_GROUP in varchar2 default null) is
188: blid number := p_data_pump_batch_line_id;
189: begin
190: if blid is not null then
191: delete from hr_pump_batch_lines where batch_line_id = blid;
192: delete from hr_pump_batch_exceptions
193: where source_type = 'BATCH_LINE' and source_id = blid;
194: end if;
195: insert into hr_pump_batch_lines
191: delete from hr_pump_batch_lines where batch_line_id = blid;
192: delete from hr_pump_batch_exceptions
193: where source_type = 'BATCH_LINE' and source_id = blid;
194: end if;
195: insert into hr_pump_batch_lines
196: (batch_id
197: ,batch_line_id
198: ,business_group_name
199: ,api_module_id
307: ,pval116
308: ,pval117)
309: values
310: (p_batch_id
311: ,nvl(blid,hr_pump_batch_lines_s.nextval)
312: ,p_data_pump_business_grp_name
313: ,1373
314: ,'U'
315: ,p_user_sequence
666: decode(l.pval116,cn,vn,vn,vn,l.pval116) p116,
667: l.pval116 d116,
668: decode(l.pval117,cn,vn,vn,vn,l.pval117) p117,
669: l.pval117 d117
670: from hr_pump_batch_lines l
671: where l.batch_line_id = p_batch_line_id;
672: --
673: c cr%rowtype;
674: l_validate boolean := false;
687: open cr;
688: fetch cr into c;
689: if cr%notfound then
690: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
691: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
692: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
693: hr_utility.set_message_token('VALUE',p_batch_line_id);
694: hr_utility.raise_error;
695: end if;
873: else
874: c.p112 := 'FALSE';
875: end if;
876: --
877: update hr_pump_batch_lines l set
878: l.pval008 = decode(c.p8,null,cn,c.p8),
879: l.pval100 = decode(c.p100,null,cn,c.p100),
880: l.pval101 = decode(c.p101,null,cn,c.p101),
881: l.pval102 = decode(c.p102,null,cn,c.p102),