87: ,P_PERSON_USER_KEY in varchar2) is
88: blid number := p_data_pump_batch_line_id;
89: begin
90: if blid is not null then
91: delete from hr_pump_batch_lines where batch_line_id = blid;
92: delete from hr_pump_batch_exceptions
93: where source_type = 'BATCH_LINE' and source_id = blid;
94: end if;
95: insert into hr_pump_batch_lines
91: delete from hr_pump_batch_lines where batch_line_id = blid;
92: delete from hr_pump_batch_exceptions
93: where source_type = 'BATCH_LINE' and source_id = blid;
94: end if;
95: insert into hr_pump_batch_lines
96: (batch_id
97: ,batch_line_id
98: ,business_group_name
99: ,api_module_id
115: ,pval013
116: ,pval014)
117: values
118: (p_batch_id
119: ,nvl(blid,hr_pump_batch_lines_s.nextval)
120: ,p_data_pump_business_grp_name
121: ,1595
122: ,'U'
123: ,p_user_sequence
169: hr_pump_get.gl(l.pval012,'HR_EMP_EXTRACT_RUN_TYPE',dn,vn)) p12,
170: l.pval012 d12,
171: decode(l.pval013,cn,dn,d(l.pval013)) p13,
172: decode(l.pval014,cn,vn,l.pval014) p14
173: from hr_pump_batch_lines l
174: where l.batch_line_id = p_batch_line_id;
175: --
176: c cr%rowtype;
177: l_validate boolean := false;
182: open cr;
183: fetch cr into c;
184: if cr%notfound then
185: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
186: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
187: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
188: hr_utility.set_message_token('VALUE',p_batch_line_id);
189: hr_utility.raise_error;
190: end if;