979: hr_data_pump.entry('call');
980: open cr;
981: fetch cr into c;
982: if cr%notfound then
983: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
984: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
985: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
986: hr_utility.set_message_token('VALUE',p_batch_line_id);
987: hr_utility.raise_error;
980: open cr;
981: fetch cr into c;
982: if cr%notfound then
983: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
984: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
985: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
986: hr_utility.set_message_token('VALUE',p_batch_line_id);
987: hr_utility.raise_error;
988: end if;
981: fetch cr into c;
982: if cr%notfound then
983: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
984: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
985: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
986: hr_utility.set_message_token('VALUE',p_batch_line_id);
987: hr_utility.raise_error;
988: end if;
989: --
982: if cr%notfound then
983: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
984: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
985: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
986: hr_utility.set_message_token('VALUE',p_batch_line_id);
987: hr_utility.raise_error;
988: end if;
989: --
990: if c.p157 is null then
983: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
984: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
985: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
986: hr_utility.set_message_token('VALUE',p_batch_line_id);
987: hr_utility.raise_error;
988: end if;
989: --
990: if c.p157 is null then
991: L_PERSON_ID:=nn;