[Home] [Help]
121: ,P_PAYROLL_RUN_USER_KEY in varchar2) is
122: blid number := p_data_pump_batch_line_id;
123: begin
124: if blid is not null then
125: delete from hr_pump_batch_lines where batch_line_id = blid;
126: delete from hr_pump_batch_exceptions
127: where source_type = 'BATCH_LINE' and source_id = blid;
128: end if;
129: insert into hr_pump_batch_lines
125: delete from hr_pump_batch_lines where batch_line_id = blid;
126: delete from hr_pump_batch_exceptions
127: where source_type = 'BATCH_LINE' and source_id = blid;
128: end if;
129: insert into hr_pump_batch_lines
130: (batch_id
131: ,batch_line_id
132: ,business_group_name
133: ,api_module_id
175: ,pval043
176: ,pval044)
177: values
178: (p_batch_id
179: ,nvl(blid,hr_pump_batch_lines_s.nextval)
180: ,p_data_pump_business_grp_name
181: ,1622
182: ,'U'
183: ,p_user_sequence
308: l.pval041 p41,
309: decode(l.pval042,cn,vn,l.pval042) p42,
310: decode(l.pval043,cn,vn,l.pval043) p43,
311: decode(l.pval044,cn,vn,l.pval044) p44
312: from hr_pump_batch_lines l
313: where l.batch_line_id = p_batch_line_id;
314: --
315: c cr%rowtype;
316: l_validate boolean := false;
323: open cr;
324: fetch cr into c;
325: if cr%notfound then
326: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
327: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
328: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
329: hr_utility.set_message_token('VALUE',p_batch_line_id);
330: hr_utility.raise_error;
331: end if;
412: ,P_PROCESSED_ASSIGNMENT_OVN => c.p41);
413: hr_data_pump.api_trc_off;
414:
415: --
416: update hr_pump_batch_lines l set
417: l.pval038 = decode(c.p38,null,cn,c.p38),
418: l.pval039 = decode(c.p39,null,cn,c.p39),
419: l.pval040 = decode(c.p40,null,cn,c.p40),
420: l.pval041 = decode(c.p41,null,cn,c.p41)