[Home] [Help]
169: else
170: L_NO_END_ELEMENT := 'FALSE';
171: end if;
172: if blid is not null then
173: delete from hr_pump_batch_lines where batch_line_id = blid;
174: delete from hr_pump_batch_exceptions
175: where source_type = 'BATCH_LINE' and source_id = blid;
176: end if;
177: insert into hr_pump_batch_lines
173: delete from hr_pump_batch_lines where batch_line_id = blid;
174: delete from hr_pump_batch_exceptions
175: where source_type = 'BATCH_LINE' and source_id = blid;
176: end if;
177: insert into hr_pump_batch_lines
178: (batch_id
179: ,batch_line_id
180: ,business_group_name
181: ,api_module_id
253: ,pval069
254: ,pval070)
255: values
256: (p_batch_id
257: ,nvl(blid,hr_pump_batch_lines_s.nextval)
258: ,p_data_pump_business_grp_name
259: ,703
260: ,'U'
261: ,p_user_sequence
485: decode(l.pval069,cn,vn,vn,vh,l.pval069) p69,
486: l.pval069 d69,
487: decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
488: l.pval070 d70
489: from hr_pump_batch_lines l
490: where l.batch_line_id = p_batch_line_id;
491: --
492: c cr%rowtype;
493: l_validate boolean := false;
512: open cr;
513: fetch cr into c;
514: if cr%notfound then
515: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
516: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
517: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
518: hr_utility.set_message_token('VALUE',p_batch_line_id);
519: hr_utility.raise_error;
520: end if;
527: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
528: hr_utility.set_message_token('TYPE','BOOLEAN');
529: hr_utility.set_message_token('PARAMETER','P_NO_END_ELEMENT');
530: hr_utility.set_message_token('VALUE',c.p55);
531: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
532: hr_utility.raise_error;
533: end if;
534: --
535: if c.p57 is null then