[Home] [Help]
128: else
129: L_MULTI_ROW_ACTN := 'FALSE';
130: end if;
131: if blid is not null then
132: delete from hr_pump_batch_lines where batch_line_id = blid;
133: delete from hr_pump_batch_exceptions
134: where source_type = 'BATCH_LINE' and source_id = blid;
135: end if;
136: insert into hr_pump_batch_lines
132: delete from hr_pump_batch_lines where batch_line_id = blid;
133: delete from hr_pump_batch_exceptions
134: where source_type = 'BATCH_LINE' and source_id = blid;
135: end if;
136: insert into hr_pump_batch_lines
137: (batch_id
138: ,batch_line_id
139: ,business_group_name
140: ,api_module_id
174: ,pval031
175: ,pval032)
176: values
177: (p_batch_id
178: ,nvl(blid,hr_pump_batch_lines_s.nextval)
179: ,p_data_pump_business_grp_name
180: ,3847
181: ,'U'
182: ,p_user_sequence
268: decode(l.pval031,cn,vn,vn,vh,l.pval031) p31,
269: l.pval031 d31,
270: decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
271: l.pval032 d32
272: from hr_pump_batch_lines l
273: where l.batch_line_id = p_batch_line_id;
274: --
275: c cr%rowtype;
276: l_validate boolean := false;
289: open cr;
290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --
312: L_PERSON_ID :=