[Home] [Help]
205: ,P_BENEFIT_GROUP in varchar2 default null) is
206: blid number := p_data_pump_batch_line_id;
207: begin
208: if blid is not null then
209: delete from hr_pump_batch_lines where batch_line_id = blid;
210: delete from hr_pump_batch_exceptions
211: where source_type = 'BATCH_LINE' and source_id = blid;
212: end if;
213: insert into hr_pump_batch_lines
209: delete from hr_pump_batch_lines where batch_line_id = blid;
210: delete from hr_pump_batch_exceptions
211: where source_type = 'BATCH_LINE' and source_id = blid;
212: end if;
213: insert into hr_pump_batch_lines
214: (batch_id
215: ,batch_line_id
216: ,business_group_name
217: ,api_module_id
327: ,pval114
328: ,pval115)
329: values
330: (p_batch_id
331: ,nvl(blid,hr_pump_batch_lines_s.nextval)
332: ,p_data_pump_business_grp_name
333: ,3866
334: ,'U'
335: ,p_user_sequence
681: decode(l.pval114,cn,vn,vn,vh,l.pval114) p114,
682: l.pval114 d114,
683: decode(l.pval115,cn,vn,vn,vh,l.pval115) p115,
684: l.pval115 d115
685: from hr_pump_batch_lines l
686: where l.batch_line_id = p_batch_line_id;
687: --
688: c cr%rowtype;
689: l_validate boolean := false;
702: open cr;
703: fetch cr into c;
704: if cr%notfound then
705: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
706: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
707: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
708: hr_utility.set_message_token('VALUE',p_batch_line_id);
709: hr_utility.raise_error;
710: end if;
909: else
910: c.p109 := 'FALSE';
911: end if;
912: --
913: update hr_pump_batch_lines l set
914: l.pval009 = decode(c.p9,null,cn,c.p9),
915: l.pval103 = decode(c.p103,null,cn,dc(c.p103)),
916: l.pval104 = decode(c.p104,null,cn,dc(c.p104)),
917: l.pval105 = decode(c.p105,null,cn,c.p105),