[Home] [Help]
173: ,P_EMP_STATE_TAX_RULE_USER_KEY in varchar2) is
174: blid number := p_data_pump_batch_line_id;
175: begin
176: if blid is not null then
177: delete from hr_pump_batch_lines where batch_line_id = blid;
178: delete from hr_pump_batch_exceptions
179: where source_type = 'BATCH_LINE' and source_id = blid;
180: end if;
181: insert into hr_pump_batch_lines
177: delete from hr_pump_batch_lines where batch_line_id = blid;
178: delete from hr_pump_batch_exceptions
179: where source_type = 'BATCH_LINE' and source_id = blid;
180: end if;
181: insert into hr_pump_batch_lines
182: (batch_id
183: ,batch_line_id
184: ,business_group_name
185: ,api_module_id
269: ,pval081
270: ,pval084)
271: values
272: (p_batch_id
273: ,nvl(blid,hr_pump_batch_lines_s.nextval)
274: ,p_data_pump_business_grp_name
275: ,1705
276: ,'U'
277: ,p_user_sequence
532: l.pval081 d81,
533: decode(l.pval082,cn,dn,d(l.pval082)) p82,
534: decode(l.pval083,cn,dn,d(l.pval083)) p83,
535: decode(l.pval084,cn,vn,l.pval084) p84
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;
546: open cr;
547: fetch cr into c;
548: if cr%notfound then
549: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
550: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
551: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
552: hr_utility.set_message_token('VALUE',p_batch_line_id);
553: hr_utility.raise_error;
554: end if;
661: ,P_EFFECTIVE_END_DATE => c.p83);
662: hr_data_pump.api_trc_off;
663:
664: --
665: update hr_pump_batch_lines l set
666: l.pval082 = decode(c.p82,null,cn,dc(c.p82)),
667: l.pval083 = decode(c.p83,null,cn,dc(c.p83))
668: where l.rowid = c.myrowid;
669: --