[Home] [Help]
179: ,P_BENEFIT_GROUP in varchar2 default null) is
180: blid number := p_data_pump_batch_line_id;
181: begin
182: if blid is not null then
183: delete from hr_pump_batch_lines where batch_line_id = blid;
184: delete from hr_pump_batch_exceptions
185: where source_type = 'BATCH_LINE' and source_id = blid;
186: end if;
187: insert into hr_pump_batch_lines
183: delete from hr_pump_batch_lines where batch_line_id = blid;
184: delete from hr_pump_batch_exceptions
185: where source_type = 'BATCH_LINE' and source_id = blid;
186: end if;
187: insert into hr_pump_batch_lines
188: (batch_id
189: ,batch_line_id
190: ,business_group_name
191: ,api_module_id
291: ,pval107
292: ,pval108)
293: values
294: (p_batch_id
295: ,nvl(blid,hr_pump_batch_lines_s.nextval)
296: ,p_data_pump_business_grp_name
297: ,2910
298: ,'U'
299: ,p_user_sequence
618: decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
619: l.pval107 d107,
620: decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,
621: l.pval108 d108
622: from hr_pump_batch_lines l
623: where l.batch_line_id = p_batch_line_id;
624: --
625: c cr%rowtype;
626: l_validate boolean := false;
638: open cr;
639: fetch cr into c;
640: if cr%notfound then
641: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
642: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
643: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
644: hr_utility.set_message_token('VALUE',p_batch_line_id);
645: hr_utility.raise_error;
646: end if;
803: else
804: c.p104 := 'FALSE';
805: end if;
806: --
807: update hr_pump_batch_lines l set
808: l.pval003 = decode(c.p3,null,cn,c.p3),
809: l.pval092 = decode(c.p92,null,cn,c.p92),
810: l.pval093 = decode(c.p93,null,cn,c.p93),
811: l.pval094 = decode(c.p94,null,cn,c.p94),