[Home] [Help]
191: ,P_BENEFIT_GROUP in varchar2 default null) is
192: blid number := p_data_pump_batch_line_id;
193: begin
194: if blid is not null then
195: delete from hr_pump_batch_lines where batch_line_id = blid;
196: delete from hr_pump_batch_exceptions
197: where source_type = 'BATCH_LINE' and source_id = blid;
198: end if;
199: insert into hr_pump_batch_lines
195: delete from hr_pump_batch_lines where batch_line_id = blid;
196: delete from hr_pump_batch_exceptions
197: where source_type = 'BATCH_LINE' and source_id = blid;
198: end if;
199: insert into hr_pump_batch_lines
200: (batch_id
201: ,batch_line_id
202: ,business_group_name
203: ,api_module_id
315: ,pval120
316: ,pval121)
317: values
318: (p_batch_id
319: ,nvl(blid,hr_pump_batch_lines_s.nextval)
320: ,p_data_pump_business_grp_name
321: ,2903
322: ,'U'
323: ,p_user_sequence
684: decode(l.pval120,cn,vn,vn,vn,l.pval120) p120,
685: l.pval120 d120,
686: decode(l.pval121,cn,vn,vn,vn,l.pval121) p121,
687: l.pval121 d121
688: from hr_pump_batch_lines l
689: where l.batch_line_id = p_batch_line_id;
690: --
691: c cr%rowtype;
692: l_validate boolean := false;
705: open cr;
706: fetch cr into c;
707: if cr%notfound then
708: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
709: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
710: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
711: hr_utility.set_message_token('VALUE',p_batch_line_id);
712: hr_utility.raise_error;
713: end if;
895: else
896: c.p116 := 'FALSE';
897: end if;
898: --
899: update hr_pump_batch_lines l set
900: l.pval008 = decode(c.p8,null,cn,c.p8),
901: l.pval104 = decode(c.p104,null,cn,c.p104),
902: l.pval105 = decode(c.p105,null,cn,c.p105),
903: l.pval106 = decode(c.p106,null,cn,c.p106),