389: hr_data_pump.entry('call');
390: open cr;
391: fetch cr into c;
392: if cr%notfound then
393: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
394: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
395: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
396: hr_utility.set_message_token('VALUE',p_batch_line_id);
397: hr_utility.raise_error;
390: open cr;
391: fetch cr into c;
392: if cr%notfound then
393: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
394: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
395: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
396: hr_utility.set_message_token('VALUE',p_batch_line_id);
397: hr_utility.raise_error;
398: end if;
391: fetch cr into c;
392: if cr%notfound then
393: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
394: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
395: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
396: hr_utility.set_message_token('VALUE',p_batch_line_id);
397: hr_utility.raise_error;
398: end if;
399: --
392: if cr%notfound then
393: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
394: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
395: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
396: hr_utility.set_message_token('VALUE',p_batch_line_id);
397: hr_utility.raise_error;
398: end if;
399: --
400: if upper(c.p43) = 'TRUE' then
393: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
394: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
395: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
396: hr_utility.set_message_token('VALUE',p_batch_line_id);
397: hr_utility.raise_error;
398: end if;
399: --
400: if upper(c.p43) = 'TRUE' then
401: L_MULTI_ROW_ACTN := true;
401: L_MULTI_ROW_ACTN := true;
402: elsif upper(c.p43) = 'FALSE' then
403: L_MULTI_ROW_ACTN := false;
404: elsif c.p43 is not null then
405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
402: elsif upper(c.p43) = 'FALSE' then
403: L_MULTI_ROW_ACTN := false;
404: elsif c.p43 is not null then
405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
403: L_MULTI_ROW_ACTN := false;
404: elsif c.p43 is not null then
405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
404: elsif c.p43 is not null then
405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
412: --
405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
412: --
413: if c.p44 is null then
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
412: --
413: if c.p44 is null then
414: L_PL_BNF_ID:=nn;