[Home] [Help]
126: ,P_TARGET_ENTRY_USER_KEY in varchar2 default null) is
127: blid number := p_data_pump_batch_line_id;
128: begin
129: if blid is not null then
130: delete from hr_pump_batch_lines where batch_line_id = blid;
131: delete from hr_pump_batch_exceptions
132: where source_type = 'BATCH_LINE' and source_id = blid;
133: end if;
134: insert into hr_pump_batch_lines
130: delete from hr_pump_batch_lines where batch_line_id = blid;
131: delete from hr_pump_batch_exceptions
132: where source_type = 'BATCH_LINE' and source_id = blid;
133: end if;
134: insert into hr_pump_batch_lines
135: (batch_id
136: ,batch_line_id
137: ,business_group_name
138: ,api_module_id
185: ,pval049
186: ,pval050)
187: values
188: (p_batch_id
189: ,nvl(blid,hr_pump_batch_lines_s.nextval)
190: ,p_data_pump_business_grp_name
191: ,2169
192: ,'U'
193: ,p_user_sequence
332: decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
333: l.pval049 d49,
334: decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
335: l.pval050 d50
336: from hr_pump_batch_lines l
337: where l.batch_line_id = p_batch_line_id;
338: --
339: c cr%rowtype;
340: l_validate boolean := false;
351: open cr;
352: fetch cr into c;
353: if cr%notfound then
354: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
355: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
356: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
357: hr_utility.set_message_token('VALUE',p_batch_line_id);
358: hr_utility.raise_error;
359: end if;
467: else
468: c.p44 := 'FALSE';
469: end if;
470: --
471: update hr_pump_batch_lines l set
472: l.pval040 = decode(c.p40,null,cn,dc(c.p40)),
473: l.pval041 = decode(c.p41,null,cn,dc(c.p41)),
474: l.pval042 = decode(c.p42,null,cn,c.p42),
475: l.pval043 = decode(c.p43,null,cn,c.p43),