[Home] [Help]
140: ,P_EFFECTIVE_DATE in date) is
141: blid number := p_data_pump_batch_line_id;
142: begin
143: if blid is not null then
144: delete from hr_pump_batch_lines where batch_line_id = blid;
145: delete from hr_pump_batch_exceptions
146: where source_type = 'BATCH_LINE' and source_id = blid;
147: end if;
148: insert into hr_pump_batch_lines
144: delete from hr_pump_batch_lines where batch_line_id = blid;
145: delete from hr_pump_batch_exceptions
146: where source_type = 'BATCH_LINE' and source_id = blid;
147: end if;
148: insert into hr_pump_batch_lines
149: (batch_id
150: ,batch_line_id
151: ,business_group_name
152: ,api_module_id
213: ,pval059
214: ,pval060)
215: values
216: (p_batch_id
217: ,nvl(blid,hr_pump_batch_lines_s.nextval)
218: ,p_data_pump_business_grp_name
219: ,1220
220: ,'U'
221: ,p_user_sequence
400: decode(l.pval057,cn,nn,n(l.pval057)) p57,
401: decode(l.pval058,cn,vn,l.pval058) p58,
402: decode(l.pval059,cn,vn,l.pval059) p59,
403: decode(l.pval060,cn,dn,d(l.pval060)) p60
404: from hr_pump_batch_lines l
405: where l.batch_line_id = p_batch_line_id;
406: --
407: c cr%rowtype;
408: l_validate boolean := false;
415: open cr;
416: fetch cr into c;
417: if cr%notfound then
418: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
419: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
420: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
421: hr_utility.set_message_token('VALUE',p_batch_line_id);
422: hr_utility.raise_error;
423: end if;
506: hr_data_pump.api_trc_off;
507: --
508: iuk(p_batch_line_id,c.p55,L_JOB_REQUIREMENT_ID);
509: --
510: update hr_pump_batch_lines l set
511: l.pval055 = decode(c.p55,null,cn,c.p55),
512: l.pval056 = decode(c.p56,null,cn,c.p56),
513: l.pval057 = decode(c.p57,null,cn,c.p57)
514: where l.rowid = c.myrowid;