[Home] [Help]
148: ,P_BENEFIT_GROUP in varchar2 default null) is
149: blid number := p_data_pump_batch_line_id;
150: begin
151: if blid is not null then
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
157: (batch_id
158: ,batch_line_id
159: ,business_group_name
160: ,api_module_id
229: ,pval073
230: ,pval074)
231: values
232: (p_batch_id
233: ,nvl(blid,hr_pump_batch_lines_s.nextval)
234: ,p_data_pump_business_grp_name
235: ,3860
236: ,'U'
237: ,p_user_sequence
452: decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
453: l.pval073 d73,
454: decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
455: l.pval074 d74
456: from hr_pump_batch_lines l
457: where l.batch_line_id = p_batch_line_id;
458: --
459: c cr%rowtype;
460: l_validate boolean := false;
470: open cr;
471: fetch cr into c;
472: if cr%notfound then
473: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
474: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
475: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
476: hr_utility.set_message_token('VALUE',p_batch_line_id);
477: hr_utility.raise_error;
478: end if;
597: else
598: c.p70 := 'FALSE';
599: end if;
600: --
601: update hr_pump_batch_lines l set
602: l.pval063 = decode(c.p63,null,cn,c.p63),
603: l.pval064 = decode(c.p64,null,cn,c.p64),
604: l.pval065 = decode(c.p65,null,cn,dc(c.p65)),
605: l.pval066 = decode(c.p66,null,cn,dc(c.p66)),