288: hr_data_pump.entry('call');
289: open cr;
290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
289: open cr;
290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
290: fetch cr into c;
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
298: --
291: if cr%notfound then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
298: --
299: if upper(c.p11) = 'TRUE' then
292: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
293: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
294: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
295: hr_utility.set_message_token('VALUE',p_batch_line_id);
296: hr_utility.raise_error;
297: end if;
298: --
299: if upper(c.p11) = 'TRUE' then
300: L_MULTI_ROW_ACTN := true;
300: L_MULTI_ROW_ACTN := true;
301: elsif upper(c.p11) = 'FALSE' then
302: L_MULTI_ROW_ACTN := false;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
301: elsif upper(c.p11) = 'FALSE' then
302: L_MULTI_ROW_ACTN := false;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
302: L_MULTI_ROW_ACTN := false;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
303: elsif c.p11 is not null then
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --
304: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --
312: L_PERSON_ID :=
305: hr_utility.set_message_token('TYPE','BOOLEAN');
306: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
307: hr_utility.set_message_token('VALUE',c.p11);
308: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
309: hr_utility.raise_error;
310: end if;
311: --
312: L_PERSON_ID :=
313: BEN_PUMP_GET.GET_PEN_PERSON_ID