[Home] [Help]
181: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
182: blid number := p_data_pump_batch_line_id;
183: begin
184: if blid is not null then
185: delete from hr_pump_batch_lines where batch_line_id = blid;
186: delete from hr_pump_batch_exceptions
187: where source_type = 'BATCH_LINE' and source_id = blid;
188: end if;
189: insert into hr_pump_batch_lines
185: delete from hr_pump_batch_lines where batch_line_id = blid;
186: delete from hr_pump_batch_exceptions
187: where source_type = 'BATCH_LINE' and source_id = blid;
188: end if;
189: insert into hr_pump_batch_lines
190: (batch_id
191: ,batch_line_id
192: ,business_group_name
193: ,api_module_id
295: ,pval109
296: ,pval110)
297: values
298: (p_batch_id
299: ,nvl(blid,hr_pump_batch_lines_s.nextval)
300: ,p_data_pump_business_grp_name
301: ,3215
302: ,'U'
303: ,p_user_sequence
618: decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
619: l.pval109 d109,
620: decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
621: l.pval110 d110
622: from hr_pump_batch_lines l
623: where l.batch_line_id = p_batch_line_id;
624: --
625: c cr%rowtype;
626: l_validate boolean := false;
650: open cr;
651: fetch cr into c;
652: if cr%notfound then
653: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
654: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
655: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
656: hr_utility.set_message_token('VALUE',p_batch_line_id);
657: hr_utility.raise_error;
658: end if;
946: else
947: c.p91 := 'FALSE';
948: end if;
949: --
950: update hr_pump_batch_lines l set
951: l.pval002 = decode(c.p2,null,cn,c.p2),
952: l.pval082 = decode(c.p82,null,cn,c.p82),
953: l.pval083 = decode(c.p83,null,cn,c.p83),
954: l.pval084 = decode(c.p84,null,cn,dc(c.p84)),