186: hr_data_pump.entry('call');
187: open cr;
188: fetch cr into c;
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
187: open cr;
188: fetch cr into c;
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
188: fetch cr into c;
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
196: --
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
196: --
197: if upper(c.p5) = 'TRUE' then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
196: --
197: if upper(c.p5) = 'TRUE' then
198: L_DISABLE_RANGE_OVERLAP_CHECK := true;
198: L_DISABLE_RANGE_OVERLAP_CHECK := true;
199: elsif upper(c.p5) = 'FALSE' then
200: L_DISABLE_RANGE_OVERLAP_CHECK := false;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
199: elsif upper(c.p5) = 'FALSE' then
200: L_DISABLE_RANGE_OVERLAP_CHECK := false;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
200: L_DISABLE_RANGE_OVERLAP_CHECK := false;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
209: --
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
209: --
210: if upper(c.p6) = 'TRUE' then
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
209: --
210: if upper(c.p6) = 'TRUE' then
211: L_DISABLE_UNITS_CHECK := true;
211: L_DISABLE_UNITS_CHECK := true;
212: elsif upper(c.p6) = 'FALSE' then
213: L_DISABLE_UNITS_CHECK := false;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
212: elsif upper(c.p6) = 'FALSE' then
213: L_DISABLE_UNITS_CHECK := false;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
213: L_DISABLE_UNITS_CHECK := false;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
222: --
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
222: --
223: if c.p13 is null then
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
222: --
223: if c.p13 is null then
224: L_USER_TABLE_ID:=nn;