255: hr_data_pump.entry('call');
256: open cr;
257: fetch cr into c;
258: if cr%notfound then
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
256: open cr;
257: fetch cr into c;
258: if cr%notfound then
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
264: end if;
257: fetch cr into c;
258: if cr%notfound then
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
264: end if;
265: --
258: if cr%notfound then
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
264: end if;
265: --
266: L_RATING_SCALE_ID :=
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
264: end if;
265: --
266: L_RATING_SCALE_ID :=
267: PER_COMPETENCE_DATA_PUMP.GET_RSC_OLD_ID