[Home] [Help]
112: ,P_EXT_EFFORT_LINES_USER_KEY in varchar2) is
113: blid number := p_data_pump_batch_line_id;
114: begin
115: if blid is not null then
116: delete from hr_pump_batch_lines where batch_line_id = blid;
117: delete from hr_pump_batch_exceptions
118: where source_type = 'BATCH_LINE' and source_id = blid;
119: end if;
120: insert into hr_pump_batch_lines
116: delete from hr_pump_batch_lines where batch_line_id = blid;
117: delete from hr_pump_batch_exceptions
118: where source_type = 'BATCH_LINE' and source_id = blid;
119: end if;
120: insert into hr_pump_batch_lines
121: (batch_id
122: ,batch_line_id
123: ,business_group_name
124: ,api_module_id
157: ,pval030
158: ,pval031)
159: values
160: (p_batch_id
161: ,nvl(blid,hr_pump_batch_lines_s.nextval)
162: ,p_data_pump_business_grp_name
163: ,3795
164: ,'U'
165: ,p_user_sequence
255: l.pval029 d29,
256: decode(l.pval030,cn,nn,n(l.pval030)) p30,
257: l.pval031 p31,
258: l.pval032 p32
259: from hr_pump_batch_lines l
260: where l.batch_line_id = p_batch_line_id;
261: --
262: c cr%rowtype;
263: l_validate boolean := false;
269: open cr;
270: fetch cr into c;
271: if cr%notfound then
272: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
273: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
274: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
275: hr_utility.set_message_token('VALUE',p_batch_line_id);
276: hr_utility.raise_error;
277: end if;
321: else
322: c.p32 := 'FALSE';
323: end if;
324: --
325: update hr_pump_batch_lines l set
326: l.pval030 = decode(c.p30,null,cn,c.p30),
327: l.pval031 = decode(c.p31,null,cn,c.p31),
328: l.pval032 = decode(c.p32,null,cn,c.p32)
329: where l.rowid = c.myrowid;