[Home] [Help]
157: ,P_LOCATION_CODE in varchar2 default null) is
158: blid number := p_data_pump_batch_line_id;
159: begin
160: if blid is not null then
161: delete from hr_pump_batch_lines where batch_line_id = blid;
162: delete from hr_pump_batch_exceptions
163: where source_type = 'BATCH_LINE' and source_id = blid;
164: end if;
165: insert into hr_pump_batch_lines
161: delete from hr_pump_batch_lines where batch_line_id = blid;
162: delete from hr_pump_batch_exceptions
163: where source_type = 'BATCH_LINE' and source_id = blid;
164: end if;
165: insert into hr_pump_batch_lines
166: (batch_id
167: ,batch_line_id
168: ,business_group_name
169: ,api_module_id
245: ,pval074
246: ,pval075)
247: values
248: (p_batch_id
249: ,nvl(blid,hr_pump_batch_lines_s.nextval)
250: ,p_data_pump_business_grp_name
251: ,2206
252: ,'U'
253: ,p_user_sequence
478: decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
479: l.pval074 d74,
480: decode(l.pval075,cn,vn,vn,vh,l.pval075) p75,
481: l.pval075 d75
482: from hr_pump_batch_lines l
483: where l.batch_line_id = p_batch_line_id;
484: --
485: c cr%rowtype;
486: l_validate boolean := false;
495: open cr;
496: fetch cr into c;
497: if cr%notfound then
498: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
499: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
500: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
501: hr_utility.set_message_token('VALUE',p_batch_line_id);
502: hr_utility.raise_error;
503: end if;
635: else
636: c.p72 := 'FALSE';
637: end if;
638: --
639: update hr_pump_batch_lines l set
640: l.pval072 = decode(c.p72,null,cn,c.p72)
641: where l.rowid = c.myrowid;
642: --
643: close cr;