[Home] [Help]
123: ,P_LOCATION_CODE in varchar2 default null) 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
179: ,pval041
180: ,pval044)
181: values
182: (p_batch_id
183: ,nvl(blid,hr_pump_batch_lines_s.nextval)
184: ,p_data_pump_business_grp_name
185: ,2205
186: ,'U'
187: ,p_user_sequence
316: l.pval042 p42,
317: l.pval043 p43,
318: decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
319: l.pval044 d44
320: from hr_pump_batch_lines l
321: where l.batch_line_id = p_batch_line_id;
322: --
323: c cr%rowtype;
324: l_validate boolean := false;
331: open cr;
332: fetch cr into c;
333: if cr%notfound then
334: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
335: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
336: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
337: hr_utility.set_message_token('VALUE',p_batch_line_id);
338: hr_utility.raise_error;
339: end if;
406: else
407: c.p43 := 'FALSE';
408: end if;
409: --
410: update hr_pump_batch_lines l set
411: l.pval041 = decode(c.p41,null,cn,c.p41),
412: l.pval042 = decode(c.p42,null,cn,c.p42),
413: l.pval043 = decode(c.p43,null,cn,c.p43)
414: where l.rowid = c.myrowid;