[Home] [Help]
180: ,P_BENEFIT_GROUP in varchar2 default null) is
181: blid number := p_data_pump_batch_line_id;
182: begin
183: if blid is not null then
184: delete from hr_pump_batch_lines where batch_line_id = blid;
185: delete from hr_pump_batch_exceptions
186: where source_type = 'BATCH_LINE' and source_id = blid;
187: end if;
188: insert into hr_pump_batch_lines
184: delete from hr_pump_batch_lines where batch_line_id = blid;
185: delete from hr_pump_batch_exceptions
186: where source_type = 'BATCH_LINE' and source_id = blid;
187: end if;
188: insert into hr_pump_batch_lines
189: (batch_id
190: ,batch_line_id
191: ,business_group_name
192: ,api_module_id
293: ,pval109
294: ,pval110)
295: values
296: (p_batch_id
297: ,nvl(blid,hr_pump_batch_lines_s.nextval)
298: ,p_data_pump_business_grp_name
299: ,2160
300: ,'U'
301: ,p_user_sequence
624: decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
625: l.pval109 d109,
626: decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
627: l.pval110 d110
628: from hr_pump_batch_lines l
629: where l.batch_line_id = p_batch_line_id;
630: --
631: c cr%rowtype;
632: l_validate boolean := false;
645: open cr;
646: fetch cr into c;
647: if cr%notfound then
648: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
649: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
650: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
651: hr_utility.set_message_token('VALUE',p_batch_line_id);
652: hr_utility.raise_error;
653: end if;
824: else
825: c.p105 := 'FALSE';
826: end if;
827: --
828: update hr_pump_batch_lines l set
829: l.pval008 = decode(c.p8,null,cn,c.p8),
830: l.pval093 = decode(c.p93,null,cn,c.p93),
831: l.pval094 = decode(c.p94,null,cn,c.p94),
832: l.pval095 = decode(c.p95,null,cn,c.p95),