364: hr_data_pump.entry('call');
365: open cr;
366: fetch cr into c;
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
365: open cr;
366: fetch cr into c;
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
366: fetch cr into c;
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
374: --
367: if cr%notfound then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
374: --
375: if upper(c.p2) = 'TRUE' then
368: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
369: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
370: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
371: hr_utility.set_message_token('VALUE',p_batch_line_id);
372: hr_utility.raise_error;
373: end if;
374: --
375: if upper(c.p2) = 'TRUE' then
376: L_PRADD_OVLAPVAL_OVERRIDE := true;
376: L_PRADD_OVLAPVAL_OVERRIDE := true;
377: elsif upper(c.p2) = 'FALSE' then
378: L_PRADD_OVLAPVAL_OVERRIDE := false;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
377: elsif upper(c.p2) = 'FALSE' then
378: L_PRADD_OVLAPVAL_OVERRIDE := false;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
378: L_PRADD_OVLAPVAL_OVERRIDE := false;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
379: elsif c.p2 is not null then
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
387: --
380: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
387: --
388: L_COMMENTS := c.plongval;
381: hr_utility.set_message_token('TYPE','BOOLEAN');
382: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
383: hr_utility.set_message_token('VALUE',c.p2);
384: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
385: hr_utility.raise_error;
386: end if;
387: --
388: L_COMMENTS := c.plongval;
389: if L_COMMENTS = cn then