[Home] [Help]
123: ,P_PER_IN_LER_USER_KEY in varchar2) is
124: blid number := p_data_pump_batch_line_id;
125: begin
126: if blid is not null then
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
132: (batch_id
133: ,batch_line_id
134: ,business_group_name
135: ,api_module_id
177: ,pval041
178: ,pval042)
179: values
180: (p_batch_id
181: ,nvl(blid,hr_pump_batch_lines_s.nextval)
182: ,p_data_pump_business_grp_name
183: ,1012
184: ,'U'
185: ,p_user_sequence
308: l.pval040 d40,
309: decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
310: l.pval041 d41,
311: decode(l.pval042,cn,vn,l.pval042) p42
312: from hr_pump_batch_lines l
313: where l.batch_line_id = p_batch_line_id;
314: --
315: c cr%rowtype;
316: l_validate boolean := false;
329: open cr;
330: fetch cr into c;
331: if cr%notfound then
332: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
333: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
334: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
335: hr_utility.set_message_token('VALUE',p_batch_line_id);
336: hr_utility.raise_error;
337: end if;
458: ,P_DATETRACK_MODE => c.p37);
459: hr_data_pump.api_trc_off;
460:
461: --
462: update hr_pump_batch_lines l set
463: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
464: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
465: where l.rowid = c.myrowid;
466: --