[Home] [Help]
106: else
107: L_DISABLE_UNITS_CHECK := 'FALSE';
108: end if;
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
129: ,pval008
130: ,pval012)
131: values
132: (p_batch_id
133: ,nvl(blid,hr_pump_batch_lines_s.nextval)
134: ,p_data_pump_business_grp_name
135: ,3037
136: ,'U'
137: ,p_user_sequence
167: l.pval009 p9,
168: decode(l.pval010,cn,dn,d(l.pval010)) p10,
169: decode(l.pval011,cn,dn,d(l.pval011)) p11,
170: decode(l.pval012,cn,vn,l.pval012) p12
171: from hr_pump_batch_lines l
172: where l.batch_line_id = p_batch_line_id;
173: --
174: c cr%rowtype;
175: l_validate boolean := false;
183: open cr;
184: fetch cr into c;
185: if cr%notfound then
186: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
187: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
188: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
189: hr_utility.set_message_token('VALUE',p_batch_line_id);
190: hr_utility.raise_error;
191: end if;
198: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
199: hr_utility.set_message_token('TYPE','BOOLEAN');
200: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
201: hr_utility.set_message_token('VALUE',c.p5);
202: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
203: hr_utility.raise_error;
204: end if;
205: --
206: if upper(c.p6) = 'TRUE' then
211: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
212: hr_utility.set_message_token('TYPE','BOOLEAN');
213: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
214: hr_utility.set_message_token('VALUE',c.p6);
215: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
216: hr_utility.raise_error;
217: end if;
218: --
219: if c.p12 is null then
243: hr_data_pump.api_trc_off;
244: --
245: iuk(p_batch_line_id,c.p8,L_USER_ROW_ID);
246: --
247: update hr_pump_batch_lines l set
248: l.pval003 = decode(c.p3,null,cn,c.p3),
249: l.pval008 = decode(c.p8,null,cn,c.p8),
250: l.pval009 = decode(c.p9,null,cn,c.p9),
251: l.pval010 = decode(c.p10,null,cn,dc(c.p10)),