219: hr_data_pump.entry('call');
220: open cr;
221: fetch cr into c;
222: if cr%notfound then
223: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
224: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
225: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
226: hr_utility.set_message_token('VALUE',p_batch_line_id);
227: hr_utility.raise_error;
220: open cr;
221: fetch cr into c;
222: if cr%notfound then
223: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
224: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
225: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
226: hr_utility.set_message_token('VALUE',p_batch_line_id);
227: hr_utility.raise_error;
228: end if;
221: fetch cr into c;
222: if cr%notfound then
223: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
224: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
225: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
226: hr_utility.set_message_token('VALUE',p_batch_line_id);
227: hr_utility.raise_error;
228: end if;
229: --
222: if cr%notfound then
223: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
224: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
225: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
226: hr_utility.set_message_token('VALUE',p_batch_line_id);
227: hr_utility.raise_error;
228: end if;
229: --
230: if c.p15 is null then
223: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
224: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
225: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
226: hr_utility.set_message_token('VALUE',p_batch_line_id);
227: hr_utility.raise_error;
228: end if;
229: --
230: if c.p15 is null then
231: L_CSD_BY_PTNL_LER_FOR_PER_ID:=nn;