429: hr_data_pump.entry('call');
430: open cr;
431: fetch cr into c;
432: if cr%notfound then
433: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
434: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
435: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
436: hr_utility.set_message_token('VALUE',p_batch_line_id);
437: hr_utility.raise_error;
430: open cr;
431: fetch cr into c;
432: if cr%notfound then
433: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
434: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
435: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
436: hr_utility.set_message_token('VALUE',p_batch_line_id);
437: hr_utility.raise_error;
438: end if;
431: fetch cr into c;
432: if cr%notfound then
433: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
434: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
435: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
436: hr_utility.set_message_token('VALUE',p_batch_line_id);
437: hr_utility.raise_error;
438: end if;
439: --
432: if cr%notfound then
433: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
434: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
435: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
436: hr_utility.set_message_token('VALUE',p_batch_line_id);
437: hr_utility.raise_error;
438: end if;
439: --
440: L_COMMENTS := c.plongval;
433: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
434: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
435: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
436: hr_utility.set_message_token('VALUE',p_batch_line_id);
437: hr_utility.raise_error;
438: end if;
439: --
440: L_COMMENTS := c.plongval;
441: if L_COMMENTS = cn then