[Home] [Help]
120: ,P_PER_IN_LER_USER_KEY in varchar2) is
121: blid number := p_data_pump_batch_line_id;
122: begin
123: if blid is not null then
124: delete from hr_pump_batch_lines where batch_line_id = blid;
125: delete from hr_pump_batch_exceptions
126: where source_type = 'BATCH_LINE' and source_id = blid;
127: end if;
128: insert into hr_pump_batch_lines
124: delete from hr_pump_batch_lines where batch_line_id = blid;
125: delete from hr_pump_batch_exceptions
126: where source_type = 'BATCH_LINE' and source_id = blid;
127: end if;
128: insert into hr_pump_batch_lines
129: (batch_id
130: ,batch_line_id
131: ,business_group_name
132: ,api_module_id
173: ,pval041
174: ,pval042)
175: values
176: (p_batch_id
177: ,nvl(blid,hr_pump_batch_lines_s.nextval)
178: ,p_data_pump_business_grp_name
179: ,1009
180: ,'U'
181: ,p_user_sequence
303: l.pval040 d40,
304: decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
305: l.pval041 d41,
306: decode(l.pval042,cn,vn,l.pval042) p42
307: from hr_pump_batch_lines l
308: where l.batch_line_id = p_batch_line_id;
309: --
310: c cr%rowtype;
311: l_validate boolean := false;
323: open cr;
324: fetch cr into c;
325: if cr%notfound then
326: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
327: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
328: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
329: hr_utility.set_message_token('VALUE',p_batch_line_id);
330: hr_utility.raise_error;
331: end if;
428: hr_data_pump.api_trc_off;
429: --
430: iuk(p_batch_line_id,c.p1,L_PRTT_PREM_ID);
431: --
432: update hr_pump_batch_lines l set
433: l.pval001 = decode(c.p1,null,cn,c.p1),
434: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
435: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
436: l.pval036 = decode(c.p36,null,cn,c.p36)