240: hr_data_pump.entry('call');
241: open cr;
242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
241: open cr;
242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
250: --
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
250: --
251: if upper(c.p5) = 'TRUE' then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
250: --
251: if upper(c.p5) = 'TRUE' then
252: L_MULTI_ROW_ACTN := true;
252: L_MULTI_ROW_ACTN := true;
253: elsif upper(c.p5) = 'FALSE' then
254: L_MULTI_ROW_ACTN := false;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
253: elsif upper(c.p5) = 'FALSE' then
254: L_MULTI_ROW_ACTN := false;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
254: L_MULTI_ROW_ACTN := false;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
255: elsif c.p5 is not null then
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --
264: L_PERSON_ID :=
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --
264: L_PERSON_ID :=
265: BEN_PUMP_GET.GET_PEN_PERSON_ID