[Home] [Help]
177: ,P_RATING_SCALE_NAME in varchar2 default null) is
178: blid number := p_data_pump_batch_line_id;
179: begin
180: if blid is not null then
181: delete from hr_pump_batch_lines where batch_line_id = blid;
182: delete from hr_pump_batch_exceptions
183: where source_type = 'BATCH_LINE' and source_id = blid;
184: end if;
185: insert into hr_pump_batch_lines
181: delete from hr_pump_batch_lines where batch_line_id = blid;
182: delete from hr_pump_batch_exceptions
183: where source_type = 'BATCH_LINE' and source_id = blid;
184: end if;
185: insert into hr_pump_batch_lines
186: (batch_id
187: ,batch_line_id
188: ,business_group_name
189: ,api_module_id
287: ,pval098
288: ,pval099)
289: values
290: (p_batch_id
291: ,nvl(blid,hr_pump_batch_lines_s.nextval)
292: ,p_data_pump_business_grp_name
293: ,1173
294: ,'U'
295: ,p_user_sequence
598: decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
599: l.pval098 d98,
600: decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
601: l.pval099 d99
602: from hr_pump_batch_lines l
603: where l.batch_line_id = p_batch_line_id;
604: --
605: c cr%rowtype;
606: l_validate boolean := false;
611: open cr;
612: fetch cr into c;
613: if cr%notfound then
614: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
615: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
616: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
617: hr_utility.set_message_token('VALUE',p_batch_line_id);
618: hr_utility.raise_error;
619: end if;
729: ,P_INFORMATION20 => c.p98);
730: hr_data_pump.api_trc_off;
731:
732: --
733: update hr_pump_batch_lines l set
734: l.pval064 = decode(c.p64,null,cn,c.p64),
735: l.pval065 = decode(c.p65,null,cn,c.p65),
736: l.pval066 = decode(c.p66,null,cn,c.p66),
737: l.pval067 = decode(c.p67,null,cn,c.p67)