[Home] [Help]
174: ,P_CAGR_NAME in varchar2 default null) is
175: blid number := p_data_pump_batch_line_id;
176: begin
177: if blid is not null then
178: delete from hr_pump_batch_lines where batch_line_id = blid;
179: delete from hr_pump_batch_exceptions
180: where source_type = 'BATCH_LINE' and source_id = blid;
181: end if;
182: insert into hr_pump_batch_lines
178: delete from hr_pump_batch_lines where batch_line_id = blid;
179: delete from hr_pump_batch_exceptions
180: where source_type = 'BATCH_LINE' and source_id = blid;
181: end if;
182: insert into hr_pump_batch_lines
183: (batch_id
184: ,batch_line_id
185: ,business_group_name
186: ,api_module_id
275: ,pval095
276: ,pval096)
277: values
278: (p_batch_id
279: ,nvl(blid,hr_pump_batch_lines_s.nextval)
280: ,p_data_pump_business_grp_name
281: ,2162
282: ,'U'
283: ,p_user_sequence
565: decode(l.pval095,cn,vn,vn,vh,l.pval095) p95,
566: l.pval095 d95,
567: decode(l.pval096,cn,vn,vn,vh,l.pval096) p96,
568: l.pval096 d96
569: from hr_pump_batch_lines l
570: where l.batch_line_id = p_batch_line_id;
571: --
572: c cr%rowtype;
573: l_validate boolean := false;
588: open cr;
589: fetch cr into c;
590: if cr%notfound then
591: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
592: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
594: hr_utility.set_message_token('VALUE',p_batch_line_id);
595: hr_utility.raise_error;
596: end if;
802: else
803: c.p87 := 'FALSE';
804: end if;
805: --
806: update hr_pump_batch_lines l set
807: l.pval079 = decode(c.p79,null,cn,c.p79),
808: l.pval080 = decode(c.p80,null,cn,c.p80),
809: l.pval081 = decode(c.p81,null,cn,c.p81),
810: l.pval082 = decode(c.p82,null,cn,c.p82),