511: hr_data_pump.entry('call');
512: open cr;
513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
512: open cr;
513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
521: --
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
521: --
522: if upper(c.p55) = 'TRUE' then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
521: --
522: if upper(c.p55) = 'TRUE' then
523: L_NO_END_ELEMENT := true;
523: L_NO_END_ELEMENT := true;
524: elsif upper(c.p55) = 'FALSE' then
525: L_NO_END_ELEMENT := false;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
524: elsif upper(c.p55) = 'FALSE' then
525: L_NO_END_ELEMENT := false;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
525: L_NO_END_ELEMENT := false;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
526: elsif c.p55 is not null then
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --
535: if c.p57 is null then
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --
535: if c.p57 is null then
536: L_PRTT_RT_VAL_ID:=nn;