[Home] [Help]
178: ,P_BENEFIT_GROUP in varchar2 default null) is
179: blid number := p_data_pump_batch_line_id;
180: begin
181: if blid is not null then
182: delete from hr_pump_batch_lines where batch_line_id = blid;
183: delete from hr_pump_batch_exceptions
184: where source_type = 'BATCH_LINE' and source_id = blid;
185: end if;
186: insert into hr_pump_batch_lines
182: delete from hr_pump_batch_lines where batch_line_id = blid;
183: delete from hr_pump_batch_exceptions
184: where source_type = 'BATCH_LINE' and source_id = blid;
185: end if;
186: insert into hr_pump_batch_lines
187: (batch_id
188: ,batch_line_id
189: ,business_group_name
190: ,api_module_id
289: ,pval103
290: ,pval104)
291: values
292: (p_batch_id
293: ,nvl(blid,hr_pump_batch_lines_s.nextval)
294: ,p_data_pump_business_grp_name
295: ,1351
296: ,'U'
297: ,p_user_sequence
602: decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
603: l.pval103 d103,
604: decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
605: l.pval104 d104
606: from hr_pump_batch_lines l
607: where l.batch_line_id = p_batch_line_id;
608: --
609: c cr%rowtype;
610: l_validate boolean := false;
620: open cr;
621: fetch cr into c;
622: if cr%notfound then
623: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
624: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
625: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
626: hr_utility.set_message_token('VALUE',p_batch_line_id);
627: hr_utility.raise_error;
628: end if;
777: else
778: c.p100 := 'FALSE';
779: end if;
780: --
781: update hr_pump_batch_lines l set
782: l.pval093 = decode(c.p93,null,cn,c.p93),
783: l.pval094 = decode(c.p94,null,cn,c.p94),
784: l.pval095 = decode(c.p95,null,cn,dc(c.p95)),
785: l.pval096 = decode(c.p96,null,cn,dc(c.p96)),