[Home] [Help]
231: ,P_BENEFIT_GROUP in varchar2 default null) is
232: blid number := p_data_pump_batch_line_id;
233: begin
234: if blid is not null then
235: delete from hr_pump_batch_lines where batch_line_id = blid;
236: delete from hr_pump_batch_exceptions
237: where source_type = 'BATCH_LINE' and source_id = blid;
238: end if;
239: insert into hr_pump_batch_lines
235: delete from hr_pump_batch_lines where batch_line_id = blid;
236: delete from hr_pump_batch_exceptions
237: where source_type = 'BATCH_LINE' and source_id = blid;
238: end if;
239: insert into hr_pump_batch_lines
240: (batch_id
241: ,batch_line_id
242: ,business_group_name
243: ,api_module_id
379: ,pval140
380: ,pval141)
381: values
382: (p_batch_id
383: ,nvl(blid,hr_pump_batch_lines_s.nextval)
384: ,p_data_pump_business_grp_name
385: ,1212
386: ,'U'
387: ,p_user_sequence
811: decode(l.pval140,cn,vn,vn,vh,l.pval140) p140,
812: l.pval140 d140,
813: decode(l.pval141,cn,vn,vn,vh,l.pval141) p141,
814: l.pval141 d141
815: from hr_pump_batch_lines l
816: where l.batch_line_id = p_batch_line_id;
817: --
818: c cr%rowtype;
819: l_validate boolean := false;
832: open cr;
833: fetch cr into c;
834: if cr%notfound then
835: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
836: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
837: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
838: hr_utility.set_message_token('VALUE',p_batch_line_id);
839: hr_utility.raise_error;
840: end if;
1065: else
1066: c.p135 := 'FALSE';
1067: end if;
1068: --
1069: update hr_pump_batch_lines l set
1070: l.pval009 = decode(c.p9,null,cn,c.p9),
1071: l.pval129 = decode(c.p129,null,cn,dc(c.p129)),
1072: l.pval130 = decode(c.p130,null,cn,dc(c.p130)),
1073: l.pval131 = decode(c.p131,null,cn,c.p131),