[Home] [Help]
148: ,P_EMP_FED_TAX_INF_USER_KEY in varchar2) is
149: blid number := p_data_pump_batch_line_id;
150: begin
151: if blid is not null then
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
157: (batch_id
158: ,batch_line_id
159: ,business_group_name
160: ,api_module_id
217: ,pval056
218: ,pval057)
219: values
220: (p_batch_id
221: ,nvl(blid,hr_pump_batch_lines_s.nextval)
222: ,p_data_pump_business_grp_name
223: ,1158
224: ,'U'
225: ,p_user_sequence
397: l.pval054 d54,
398: decode(l.pval055,cn,dn,d(l.pval055)) p55,
399: decode(l.pval056,cn,vn,l.pval056) p56,
400: decode(l.pval057,cn,vn,l.pval057) p57
401: from hr_pump_batch_lines l
402: where l.batch_line_id = p_batch_line_id;
403: --
404: c cr%rowtype;
405: l_validate boolean := false;
411: open cr;
412: fetch cr into c;
413: if cr%notfound then
414: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
415: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
416: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
417: hr_utility.set_message_token('VALUE',p_batch_line_id);
418: hr_utility.raise_error;
419: end if;
500: ,P_DATETRACK_MODE => c.p56);
501: hr_data_pump.api_trc_off;
502:
503: --
504: update hr_pump_batch_lines l set
505: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
506: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
507: where l.rowid = c.myrowid;
508: --