153: hr_data_pump.entry('call');
154: open cr;
155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
154: open cr;
155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
163: --
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
163: --
164: if upper(c.p5) = 'TRUE' then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
163: --
164: if upper(c.p5) = 'TRUE' then
165: L_MULTI_ROW_ACTN := true;
165: L_MULTI_ROW_ACTN := true;
166: elsif upper(c.p5) = 'FALSE' then
167: L_MULTI_ROW_ACTN := false;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
166: elsif upper(c.p5) = 'FALSE' then
167: L_MULTI_ROW_ACTN := false;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
167: L_MULTI_ROW_ACTN := false;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --
177: if c.p7 is null then
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --
177: if c.p7 is null then
178: L_ELIG_CVRD_DPNT_ID:=nn;