[Home] [Help]
123: ,P_CVRD_EMP_PERSON_USER_KEY in varchar2 default null) is
124: blid number := p_data_pump_batch_line_id;
125: begin
126: if blid is not null then
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
132: (batch_id
133: ,batch_line_id
134: ,business_group_name
135: ,api_module_id
179: ,pval042
180: ,pval043)
181: values
182: (p_batch_id
183: ,nvl(blid,hr_pump_batch_lines_s.nextval)
184: ,p_data_pump_business_grp_name
185: ,24
186: ,'U'
187: ,p_user_sequence
319: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
320: l.pval042 d42,
321: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
322: l.pval043 d43
323: from hr_pump_batch_lines l
324: where l.batch_line_id = p_batch_line_id;
325: --
326: c cr%rowtype;
327: l_validate boolean := false;
337: open cr;
338: fetch cr into c;
339: if cr%notfound then
340: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
341: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
342: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
343: hr_utility.set_message_token('VALUE',p_batch_line_id);
344: hr_utility.raise_error;
345: end if;
440: hr_data_pump.api_trc_off;
441: --
442: iuk(p_batch_line_id,c.p1,L_CBR_QUALD_BNF_ID);
443: --
444: update hr_pump_batch_lines l set
445: l.pval001 = decode(c.p1,null,cn,c.p1),
446: l.pval037 = decode(c.p37,null,cn,c.p37)
447: where l.rowid = c.myrowid;
448: --