[Home] [Help]
160: ,P_CTY_INFORMATION30 in varchar2 default null) is
161: blid number := p_data_pump_batch_line_id;
162: begin
163: if blid is not null then
164: delete from hr_pump_batch_lines where batch_line_id = blid;
165: delete from hr_pump_batch_exceptions
166: where source_type = 'BATCH_LINE' and source_id = blid;
167: end if;
168: insert into hr_pump_batch_lines
164: delete from hr_pump_batch_lines where batch_line_id = blid;
165: delete from hr_pump_batch_exceptions
166: where source_type = 'BATCH_LINE' and source_id = blid;
167: end if;
168: insert into hr_pump_batch_lines
169: (batch_id
170: ,batch_line_id
171: ,business_group_name
172: ,api_module_id
253: ,pval081
254: ,pval082)
255: values
256: (p_batch_id
257: ,nvl(blid,hr_pump_batch_lines_s.nextval)
258: ,p_data_pump_business_grp_name
259: ,1700
260: ,'U'
261: ,p_user_sequence
508: decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
509: l.pval081 d81,
510: decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
511: l.pval082 d82
512: from hr_pump_batch_lines l
513: where l.batch_line_id = p_batch_line_id;
514: --
515: c cr%rowtype;
516: l_validate boolean := false;
521: open cr;
522: fetch cr into c;
523: if cr%notfound then
524: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
525: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
526: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
527: hr_utility.set_message_token('VALUE',p_batch_line_id);
528: hr_utility.raise_error;
529: end if;
616: hr_data_pump.api_trc_off;
617: --
618: iuk(p_batch_line_id,c.p1,L_EMP_CITY_TAX_RULE_ID);
619: --
620: update hr_pump_batch_lines l set
621: l.pval001 = decode(c.p1,null,cn,c.p1),
622: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
623: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
624: l.pval019 = decode(c.p19,null,cn,c.p19)