[Home] [Help]
127: ,P_LEGISLATION_SUBGROUP in varchar2 default null) is
128: blid number := p_data_pump_batch_line_id;
129: begin
130: if blid is not null then
131: delete from hr_pump_batch_lines where batch_line_id = blid;
132: delete from hr_pump_batch_exceptions
133: where source_type = 'BATCH_LINE' and source_id = blid;
134: end if;
135: insert into hr_pump_batch_lines
131: delete from hr_pump_batch_lines where batch_line_id = blid;
132: delete from hr_pump_batch_exceptions
133: where source_type = 'BATCH_LINE' and source_id = blid;
134: end if;
135: insert into hr_pump_batch_lines
136: (batch_id
137: ,batch_line_id
138: ,business_group_name
139: ,api_module_id
187: ,pval049
188: ,pval050)
189: values
190: (p_batch_id
191: ,nvl(blid,hr_pump_batch_lines_s.nextval)
192: ,p_data_pump_business_grp_name
193: ,708
194: ,'U'
195: ,p_user_sequence
347: decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
348: l.pval049 d49,
349: decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
350: l.pval050 d50
351: from hr_pump_batch_lines l
352: where l.batch_line_id = p_batch_line_id;
353: --
354: c cr%rowtype;
355: l_validate boolean := false;
359: open cr;
360: fetch cr into c;
361: if cr%notfound then
362: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
363: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
364: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
365: hr_utility.set_message_token('VALUE',p_batch_line_id);
366: hr_utility.raise_error;
367: end if;
422: ,P_LEGISLATION_SUBGROUP => c.p50);
423: hr_data_pump.api_trc_off;
424:
425: --
426: update hr_pump_batch_lines l set
427: l.pval001 = decode(c.p1,null,cn,c.p1),
428: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
429: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
430: l.pval045 = decode(c.p45,null,cn,c.p45)