[Home] [Help]
200: ,P_CON_SEG_USER_NAME in varchar2) is
201: blid number := p_data_pump_batch_line_id;
202: begin
203: if blid is not null then
204: delete from hr_pump_batch_lines where batch_line_id = blid;
205: delete from hr_pump_batch_exceptions
206: where source_type = 'BATCH_LINE' and source_id = blid;
207: end if;
208: insert into hr_pump_batch_lines
204: delete from hr_pump_batch_lines where batch_line_id = blid;
205: delete from hr_pump_batch_exceptions
206: where source_type = 'BATCH_LINE' and source_id = blid;
207: end if;
208: insert into hr_pump_batch_lines
209: (batch_id
210: ,batch_line_id
211: ,business_group_name
212: ,api_module_id
325: ,pval119
326: ,pval120)
327: values
328: (p_batch_id
329: ,nvl(blid,hr_pump_batch_lines_s.nextval)
330: ,p_data_pump_business_grp_name
331: ,3870
332: ,'U'
333: ,p_user_sequence
694: l.pval118 d118,
695: decode(l.pval119,cn,vn,vn,vn,l.pval119) p119,
696: l.pval119 d119,
697: decode(l.pval120,cn,vn,l.pval120) p120
698: from hr_pump_batch_lines l
699: where l.batch_line_id = p_batch_line_id;
700: --
701: c cr%rowtype;
702: l_validate boolean := false;
722: open cr;
723: fetch cr into c;
724: if cr%notfound then
725: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
726: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
727: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
728: hr_utility.set_message_token('VALUE',p_batch_line_id);
729: hr_utility.raise_error;
730: end if;
1018: else
1019: c.p106 := 'FALSE';
1020: end if;
1021: --
1022: update hr_pump_batch_lines l set
1023: l.pval098 = decode(c.p98,null,cn,c.p98),
1024: l.pval099 = decode(c.p99,null,cn,c.p99),
1025: l.pval100 = decode(c.p100,null,cn,dc(c.p100)),
1026: l.pval101 = decode(c.p101,null,cn,dc(c.p101)),