319: hr_data_pump.entry('call');
320: open cr;
321: fetch cr into c;
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
320: open cr;
321: fetch cr into c;
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
321: fetch cr into c;
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
329: --
322: if cr%notfound then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
329: --
330: if upper(c.p2) = 'TRUE' then
323: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
324: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
325: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
326: hr_utility.set_message_token('VALUE',p_batch_line_id);
327: hr_utility.raise_error;
328: end if;
329: --
330: if upper(c.p2) = 'TRUE' then
331: L_PRADD_OVLAPVAL_OVERRIDE := true;
331: L_PRADD_OVLAPVAL_OVERRIDE := true;
332: elsif upper(c.p2) = 'FALSE' then
333: L_PRADD_OVLAPVAL_OVERRIDE := false;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
332: elsif upper(c.p2) = 'FALSE' then
333: L_PRADD_OVLAPVAL_OVERRIDE := false;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
333: L_PRADD_OVLAPVAL_OVERRIDE := false;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
334: elsif c.p2 is not null then
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
342: --
335: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
342: --
343: L_COMMENTS := c.plongval;
336: hr_utility.set_message_token('TYPE','BOOLEAN');
337: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
338: hr_utility.set_message_token('VALUE',c.p2);
339: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
340: hr_utility.raise_error;
341: end if;
342: --
343: L_COMMENTS := c.plongval;
344: if L_COMMENTS = cn then