[Home] [Help]
131: ,P_PLAN_TYPE in varchar2) is
132: blid number := p_data_pump_batch_line_id;
133: begin
134: if blid is not null then
135: delete from hr_pump_batch_lines where batch_line_id = blid;
136: delete from hr_pump_batch_exceptions
137: where source_type = 'BATCH_LINE' and source_id = blid;
138: end if;
139: insert into hr_pump_batch_lines
135: delete from hr_pump_batch_lines where batch_line_id = blid;
136: delete from hr_pump_batch_exceptions
137: where source_type = 'BATCH_LINE' and source_id = blid;
138: end if;
139: insert into hr_pump_batch_lines
140: (batch_id
141: ,batch_line_id
142: ,business_group_name
143: ,api_module_id
193: ,pval049
194: ,pval050)
195: values
196: (p_batch_id
197: ,nvl(blid,hr_pump_batch_lines_s.nextval)
198: ,p_data_pump_business_grp_name
199: ,710
200: ,'U'
201: ,p_user_sequence
355: l.pval048 d48,
356: decode(l.pval049,cn,vn,vn,vh,l.pval049) p49,
357: l.pval049 d49,
358: decode(l.pval050,cn,vn,l.pval050) p50
359: from hr_pump_batch_lines l
360: where l.batch_line_id = p_batch_line_id;
361: --
362: c cr%rowtype;
363: l_validate boolean := false;
369: open cr;
370: fetch cr into c;
371: if cr%notfound then
372: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
375: hr_utility.set_message_token('VALUE',p_batch_line_id);
376: hr_utility.raise_error;
377: end if;
455: ,P_LEGISLATION_SUBGROUP => c.p49);
456: hr_data_pump.api_trc_off;
457:
458: --
459: update hr_pump_batch_lines l set
460: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
461: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
462: where l.rowid = c.myrowid;
463: --