[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: ,1390
288: ,'U'
289: ,p_user_sequence
590: decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
591: l.pval102 d102,
592: decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
593: l.pval103 d103
594: from hr_pump_batch_lines l
595: where l.batch_line_id = p_batch_line_id;
596: --
597: c cr%rowtype;
598: l_validate boolean := false;
610: open cr;
611: fetch cr into c;
612: if cr%notfound then
613: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
614: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
615: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
616: hr_utility.set_message_token('VALUE',p_batch_line_id);
617: hr_utility.raise_error;
618: end if;
770: else
771: c.p99 := 'FALSE';
772: end if;
773: --
774: update hr_pump_batch_lines l set
775: l.pval004 = decode(c.p4,null,cn,c.p4),
776: l.pval087 = decode(c.p87,null,cn,c.p87),
777: l.pval088 = decode(c.p88,null,cn,c.p88),
778: l.pval089 = decode(c.p89,null,cn,c.p89),