[Home] [Help]
123: ,P_LANGUAGE_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: ,pval046
180: ,pval047)
181: values
182: (p_batch_id
183: ,nvl(blid,hr_pump_batch_lines_s.nextval)
184: ,p_data_pump_business_grp_name
185: ,1385
186: ,'U'
187: ,p_user_sequence
318: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
319: l.pval046 d46,
320: decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
321: l.pval047 d47
322: from hr_pump_batch_lines l
323: where l.batch_line_id = p_batch_line_id;
324: --
325: c cr%rowtype;
326: l_validate boolean := false;
335: open cr;
336: fetch cr into c;
337: if cr%notfound then
338: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
341: hr_utility.set_message_token('VALUE',p_batch_line_id);
342: hr_utility.raise_error;
343: end if;
427: hr_data_pump.api_trc_off;
428: --
429: iuk(p_batch_line_id,c.p36,L_PERSONAL_PAYMENT_METHOD_ID);
430: --
431: update hr_pump_batch_lines l set
432: l.pval036 = decode(c.p36,null,cn,c.p36),
433: l.pval037 = decode(c.p37,null,cn,c.p37),
434: l.pval038 = decode(c.p38,null,cn,c.p38),
435: l.pval039 = decode(c.p39,null,cn,dc(c.p39)),