[Home] [Help]
99: ,P_PERSON_USER_KEY in varchar2 default null) is
100: blid number := p_data_pump_batch_line_id;
101: begin
102: if blid is not null then
103: delete from hr_pump_batch_lines where batch_line_id = blid;
104: delete from hr_pump_batch_exceptions
105: where source_type = 'BATCH_LINE' and source_id = blid;
106: end if;
107: insert into hr_pump_batch_lines
103: delete from hr_pump_batch_lines where batch_line_id = blid;
104: delete from hr_pump_batch_exceptions
105: where source_type = 'BATCH_LINE' and source_id = blid;
106: end if;
107: insert into hr_pump_batch_lines
108: (batch_id
109: ,batch_line_id
110: ,business_group_name
111: ,api_module_id
131: ,pval018
132: ,pval019)
133: values
134: (p_batch_id
135: ,nvl(blid,hr_pump_batch_lines_s.nextval)
136: ,p_data_pump_business_grp_name
137: ,660
138: ,'U'
139: ,p_user_sequence
199: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
200: l.pval018 d18,
201: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
202: l.pval019 d19
203: from hr_pump_batch_lines l
204: where l.batch_line_id = p_batch_line_id;
205: --
206: c cr%rowtype;
207: l_validate boolean := false;
220: open cr;
221: fetch cr into c;
222: if cr%notfound then
223: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
224: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
225: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
226: hr_utility.set_message_token('VALUE',p_batch_line_id);
227: hr_utility.raise_error;
228: end if;
308: hr_data_pump.api_trc_off;
309: --
310: iuk(p_batch_line_id,c.p1,L_PTNL_LER_FOR_PER_ID);
311: --
312: update hr_pump_batch_lines l set
313: l.pval001 = decode(c.p1,null,cn,c.p1),
314: l.pval013 = decode(c.p13,null,cn,c.p13)
315: where l.rowid = c.myrowid;
316: --