[Home] [Help]
169: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
170: blid number := p_data_pump_batch_line_id;
171: begin
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
264: ,pval091
265: ,pval092)
266: values
267: (p_batch_id
268: ,nvl(blid,hr_pump_batch_lines_s.nextval)
269: ,p_data_pump_business_grp_name
270: ,1377
271: ,'U'
272: ,p_user_sequence
541: decode(l.pval091,cn,vn,vn,vh,l.pval091) p91,
542: l.pval091 d91,
543: decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
544: l.pval092 d92
545: from hr_pump_batch_lines l
546: where l.batch_line_id = p_batch_line_id;
547: --
548: c cr%rowtype;
549: l_validate boolean := false;
569: open cr;
570: fetch cr into c;
571: if cr%notfound then
572: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
573: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
574: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
575: hr_utility.set_message_token('VALUE',p_batch_line_id);
576: hr_utility.raise_error;
577: end if;
836: else
837: c.p76 := 'FALSE';
838: end if;
839: --
840: update hr_pump_batch_lines l set
841: l.pval066 = decode(c.p66,null,cn,c.p66),
842: l.pval067 = decode(c.p67,null,cn,c.p67),
843: l.pval068 = decode(c.p68,null,cn,c.p68),
844: l.pval069 = decode(c.p69,null,cn,c.p69),