[Home] [Help]
142: else
143: L_VALIDATE_COUNTY := 'FALSE';
144: end if;
145: if blid is not null then
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
146: delete from hr_pump_batch_lines where batch_line_id = blid;
147: delete from hr_pump_batch_exceptions
148: where source_type = 'BATCH_LINE' and source_id = blid;
149: end if;
150: insert into hr_pump_batch_lines
151: (batch_id
152: ,batch_line_id
153: ,business_group_name
154: ,api_module_id
206: ,pval049
207: ,pval050)
208: values
209: (p_batch_id
210: ,nvl(blid,hr_pump_batch_lines_s.nextval)
211: ,p_data_pump_business_grp_name
212: ,1185
213: ,'U'
214: ,p_user_sequence
367: l.pval048 d48,
368: decode(l.pval049,cn,vn,l.pval049) p49,
369: decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
370: l.pval050 d50
371: from hr_pump_batch_lines l
372: where l.batch_line_id = p_batch_line_id;
373: --
374: c cr%rowtype;
375: l_validate boolean := false;
384: open cr;
385: fetch cr into c;
386: if cr%notfound then
387: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
388: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
389: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
390: hr_utility.set_message_token('VALUE',p_batch_line_id);
391: hr_utility.raise_error;
392: end if;
399: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
400: hr_utility.set_message_token('TYPE','BOOLEAN');
401: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
402: hr_utility.set_message_token('VALUE',c.p2);
403: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
404: hr_utility.raise_error;
405: end if;
406: --
407: L_COMMENTS := c.plongval;