[Home] [Help]
171: ,P_EMP_FED_TAX_RULE_USER_KEY in varchar2) is
172: blid number := p_data_pump_batch_line_id;
173: begin
174: if blid is not null then
175: delete from hr_pump_batch_lines where batch_line_id = blid;
176: delete from hr_pump_batch_exceptions
177: where source_type = 'BATCH_LINE' and source_id = blid;
178: end if;
179: insert into hr_pump_batch_lines
175: delete from hr_pump_batch_lines where batch_line_id = blid;
176: delete from hr_pump_batch_exceptions
177: where source_type = 'BATCH_LINE' and source_id = blid;
178: end if;
179: insert into hr_pump_batch_lines
180: (batch_id
181: ,batch_line_id
182: ,business_group_name
183: ,api_module_id
267: ,pval081
268: ,pval084)
269: values
270: (p_batch_id
271: ,nvl(blid,hr_pump_batch_lines_s.nextval)
272: ,p_data_pump_business_grp_name
273: ,1706
274: ,'U'
275: ,p_user_sequence
533: l.pval081 d81,
534: decode(l.pval082,cn,dn,d(l.pval082)) p82,
535: decode(l.pval083,cn,dn,d(l.pval083)) p83,
536: decode(l.pval084,cn,vn,l.pval084) p84
537: from hr_pump_batch_lines l
538: where l.batch_line_id = p_batch_line_id;
539: --
540: c cr%rowtype;
541: l_validate boolean := false;
547: open cr;
548: fetch cr into c;
549: if cr%notfound then
550: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
551: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
552: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
553: hr_utility.set_message_token('VALUE',p_batch_line_id);
554: hr_utility.raise_error;
555: end if;
662: ,P_EFFECTIVE_END_DATE => c.p83);
663: hr_data_pump.api_trc_off;
664:
665: --
666: update hr_pump_batch_lines l set
667: l.pval082 = decode(c.p82,null,cn,dc(c.p82)),
668: l.pval083 = decode(c.p83,null,cn,dc(c.p83))
669: where l.rowid = c.myrowid;
670: --