[Home] [Help]
188: ,P_CON_SEG_USER_NAME in varchar2) is
189: blid number := p_data_pump_batch_line_id;
190: begin
191: if blid is not null then
192: delete from hr_pump_batch_lines where batch_line_id = blid;
193: delete from hr_pump_batch_exceptions
194: where source_type = 'BATCH_LINE' and source_id = blid;
195: end if;
196: insert into hr_pump_batch_lines
192: delete from hr_pump_batch_lines where batch_line_id = blid;
193: delete from hr_pump_batch_exceptions
194: where source_type = 'BATCH_LINE' and source_id = blid;
195: end if;
196: insert into hr_pump_batch_lines
197: (batch_id
198: ,batch_line_id
199: ,business_group_name
200: ,api_module_id
303: ,pval109
304: ,pval110)
305: values
306: (p_batch_id
307: ,nvl(blid,hr_pump_batch_lines_s.nextval)
308: ,p_data_pump_business_grp_name
309: ,3858
310: ,'U'
311: ,p_user_sequence
637: l.pval108 d108,
638: decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
639: l.pval109 d109,
640: decode(l.pval110,cn,vn,l.pval110) p110
641: from hr_pump_batch_lines l
642: where l.batch_line_id = p_batch_line_id;
643: --
644: c cr%rowtype;
645: l_validate boolean := false;
667: open cr;
668: fetch cr into c;
669: if cr%notfound then
670: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
671: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
672: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
673: hr_utility.set_message_token('VALUE',p_batch_line_id);
674: hr_utility.raise_error;
675: end if;
968: else
969: c.p94 := 'FALSE';
970: end if;
971: --
972: update hr_pump_batch_lines l set
973: l.pval086 = decode(c.p86,null,cn,c.p86),
974: l.pval087 = decode(c.p87,null,cn,c.p87),
975: l.pval088 = decode(c.p88,null,cn,c.p88),
976: l.pval089 = decode(c.p89,null,cn,c.p89),