[Home] [Help]
106: ,P_PERSON_USER_KEY in varchar2) is
107: blid number := p_data_pump_batch_line_id;
108: begin
109: if blid is not null then
110: delete from hr_pump_batch_lines where batch_line_id = blid;
111: delete from hr_pump_batch_exceptions
112: where source_type = 'BATCH_LINE' and source_id = blid;
113: end if;
114: insert into hr_pump_batch_lines
110: delete from hr_pump_batch_lines where batch_line_id = blid;
111: delete from hr_pump_batch_exceptions
112: where source_type = 'BATCH_LINE' and source_id = blid;
113: end if;
114: insert into hr_pump_batch_lines
115: (batch_id
116: ,batch_line_id
117: ,business_group_name
118: ,api_module_id
134: ,pval013
135: ,pval014)
136: values
137: (p_batch_id
138: ,nvl(blid,hr_pump_batch_lines_s.nextval)
139: ,p_data_pump_business_grp_name
140: ,1595
141: ,'U'
142: ,p_user_sequence
188: hr_pump_get.gl(l.pval012,'HR_EMP_EXTRACT_RUN_TYPE',dn,vn)) p12,
189: l.pval012 d12,
190: decode(l.pval013,cn,dn,d(l.pval013)) p13,
191: decode(l.pval014,cn,vn,l.pval014) p14
192: from hr_pump_batch_lines l
193: where l.batch_line_id = p_batch_line_id;
194: --
195: c cr%rowtype;
196: l_validate boolean := false;
201: open cr;
202: fetch cr into c;
203: if cr%notfound then
204: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
205: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
206: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
207: hr_utility.set_message_token('VALUE',p_batch_line_id);
208: hr_utility.raise_error;
209: end if;