[Home] [Help]
174: ,P_BENEFIT_GROUP in varchar2 default null) is
175: blid number := p_data_pump_batch_line_id;
176: begin
177: if blid is not null then
178: delete from hr_pump_batch_lines where batch_line_id = blid;
179: delete from hr_pump_batch_exceptions
180: where source_type = 'BATCH_LINE' and source_id = blid;
181: end if;
182: insert into hr_pump_batch_lines
178: delete from hr_pump_batch_lines where batch_line_id = blid;
179: delete from hr_pump_batch_exceptions
180: where source_type = 'BATCH_LINE' and source_id = blid;
181: end if;
182: insert into hr_pump_batch_lines
183: (batch_id
184: ,batch_line_id
185: ,business_group_name
186: ,api_module_id
281: ,pval102
282: ,pval103)
283: values
284: (p_batch_id
285: ,nvl(blid,hr_pump_batch_lines_s.nextval)
286: ,p_data_pump_business_grp_name
287: ,1391
288: ,'U'
289: ,p_user_sequence
592: decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
593: l.pval102 d102,
594: decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
595: l.pval103 d103
596: from hr_pump_batch_lines l
597: where l.batch_line_id = p_batch_line_id;
598: --
599: c cr%rowtype;
600: l_validate boolean := false;
612: open cr;
613: fetch cr into c;
614: if cr%notfound then
615: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
616: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
617: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
618: hr_utility.set_message_token('VALUE',p_batch_line_id);
619: hr_utility.raise_error;
620: end if;
772: else
773: c.p99 := 'FALSE';
774: end if;
775: --
776: update hr_pump_batch_lines l set
777: l.pval004 = decode(c.p4,null,cn,c.p4),
778: l.pval087 = decode(c.p87,null,cn,c.p87),
779: l.pval088 = decode(c.p88,null,cn,c.p88),
780: l.pval089 = decode(c.p89,null,cn,c.p89),