[Home] [Help]
108: ,P_ASSIGNMENT_USER_KEY in varchar2) is
109: blid number := p_data_pump_batch_line_id;
110: begin
111: if blid is not null then
112: delete from hr_pump_batch_lines where batch_line_id = blid;
113: delete from hr_pump_batch_exceptions
114: where source_type = 'BATCH_LINE' and source_id = blid;
115: end if;
116: insert into hr_pump_batch_lines
112: delete from hr_pump_batch_lines where batch_line_id = blid;
113: delete from hr_pump_batch_exceptions
114: where source_type = 'BATCH_LINE' and source_id = blid;
115: end if;
116: insert into hr_pump_batch_lines
117: (batch_id
118: ,batch_line_id
119: ,business_group_name
120: ,api_module_id
149: ,pval026
150: ,pval028)
151: values
152: (p_batch_id
153: ,nvl(blid,hr_pump_batch_lines_s.nextval)
154: ,p_data_pump_business_grp_name
155: ,2168
156: ,'U'
157: ,p_user_sequence
240: hr_pump_get.gl(l.pval026,'YES_NO',dn,vn)) p26,
241: l.pval026 d26,
242: l.pval027 p27,
243: decode(l.pval028,cn,vn,l.pval028) p28
244: from hr_pump_batch_lines l
245: where l.batch_line_id = p_batch_line_id;
246: --
247: c cr%rowtype;
248: l_validate boolean := false;
254: open cr;
255: fetch cr into c;
256: if cr%notfound then
257: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
258: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
259: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
260: hr_utility.set_message_token('VALUE',p_batch_line_id);
261: hr_utility.raise_error;
262: end if;
308: else
309: c.p27 := 'FALSE';
310: end if;
311: --
312: update hr_pump_batch_lines l set
313: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
314: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
315: l.pval027 = decode(c.p27,null,cn,c.p27)
316: where l.rowid = c.myrowid;