380: hr_data_pump.entry('call');
381: open cr;
382: fetch cr into c;
383: if cr%notfound then
384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
381: open cr;
382: fetch cr into c;
383: if cr%notfound then
384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
389: end if;
382: fetch cr into c;
383: if cr%notfound then
384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
389: end if;
390: --
383: if cr%notfound then
384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
389: end if;
390: --
391: if upper(c.p44) = 'TRUE' then
384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
389: end if;
390: --
391: if upper(c.p44) = 'TRUE' then
392: L_MULTI_ROW_ACTN := true;
392: L_MULTI_ROW_ACTN := true;
393: elsif upper(c.p44) = 'FALSE' then
394: L_MULTI_ROW_ACTN := false;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
393: elsif upper(c.p44) = 'FALSE' then
394: L_MULTI_ROW_ACTN := false;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
394: L_MULTI_ROW_ACTN := false;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
395: elsif c.p44 is not null then
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --
396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --
404: if c.p45 is null then
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --
404: if c.p45 is null then
405: L_PRTT_ENRT_RSLT_ID:=nn;