[Home] [Help]
117: else
118: L_MULTI_ROW_ACTN := 'FALSE';
119: end if;
120: if blid is not null then
121: delete from hr_pump_batch_lines where batch_line_id = blid;
122: delete from hr_pump_batch_exceptions
123: where source_type = 'BATCH_LINE' and source_id = blid;
124: end if;
125: insert into hr_pump_batch_lines
121: delete from hr_pump_batch_lines where batch_line_id = blid;
122: delete from hr_pump_batch_exceptions
123: where source_type = 'BATCH_LINE' and source_id = blid;
124: end if;
125: insert into hr_pump_batch_lines
126: (batch_id
127: ,batch_line_id
128: ,business_group_name
129: ,api_module_id
154: ,pval022
155: ,pval023)
156: values
157: (p_batch_id
158: ,nvl(blid,hr_pump_batch_lines_s.nextval)
159: ,p_data_pump_business_grp_name
160: ,3846
161: ,'U'
162: ,p_user_sequence
222: decode(l.pval020,cn,vn,l.pval020) p20,
223: decode(l.pval021,cn,vn,l.pval021) p21,
224: decode(l.pval022,cn,dn,d(l.pval022)) p22,
225: decode(l.pval023,cn,nn,n(l.pval023)) p23
226: from hr_pump_batch_lines l
227: where l.batch_line_id = p_batch_line_id;
228: --
229: c cr%rowtype;
230: l_validate boolean := false;
241: open cr;
242: fetch cr into c;
243: if cr%notfound then
244: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
245: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
246: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
247: hr_utility.set_message_token('VALUE',p_batch_line_id);
248: hr_utility.raise_error;
249: end if;
256: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
257: hr_utility.set_message_token('TYPE','BOOLEAN');
258: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
259: hr_utility.set_message_token('VALUE',c.p5);
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.raise_error;
262: end if;
263: --
264: L_PERSON_ID :=