[Home] [Help]
182: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
183: blid number := p_data_pump_batch_line_id;
184: begin
185: if blid is not null then
186: delete from hr_pump_batch_lines where batch_line_id = blid;
187: delete from hr_pump_batch_exceptions
188: where source_type = 'BATCH_LINE' and source_id = blid;
189: end if;
190: insert into hr_pump_batch_lines
186: delete from hr_pump_batch_lines where batch_line_id = blid;
187: delete from hr_pump_batch_exceptions
188: where source_type = 'BATCH_LINE' and source_id = blid;
189: end if;
190: insert into hr_pump_batch_lines
191: (batch_id
192: ,batch_line_id
193: ,business_group_name
194: ,api_module_id
297: ,pval111
298: ,pval112)
299: values
300: (p_batch_id
301: ,nvl(blid,hr_pump_batch_lines_s.nextval)
302: ,p_data_pump_business_grp_name
303: ,1374
304: ,'U'
305: ,p_user_sequence
629: decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
630: l.pval111 d111,
631: decode(l.pval112,cn,vn,vn,vn,l.pval112) p112,
632: l.pval112 d112
633: from hr_pump_batch_lines l
634: where l.batch_line_id = p_batch_line_id;
635: --
636: c cr%rowtype;
637: l_validate boolean := false;
658: open cr;
659: fetch cr into c;
660: if cr%notfound then
661: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
662: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
663: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
664: hr_utility.set_message_token('VALUE',p_batch_line_id);
665: hr_utility.raise_error;
666: end if;
930: else
931: c.p95 := 'FALSE';
932: end if;
933: --
934: update hr_pump_batch_lines l set
935: l.pval002 = decode(c.p2,null,cn,c.p2),
936: l.pval086 = decode(c.p86,null,cn,c.p86),
937: l.pval087 = decode(c.p87,null,cn,c.p87),
938: l.pval088 = decode(c.p88,null,cn,c.p88),