[Home] [Help]
151: ,P_LANGUAGE_CODE in varchar2 default null) is
152: blid number := p_data_pump_batch_line_id;
153: begin
154: if blid is not null then
155: delete from hr_pump_batch_lines where batch_line_id = blid;
156: delete from hr_pump_batch_exceptions
157: where source_type = 'BATCH_LINE' and source_id = blid;
158: end if;
159: insert into hr_pump_batch_lines
155: delete from hr_pump_batch_lines where batch_line_id = blid;
156: delete from hr_pump_batch_exceptions
157: where source_type = 'BATCH_LINE' and source_id = blid;
158: end if;
159: insert into hr_pump_batch_lines
160: (batch_id
161: ,batch_line_id
162: ,business_group_name
163: ,api_module_id
235: ,pval074
236: ,pval075)
237: values
238: (p_batch_id
239: ,nvl(blid,hr_pump_batch_lines_s.nextval)
240: ,p_data_pump_business_grp_name
241: ,2194
242: ,'U'
243: ,p_user_sequence
456: decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
457: l.pval074 d74,
458: decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
459: l.pval075 d75
460: from hr_pump_batch_lines l
461: where l.batch_line_id = p_batch_line_id;
462: --
463: c cr%rowtype;
464: l_validate boolean := false;
473: open cr;
474: fetch cr into c;
475: if cr%notfound then
476: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
477: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
478: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
479: hr_utility.set_message_token('VALUE',p_batch_line_id);
480: hr_utility.raise_error;
481: end if;
589: hr_data_pump.api_trc_off;
590: --
591: iuk(p_batch_line_id,c.p65,L_PERSONAL_PAYMENT_METHOD_ID);
592: --
593: update hr_pump_batch_lines l set
594: l.pval065 = decode(c.p65,null,cn,c.p65),
595: l.pval066 = decode(c.p66,null,cn,c.p66),
596: l.pval067 = decode(c.p67,null,cn,c.p67),
597: l.pval068 = decode(c.p68,null,cn,dc(c.p68)),