[Home] [Help]
113: ,P_ELEMENT_ENTRY_USER_KEY in varchar2) is
114: blid number := p_data_pump_batch_line_id;
115: begin
116: if blid is not null then
117: delete from hr_pump_batch_lines where batch_line_id = blid;
118: delete from hr_pump_batch_exceptions
119: where source_type = 'BATCH_LINE' and source_id = blid;
120: end if;
121: insert into hr_pump_batch_lines
117: delete from hr_pump_batch_lines where batch_line_id = blid;
118: delete from hr_pump_batch_exceptions
119: where source_type = 'BATCH_LINE' and source_id = blid;
120: end if;
121: insert into hr_pump_batch_lines
122: (batch_id
123: ,batch_line_id
124: ,business_group_name
125: ,api_module_id
159: ,pval034
160: ,pval035)
161: values
162: (p_batch_id
163: ,nvl(blid,hr_pump_batch_lines_s.nextval)
164: ,p_data_pump_business_grp_name
165: ,2171
166: ,'U'
167: ,p_user_sequence
265: decode(l.pval032,cn,dn,d(l.pval032)) p32,
266: l.pval033 p33,
267: decode(l.pval034,cn,vn,l.pval034) p34,
268: decode(l.pval035,cn,vn,l.pval035) p35
269: from hr_pump_batch_lines l
270: where l.batch_line_id = p_batch_line_id;
271: --
272: c cr%rowtype;
273: l_validate boolean := false;
280: open cr;
281: fetch cr into c;
282: if cr%notfound then
283: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
284: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
285: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
286: hr_utility.set_message_token('VALUE',p_batch_line_id);
287: hr_utility.raise_error;
288: end if;
349: else
350: c.p33 := 'FALSE';
351: end if;
352: --
353: update hr_pump_batch_lines l set
354: l.pval031 = decode(c.p31,null,cn,dc(c.p31)),
355: l.pval032 = decode(c.p32,null,cn,dc(c.p32)),
356: l.pval033 = decode(c.p33,null,cn,c.p33)
357: where l.rowid = c.myrowid;