[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: ,1372
314: ,'U'
315: ,p_user_sequence
663: decode(l.pval116,cn,vn,vn,vn,l.pval116) p116,
664: l.pval116 d116,
665: decode(l.pval117,cn,vn,vn,vn,l.pval117) p117,
666: l.pval117 d117
667: from hr_pump_batch_lines l
668: where l.batch_line_id = p_batch_line_id;
669: --
670: c cr%rowtype;
671: l_validate boolean := false;
684: open cr;
685: fetch cr into c;
686: if cr%notfound then
687: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
688: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
689: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
690: hr_utility.set_message_token('VALUE',p_batch_line_id);
691: hr_utility.raise_error;
692: end if;
870: else
871: c.p112 := 'FALSE';
872: end if;
873: --
874: update hr_pump_batch_lines l set
875: l.pval008 = decode(c.p8,null,cn,c.p8),
876: l.pval100 = decode(c.p100,null,cn,c.p100),
877: l.pval101 = decode(c.p101,null,cn,c.p101),
878: l.pval102 = decode(c.p102,null,cn,c.p102),