[Home] [Help]
182: ,P_BENEFIT_GROUP in varchar2 default null) is
183: blid number := p_data_pump_batch_line_id;
184: begin
185: if blid is not null then
186: delete from hr_pump_batch_lines where batch_line_id = blid;
187: delete from hr_pump_batch_exceptions
188: where source_type = 'BATCH_LINE' and source_id = blid;
189: end if;
190: insert into hr_pump_batch_lines
186: delete from hr_pump_batch_lines where batch_line_id = blid;
187: delete from hr_pump_batch_exceptions
188: where source_type = 'BATCH_LINE' and source_id = blid;
189: end if;
190: insert into hr_pump_batch_lines
191: (batch_id
192: ,batch_line_id
193: ,business_group_name
194: ,api_module_id
297: ,pval110
298: ,pval111)
299: values
300: (p_batch_id
301: ,nvl(blid,hr_pump_batch_lines_s.nextval)
302: ,p_data_pump_business_grp_name
303: ,3871
304: ,'U'
305: ,p_user_sequence
634: decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
635: l.pval110 d110,
636: decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
637: l.pval111 d111
638: from hr_pump_batch_lines l
639: where l.batch_line_id = p_batch_line_id;
640: --
641: c cr%rowtype;
642: l_validate boolean := false;
654: open cr;
655: fetch cr into c;
656: if cr%notfound then
657: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
658: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
659: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
660: hr_utility.set_message_token('VALUE',p_batch_line_id);
661: hr_utility.raise_error;
662: end if;
822: else
823: c.p107 := 'FALSE';
824: end if;
825: --
826: update hr_pump_batch_lines l set
827: l.pval003 = decode(c.p3,null,cn,c.p3),
828: l.pval095 = decode(c.p95,null,cn,c.p95),
829: l.pval096 = decode(c.p96,null,cn,c.p96),
830: l.pval097 = decode(c.p97,null,cn,c.p97),