353: hr_data_pump.entry('call');
354: open cr;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
354: open cr;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
363: --
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
363: --
364: if upper(c.p43) = 'TRUE' then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;
363: --
364: if upper(c.p43) = 'TRUE' then
365: L_MULTI_ROW_ACTN := true;
365: L_MULTI_ROW_ACTN := true;
366: elsif upper(c.p43) = 'FALSE' then
367: L_MULTI_ROW_ACTN := false;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
366: elsif upper(c.p43) = 'FALSE' then
367: L_MULTI_ROW_ACTN := false;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
367: L_MULTI_ROW_ACTN := false;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
368: elsif c.p43 is not null then
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --
369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --
377: if c.p44 is null then
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --
377: if c.p44 is null then
378: L_PRTT_ENRT_RSLT_ID:=nn;