361: hr_data_pump.entry('call');
362: open cr;
363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
362: open cr;
363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
371: --
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
371: --
372: if upper(c.p42) = 'TRUE' then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;
371: --
372: if upper(c.p42) = 'TRUE' then
373: L_MULTI_ROW_ACTN := true;
373: L_MULTI_ROW_ACTN := true;
374: elsif upper(c.p42) = 'FALSE' then
375: L_MULTI_ROW_ACTN := false;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: elsif upper(c.p42) = 'FALSE' then
375: L_MULTI_ROW_ACTN := false;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
375: L_MULTI_ROW_ACTN := false;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
376: elsif c.p42 is not null then
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --
377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --
385: if c.p43 is null then
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --
385: if c.p43 is null then
386: L_ELIG_CVRD_DPNT_ID:=nn;