[Home] [Help]
182: ,P_INPUT_VALUE_NAME15 in varchar2 default null) is
183: blid number := p_data_pump_batch_line_id;
184: begin
185: if blid is not null then
186: delete from hr_pump_batch_lines where batch_line_id = blid;
187: delete from hr_pump_batch_exceptions
188: where source_type = 'BATCH_LINE' and source_id = blid;
189: end if;
190: insert into hr_pump_batch_lines
186: delete from hr_pump_batch_lines where batch_line_id = blid;
187: delete from hr_pump_batch_exceptions
188: where source_type = 'BATCH_LINE' and source_id = blid;
189: end if;
190: insert into hr_pump_batch_lines
191: (batch_id
192: ,batch_line_id
193: ,business_group_name
194: ,api_module_id
297: ,pval104
298: ,pval105)
299: values
300: (p_batch_id
301: ,nvl(blid,hr_pump_batch_lines_s.nextval)
302: ,p_data_pump_business_grp_name
303: ,1382
304: ,'U'
305: ,p_user_sequence
614: decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
615: l.pval104 d104,
616: decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
617: l.pval105 d105
618: from hr_pump_batch_lines l
619: where l.batch_line_id = p_batch_line_id;
620: --
621: c cr%rowtype;
622: l_validate boolean := false;
651: open cr;
652: fetch cr into c;
653: if cr%notfound then
654: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
655: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
656: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
657: hr_utility.set_message_token('VALUE',p_batch_line_id);
658: hr_utility.raise_error;
659: end if;
1063: else
1064: c.p80 := 'FALSE';
1065: end if;
1066: --
1067: update hr_pump_batch_lines l set
1068: l.pval076 = decode(c.p76,null,cn,dc(c.p76)),
1069: l.pval077 = decode(c.p77,null,cn,dc(c.p77)),
1070: l.pval078 = decode(c.p78,null,cn,c.p78),
1071: l.pval079 = decode(c.p79,null,cn,c.p79),