367: hr_data_pump.entry('call');
368: open cr;
369: fetch cr into c;
370: if cr%notfound then
371: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
372: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
373: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
374: hr_utility.set_message_token('VALUE',p_batch_line_id);
375: hr_utility.raise_error;
368: open cr;
369: fetch cr into c;
370: if cr%notfound then
371: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
372: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
373: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
374: hr_utility.set_message_token('VALUE',p_batch_line_id);
375: hr_utility.raise_error;
376: end if;
369: fetch cr into c;
370: if cr%notfound then
371: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
372: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
373: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
374: hr_utility.set_message_token('VALUE',p_batch_line_id);
375: hr_utility.raise_error;
376: end if;
377: --
370: if cr%notfound then
371: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
372: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
373: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
374: hr_utility.set_message_token('VALUE',p_batch_line_id);
375: hr_utility.raise_error;
376: end if;
377: --
378: L_COMPETENCE_ID :=
371: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
372: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
373: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
374: hr_utility.set_message_token('VALUE',p_batch_line_id);
375: hr_utility.raise_error;
376: end if;
377: --
378: L_COMPETENCE_ID :=
379: hr_pump_get.GET_COMPETENCE_ID