[Home] [Help]
165: ,P_EMP_STATE_TAX_RULE_USER_KEY in varchar2) is
166: blid number := p_data_pump_batch_line_id;
167: begin
168: if blid is not null then
169: delete from hr_pump_batch_lines where batch_line_id = blid;
170: delete from hr_pump_batch_exceptions
171: where source_type = 'BATCH_LINE' and source_id = blid;
172: end if;
173: insert into hr_pump_batch_lines
169: delete from hr_pump_batch_lines where batch_line_id = blid;
170: delete from hr_pump_batch_exceptions
171: where source_type = 'BATCH_LINE' and source_id = blid;
172: end if;
173: insert into hr_pump_batch_lines
174: (batch_id
175: ,batch_line_id
176: ,business_group_name
177: ,api_module_id
263: ,pval083
264: ,pval084)
265: values
266: (p_batch_id
267: ,nvl(blid,hr_pump_batch_lines_s.nextval)
268: ,p_data_pump_business_grp_name
269: ,1704
270: ,'U'
271: ,p_user_sequence
532: l.pval084 p84,
533: l.pval085 p85,
534: decode(l.pval086,cn,dn,d(l.pval086)) p86,
535: decode(l.pval087,cn,dn,d(l.pval087)) p87
536: from hr_pump_batch_lines l
537: where l.batch_line_id = p_batch_line_id;
538: --
539: c cr%rowtype;
540: l_validate boolean := false;
545: open cr;
546: fetch cr into c;
547: if cr%notfound then
548: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
549: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
550: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
551: hr_utility.set_message_token('VALUE',p_batch_line_id);
552: hr_utility.raise_error;
553: end if;
645: hr_data_pump.api_trc_off;
646: --
647: iuk(p_batch_line_id,c.p84,L_EMP_STATE_TAX_RULE_ID);
648: --
649: update hr_pump_batch_lines l set
650: l.pval084 = decode(c.p84,null,cn,c.p84),
651: l.pval085 = decode(c.p85,null,cn,c.p85),
652: l.pval086 = decode(c.p86,null,cn,dc(c.p86)),
653: l.pval087 = decode(c.p87,null,cn,dc(c.p87))