[Home] [Help]
171: ,P_ASSIGNMENT_USER_KEY in varchar2) is
172: blid number := p_data_pump_batch_line_id;
173: begin
174: if blid is not null then
175: delete from hr_pump_batch_lines where batch_line_id = blid;
176: delete from hr_pump_batch_exceptions
177: where source_type = 'BATCH_LINE' and source_id = blid;
178: end if;
179: insert into hr_pump_batch_lines
175: delete from hr_pump_batch_lines where batch_line_id = blid;
176: delete from hr_pump_batch_exceptions
177: where source_type = 'BATCH_LINE' and source_id = blid;
178: end if;
179: insert into hr_pump_batch_lines
180: (batch_id
181: ,batch_line_id
182: ,business_group_name
183: ,api_module_id
275: ,pval091
276: ,pval092)
277: values
278: (p_batch_id
279: ,nvl(blid,hr_pump_batch_lines_s.nextval)
280: ,p_data_pump_business_grp_name
281: ,1324
282: ,'U'
283: ,p_user_sequence
537: l.pval090 d90,
538: decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
539: l.pval091 d91,
540: decode(l.pval092,cn,vn,l.pval092) p92
541: from hr_pump_batch_lines l
542: where l.batch_line_id = p_batch_line_id;
543: --
544: c cr%rowtype;
545: l_validate boolean := false;
552: open cr;
553: fetch cr into c;
554: if cr%notfound then
555: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
556: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
557: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
558: hr_utility.set_message_token('VALUE',p_batch_line_id);
559: hr_utility.raise_error;
560: end if;
676: else
677: c.p70 := 'FALSE';
678: end if;
679: --
680: update hr_pump_batch_lines l set
681: l.pval007 = decode(c.p7,null,cn,c.p7),
682: l.pval008 = decode(c.p8,null,cn,c.p8),
683: l.pval013 = decode(c.p13,null,cn,c.p13),
684: l.pval014 = decode(c.p14,null,cn,c.p14),