301: hr_data_pump.entry('call');
302: open cr;
303: fetch cr into c;
304: if cr%notfound then
305: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
306: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
307: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
308: hr_utility.set_message_token('VALUE',p_batch_line_id);
309: hr_utility.raise_error;
302: open cr;
303: fetch cr into c;
304: if cr%notfound then
305: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
306: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
307: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
308: hr_utility.set_message_token('VALUE',p_batch_line_id);
309: hr_utility.raise_error;
310: end if;
303: fetch cr into c;
304: if cr%notfound then
305: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
306: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
307: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
308: hr_utility.set_message_token('VALUE',p_batch_line_id);
309: hr_utility.raise_error;
310: end if;
311: --
304: if cr%notfound then
305: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
306: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
307: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
308: hr_utility.set_message_token('VALUE',p_batch_line_id);
309: hr_utility.raise_error;
310: end if;
311: --
312: if c.p37 is null then
305: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
306: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
307: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
308: hr_utility.set_message_token('VALUE',p_batch_line_id);
309: hr_utility.raise_error;
310: end if;
311: --
312: if c.p37 is null then
313: L_ASSIGNMENT_ID:=nn;