[Home] [Help]
113: ,P_EXT_EFFORT_LINE_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
158: ,pval030
159: ,pval032)
160: values
161: (p_batch_id
162: ,nvl(blid,hr_pump_batch_lines_s.nextval)
163: ,p_data_pump_business_grp_name
164: ,3800
165: ,'U'
166: ,p_user_sequence
263: l.pval029 d29,
264: decode(l.pval030,cn,nn,n(l.pval030)) p30,
265: l.pval031 p31,
266: decode(l.pval032,cn,vn,l.pval032) p32
267: from hr_pump_batch_lines l
268: where l.batch_line_id = p_batch_line_id;
269: --
270: c cr%rowtype;
271: l_validate boolean := false;
277: open cr;
278: fetch cr into c;
279: if cr%notfound then
280: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
281: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
282: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
283: hr_utility.set_message_token('VALUE',p_batch_line_id);
284: hr_utility.raise_error;
285: end if;
335: else
336: c.p31 := 'FALSE';
337: end if;
338: --
339: update hr_pump_batch_lines l set
340: l.pval030 = decode(c.p30,null,cn,c.p30),
341: l.pval031 = decode(c.p31,null,cn,c.p31)
342: where l.rowid = c.myrowid;
343: --