[Home] [Help]
123: ,P_PAYROLL_RUN_USER_KEY in varchar2) is
124: blid number := p_data_pump_batch_line_id;
125: begin
126: if blid is not null then
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
127: delete from hr_pump_batch_lines where batch_line_id = blid;
128: delete from hr_pump_batch_exceptions
129: where source_type = 'BATCH_LINE' and source_id = blid;
130: end if;
131: insert into hr_pump_batch_lines
132: (batch_id
133: ,batch_line_id
134: ,business_group_name
135: ,api_module_id
179: ,pval045
180: ,pval046)
181: values
182: (p_batch_id
183: ,nvl(blid,hr_pump_batch_lines_s.nextval)
184: ,p_data_pump_business_grp_name
185: ,1619
186: ,'U'
187: ,p_user_sequence
318: l.pval043 p43,
319: decode(l.pval044,cn,vn,l.pval044) p44,
320: decode(l.pval045,cn,vn,l.pval045) p45,
321: decode(l.pval046,cn,vn,l.pval046) p46
322: from hr_pump_batch_lines l
323: where l.batch_line_id = p_batch_line_id;
324: --
325: c cr%rowtype;
326: l_validate boolean := false;
333: open cr;
334: fetch cr into c;
335: if cr%notfound then
336: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
337: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
338: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
339: hr_utility.set_message_token('VALUE',p_batch_line_id);
340: hr_utility.raise_error;
341: end if;
422: ,P_BALANCE_AMOUNT_OVN => c.p43);
423: hr_data_pump.api_trc_off;
424:
425: --
426: update hr_pump_batch_lines l set
427: l.pval040 = decode(c.p40,null,cn,c.p40),
428: l.pval041 = decode(c.p41,null,cn,c.p41),
429: l.pval042 = decode(c.p42,null,cn,c.p42),
430: l.pval043 = decode(c.p43,null,cn,c.p43)