[Home] [Help]
157: ,P_SVR_ASSIGNMENT_USER_KEY 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
240: ,pval078
241: ,pval079)
242: values
243: (p_batch_id
244: ,nvl(blid,hr_pump_batch_lines_s.nextval)
245: ,p_data_pump_business_grp_name
246: ,1376
247: ,'U'
248: ,p_user_sequence
477: decode(l.pval078,cn,vn,vn,vh,l.pval078) p78,
478: l.pval078 d78,
479: decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
480: l.pval079 d79
481: from hr_pump_batch_lines l
482: where l.batch_line_id = p_batch_line_id;
483: --
484: c cr%rowtype;
485: l_validate boolean := false;
501: open cr;
502: fetch cr into c;
503: if cr%notfound then
504: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
505: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
506: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
507: hr_utility.set_message_token('VALUE',p_batch_line_id);
508: hr_utility.raise_error;
509: end if;
703: else
704: c.p70 := 'FALSE';
705: end if;
706: --
707: update hr_pump_batch_lines l set
708: l.pval061 = decode(c.p61,null,cn,c.p61),
709: l.pval062 = decode(c.p62,null,cn,c.p62),
710: l.pval063 = decode(c.p63,null,cn,c.p63),
711: l.pval064 = decode(c.p64,null,cn,c.p64),