[Home] [Help]
148: ,P_QA_ORGANIZATION in varchar2 default null) is
149: blid number := p_data_pump_batch_line_id;
150: begin
151: if blid is not null then
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
152: delete from hr_pump_batch_lines where batch_line_id = blid;
153: delete from hr_pump_batch_exceptions
154: where source_type = 'BATCH_LINE' and source_id = blid;
155: end if;
156: insert into hr_pump_batch_lines
157: (batch_id
158: ,batch_line_id
159: ,business_group_name
160: ,api_module_id
229: ,pval066
230: ,pval067)
231: values
232: (p_batch_id
233: ,nvl(blid,hr_pump_batch_lines_s.nextval)
234: ,p_data_pump_business_grp_name
235: ,3117
236: ,'U'
237: ,p_user_sequence
449: hr_pump_get.gl(l.pval067,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p67,
450: l.pval067 d67,
451: l.pval068 p68,
452: l.pval069 p69
453: from hr_pump_batch_lines l
454: where l.batch_line_id = p_batch_line_id;
455: --
456: c cr%rowtype;
457: l_validate boolean := false;
461: open cr;
462: fetch cr into c;
463: if cr%notfound then
464: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
465: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
466: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
467: hr_utility.set_message_token('VALUE',p_batch_line_id);
468: hr_utility.raise_error;
469: end if;
542: ,P_OBJECT_VERSION_NUMBER => c.p69);
543: hr_data_pump.api_trc_off;
544:
545: --
546: update hr_pump_batch_lines l set
547: l.pval068 = decode(c.p68,null,cn,c.p68),
548: l.pval069 = decode(c.p69,null,cn,c.p69)
549: where l.rowid = c.myrowid;
550: --