[Home] [Help]
210: ,P_CAGR_NAME in varchar2 default null) is
211: blid number := p_data_pump_batch_line_id;
212: begin
213: if blid is not null then
214: delete from hr_pump_batch_lines where batch_line_id = blid;
215: delete from hr_pump_batch_exceptions
216: where source_type = 'BATCH_LINE' and source_id = blid;
217: end if;
218: insert into hr_pump_batch_lines
214: delete from hr_pump_batch_lines where batch_line_id = blid;
215: delete from hr_pump_batch_exceptions
216: where source_type = 'BATCH_LINE' and source_id = blid;
217: end if;
218: insert into hr_pump_batch_lines
219: (batch_id
220: ,batch_line_id
221: ,business_group_name
222: ,api_module_id
353: ,pval140
354: ,pval141)
355: values
356: (p_batch_id
357: ,nvl(blid,hr_pump_batch_lines_s.nextval)
358: ,p_data_pump_business_grp_name
359: ,2161
360: ,'U'
361: ,p_user_sequence
770: decode(l.pval140,cn,vn,vn,vn,l.pval140) p140,
771: l.pval140 d140,
772: decode(l.pval141,cn,vn,vn,vn,l.pval141) p141,
773: l.pval141 d141
774: from hr_pump_batch_lines l
775: where l.batch_line_id = p_batch_line_id;
776: --
777: c cr%rowtype;
778: l_validate boolean := false;
801: open cr;
802: fetch cr into c;
803: if cr%notfound then
804: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
805: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
806: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
807: hr_utility.set_message_token('VALUE',p_batch_line_id);
808: hr_utility.raise_error;
809: end if;
1125: else
1126: c.p122 := 'FALSE';
1127: end if;
1128: --
1129: update hr_pump_batch_lines l set
1130: l.pval002 = decode(c.p2,null,cn,c.p2),
1131: l.pval110 = decode(c.p110,null,cn,c.p110),
1132: l.pval111 = decode(c.p111,null,cn,c.p111),
1133: l.pval112 = decode(c.p112,null,cn,c.p112),