[Home] [Help]
186: ,P_BENEFIT_GROUP in varchar2 default null) is
187: blid number := p_data_pump_batch_line_id;
188: begin
189: if blid is not null then
190: delete from hr_pump_batch_lines where batch_line_id = blid;
191: delete from hr_pump_batch_exceptions
192: where source_type = 'BATCH_LINE' and source_id = blid;
193: end if;
194: insert into hr_pump_batch_lines
190: delete from hr_pump_batch_lines where batch_line_id = blid;
191: delete from hr_pump_batch_exceptions
192: where source_type = 'BATCH_LINE' and source_id = blid;
193: end if;
194: insert into hr_pump_batch_lines
195: (batch_id
196: ,batch_line_id
197: ,business_group_name
198: ,api_module_id
305: ,pval114
306: ,pval115)
307: values
308: (p_batch_id
309: ,nvl(blid,hr_pump_batch_lines_s.nextval)
310: ,p_data_pump_business_grp_name
311: ,3873
312: ,'U'
313: ,p_user_sequence
654: decode(l.pval114,cn,vn,vn,vn,l.pval114) p114,
655: l.pval114 d114,
656: decode(l.pval115,cn,vn,vn,vn,l.pval115) p115,
657: l.pval115 d115
658: from hr_pump_batch_lines l
659: where l.batch_line_id = p_batch_line_id;
660: --
661: c cr%rowtype;
662: l_validate boolean := false;
673: open cr;
674: fetch cr into c;
675: if cr%notfound then
676: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
677: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
678: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
679: hr_utility.set_message_token('VALUE',p_batch_line_id);
680: hr_utility.raise_error;
681: end if;
845: else
846: c.p110 := 'FALSE';
847: end if;
848: --
849: update hr_pump_batch_lines l set
850: l.pval003 = decode(c.p3,null,cn,c.p3),
851: l.pval099 = decode(c.p99,null,cn,c.p99),
852: l.pval100 = decode(c.p100,null,cn,c.p100),
853: l.pval101 = decode(c.p101,null,cn,dc(c.p101)),