[Home] [Help]
131: ,P_COMPETENCE_NAME in varchar2) is
132: blid number := p_data_pump_batch_line_id;
133: begin
134: if blid is not null then
135: delete from hr_pump_batch_lines where batch_line_id = blid;
136: delete from hr_pump_batch_exceptions
137: where source_type = 'BATCH_LINE' and source_id = blid;
138: end if;
139: insert into hr_pump_batch_lines
135: delete from hr_pump_batch_lines where batch_line_id = blid;
136: delete from hr_pump_batch_exceptions
137: where source_type = 'BATCH_LINE' and source_id = blid;
138: end if;
139: insert into hr_pump_batch_lines
140: (batch_id
141: ,batch_line_id
142: ,business_group_name
143: ,api_module_id
195: ,pval049
196: ,pval052)
197: values
198: (p_batch_id
199: ,nvl(blid,hr_pump_batch_lines_s.nextval)
200: ,p_data_pump_business_grp_name
201: ,3105
202: ,'U'
203: ,p_user_sequence
355: l.pval049 d49,
356: l.pval050 p50,
357: l.pval051 p51,
358: decode(l.pval052,cn,vn,l.pval052) p52
359: from hr_pump_batch_lines l
360: where l.batch_line_id = p_batch_line_id;
361: --
362: c cr%rowtype;
363: l_validate boolean := false;
368: open cr;
369: fetch cr into c;
370: if cr%notfound then
371: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
372: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
373: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
374: hr_utility.set_message_token('VALUE',p_batch_line_id);
375: hr_utility.raise_error;
376: end if;
438: ,P_OBJECT_VERSION_NUMBER => c.p51);
439: hr_data_pump.api_trc_off;
440:
441: --
442: update hr_pump_batch_lines l set
443: l.pval050 = decode(c.p50,null,cn,c.p50),
444: l.pval051 = decode(c.p51,null,cn,c.p51)
445: where l.rowid = c.myrowid;
446: --