DBA Data[Home] [Help]

APPS.BEN_PBB_LER dependencies on BENUTILS

Line 136: benutils.set_data_migrator_mode;

132: --
133: --
134: begin
135: -- Bug 3320133
136: benutils.set_data_migrator_mode;
137: if hr_general.g_data_migrator_mode in ( 'Y','P') then
138: --
139: return;
140: --

Line 252: benutils.exec_rule(

248: l_col_old_val := to_char(p_old.BNFTS_BAL_ID);
249: l_col_new_val := to_char(p_new.BNFTS_BAL_ID);
250: end if;
251: --
252: benutils.exec_rule(
253: p_formula_id => l_per_info_chg_cs_ler_rl,
254: p_effective_date => l_session_date,
255: p_lf_evt_ocrd_dt => null,
256: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 291: l_changed := (benutils.column_changed(p_old.effective_start_date

287: --
288:
289: --
290: if l_column = 'EFFECTIVE_START_DATE' then
291: l_changed := (benutils.column_changed(p_old.effective_start_date
292: ,p_new.effective_start_date,l_new_val) AND
293: benutils.column_changed(p_new.effective_start_date
294: ,p_old.effective_start_date,l_old_val) AND
295: (l_changed));

Line 293: benutils.column_changed(p_new.effective_start_date

289: --
290: if l_column = 'EFFECTIVE_START_DATE' then
291: l_changed := (benutils.column_changed(p_old.effective_start_date
292: ,p_new.effective_start_date,l_new_val) AND
293: benutils.column_changed(p_new.effective_start_date
294: ,p_old.effective_start_date,l_old_val) AND
295: (l_changed));
296: hr_utility.set_location(' l_changed:',30);
297: end if;

Line 305: l_changed := (benutils.column_changed(p_old.effective_end_date

301: hr_utility.set_location('Old eed'||p_old.effective_end_date, 20);
302: if p_new.effective_end_date = hr_api.g_eot then
303: l_changed := FALSE;
304: end if;
305: l_changed := (benutils.column_changed(p_old.effective_end_date
306: ,p_new.effective_end_date,l_new_val) AND
307: benutils.column_changed(p_new.effective_end_date
308: ,p_old.effective_end_date,l_old_val) AND
309: (l_changed));

Line 307: benutils.column_changed(p_new.effective_end_date

303: l_changed := FALSE;
304: end if;
305: l_changed := (benutils.column_changed(p_old.effective_end_date
306: ,p_new.effective_end_date,l_new_val) AND
307: benutils.column_changed(p_new.effective_end_date
308: ,p_old.effective_end_date,l_old_val) AND
309: (l_changed));
310: hr_utility.set_location(' l_changed:',40);
311: --

Line 330: l_changed := (benutils.column_changed(p_old.val

326: --
327: if l_column = 'VAL' then
328: hr_utility.set_location('Old val '||p_old.val, 20);
329: hr_utility.set_location('New val '||p_new.val, 20);
330: l_changed := (benutils.column_changed(p_old.val
331: ,p_new.val,l_new_val) AND
332: benutils.column_changed(p_new.val
333: ,p_old.val,l_old_val) AND
334: (l_changed));

Line 332: benutils.column_changed(p_new.val

328: hr_utility.set_location('Old val '||p_old.val, 20);
329: hr_utility.set_location('New val '||p_new.val, 20);
330: l_changed := (benutils.column_changed(p_old.val
331: ,p_new.val,l_new_val) AND
332: benutils.column_changed(p_new.val
333: ,p_old.val,l_old_val) AND
334: (l_changed));
335: end if;
336: hr_utility.set_location(' ben_pbb_trigger', 50);

Line 342: l_changed := (benutils.column_changed(p_old.bnfts_bal_id

338: if l_column = 'BNFTS_BAL_ID' then
339: hr_utility.set_location('Old balid '||p_old.bnfts_bal_id, 20);
340: hr_utility.set_location('New balid '||p_new.bnfts_bal_id, 20);
341: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
342: l_changed := (benutils.column_changed(p_old.bnfts_bal_id
343: ,p_new.bnfts_bal_id,l_new_val) AND
344: benutils.column_changed(p_new.bnfts_bal_id
345: ,p_old.bnfts_bal_id,l_old_val) AND
346: (l_changed));

Line 344: benutils.column_changed(p_new.bnfts_bal_id

340: hr_utility.set_location('New balid '||p_new.bnfts_bal_id, 20);
341: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
342: l_changed := (benutils.column_changed(p_old.bnfts_bal_id
343: ,p_new.bnfts_bal_id,l_new_val) AND
344: benutils.column_changed(p_new.bnfts_bal_id
345: ,p_old.bnfts_bal_id,l_old_val) AND
346: (l_changed));
347: end if;
348: hr_utility.set_location(' ben_pbb_trigger', 60);