[Home] [Help]
142: ,P_PPIP_EXEMPT_FLAG in varchar2 default null) is
143: blid number := p_data_pump_batch_line_id;
144: begin
145: if blid is not null then
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
151: (batch_id
152: ,batch_line_id
153: ,business_group_name
154: ,api_module_id
217: ,pval063
218: ,pval064)
219: values
220: (p_batch_id
221: ,nvl(blid,hr_pump_batch_lines_s.nextval)
222: ,p_data_pump_business_grp_name
223: ,1155
224: ,'U'
225: ,p_user_sequence
421: l.pval062 d62,
422: decode(l.pval063,cn,dn,d(l.pval063)) p63,
423: decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
424: l.pval064 d64
425: from hr_pump_batch_lines l
426: where l.batch_line_id = p_batch_line_id;
427: --
428: c cr%rowtype;
429: l_validate boolean := false;
434: open cr;
435: fetch cr into c;
436: if cr%notfound then
437: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
438: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
439: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
440: hr_utility.set_message_token('VALUE',p_batch_line_id);
441: hr_utility.raise_error;
442: end if;
512: hr_data_pump.api_trc_off;
513: --
514: iuk(p_batch_line_id,c.p1,L_EMP_PROVINCE_TAX_INF_ID);
515: --
516: update hr_pump_batch_lines l set
517: l.pval001 = decode(c.p1,null,cn,c.p1),
518: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
519: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
520: l.pval061 = decode(c.p61,null,cn,c.p61)