[Home] [Help]
194: ,P_BENEFIT_GROUP in varchar2 default null) is
195: blid number := p_data_pump_batch_line_id;
196: begin
197: if blid is not null then
198: delete from hr_pump_batch_lines where batch_line_id = blid;
199: delete from hr_pump_batch_exceptions
200: where source_type = 'BATCH_LINE' and source_id = blid;
201: end if;
202: insert into hr_pump_batch_lines
198: delete from hr_pump_batch_lines where batch_line_id = blid;
199: delete from hr_pump_batch_exceptions
200: where source_type = 'BATCH_LINE' and source_id = blid;
201: end if;
202: insert into hr_pump_batch_lines
203: (batch_id
204: ,batch_line_id
205: ,business_group_name
206: ,api_module_id
321: ,pval123
322: ,pval124)
323: values
324: (p_batch_id
325: ,nvl(blid,hr_pump_batch_lines_s.nextval)
326: ,p_data_pump_business_grp_name
327: ,3874
328: ,'U'
329: ,p_user_sequence
699: decode(l.pval123,cn,vn,vn,vn,l.pval123) p123,
700: l.pval123 d123,
701: decode(l.pval124,cn,vn,vn,vn,l.pval124) p124,
702: l.pval124 d124
703: from hr_pump_batch_lines l
704: where l.batch_line_id = p_batch_line_id;
705: --
706: c cr%rowtype;
707: l_validate boolean := false;
720: open cr;
721: fetch cr into c;
722: if cr%notfound then
723: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
724: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
725: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
726: hr_utility.set_message_token('VALUE',p_batch_line_id);
727: hr_utility.raise_error;
728: end if;
913: else
914: c.p119 := 'FALSE';
915: end if;
916: --
917: update hr_pump_batch_lines l set
918: l.pval008 = decode(c.p8,null,cn,c.p8),
919: l.pval107 = decode(c.p107,null,cn,c.p107),
920: l.pval108 = decode(c.p108,null,cn,c.p108),
921: l.pval109 = decode(c.p109,null,cn,c.p109),