[Home] [Help]
162: ,P_BENEFIT_GROUP in varchar2 default null) is
163: blid number := p_data_pump_batch_line_id;
164: begin
165: if blid is not null then
166: delete from hr_pump_batch_lines where batch_line_id = blid;
167: delete from hr_pump_batch_exceptions
168: where source_type = 'BATCH_LINE' and source_id = blid;
169: end if;
170: insert into hr_pump_batch_lines
166: delete from hr_pump_batch_lines where batch_line_id = blid;
167: delete from hr_pump_batch_exceptions
168: where source_type = 'BATCH_LINE' and source_id = blid;
169: end if;
170: insert into hr_pump_batch_lines
171: (batch_id
172: ,batch_line_id
173: ,business_group_name
174: ,api_module_id
257: ,pval090
258: ,pval091)
259: values
260: (p_batch_id
261: ,nvl(blid,hr_pump_batch_lines_s.nextval)
262: ,p_data_pump_business_grp_name
263: ,2165
264: ,'U'
265: ,p_user_sequence
526: decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
527: l.pval090 d90,
528: decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
529: l.pval091 d91
530: from hr_pump_batch_lines l
531: where l.batch_line_id = p_batch_line_id;
532: --
533: c cr%rowtype;
534: l_validate boolean := false;
546: open cr;
547: fetch cr into c;
548: if cr%notfound then
549: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
550: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
551: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
552: hr_utility.set_message_token('VALUE',p_batch_line_id);
553: hr_utility.raise_error;
554: end if;
694: else
695: c.p87 := 'FALSE';
696: end if;
697: --
698: update hr_pump_batch_lines l set
699: l.pval004 = decode(c.p4,null,cn,c.p4),
700: l.pval075 = decode(c.p75,null,cn,c.p75),
701: l.pval076 = decode(c.p76,null,cn,c.p76),
702: l.pval077 = decode(c.p77,null,cn,c.p77),