[Home] [Help]
173: ,P_VACANCY_USER_KEY in varchar2 default null) is
174: blid number := p_data_pump_batch_line_id;
175: begin
176: if blid is not null then
177: delete from hr_pump_batch_lines where batch_line_id = blid;
178: delete from hr_pump_batch_exceptions
179: where source_type = 'BATCH_LINE' and source_id = blid;
180: end if;
181: insert into hr_pump_batch_lines
177: delete from hr_pump_batch_lines where batch_line_id = blid;
178: delete from hr_pump_batch_exceptions
179: where source_type = 'BATCH_LINE' and source_id = blid;
180: end if;
181: insert into hr_pump_batch_lines
182: (batch_id
183: ,batch_line_id
184: ,business_group_name
185: ,api_module_id
279: ,pval101
280: ,pval102)
281: values
282: (p_batch_id
283: ,nvl(blid,hr_pump_batch_lines_s.nextval)
284: ,p_data_pump_business_grp_name
285: ,3855
286: ,'U'
287: ,p_user_sequence
581: decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
582: l.pval101 d101,
583: decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
584: l.pval102 d102
585: from hr_pump_batch_lines l
586: where l.batch_line_id = p_batch_line_id;
587: --
588: c cr%rowtype;
589: l_validate boolean := false;
602: open cr;
603: fetch cr into c;
604: if cr%notfound then
605: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
606: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
607: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
608: hr_utility.set_message_token('VALUE',p_batch_line_id);
609: hr_utility.raise_error;
610: end if;
769: else
770: c.p97 := 'FALSE';
771: end if;
772: --
773: update hr_pump_batch_lines l set
774: l.pval003 = decode(c.p3,null,cn,c.p3),
775: l.pval085 = decode(c.p85,null,cn,c.p85),
776: l.pval086 = decode(c.p86,null,cn,c.p86),
777: l.pval087 = decode(c.p87,null,cn,c.p87),