[Home] [Help]
213: ,P_BENEFIT_GROUP in varchar2 default null) is
214: blid number := p_data_pump_batch_line_id;
215: begin
216: if blid is not null then
217: delete from hr_pump_batch_lines where batch_line_id = blid;
218: delete from hr_pump_batch_exceptions
219: where source_type = 'BATCH_LINE' and source_id = blid;
220: end if;
221: insert into hr_pump_batch_lines
217: delete from hr_pump_batch_lines where batch_line_id = blid;
218: delete from hr_pump_batch_exceptions
219: where source_type = 'BATCH_LINE' and source_id = blid;
220: end if;
221: insert into hr_pump_batch_lines
222: (batch_id
223: ,batch_line_id
224: ,business_group_name
225: ,api_module_id
343: ,pval122
344: ,pval123)
345: values
346: (p_batch_id
347: ,nvl(blid,hr_pump_batch_lines_s.nextval)
348: ,p_data_pump_business_grp_name
349: ,2911
350: ,'U'
351: ,p_user_sequence
728: decode(l.pval122,cn,vn,vn,vh,l.pval122) p122,
729: l.pval122 d122,
730: decode(l.pval123,cn,vn,vn,vh,l.pval123) p123,
731: l.pval123 d123
732: from hr_pump_batch_lines l
733: where l.batch_line_id = p_batch_line_id;
734: --
735: c cr%rowtype;
736: l_validate boolean := false;
749: open cr;
750: fetch cr into c;
751: if cr%notfound then
752: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
753: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
754: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
755: hr_utility.set_message_token('VALUE',p_batch_line_id);
756: hr_utility.raise_error;
757: end if;
964: else
965: c.p117 := 'FALSE';
966: end if;
967: --
968: update hr_pump_batch_lines l set
969: l.pval009 = decode(c.p9,null,cn,c.p9),
970: l.pval111 = decode(c.p111,null,cn,dc(c.p111)),
971: l.pval112 = decode(c.p112,null,cn,dc(c.p112)),
972: l.pval113 = decode(c.p113,null,cn,c.p113),