[Home] [Help]
142: ,P_ID_FLEX_NUM_USER_KEY in varchar2) is
143: blid number := p_data_pump_batch_line_id;
144: begin
145: if blid is not null then
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
151: (batch_id
152: ,batch_line_id
153: ,business_group_name
154: ,api_module_id
217: ,pval061
218: ,pval062)
219: values
220: (p_batch_id
221: ,nvl(blid,hr_pump_batch_lines_s.nextval)
222: ,p_data_pump_business_grp_name
223: ,1279
224: ,'U'
225: ,p_user_sequence
409: l.pval059 p59,
410: l.pval060 p60,
411: decode(l.pval061,cn,vn,l.pval061) p61,
412: decode(l.pval062,cn,vn,l.pval062) p62
413: from hr_pump_batch_lines l
414: where l.batch_line_id = p_batch_line_id;
415: --
416: c cr%rowtype;
417: l_validate boolean := false;
427: open cr;
428: fetch cr into c;
429: if cr%notfound then
430: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
431: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
432: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
433: hr_utility.set_message_token('VALUE',p_batch_line_id);
434: hr_utility.raise_error;
435: end if;
531: hr_data_pump.api_trc_off;
532: --
533: iuk(p_batch_line_id,c.p59,L_PERSON_ANALYSIS_ID);
534: --
535: update hr_pump_batch_lines l set
536: l.pval058 = decode(c.p58,null,cn,c.p58),
537: l.pval059 = decode(c.p59,null,cn,c.p59),
538: l.pval060 = decode(c.p60,null,cn,c.p60)
539: where l.rowid = c.myrowid;