[Home] [Help]
183: ,P_RATING_SCALE_NAME in varchar2 default null) is
184: blid number := p_data_pump_batch_line_id;
185: begin
186: if blid is not null then
187: delete from hr_pump_batch_lines where batch_line_id = blid;
188: delete from hr_pump_batch_exceptions
189: where source_type = 'BATCH_LINE' and source_id = blid;
190: end if;
191: insert into hr_pump_batch_lines
187: delete from hr_pump_batch_lines where batch_line_id = blid;
188: delete from hr_pump_batch_exceptions
189: where source_type = 'BATCH_LINE' and source_id = blid;
190: end if;
191: insert into hr_pump_batch_lines
192: (batch_id
193: ,batch_line_id
194: ,business_group_name
195: ,api_module_id
294: ,pval097
295: ,pval098)
296: values
297: (p_batch_id
298: ,nvl(blid,hr_pump_batch_lines_s.nextval)
299: ,p_data_pump_business_grp_name
300: ,1174
301: ,'U'
302: ,p_user_sequence
606: l.pval096 d96,
607: decode(l.pval097,cn,vn,l.pval097) p97,
608: decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
609: l.pval098 d98
610: from hr_pump_batch_lines l
611: where l.batch_line_id = p_batch_line_id;
612: --
613: c cr%rowtype;
614: l_validate boolean := false;
621: open cr;
622: fetch cr into c;
623: if cr%notfound then
624: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
625: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
626: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
627: hr_utility.set_message_token('VALUE',p_batch_line_id);
628: hr_utility.raise_error;
629: end if;
750: ,P_INFORMATION20 => c.p96);
751: hr_data_pump.api_trc_off;
752:
753: --
754: update hr_pump_batch_lines l set
755: l.pval003 = decode(c.p3,null,cn,c.p3),
756: l.pval065 = decode(c.p65,null,cn,c.p65)
757: where l.rowid = c.myrowid;
758: --