[Home] [Help]
149: ,P_SHIP_TO_LOCATION_ID in number default null) is
150: blid number := p_data_pump_batch_line_id;
151: begin
152: if blid is not null then
153: delete from hr_pump_batch_lines where batch_line_id = blid;
154: delete from hr_pump_batch_exceptions
155: where source_type = 'BATCH_LINE' and source_id = blid;
156: end if;
157: insert into hr_pump_batch_lines
153: delete from hr_pump_batch_lines where batch_line_id = blid;
154: delete from hr_pump_batch_exceptions
155: where source_type = 'BATCH_LINE' and source_id = blid;
156: end if;
157: insert into hr_pump_batch_lines
158: (batch_id
159: ,batch_line_id
160: ,business_group_name
161: ,api_module_id
231: ,pval069
232: ,pval070)
233: values
234: (p_batch_id
235: ,nvl(blid,hr_pump_batch_lines_s.nextval)
236: ,p_data_pump_business_grp_name
237: ,3225
238: ,'U'
239: ,p_user_sequence
451: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
452: l.pval069 d69,
453: decode(l.pval070,cn,nn,vn,nn,n(l.pval070)) p70,
454: l.pval070 d70
455: from hr_pump_batch_lines l
456: where l.batch_line_id = p_batch_line_id;
457: --
458: c cr%rowtype;
459: l_validate boolean := false;
469: open cr;
470: fetch cr into c;
471: if cr%notfound then
472: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
473: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
474: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
475: hr_utility.set_message_token('VALUE',p_batch_line_id);
476: hr_utility.raise_error;
477: end if;
584: ,P_OBJECT_VERSION_NUMBER => c.p68);
585: hr_data_pump.api_trc_off;
586:
587: --
588: update hr_pump_batch_lines l set
589: l.pval067 = decode(c.p67,null,cn,c.p67),
590: l.pval068 = decode(c.p68,null,cn,c.p68)
591: where l.rowid = c.myrowid;
592: --