[Home] [Help]
184: ,P_BENEFIT_GROUP in varchar2 default null) is
185: blid number := p_data_pump_batch_line_id;
186: begin
187: if blid is not null then
188: delete from hr_pump_batch_lines where batch_line_id = blid;
189: delete from hr_pump_batch_exceptions
190: where source_type = 'BATCH_LINE' and source_id = blid;
191: end if;
192: insert into hr_pump_batch_lines
188: delete from hr_pump_batch_lines where batch_line_id = blid;
189: delete from hr_pump_batch_exceptions
190: where source_type = 'BATCH_LINE' and source_id = blid;
191: end if;
192: insert into hr_pump_batch_lines
193: (batch_id
194: ,batch_line_id
195: ,business_group_name
196: ,api_module_id
301: ,pval113
302: ,pval114)
303: values
304: (p_batch_id
305: ,nvl(blid,hr_pump_batch_lines_s.nextval)
306: ,p_data_pump_business_grp_name
307: ,3862
308: ,'U'
309: ,p_user_sequence
644: decode(l.pval113,cn,vn,vn,vn,l.pval113) p113,
645: l.pval113 d113,
646: decode(l.pval114,cn,vn,vn,vn,l.pval114) p114,
647: l.pval114 d114
648: from hr_pump_batch_lines l
649: where l.batch_line_id = p_batch_line_id;
650: --
651: c cr%rowtype;
652: l_validate boolean := false;
665: open cr;
666: fetch cr into c;
667: if cr%notfound then
668: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
669: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
670: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
671: hr_utility.set_message_token('VALUE',p_batch_line_id);
672: hr_utility.raise_error;
673: end if;
848: else
849: c.p109 := 'FALSE';
850: end if;
851: --
852: update hr_pump_batch_lines l set
853: l.pval008 = decode(c.p8,null,cn,c.p8),
854: l.pval097 = decode(c.p97,null,cn,c.p97),
855: l.pval098 = decode(c.p98,null,cn,c.p98),
856: l.pval099 = decode(c.p99,null,cn,c.p99),