[Home] [Help]
137: else
138: L_VALIDATE_COUNTY := 'FALSE';
139: end if;
140: if blid is not null then
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
146: (batch_id
147: ,batch_line_id
148: ,business_group_name
149: ,api_module_id
196: ,pval044
197: ,pval045)
198: values
199: (p_batch_id
200: ,nvl(blid,hr_pump_batch_lines_s.nextval)
201: ,p_data_pump_business_grp_name
202: ,2907
203: ,'U'
204: ,p_user_sequence
343: l.pval043 d43,
344: decode(l.pval044,cn,vn,l.pval044) p44,
345: decode(l.pval045,cn,vn,vn,vh,l.pval045) p45,
346: l.pval045 d45
347: from hr_pump_batch_lines l
348: where l.batch_line_id = p_batch_line_id;
349: --
350: c cr%rowtype;
351: l_validate boolean := false;
360: open cr;
361: fetch cr into c;
362: if cr%notfound then
363: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
364: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
365: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
366: hr_utility.set_message_token('VALUE',p_batch_line_id);
367: hr_utility.raise_error;
368: end if;
375: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
376: hr_utility.set_message_token('TYPE','BOOLEAN');
377: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
378: hr_utility.set_message_token('VALUE',c.p2);
379: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
380: hr_utility.raise_error;
381: end if;
382: --
383: L_COMMENTS := c.plongval;