[Home] [Help]
210: ,P_BENEFIT_GROUP in varchar2 default null) is
211: blid number := p_data_pump_batch_line_id;
212: begin
213: if blid is not null then
214: delete from hr_pump_batch_lines where batch_line_id = blid;
215: delete from hr_pump_batch_exceptions
216: where source_type = 'BATCH_LINE' and source_id = blid;
217: end if;
218: insert into hr_pump_batch_lines
214: delete from hr_pump_batch_lines where batch_line_id = blid;
215: delete from hr_pump_batch_exceptions
216: where source_type = 'BATCH_LINE' and source_id = blid;
217: end if;
218: insert into hr_pump_batch_lines
219: (batch_id
220: ,batch_line_id
221: ,business_group_name
222: ,api_module_id
337: ,pval119
338: ,pval120)
339: values
340: (p_batch_id
341: ,nvl(blid,hr_pump_batch_lines_s.nextval)
342: ,p_data_pump_business_grp_name
343: ,3208
344: ,'U'
345: ,p_user_sequence
708: decode(l.pval119,cn,vn,vn,vh,l.pval119) p119,
709: l.pval119 d119,
710: decode(l.pval120,cn,vn,vn,vh,l.pval120) p120,
711: l.pval120 d120
712: from hr_pump_batch_lines l
713: where l.batch_line_id = p_batch_line_id;
714: --
715: c cr%rowtype;
716: l_validate boolean := false;
729: open cr;
730: fetch cr into c;
731: if cr%notfound then
732: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
733: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
734: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
735: hr_utility.set_message_token('VALUE',p_batch_line_id);
736: hr_utility.raise_error;
737: end if;
941: else
942: c.p114 := 'FALSE';
943: end if;
944: --
945: update hr_pump_batch_lines l set
946: l.pval009 = decode(c.p9,null,cn,c.p9),
947: l.pval108 = decode(c.p108,null,cn,dc(c.p108)),
948: l.pval109 = decode(c.p109,null,cn,dc(c.p109)),
949: l.pval110 = decode(c.p110,null,cn,c.p110),