[Home] [Help]
268: ,P_LANGUAGE_CODE in varchar2 default null) is
269: blid number := p_data_pump_batch_line_id;
270: begin
271: if blid is not null then
272: delete from hr_pump_batch_lines where batch_line_id = blid;
273: delete from hr_pump_batch_exceptions
274: where source_type = 'BATCH_LINE' and source_id = blid;
275: end if;
276: insert into hr_pump_batch_lines
272: delete from hr_pump_batch_lines where batch_line_id = blid;
273: delete from hr_pump_batch_exceptions
274: where source_type = 'BATCH_LINE' and source_id = blid;
275: end if;
276: insert into hr_pump_batch_lines
277: (batch_id
278: ,batch_line_id
279: ,business_group_name
280: ,api_module_id
469: ,pval195
470: ,pval196)
471: values
472: (p_batch_id
473: ,nvl(blid,hr_pump_batch_lines_s.nextval)
474: ,p_data_pump_business_grp_name
475: ,1238
476: ,'U'
477: ,p_user_sequence
1063: decode(l.pval195,cn,vn,vn,vn,l.pval195) p195,
1064: l.pval195 d195,
1065: decode(l.pval196,cn,vn,vn,vn,l.pval196) p196,
1066: l.pval196 d196
1067: from hr_pump_batch_lines l
1068: where l.batch_line_id = p_batch_line_id;
1069: --
1070: c cr%rowtype;
1071: l_validate boolean := false;
1083: open cr;
1084: fetch cr into c;
1085: if cr%notfound then
1086: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
1087: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
1088: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
1089: hr_utility.set_message_token('VALUE',p_batch_line_id);
1090: hr_utility.raise_error;
1091: end if;
1353: else
1354: c.p190 := 'FALSE';
1355: end if;
1356: --
1357: update hr_pump_batch_lines l set
1358: l.pval181 = decode(c.p181,null,cn,c.p181),
1359: l.pval182 = decode(c.p182,null,cn,c.p182),
1360: l.pval183 = decode(c.p183,null,cn,c.p183),
1361: l.pval184 = decode(c.p184,null,cn,c.p184),