[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
197: ,pval045
198: ,pval046)
199: values
200: (p_batch_id
201: ,nvl(blid,hr_pump_batch_lines_s.nextval)
202: ,p_data_pump_business_grp_name
203: ,1380
204: ,'U'
205: ,p_user_sequence
347: l.pval044 d44,
348: decode(l.pval045,cn,vn,l.pval045) p45,
349: decode(l.pval046,cn,vn,vn,vh,l.pval046) p46,
350: l.pval046 d46
351: from hr_pump_batch_lines l
352: where l.batch_line_id = p_batch_line_id;
353: --
354: c cr%rowtype;
355: l_validate boolean := false;
364: open cr;
365: fetch cr into c;
366: if cr%notfound then
367: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
368: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
369: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
370: hr_utility.set_message_token('VALUE',p_batch_line_id);
371: hr_utility.raise_error;
372: end if;
379: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
380: hr_utility.set_message_token('TYPE','BOOLEAN');
381: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
382: hr_utility.set_message_token('VALUE',c.p2);
383: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
384: hr_utility.raise_error;
385: end if;
386: --
387: L_COMMENTS := c.plongval;