[Home] [Help]
153: ,P_QUALIFICATION_TYPE_NAME in varchar2) is
154: blid number := p_data_pump_batch_line_id;
155: begin
156: if blid is not null then
157: delete from hr_pump_batch_lines where batch_line_id = blid;
158: delete from hr_pump_batch_exceptions
159: where source_type = 'BATCH_LINE' and source_id = blid;
160: end if;
161: insert into hr_pump_batch_lines
157: delete from hr_pump_batch_lines where batch_line_id = blid;
158: delete from hr_pump_batch_exceptions
159: where source_type = 'BATCH_LINE' and source_id = blid;
160: end if;
161: insert into hr_pump_batch_lines
162: (batch_id
163: ,batch_line_id
164: ,business_group_name
165: ,api_module_id
235: ,pval067
236: ,pval068)
237: values
238: (p_batch_id
239: ,nvl(blid,hr_pump_batch_lines_s.nextval)
240: ,p_data_pump_business_grp_name
241: ,3118
242: ,'U'
243: ,p_user_sequence
457: decode(l.pval067,cn,vn,vn,vh,
458: hr_pump_get.gl(l.pval067,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p67,
459: l.pval067 d67,
460: decode(l.pval068,cn,vn,l.pval068) p68
461: from hr_pump_batch_lines l
462: where l.batch_line_id = p_batch_line_id;
463: --
464: c cr%rowtype;
465: l_validate boolean := false;
471: open cr;
472: fetch cr into c;
473: if cr%notfound then
474: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
475: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
476: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
477: hr_utility.set_message_token('VALUE',p_batch_line_id);
478: hr_utility.raise_error;
479: end if;