[Home] [Help]
150: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
151: blid number := p_data_pump_batch_line_id;
152: begin
153: if blid is not null then
154: delete from hr_pump_batch_lines where batch_line_id = blid;
155: delete from hr_pump_batch_exceptions
156: where source_type = 'BATCH_LINE' and source_id = blid;
157: end if;
158: insert into hr_pump_batch_lines
154: delete from hr_pump_batch_lines where batch_line_id = blid;
155: delete from hr_pump_batch_exceptions
156: where source_type = 'BATCH_LINE' and source_id = blid;
157: end if;
158: insert into hr_pump_batch_lines
159: (batch_id
160: ,batch_line_id
161: ,business_group_name
162: ,api_module_id
228: ,pval072
229: ,pval073)
230: values
231: (p_batch_id
232: ,nvl(blid,hr_pump_batch_lines_s.nextval)
233: ,p_data_pump_business_grp_name
234: ,3216
235: ,'U'
236: ,p_user_sequence
445: decode(l.pval072,cn,vn,vn,vh,l.pval072) p72,
446: l.pval072 d72,
447: decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
448: l.pval073 d73
449: from hr_pump_batch_lines l
450: where l.batch_line_id = p_batch_line_id;
451: --
452: c cr%rowtype;
453: l_validate boolean := false;
474: open cr;
475: fetch cr into c;
476: if cr%notfound then
477: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
478: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
479: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
480: hr_utility.set_message_token('VALUE',p_batch_line_id);
481: hr_utility.raise_error;
482: end if;
720: else
721: c.p60 := 'FALSE';
722: end if;
723: --
724: update hr_pump_batch_lines l set
725: l.pval052 = decode(c.p52,null,cn,c.p52),
726: l.pval053 = decode(c.p53,null,cn,dc(c.p53)),
727: l.pval054 = decode(c.p54,null,cn,dc(c.p54)),
728: l.pval055 = decode(c.p55,null,cn,c.p55),