[Home] [Help]
181: ,P_INPUT_VALUE_NAME15 in varchar2 default null) is
182: blid number := p_data_pump_batch_line_id;
183: begin
184: if blid is not null then
185: delete from hr_pump_batch_lines where batch_line_id = blid;
186: delete from hr_pump_batch_exceptions
187: where source_type = 'BATCH_LINE' and source_id = blid;
188: end if;
189: insert into hr_pump_batch_lines
185: delete from hr_pump_batch_lines where batch_line_id = blid;
186: delete from hr_pump_batch_exceptions
187: where source_type = 'BATCH_LINE' and source_id = blid;
188: end if;
189: insert into hr_pump_batch_lines
190: (batch_id
191: ,batch_line_id
192: ,business_group_name
193: ,api_module_id
293: ,pval100
294: ,pval101)
295: values
296: (p_batch_id
297: ,nvl(blid,hr_pump_batch_lines_s.nextval)
298: ,p_data_pump_business_grp_name
299: ,1383
300: ,'U'
301: ,p_user_sequence
601: decode(l.pval100,cn,vn,vn,vh,l.pval100) p100,
602: l.pval100 d100,
603: decode(l.pval101,cn,vn,vn,vh,l.pval101) p101,
604: l.pval101 d101
605: from hr_pump_batch_lines l
606: where l.batch_line_id = p_batch_line_id;
607: --
608: c cr%rowtype;
609: l_validate boolean := false;
637: open cr;
638: fetch cr into c;
639: if cr%notfound then
640: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
641: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
642: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
643: hr_utility.set_message_token('VALUE',p_batch_line_id);
644: hr_utility.raise_error;
645: end if;
1097: else
1098: c.p78 := 'FALSE';
1099: end if;
1100: --
1101: update hr_pump_batch_lines l set
1102: l.pval076 = decode(c.p76,null,cn,dc(c.p76)),
1103: l.pval077 = decode(c.p77,null,cn,dc(c.p77)),
1104: l.pval078 = decode(c.p78,null,cn,c.p78)
1105: where l.rowid = c.myrowid;