[Home] [Help]
164: ,P_JOB_GROUP_USER_KEY in varchar2) is
165: blid number := p_data_pump_batch_line_id;
166: begin
167: if blid is not null then
168: delete from hr_pump_batch_lines where batch_line_id = blid;
169: delete from hr_pump_batch_exceptions
170: where source_type = 'BATCH_LINE' and source_id = blid;
171: end if;
172: insert into hr_pump_batch_lines
168: delete from hr_pump_batch_lines where batch_line_id = blid;
169: delete from hr_pump_batch_exceptions
170: where source_type = 'BATCH_LINE' and source_id = blid;
171: end if;
172: insert into hr_pump_batch_lines
173: (batch_id
174: ,batch_line_id
175: ,business_group_name
176: ,api_module_id
261: ,pval085
262: ,pval086)
263: values
264: (p_batch_id
265: ,nvl(blid,hr_pump_batch_lines_s.nextval)
266: ,p_data_pump_business_grp_name
267: ,1336
268: ,'U'
269: ,p_user_sequence
523: l.pval084 p84,
524: decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
525: l.pval085 d85,
526: decode(l.pval086,cn,vn,l.pval086) p86
527: from hr_pump_batch_lines l
528: where l.batch_line_id = p_batch_line_id;
529: --
530: c cr%rowtype;
531: l_validate boolean := false;
537: open cr;
538: fetch cr into c;
539: if cr%notfound then
540: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
541: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
542: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
543: hr_utility.set_message_token('VALUE',p_batch_line_id);
544: hr_utility.raise_error;
545: end if;
652: ,P_NAME => c.p84);
653: hr_data_pump.api_trc_off;
654:
655: --
656: update hr_pump_batch_lines l set
657: l.pval081 = decode(c.p81,null,cn,c.p81),
658: l.pval082 = decode(c.p82,null,cn,c.p82),
659: l.pval083 = decode(c.p83,null,cn,c.p83),
660: l.pval084 = decode(c.p84,null,cn,c.p84)