[Home] [Help]
175: ,P_VEHICLE_REPOSITORY_USER_KEY in varchar2) is
176: blid number := p_data_pump_batch_line_id;
177: begin
178: if blid is not null then
179: delete from hr_pump_batch_lines where batch_line_id = blid;
180: delete from hr_pump_batch_exceptions
181: where source_type = 'BATCH_LINE' and source_id = blid;
182: end if;
183: insert into hr_pump_batch_lines
179: delete from hr_pump_batch_lines where batch_line_id = blid;
180: delete from hr_pump_batch_exceptions
181: where source_type = 'BATCH_LINE' and source_id = blid;
182: end if;
183: insert into hr_pump_batch_lines
184: (batch_id
185: ,batch_line_id
186: ,business_group_name
187: ,api_module_id
269: ,pval079
270: ,pval082)
271: values
272: (p_batch_id
273: ,nvl(blid,hr_pump_batch_lines_s.nextval)
274: ,p_data_pump_business_grp_name
275: ,2895
276: ,'U'
277: ,p_user_sequence
526: l.pval079 d79,
527: decode(l.pval080,cn,dn,d(l.pval080)) p80,
528: decode(l.pval081,cn,dn,d(l.pval081)) p81,
529: decode(l.pval082,cn,vn,l.pval082) p82
530: from hr_pump_batch_lines l
531: where l.batch_line_id = p_batch_line_id;
532: --
533: c cr%rowtype;
534: l_validate boolean := false;
540: open cr;
541: fetch cr into c;
542: if cr%notfound then
543: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
544: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
545: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
546: hr_utility.set_message_token('VALUE',p_batch_line_id);
547: hr_utility.raise_error;
548: end if;
652: ,P_EFFECTIVE_END_DATE => c.p81);
653: hr_data_pump.api_trc_off;
654:
655: --
656: update hr_pump_batch_lines l set
657: l.pval080 = decode(c.p80,null,cn,dc(c.p80)),
658: l.pval081 = decode(c.p81,null,cn,dc(c.p81))
659: where l.rowid = c.myrowid;
660: --